Hello,
I need some help enabling the PAL logging on the July CUs (2022-CU26 and 2025-CU7) because the method described in https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-ad-auth-troubleshooting?view=sql-server-ver17 doesn't seem to work any more.
Neither of the logger.ini files that I tried (see bellow) produce a log file, even after restarting the engine. But strace shows the engine opens the file successfully.
The original from the official doc no longer works (the Windows authentication on the same server works):
[Output:security]
Type = File
Filename = /var/opt/mssql/log/security.log
[Logger]
Level = Silent
[Logger:security.kerberos]
Level = Debug
Outputs = security
[Logger:security.ldap]
Level = debug
Outputs = security
Thought that maybe the logger IDs have changed, but that doesn't work either:
[Output:all]
Type = File
Filename = /var/opt/mssql/log/all.log
[Logger]
Level = Debug
Outputs = all
Neither of my attempts with relative filename succeeded:
Filename = log/all.log
Filename = all.log
Hello,
I need some help enabling the PAL logging on the July CUs (2022-CU26 and 2025-CU7) because the method described in https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-ad-auth-troubleshooting?view=sql-server-ver17 doesn't seem to work any more.
Neither of the logger.ini files that I tried (see bellow) produce a log file, even after restarting the engine. But strace shows the engine opens the file successfully.
The original from the official doc no longer works (the Windows authentication on the same server works):
Thought that maybe the logger IDs have changed, but that doesn't work either:
Neither of my attempts with relative filename succeeded: