安装Sql Server2019、Sybase157、Mongo

安装sql server 2019

下载地址：

https://packages.microsoft.com/rhel/7/mssql-server-2019/

安装包：

mssql-server-15.0.4003.23-3.x86_64.rpm
msodbcsql17-17.4.1.1-1.x86_64.rpm
mssql-tools-17.4.1.1-1.x86_64.rpm

rpm -ivh mssql-server-15.0.4003.23-3.x86_64.rpm
rpm -ivh msodbcsql17-17.4.1.1-1.x86_64.rpm 
rpm -ivh mssql-tools-17.4.1.1-1.x86_64.rpm 

#配置
/opt/mssql/bin/mssql-conf setup

#选3，选express版本
Choose an edition of SQL Server:
  1) Evaluation (free, no production use rights, 180-day limit)
  2) Developer (free, no production use rights)
  3) Express (free)
  4) Web (PAID)
  5) Standard (PAID)
  6) Enterprise (PAID) - CPU Core utilization restricted to 20 physical/40 hyperthreaded
  7) Enterprise Core (PAID) - CPU Core utilization up to Operating System Maximum
  8) I bought a license through a retail sales channel and have a product key to enter.

echo 'export PATH=$PATH:/opt/mssql-tools/bin' > /etc/profile.d/mssql.sh 
source !$


#防火墙添加服务
firewall-cmd --permanent --add-service=mssql 
firewall-cmd --reload


#修改端口（办公网段1433端口被屏蔽）
 /opt/mssql/bin/mssql-conf set network.tcpport 11433

#重启
systemctl restart mssql-server.service

#命令行连接测试
sqlcmd -S 172.16.16.XX:11433

# 显示系统数据库
1> select name,database_id from sys.databases;
# 执行
2> go
name                                                                                                                             database_id
-------------------------------------------------------------------------------------------------------------------------------- -----------
master                                                                                                                                     1
tempdb                                                                                                                                     2
model                                                                                                                                      3
msdb                                                                                                                                       4

(4 rows affected)
# 查看软件版本
1> SELECT @@VERSION
2> go

Sybase 15.7安装

#离线安装导入镜像
docker load -i sybase157.tar

#创建容器，等30秒
docker run -d -t -p 5000:5000 -e "SYBASE_USER=guest" -h dksybase --name sybase157 chernov/sybase:latest

#安装 pubs2 test database
docker exec -t sybase157 /bin/bash /sybase/isql -i"/opt/sybase/ASE-15_0/scripts/installpubs2"

#查看日志
docker logs [containerid]

mongodb 安装

1.解压，创建软连接

tar -zxvf mongodb-linux-x86_64-3.4.6.tgz.gz

cd /data/software/
mkdir mongodb
ln -s /data/software/mongodb-linux-x86_64-3.4.6 /data/software/mongodb
cd mongodb
mkdir -p data/db
chmod  777  -r data/db
mkdir logs
cd logs
touch mongodb.log

2.配置系统profile

vi /etc/profile
export MONGODB_HOME=/data/software/mongodb  
export PATH=$PATH:$MONGODB_HOME/bin

3.mogodb.conf 配置文件

vi /data/software/mongodb/bin/mongodb.conf

dbpath = /data/software/mongodb/data/db
logpath = /data/software/mongodb/logs/mongodb.log
port = 27018
fork = true
nohttpinterface = true
bind_ip = 0.0.0.0
auth=false
logappend = true

4.启动

./mongod -f mongodb.conf

5.配置

#连接
./mongo 127.0.0.1:27018

#创建用户
use admin
db.createUser({ user: "admin", pwd: "XXX", roles: [{ role: "userAdminAnyDatabase", db: "admin" }] })
db.createUser({user: "root",pwd: "XXX", roles: [ { role: "root", db: "admin" } ]})

#验证
db.auth("root","Rt@20201207")

#关闭
db.shutdownServer() 

6.开启鉴权并启动

vi /data/software/mongodb/bin/mongodb.conf

#修改配置项
auth=true

./mongod -f mongodb.conf

参考文档：
https://blog.csdn.net/topswim/article/details/86613507
https://blog.csdn.net/Aria_Miazzy/article/details/85229736
https://blog.csdn.net/u014389734/article/details/103952326
https://www.cnblogs.com/lemon-flm/p/11052449.html
https://www.jianshu.com/p/62736bff7e2e