[asterisk-users] Ubuntu as remote MySQL server

[mkn0014]

Ronald Wiplinger wrote:
> 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
>   

Try this thread.

http://lists.mysql.com/mysql/183474