[asterisk-users] Ubuntu as remote MySQL server

[Tilghman Lesher]

On Monday 26 May 2008 01:32:31 Ronald Wiplinger wrote:
> Tilghman Lesher wrote:
> > On Monday 26 May 2008 00:46:16 Ronald Wiplinger wrote:
> >> Tilghman Lesher wrote:
> >>
> >> I added the Grant statement
> >>
> >> GRANT select,insert,update ON asterisk.* to astuser at 192.168.1.20
> >> IDENTIFIED BY 'somepassword';
> >>
> >>
> >> reloaded the privileges, and still get the same problem:
> >> [May 26 13:40:48] ERROR[3109]: res_config_mysql.c:651 mysql_reconnect:
> >> MySQL RealTime: Failed to connect database server astconf on
> >> 192.168.250.254 (err 2003). Check debug for more info.
> >>
> >>
> >> # mysql -uastuser -h192.168.250.20 -p
> >> Enter password:
> >> ERROR 1045: Access denied for user: 'astuser at vpbx.elmit.com' (Using
> >> password: YES)
> >
> > Okay, you're failing to connect to 192.168.250.254 in the Asterisk
> > config, yet you're connecting to 192.168.250.20 in the test.  So check
> > your IP addresses carefully, to ensure that you're trying to connect to
> > the correct server.
>
> Sorry, I miss spelled it. It gives me another error:
>  # mysql -uastuser -h192.168.250.254 -p
> Enter password:
> ERROR 2003: Can't connect to MySQL server on '192.168.250.254' (111)
>
> Remains the same problem, I cannot connect.
> How can I further test why it does not connect?

Okay, progress.  You probably don't have MySQL configured to listen on its
TCP port (this is disabled by default).  Check for the line 'skip-networking'
in /etc/mysql/my.cnf or bind-address=127.0.0.1.  Either setting will prevent
MySQL from listening on the public addresses.

-- 
Tilghman