Vojtěch Zeisek wrote:
Dne Ne 13. dubna 2014 13:26:35, Per Jessen napsal(a):
Vojtěch Zeisek wrote:
Dne Ne 13. dubna 2014 11:01:46, Per Jessen napsal(a):
Vojtěch Zeisek wrote:
Hi, after upgrade of our server to 13.1 I finally decided to switch from MySQL to MariaDB. I uninstalled MySQL packages and installed MariaDB. No problem, it works fine, including automysqlbackup and other tools. I just wonder how to start the DB automatically during computer boot.
I've been using mariadb for nearly twop years I think, auto-start works exactly as for mysql.
It doesn't for me. :-(
Okay, then we should investigate why it doesn't work. You know, look at log messages, systemctl output etc. I'm running mariadb on 12.3, not 13.1, but given that the init-script was not converted to a systemd unit yet, there should be no major difference.
What does "systemctl status mysql.service" tell you when a start has failed?
Nothing.
No output from "systemctl status mysql.service" at all?? On a successful start, this is mine: # systemctl status mysql.service mysql.service - LSB: Start the MySQL database server Loaded: loaded (/etc/init.d/mysql) Active: active (running) since Thu, 2014-04-10 09:37:27 CEST; 3 days ago Process: 17719 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS) CGroup: name=systemd:/system/mysql.service 17801 /bin/sh /usr/bin/mysqld_safe --mysqld=mysqld --user=mysql --pid-file=/var/run/mysql/mysqld.pid --socket=/var/run/mysql/mysql.sock --datadir=/srv/mysql 18192 /usr/sbin/mysqld --basedir=/usr --datadir=/srv/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/mysqld.log --pid-file=/var/run/mysql/mysqld.pid --socket=/var/run/mysql/mysql.... Apr 10 09:37:22 adenauer systemd[1]: Starting LSB: Start the MySQL database server... Apr 10 09:37:27 adenauer mysql[17719]: Starting service MySQL ..done Apr 10 09:37:27 adenauer systemd[1]: Started LSB: Start the MySQL database server.
When I use systemctl start mysql.service it starts as expected, so that there is IMHO no reason to other complains than those written by systemctl enable mysql.service... There is no error in MySQL logs. V.
No, your mysql setup is clearly working, so it's a systemd/startup issue. Is mysql enabled in sysvinit? "chkconfg mysql" ? If not, enable it. Maybe "systemctl enable mysql" did not in fact enable it, even if it said so. -- Per Jessen, Zürich (16.4°C) http://www.dns24.ch/ - your free DNS host, made in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org