2013-02-27 08:41:56 |
Roman Yepishev |
description |
STR:
1. Install mysql-server.
2. start mysql
3. Look into /var/log/syslog
Expected results:
Feb 27 08:13:49 sabre mysqld: 130227 8:13:49 [Note] /usr/sbin/mysqld: ready for connections.
Feb 27 08:13:49 sabre mysqld: Version: '5.5.29-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
Actual results:
Only lines from debian-start are visible.
The reason for that is that upstart job calls /usr/sbin/mysqld and not /usr/bin/mysqld_safe which sets up various bits and pieces including the logger process. So no logs are sent to syslog from mysql on Ubuntu 12.04 where MySQL is configured to log to syslog via /etc/mysql/conf.d/mysqld_safe_syslog.cnf by default.
In my case it prevents configuration of X509 client certificate checks because "X509 issuer mismatch: should be 'C=IL, O=StartCom Ltd., OU=Secure Digital Certificate Signing, CN=StartCom Class 1 Primary Intermediate Server CA' but is '/C=IL/O=StartCom Ltd./OU=Secure Digital Certificate Signing/CN=StartCom Class 1 Primary Intermediate Server CA'" message is never seen in the logs and this is important because of http://bugs.mysql.com/bug.php?id=59376 where RDN should be in specific order.
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: mysql-server 5.5.29-0ubuntu0.12.04.1
ProcVersionSignature: Ubuntu 3.2.0-38.60-generic-pae 3.2.37
Uname: Linux 3.2.0-38-generic-pae i686
ApportVersion: 2.0.1-0ubuntu17.1
Architecture: i386
Date: Wed Feb 27 08:14:52 2013
InstallationMedia: Ubuntu-Server 12.04 LTS "Precise Pangolin" - Release i386 (20120424.1)
Logs.var.log.daemon.log:
Logs.var.log.kern.log:
Feb 27 06:58:38 sabre-clone kernel: [76625.775253] type=1400 audit(1361948318.496:20): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=6597 comm="apparmor_parser"
Feb 27 06:59:41 sabre-clone kernel: [76688.595429] type=1400 audit(1361948381.316:21): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=6799 comm="apparmor_parser"
Feb 27 07:13:38 sabre-clone kernel: [77525.967644] type=1400 audit(1361949218.688:22): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=7130 comm="apparmor_parser"
MarkForUpload: True
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
[mysqld_safe]
syslog
MySQLVarLibDirListing: ['mysql_upgrade_info', 'performance_schema', 'debian-5.5.flag', 'test', 'ib_logfile0', 'ib_logfile1', 'mysql', 'ibdata1', 'rtginua6_wp1']
PackageArchitecture: all
SourcePackage: mysql-5.5
UpgradeStatus: No upgrade log present (probably fresh install) |
STR:
1. Install mysql-server.
2. start mysql
3. Look into /var/log/syslog
Expected results:
Feb 27 08:13:49 sabre mysqld: 130227 8:13:49 [Note] /usr/sbin/mysqld: ready for connections.
Feb 27 08:13:49 sabre mysqld: Version: '5.5.29-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
Actual results:
Only lines from debian-start are visible.
The reason for that is that upstart job calls /usr/sbin/mysqld and not /usr/bin/mysqld_safe which sets up various bits and pieces including the logger process. So no logs are sent to syslog from mysql on Ubuntu 12.04 where MySQL is configured to log to syslog via /etc/mysql/conf.d/mysqld_safe_syslog.cnf by default.
In my case it prevents configuration of X509 client certificate checks because "X509 issuer mismatch: should be 'C=IL, O=StartCom Ltd., OU=Secure Digital Certificate Signing, CN=StartCom Class 1 Primary Intermediate Server CA' but is '/C=IL/O=StartCom Ltd./OU=Secure Digital Certificate Signing/CN=StartCom Class 1 Primary Intermediate Server CA'" message is never seen in the logs and this is important because of http://bugs.mysql.com/bug.php?id=59376 where RDN should be in specific order.
WORKAROUND:
Create /etc/init/mysql.override with the following contents:
exec /usr/bin/mysqld_safe
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: mysql-server 5.5.29-0ubuntu0.12.04.1
ProcVersionSignature: Ubuntu 3.2.0-38.60-generic-pae 3.2.37
Uname: Linux 3.2.0-38-generic-pae i686
ApportVersion: 2.0.1-0ubuntu17.1
Architecture: i386
Date: Wed Feb 27 08:14:52 2013
InstallationMedia: Ubuntu-Server 12.04 LTS "Precise Pangolin" - Release i386 (20120424.1)
Logs.var.log.daemon.log:
Logs.var.log.kern.log:
Feb 27 06:58:38 sabre-clone kernel: [76625.775253] type=1400 audit(1361948318.496:20): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=6597 comm="apparmor_parser"
Feb 27 06:59:41 sabre-clone kernel: [76688.595429] type=1400 audit(1361948381.316:21): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=6799 comm="apparmor_parser"
Feb 27 07:13:38 sabre-clone kernel: [77525.967644] type=1400 audit(1361949218.688:22): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=7130 comm="apparmor_parser"
MarkForUpload: True
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
[mysqld_safe]
syslog
MySQLVarLibDirListing: ['mysql_upgrade_info', 'performance_schema', 'debian-5.5.flag', 'test', 'ib_logfile0', 'ib_logfile1', 'mysql', 'ibdata1', 'rtginua6_wp1']
PackageArchitecture: all
SourcePackage: mysql-5.5
UpgradeStatus: No upgrade log present (probably fresh install) |
|