Hi Ken, This happens because the `/var/log/mysql` directory is in principle for error and slow logs, binary logs usually go under `/var/lib/mysql` or whatever the datadir is. You can configure a separate dir in some specific cases, but in most cases you can just specify: `log-bin` in the config without any arguments and it will create the binary logs in your datadir.
Hope that helps. -GL Le sam. 17 févr. 2024 à 03:42, Ken Wright via discuss < [email protected]> a écrit : > 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. > _______________________________________________ > discuss mailing list -- [email protected] > To unsubscribe send an email to [email protected] >
_______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
