** Description changed: 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" + 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 + [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)
-- 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
