Package Details: mssql-server 15.0.4261.1-8

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://docs.microsoft.com/en-us/sql/linux/sql-server-linux-overview?view=sql-server-ver15
Licenses: unknown
Submitter: flash2k2
Maintainer: doctorzeus
Last Packager: doctorzeus
Votes: 25
Popularity: 0.003529
First Submitted: 2016-11-17 09:25 (UTC)
Last Updated: 2022-12-04 22:59 (UTC)

Pinned Comments

doctorzeus commented on 2022-12-04 23:03 (UTC)

For anyone who has been having problems with the package url not resolving, I have updated the package source to the direct alias of "packages.microsoft.com" to my region's azure instance.

This should solve the issue with different users regions having different directory structures until a more ideal solution comes to light.

Latest Comments

1 2 3 4 5 6 .. 10 Next › Last »

doctorzeus commented on 2022-12-04 23:03 (UTC)

For anyone who has been having problems with the package url not resolving, I have updated the package source to the direct alias of "packages.microsoft.com" to my region's azure instance.

This should solve the issue with different users regions having different directory structures until a more ideal solution comes to light.

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