[mythtv-users] Cannot get the backend to run

Jarom McDonald jarom_mcdonald at byu.edu
Fri May 22 22:26:08 UTC 2009


The one piece of information you haven't provided yet are the details of 
your mysql user tables on the non-working and the working servers. 
Remember that a mysql user is a combination of a username and a 
hostname, so mythtv at localhost and mythtv at macMini and mythtv at 192.168.1.61 
are 3 separate users (even if, on the OS level, they all resolve to each 
other). The error message you're getting on MacMini is not a Myth error, 
but a MySQL error telling you that the mythtv at macMini user has been 
denied access. There are only three reasons for this: 1) mysql isn't 
configured to accept any users not from the 'localhost' host, 2) the 
password in mysql.txt isn't corresponding with the password in the mysql 
tables, or 3) the mysql at macMini user doesn't even exist.

You've ruled out 1 and 2, but haven't ruled out 3. In your mysql user 
table, ("SELECT user,host FROM user") you have a mythtv at localhost 
(evident from your very first message that let you connect), and you 
have a mythtv at 192.168.1.61 (that was created when you did the GRANT 
statement), but you should check to see if you have a mythtv at macMini, 
and that ITS password is properly set, since that's the user that 
mythbackend is trying to connect with. You could just do:

GRANT ALL on mythconverg.* to mythtv at macMini IDENTIFIED BY "[password]"

just as you did with the user that has the ip address as the hostname, 
to insure that the user exists with the right password.

If THAT fails, then I don't know what to say ... there could be some 
corruption in the mysql user tables. You could delete all users and 
re-create them, I suppose, or drop the DBs and reinstall mysql (you did 
say this was a new server, correct?)

Jarom

On 05/22/09 16:01, Mark Knecht wrote:
> On Fri, May 22, 2009 at 2:57 PM, Mark Knecht<markknecht at gmail.com>  wrote:
>    
>> When I try and run mythtv-setup then I get the message about not being
>> able to access the database:
>>
>> MacMini ~ # mythtv-setup
>> 2009-05-22 14:53:27.249 Using runtime prefix = /usr
>> 2009-05-22 14:53:27.292 DPMS is active.
>> 2009-05-22 14:53:27.294 Empty LocalHostName.
>> 2009-05-22 14:53:27.294 Using localhost value of MacMini
>> 2009-05-22 14:53:27.295 Testing network connectivity to 192.168.1.61
>> 2009-05-22 14:53:27.362 New DB connection, total: 1
>> 2009-05-22 14:53:27.391 Unable to connect to database!
>> 2009-05-22 14:53:27.391 Driver error was [1/1045]:
>> QMYSQL3: Unable to connect
>> Database error was:
>> Access denied for user 'mythtv'@'MacMini' (using password: YES)
>>
>> QSqlQuery::exec: database not open
>> QSqlQuery::exec: database not open
>> 2009-05-22 14:53:27.445 DB Error (KickDatabase):
>> Query was:
>> SELECT NULL;
>> No error type from QSqlError?  Strange...
>>
>> 2009-05-22 14:53:28.048 UPnPautoconf() - Found one UPnP backend
>> 2009-05-22 14:53:28.091 MythXMLClient::GetConnectionInfo Failed -
>> (604) No Security Pin assigned. Run mythtv-setup to set one.
>>
>>
>>      
>
> I meant to include this. On a different machine I have mythtv set up
> with the old server on 192.168.1.59. Dragonfly can access that mysql
> database correctly when I run mythtv-setup.
>
> mark at dragonfly ~ $ cat .mythtv/mysql.txt
> DBHostName=192.168.1.59
> DBUserName=mythtv
> DBPassword=mythtv
> DBName=mythconverg
> DBType=QMYSQL3
> mark at dragonfly ~ $
>
> mark at dragonfly ~ $ mythtv-setup --geometry 640x480
> 2009-05-22 15:00:39.549 Using runtime prefix = /usr
> 2009-05-22 15:00:39.576 XScreenSaver support enabled
> 2009-05-22 15:00:39.589 DPMS is active.
> 2009-05-22 15:00:39.590 Empty LocalHostName.
> 2009-05-22 15:00:39.590 Using localhost value of dragonfly
> 2009-05-22 15:00:39.591 Testing network connectivity to 192.168.1.59
> 2009-05-22 15:00:39.701 New DB connection, total: 1
> 2009-05-22 15:00:39.708 Connected to database 'mythconverg' at host:
> 192.168.1.59
> 2009-05-22 15:00:39.709 Closing DB connection named 'DBManager0'
> 2009-05-22 15:00:39.748 Primary screen 0.
> 2009-05-22 15:00:39.765 Connected to database 'mythconverg' at host:
> 192.168.1.59
> 2009-05-22 15:00:39.766 Running in a window
> 2009-05-22 15:00:39.773 Using screen 0, 1280x998 at 0,0
> 2009-05-22 15:00:39.784 Overriding GUI, width=640, height=480 at 0,0
> 2009-05-22 15:00:39.786 New DB connection, total: 2
> 2009-05-22 15:00:39.787 Connected to database 'mythconverg' at host:
> 192.168.1.59
> 2009-05-22 15:00:39.788 Current Schema Version: 1214
> 2009-05-22 15:00:39.999 No theme dir: /home/mark/.mythtv/themes/Titivillus
> 2009-05-22 15:00:40.000 Switching to square mode (Titivillus)
> 2009-05-22 15:00:40.042 Using the Qt painter
> 2009-05-22 15:00:40.043 JoystickMenuClient Error: Joystick disabled -
> Failed to read /home/mark/.mythtv/joystickmenurc
> 2009-05-22 15:00:41.491 Loading from:
> /usr/share/mythtv/themes/Titivillus/base.xml
> 2009-05-22 15:00:41.610 Loading from: /usr/share/mythtv/themes/default/base.xml
> 2009-05-22 15:00:41.653 No theme dir: /home/mark/.mythtv/themes/Titivillus
> 2009-05-22 15:00:51.019 DB Error (checkStoragePaths):
> Query was:
> SELECT groupname, dirname FROM storagegroup WHERE hostname = 'dragonfly';
> No error type from QSqlError?  Strange...
> mark at dragonfly ~ $
>
>
> No problem finding mysql.txt and no problem talking to the mysql
> database on 192.168.1.59.
>
> Just more data.
>
> - Mark
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>    

-- 
Jarom McDonald
Assistant Research Professor, College of Humanities
Brigham Young University
1163-G JFSB
Provo, UT 84602
801.422.7426
jarom_mcdonald at byu.edu



More information about the mythtv-users mailing list