Comment 2 for bug 243504

Vince McIntyre wrote:
> I tried a complete purge/reinstall cycle.
> $ sudo aptitide --purge remove mythtv
> $ sudo aptitude --purge remove mythtv-backend
> $ sudo aptitude --purge remove mythtv-frontend
> $ sudo aptitude --purge remove mythtv-common
> $ sudo aptitude update
> $ sudo aptitude upgrade
> $ sudo aptitude install mythtv
> $ mythtv-setup
>
> I get the same behaviour.
>
> NB: If I say OK to the "mythfilldatabase" popup prompt, I got the fllowing in an xterm titled "running mythfilldatabase"
> -------------
> 2008-06-27 23:12:05.490 Using runtime prefix = /usr, libdir = /usr/lib
> 2008-06-27 23:12:05.491 Using localhost value of wellington
> 2008-06-27 23:12:05.497 New DB connection, total: 1
> 2008-06-27 23:12:05.500 Unable to connect to database!
> 2008-06-27 23:12:05.500 Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user 'mythtv'@'localhost' (using password: YES)
>
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2008-06-27 23:12:05.550 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError? Strange...
> QServerSocket: failed to bind or listen to the socket
> 2008-06-27 23:12:05.601 MCP::InitUPnP() - HttpServer Create Error
> 2008-06-27 23:12:05.601 Deleting UPnP client...
> 2008-06-27 23:12:05.601 No UPnP backends found
>
> No UPnP backends found
>
> Would you like to configure the database connection now? [yes]
> Database host name: [localhost]
> Should I test connectivity to this host using the ping command? [yes]
> Database non-default port: [0]
> Database name: [mythconverg]
> Database user name: [mythtv]
> Database password: [0ciB7wRh]
> Unique identifier for this machine (if empty, the local host name will be used): [wellington]
> Would you like to use Wake-On-LAN to retry database connections? [no]
> 2008-06-27 23:13:31.942 Unable to connect to database!
> 2008-06-27 23:13:31.942 Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user 'mythtv'@'localhost' (using password: YES)
>
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2008-06-27 23:13:31.993 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError? Strange...
> 2008-06-27 23:13:32.043 Cannot login to database?
> 2008-06-27 23:13:32.043 Cannot login to database?
>
> Cannot login to database?
>
> Would you like to configure the database connection now? [yes]
> ------------
> and so on, endlessly...
>
The database is created by mythtv-database. You have to purge that and drop the
table made by that.

--
Mario Limonciello
<email address hidden>