> http://ftp.iq-labs.net/queue_log- > 1.4/asterisk_queue_log_realtime_1.4.19.patch > > This uses standardized realtime/mysql library from asterisk addons. > For it to support SQL inserts in 1.4, you would also need to apply > both patches from (1 for asterisk, another for asterisk-addons) > > http://ftp.iq-labs.net/realtime_store_destroy-1.4/ > > This will later allow you to upgrade to 1.6 and having everything > working without patching.
I have patched in asterisk 1.4 . main/logger.c . include/asterisk/config.h . main/config.c I have patched in asterisk-addons 1.4 . res/res_config_mysql.c I have re-installed asterisk and asterisk-addons. I created a database called db1 and in there created a table called queue_log as per instruction http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL I changed /etc/asterisk/extconfig.conf to add the following line: [settings] queue_log => mysql,db1 I changed /etc/asterisk/res_mysql.conf to add the following: [general] dbhost = localhost dbname = db1 dbuser = user dbpass = password dbport = 3306 dbsock = /var/lib/mysql/mysql.sock 1) However, whenever I perform an agent login, no row is written to table queue_log. I checked /var/log/asterisk/queue_log and a new entry is written there. 2) I set debug to 10 on the console in asterisk and re-did the test but there were no error messages in /var/log/asterisk/messages. 3) I set debug on in mysqld and there are no information for inserting into table queue_log, except the cdr logging as below. Tcp port: 0 Unix socket: (null) Time Id Command Argument 081013 15:59:36 1 Connect [EMAIL PROTECTED] on db1 2 Connect [EMAIL PROTECTED] on db1 081013 16:00:32 1 Query INSERT INTO cdr_log ... 081013 16:01:42 1 Query INSERT INTO cdr_log ... Is there anyone who can help me? _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
