[mythtv-users] new user with error...please point me toward the appropriate reading

Nick Morrott knowledgejunkie at gmail.com
Sun Jan 28 16:19:03 UTC 2007


On 28/01/07, Mike Chandler <michaelachandler at cox.net> wrote:
> Hello all,
> I have looked around here as much as I could with the limited time I have left
> today and I really would appreciate if someone could point me to the answer
> to this error. Using debian etch, nvidia fx5200.
> Thanks!
>
> mike at localhost:~$ mythfrontend
> 2007-01-27 19:38:52.408 Using runtime prefix = /usr
> 2007-01-27 19:38:52.456 DPMS is active.
> 2007-01-27 19:38:52.496 New DB connection, total: 1
> 2007-01-27 19:38:52.501 Connected to database 'mysql' at host: localhost
> 2007-01-27 19:38:52.504 Total desktop dim: 1280x960, with 1 screen[s].
> 2007-01-27 19:38:52.507 Using screen 0, 1280x960 at 0,0
> 2007-01-27 19:38:52.515 Current Schema Version:
> 2007-01-27 19:38:52.516 Newest Schema Version : 1160
> 2007-01-27 19:38:52.517 New DB connection, total: 2
> 2007-01-27 19:38:52.518 Connected to database 'mysql' at host: localhost
> 2007-01-27 19:38:52.518 Setting Lock for Database Schema upgrade. If you see a
> long pause here it means the Schema is already locked and is being upgraded
> by another Myth process.
> 2007-01-27 19:38:52.519 New DB connection, total: 3
> 2007-01-27 19:38:52.520 Connected to database 'mysql' at host: localhost
> 2007-01-27 19:38:52.521 Told to create a NEW database schema, but the database
> already has 17 tables.
> If you are sure this is a good mythtv database, verify
> that the settings table has the DBSchemaVer variable.
>
> 2007-01-27 19:38:52.522 Database Schema upgrade FAILED, unlocking.
> 2007-01-27 19:38:52.522 Couldn't upgrade database to new schema, exiting.

For some reason (incorrect installation, tinkering, etc) your frontend
system is trying to connect to the wrong database. The MythTV database
is usually called 'mythconverg' whereas your log output shows your
system trying to connect to 'mysql'.

You should have a ~/.mythtv/mysql.txt file (where ~ is the home
directory for your frontend user) - open it in a text editor and edit
the line:

DBName=mysql

to

DBName=mythconverg

Save the file, and then restart the frontend.

Nick
-- 
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin


More information about the mythtv-users mailing list