[mythtv-users] can't login in to sql

[the mad doctor kaeding]

I just now compiled and installed the newest mysql (5.1.30),
and followed your instructions to the letter.  And I get the
same problem:  after a couple screens to enter sql names
and password, and checkboxes for waking the sql server,
mythtv-setup takes me to a box saying "Cannot log in to
database?" (yes there is a question mark in it).

Here's what the terminal window says:

> mythtv-setup
2008-12-21 22:40:32.067 Using runtime prefix = /usr, libdir = /usr/lib
2008-12-21 22:40:32.307 DPMS is disabled.
2008-12-21 22:40:32.308 Empty LocalHostName.
2008-12-21 22:40:32.309 Using localhost value of kaeding
QSqlDatabase: QMYSQL3 driver not loaded
QSqlDatabase: available drivers:
2008-12-21 22:40:32.311 New DB connection, total: 1
2008-12-21 22:40:32.311 Unable to connect to database!
2008-12-21 22:40:32.312 No error type from QSqlError?  Strange...
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-12-21 22:40:32.364 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
.............................................................................
2008-12-21 22:40:35.820 UPnPautoconf() - No UPnP backends found
2008-12-21 22:40:35.821 No UPnP backends found
2008-12-21 22:40:35.827 Total desktop dim: 1600x1200, with 1 screen[s].
2008-12-21 22:40:35.827 Using screen 0, 1600x1200 at 0,0
2008-12-21 22:40:35.830 Switching to square mode (blue)
2008-12-21 22:40:35.878 Using the Qt painter
mythtv: could not connect to socket
mythtv: Connection refused
2008-12-21 22:40:35.915 lirc_init failed for mythtv, see preceding messages
2008-12-21 22:40:35.915 JoystickMenuClient Error: Joystick disabled - Failed
toread /root/.mythtv/joystickmenurc
2008-12-21 22:40:37.547 DB Error (Clear setting):
Query was:

No error type from QSqlError?  Strange...
2008-12-21 22:40:37.547 DB Error (SaveSettingOnHost query failure: ):
Query was:

No error type from QSqlError?  Strange...
2008-12-21 22:40:37.547 DB Error (Clear setting):
Query was:

No error type from QSqlError?  Strange...
2008-12-21 22:40:37.547 DB Error (SaveSettingOnHost query failure: ):
Query was:

No error type from QSqlError?  Strange...
2008-12-21 22:40:49.783 Writing settings file /root/.mythtv/mysql.txt
2008-12-21 22:40:49.784 Closing DB connection named 'DBManager0'
2008-12-21 22:40:49.824 Unable to connect to database!
2008-12-21 22:40:49.825 No error type from QSqlError?  Strange...
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-12-21 22:40:49.876 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2008-12-21 22:40:49.928 Cannot login to database?
2008-12-21 22:40:49.928 Cannot login to database?
2008-12-21 22:40:49.928 Total desktop dim: 1600x1200, with 1 screen[s].
2008-12-21 22:40:49.929 Using screen 0, 1600x1200 at 0,0
2008-12-21 22:40:49.930 Switching to square mode (blue)
2008-12-21 22:40:50.141 Using the Qt painter
mythtv: could not connect to socket
mythtv: Connection refused
2008-12-21 22:40:50.163 lirc_init failed for mythtv, see preceding messages
2008-12-21 22:40:50.164 JoystickMenuClient Error: Joystick disabled - Failed
toread /root/.mythtv/joystickmenurc
2008-12-21 22:40:51.277 DB Error (Clear setting):
Query was:

No error type from QSqlError?  Strange...
2008-12-21 22:40:51.277 DB Error (SaveSettingOnHost query failure: ):
Query was:

No error type from QSqlError?  Strange...
2008-12-21 22:40:54.672 User cancelled database configuration
2008-12-21 22:40:54.698 Deleting UPnP client...
2008-12-21 22:40:56.073 Failed to init MythContext, exiting.



On Sun, Dec 21, 2008 at 9:32 PM, Brad DerManouelian
<myth at dermanouelian.com>wrote:

> On Dec 21, 2008, at 5:38 PM, the mad doctor kaeding wrote:
>
> echo 'show databases;' | mysql --user=root --password
> gives
> ....
> mysql
> mythconverg
> .....
>
>
> So the mythtv user doesn't have access to the mythconverg database by the
> root user does.
> Again, I point you to this page:
> http://www.mythtv.org/wiki/index.php/Mysql
> With special attention to this part:
>
> # mysql -u root -p mysql
> myqsl> GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'localhost'
>     -> IDENTIFIED BY 'mythtv' WITH GRANT OPTION;
> mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
> mysql> FLUSH PRIVILEGES;
> mysql> quit
>
>
>
> _______________________________________________
> 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/20081221/4b1d1a40/attachment.htm