Listing the Microsoft SQL Server configuration with the values set by mssql-conf?

Question

The utility mssql-conf in /opt/mssql/bin/mssql-conf has the setting list which tells you possible keys,

$ sudo ./mssql-conf list
control.alternatewritethrough              Enable optimized write through flush for O_DSYNC requests
control.hestacksize                        Host extension stack size in KB
control.writethrough                       Use O_DSYNC for file flag write through requests
coredump.captureminiandfull                Capture both mini and full core dumps
coredump.coredumptype                      Core dump type to capture: mini, miniplus, filtered, full
filelocation.defaultbackupdir              Default directory for backup files
filelocation.defaultdatadir                Default directory for data files
filelocation.defaultdumpdir                Default directory for crash dump files
filelocation.defaultlogdir                 Default directory for log files
filelocation.errorlogfile                  Error log file location
filelocation.masterdatafile                Master database data file location
filelocation.masterlogfile                 Master database log file location
hadr.hadrenabled                           Allow SQL Server to use availability groups for high availability and disaster recovery
language.lcid                              Locale identifier for SQL Server to use (e.g. 1033 for US - English)
memory.memorylimitmb                       SQL Server memory limit (megabytes)
network.forceencryption                    Force encryption of incoming client connections
network.forcesecureldap                    Force using LDAPS to contact domain controller
network.ipaddress                          IP address for incoming connections
network.kerberoskeytabfile                 Kerberos keytab file location
network.tcpport                            TCP port for incoming connections
network.tlscert                            Path to certificate file for encrypting incoming client connections
network.tlsciphers                         TLS ciphers allowed for encrypted incoming client connections
network.tlskey                             Path to private key file for encrypting incoming client connections
network.tlsprotocols                       TLS protocol versions allowed for encrypted incoming client connections
sqlagent.databasemailprofile               SQL Agent Database Mail profile name
sqlagent.enabled                           Enable or disable SQLAgent
sqlagent.errorlogfile                      SQL Agent log file path
sqlagent.errorlogginglevel                 SQL Agent logging level bitmask - 1=Errors, 2=Warnings, 4=Info
telemetry.customerfeedback                 Telemetry status
telemetry.userrequestedlocalauditdirectory Directory for telemetry local audit cache

How do I get the values?

Answer 1

There is no command line option to view what the values are actually set too, for now you'll have to check the file yourself

cat /var/opt/mssql/mssql.conf

However, it does not show the defaults. Stock, it has two options. One for sqlagent.enabled and one for EULA.accepteula. If you change one of those values as in the case of disabling CEIP,

$ sudo /opt/mssql/bin/mssql-conf set telemetry.customerfeedback false

Your conf file will look like this,

$ cat /var/opt/mssql/mssql.conf
[EULA]
accepteula = Y

[sqlagent]
enabled = false

[telemetry]
customerfeedback = false