Package Details: mssql-server 16.0.4115.5-1

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: doctorzeus
Last Packager: doctorzeus
Votes: 29
Popularity: 1.57
First Submitted: 2016-11-17 09:25 (UTC)
Last Updated: 2024-03-19 19:04 (UTC)

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)

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

Latest Comments

« First ‹ Previous 1 .. 7 8 9 10 11 12 13 Next › Last »

countercraft commented on 2017-05-08 15:55 (UTC)

I managed to update the PKGBUILD to install the newest version and update the links to use libopenssl-1.0-compat. The newest version also depends on libsss_nss_idmap, and the python scripts were changed. 3c3 < pkgver=14.0.200.24 --- > pkgver=14.0.500.272 5c5 < pkgrel=2 --- > pkgrel=1 10,13c10,14 < depends=(python2-configparser numactl) < makedepends=(rpmextract) < source=("https://packages.microsoft.com/rhel/7/$pkgname/$pkgname-$_prodver.x86_64.rpm") < md5sums=('d498ce2395cca3d094152bc84a9575e5') --- > depends=(python2-configparser numactl libopenssl-1.0-compat) > source=("https://packages.microsoft.com/rhel/7/$pkgname/$pkgname-$_prodver.x86_64.rpm" > "http://mirror.centos.org/centos/7/os/x86_64/Packages/libsss_nss_idmap-1.14.0-43.el7.x86_64.rpm") > sha256sums=('bf1840059a35f51c7841bb4695fdd77ebc7c7df752003c1e173166a700d5ae75' > 'db81bc79c4cb24d6710ba5ce6c56cf3cc102b9db4afadee41e92f1583f28f878') 20,22c21,26 < ln -s /usr/lib/libssl.so.1.0.0 usr/lib/libssl.so.10 < ln -s /usr/lib/libcrypto.so.1.0.0 usr/lib/libcrypto.so.10 < sed 's/^exec/exec python2/' opt/mssql/bin/mssql-conf -i --- > cp $srcdir/usr/lib64/libsss_nss_idmap.so.0* opt/mssql/lib > ln -s /usr/lib/openssl-1.0-compat/libssl.so usr/lib/libssl.so.10 > ln -s /usr/lib/openssl-1.0-compat/libcrypto.so usr/lib/libcrypto.so.10 > for i in $(ls opt/mssql/lib/mssql-conf/*.py); do > sed 's/#!\/usr\/bin\/python/#!\/usr\/bin\/python2/' $i -i > done

djmott commented on 2017-05-07 04:15 (UTC)

I was able to get it working by copying libcrypto* to the ./lib folder from the msodbcsql package and deleting libjemalloc.so.1 and libunwind.so.8

taktika commented on 2017-05-03 11:33 (UTC)

I confirm that it has stopped working. Does not work on new fresh install either. Result: (both files exists) >sudo /opt/mssql/bin/sqlservr /opt/mssql/bin/sqlservr: /usr/lib/libcrypto.so.10: version `libcrypto.so.10' not found (required by /opt/mssql/bin/sqlservr) >sqlcmd -S localhost Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.1.0' : file not found.

Eremiell commented on 2017-04-29 06:40 (UTC) (edited on 2017-04-29 09:01 (UTC) by Eremiell)

Sadly still doesn't run, maybe the hack over at https://aur.archlinux.org/packages/msodbcsql/ might help? Edit: Tried to port the hack, sadly wasn't successful. Maybe I just screwed up and did some trivial mistake, so it shouldn't be an indicator that it can't be done. Just not going to burn more time on that right now.

Eremiell commented on 2017-04-29 06:37 (UTC)

diff --git a/PKGBUILD b/PKGBUILD index e38273d..07f78f6 100644 --- a/PKGBUILD +++ b/PKGBUILD @@ -1,6 +1,6 @@ # Maintainer: Aleksey Kamenskikh <aleksey.kamenskikh@gmail.com> pkgname=mssql-server -pkgver=14.0.200.24 +pkgver=14.0.500.272 _prodver=${pkgver}-2 pkgrel=2 pkgdesc="Microsoft SQL Server for Linux" @@ -10,7 +10,7 @@ license=('unknown') depends=(python2-configparser numactl) makedepends=(rpmextract) source=("https://packages.microsoft.com/rhel/7/$pkgname/$pkgname-$_prodver.x86_64.rpm") -md5sums=('d498ce2395cca3d094152bc84a9575e5') +sha512sums=('028d0abfb816ab7bb830db7e89604b9698af46505c92f923636d63a53e828aefa013ece0c018e374c08f90258676163eff2b0b4dae3d90b5ed1b995b8053651d') noextract=("$pkgname-$_prodver.x86_64.rpm") install=$pkgname.install

keoma commented on 2017-04-27 20:55 (UTC)

It seems mssql-server does not support openssl 1.1 version yet. It's a big problem for me because I really need SQL Server. I'm monitoring and trying to install on my system and, if I get success, I'll tell you.

martinm1000 commented on 2017-04-25 05:22 (UTC) (edited on 2017-04-25 05:24 (UTC) by martinm1000)

This package is way out of date. And now it doesn't work anymore... not sure why, the lib is there... unless its the openssl update I just got. /opt/mssql/bin/sqlservr: /usr/lib/libcrypto.so.10: version `libcrypto.so.10' not found (required by /opt/mssql/bin/sqlservr)

elvisd commented on 2017-02-06 16:47 (UTC)

Since today I couldn't start the mssql-server via systemctl. Starting it from command line an error is thrown about missing numa(somthing).so file. Installing the numactl library via pacman resolved the issue. Should this be added to the packagebuild?

wllacer commented on 2017-01-25 18:18 (UTC)

Just FYI On executing the setup utility: /opt/mssql/bin/sqlservr: /usr/lib/libcrypto.so.10: no version information available (required by /opt/mssql/bin/sqlservr) sqlservr: This program requires a machine with at least 3250 megabytes of memory. I guess i need to find another test machine :-(

flash2k2 commented on 2016-12-06 10:23 (UTC)

Thanks, clfarron4. I've updated the PKGBUILD

« First ‹ Previous 1 .. 7 8 9 10 11 12 13 Next › Last »