[mythtv-users] Won't Save Backend Settings
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
>> 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');
> 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.
> mythtv-users mailing list
> mythtv-users at mythtv.org
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.
More information about the mythtv-users