[mythtv-users] mythfrontend can't connect to backend/database

[starcycle]

On Sun, Apr 20, 2008 at 2:15 PM, Michael T. Dean
<mtdean at thirdcontact.com> wrote:
>
>  It also says that blank prevents all connections.  Did you actually type
>  in 0000 and save it?

that's what it said, so that's what I did. ;)

>
>
>  > Now I just have to figure why the clients won't connect to the
>  > database. Do I need a "mythtv" user or group on the clients?
>
>  Fix the ~/.mythtv/config.xml's...

I'm not sure what it means to fix it. It just has some long number in
xml tags, like this:
   <MediaRenderer>26aae4b6-2605-4e1d-8cfb-5525acc8b459</MediaRenderer>

and also the pin. I deleted the files a number of times and retried,
and I keep getting the same thing.

Btw, when I select the "manual config," the setup screen comes up
where you enter the IP, etc. But if I select it after doing a "save
the database/backend" screen, a dialog comes up saying it "can't find
(ping) database host on the network." I can ping everything on the lan
from everywhere else, so I'm not sure why mythtv can't ping.


FWIW, here's the output after deleting the ~/.mythtv directory
contents, followed by the output of starting the backend. maybe
someone can spot a problem:

client:
====================================
>
jeff at bart:~ $ mythfrontend
2008-04-20 14:23:18.876 Using runtime prefix = /usr, libdir = /usr/lib
2008-04-20 14:23:19.584 DPMS is active.
2008-04-20 14:23:19.585 Unable to read configuration file mysql.txt
2008-04-20 14:23:19.585 Empty LocalHostName.
2008-04-20 14:23:19.585 Using localhost value of bart
QSettings::sync: filename is null/empty
2008-04-20 14:23:19.598 New DB connection, total: 1
2008-04-20 14:23:19.599 Unable to connect to database!
2008-04-20 14:23:19.599 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-04-20 14:23:19.660 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...

2008-04-20 14:23:19.877 UPnPautoconf() - Found one UPnP backend
2008-04-20 14:23:19.919 MythXMLClient::GetConnectionInfo Failed -
(606) Action Not Authorized
2008-04-20 14:23:20.600 Total desktop dim: 1400x1050, with 1 screen[s].
2008-04-20 14:23:20.601 Using screen 0, 1400x1050 at 0,0
2008-04-20 14:23:20.603 Switching to square mode (blue)
2008-04-20 14:23:20.685 Using the Qt painter
mythtv: could not connect to socket
mythtv: No such file or directory
2008-04-20 14:23:20.687 lirc_init failed for mythtv, see preceding messages
2008-04-20 14:23:20.697 JoystickMenuClient Error: Joystick disabled -
Failed to read /home/jeff/.mythtv/joystickmenurc
QSettings::sync: filename is null/empty
QSettings::sync: filename is null/empty
QSettings::sync: filename is null/empty
2008-04-20 14:23:23.679 DB Error (Clear setting):
Query was:

No error type from QSqlError?  Strange...
2008-04-20 14:23:23.679 DB Error (SaveSettingOnHost query failure: ):
Query was:

No error type from QSqlError?  Strange...
2008-04-20 14:23:23.680 DB Error (Clear setting):
Query was:

No error type from QSqlError?  Strange...
2008-04-20 14:23:23.680 DB Error (SaveSettingOnHost query failure: ):
Query was:

No error type from QSqlError?  Strange...
2008-04-20 14:23:23.680 Putting up the UPnP backend chooser
2008-04-20 14:23:25.482 MythXMLClient::GetConnectionInfo Failed -
(606) Action Not Authorized
2008-04-20 14:23:28.488 Unable to connect to database!
2008-04-20 14:23:28.490 Driver error was [1/2013]:
QMYSQL3: Unable to connect
Database error was:
Lost connection to MySQL server at 'reading initial communication
packet', system error: 0

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-04-20 14:23:28.546 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2008-04-20 14:23:28.596 Database not open while trying to load
setting: UseArrowAccels
2008-04-20 14:23:28.600 Unable to connect to database!
2008-04-20 14:23:28.600 Driver error was [1/2013]:
QMYSQL3: Unable to connect
Database error was:
Lost connection to MySQL server at 'reading initial communication
packet', system error: 0

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-04-20 14:23:28.655 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2008-04-20 14:23:28.706 Database not open while trying to load
setting: PopupHeightPadding
2008-04-20 14:23:28.710 Unable to connect to database!
2008-04-20 14:23:28.711 Driver error was [1/2013]:
QMYSQL3: Unable to connect
Database error was:
Lost connection to MySQL server at 'reading initial communication
packet', system error: 0

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-04-20 14:23:28.766 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2008-04-20 14:23:28.816 Database not open while trying to load
setting: PopupWidthPadding
2008-04-20 14:23:31.911 Testing network connectivity to 192.168.0.103
2008-04-20 14:23:32.003 Unable to connect to database!
2008-04-20 14:23:32.004 Driver error was [1/2013]:
QMYSQL3: Unable to connect
Database error was:
Lost connection to MySQL server at 'reading initial communication
packet', system error: 0

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-04-20 14:23:32.065 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2008-04-20 14:23:32.116 Cannot login to database?
2008-04-20 14:23:32.116 Total desktop dim: 1400x1050, with 1 screen[s].
2008-04-20 14:23:32.116 Using screen 0, 1400x1050 at 0,0
2008-04-20 14:23:32.118 Switching to square mode (blue)
2008-04-20 14:23:32.136 Using the Qt painter
mythtv: could not connect to socket
mythtv: No such file or directory
2008-04-20 14:23:32.136 lirc_init failed for mythtv, see preceding messages
2008-04-20 14:23:32.143 JoystickMenuClient Error: Joystick disabled -
Failed to read /home/jeff/.mythtv/joystickmenurc
2008-04-20 14:23:34.838 DB Error (Clear setting):
Query was:

No error type from QSqlError?  Strange...
2008-04-20 14:23:34.838 DB Error (SaveSettingOnHost query failure: ):
Query was:

No error type from QSqlError?  Strange...
2008-04-20 14:23:35.708 Putting up the UPnP backend chooser
2008-04-20 14:23:37.974 User requested Manual Config
2008-04-20 14:23:37.974 Testing network connectivity to
2008-04-20 14:23:38.034 Cannot find (ping) database host  on the network
2008-04-20 14:23:38.034 Cannot find (ping) database host  on the network
2008-04-20 14:23:41.850 Putting up the UPnP backend chooser
2008-04-20 14:23:42.946 MythXMLClient::GetConnectionInfo Failed -
(606) Action Not Authorized
2008-04-20 14:23:46.269 Unable to connect to database!
2008-04-20 14:23:46.271 Driver error was [1/2013]:
QMYSQL3: Unable to connect
Database error was:
Lost connection to MySQL server at 'reading initial communication
packet', system error: 0

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-04-20 14:23:46.326 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2008-04-20 14:23:46.376 Database not open while trying to load
setting: UseArrowAccels
2008-04-20 14:23:46.381 Unable to connect to database!
2008-04-20 14:23:46.381 Driver error was [1/2013]:
QMYSQL3: Unable to connect
Database error was:
Lost connection to MySQL server at 'reading initial communication
packet', system error: 0

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-04-20 14:23:46.438 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2008-04-20 14:23:46.488 Database not open while trying to load
setting: PopupHeightPadding
2008-04-20 14:23:46.493 Unable to connect to database!
2008-04-20 14:23:46.493 Driver error was [1/2013]:
QMYSQL3: Unable to connect
Database error was:
Lost connection to MySQL server at 'reading initial communication
packet', system error: 0

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-04-20 14:23:46.548 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2008-04-20 14:23:46.598 Database not open while trying to load
setting: PopupWidthPadding
2008-04-20 14:23:50.030 Writing settings file /home/jeff/.mythtv/mysql.txt
2008-04-20 14:23:50.045 Could not find widget to detach
2008-04-20 14:23:50.046 Testing network connectivity to 192.168.0.103
2008-04-20 14:23:50.106 Unable to connect to database!
2008-04-20 14:23:50.107 Driver error was [1/2013]:
QMYSQL3: Unable to connect
Database error was:
Lost connection to MySQL server at 'reading initial communication
packet', system error: 0

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2008-04-20 14:23:50.163 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2008-04-20 14:23:50.213 Cannot login to database?
2008-04-20 14:23:50.213 Cannot login to database?
2008-04-20 14:23:50.213 Total desktop dim: 1400x1050, with 1 screen[s].
2008-04-20 14:23:50.214 Using screen 0, 1400x1050 at 0,0
2008-04-20 14:23:50.216 Switching to square mode (blue)
2008-04-20 14:23:50.276 Using the Qt painter
mythtv: could not connect to socket
mythtv: No such file or directory
2008-04-20 14:23:50.276 lirc_init failed for mythtv, see preceding messages
2008-04-20 14:23:50.283 JoystickMenuClient Error: Joystick disabled -
Failed to read /home/jeff/.mythtv/joystickmenurc
2008-04-20 14:23:52.468 DB Error (Clear setting):
Query was:

No error type from QSqlError?  Strange...
2008-04-20 14:23:52.468 DB Error (SaveSettingOnHost query failure: ):
Query was:

No error type from QSqlError?  Strange...
2008-04-20 14:23:53.275 Putting up the UPnP backend chooser
2008-04-20 14:23:54.371 User canceled database configuration
2008-04-20 14:23:54.371 Failed to init MythContext, exiting.
======================================

server:
=======================================

root at moe:/home/jeff # /etc/init.d/mythtv-backend restart
Restarting MythTV server: mythbackend .
cannot open logfile /var/log/mythtv/mythbackend.log
cannot open logfile; using stdout/stderr
2008-04-20 14:32:00.286 Using runtime prefix = /usr, libdir = /usr/lib
2008-04-20 14:32:00.287 Unable to read configuration file mysql.txt
2008-04-20 14:32:00.287 Empty LocalHostName.
2008-04-20 14:32:00.287 Using localhost value of moe
.
root at moe:/home/jeff # 2008-04-20 14:32:00.325 New DB connection, total: 1
2008-04-20 14:32:00.332 Connected to database 'mythconverg' at host: localhost
2008-04-20 14:32:00.334 Closing DB connection named 'DBManager0'
2008-04-20 14:32:00.336 Connected to database 'mythconverg' at host: localhost
2008-04-20 14:32:00.338 New DB connection, total: 2
2008-04-20 14:32:00.338 Connected to database 'mythconverg' at host: localhost
2008-04-20 14:32:00.341 Current Schema Version: 1214
Starting up as the master server.
2008-04-20 14:32:01.585 Main::Registering HttpStatus Extension
2008-04-20 14:32:01.586 mythbackend version: 0.21.20080304-1 www.mythtv.org
2008-04-20 14:32:01.586 Enabled verbose msgs:  important general
2008-04-20 14:32:01.588 AutoExpire: CalcParams(): Max required Free
Space: 0.0 GB w/freq: 15 min
2008-04-20 14:32:10.367 UPnpMedia: BuildMediaMap - no VideoStartupDir
set,  skipping scan.

=====================================