[mythtv-users] Setting up mythtv on debian etch
R. G. Newbury
newbury at mandamus.org
Fri Jan 18 05:11:42 UTC 2008
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.
More information about the mythtv-users