[mythtv-users] common noob question

[Andrew Close]

On Tue, Apr 29, 2008 at 12:20 AM, Nicolas Frazier
<nickfrazier1 at gmail.com> wrote:
> I have gotten stuck during mythtv installation. I cannot connect to a
> database for myth. Using the information listed below can someone help me
> through the process?
>
>
> nick at nick-laptop:~$ sudo -H -u mythtv mythfilldatabase
>  [sudo] password for nick:
> 2008-04-29 00:44:52.282 Using runtime prefix = /usr, libdir = /usr/lib
> 2008-04-29 00:44:52.362 Empty LocalHostName.
> 2008-04-29 00:44:52.363 Using localhost value of nick-laptop
> 2008-04-29 00:44:52.552 New DB connection, total: 1
>  2008-04-29 00:44:52.585 Unable to connect to database!
> 2008-04-29 00:44:52.585 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-04-29 00:44:52.641 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> QServerSocket: failed to bind or listen to the socket
>  2008-04-29 00:44:52.697 MCP::InitUPnP() - HttpServer Create Error
> 2008-04-29 00:44:52.697 Deleting UPnP client...
> 2008-04-29 00:44:52.699 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: [mypassword]
>  Unique identifier for this machine (if empty, the local host name will be
> used):
> Would you like to use Wake-On-LAN to retry database connections? [no]
> 2008-04-29 00:45:02.910 Unable to connect to database!
> 2008-04-29 00:45:02.910 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-04-29 00:45:02.961 DB Error (KickDatabase):
>  Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2008-04-29 00:45:03.011 Cannot login to database?
> 2008-04-29 00:45:03.011 Cannot login to database?
>
> Cannot login to database?

Nick,
in your previous post i believe you mentioned that you have a separate
FE/BE setup.  if that's the case, then this may be your issue:

Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)

specifically the 'mythtv at localhost'
shouldn't that be mythtv at your_backend_machine ???


-- 
Andrew Close