SQL Server set up on Asahi Linux Remix Fedora 40

Our Neighbors Asahi Linux Ask Asahi
, , ,
1

I need help installing SQL Server using Docker on my Asahi Linux machine. It’s not working, and I keep getting an Exit(1) error when I try to run SQL Server. I’ve spent two days trying to figure it out, but I haven’t had any success. Thank you very much for your assistance!

I checked in logs and tried to follow some instructions on the internet but still not ok:
2024/09/26 13:31:49 [launchpadd] INFO: Extensibility Log Header:
2024/09/26 13:31:49 [launchpadd] WARNING: Failed to load /var/opt/mssql/mssql.conf ini file with error open /var/opt/mssql/mssql.conf: no such file or directory
2024/09/26 13:31:49 [launchpadd] INFO: DataDirectories = /bin:/etc:/lib:/lib32:/lib64:/sbin:/usr/bin:/usr/include:/usr/lib:/usr/lib32:/usr/lib64:/usr/libexec/gcc:/usr/sbin:/usr/share:/var/lib:/opt/microsoft:/opt/mssql-extensibility:/opt/mssql/mlservices:/opt/mssql/lib/zulu-jre-11:/opt/mssql-tools
: Unsupported system page size
: Unsupported system page size
: Unsupported system page size
…

2

My guess is that asahi and the mac hatdware is using a 16k page size and that is the issue. If that is correct you need a fix to the sql server to support 16k pages I assume.

3

Added asahi

4

I tried to search but failed to find a way to make the sql server to support 16k pages. Could you recommend some posts that con fix the problems?

5

From Ask Fedora to Ask Asahi

6

SQL Server is not opensource, so this isn’t something you can fix yourself. Your options are to either get the vendor to port SQL Server to 16k page-size systems, or to run it inside a VM (e.g. using libvirt) with a 4k page-size kernel. If you report this to the vendor, please add a reference to Broken Software · AsahiLinux/docs Wiki · GitHub so we can track it.

7

I assume that you must use Microsoft SQL Server for our job?
Otherwise I would suggest you use postgreql instead.