Page 2 of 2

Re: Can't connect to DB (Mageia system)

Posted: Thu Oct 17, 2019 4:11 am
by bill6502
Let's concentrate on the: ss -n -o 'sport = :mysql' results. It suggests that MariaDB isn't running.

Does: systemctl status mysqld.service still show it running?

Re: Can't connect to DB (Mageia system)

Posted: Thu Oct 17, 2019 6:40 am
by wesnewell
Leave the d off.

wes@mythfe0:~$ systemctl status mysql
‚óŹ mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Fri 2019-10-11 23:56:20 CDT; 5 days ago

Re: Can't connect to DB (Mageia system)

Posted: Thu Oct 17, 2019 7:09 am
by blm-ubunet
The OP early posts show database server running & user interacting via the cmd line.
MythTV logs show database server running initially & then disappearing

One possible explanation is that dB server crashes because of mythtv.

I would tail the systemd journal logs while starting backend or mythtv-setup from another terminal.

Re: Can't connect to DB (Mageia system)

Posted: Thu Oct 17, 2019 2:06 pm
by bill6502
@wesnewell, fun fact: the service likely has an Alias in the [Install] section.
Try: systemctl show --property=Names mariadb.service. It may be necessary
to disable/enable the service to create the symlinks though (I had to.)

@anp66, @blm-ubunet is spot on, and journalctl --unit mariadb limits the output to the service
of interest (Aliases don't work with journalctl.) Also, cat /var/log/mysql/error.log may have more
information.