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 .. 13 Next › Last »

Nek commented on 2022-12-02 15:20 (UTC)

I get this error:

Validating source files with sha256sums... mssql-server-15.0.4261.1-2.x86_64.rpm ... FAILED

seems that the hosted rpm file has changed and needs rehashing

doctorzeus commented on 2022-11-29 21:31 (UTC) (edited on 2022-11-29 21:35 (UTC) by doctorzeus)

@zwastik and @Roknauta Microsoft sometimes have different directory structures in different azure region instances.. So please tell me the results of:

$ host packages.microsoft.com

Roknauta commented on 2022-11-29 10:36 (UTC)

@zwastik same problem here.

zwastik commented on 2022-11-27 20:00 (UTC) 

==> Making package: msodbcsql 18.1.2.1-1 (Sun 27 Nov 2022 04:59:52 PM -03)                                                                   
==> Checking runtime dependencies...
==> Checking buildtime dependencies...
==> Retrieving sources...
  -> Downloading msodbcsql18-18.1.2.1-1.x86_64.rpm...
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0   162    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
curl: (22) The requested URL returned error: 404
==> ERROR: Failure while downloading https://packages.microsoft.com/rhel/8/prod/Packages/m/msodbcsql18-18.1.2.1-1.x86_64.rpm
    Aborting...

Command 'makepkg' failed to execute.

jorgemota commented on 2022-11-18 23:38 (UTC) (edited on 2022-11-22 20:30 (UTC) by jorgemota)

After I upgraded to this I was unable to start mssql server, Got Setup step is FORCE copying system data file 'C:\templatedata\model_msdblog.ldf' to '/var/opt/mssql/data/model_msdblog.ldf'.

and

Error 5(Access is denied.) occurred while opening file '/var/opt/mssql/data/master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error

cannot run with sudo /opt/mssql/bin/sqlsrv

Reverted to this version: https://aur.archlinux.org/cgit/aur.git/commit/?h=mssql-server&id=26e3f7f344160ba6ee80279b65d18aa9ae7d2ad3

and now can start with systemctl as always.

EDIT updated to latest version, got same error as before on virtualized pc, reverted version got same problem. after upgrade run 

 systemctl disable mssql-server

 chown -R mssql:mssql /opt/mssql 
 chown -R mssql:mssql /var/opt/mssql
 su - mssql
 /opt/mssql/bin/sqlsrvr 
 ##Wait some minutes to wait end upgrades scripts..and press CTRL+C
 exit 
 systemctl enable mssql-server
 systemctl start mssql-server

All starts working again...

mindriddler commented on 2022-11-17 07:45 (UTC)

@doctorzeus I just updated this package and it worked. Then i tried to uninstall and reinstall the package again and everything worked flawless this time.

Thank you for whatever it was you did to resolve the issue i had!

doctorzeus commented on 2022-11-15 21:31 (UTC) (edited on 2022-11-15 21:34 (UTC) by doctorzeus)

@serverach Official repo lists the dependency as openssl >= 1.0.1 but I'm guessing the latest version of openssl that breaks mssql-server hasn't been released on redhat yet..

Technically they should both work (verified this and did not have openssl-1.1 installed when I tried it).. Tested with linking openssl-1.1 libs and they seem to work so will update accordingly as its better to have the newer one..

Also my object dep trace seems to point to the latest version $ ldd /opt/mssql/bin/sqlservr | grep -i ssl OUTPUT: libssl.so.3 => /usr/lib/libssl.so.3 (0x00007f23250a3000)

severach commented on 2022-11-15 17:19 (UTC) (edited on 2022-11-15 17:24 (UTC) by severach)

openssl 1.0 is not correct. Please revert to openssl 1.1. It keeps working because you didn't remove openssl 1.1. Remove the non depends openssl to show the requirement.

ldd /opt/mssql/bin/sqlservr | grep -i ssl
    libssl.so.1.1 => /usr/lib/libssl.so.1.1 (0x00007ff49b61c000)

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

@mindriddler

Just vpn'd into Sweeden and tried the source's dir address of "https://packages.microsoft.com/rhel/7/mssql-server-2019/" and can confirm it is very different..

Normally I get the full list of all the different mssql-server rpms wheras this one only gives me "Packages", "config.repo" and "repodata"..

This presents a whole other problem as there might be different variations on different azure region servers..

In the mean time however I can see about maybe doing a host lookup source override for the westeurope azure instance in the PKGBUILD..

mindriddler commented on 2022-11-14 11:26 (UTC) (edited on 2022-11-14 11:26 (UTC) by mindriddler)

@doctorzeus Here is the host lookup

packages.microsoft.com is an alias for apt-geofence-parent.trafficmanager.net. apt-geofence-parent.trafficmanager.net is an alias for csd-apt-weu-d-4.westeurope.cloudapp.azure.com. csd-apt-weu-d-4.westeurope.cloudapp.azure.com has address 13.81.215.193

« First ‹ Previous 1 2 3 4 5 6 7 8 9 .. 13 Next › Last »