Enabling Machine Learning Service In mssql-docker

[shankarshastri]

Wanted to know how to enable Machine Learning Service (In-Database)?

[forkazmoden]

Hi,

SQL Server Machine Learning Services runs on Linux operating systems starting in the preview release of SQL Server 2019. Please refer to the document from Install SQL Server 2019 Machine Learning Services (R, Python, Java) on Linux.

[shankarshastri]

@forkazmoden, does it mean it's not available before 2019 in Linux version and only available in 2017 windows? I actually wanted to try it on docker containers.

[twright-msft]

Yes, that's correct. And even then, it's not installed in the Windows containers we provide today and we havent tested it in containers yet. Best to install it natively on Windows (2017) or Windows/Linux (2019 preview) VM for now. We'll containerize it on Linux pretty soon.

[shankarshastri]

Thanks, @twright-msft. Hope it will happen soon.

[DeppLearning]

Any news on this since CTP 2.3? According to the release notes sp_execute_external_script should work now.

I tried running a R script on an SQL server sporting the CTP 2.3 ubuntu release but get this:
SQL Server was unable to communicate with the LaunchPad service for request id: E66F4BF9-3991-4C93-A151-FCB76F625687. Please verify the configuration of the service.

When following the instructions for configuring under linux, I always get to the point where I have to restart the sql server using systemctl, for example to enable external scripts.

How is one supposed to enable external scripts? I tried by enabling it in a fresh docker container via sqlcmd/SSMS, exporting the master db and adding it to a new docker image. I always end up at the "unable to communicate with the LaunchPad" error no matter what I try. Restarting Launchpad seems to require systemctl again

Super exited for sql server + R in docker!

[lonaysta]

Also excited to see Machine Learning Services coming to SQL Server 2019 for Linux Docker! Have been recently researching approaches for an upcoming development task, and this seems to be promising for my need. Eager to see news on it.

[lonaysta]

Seems this feature is not live as of CTP 2.4. Hope this will be available soon!

[ClientIco]

So I got this working by adding this line

RUN chown -R root:root /var/opt/mssql-extensibility

Before it would just throw out launchpad.cer: Access denied

I just wonder if I introduced a security issue by adding this in for myself.

[jgfdsa]

Hi @ClientIco

Your post put me in the right direction. I have been trying to install SQL Server 2019 + Machine learning services in Ubuntu 16 but with no luck. I also tried using the Docker as described here

I confirm that running chown -R root:root /var/opt/mssql-extensibility fix the issue: SQL Server was unable to communicate with the LaunchPad service

I dont think this introduces any security issue. In fact, is part of the procedure when running building the DockerFile
39...
`# set directory permissions and create default directories

RUN chown -R root:root /opt/mssql/bin/launchpadd

RUN chown -R root:root /opt/mssql/bin/setnetbr

RUN mkdir -p /var/opt/mssql-extensibility/data

RUN mkdir -p /var/opt/mssql-extensibility/log

RUN chown -R root:root /var/opt/mssql-extensibility

RUN chmod -R 777 /var/opt/mssql-extensibility`

47...

[vin-yu]

we just added these two lines to the dockerfile to get things working. @ClientIco

RUN chown -R root:root /var/opt/mssql-extensibility
RUN chmod -R 777 /var/opt/mssql-extensibility

at the moment launchpaddd and mssql run as root but in the future we will run as non-root

[lerinave]

@Clientlco @jgfdsa @vin-yu Could you please list some instructions on how to get it to work?
I have the latest docker image from mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04 running, but cannot get the following two commands work:
sudo apt-get install mssql-mlservices-mlm-py
sudo apt-get install mssql-mlservices-mlm-r
it prompts "Unable to locate package XXX" ...

[peace-blaster]

Came here with the same issue as @lerinave. Did these packages move somewhere or something?

[jlehew]

I get the unable to locate package error as well. Says it cannot load the microsoft-openmpi package