sqlserver2017无法读取/var/opt/mssql/mssql.conf

Question

已经修改了/var/opt/mssql/mssql.conf文件

/var/opt/mssql/mssql.conf

[EULA]
accepteula = Y

[coredump]
captureminiandfull = true
coredumptype = full

[filelocation]
defaultbackupdir = /data/mssql/data/
defaultdatadir = /data/mssql/data/
defaultdumpdir = /data/mssql/log/
defaultlogdir = /data/mssql/log/

[hadr]
hadrenabled = 0

[language]
lcid = 2052

[memory]
memorylimitmb = 4096

#[network]
#forceencryption = 0
#ipaddress = 10.192.0.0
#kerberoskeytabfile = /var/opt/mssql/secrets/mssql.keytab
#tcpport = 1401
#tlscert = /etc/ssl/certs/mssql.pem
#tlsciphers = ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA:ECDHE-RSA-AES128-SHA:AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA256:AES128-SHA256:AES256-SHA:AES128-SHA
#tlskey = /etc/ssl/private/mssql.key
#tlsprotocols = 1.2,1.1,1.0

[sqlagent]
databasemailprofile = default
errorlogfile = /data/mssql/log/sqlagentlog.log
errorlogginglevel = 7

[telemetry]
customerfeedback = true
userrequestedlocalauditdirectory = /tmp/audit

[traceflag]
traceflag0 = 1204
traceflag1 = 2345
traceflag = 3456

执行安装

/opt/mssql/bin/mssql-conf -n setup

配置文件指定的数据库安装位置是：/data/mssql/data/，但是sqlserver还是安装在/var/opt/mssql目录下，请问是什么原因

---

Love SQL

Answer 1

Hi Steven.桦仔,

你有给相应的目录授权吗，你需要把对应目录的owner and group改为mssql user。 现在这个情况，你可以尝试使用这个工具在安装之后修改目录位置：

1. 修改相应的目录的owner到mssql，下面的例子假设使用/tmp/backup

sudo chown mssql /tmp/backup
sudo chgrp mssql /tmp/backup

2. 执行这个命令sudo /opt/mssql/bin/mssql-conf set filelocation.defaultbackupdir /tmp/backup

3. 重启SQL Server   sudo systemctl restart mssql-server

几个路径都是类似的改法，你看下这个 https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf

Best Regards，

Teige

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

chown我执行过的，权限都有的，我的问题是，为啥我手动改var/opt/mssql/mssql.conf 文件，sqlserver就不读这个文件，而要每次都要执行一下这个shell脚本mssql-conf 更改相关设置？

 /opt/mssql/bin/mssql-conf set filelocation.defaultbackupdir /tmp/backup

---

Love SQL

Answer 3

Hi Steven.桦仔，

你的Linux的版本是什么啊，另外你的完整的安装命令是什么，我测试了一下但是不能重现问题，你看一下文档看看是不是指令出错了： https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-environment-variables

Best Regards,

Teige

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 4

Linux版本：centos7.3  64位

按照msdn的文档来安装的

---

Love SQL