[asterisk-users] realtime_multi_mysql: MySQL RealTime: Invalid database specified
jonas.kellens at telenet.be
Thu Sep 27 05:00:54 CDT 2012
On 27-09-12 11:54, Ishfaq Malik wrote:
> On Thu, 2012-09-27 at 11:00 +0200, Jonas Kellens wrote:
>> this might seem a stupid question but I really don't see the solution
>> to the problem.
>> Using Asterisk 188.8.131.52
>> In extconfig.conf I have :
>> voicemail => mysql,AsteriskHosted,voicemail_users
>> sipusers => mysql,AsteriskHosted,sip_buddies
>> sippeers => mysql,AsteriskHosted,sip_buddies
>> queues => mysql,AsteriskHosted,queues
>> queue_members => mysql,AsteriskHosted,queue_members
>> In res_mysql I have :
>> dbhost = 127.0.0.1
>> dbname = AsteriskHosted
>> dbuser = myuser
>> dbpass = mysecret
>> dbport = 3306
>> dbsock = /var/lib/mysql/mysql.sock
>> requirements=warn ; or createclose or createchar
>> But still I get the error on Asterisk CLI :
>> *CLI> [Sep 27 10:47:20] WARNING: res_config_mysql.c:335
>> realtime_mysql: MySQL RealTime: Invalid database specified:
>> AsteriskHosted (check res_mysql.conf)
>> *CLI> [Sep 27 10:47:57] WARNING: res_config_mysql.c:442
>> realtime_multi_mysql: MySQL RealTime: Invalid database specified:
>> 'AsteriskHosted' (check res_mysql.conf)
>> On 3 other servers I have installed, I have never had this problem.
>> What can be the issue ??
>> Kind regards,
> Shouldn't the config file be called res_config_mysql.conf and not
> res_mysql.conf in 1.8?
On my 3 other Asterisk 1.8 servers there is no problem with the file
res_mysql.conf and no problem with connection to the database.
More information about the asterisk-users