[mythtvnz] SOLVED - front end for mac osx 10.6

[Roger Searle]

Happily reporting this is solved.  I got the FE to work once I comment 
out the line for DBPort in the FE mysql.txt file.

I spun up a natty machine in virtualbox and played around with that, it 
had the same issue connecting to the BE database.  Reading the last few 
lines on the BE log, and starting FE from command line with "-v most" 
flag was very helpful seeing what was (or was not) going on.

My thanks to both Criggie for the nudge to get into mysql via the 
command line and Nick for the clarification of the various config files.

I now have an option of using the mac to do dvi to hdmi on the TV though 
have to put sound out separately.  Loving mythtv, and mythmote on my 
android phone . . .

Cheers,
Roger


On 8/10/11 12:48 PM, Roger Searle wrote:
> On 8/10/11 10:21 AM, Nick Rout wrote:
>> On Sat, Oct 8, 2011 at 9:56 AM, Roger Searle<roger.searle at gmail.com>  
>> wrote:
>>> Does anyone have a front end running on Mac OSX 10.6 Snow Leopard? 
>>>  I've tried the following from SourceForge being 0.24 +fixes to 
>>> match my current FE/BE: 
>>> http://sourceforge.net/projects/mythtvformacosx/files/
>>>>>> Check your backend's SQL and see if any config has been created 
>>>>>> for it?
>>>>> Try the settings table select * from settings where hostname
>>>>> like"%imac%";
>>>
>>> mysql>  select * from settings where hostname like "macbook";
>>> Empty set (0.00 sec)
>>>
>>> On the BE (following starting the mac FE below) the log shows:
>>> 2011-10-08 09:37:15.321 MainServer, Warning: Unknown socket closing
>>> MythSocket(0x7f5c20039070)
>>> FE never actually appears:
>> You are mistaken. The FE does not pick up the BE's ip address etc from
>> the BE's mysql.txt. It picks those up from the FE's mysql.txt. That is
>> the purpose of mysql.txt, it tells the frontend where to find the
>> mysql server's database. The datatbase then tells the FE where the
>> master backend is (bearing in mind that the mysql database and the
>> master backend can be on different machines.)
>  I've checked on the BE setup general screen, the local backend and 
> master backend IP addresses are both correct as 192.168.1.100.  
> netstat tells me that it's listening on ports 6543, 6544 and 6545.
>> And actually mysql.txt is not the only place the FE looks.
>> Historically the file was mysql.txt but this has been moved to
>> config.xml, which is the same info in xml format. mysql.txt is
>> preserved for historical reasons. Furthermore these files exist in
>> /etc/mythtv (ie system wide) and ~/.mythtv (per user). Check them all.
>> I am not entirely sure what order they are searched for, and which is
>> preferred if there is a conflict.
>
>
> rs-macbook:.mythtv roger$ cat config.xml
> <Configuration>
> <UPnP>
> <UDN>
> <MediaRenderer>7bc18313-3712-4990-a899-bdb43611e1ff</MediaRenderer>
> </UDN>
> <MythFrontend>
> <DefaultBackend>
> <DBHostName>192.168.1.100</DBHostName>
> <DBUserName>mythtv</DBUserName>
> <DBPassword>xlNd4HV3</DBPassword>
> <DBName>mythconverg</DBName>
> <DBPort>6543</DBPort>
> </DefaultBackend>
> </MythFrontend>
> </UPnP>
> </Configuration>
>
> rs-macbook:.mythtv roger$ cat mysql.txt
> DBHostName=192.168.1.100
> DBPort=6543
> DBUserName=mythtv
> DBPassword=xlNd4HV3
> DBName=mythconverg
> DBType=QMYSQL3
>