[mythtvnz] Frontend cannot connect to database...

[Worik Stanton]

>> What is my best path forward?
> 1. Check mysql on the backend is listenning on the right address
>
> netstat -tanp
>
> should include a line like:
>
> tcp        0      0 0.0.0.0:3306            0.0.0.0:*
> LISTEN      -
Yep

~$ sudo netstat -tanp|grep 3306
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               
LISTEN      27077/mysqld
tcp        0      0 192.168.1.14:3306       192.168.1.10:40976      
ESTABLISHED 27077/mysqld


> 2. Make sure backend is running on the right address:
>
> sudo netstat -tanp|grep mythback
>
> should include lines like:
>
> tcp        0      0 0.0.0.0:6543            0.0.0.0:*
> LISTEN      1277/mythbackend
> tcp        0      0 0.0.0.0:6544            0.0.0.0:*
> LISTEN      1277/mythbackend
>
> If not, come back for more and tell us your breed and version of linux.
>
On backend:

~$ uname -a
Linux mythdu 2.6.35-30-generic #56-Ubuntu SMP Mon Jul 11 20:00:22 UTC 
2011 i686 GNU/Linux

The frontend machine is the same with a different name

~$ uname -a
Linux watcher 2.6.35-30-generic #56-Ubuntu SMP Mon Jul 11 20:00:22 UTC 
2011 i686 GNU/Linux


I did comment out the bind-address line in my.cnf and checked that I can 
conect to themysql database (mythconverg) on the backend from the frontend.

The 4 digit Security Key is synched.

cheers
Worik

> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
>


-- 
The hippies were right