New subject: [Bug 803040] mysqld: File '/var/log/mysql/general.log' not found (Errcode: 13)

11 Feb 2013

      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.

[Bug 803040] New: mysqld: File '/var/log/mysql/general.log' not found (Errcode: 13)

bugzilla_noreply＠novell.com

bugzilla_noreply＠novell.com

bugzilla_noreply＠novell.com

bugzilla_noreply＠novell.com

bugzilla_noreply＠novell.com

bugzilla_noreply＠novell.com

bugzilla_noreply＠novell.com

bugzilla_noreply＠novell.com

bugzilla_noreply＠novell.com

bugzilla_noreply＠novell.com

bugzilla_noreply＠novell.com

tags

participants (1)