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.

If you have a problem compiling libldapV2.4, go and ask on that package page, not here.

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

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

@doctorzeus, you are right, If I uninstall openssl-1.0 I can't run with sudo /opt...

 yay -R openssl-1.0
 [sudo] password for jorge: 
 checking dependencies...
 error: failed to prepare transaction (could not satisfy dependencies)
 :: removing openssl-1.0 breaks dependency 'openssl-1.0' required by mssql-server
  -> exit status 1

I cleaned up ~/.cache/yay/mssql-server , run yay -Syyuua, yay -Syyuu, pacman -Syyuu, reinstalled... but PKGBUILD always says 'openssl-1.0' on depends... I am going to download tarball to test.

--edit I have uninstalled openssl-1.0, reinstalled openssl-1.1, tried openssl-1.0.chacha openssl-1.0-hardened but got same error.

If I copy from openssl-1.1.so got core dump. I am not sure what to do.

@jorgemota Seems the package that provides libssl.so.1.0.0 and libcrypto.so.1.0.0 is "openssl-1.0" NOT "openssl-1.1" (go figure but thats what 7/14 hour weeks for 2 weeks does to you)..

Either way deps updated so try installing the updated packaged and resolving deps and should hopefully work for you..

@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!