Topic: Microsoft SQl 2017 on SME server

[unixhed]

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?

[Jean-Philippe Pialasse]

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 .

[ReetP]

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

[unixhed]

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.

[ReetP]

Cool.

If you have some results then please create yourself a wiki page and add your notes there (just ask if you need access)

[Jean-Philippe Pialasse]

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.

[unixhed]

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.