[Solved] Backend won't start - waiting for database

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
BillK
Senior
Posts: 129
Joined: Tue Dec 09, 2014 9:49 pm
United States of America

[Solved] Backend won't start - waiting for database

Post by BillK »

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?
Last edited by BillK on Thu Oct 28, 2021 4:02 pm, edited 1 time in total.
User avatar
bill6502
Developer
Posts: 2307
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Backend won't start - waiting for database

Post by bill6502 »

I'd start by looking at bind-address

Code: Select all

 cat /etc/mysql/mysql.conf.d/mythtv.cnf 
[mysqld]
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.
BillK
Senior
Posts: 129
Joined: Tue Dec 09, 2014 9:49 pm
United States of America

Re: Backend won't start - waiting for database

Post by BillK »

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.
Post Reply