Queue log is not getting dummped in to mysql database


I have asterisk installed on my centOS. I want to log the queue_log data in to mysql DB. But its not going to DB though the entries are there in the ‘/var/log/asterisk/queue_log’.

I m getting warning on my CLI :


[quote]queue_log => mysql,general ; for asterisk-1.6.x here we have to specify the context instead of database name


;dbhost = localhost
dbhost =
dbname = asterisk
dbuser = root
dbpass = rig@1123
dbport = 3306
dbsock = /tmp/mysql.sock





The above issue is resolved.

MySQL devel should be properly install. check it out if it is not there then :

Run the following from the CLI :

[quote]*CLI> core show config mappings
Config Engine: curl => mysql mapping was not there
*CLI> module show like mysql
*CLI> No modules available[/quote]

I have reloaded the mysql config module.

[quote]*CLI> module reload res_config_mysql.so
== MySQL RealTime reloaded.

*CLI> core show config mappings
Config Engine: curl
Config Engine: mysql
===> queue_log (db=general, table=queue_log)

*CLI> module show like mysql
Module Description Use Count
app_addon_sql_mysql.so Simple Mysql Interface 0
res_config_mysql.so MySQL RealTime Configuration Driver 0
cdr_addon_mysql.so MySQL CDR Backend 0
3 modules loaded

Now, the queue log and the agent status is dumped to mysql database properly.

:smile: Urmi :smile: