** 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
