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 <discuss@lists.mariadb.org> 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 -- discuss@lists.mariadb.org
To unsubscribe send an email to discuss-leave@lists.mariadb.org