@jorgemmota openssl-1.0 is provided by the core repo don't get an AUR version.. Also you shouldn't need openssl-1.1 for this package..
Have you tried installing the package normally without yay?
Git Clone URL: | https://aur.archlinux.org/mssql-server.git (read-only, click to copy) |
---|---|
Package Base: | mssql-server |
Description: | Microsoft SQL Server for Linux |
Upstream URL: | https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-overview?view=sql-server-ver16 |
Licenses: | unknown |
Submitter: | flash2k2 |
Maintainer: | too |
Last Packager: | too |
Votes: | 31 |
Popularity: | 0.57 |
First Submitted: | 2016-11-17 09:25 (UTC) |
Last Updated: | 2025-05-25 16:51 (UTC) |
« First ‹ Previous 1 2 3 4 5 6 7 8 9 10 11 .. 13 Next › Last »
@jorgemmota openssl-1.0 is provided by the core repo don't get an AUR version.. Also you shouldn't need openssl-1.1 for this package..
Have you tried installing the package normally without yay?
@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:
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
/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
Pinned Comments
doctorzeus commented on 2023-05-16 10:15 (UTC) (edited on 2023-06-17 03:56 (UTC) by doctorzeus)
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
doctorzeus commented on 2023-02-22 22:23 (UTC) (edited on 2024-08-19 04:24 (UTC) by doctorzeus)
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