Public bug reported:

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)

** Affects: mysql-5.5 (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: apport-bug i386 precise

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1134081

Title:
  Not logging to syslog even though configured to by default

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1134081/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to