After an update from 0.22 to 0.23, i have this problem on the MD's.
root@moon130:~# apt-get dist-upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0B of additional disk space will be used.
Do you want to continue [Y/n]?
Setting up mythtv-database (0.23-0.1) ...
Failed to execute SQL: GRANT ALL PRIVILEGES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY '3zRkyO86'\nAccess denied for user 'root'@'192.168.80.4' to database 'mythconverg' at -e line 8, <> line 1.
dpkg: error processing mythtv-database (--configure):
subprocess post-installation script returned error exit status 255
Errors were encountered while processing:
mythtv-database
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@moon130:~#
Is there a solution ?
Remove and reinstall Mythtv on the MD's don't resolve this.
Greetings,
Philippe
Quote from: pga57 on May 27, 2010, 08:55:15 PM
After an update from 0.22 to 0.23, i have this problem on the MD's.
root@moon130:~# apt-get dist-upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0B of additional disk space will be used.
Do you want to continue [Y/n]?
Setting up mythtv-database (0.23-0.1) ...
Failed to execute SQL: GRANT ALL PRIVILEGES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY '3zRkyO86'\nAccess denied for user 'root'@'192.168.80.4' to database 'mythconverg' at -e line 8, <> line 1.
dpkg: error processing mythtv-database (--configure):
subprocess post-installation script returned error exit status 255
Errors were encountered while processing:
mythtv-database
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@moon130:~#
Is there a solution ?
Remove and reinstall Mythtv on the MD's don't resolve this.
Greetings,
Philippe
Hi..
I had this problem to.
I had to rebuild my system and that is not really the nice thing..
So what you can do is try to rebuild the MD image. From the Webmin
this will take some time but could you please try it so we can see if this is a work around.
Thanks
C
Quote from: pga57 on May 27, 2010, 08:55:15 PM[..]
Failed to execute SQL: GRANT ALL PRIVILEGES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY '3zRkyO86'\nAccess denied for user 'root'@'192.168.80.4' to database 'mythconverg' at -e line 8, <> line 1.
[..]
That query looks (to me) like it should have only been run on the Core. Then again I'm not that familiar with MythTV.
I don't think so cause there is a backend on every MD..
I am also not 100%
C
Looks like this will take care of it
mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('YourPasswordHere') WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
dpkg-reconfigure --force mythtv-database
worked for me on a MD
HTH
Tim
No success after your suggestion Tim.
I have set a empty password for root on the MD mysql and when I run the dpkg-reconfigure --force mythtv-database:
root@moon130:~# dpkg-reconfigure --force mythtv-database
Failed to execute SQL: GRANT ALL PRIVILEGES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY '3zRkyO86'\nAccess denied for user 'root'@'192.168.80.4' to database 'mythconverg' at -e line 8, <> line 1.
I've not this error when I updated the Core, only the MDs.
I will try to rebuild the MD image and see what's append....
Thank's all of you for your suggestions !
Philippe
Try
Edit the postinst script
nano /var/lib/dpkg/info/mythtv-database.postinst
rem lines 47 and 49 by putting a # at the front of the line
and rerun reconfigure
HTH
Tim
Same result Tim:
root@moon130:~# dpkg-reconfigure --force mythtv-database
Failed to execute SQL: GRANT ALL PRIVILEGES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY '3zRkyO86'\nAccess denied for user 'root'@'192.168.80.4' to database 'mythconverg' at -e line 8, <> line 1.