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

Jonas Kellens jonas.kellens at telenet.be
Wed Sep 8 10:13:38 CDT 2010


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.






More information about the asterisk-users mailing list