[mythtv-users] Cannot get the backend to run

[Mark Knecht]

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