<!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 17:46:58 Brad DerManouelian wrote:<br>
> On Aug 25, 2009, at 2:41 PM, Eric A. Boney wrote:<br>
> > I am having some issues getting my slave backend to connect to the<br>
> > mysql database on the master backend.<br>
> ><br>
> > Somehow the master sees that the slave has an additional tuner card<br>
> > available, but it doesn't show it as connected. In the logs on the<br>
> > slave I see errors about not being able to connect to the database.<br>
> > I have verified that the ip address is correct, that the password is<br>
> > correct and that the slave backend is actually running.<br>
> ><br>
> > I have looked at the permissions of the "mythtv" user in mysql and<br>
> > it has complete access both locally and with the "%" sign. I do not<br>
> > have MySQL installed on the slave server at all.<br>
> ><br>
> > I looked at the my.cnf configuration file on my master backend and I<br>
> > have tried both commenting and un-commenting the line bind:<br>
> > 192.168.1.xxx out. Neither seems to allow the slave to access the<br>
> > database on the master.<br>
> ><br>
> > I am at a loss currently. If there are other items from either of<br>
> > the logs that might help, please just ask.<br>
><br>
> The actual error message coming from MySQL would help. Try logging in<br>
> from the command line and report back the error you get.<br>
><br>
> e.g. $ mysql -umythtv -p<password> -h<ip address of backend> mythconverg<br>
><br>
> -Brad<br>
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.<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>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.<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></body></html>