[mythtv-users] noob database question

[Nicolas Frazier]

Thanks for your reply. I applied the command you suggested and I was
presented with the common area of non compliance I have had trouble with.
Here is what I'm seeing. Maybe you could help me from this point:

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?

Would you like to configure the database connection now? [yes]



On Tue, Apr 29, 2008 at 12:39 AM, James Bunton <jamesbunton at fastmail.fm>
wrote:

> On Tue, Apr 29, 2008 at 12:20:41AM -0400, Nicolas Frazier wrote:
> > As a noob to Mythtv installation, how do you complete the database
> > installation of myth in the latest ubuntu environment.  mythfilldatabase
> > cannot login.
>
> Make sure you're running mythfilldatabase as the correct user. Probably
> the
> mythtv user is what you want.
>
> This may do what you want
> $ sudo -H -u mythtv mythfilldatabase
>
> ---
>
> James
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iQEVAwUBSBamjpenTbLEKWSrAQJAUggAmsdEhasO5vr69G/KBAsABuxcBnxJeVIr
> 7FePm7GN1BBztCXMDz/UOMbeSnTcc2XeVgH74dU8uwL0qOOj33kMX5PcOpNf28OU
> oweqd8wlph3Nw4Ah0eeDAL13JmXT5sFKAfTMVGzxmGORMLWR1VlAwMhwv4Xu/lIA
> BxI4l0kwhhF3DQFLjlgffAGOgmiXZdRg54AKgCLgQX8JJ1s6foJEhaDSzdDb/NC7
> xQodI+Xvt4ZQ0pBIC6uEDsxwUMDieO4Ubnfz6lC82JtrMmmxNXyZFPNp4Gnw94Ua
> up8oiwSdgPev2FRA50zHF1EoIqNu+VNU9zRjT5J7aWVhCqDCNBCfGg==
> =JNyL
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080429/8c8962b2/attachment.htm