[mythtvnz] Frontend cannot connect to database...

[Nick Rout]

On Sun, Sep 4, 2011 at 9:50 AM, Worik Stanton <worik.stanton at gmail.com> wrote:
>
>>> 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

You didn't give us the answer to this question.

>>
>> 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
>
>
> _______________________________________________
> 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/
>