(Solved) Upgrade to 29.1 from 28.1 not going so well.

[raydude]

When mythtv tries to open the database it can't connect.

The error message is:

2018-09-22 11:25:50.137385 E [DBManager3] Unable to connect to database!
2018-09-22 11:25:50.137395 E Driver error was [1/1045]:
QMYSQL: Unable to connect
Database error was:
Access denied for user 'mythtv'@'server' (using password: YES)

But the strange thing is: if I run mysql from the command line as root with user=mythtv, pw=mythtv, it works fine.

Any ideas?

[pgbennett]

Check the file $HOME/.mythtv/config.xml to see if the correct user id and password are there.

[raydude]

I solved it myself. The trick was to tell mariadb to enable mythtv the user from the IP address of the server. Apparently localhost is not enough...

Here's the exact commands I used:

GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'SERVER_IP' IDENTIFIED BY 'mythtv' WITH GRANT OPTION;
FLUSH PRIVILEGES;

SERVER_IP is the IP address of your server (192.168.1.whatever for example).

This command was run as a root recently in the past and was not good enough:

grant all on mythconverg.* to mythtv@"%" identified by "mythtv";