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

[Gareth Blades]

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.