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?
Can't connect to DB (Mageia system)
Re: Can't connect to DB (Mageia system)
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
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 Ryzen 3 3200G, 6 atsc tuners. FE's-GF8200's Athlon II, Ryzen 3 2200G. Mythtv user since 2005.
-
- Senior
- Posts: 155
- Joined: Sun Jun 15, 2014 1:08 am
Re: Can't connect to DB (Mageia system)
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.
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)
@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.
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.