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

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

Moderator: Forum Moderators

Post Reply
raydude
Newcomer
Posts: 4
Joined: Sat Sep 02, 2017 8:08 pm
United States of America

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

Post by raydude » Sat Sep 22, 2018 6:28 pm

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?
Last edited by Steve Goodey on Sun Sep 23, 2018 6:57 am, edited 1 time in total.
Reason: Added (Solved) to Title.

User avatar
pgbennett
Developer
Posts: 250
Joined: Mon Apr 27, 2015 5:41 pm
United States of America

Re: Upgrade to 29.1 from 28.1 not going so well.

Post by pgbennett » Sat Sep 22, 2018 9:12 pm

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

raydude
Newcomer
Posts: 4
Joined: Sat Sep 02, 2017 8:08 pm
United States of America

Re: Upgrade to 29.1 from 28.1 not going so well.

Post by raydude » Sat Sep 22, 2018 11:09 pm

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";

Post Reply