Koozali.org: home of the SME Server

Contribs.org Forums => General Discussion => Topic started by: Skalviai on December 17, 2021, 09:43:03 PM

Title: Microsoft SQL 2019 on SME server
Post by: Skalviai on December 17, 2021, 09:43:03 PM

Good Day.
I am trying to install MS SQL server for Linux on SME server 10.
I installed SQL Server according to the instructions provided https://phoenixnap.com/kb/sql-server-linux.
SQL Server is running fine, but not after rebooting the server.

# systemctl start mssql-server
Information: mssql-server is not defined in configuration DB.

After manual run service SQL server work fine.


How to auto run SQL service at boot?

Title: Re: Microsoft SQL 2019 on SME server
Post by: mmccarn on December 18, 2021, 03:26:40 PM

SME10 uses a custom wrapper around systemctl that checks to make sure the SME configuration database
a) has an entry for the service
b) indicates that the service is enabled

Try this:

Code: [Select]

config set mssql-server service status enabled

Note: there may be more settings needed to create firewall rules, too.

Title: Re: Microsoft SQL 2019 on SME server
Post by: Skalviai on December 18, 2021, 08:50:09 PM

Quote from: mmccarn on December 18, 2021, 03:26:40 PM

Try this:

Code: [Select]

config set mssql-server service status enabled


Thanks for the idea.
SQL server works great after:

Code: [Select]

config settype mssql-server service


Title: Re: Microsoft SQL 2019 on SME server
Post by: ReetP on December 19, 2021, 12:53:59 AM

You should have a unit override file called

49-koozali.preset

Code: [Select]

[Install]
wantedBy=sme-server.target
Should also have an action to expand the correct templates & adjust the relevant services.

See my note to self here & read the wiki for more.

https://wiki.koozali.org/User_talk:ReetP
https://wiki.koozali.org/Postgres