[Bug 803040] New: mysqld: File '/var/log/mysql/general.log' not found (Errcode: 13)
https://bugzilla.novell.com/show_bug.cgi?id=803040 https://bugzilla.novell.com/show_bug.cgi?id=803040#c0 Summary: mysqld: File '/var/log/mysql/general.log' not found (Errcode: 13) Classification: openSUSE Product: openSUSE 12.1 Version: Final Platform: x86-64 OS/Version: openSUSE 12.1 Status: NEW Severity: Normal Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: laurent.henry@ehess.fr QAContact: qa-bugs@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; fr; rv:1.9.1.10) Gecko/20100506 SUSE/3.5.10-0.1 Firefox/3.5.10 Doing a mysql restart, i find in /var/log/mysql/mysqld.log that the general.log file have a problem. 130211 10:59:28 Percona XtraDB (http://www.percona.com) 1.0.17-14.1 started; log sequence number 136415360 130211 10:59:28 [ERROR] mysqld: File '/var/log/mysql/general.log' not found (Errcode: 13) 130211 10:59:28 [ERROR] Could not use /var/log/mysql/general.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. 130211 10:59:28 [Note] Event Scheduler: Loaded 0 events 130211 10:59:28 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.2.13-MariaDB-log' socket: '/var/run/mysql/mysql.sock' port: 3306 SUSE MySQL RPM The general.log exists but seems never used since the installation of the server: # l /var/log/mysql/ total 668 drw-rw---- 2 root root 4096 3 déc. 23:45 ./ drwxr-xr-x 15 root root 4096 11 févr. 11:03 ../ -rw-rw---- 1 mysql mysql 0 27 juil. 2012 general.log -rw-rw---- 1 mysql mysql 2356 11 févr. 10:59 mysqld.log Thinking of a permission problem i try this: # sudo -u mysql ls /var/log/mysql/general.log ls: impossible d'accéder à /var/log/mysql/general.log: Permission non accordée In french, it means there is something wrong with permissions. trying to chmod "." with mysql:mysql doesn't change a thing. Changing destination in my.cnf to /tmp/general.log works anyway. I did not change anything there since the initial install. (i had to troubleshoot this because of an update which crashed mysql. If general could not be written, mysqld shutdowned automatically) Reproducible: Always Steps to Reproduce: 1./etc/init.d/mysqld restart 2.watch /var/log/mysql/mysqld.log 3. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=803040
https://bugzilla.novell.com/show_bug.cgi?id=803040#c1
Christian Boltz
drw-rw---- 2 root root 4096 3 déc. 23:45 ./
That's two problems in one: - owner and group should by "mysql" - missing x permissions, so there's no chance to enter the directory (chmod +x should help) -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=803040
https://bugzilla.novell.com/show_bug.cgi?id=803040#c
Swamp Workflow Management
https://bugzilla.novell.com/show_bug.cgi?id=803040
https://bugzilla.novell.com/show_bug.cgi?id=803040#c
Swamp Workflow Management
https://bugzilla.novell.com/show_bug.cgi?id=803040
https://bugzilla.novell.com/show_bug.cgi?id=803040#c3
--- Comment #3 from Swamp Workflow Management
https://bugzilla.novell.com/show_bug.cgi?id=803040
https://bugzilla.novell.com/show_bug.cgi?id=803040#c
Swamp Workflow Management
https://bugzilla.novell.com/show_bug.cgi?id=803040
https://bugzilla.novell.com/show_bug.cgi?id=803040#c4
Marcus Meissner
https://bugzilla.novell.com/show_bug.cgi?id=803040
https://bugzilla.novell.com/show_bug.cgi?id=803040#c5
Swamp Workflow Management
https://bugzilla.novell.com/show_bug.cgi?id=803040
https://bugzilla.novell.com/show_bug.cgi?id=803040#c
Swamp Workflow Management
https://bugzilla.novell.com/show_bug.cgi?id=803040
https://bugzilla.novell.com/show_bug.cgi?id=803040#c7
Swamp Workflow Management
https://bugzilla.novell.com/show_bug.cgi?id=803040
https://bugzilla.novell.com/show_bug.cgi?id=803040#c
Swamp Workflow Management
participants (1)
-
bugzilla_noreply@novell.com