Hi John,
On Mon, Oct 13, 2008 at 9:51 AM, Lee, John (Sydney) <[EMAIL PROTECTED]> wrote: >> http://ftp.iq-labs.net/queue_log- >> 1.4/asterisk_queue_log_realtime_1.4.19.patch Haven't you forgotten this one? ;) if you have applied everything correctly - queue_log file shoudln't have any more lines (except init when restarting asterisk). Regards, Atis >> >> 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? > > -- Atis Lezdins, VoIP Project Manager / Developer, [EMAIL PROTECTED] Skype: atis.lezdins Cell Phone: +371 28806004 Cell Phone: +1 800 7300689 Work phone: +1 800 7502835 _______________________________________________ -- 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