Greetings! I'm trying to set up a backup email server using Ubuntu 23.10 Server. I want to replicate my MariaDB databases from the primary email server to the secondary, but whenever I add the line log-bin = /var/log/mysql/master-bin to /etc/mysql/mariadb.conf.d/50-server.cnf MariaDB fails to restart. I've looked for help online, but haven't had any luck. Can anyone help? Further details available on request. Ken -- If you ever think international affairs make sense, remember this: because a Serb shot an Austrian in Bosnia, Germany invaded Belgium.
Hi Ken, Under what group heading are you adding log-bin? Something like [mariadb]? If you have an explicit error-log file configured? What is the content on the restart. Otherwise journalctl -n 50 -u mariadb.service should contain the required information to resolve this. On Fri, 16 Feb 2024 at 13:05, Ken Wright via discuss <discuss@lists.mariadb.org> wrote:
Greetings!
I'm trying to set up a backup email server using Ubuntu 23.10 Server. I want to replicate my MariaDB databases from the primary email server to the secondary, but whenever I add the line
log-bin = /var/log/mysql/master-bin
to /etc/mysql/mariadb.conf.d/50-server.cnf MariaDB fails to restart. I've looked for help online, but haven't had any luck. Can anyone help? Further details available on request.
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
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? Ken -- If you ever think international affairs make sense, remember this: because a Serb shot an Austrian in Bosnia, Germany invaded Belgium.
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.
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
participants (3)
-
Daniel Black -
Guillaume Lefranc -
Ken Wright