[mythtv-users] Problem to connect to remote backend

[Ole Jørgen Legård]

> H P Ladds:

> I received similar warnings when accidentally used two differing
> versions of My SQL.

Frontend:
mysql -V
mysql  Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 
5.2

Backend:
mysql -V
mysql  Ver 14.12 Distrib 5.0.51a, for redhat-linux-gnu (x86_64) using 
readline 5.0

Could this be a problem (I have no idea what these differences mean)?

> Nick Morrott:

> Still looks like your frontend cannot communicate with the MySQL
> server. Can you successfully:

> # mysql -h 192.168.1.101 -u mythtv mythconverg -p

mysql -h 192.168.1.101 -u mythtv mythconverg -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.0.51a Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

> (assuming the MySQL server is the same IP as your master backend).
Correct.

> Have you granted access for remote machines to the mythconverg database?
I think so, but I don't remember. How can I verify? Isn't the above result a 
sufficient verification?

> greg:
> Firewall perhaps?
I have opened all the ports I can think of in the firewall, but I have also 
tried when the firewall is disabled. Same result.


I see the following line when starting mythbackend:
2008-09-15 06:27:57.782 Connected to database 'mythconverg' at host: 
localhost

Could this mean that somewhere I have not changed from localhost to my IP 
address, or is this automatically since the database and mythbackend is on 
the same computer?
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users