[mythtv-users] Ver 31 frontend cannot connect to the database
keemllib at gmail.com
Tue Nov 24 01:25:53 UTC 2020
On 11/23/20 6:57 PM, Mike Carron wrote:
> I've gone over everything and I have to conclude that port 3306 on the
> backend being closed is the culprit. Since mythfrontend wants to use
> port 3306 to communicate with the backend I'm not going to get anywhere
> until port 3306 is opened. Unfortunately I do not know how to do that.
> How do I open port 3306?
The SQL server will open the port. The default is 3306.
Do this, command and output please:
sudo grep --recursive --ignore "port.*=" /etc/mysql
I can't agree with your assumption though. Need the fresh
command and output of this:
mysql --host=192.168.0.222 --user=mythtv --password=<from config.xml>
The reset time to live output of nmap is unusual:
PORT STATE SERVICE REASON
3306/tcp closed mysql reset ttl 64
I'm wondering if the SQL server is failing and restarting. Full output of
systemctl status mysql # or mysqld or mariadb, I forgot which works for you
More information about the mythtv-users