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

[the mad doctor kaeding]

I have run mc.sql onto sql, added a mythtv group, added
myself to that group, run the mysql commands to grant
permissions for the mythtv user, and still get
"cannot login to database?"


On Sun, Dec 21, 2008 at 10:42 PM, the mad doctor kaeding <
the.mad.doctor.kaeding at gmail.com> wrote:

> 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/78fbb62f/attachment.htm