Author Topic: Mythtv don't work on MD's after an update to 0.23  (Read 5477 times)

pga57

  • Veteran
  • ***
  • Posts: 145
    • View Profile
Mythtv don't work on MD's after an update to 0.23
« 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.

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

  • Veteran
  • ***
  • Posts: 136
  • SSDD
    • View Profile
Re: Mythtv don't work on MD's after an update to 0.23
« Reply #1 on: May 27, 2010, 11:13:14 pm »
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

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 2256
  • Department of Redundancy Department.
    • View Profile
Re: Mythtv don't work on MD's after an update to 0.23
« Reply #2 on: May 28, 2010, 01:03:19 am »
[..]
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.
"Change is inevitable. Progress is optional."
-- Anonymous


fastie81

  • Veteran
  • ***
  • Posts: 136
  • SSDD
    • View Profile
Re: Mythtv don't work on MD's after an update to 0.23
« Reply #3 on: May 28, 2010, 01:15:21 am »
I don't think so cause there is a backend on every MD..
I am also not 100%
C

tkmedia

  • wants to work for LinuxMCE
  • **
  • Posts: 937
    • View Profile
    • LMCECompatible
Re: Mythtv don't work on MD's after an update to 0.23
« Reply #4 on: May 28, 2010, 05:32:19 am »
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
My Setup http://wiki.linuxmce.org/index.php/User:Tkmedia

For LinuxMce compatible  systems and accessories
http://lmcecompatible.com/

pga57

  • Veteran
  • ***
  • Posts: 145
    • View Profile
Re: Mythtv don't work on MD's after an update to 0.23
« Reply #5 on: May 28, 2010, 07:35:55 am »
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

  • wants to work for LinuxMCE
  • **
  • Posts: 937
    • View Profile
    • LMCECompatible
Re: Mythtv don't work on MD's after an update to 0.23
« Reply #6 on: May 28, 2010, 05:13:49 pm »
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

My Setup http://wiki.linuxmce.org/index.php/User:Tkmedia

For LinuxMce compatible  systems and accessories
http://lmcecompatible.com/

pga57

  • Veteran
  • ***
  • Posts: 145
    • View Profile
Re: Mythtv don't work on MD's after an update to 0.23
« Reply #7 on: May 28, 2010, 06:01:38 pm »
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.