Koozali.org: home of the SME Server

Microsoft SQL 2019 on SME server

Offline Skalviai

  • *
  • 35
  • +0/-0
Microsoft SQL 2019 on SME server
« 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?



« Last Edit: December 18, 2021, 02:54:17 PM by Skalviai »
.........

Offline mmccarn

  • *
  • 2,626
  • +10/-0
Re: Microsoft SQL 2019 on SME server
« Reply #1 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.

Offline Skalviai

  • *
  • 35
  • +0/-0
Re: Microsoft SQL 2019 on SME server
« Reply #2 on: December 18, 2021, 08:50:09 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
.........

Online ReetP

  • *
  • 3,722
  • +5/-0
Re: Microsoft SQL 2019 on SME server
« Reply #3 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

...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation