Yes, I certainly applied the patch in http://ftp.iq-labs.net/queue_log-1.4/asterisk_queue_log_realtime_1.4.19. patch
Just to double-check, there is only one patch in this URL which is main/logger.c By the way, did you see anything wrong with my config files? /etc/asterisk/extconfig.conf [settings] queue_log => mysql,db1 /etc/asterisk/res_mysql.conf [general] dbhost = localhost dbname = db1 dbuser = user dbpass = password dbport = 3306 dbsock = /var/lib/mysql/mysql.sock > -----Original Message----- > From: Atis Lezdins [mailto:[EMAIL PROTECTED] > Sent: Monday, 13 October 2008 8:02 PM > To: Lee, John (Sydney) > Cc: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: Re: [asterisk-users] realtime queue_log to mySQL backport to 1.4 > > 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