Installing Zentyal-core messes with existing MySQL

[jjdejong@…]

Installing Zentyal-core adds the file /etc/mysql/conf.d/zentyal.cnf. This file causes InnoDB to be turned off, which is a little awkward if I have an InnoDB database already running in MySQL.

Since Zentyal has no native tools yet to manage MySQL, existing set-ups of MySQL should not be broken when intalling Zentyal on an Ubuntu server.

[jamor@…]

Thanks for the report, Jjdejong,

we have disabled InnoDB for optimization but as you say that is not the good solution. We will reimplement this part so InooDB is only disabled if it is not used

[nico9julio@…]

Tested two times:

1- Install Ubuntu Server 12.04 32Bit with LAMP server 2- Install Zentyal 2.3 as described here:  http://trac.zentyal.org/wiki/Documentation/Community/Installation/InstallationGuide#Zentyal2.3packages 3- Only 1 package: zentyal 4- Zentyal works fine 5- MySQL doesn't work anymore:

---

# sudo service mysql start start: Job failed to start

---

# cat /var/log/mysql.err empty # cat /var/log/mysql.log empty

---

# mysqld --verbose mysqld: error while loading shared libraries: libz.so.1: cannot open shared object file: No such file or directory

---

# dmesg

[206214.945123] type=1400 audit(1342104795.752:25): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=4317 comm="apparmor_parser" [206215.049794] type=1400 audit(1342104795.856:26): apparmor="DENIED" operation="open" parent=1 profile="/usr/sbin/mysqld" name="/ro/etc/ld.so.cache" pid=4321 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0 [206215.050105] type=1400 audit(1342104795.856:27): apparmor="DENIED" operation="open" parent=1 profile="/usr/sbin/mysqld" name="/ro/lib/i386-linux-gnu/libz.so.1.2.3.4" pid=4321 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0 [206215.066815] init: mysql main process (4321) terminated with status 127 [206215.066908] init: mysql main process ended, respawning [206215.193643] init: mysql post-start process (4322) terminated with status 1 [206215.217023] type=1400 audit(1342104796.024:28): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=4336 comm="apparmor_parser" [206215.224871] type=1400 audit(1342104796.032:29): apparmor="DENIED" operation="open" parent=1 profile="/usr/sbin/mysqld" name="/ro/etc/ld.so.cache" pid=4340 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0 [206215.225359] type=1400 audit(1342104796.032:30): apparmor="DENIED" operation="open" parent=1 profile="/usr/sbin/mysqld" name="/ro/lib/i386-linux-gnu/libz.so.1.2.3.4" pid=4340 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0 [206215.227235] init: mysql main process (4340) terminated with status 127 [206215.227342] init: mysql main process ended, respawning [206215.249188] init: mysql post-start process (4341) terminated with status 1 [206215.271249] type=1400 audit(1342104796.076:31): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=4355 comm="apparmor_parser" [206215.279142] type=1400 audit(1342104796.084:32): apparmor="DENIED" operation="open" parent=1 profile="/usr/sbin/mysqld" name="/ro/etc/ld.so.cache" pid=4359 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0 [206215.279645] type=1400 audit(1342104796.084:33): apparmor="DENIED" operation="open" parent=1 profile="/usr/sbin/mysqld" name="/ro/lib/i386-linux-gnu/libz.so.1.2.3.4" pid=4359 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0 [206215.281452] init: mysql main process (4359) terminated with status 127 [206215.281545] init: mysql respawning too fast, stopped [206218.778076] type=1400 audit(1342104799.584:34): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=4376 comm="apparmor_parser" [206218.789684] init: mysql main process (4380) terminated with status 127 [206218.789796] init: mysql main process ended, respawning [206218.811688] init: mysql post-start process (4381) terminated with status 1 [206218.843603] init: mysql main process (4399) terminated with status 127 [206218.843708] init: mysql main process ended, respawning [206218.865462] init: mysql post-start process (4400) terminated with status 1 [206218.900549] init: mysql main process (4418) terminated with status 127 [206218.900662] init: mysql respawning too fast, stopped

[jacalvo@…]

This should be fixed with zentyal-core 2.3.22 (it doesn't disable innodb if there are more MySQL databases in the system).

Note that if you upgrade it won't be fixed, you will have to edit /etc/mysql/conf.d/zentyal.cnf by hand.