[mythtv-users] Setting up mythtv on debian etch

[R. G. Newbury]

Jorge Luis wrote:
> I ran dpkg-reconfigure mythtv-database
> 
> Then I try to run mythbackend and this is the output
> Session management error: Authentication Rejected, reason : None of the 
> authenti cation protocols specified are supported and host-based 
> authentication failed
> 2008-01-17 18:31:07.480 Using runtime prefix = /usr
> 2008-01-17 18:31:07.535 New DB connection, total: 1
> 2008-01-17 18:31:07.543 Connected to database 'mysql' at host: home1
> 2008-01-17 18:31:07.561 Current Schema Version:
> 2008-01-17 18:31:07.563 DataDirectProcessor::FixProgramIDs() -- begin
> 2008-01-17 18:31:07.564 New DB DataDirect connection
> 2008-01-17 18:31:07.565 Connected to database 'mysql' at host: home1
> 2008-01-17 18:31:07.566 DB Error (Fixing program ids in recorded):
> Query was:
> UPDATE recorded SET programid=CONCAT(SUBSTRING(programid, 1, 2),       
> '00', SUBSTRING(programid, 3)) WHERE length(programid) = 12
> Driver error was [2/1146]:
> QMYSQL3: Unable to execute query
> Database error was:
> Table 'mysql.recorded' doesn't exist

You have inadvertantly crushed your mysql setup. Mysql creates and 
manages its own database to keep track of who is entitled to do what on 
the other databases...That database is called 'mysql'.

You will have to delete the mess you have made, and start again with mysql.
And THEN create a MYTHCONVERG" database for all the myth stuff to live in.

Although you are on dbian, Jarod Wilson's guide is VERY GODD.

Geoff