@doctorzeus separate packages make perfect sense, I thought about doing one at least for lts myself, but learning the packaging spec is still on todo :) and a single maintainer for related packages would probably make more sense as well.
Search Criteria
Package Details: mssql-server 16.0.4135.4-1
Package Actions
| 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: | 30 |
| Popularity: | 0.133207 |
| First Submitted: | 2016-11-17 09:25 (UTC) |
| Last Updated: | 2024-08-12 02:03 (UTC) |
Dependencies (16)
- gawk (gawk-gitAUR, busybox-coreutilsAUR)
- gdb (gdb-gitAUR, gdb-debug-gitAUR)
- glibc (glibc-gitAUR, glibc-linux4AUR, glibc-eacAUR, glibc-eac-binAUR, glibc-eac-rocoAUR)
- krb5 (krb5-gitAUR)
- libatomic_ops
- libc++ (libc++-msanAUR, libc++-modulesAUR)
- libldap24AUR
- libunwind (libunwind-carbonAUR, libunwind-gitAUR)
- nss (nss-hgAUR)
- numactl (numactl-gitAUR)
- openssl-1.1
- pam (pam-selinuxAUR)
- sed (busybox-coreutilsAUR, sed-gitAUR)
- sssd (sssd-gitAUR, sssd-nosmbAUR)
- debugedit (debugedit-gitAUR) (optional)
- python-pyodbcAUR (optional)
Required by (4)
- mssql-server-fts
- mssql-tools (optional)
- python-pydal-git (optional)
- shlink (optional)
Sources (1)
too commented on 2020-10-07 08:12 (UTC)
doctorzeus commented on 2020-10-07 03:18 (UTC)
@too
I think it would be best introduced as a separate AUR package which would then depend on mssql-server.
I might be wrong but I'm pretty sure the AUR discourages bundling packages in this fashion to prevent mission creep etc..
too commented on 2020-10-05 09:15 (UTC) (edited on 2020-10-05 09:16 (UTC) by too)
To package authors - are you considering adding mssql feature packages in addition to the main pkg? I manually installed matching version mssql-server-fts from deb and it works fine but there is no aur package for it yet:
wget https://packages.microsoft.com/ubuntu/18.04/mssql-server-2019/pool/main/m/mssql-server-fts/mssql-server-fts_15.0.4053.23-2_amd64.deb
dpkg --extract ./mssql-server-fts_15.0.4053.23-2_amd64.deb /
Current list of available additional packages includes high availability, fts, extensibility, java extensibility and polybase: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-release-notes-2019?view=sql-server-ver15
ArthurBorsboom commented on 2020-03-10 12:48 (UTC)
systemd[1]: Configuration file /usr/lib/systemd/system/mssql-server.service is marked executable. Please remove executable permission bits. Proceeding anyway.
countercraft commented on 2020-02-03 14:11 (UTC)
@doctorzeus I never used SQLAgent so I don't really know what's going wrong. I followed these two tutorials (https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-sql-agent?view=sql-server-ver15 and https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-run-sql-server-agent-job?view=sql-server-ver15) and it seems to work.
I updated the package because I discovered that Microsoft now specifies the Python 2 interpreter on the scripts, so the sed used to correct the interpreter was wrong.
doctorzeus commented on 2020-02-02 03:35 (UTC)
@gabrielmldantas Did a fresh install this weekend and still getting the same error unfortunately.
Did Microsoft remove SQLAgent availability from the Developer license as otherwise I can't find anything on google referencing the issue so assuming its a package/distro issue?
doctorzeus commented on 2020-01-09 01:40 (UTC) (edited on 2020-01-29 16:07 (UTC) by doctorzeus)
@gabrielmldantas no luck unfortunately, guessing it's something todo with the upgrade from 2017-2019.. Going to try a fresh install..
Is Microsoft maintaining the 2017 one? If so someone could always start a separate package.
countercraft commented on 2020-01-08 12:36 (UTC)
@doctorzeus I didn't have this problem but the 2 or 3 last versions of SQL Server had a problem with OpenSSL causing connection failures. That's why I linked the correct OpenSSL libraries directly into the installation directory. Anyway, a new version was released yesterday and it seems to not need the link anymore, so I removed them from the PKGBUILD. You can try to update to see if it works for you.
doctorzeus commented on 2020-01-08 01:39 (UTC) (edited on 2020-01-08 02:01 (UTC) by doctorzeus)
Don't know if this is package specific (will delete if I find its not) but since the update to 15.0.2000.5 sqlagent refuses to start with:
SQL Server does not accept the connection (error: 11001). Waiting for Sql Server to allow connections. Operation attempted was: Verify Connection On Start.
The agent makes several attempts and finally gives up with the error:
SQLServer Error: 11001, TCP Provider: No such host is known. [SQLSTATE 08001]
Might be to do with the upgrade from 2017 to 2019.
countercraft commented on 2020-01-06 16:07 (UTC)
@pickfire yes, the config and settings scripts still target Python 2.
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