[mythtv-users] Mythfrontend doesn't update database to new schema

James Pifer jep at obrien-pifer.com
Tue Aug 2 15:46:56 UTC 2011


> This likely means that the user mythtv at 192.168.1.0/255.255.255.0 does 
> not have proper permissions granted.  Specifically, this operation 
> requires the ALTER privilege, but you need to GRANT ALL for the mythtv 
> user(s) to handle operations needed by other parts of MythTV.  See 
> http://www.mythtv.org/docs/mythtv-HOWTO-6.html#modify_perm_mysql .  And 
> note that depending on how your distro does things, you may need to use 
> a different password (the 'identified by "mythtv"' part), and it seems 
> some distros have broken MySQL somehow such that the grants don't work 
> properly, and you have to follow the given lines with a SET PASSWORD...  
> Something like:
> 
> SET PASSWORD FOR 'mythtv'@'192.168.1.%' = PASSWORD('mythtv');
> 
> Note, also, you really want to have only one entry per host.  So, you 
> may want to check your mysql.user table to verify that you're not 
> "shadowing" existing entries.
> 
> Mike

If I look at mysql.users there are multiple rows for mythtv, so I'm not
sure if that confirms I'm not shadowing?

I did a grant all. Specifically, to cover all bases I did this:

MariaDB [mythconverg]> GRANT ALL ON mythconverg TO mythtv@'192.168.1.0/255.255.255.0' IDENTIFIED BY 'mythtv';
Query OK, 0 rows affected (0.00 sec)

MariaDB [mythconverg]> SET PASSWORD FOR 'mythtv'@'192.168.1.0/255.255.255.0' = PASSWORD('mythtv');
Query OK, 0 rows affected (0.00 sec)

MariaDB [mythconverg]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

MariaDB [mythconverg]> GRANT ALL ON mythconverg TO mythtv@'192.168.1.%' IDENTIFIED BY 'mythtv';
Query OK, 0 rows affected (0.00 sec)

MariaDB [mythconverg]> SET PASSWORD FOR 'mythtv'@'192.168.1.%' = PASSWORD('mythtv');
Query OK, 0 rows affected (0.00 sec)

MariaDB [mythconverg]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)


I still get the same thing when I try to start the frontend. What did I
miss?

2011-08-02 11:42:36.501 Connected to database 'mythconverg' at host: 192.168.1.17
2011-08-02 11:42:36.503 Upgrading to MythTV schema version 1226
2011-08-02 11:42:36.504 DB Error (Performing database upgrade): 
Query was: ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8; 
Error was: Driver error was [2/1044]:
QMYSQL: Unable to execute query
Database error was:
Access denied for user 'mythtv'@'192.168.1.0/255.255.255.0' to database 'mythconverg'
 
new version: 1226
2011-08-02 11:42:36.505 Deleting UPnP client...

Thanks,
James



More information about the mythtv-users mailing list