Mythtv don't work on MD's after an update to 0.23

[pga57]

After an update from 0.22 to 0.23, i have this problem on the MD's.

Code: [Select]


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

[fastie81]

After an update from 0.22 to 0.23, i have this problem on the MD's.

Code: [Select]


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

[Zaerc]

[..]

Code: [Select]

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.

[fastie81]

I don't think so cause there is a backend on every MD..
I am also not 100%
C

[tkmedia]

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

[pga57]

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:

Code: [Select]

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

[tkmedia]

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

[pga57]

Same result Tim:

Code: [Select]


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.