[asterisk-users] Ubuntu as remote MySQL server

[Ronald Wiplinger]

mkn0014 wrote:
> 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
>   

Thanks that helped for Astrisk. Basically I just had to change in the
user table of MySQL the field of password to "OLD_PASSWORD" so it makes
a 16 Byte hash instead of new 41 Bytes.

Now I got an additional problem.
I changed in the my.ini   bind=192.168.250.254
That gives me the problem that a local web page cannot access the
database. Can I somehow use two bind? 127.0.0.1 and 192.168.250.254???
Actually I do not understand, because when I am on the server executing
the mysql for the local mysql with -h192.168.250.254 it works, just not
via the web site.