Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - MAbdullah47

Pages: [1]
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 / Re: QueueDial script Installation On Asterisk Machine
« on: October 04, 2007, 10:49:24 »
Ok , I think I'll go to Queuemetrics better now I understand you are right
Thanks.
I want you also to help on my second question:
http://forum.queuemetrics.com/index.php?topic=123.0

3
MySQL storage and Qloaderd/Uniloader / Re: QueueDial script Installation On Asterisk Machine
« on: October 03, 2007, 13:58:57 »
Quote from: QueueMetrics on October 03, 2007, 11:18:31
I mean, what are you doing that for? calculate usage statistics?

Yes

4
MySQL storage and Qloaderd/Uniloader / Re: QueueDial script Installation On Asterisk Machine
« on: October 03, 2007, 09:20:36 »
stats?

5
MySQL storage and Qloaderd/Uniloader / Re: Some Queue Log Information Not Logged Into the table
« on: October 02, 2007, 14:58:47 »
On My soft phone I pressed 900* then It gets login + password and succeffuly logged on but this events didn't registered on my log file, why?

6
MySQL storage and Qloaderd/Uniloader / Re: Some Queue Log Information Not Logged Into the table
« on: October 02, 2007, 14:56:41 »
Here is a sample for what i did on extensions.conf :

[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]
; removequeuemember - 423
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 there is no any Event of Agentlogin or Agentlogoff registered on my queue_log file nor In Queue_log table , what is the modification taht I should do on my previous text.

7
MySQL storage and Qloaderd/Uniloader / Re: QueueDial script Installation On Asterisk Machine
« on: October 02, 2007, 12:33:53 »
I'm not planing to install queuemetrics ,Just database loader .

8
MySQL storage and Qloaderd/Uniloader / Re: Some Queue Log Information Not Logged Into the table
« on: October 02, 2007, 12:32:32 »
I got some information here:

http://queuemetrics.com/faq.jsp#faq-018-dynamic_agents

But How I Implement what is inside the link on my real case , my real case is:

I have Queue name (900) and three Agent members:
Agent/101
Agent/102
Agent/103

I want the log to register each login / logoff activities .

Note: I'm not Installed queuemetrics on my machine Just only queuelodered 1.7

Thanks

9
MySQL storage and Qloaderd/Uniloader / Re: Some Queue Log Information Not Logged Into the table
« on: October 02, 2007, 08:12:50 »
Can You Help me by some example step by step on how to Add Commands that do what I need to register those events, Either through the FreePbx web site or through extensions.conf precisely .

10
MySQL storage and Qloaderd/Uniloader / Re: Some Queue Log Information Not Logged Into the table
« on: October 01, 2007, 13:07:57 »
Shall I do something on the Queue Or SIP user to Allow registering for login/log off event?

11
MySQL storage and Qloaderd/Uniloader / Re: Some Queue Log Information Not Logged Into the table
« on: October 01, 2007, 11:51:28 »
Can You Explain Precisely how it depends on the DialPlan?

12
MySQL storage and Qloaderd/Uniloader / Re: QueueDial script Installation On Asterisk Machine
« on: October 01, 2007, 11:50:07 »
No ,Quemetrics is not installed on any machine, I have two servers 1 Linux (Trixbox) CentOS release 4.4 as OS machine
The Other Machine is for MySQL 5.0 based on (Win 2000 server) , the first machine Qloader is installed on it and works successfuly.

13
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)?


14
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

Pages: [1]