[asterisk-users] Ubuntu as remote MySQL server

[Ronald Wiplinger]

Tilghman Lesher wrote:
> 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.
>
>   
Not so good!

I changed bind-address = 192.168.250.254 (that is the ethernet port on
the internal lan of the server)
The result is:
1. the local website on that server cannot access the local database for
the web portal
2. the remote asterisk gets the error:
ERROR 1251: Client does not support authentication protocol requested by
server; consider upgrading MySQL client

I tried to add in the mysqld section of my.ini
old_passwords

but it did not help to overcome.

Besides to upgrade the asterisk machine is there anything I can do now?
I plan to upgrade the Asterisk server including Asterisk in the next weeks.


bye

Ronald