[mythtvnz] New Backend / Existing Frontends

[Tortise]

----- 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.