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

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


> Ah, yeah, I'm sure you mean:
> 
> http://www.gossamer-threads.com/lists/mythtv/users/407793#407793
> 
> And, thanks for the reminder...  I need to tell people to /never/ do 
> that with versions > 0.24.
> 
> In this case, though, since you're running MythTV 0.24.x, it was the 
> right approach to fix the problem.  Glad you figured it out.

Hi Mike. I have a new issue which I think is related to the database. If
not I can create a new thread. I installed a new mythfrontend on
opensuse 11.3 so versions are the same as my backend. I've also enabled
mysql access for mythtv user and tested using mysql client. When I start
mythfrontend I get this. Any suggestions?

I googled and found a suggestion of dropping the database again, etc.
I'd rather not now that the backend is working, and the frontend is
working from the backend machine. 

Thanks,
James


2011-08-02 11:03:45.752 mythfrontend version:  [v0.24.1] www.mythtv.org
2011-08-02 11:03:45.753 Using runtime prefix = /usr
2011-08-02 11:03:45.753 Using configuration directory = /home/mythtv/.mythtv
2011-08-02 11:03:45.754 ThreadPool:HTTP: Initial 1, Max 25, Timeout 60000
2011-08-02 11:03:46.233 Empty LocalHostName.
2011-08-02 11:03:46.233 Using localhost value of mythtv-mb
2011-08-02 11:03:46.234 Testing network connectivity to '192.168.1.17'
2011-08-02 11:03:46.393 New DB connection, total: 1
2011-08-02 11:03:46.433 Connected to database 'mythconverg' at host: 192.168.1.17
2011-08-02 11:03:46.437 Closing DB connection named 'DBManager0'
2011-08-02 11:03:46.462 Could not find theme:  - Switching to Terra
2011-08-02 11:03:46.689 Desktop video mode: 1024x768 75.000 Hz
2011-08-02 11:03:46.844 get_ip: Name or service not known
2011-08-02 11:03:46.844 LIRC, Error: Failed to parse IP address ''
2011-08-02 11:03:46.845 JoystickMenuThread: Joystick disabled - Failed to read /home/mythtv/.mythtv/joystickmenurc
2011-08-02 11:03:46.867 Using Frameless Window
2011-08-02 11:03:46.868 Using Full Screen Window
2011-08-02 11:03:46.891 Using the Qt painter
2011-08-02 11:03:49.637 No locale defaults file for en_US, skipping
2011-08-02 11:03:49.637 System Locale (en_US), Country (US), Language (en)
2011-08-02 11:03:52.780 Loading en_us translation for module mythfrontend
2011-08-02 11:03:52.800 Current locale en_US
2011-08-02 11:03:52.800 No locale defaults file for en_US, skipping
2011-08-02 11:03:52.958 ScreenSaverX11Private: Gnome screen saver support enabled
2011-08-02 11:03:53.092 DPMS is disabled.
2011-08-02 11:03:53.329 Connected to database 'mythconverg' at host: 192.168.1.17
2011-08-02 11:03:53.333 Inserting MythTV initial database information.
2011-08-02 11:03:53.334 New DB connection, total: 2
2011-08-02 11:03:53.339 Connected to database 'mythconverg' at host: 192.168.1.17
2011-08-02 11:03:53.342 Upgrading to MythTV schema version 1226
2011-08-02 11:03:53.343 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:03:53.343 Deleting UPnP client...





More information about the mythtv-users mailing list