Koozali.org: home of the SME Server

Contribs.org Forums => General Discussion => Topic started by: unixhed on April 16, 2018, 07:28:11 PM

Title: Microsoft SQl 2017 on SME server
Post by: unixhed on April 16, 2018, 07:28:11 PM
Good Day.

I am trying to install MS SQL server for Linux on SME server 9.2. I have downloaded the repository file into /etc/yum.repo with:

 wget https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo -O /etc/yum.repos.d/mssql-server.repo
  then
signal-event yum-modify.

Does not recognise repo.

Tried:

/sbin/e-smith/db yum_repositories setprop mssql-server status enabled

Still:

No package mssql-server available.
Error: Nothing to do

What am I doing wrong? :-(
Title: Re: Microsoft SQl 2017 on SME server
Post by: Jean-Philippe Pialasse on April 16, 2018, 07:53:22 PM
SME server ignore the content of the /etc/yum.repos.d to avoid conflict with upstream repo.

you need to eihter
1- use the db yum_repositories to set your repo and then signal-event yum-modify see :  https://wiki.contribs.org/Category:Yum_Repository and as an example : https://wiki.contribs.org/Openfusion

or

2- my guess is that if you put that file in /etc/yum.smerepos.d it should work.

let me know.


a third alternative would be if this is needed by a lot to build a smeserver-extrarepositories-mssql rpm to config this .

Title: Re: Microsoft SQl 2017 on SME server
Post by: ReetP on April 17, 2018, 12:58:36 AM
The repo quoted above was for RHEL 7.

Need to check if there is a version for RHEL 6 which SME 9 is based on
Title: Re: Microsoft SQl 2017 on SME server
Post by: unixhed on April 17, 2018, 11:31:10 AM
Thank you very much for your tips.
I moved the file to etc/yum.smerepos.d, then -

db yum_repositories set mssql-server repository \
BaseURL https://packages.microsoft.com/rhel/7/mssql-server-2017 \
EnableGroups no GPGCheck yes Name "MS-SQL repository" \
GPGKey https://packages.microsoft.com/keys/microsoft.asc Visible yes status disabled

signal-event yum-modify, a db yum_repositories show to check if OK.

yum install then proceeded correctly, other than expected dependency issues.

ReetP, you are correct in that the mssql build is for RHEL 7, but I wanted to get the install syntax right before testing on sme-server 10.

The build for RHEL 6 is no longer available in the repository, but there are some interesting rpms...
https://packages.microsoft.com/rhel/6.8/prod/
Thanks again.
Title: Re: Microsoft SQl 2017 on SME server
Post by: ReetP on April 17, 2018, 11:40:22 AM
Cool.

If you have some results then please create yourself a wiki page and add your notes there (just ask if you need access)
Title: Re: Microsoft SQl 2017 on SME server
Post by: Jean-Philippe Pialasse on April 17, 2018, 02:29:27 PM
It was a one or the other. You do not need to move the file and create the db entry, they should have the same result. Only the second will populate the default file, the sme way, and the first  will just work using the copied file in the right location untill you removed it manually.
Title: Re: Microsoft SQl 2017 on SME server
Post by: unixhed on April 18, 2018, 07:18:03 AM
Thanks again for the insights.
The install went smoothly on SME 10 in a VM, but I have insufficient RAM to configure.
I will set up a test rig over the weekend to test with the office app.