[mythtvnz] New Backend / Existing Frontends

[Nick Rout]

On Tue, Feb 9, 2010 at 10:16 PM, Tortise <tortise at paradise.net.nz> wrote:
> ----- Original Message -----
> From: Duncan Kennington
> To: MythTV in NZ
> Sent: Tuesday, February 09, 2010 9:27 PM
> Subject: Re: [mythtvnz] New Backend / Existing Frontends
>
>
> MySQL have skip-networking commented out in the mysql configuration?
>
>
> On 9 February 2010 21:23, Tortise <tortise at paradise.net.nz> wrote:
>
> I've setup a new FE/BE and got it running.
> The existing and previously fine FE's cannot connect to the new box, they have somehow got the correct new password, hostname is
> correct however there is an asterisk by this complaining about not being able to connect to the database.  The BE setup included the
> "0000" to allow other boxes to access.
> Anyone got any ideas what's blocking the FE's on the new FE/BE?
>
>
> _______________________________________________
>
> Thanks for the tip.
>
> I think http://www.mythtv.org/docs/mythtv-HOWTO-6.html is now out of date for mythbuntu 9.10, /etc/mysql/my.cnf now includes:
>
> # Instead of skip-networking the default is now to listen only on
> # localhost which is more compatible and is not less secure.
> #bind-address           = 127.0.0.1        #<<<<<< I commented out and added:
> bind-address            = w.x.y.1             #where w,x and y subs with actual LAN numbers!
>
>
>
> :~$ sudo mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 753
> Server version: 5.1.37-1ubuntu5 (Ubuntu)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
>
>
> mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> flush privileges;
> Query OK, 0 rows affected (0.00 sec)
>
> Still no go.  Hmmm.
>

sudo dpkg-reconfigure mythtv-database

and maybe

sudo dpkg-reconfigure mythtv-common

if that doesn't fix it, look at the frontend logs on the machines that
cannot connect.

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