Topics

1

MySQL storage and Qloaderd/Uniloader / Some Queue_Log events not registerd on the file & On the database table

« on: October 05, 2007, 14:39:15 »

Dear Members

I implemented the queueloader on my server machines successfully, I notices that some (Queue Log Information) is not registered on the database table (log_file) based on the information on this link:
http://www.voip-info.org/tiki-index.php?page=Asterisk+log+queue_log

The majority of the log information registered on the database successfully e.g.: COMPLETECALLER & COMPLETEAGENT but some of important information’s are not (never) registered like:(AGENTLOGOFF/AGENTLOGIN/AGENTCALLBACKLOGOFF) never registered in (queue_log.conf) , I tried many times to switch off the telephone(X-Lite soft phone) powers and on it again and register a new user but it never registered on the database any one have feed back on how to resolve this issue.Some information like(CONNECT(holdtime),ENTERQUEUE(url|callerid)  is registered on the database and some times are not registered.

I noticed also that (EXITWITHTIMEOUT) & (ABANDON) registered on the queue_log.conf file but not on the database , later when rewrite (qloader.pl) and Set the line: my $use_subqueue = 1 and created TABLE qlog_opencalls the two events (EXITWITHTIMEOUT) & (ABANDON) registered on the database table(qlog_opencalls) but without determining the time that the caller wasting when terminating the call , how I can solve this problem?.

I rewrite my (extensions.conf) to insert a dialplan that may solve the problem of (AGENTLOGIN) & (AGENTLOGOFF) , Here is a sample for what i did on extensions.conf :
I have Queue name (900) and three Agent members:
Agent/101
Agent/102
Agent/103

[agentlogin]
exten => s,1,AddQueueMember(900,Agent/${CALLERID(num)})
exten => s,n,System( echo 
"${EPOCH}|${UNIQUEID}|NONE|Agent/${CALLERID(num)}|AGENTLOGIN|-" >> /var/log/asterisk/queue_log )
exten => s,n,Hangup()


[agentgogoff]
exten => s,1,RemoveQueueMember(900,Agent/${CALLERID(num)})
exten => s,n,DBget(ORGEPOCH=dynlogin/log_Agent-${CALLERID(num)})
exten => s,n,Set(RV=$[${EPOCH} - ${ORGEPOCH}])
exten => s,n,GotoIf($["${RV}" = "0"]?8:6)
exten => s,n,System( echo  "${EPOCH}|${UNIQUEID}|NONE|Agent/${CALLERID(num)}|AGENTLOGOFF|-|${RV}" >> /var/log/asterisk/queue_log )
exten => s,n,Hangup

but still (AgentLogin)&(AGENTLOGOFF) not registered on the (queue_log.conf) file nor on the (DB) table.


Thanks

2

MySQL storage and Qloaderd/Uniloader / QueueDial script Installation On Asterisk Machine

« on: October 01, 2007, 10:21:03 »

Dear Members

 Any one can help me how to install (QueueDial 1.5 ) that founded on this link:http://queuemetrics.com/download.jsp?

Please note that I only implemented installation for (Qloader) on my asterisk machine and it works successfuly , my machine doesn't have (Quemetrics) so is needed to be implemented with (QueueDial 1.5)?

3

MySQL storage and Qloaderd/Uniloader / Some Queue Log Information Not Logged Into the table

« on: October 01, 2007, 09:52:38 »

Dear Members

I implemented the queueloader on my server machines successfully, I notices that some (Queue Log Information) is not registered on the database table (log_file) based on the information on this link:
http://www.voip-info.org/tiki-index.php?page=Asterisk+log+queue_log

The majority of the log information registered on the database successfully but some of important information’s are not (never) registered like:(AGENTLOGOFF/AGENTLOGIN/AGENTCALLBACKLOGOFF) , I tried many times to switch off the telephone(X-Lite soft phone) powers and on it again and register a new user but it never registered on the database any one have feed back on how to resolve this issue.
Some information like(CONNECT(holdtime),ENTERQUEUE(url|callerid)  is registered on the database and some times are not registered.

I Also notices that Qloader will stop if there were no any activity specially at night so what Is the steps that should take place to reactivate qloader?
How I keep it active even if there are no call activities on the network?

Thanks