Messages

2536

QueueMetrics installation / Re: File sql: not found

« on: May 13, 2008, 10:39:11 »

I really find this strange, as there is no different operation done when fetching data for the analysis versus loading, say, user prefrences from the database. Your suggested permissions are even excessive, as QM does not need write access to its own webapp. Still, if it's a security problem.... disable the security manager 

2537

Outbound and QueueMetrics / Re: Using Hot Desking and Outbound Agent ID

« on: May 12, 2008, 09:21:09 »

Yes but you need a bit of custom programming.

The idea is that you store the extension-agent association at logon time and do a lookup by extension in order to get the current agent.

The guidelines are here:
http://queuemetrics.com/faq.jsp#faq-038-agent_tracking

2538

Outbound and QueueMetrics / Re: Queuemetrics not recognising Caller (A Party) hangup on outbound call.

« on: May 12, 2008, 09:07:45 »

 

2539

MySQL storage and Qloaderd/Uniloader / Re: queue_log not writing after system change

« on: May 10, 2008, 09:12:05 »

Are you running SQL storage or flat_file?

2540

Outbound and QueueMetrics / Re: Queuemetrics not recognising Caller (A Party) hangup on outbound call.

« on: May 10, 2008, 09:11:13 »

OK now change the lowercase h line to:

Code: [Select]

exten => h,1,System( echo "${EPOCH}|${UNIQUEID}|${QUEUENAME}|${AGENT}|COMPLETECALLER|0|${ANSWEREDTIME}" >> /var/log/asterisk/queue_log )
This should hang up the call

2541

Running QueueMetrics / Re: Stats on concurrent calls

« on: May 10, 2008, 09:07:32 »

This is not simple to do: it requires a state machine to track how many calls are open at any given moment in time. I think you should do this on a second-.per-second basis, so using SQL grouping functions won't help.

If you can come up with a simpler idea of how to implement that, we are going to implement it as well

2542

QueueMetrics installation / Re: File sql: not found

« on: May 10, 2008, 09:03:23 »

One stupid thing: are you sure you can run a select * on queue_log, i.e. the table is not ruined?

2543

QueueMetrics installation / Re: QM 1.4 and Trixbox 2.6.1

« on: May 10, 2008, 09:00:28 »

Looks like your system is not default-loading Agent channels, so when it tries to login  Agent/5000 it crashes because it knows not of Agent/... channels.

Try this:

Code: [Select]

module unload chan_agent.so
module load chan_agent.so
and see if after that the commands agent show or show agents work.

2544

Outbound and QueueMetrics / Re: Queuemetrics not recognising Caller (A Party) hangup on outbound call.

« on: May 09, 2008, 09:21:42 »

Try doing this:
* add the following lines to context [queuedial], after the rest

Code: [Select]

exten => h,1,NoOp( "Trapped -> lowercase h" )
exten => H,1,NoOp( "Trapped -> uppercase H" )

reload Asterisk and run a trace again lik ethe other one you posted. I want to see if the event of the call closure gets traced or not.

2545

Running QueueMetrics / Re: Stats on concurrent calls

« on: May 09, 2008, 09:15:36 »

My suggestion to do that empirically is to look at the number of lost calls with 15-minute definition, match that to the staffing levels, and see what-where it is going wrong.

2546

QueueMetrics installation / Re: File sql: not found

« on: May 09, 2008, 09:12:52 »

Have you tried using only sql:P000 instead of sql:P000|1 ?
Also, are you sure that all the fields in:

Code: [Select]

sqlPreset.1.table=queue_log
sqlPreset.1.f_time_id=time_id
sqlPreset.1.f_call_id=call_id
sqlPreset.1.f_queue=queue
sqlPreset.1.f_agent=agent
sqlPreset.1.f_verb=verb
sqlPreset.1.f_partition=partition
sqlPreset.1.f_data1=data1
sqlPreset.1.f_data2=data2
sqlPreset.1.f_data3=data3
sqlPreset.1.f_data4=data4
sqlPreset.1.f_incr=unique_row_count
have the same name as the table columns?

2547

QueueMetrics installation / Re: Updating QM

« on: May 09, 2008, 09:09:39 »

Yes as an alternative you can simply delete that file and it will be rebuilt.
Nice to see it's working. 

2548

QueueMetrics installation / Re: Updating QM

« on: May 08, 2008, 18:02:52 »

Is the new webapp working? if you go to http://serverip:8080/queuemetrics-1.4.4b5 do you see anything?
BTW, are you running a custom beta version?

2549

QueueMetrics installation / Re: QM 1.4 and Trixbox 2.6.1

« on: May 08, 2008, 18:00:35 »

    -- Executing [20@queuemetrics:2] NoOp("Local/20@queuemetrics-b2c3,2", " "QM: Logging on Agent/5000 to extension 100@from-internal" ") in new stack
  == Spawn extension (queuemetrics, 20, 3) exited non-zero on 'Local/20@queuemetrics-b2c3,2'

I see that it goes to step 3 and logs nothing. Can you post the modified queuemetrics-extension.conf?

Also please post the response of the CLI command show agents.

2550

Outbound and QueueMetrics / Re: Logging Out Going Calls without having to hit any code?

« on: May 08, 2008, 13:24:58 »

Well basically you should find the Dial() command being called and replace it with the piece of dialplan above. Of course this means that ALL calls made on the system will be logged.