[mythtv-users] Configuring a slave server with additional tuners

[Eric A. Boney]

On Tuesday 25 August 2009 18:20:30 Brad DerManouelian wrote:
> On Aug 25, 2009, at 3:11 PM, Eric A. Boney wrote:
> > Well when I run that from the command line I am able to login to the
> > mysql server and get a myql command prompt. No errors encountered at
> > all. So this makes me wonder if there is a problem with the
> > configuration file for the slave backend.
> >
> > I have looked in the mysql.txt files on the slave backend and all
> > the DB information there is correct. Only item missing in all of
> > them is the DBType= is blank.
>
> Are you using the IP address in your config or the hostname? I seem to
> remember IP address is required. I think it would be helpful to see
> the error log from the slave.
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.

Thanks again for all the help!

-Eric


*************************************************
2009-08-25 18:29:11.636 Using runtime prefix = /usr
2009-08-25 18:29:11.640 Empty LocalHostName.
2009-08-25 18:29:11.641 Using localhost value of xxxxxx.com
2009-08-25 18:29:11.648 New DB connection, total: 1
2009-08-25 18:29:11.651 Unable to connect to database!
2009-08-25 18:29:11.651 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2009-08-25 18:29:11.704 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...

2009-08-25 18:29:12.185 UPnPautoconf() - Found one UPnP backend
2009-08-25 18:29:15.209 MythXMLClient::GetConnectionInfo Failed - (606) Action 
Not Authorized
2009-08-25 18:29:15.209 Cannot login to database?

Cannot login to database?

Would you like to configure the database connection now? [yes]  
[console is not interactive, using default 'yes']
Database host name: [localhost]  
[console is not interactive, using default 'localhost']
Should I test connectivity to this host using the ping command? [yes]  
[console is not interactive, using default 'yes']
Database non-default port: [0]  
[console is not interactive, using default '0']
Database name: [mythconverg]  
[console is not interactive, using default 'mythconverg']
Database user name: [mythtv]  
[console is not interactive, using default 'mythtv']
Database password: [xxxxxx]  
[console is not interactive, using default 'xxxxxx']
Unique identifier for this machine (if empty, the local host name will be 
used):  
[console is not interactive, using default '']
Would you like to use Wake-On-LAN to retry database connections? [no]  
[console is not interactive, using default 'no']
2009-08-25 18:29:15.226 Unable to connect to database!
2009-08-25 18:29:15.227 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2009-08-25 18:29:15.279 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2009-08-25 18:29:15.330 Cannot login to database?
2009-08-25 18:29:15.330 Cannot login to database?

Cannot login to database?
*************************************************************


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20090825/f9fbd036/attachment.htm>