Mssql.conf

/var/opt/mssql/mssql.conf
! dit is een pseudo tekst bestand , het de output een bash script die python script aanroept
je kan dus niet met een editor aanpassen

! diepgaande uitleg :
https://www.sqlshack.com/configure-sql-server-2017-linux-mssql-conf-available-tools/

sudo /opt/mssql/bin/mssql-conf validate

sudo /opt/mssql/bin/mssql-conf set filelocation.masterdatafile
sudo /opt/mssql/bin/mssql-conf get filelocation.masterdatafile
sudo /opt/mssql/bin/mssql-conf unset filelocation.masterdatafile

cat /opt/mssql/bin/mssql-conf
– indien er iets fout loopt , toont het de inhoud van het bash script

    ``` 
    #!/bin/bash
    # Don't generate .pyc files
    export PYTHONDONTWRITEBYTECODE=1

    CMD="exec $(dirname $0)/../lib/mssql-conf/mssql-conf.py $@"

    # Handle all permissions checks and file creations internally
    # This allows for all error messages to be localized
    /bin/bash -c "$CMD"
    ```

– anders, de pseudo text in een ini file formatering
enabled = false [EULA] accepteula = Y [language] lcid = 1033 [filelocation] masterdatafile = /mnt/backup/SQLSYSDB/master.mdf masterlogfile = /mnt/backup/SQLSYSDB/mastlog.ldf defaultdatadir = /mnt/backup/SQLDATA defaultdumpdir = /mnt/backup/SQLLOGGING

sudo /opt/mssql/bin/mssql-conf list

```
Locale en_DK not supported. Using en_US.

control.alternatewritethrough control.hestacksize control.stoponguestprocessfault control.writethrough coredump.captureminiandfull coredump.coredumptype distributedtransaction.allow distributedtransaction.fallb distributedtransaction.maxlogsize distributedtransaction.memorybuffersize distributedtransaction.servertcpport distributedtransaction.trace_cm distributedtransaction.trace_contact distributedtransaction.trace_gateway distributedtransaction.trace_log distributedtransaction.trace_misc distributedtransaction.trace_proxy distributedtransaction.trace_svc distributedtransaction.trace_trace distributedtransaction.trace_util distributedtransaction.trace_xa distributedtransaction.tracefilepath distributedtransaction.turnoffrpcsecurity errorlog.numerrorlogs extensibility.datadirectories extensibility.outboundnetworkaccess filelocation.defaultbackupdir filelocation.defaultdatadir filelocation.defaultdumpdir filelocation.defaultlogdir filelocation.errorlogfile filelocation.machinekeyfile filelocation.masterdatafile filelocation.masterlogfile hadr.hadrenabled language.lcid memory.disablememorypressure memory.enablecontainersharedmemory memory.memory_optimized memory.memorylimitmb network.disablesssd network.enablekdcfromkrb5conf network.forceencryption network.forcesecureldap network.ipaddress network.kerberoscredupdatefrequency network.kerberoskeytabfile network.ldaphostcanon network.privilegedadaccount network.rpcport network.tcpport network.tlscert network.tlsciphers network.tlskey network.tlsprotocols network.trustedexternaldomains sqlagent.databasemailprofile sqlagent.enabled sqlagent.errorlogfile sqlagent.errorlogginglevel sqlagent.startupwaitforalldb telemetry.customerfeedback telemetry.userrequestedlocal uncmapping. Enable optimized write through flush for O_DSYNC requests
Host extension stack size in KB
Stops the process if any guest process reports unhandled exception
Use O_DSYNC for file flag write through requests
Capture both mini and full core dumps
Core dump type to capture: mini, miniplus, filtered, full
onlysecurerpccalls Configure secure only rpc calls for distributed transactions
acktounsecurerpcifnecessary Configure security only rpc calls for distributed transactions
DTC log file size in MB. Default is 64MB
Circular buffer size in which traces are stored. This size is in MB and default is 10MB
MSDTC rpc server port
Traces in the connection manager
Traces the contact pool and contacts
Traces Gateway source
Log tracing
Traces that cannot be categorized into the other categories
Traces that are generated in the MSDTC proxy
Traces service and .exe file startup
The trace infrastructure itself
Traces utility routines that are called from multiple locations
XA Transaction Manager (XATM) tracing source
Folder in which trace files should be stored
Enable or disable RPC security for distributed transactions
Number of error log maintained before cycling the log.
Colon separated directory paths available to sp_execute_external_script
Enable outbound network access for sp_execute_external_script
Default directory for backup files
Default directory for data files
Default directory for crash dump files
Default directory for log files
Error log file location
Location of machine key file
Master database data file location
Master database log file location
Allow SQL Server to use availability groups for high availability and disaster recovery
Locale identifier for SQL Server to use (e.g. 1033 for US - English)
SQL Server disable memory pressure
Enable or disable use of shared memory when SQL runs inside a container
Enable or disable SQL Server memory optimized features - persistent memory file enlightenment, memory protection
SQL Server memory limit (megabytes)
Disable querying SSSD for AD account information and default to LDAP calls
Enable looking up KDC information from krb5.conf
Force encryption of incoming client connections
Force using LDAPS to contact domain controller
IP address for incoming connections
Time in seconds between checks for kerberos credentials that need to be updated
Kerberos keytab file location
Canonicalize hostnames with LDAP
Privileged AD user to use for AD authentication
TCP port for Rpc endpoint mapper
TCP port for incoming connections
Path to certificate file for encrypting incoming client connections
TLS ciphers allowed for encrypted incoming client connections
Path to private key file for encrypting incoming client connections
TLS protocol versions allowed for encrypted incoming client connections
Trusted domains outside the AD forest SQL is joined to
SQL Agent Database Mail profile name
Enable or disable SQLAgent
SQL Agent log file path
SQL Agent logging level bitmask - 1=Errors, 2=Warnings, 4=Info
Set to 1 (default) if SqlAgent should wait for all databases on startup; set to 0 to wait for MSDB only
Telemetry status
auditdirectory Directory for telemetry local audit cache
Maps UNC path to a local path. (e.g. ./mssql-conf set uncmapping //servername/sharename /tmp/folder)