[mythtv-users] How to connect a FE to a remote BE

[Glen Hawksworth]

Sorry, I have an update. Typing:

	lsof -i :3306

had no effect but typing:

	sudo lsof -i :3306

returned:

	COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
	mysqld 5558 mysql 13u IPv4 18017     TCP *:mysql (LISTEN)
	mysqld 5558 mysql 73u IPv4 25245     TCP
glen-desktop.local:mysql->192.168.0.103:56928 (ESTABLISHED)

The established with the FE IP address is encouraging however I still
cannot get the FE to connect. I go into Myth Control Centre and test the
MySQL connection and I get a fail every time.

I am beginning to think that I should chuck it all in and start again
but I don't know how or what I would do differently.

I don't know if it is worth anything but when I installed MythTV on the
BE machine it installed Myth Control Centre on it too but it has never
worked. The best I can get it to do is ask me for a password.


On Fri, 2007-11-16 at 20:53 +1100, Glen Hawksworth wrote:
> <quote>
> # Instead of skip-networking the default is now to listen only on
> # localhost which is more compatible and is not less secure.
> </quote>
> 
> Does this mean instead of removing Skip-Networking I should remove
> skip-external-locking?
> 
> I will try it anyway but please let me know if I have done the right
> thing (in case it doesn't solve my problem).
> 
> cheers,
> Glen
> 
> On Fri, 2007-11-16 at 10:10 +0100, Ralf Kleineisel wrote:
> > Glen Hawksworth wrote:
> > 
> > > When I type that I get no response at all
> > > how would I remedy this?
> > 
> > This means that your mysqld is not running or is not listening on the 
> > standard tcp port. If your BE mythtv can connect it probably connects 
> > via socket.
> > 
> > Check your mysqld setup (probably /etc/my.cnf) and your mysqld startup 
> > scripts. skip-networking must not be set.
> > 
> > See http://dev.mysql.com/doc/index.html
> > 
> > 
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> > 
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>