[mythtv-users] Won't Save Backend Settings

David Rush david at rushtone.com
Fri Aug 31 02:18:59 UTC 2007


> On 08/30/2007 09:24 PM, David Rush wrote:
>   
>> More info.... /var/log/mythtv/mythbackend.log has some interesting stuff:
>>   
>>     
> ...
>   
>> 2007-08-30 21:14:49.555 Told to create a NEW database schema, but the 
>> database
>> already has 5 tables.
>> If you are sure this is a good mythtv database, verify
>> that the settings table has the DBSchemaVer variable.
>>
>> 2007-08-30 21:14:49.556 Database Schema upgrade FAILED, unlocking.
>> 2007-08-30 21:14:49.557 Couldn't upgrade database to new schema
>>
>> So, there IS a database problem.
>>     
>
> That happens when you have a database that includes tables but has
> "broken" data (i.e. missing DB schema version and possibly other stuff).
>
> If you're setting things up for the first time, I'd recommend installing
> mythtv and mythtv-database, then using the mysql client, log into the
> DBMS as root
>
> mysql -uroot -p mysql
>
> (and supply the root password).  Then issue the command:
>
> DROP DATABASE mythconverg;
>
> Then apply the mc.sql script as described at
> http://mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2 , then start up
> mythtv-setup and begin configuration.  This will "fix" the DB by
> starting over (so, re-does what mythtv-database tried to do for you in
> such a way that your package manager is happy).
>
> If you don't know the mysql root password, shut down the mysql server
> and run the following as root:
>
> cat > /srv/mysql/tmpinit.sql << EOF
> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('rootpasswd');
> SET PASSWORD FOR 'root'@'`hostname`' = PASSWORD('rootpasswd');
> EOF
> mysqld_safe --user=mysql --init-file=/srv/mysql/tmpinit.sql 2>&1
>   
>> /dev/null &
>>     
> rm /srv/mysql/tmpinit.sql
>
> But change the "rootpasswd" to something sensible (and not so crackable
> :).  Use another window to shut down the mysql server and restart it
> then log in as root using the password you supplied.
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>   
Mike:

I didn't have the root pword, and I couldn't get the tmpinit.sql script 
to work, but I tried the DROP command mythtv rather than root, and that 
seems to have done the trick.  I'm scanning for channels now.

Thanks!

David


More information about the mythtv-users mailing list