[asterisk-users] Upgrade from 1.4 to 1.6 : problems with realtime mysql

[Jonas Kellens]

On 09/08/2010 05:18 PM, Gareth Blades wrote:
> Jonas Kellens wrote:
>    
>> On 09/08/2010 04:50 PM, Gareth Blades wrote:
>>      
>>> Jonas Kellens wrote:
>>>
>>>        
>>>> Hello,
>>>>
>>>> in asterisk 1.4.30 all realtime configurations go well.
>>>>
>>>> In asterisk 1.6.2.11 the following appears on CLI :
>>>>
>>>> [Sep  8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql:
>>>> MySQL RealTime: Invalid database specified: MyDBase (check res_mysql.conf)
>>>> [Sep  8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql:
>>>> MySQL RealTime: Invalid database specified: MyDBase (check res_mysql.conf)
>>>>
>>>> res_mysql.conf :
>>>>
>>>> [general]
>>>> dbhost = 127.0.0.1
>>>> dbname = MyDBase
>>>> dbuser = asterisk
>>>> dbpass = mysecret
>>>> dbport = 3306
>>>> dbsock = /tmp/mysql.sock
>>>> requirements=warn ; or createclose or createchar
>>>>
>>>>
>>>> What do I need to change to be conform asterisk 1.6 ?!
>>>>
>>>> Reloading, restarting asterisk and restarting my CentOS-server all
>>>> doesn't help.
>>>>
>>>>
>>>> Jonas.
>>>>
>>>>
>>>>          
>>> You have no entry called MyDBase in there.
>>> Rename '[general]' to '[MyDBase]' and give it another go.
>>>
>>>        
>> This did not work.
>>
>> This is the message :
>>
>> [Sep  8 17:08:43] ERROR[1843]: res_config_mysql.c:1575 mysql_reconnect:
>> MySQL RealTime: Failed to connect database server MyDBase on 127.0.0.1
>> (err 1045). Check debug for more info.
>> [Sep  8 17:08:43] ERROR[1843]: res_config_mysql.c:1575 mysql_reconnect:
>> MySQL RealTime: Failed to connect database server MyDBase on 127.0.0.1
>> (err 1045). Check debug for more info.
>>
>>
>> However my log /var/log/asterisk/debug has no entry of today... Which
>> debug info can I check then ?!
>>
>>
>> Jonas.
>>
>>
>>
>>
>>      
> You are closer.
> 1) Make sure the myDBase database exists and the asterisk user has
> permission to access it.
> 2) You have an IP address&  port together with a socket filename listed.
> Decide whhich method you want to use and remove the configuration for
> the other.
>    


Created another user on the MySQL-DB and now it works...

Thanks.

Jonas.