Bug #1943 binlog

• Submitted: 25 Nov 2003 4:07
• Modified: 28 Nov 2003 7:18
• Reporter: [ name withheld ]
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0.12-max-log
• OS: Linux (Linux barny 2.4.18-14bigmem #1 S)
• CPU Architecture: Any

[25 Nov 2003 4:07] [ name withheld ]

Description:
Creating/writing binlog is configured in the my.cnf, but doesn´t work!?

How to repeat:
?

[25 Nov 2003 6:10] Guilhem Bichot

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

[26 Nov 2003 6:55] [ name withheld ]

Sorry,
we configured our my.cnf as follow:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-bin=/var/log/mysql
server-id=1

[mysql.server]
user=mysql
basedir=/usr/local/mysql

[safe_mysqld]
err-log=/var/log/mysql/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

but the server doesn´t create binary logs.

[26 Nov 2003 8:24] Guilhem Bichot

You used
log-bin=/var/log/mysql
This will try to create two files:
mysql.001
mysql.index
in /var/log.
In the .err file of mysqld, mysqld tells you why it could not create the files.
Maybe the Unix user which runs mysqld (maybe user 'mysql') does not have permission to create a file in /var/log. For example on my Linux, /var/log is writeable only by root:
drwxr-xr-x   12 root     root         4096 Nov 26 14:41 /var/log/
If it's a permission problem you will see "error 13" in the .err file:
[guilhem@gbichot2 guilhem]$ perror 13
Error code  13:  Permission denied

[27 Nov 2003 1:58] [ name withheld ]

The rights will be checked soon by the admins.
But there is no .err file.

[28 Nov 2003 7:18] Guilhem Bichot

Sorry, I forgot you had configured the name of the error log (which has the .err extension by default). In your case, I meant:
/var/log/mysql/mysqld.log

[8 Dec 2003 0:46] [ name withheld ]

Thanx for your help. We found the "Error code  13:  Permission denied" in the mysld.log. After setting the permissions the binlog is created.