Arch Linux User Repository

This current package is MSSQLServer2022.

For anyone who needs to set the compatibility level of a db to migrate to an older version, see this article:

https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16

NOTES ON libldap 2.4:

Yes there is a newer version in the official repos but the binaries do not run without this version which is listed in the dependencies by Microsoft.

You can get libldap V2.4 here from this AUR package:

https://aur.archlinux.org/packages/libldap24

@msir The files you changed are specific to pamac of course.

However re "openssl-1.1" its a very recent package by the looks of things, try doing a full system update and in particular make sure your package list is updated: I.e. "sudo pacman -Syyu"..

Hi, I updated but same error when using systemctl start mssql-server. After 5 seconds got this:

mssql-server.service - Microsoft SQL Server Database Engine
  Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; pre>
  Active: failed (Result: exit-code) since Tue 2022-11-08 22:15:20 CST; 5s a>
 Duration: 1.742s
    Docs: https://docs.microsoft.com/en-us/sql/linux
 Process: 33368 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=1/FAI>
 Main PID: 33368 (code=exited, status=1/FAILURE)
   Tasks: 3
 Memory: 237.2M
    CPU: 21.066s
 CGroup: /system.slice/mssql-server.service
         ├─33872 sh /opt/mssql/bin/compress-dump.sh /var/opt/mssql/log/core>
         ├─33873 /bin/tar cjf /var/opt/mssql/log/core.sqlservr.11_08_2022_2>
         └─33874 bzip2

  --journalctl -xeu...
  The job identifier is 4182 and the job result is failed.
  Nov 08 22:47:58 blackfox systemd[1]: mssql-server.service: Start request repeated       too quickly.
  Nov 08 22:47:58 blackfox systemd[1]: mssql-server.service: Failed with result 'exit-code'.
  ░░ Subject: Unit failed
  ░░ Defined-By: systemd
  ░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
  ░░ 
  ░░ The unit mssql-server.service has entered the 'failed' state with result 'exit-      code'.
  Nov 08 22:47:58 blackfox systemd[1]: mssql-server.service: Unit process 37424 (sh)       remains running after unit stopped.
  Nov 08 22:47:58 blackfox systemd[1]: mssql-server.service: Unit process 37425 (tar)       remains running after unit stopped.
  Nov 08 22:47:58 blackfox systemd[1]: mssql-server.service: Unit process 37426       (bzip2) remains running after unit stopped.
  Nov 08 22:47:58 blackfox systemd[1]: mssql-server.service: Unit process 37886 (sh)       remains running after unit stopped.
  Nov 08 22:47:58 blackfox systemd[1]: mssql-server.service: Unit process 37887 (tar) remains running after unit stopped.
  Nov 08 22:47:58 blackfox systemd[1]: mssql-server.service: Unit process 37888       (bzip2) remains running after unit stopped.
  Nov 08 22:47:58 blackfox systemd[1]: Failed to start Microsoft SQL Server Database       Engine.
  ░░ Subject: A start job for unit mssql-server.service has failed
  ░░ Defined-By: systemd
  ░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
  ░░ 
  ░░ A start job for unit mssql-server.service has finished with a failure.

but if I run sudo sudo /opt/mssql/bin/sqlservr this works normally... with and without libssl.so and libcrypto in /opt/mssql/lib

Hi. I had mssql-server running during the one but latest update and after reboot the server indeed refused to start up. I couldn't get it running. The latest update 15.0.4261.1-2 solved the problem for me, and it's up and running again. Thanks @doctorzeus !

Hi @doctorzeus, I have tried to install, but still without success. The ouput of

(base) which openssl

is

/home/msir/opt/openssl/bin/openssl

When I try to install the mssql-server using the command:

(base) pamac build mssql-server

It asks me to edit two files:

First one:/var/tmp/pamac-build-username/mssql-server/diff

In this file, there are the lines:

ln -s /lib/libssl.so.1.0.0 $pkgdir/opt/mssql/lib/libssl.so

ln -s /lib/libcrypto.so.1.0.0 $pkgdir/opt/mssql/lib/libcrypto.so

I have changed these two lines to:

ln -s /home/msir/opt/openssl/lib/libssl.so.1.0.0 $pkgdir/opt/mssql/lib/libssl.so

ln -s /home/msir/opt/openssl/lib/libcrypto.so.1.0.0 $pkgdir/opt/mssql/lib/libssl.so

These are the contents of /home/msir/opt/openssl/lib:

engines-1.1 libcrypto.a libcrypto.so libcrypto.so.1.1 libssl.a libssl.so libssl.so.1.1 pkgconfig

The second file to edit is:

/var/tmp/pamac-build-msir/mssql-server/PKGBULD

, and it has the same lines as above that I have changed in the same way:

ln -s /lib/libssl.so.1.0.0 $pkgdir/opt/mssql/lib/libssl.so

ln -s /lib/libcrypto.so.1.0.0 $pkgdir/opt/mssql/lib/libcrypto.so

to

ln -s /home/msir/opt/openssl/lib/libssl.so.1.0.0 $pkgdir/opt/mssql/lib/libssl.so

ln -s /home/msir/opt/openssl/lib/libcrypto.so.1.0.0 $pkgdir/opt/mssql/lib/libssl.so

There is still a third file that I let unchanged:

/var/tmp/pamac-build-msir/mssql-server/mssql-server.install

with the following lines:

post_install() { echo "Now run /opt/mssql/bin/mssql-conf setup" }

Independently, I have this error:

Warning: cannot resolve "openssl-1.1", a dependency of "mssql-server" Error: Failed to prepare transaction: could not satisfy dependencies: - unable to satisfy dependency 'openssl-1.1' required by mssql-server

I would like to know if someone have faced an equivalent error.

Thanks in advance!

@purple_sunset Many Thanks!

I have put through an update adding a symbolic link to those libs from the openssl-1.1 package. So should be working now.

Look like it stop working after updating openssl to 3.0.7. My workaround is copy openssl 1.0 libcrypto and libssl to mssql lib folder:

sudo cp /usr/lib/libssl.so.1.0.0 /opt/mssql/lib/libssl.so

sudo cp /usr/lib/libcrypto.so.1.0.0 /opt/mssql/lib/libcrypto.so

Package sadly seems to be broken after recent arch update and is seg faulting on startup.

Probably a broken dep but am currently away from my workstation to be able to be able to have a proper look for the next few days..

If someone figures this one out please post here and I will update with fix!

After install I had to create manually user by "useradd mssql".

After creating user there were warning which was not visible before this install: [sss_cache] [confdb_get_domains] (0x0010): No domains configured, fatal error! [sss_cache] [confdb_get_domains] (0x0010): No domains configured, fatal error!

These problems I believe apeeared in last month, before that whole installation worked

@JimMoen Not out of date, rolling release in core of libldap causes mssql to fail to start.