[mythtvnz] Frontend cannot connect to database...

[Nick Rout]

On Sat, Sep 3, 2011 at 4:12 PM, Worik Stanton <worik.stanton at gmail.com> wrote:
> I am setting up a front end and it cannot connect to the backends database.
>
> When  I run the frontend it hangs at "New DB connection, total: 1"
>
> The passwords, names of database, user etcetera match on the frontend
> and backend.
>
> A connection is made. the backend log reports "2011-09-03 16:09:14.911
> MainServer, Warning: Unknown socket closing MythSocket(0x9990850)" when
> I start and close the frontend.
>
> I am not sure what to do next.  My memory tells me that MySQL out of the
> box does not accept remote queries but I cannot remember how to check.
>
> 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      -

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.