On Fri, 2024-02-16 at 00:44 -0500, Ken Wright via discuss wrote:
On Fri, 2024-02-16 at 14:44 +1100, Daniel Black via discuss wrote:
Hi Ken,
Under what group heading are you adding log-bin? Something like [mariadb]?
Just checked. The heading is [mysqld]
If you have an explicit error-log file configured? What is the content on the restart.
I see the following error line in journalctl:
[ERROR] mariadbd: File '/var/log/mysql/master-bin.index' not found (Errcode: 13 "Permission denied")
I had to mkdir the /var/log/mysql/ directory, and it's owned by root:root, with write permission only for the owner. Should I chown to a different user?
Bad form, replying to myself. I checked, and tried chowning the /var/log/mysql/ directory to mysql:mysql. Now it works. Thanks for pointing me in the right direction! Ken -- If you ever think international affairs make sense, remember this: because a Serb shot an Austrian in Bosnia, Germany invaded Belgium.