On 05/24/2017 02:24 PM, cisaksen wrote:[color=blue]
I’m finally getting around to using the systemd version of mariadb and
having trouble getting the database to start.
Past/background: Starting with 12 sp1 suse went from a init.d script to
systemd to run mariadb. Well that didn’t work to well for as we had
many DB servers running multiple instances and the systemd didn’t handle
it well. So what we did was:
- add “.off” to the service files in /usr/lib/systemd/system
- copy the init.d script from 12 sp0 to /etc/init.d
- then run systemctl daemon-reload.
This has worked for every DB server we had.
Now every time there’s an update to mariadb we have had to do this
process. I’m trying to get away from it but i’m running into this
Yes, this is expected; do not touch files you do not own under
/usr/lib/systemd/system as those are package-owned and will be replaced.
They’re not configuration files; they’re default service unit files.
Treat them like non-configuration files.
But you want to change them, you say? That’s fine: copy them to
/etc/systemd/system and then modify them there. This is the place you
override the default service unit files. Alternatively, depending on the
changes, you can create drop-in files that only override certain parts of
the originals. Once you create these alternatives under
/etc/systemd/system and reload the daemon (as you have already figured out
to do) you’ll see the systemctl command show the files actually used, so
that’s helpful to see what is being used at runtime.
Little more info: the database files are not in the default location
that suse places them. We do use /etc/my.cnf and specify the file
locations in here. That includes the multiple DB instances.
Not sure why it’s not working but after looking at the
mysql-systemd-helper it appears to require that the files be in the
I have no idea about this, but maybe post the contents of the service unit
files in case they have something in them that overrides the my.cnf
somehow, though that seems odd.
Just to be clear, are you using MariaDB from SLES, or did you add it from
an outside source?
If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below.
If you want to send me a private message, please let me know in the
forum as I do not use the web interface often.