Running Ubuntu 20.04.
It all started when my cable company switched my cable modem. All my LAN IPs changed from 192.168... to 10.200.... I updated the /etc/hosts files and replaced "192.168.1.%" with "10.200.1.%" in the users->Hosts table in mysql. The command 'mysql -h localhost -u mythtv -p` gets me into the database on the mythbackend server. BUT the backend refuses to start. It says "Waiting for database to start" (or words to that effect). In Setup, the database hostname is "localhost" which hasn't changed.
What the heck am I missing?
[Solved] Backend won't start - waiting for database
Moderator: Forum Moderators
[Solved] Backend won't start - waiting for database
Last edited by BillK on Thu Oct 28, 2021 4:02 pm, edited 1 time in total.
Re: Backend won't start - waiting for database
I'd start by looking at bind-address
Then see if the GRANT options are OK (should be for localhost).
Verify that in ~mythtv/.mythtv/config.xml, the <Host> is set to localhost.
Test, without MythTV with: mysql --user=mythtv --host=localhost --password mythconverg
Your password from config.xml.
Code: Select all
cat /etc/mysql/mysql.conf.d/mythtv.cnf
[mysqld]
bind-address=::
Verify that in ~mythtv/.mythtv/config.xml, the <Host> is set to localhost.
Test, without MythTV with: mysql --user=mythtv --host=localhost --password mythconverg
Your password from config.xml.
Re: Backend won't start - waiting for database
I need to make a correction to my original post. The backend was running, the frontend couldn't connect to it.
I finally got it connected by running mythtv-setup -> General -> Host Address Backend Setup -> Primary Address/DNS Name which was set to 127.0.0.1. I changed it to the 10.200... address of the server and everything worked.
I finally got it connected by running mythtv-setup -> General -> Host Address Backend Setup -> Primary Address/DNS Name which was set to 127.0.0.1. I changed it to the 10.200... address of the server and everything worked.