Can't connect to DB (Mageia system)

For discussion of topics specific to MythTV on linux
User avatar
bill6502
Developer
Posts: 1377
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

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

Post by bill6502 » Thu Oct 17, 2019 4:11 am

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?

wesnewell
Senior
Posts: 512
Joined: Mon Jun 23, 2014 6:54 pm
Location: Wylie TX, USA
United States of America

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

Post by wesnewell » Thu Oct 17, 2019 6:40 am

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
BE/FE-Asrock AB350 Pro AMD Ryzen 3 2200G, 6 atsc tuners. Frontends-GF8200's,,AMD Athlon II's. Mythtv user since 2005.

blm-ubunet
Junior
Posts: 92
Joined: Sun Jun 15, 2014 1:08 am
Cambodia

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

Post by blm-ubunet » Thu Oct 17, 2019 7:09 am

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.

User avatar
bill6502
Developer
Posts: 1377
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

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

Post by bill6502 » Thu Oct 17, 2019 2:06 pm

@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.

Post Reply