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: 0.75
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 2 3 4 5 6 7 8 9 10 .. 13 Next › Last »

doctorzeus commented on 2022-11-14 11:22 (UTC)

@mindriddler Just because the link is broken for you doesn't mean its broken for everyone:

I re-downloaded and rebuilt the package as well as downloaded the source link manually and looked for the file in the directory listing of "https://packages.microsoft.com/rhel/7/mssql-server-2019/" it all worked and was there.. Maybe someone else can verify they have the same problem?

Only thing I can think of is that it might be a region issue with "packages.microsoft.com" resolving to a different server with a different directory structure as the packages are all hosted on azure..

Could you do a host lookup on "packages.microsoft.com", i.e:

$ host packages.microsoft.com

mindriddler commented on 2022-11-14 11:18 (UTC)

@doctorzues so i downloaded a snapshot and modified the pkbuild source to the link i sent you and it worked without any issues. I highly suggest that you update the source as it is broken

mindriddler commented on 2022-11-14 10:50 (UTC) (edited on 2022-11-14 10:52 (UTC) by mindriddler)

@doctorzeus well, i mean.. the link you posted in your response to me works, but the link in Sources does not work. That link gives 404: not found when trying to build. Which indicates that the link is broken.

Just try to change it to the only i linked, im sure it will work.

Everything is pointing to the source is broken

https://i.imgur.com/UttdSST.png https://i.imgur.com/JAYgXf4.png

doctorzeus commented on 2022-11-14 09:46 (UTC)

@jorgemota Not sure whats happening with yours sorry. I will boot up a fresh arch VM when I get a chance this week to do a fresh install with no extra deps and see if there is any issues on that to verify..

doctorzeus commented on 2022-11-14 09:42 (UTC)

@mindriddler Source dir under the package build is "https://packages.microsoft.com/rhel/7/mssql-server-2019/" and yes it is correct.

mindriddler commented on 2022-11-14 08:48 (UTC)

Are you using the correct source? When i try to download and build this i get 404: not found and i also tried to go to your source link manually but there i also get 404: not found

I tried to change the URL and i found the correct package on this URL: https://packages.microsoft.com/rhel/7/mssql-server-2019/Packages/m/

So it seems to me that the source should be https://packages.microsoft.com/rhel/7/mssql-server-2019/Packages/m/mssql-server-15.0.4261.1-2.x86_64.rpm

jorgemota commented on 2022-11-11 17:39 (UTC)

@doctorzeus, I did it at first time, but I tried again, removed all references to files for openssl-1.0* (removed package, removed from pacman cache, removed links, etc) installed with pacman -S openssl-1.0 and mssql-server with tarball and makepkg -si but result remains equals.

doctorzeus commented on 2022-11-11 01:50 (UTC)

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

jorgemota commented on 2022-11-09 16:24 (UTC) (edited on 2022-11-10 06:56 (UTC) by jorgemota)

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

doctorzeus commented on 2022-11-09 06:38 (UTC) (edited on 2022-11-09 07:09 (UTC) by doctorzeus)

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