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

the mad doctor kaeding the.mad.doctor.kaeding at gmail.com
Mon Dec 22 01:38:39 UTC 2008


echo 'show databases;' | mysql --user=root --password
gives
....
mysql
mythconverg
.....

echo 'show tables;' | mysql --user=mythtv --password=mythtv
--database=mythconverg
gives a blank line

creating /etc/mythtv/mysql.txt with the right stuff in it
had no effect.


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

> Does this mean anything?:
>
> > mythtv-setup
> 2008-12-21 20:28:58.777 Using runtime prefix = /usr, libdir = /usr/lib
> 2008-12-21 20:28:58.893 DPMS is disabled.
> 2008-12-21 20:28:58.974 Empty LocalHostName.
> 2008-12-21 20:28:58.974 Using localhost value of kaeding
> ...........................................................................
> 2008-12-21 20:29:02.431 UPnPautoconf() - No UPnP backends found
> 2008-12-21 20:29:02.431 No UPnP backends found
> QSqlDatabase: QMYSQL3 driver not loaded
> QSqlDatabase: available drivers:
> 2008-12-21 20:29:02.434 New DB connection, total: 1
> 2008-12-21 20:29:02.624 Total desktop dim: 1600x1200, with 1 screen[s].
> 2008-12-21 20:29:02.625 Using screen 0, 1600x1200 at 0,0
> 2008-12-21 20:29:02.700 Switching to square mode (blue)
> 2008-12-21 20:29:02.880 Using the Qt painter
> mythtv: could not connect to socket
> mythtv: Connection refused
> 2008-12-21 20:29:02.887 lirc_init failed for mythtv, see preceding messages
> 2008-12-21 20:29:02.887 JoystickMenuClient Error: Joystick disabled -
> Failed toread /home/kaeding/.mythtv/joystickmenurc
> 2008-12-21 20:29:05.249 DB Error (Clear setting):
> Query was:
>
> No error type from QSqlError?  Strange...
> 2008-12-21 20:29:05.249 DB Error (SaveSettingOnHost query failure: ):
> Query was:
>
> No error type from QSqlError?  Strange...
> 2008-12-21 20:29:05.249 DB Error (Clear setting):
> Query was:
>
> No error type from QSqlError?  Strange...
> 2008-12-21 20:29:05.250 DB Error (SaveSettingOnHost query failure: ):
> Query was:
>
> No error type from QSqlError?  Strange...
> 2008-12-21 20:29:08.166 Writing settings file
> /home/kaeding/.mythtv/mysql.txt
> 2008-12-21 20:29:08.167 Closing DB connection named 'DBManager0'
> 2008-12-21 20:29:08.233 Cannot connect to port 6603 on database host
> localhost
> 2008-12-21 20:29:08.233 Cannot connect to port 6603 on database host
> localhost
> 2008-12-21 20:29:08.234 Total desktop dim: 1600x1200, with 1 screen[s].
> 2008-12-21 20:29:08.234 Using screen 0, 1600x1200 at 0,0
> 2008-12-21 20:29:08.237 Switching to square mode (blue)
> 2008-12-21 20:29:08.733 Using the Qt painter
> mythtv: could not connect to socket
> mythtv: Connection refused
> 2008-12-21 20:29:08.862 lirc_init failed for mythtv, see preceding messages
> 2008-12-21 20:29:08.862 JoystickMenuClient Error: Joystick disabled -
> Failed toread /home/kaeding/.mythtv/joystickmenurc
> 2008-12-21 20:29:09.605 DB Error (Clear setting):
> Query was:
>
> No error type from QSqlError?  Strange...
> 2008-12-21 20:29:09.605 DB Error (SaveSettingOnHost query failure: ):
> Query was:
>
> No error type from QSqlError?  Strange...
> 2008-12-21 20:29:17.441 User cancelled database configuration
> 2008-12-21 20:29:17.470 Deleting UPnP client...
> 2008-12-21 20:29:18.372 Failed to init MythContext, exiting.
>
>
>
> On Sun, Dec 21, 2008 at 8:24 PM, the mad doctor kaeding <
> the.mad.doctor.kaeding at gmail.com> wrote:
>
>> If I follow those instructions:
>>
>> UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
>> ERROR 1046 (3D000): No database selected
>>
>>
>>
>> On Sun, Dec 21, 2008 at 8:03 PM, Brad DerManouelian <
>> myth at dermanouelian.com> wrote:
>>
>>> On Dec 21, 2008, at 4:50 PM, the mad doctor kaeding wrote:
>>>
>>> > Yes, I'm following the instructions, and got to
>>> > this point in the manual:
>>> >
>>> > --------------------------
>>> > Setup MythTV backend preferences and tune TV cards
>>> > Open a Terminal Window and type
>>> >
>>> > > mythtv-setup
>>> > -------------------------
>>> >
>>> > At this point I do NOT see the general setup window.  I see
>>> > a window asking for hostname, port, sql username and password,
>>> > and sql database name.  So I leave them as they are.  Then
>>> >
>>> > a new window comes up to tell me "Cannot log in to database?"
>>> > After clicking 'OK', I'm dead.  Cannot run mythtv.
>>> http://www.mythtv.org/wiki/index.php/Category:MySQL
>>>
>>> _______________________________________________
>>> 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/aa830b3a/attachment.htm 


More information about the mythtv-users mailing list