[mythtv-users] mythtv-setup does not create video sources

[Brian Guilfoos]

Jimmy Desai wrote:
>> Is the mythtv-setup program connecting to the database? ( Intense Red)
> 
> I think it is. (I have installed and configured MySQL. It's working
> properly, since I'm able to access it through my browser using
> "localhost". I've also setup the root password and supplied it to mythtv
> during configuration.) Here is the output when I start it up in a console:
> 
> 2006-06-18 15:15:43.655 Current Schema Version:
> 2006-06-18 15:15:43.656 Newest Schema Version : 1123
> 2006-06-18 15:15:43.658 New DB connection, total: 2
> 2006-06-18 15:15:43.659 Connected to database 'mythconverg' at host:
> localhost
> 2006-06-18 15:15:43.660 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.
> 2006-06-18 15:15:43.663 New DB connection, total: 3
> 2006-06-18 15:15:43.664 Connected to database 'mythconverg' at host:
> localhost
> 2006-06-18 15:15:43.665 Told to create a NEW database schema, but the
> database
> already has 14 tables.
> If you are sure this is a good mythtv database, verify
> that the settings table has the DBSchemaVer variable.

I think this is your problem.  Your database looks hosed.  Try dropping
the mythconverg database and "reinstalling" it.

$ mysql -u root -p
mysql> drop database mythconverg
mysql> exit
$ mysql -u root -p < /usr/share/doc/mythtv-0.19/database/mc.sql

I think that'll fix things.