[mythtv-users] mythfrontend can't connect to backend/database

[starcycle]

omg - I can't believe it. i think it was the /etc/hosts.allow file. I
added mysqld: <lan IP> and now it's working. :-o  I read something
authoritative on linuxquestions about 12 hours ago saying mysql didn't
use tcp wrappers so I just ruled it out -- i guess that was wrong!
well, at least it's working now. I can't believe it was hosts.allow!!!

thanks to everyone for your help & patient replies.

cheers

On Sun, Apr 20, 2008 at 9:15 PM, Phil Bridges <gravityhammer at gmail.com> wrote:
>
> On Sun, Apr 20, 2008 at 9:06 PM, starcycle <starcycle at gmail.com> wrote:
>  > On Sun, Apr 20, 2008 at 8:56 PM, starcycle <starcycle at gmail.com> wrote:
>  >  > On Sun, Apr 20, 2008 at 8:51 PM, starcycle <starcycle at gmail.com> wrote:
>  >  >  >
>  >  >  >  root at moe:~ # perror l
>  >  >  >  OS error code   0:  Success
>  >  >
>  >  >  oh shoot - I guess that was supposed to be perror 1. :p
>  >  >
>  >  >  root at moe:~ # perror 1
>  >  >
>  >  > OS error code   1:  Operation not permitted
>  >  >
>  >  >  okay - so perhaps changing /var/run/mysqld to /var/lib/mysql would
>  >  >  work? trying ... thanks
>  >  >
>  >
>  >  Nope, didn't work. Also, that wouldn't explain why the localhost can
>  >  access the database, would it? only the networked clients can't access
>  >  it.
>  >
>  >  damn, i'm about ready to give up. nothing on linux has ever given me
>  >  this much trouble. it doesn't make sense -- something apparently is
>  >  just fubared.
>  >
>
>  Look at your my.cnf on your backend.  What does it say in this section?
>  # security:
>  # using "localhost" in connects uses sockets by default
>  # skip-networking
>  # bind-address                          = 127.0.0.1
>
>
> _______________________________________________
>  mythtv-users mailing list
>  mythtv-users at mythtv.org
>  http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>