<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd"><html><head><meta name="qrichtext" content="1" /><style type="text/css">p, li { white-space: pre-wrap; }</style></head><body style=" font-family:'Times New Roman'; font-size:11pt; font-weight:400; font-style:normal;">On Tuesday 25 August 2009 18:20:30 Brad DerManouelian wrote:<br>
> On Aug 25, 2009, at 3:11 PM, Eric A. Boney wrote:<br>
> > Well when I run that from the command line I am able to login to the<br>
> > mysql server and get a myql command prompt. No errors encountered at<br>
> > all. So this makes me wonder if there is a problem with the<br>
> > configuration file for the slave backend.<br>
> ><br>
> > I have looked in the mysql.txt files on the slave backend and all<br>
> > the DB information there is correct. Only item missing in all of<br>
> > them is the DBType= is blank.<br>
><br>
> Are you using the IP address in your config or the hostname? I seem to<br>
> remember IP address is required. I think it would be helpful to see<br>
> the error log from the slave.<br>
To the best of my knowledge I am using the actual ip address for the master backend. Below is the output from the slave log files. This is just a snippet as the log file get repeatitive after this. Nowhere in the log file does it show the ip address of the master backend that is trying to be attached to, although I know for sure that it is entered into the mythtv-setup configuration area.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Thanks again for all the help!<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>-Eric<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>*************************************************<br>
2009-08-25 18:29:11.636 Using runtime prefix = /usr<br>
2009-08-25 18:29:11.640 Empty LocalHostName.<br>
2009-08-25 18:29:11.641 Using localhost value of xxxxxx.com<br>
2009-08-25 18:29:11.648 New DB connection, total: 1<br>
2009-08-25 18:29:11.651 Unable to connect to database!<br>
2009-08-25 18:29:11.651 Driver error was [1/2002]:<br>
QMYSQL3: Unable to connect<br>
Database error was:<br>
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>QSqlQuery::exec: database not open<br>
QSqlQuery::exec: database not open<br>
2009-08-25 18:29:11.704 DB Error (KickDatabase):<br>
Query was:<br>
SELECT NULL;<br>
No error type from QSqlError? Strange...<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>2009-08-25 18:29:12.185 UPnPautoconf() - Found one UPnP backend<br>
2009-08-25 18:29:15.209 MythXMLClient::GetConnectionInfo Failed - (606) Action Not Authorized<br>
2009-08-25 18:29:15.209 Cannot login to database?<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Cannot login to database?<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Would you like to configure the database connection now? [yes] <br>
[console is not interactive, using default 'yes']<br>
Database host name: [localhost] <br>
[console is not interactive, using default 'localhost']<br>
Should I test connectivity to this host using the ping command? [yes] <br>
[console is not interactive, using default 'yes']<br>
Database non-default port: [0] <br>
[console is not interactive, using default '0']<br>
Database name: [mythconverg] <br>
[console is not interactive, using default 'mythconverg']<br>
Database user name: [mythtv] <br>
[console is not interactive, using default 'mythtv']<br>
Database password: [xxxxxx] <br>
[console is not interactive, using default 'xxxxxx']<br>
Unique identifier for this machine (if empty, the local host name will be used): <br>
[console is not interactive, using default '']<br>
Would you like to use Wake-On-LAN to retry database connections? [no] <br>
[console is not interactive, using default 'no']<br>
2009-08-25 18:29:15.226 Unable to connect to database!<br>
2009-08-25 18:29:15.227 Driver error was [1/2002]:<br>
QMYSQL3: Unable to connect<br>
Database error was:<br>
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>QSqlQuery::exec: database not open<br>
QSqlQuery::exec: database not open<br>
2009-08-25 18:29:15.279 DB Error (KickDatabase):<br>
Query was:<br>
SELECT NULL;<br>
No error type from QSqlError? Strange...<br>
2009-08-25 18:29:15.330 Cannot login to database?<br>
2009-08-25 18:29:15.330 Cannot login to database?<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Cannot login to database?<br>
*************************************************************<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p></body></html>