| 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.096218 |
| First Submitted: | 2016-11-17 09:25 (UTC) |
| Last Updated: | 2024-08-12 02:03 (UTC) |
After install I had to create manually user by "useradd mssql".
After creating user there were warning which was not visible before this install: [sss_cache] [confdb_get_domains] (0x0010): No domains configured, fatal error! [sss_cache] [confdb_get_domains] (0x0010): No domains configured, fatal error!
These problems I believe apeeared in last month, before that whole installation worked
@JimMoen Not out of date, rolling release in core of libldap causes mssql to fail to start.
@DevProd Did you force update libldap? Mssql will fail to start it it can't find libldap-2.4.so.2 ..
i got this error
mssql-server.service - Microsoft SQL Server Database Engine Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Sat 2022-01-29 15:31:25 CET; 38min ago Docs: https://docs.microsoft.com/en-us/sql/linux Process: 94088 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=217/USER) Main PID: 94088 (code=exited, status=217/USER) CPU: 2ms
Jan 29 15:31:25 devarch systemd[1]: mssql-server.service: Scheduled restart job, restart counter is at 3. Jan 29 15:31:25 devarch systemd[1]: Stopped Microsoft SQL Server Database Engine. Jan 29 15:31:25 devarch systemd[1]: mssql-server.service: Start request repeated too quickly. Jan 29 15:31:25 devarch systemd[1]: mssql-server.service: Failed with result 'exit-code'. Jan 29 15:31:25 devarch systemd[1]: Failed to start Microsoft SQL Server Database Engine.
Ok so you have to have libldap24 from the AUR to get this to build currently.
The current libldap is 2.6 in the repos
I have removed python2-configparser as a dependency as it has been removed from the official repos and it seems to install and run just fine without it and doesn't seem to be a required dependency anymore..
Possibly it was bundled into python2 (maybe someone can enlighten me on this?).
What happened to python2-configparser and python2-backports?
@doctorzeus: thank you, however I already have last libldap update and can't downgrade because of other packages.
@fishnet37222 and @kvasthval: Yes, I think the better solution right now is actually getting libldap24. Changed dep in PKGBUILD and got it working, thanks.
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