ms windoz 10 & wsl & oraclelinux 8 & ms sql server 19 hacks

curl -o /etc/yum.repos.d/mssql-server.repo \ https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo

curl https://packages.microsoft.com/config/rhel/8/prod.repo > /etc/yum.repos.d/msprod.repo

dnf install mssql-server
dnf install mssql-tools

/opt/mssql/bin/mssql-conf setup

[3 = Express]

openssl req -x509 -nodes -newkey rsa:2048 -subj '/CN=MYHOSTNAME' \
-keyout mssql.key -out mssql.pem -days 365 

chown mssql:mssql mssql.key mssql.pem 

mv mssql.pem /etc/ssl/certs/ 

mkdir /etc/ssl/private/

mv mssql.key /etc/ssl/private/

systemctl stop mssql-server 

cat /var/opt/mssql/mssql.conf 

/opt/mssql/bin/mssql-conf set network.tlscert /etc/ssl/certs/mssql.pem 
/opt/mssql/bin/mssql-conf set network.tlskey /etc/ssl/private/mssql.key 
/opt/mssql/bin/mssql-conf set network.tlsprotocols 1.2 
/opt/mssql/bin/mssql-conf set network.forceencryption 0 

cat /var/opt/mssql/mssql.conf 

systemctl restart mssql-server 

systemctl status mssql-server 

sqlcmd -C -U sa -P

cp cert to /etc/pki/ca-trust/source/anchors/ 
then use update-ca-trust to enable it as system CA certificate.

sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent
sudo firewall-cmd --reload