[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