Messages

1

Running QueueMetrics / Solved: Disabling the homepage news bloc

« on: September 18, 2014, 17:08:08 »

Hi,

I want to disable/hide for some users the homepage "news" bloc (div id="news_div"), i found in frontPage.jsp that it was only displayed
when "oC.getI( "DATI_homepageNews")" was greated than zero, but couldn't found where to change this (if it's even possible? )

2

QueueMetrics installation / Re: TOMCAT5_SECURITY=yes, one issue left

« on: January 18, 2009, 19:38:36 »

If you are using call files, there is on permission missing from the previous set:

Code: [Select]

permission java.io.FilePermission "/var/spool/asterisk/outgoing/*", "write";


3

QueueMetrics news / Re: QueueMetrics 1.4.7.1 released

« on: October 24, 2008, 16:25:01 »

About the french translation, i left some thing pass by last time:

there is still some UTF-8 string badly parsed in
WEB-INF/LDec/fr_FR/day_month

The months 2 and 12 are defined using html entity, but not month 8 which is still using UTF-8 string which
doesn't work. a workaround would be:

M8|Août

Also in WEB-INF/LIntl/queuemetrics_fr_FR.properties, the line:

licence_licence_expires_on=ate d'expiration de la licence :

is incorrect, missing a 'D' in front like:

licence_licence_expires_on=Date d'expiration de la licence :

--
benoit

4

Outbound and QueueMetrics / Re: EXPERIMENTAL: replace the queueDial.agi with a pure-scripting solution

« on: October 17, 2008, 12:45:42 »

Hi,

I'm using actually a modified version of the AEL macro qmoutqdial (http://forum.queuemetrics.com/index.php?topic=77.msg276#msg276), where i've added a call to our dialstatus macro to handle
busy/congestion/unavailable signal.

Is there an advantage in your new diaplan version ?

5

Improving QueueMetrics / Re: Queue direction and session reset

« on: June 14, 2008, 17:42:18 »

Ok i got the #2, i had made the update from 1.4.3 to 1.4.4 the wrong way, which hasn't helped.
But tomcat is at fault too, he didn't rebuild his jsp cache, don't know why.

For the #1, yes some number aren't valid in this case, but the number of calls, length of calls are.
And anyway there is a "answered calls per direction" table, what is the use if not for this kind of thing ?

This point me to my number #4: is there a way to customize the report view (ie remove some tables)

EDIT: for the #2 in fact for grouped queue, inbound calls are correctly shown as is, it's outbond calls that
have 'Undefined' for direction. strange

6

Improving QueueMetrics / Queue direction and session reset

« on: June 13, 2008, 13:23:57 »

Few things i would like to see fixed/enhanced in queuemetrics as of now:

1/ Queue Direction
In our setup we have two queues, one 'real' (at least for asterisk) with inbound calls, one 'fake' for outbond calls.
In QM setup we can specify the 'queue direction' for each individual queue, but not when 'grouping' queues
and the call direction in the reports gave 'undefined' for everything.
Quite useless, either we review individual queue reports, for which we already knew the direction,
or we try the grouped reports but then we loss the direction, just where it was needed

2/ Session reset || tomcat restart
When restarting the servlet handler, if you reconnect an previously (to the reset) connected user, you get a message like that (which not very clear, and quite frightening for normal people):

"Errore tecnico nella classe 'it.loway.app.queuemetrics.autenticazione.testNLicMod'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.LicenceException - Stack trace: - -- Inner Exception -- - Exception: java.lang.NoSuchMethodError - Error: - it.loway.tpf.U.hexToBytes(Ljava/lang/String;)[BStack trace: - java.lang.NoSuchMethodError: it.loway.tpf.U.hexToBytes(Ljava/lang/String;)[B - at it.loway.tpf.transaction.cs.CryLicMan.validate(Unknown Source) - at it.loway.tpf.transaction.cs.CryFeatIniter.verify(Unknown Source) - at it.loway.app.queuemetrics.autenticazione.testNLicMod.doRun(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(Unknown Source) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) - at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source) - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) - at java.lang.reflect.Method.invoke(Method.java:585) - at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243) - at java.security.AccessController.doPrivileged(Native Method) - at javax.security.auth.Subject.doAsPrivileged(Subject.java:517) - at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275) - at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:245) - at org.apache.catalina.core.ApplicationFilterChain.access$0(ApplicationFilterChain.java:177) - at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:156) - at java.security.AccessController.doPrivileged(Native Method) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:152) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) - at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) - at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) - at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) - at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) - at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) - at java.lang.Thread.run(Thread.java:595) - -- End Inner Exception -- - - Service Type: TrustManagerFactory - SunX509 - X509 - PKIX - X.509 - SunPKIX - Service Type: CertPathValidator - PKIX - Service Type: SSLContext - TLS - SSL - TLSv1 - SSLv3 - Service Type: CertStore - com.sun.security.IndexedCollection - Collection - LDAP - Service Type: AlgorithmParameterGenerator - DSA - DiffieHellman - OID.1.2.840.113549.1.3.1 - DH - 1.2.840.113549.1.3.1 - Service Type: KeyGenerator - ARCFOUR - Rijndael - Blowfish - HmacSHA256 - RC4 - TripleDES - HmacSHA512 - DESede - HmacSHA384 - AES - HmacMD5 - HmacSHA1 - DES - RC2 - Service Type: Mac - HmacSHA512 - HmacSHA256 - HmacSHA384 - HmacMD5 - HmacSHA1 - HmacPBESHA1 - Service Type: Cipher - ARCFOUR - PBEWithMD5AndDES - Rijndael - OID.1.2.840.113549.1.12.1.6 - Blowfish - PBEWithSHA1AndDESede - PBEWithMD5AndTripleDES - AESWrap - RC4 - PBEWithSHA1AndRC2_40 - RSA - TripleDES - OID.1.2.840.113549.1.5.3 - 1.2.840.113549.1.12.1.3 - DESede - OID.1.2.840.113549.1.12.1.3 - AES - 1.2.840.113549.1.12.1.6 - DESedeWrap - 1.2.840.113549.1.5.3 - DES - RC2 - Service Type: Signature - OID.1.2.840.10040.4.3 - OID.1.2.840.113549.1.1.4 - 1.3.14.3.2.29 - SHA384withRSA - SHA/DSA - OID.1.2.840.113549.1.1.5 - SHA512withRSA - DSS - MD5withRSA - OID.1.2.840.113549.1.1.11 - SHA1withRSA - NONEwithDSA - 1.2.840.113549.1.1.4 - MD5andSHA1withRSA - 1.2.840.113549.1.1.11 - OID.1.2.840.113549.1.1.13 - 1.3.14.3.2.27 - 1.2.840.10040.4.3 - SHA256withRSA - 1.2.840.113549.1.1.2 - 1.2.840.113549.1.1.12 - RawDSA - SHA1withDSA - SHA1/DSA - 1.3.14.3.2.13 - MD2withRSA - SHAwithDSA - DSAWithSHA1 - 1.2.840.113549.1.1.13 - OID.1.3.14.3.2.29 - DSA - 1.2.840.113549.1.1.5 - SHA-1/DSA - OID.1.2.840.113549.1.1.12 - OID.1.2.840.113549.1.1.2 - Service Type: MessageDigest - SHA-512 - SHA1 - MD2 - SHA - SHA-256 - SHA-1 - MD5 - SHA-384 - Service Type: KeyStore - PKCS12 - CaseExactJKS - JKS - JCEKS - Service Type: SecureRandom - NativePRNG - SHA1PRNG - Service Type: KeyPairGenerator - RSA - DSA - 1.2.840.113549.1.1 - 1.2.840.10040.4.1 - OID.1.2.840.113549.1.1 - OID.1.2.840.113549.1.3.1 - DiffieHellman - DH - 1.2.840.113549.1.3.1 - 1.3.14.3.2.12 - OID.1.2.840.10040.4.1 - Service Type: CertificateFactory - X509 - X.509 - Service Type: Provider - id - Service Type: SaslClientFactory - PLAIN - EXTERNAL - CRAM-MD5 - DIGEST-MD5 - GSSAPI - Service Type: KeyManagerFactory - SunX509 - NewSunX509 - Service Type: AlgorithmParameters - PBEWithMD5AndDES - Blowfish - PBEWithSHA1AndDESede - PBE - PBEWithSHA1AndRC2_40 - TripleDES - 1.2.840.113549.1.12.1.3 - 1.2.840.10040.4.1 - DESede - 1.2.840.113549.1.12.1.6 - Rijndael - OID.1.2.840.113549.1.12.1.6 - OAEP - OID.1.2.840.113549.1.3.1 - DiffieHellman - PBEWithMD5AndTripleDES - DH - 1.3.14.3.2.12 - OID.1.2.840.113549.1.5.3 - DSA - OID.1.2.840.113549.1.12.1.3 - AES - 1.2.840.113549.1.3.1 - 1.2.840.113549.1.5.3 - DES - RC2 - Service Type: KeyAgreement - DiffieHellman - OID.1.2.840.113549.1.3.1 - DH - 1.2.840.113549.1.3.1 - Service Type: SecretKeyFactory - PBEWithMD5AndDES - OID.1.2.840.113549.1.12.1.6 - PBEWithSHA1AndDESede - PBEWithMD5AndTripleDES - PBKDF2WithHmacSHA1 - PBE - PBEWithSHA1AndRC2_40 - TripleDES - 1.2.840.113549.1.12.1.3 - OID.1.2.840.113549.1.5.3 - 1.2.840.113549.1.5.12 - OID.1.2.840.113549.1.5.12 - DESede - OID.1.2.840.113549.1.12.1.3 - 1.2.840.113549.1.12.1.6 - 1.2.840.113549.1.5.3 - DES - Service Type: GssApiMechanism - 1.2.840.113554.1.2.2 - Service Type: KeyFactory - RSA - DSA - 1.2.840.113549.1.1 - 1.2.840.10040.4.1 - OID.1.2.840.113549.1.1 - DiffieHellman - OID.1.2.840.113549.1.3.1 - DH - 1.2.840.113549.1.3.1 - 1.3.14.3.2.12 - Service Type: SaslServerFactory - CRAM-MD5 - DIGEST-MD5 - GSSAPI - Service Type: CertPathBuilder - PKIX - - at it.loway.tpf.transaction.cs.CryLicMan.validate(Unknown Source) - at it.loway.tpf.transaction.cs.CryFeatIniter.verify(Unknown Source) - at it.loway.app.queuemetrics.autenticazione.testNLicMod.doRun(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(Unknown Source) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) - at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source) - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) - at java.lang.reflect.Method.invoke(Method.java:585) - at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243) - at java.security.AccessController.doPrivileged(Native Method) - at javax.security.auth.Subject.doAsPrivileged(Subject.java:517) - at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275) - at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:245) - at org.apache.catalina.core.ApplicationFilterChain.access$0(ApplicationFilterChain.java:177) - at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:156) - at java.security.AccessController.doPrivileged(Native Method) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:152) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) - at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) - at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) - at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) - at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) - at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) - at java.lang.Thread.run(Thread.java:595) - -- End Inner Exception -- - - at it.loway.tpf.transaction.cs.CryFeatIniter.verify(Unknown Source) - at it.loway.app.queuemetrics.autenticazione.testNLicMod.doRun(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(Unknown Source) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(Unknown Source) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) - at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source) - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) - at java.lang.reflect.Method.invoke(Method.java:585) - at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243) - at java.security.AccessController.doPrivileged(Native Method) - at javax.security.auth.Subject.doAsPrivileged(Subject.java:517) - at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275) - at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:245) - at org.apache.catalina.core.ApplicationFilterChain.access$0(ApplicationFilterChain.java:177) - at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:156) - at java.security.AccessController.doPrivileged(Native Method) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:152) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) - at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) - at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) - at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) - at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) - at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) - at java.lang.Thread.run(Thread.java:595) - -- End Inner Exception -- - "

After issuing a F5/Ctrl-R i got

Your user session has expired. The webapp will restart automatically in a few seconds.

3/ Error Messages Language
Also a translation of error and log messages from italian to english would be quite usefull,
since not everyone speak italian fluently.

7

QueueMetrics installation / Re: TOMCAT5_SECURITY=yes, one issue left

« on: June 13, 2008, 09:34:04 »

As of now, i have used the following line for this:
permission java.util.PropertyPermission "*", "read,write";

but i think we can cut it down to the 'read' part.

BTW there is another issue with the security manager:
http://forum.queuemetrics.com/index.php?topic=249.0

8

QueueMetrics installation / Re: File sql: not found

« on: June 13, 2008, 09:31:32 »

permission java.security.AllPermission;

Well, to me that's the same as removing the security manager.

9

QueueMetrics installation / Re: File sql: not found

« on: May 14, 2008, 14:08:47 »

Your suggested permissions are even excessive, as QM does not need write access to its own webapp.

Well my permission surely did not allow that.
I added read/write permission to java property for the license.jsp page that was requesting it.

Still, if it's a security problem.... disable the security manager  Grin

well, that's ... not an expected answer

10

QueueMetrics installation / Re: File sql: not found

« on: May 12, 2008, 14:56:29 »

Ok so it is most probably a SecurityPolicy issue.
When i start tomcat without security manager things works

Here are the rules i've added for queuemetrics so far:

grant codeBase "file:/usr/share/tomcat5.5-webapps/queuemetrics/-" {
 permission java.net.SocketPermission "localhost:3306", "connect,resolve";
 permission java.io.FilePermission "/var/log/asterisk/queue_log", "read";
 permission java.util.PropertyPermission "*", "read,write";
};

11

QueueMetrics installation / Re: File sql: not found

« on: May 12, 2008, 11:19:07 »

Well yes the table is fine:

mysql> check table queue_log;
+------------------------+-------+----------+----------+
| Table                  | Op    | Msg_type | Msg_text |
+------------------------+-------+----------+----------+
| queuemetrics.queue_log | check | status   | OK       |
+------------------------+-------+----------+----------+
1 row in set (0.03 sec)


and i can do a select *

12

QueueMetrics installation / Re: File sql: not found

« on: May 09, 2008, 11:02:49 »

Well yes, it's the standard queue_log table from your sql file:

mysql> describe queue_log;
+------------------+------------------+------+-----+---------+----------------+
| Field            | Type             | Null | Key | Default | Extra          |
+------------------+------------------+------+-----+---------+----------------+
| partition        | varchar(20)      | NO   | MUL |         |                |
| time_id          | int(11) unsigned | NO   |     | 0       |                |
| call_id          | varchar(30)      | NO   |     |         |                |
| queue            | varchar(30)      | NO   |     |         |                |
| agent            | varchar(30)      | NO   |     |         |                |
| verb             | varchar(30)      | NO   |     |         |                |
| data1            | varchar(255)     | NO   |     |         |                |
| data2            | varchar(30)      | NO   |     |         |                |
| data3            | varchar(30)      | NO   |     |         |                |
| data4            | varchar(30)      | NO   |     |         |                |
| serverid         | varchar(10)      | NO   |     |         |                |
| unique_row_count | int(10) unsigned | NO   |     | NULL    | auto_increment |
+------------------+------------------+------+-----+---------+----------------+
12 rows in set (0.00 sec)


Also i tried

sql:
sql:P000
sql:P000|1
sql:|2

Edit:
Also what i don't understand is why is there no java exception, nor useful data in the log.
As i said queuemetrics isn't even accessing the database, except for fetching the agent list
before failing with that error

13

QueueMetrics installation / File sql: not found

« on: May 08, 2008, 20:10:39 »

Hi,

I'm having trouble with the Mysql Storage ssytem.
I was able to set-up qloaderd.pl with no problem, the queue_log table schema is the default one,
except for the data1 field size which was too small to fetch our URLs:
alter table queue_log modify data1 varchar(255);

The Mysql Storage Info is correctly seeing the table with all datas:

Partition     Entries     N. calls     From:     To:     Days of data:     Last heartbeat:     
P000    11.140    773      2008-04-21 04:51      2008-05-08 05:59    16,9 days      2008-05-08 05:57

But i keep getting "File sql:P000|1 does not exists" in the custom report setup.

Also i wasn't able to find usefull info in the tomcat logs, no Security error, only:

Code: [Select]

8 mai 2008 20:04:06 org.apache.catalina.core.ApplicationContext log
INFO: [9F07C086390BBC4546A49292995AFA31] ===== Configurazione oggetto Analizzalog ===========
 File        : sql:P000|1
 Tst Iniziale: 1210182300
 Tst Finale  : 1210268700
 Tst corrente: 1210268700
 Agenti amm. : [agent/136, none]
 Code amm.   : [none, support-out, support]
 TZ Offset   : 0
 RewrLocal   : true
 RewrLocalQN : false
 ChiudiCB/QSt: false
 Ign QStart  : false
 Ending ch.na: false
 Min Anom Wai: 1000
 Min Anom Tal: 2000
 Server ID   :
====================================================
===-------------- MYSQL extension ---------------===
 Connection  : com.mysql.jdbc.Connection@773c550f
 Partition   : P000
====================================================

8 mai 2008 20:04:06 org.apache.catalina.core.ApplicationContext log
INFO: LowayTransactionController: [9F07C086390BBC4546A49292995AFA31] [ERR] The file sql:P000|1  does not exist
8 mai 2008 20:04:06 org.apache.catalina.core.ApplicationContext log
INFO: LowayTransactionController: [9F07C086390BBC4546A49292995AFA31] Classe 'it.loway.app.queuemetrics.caricamento.caricaCoda' eseguita in 14  ms
8 mai 2008 20:04:06 org.apache.catalina.core.ApplicationContext log
INFO: LowayTransactionController: [9F07C086390BBC4546A49292995AFA31] Tempo totale esecuzione verbo 'qm_mostra_coda': 28 ms

And even activating mysql query log didn't help, i don't see any queue_log query going thru the database (on the custom report page)

Here is the configuration.property file:

Code: [Select]

default.queue=1

# This is the default queue log file.
default.queue_log_file=sql:|2

#This key is used only as a placeholder for CVS versioning information
00_version=$Id: configuration.properties,v 1.23 2007/11/21 16:11:15 lenz Exp $

#When the realtime page for an agent is computed, the queue_log is NOT read in its entirety but only the last 'n' bytes.
realtime.max_bytes_agent=65000

#The top level directory where monitored calls are held.
#Do NOT forget to add the ending slash.
default.monitored_calls=/var/spool/asterisk/

#How many digits to consider as a default area code
default.areacode_digits=2

default.start_hour=9

default.end_hour=18

default.days=7

#if liveclock is enabled, the system clock is synchronized with asterisk server system clock.
liveclock.enable=true

#The max delay that will be shown in the TOS graph
sla.max_monitored_delay=120

#How big are time intervals for the TOS graph
sla.interval=10

#Your company logo (full or relative path) - shall be resized to be an image 200 x 72
layout.logo=$WEBAPP/img/sm_your_logo.gif

#HTML string displayed on the login page.
layout.splash=Please ask your system administrator for the correct credentials to access this instance of QueueMetrics.

# Preset 1: standard DB access. Edit to suit your DB needs.
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

sqlPreset.2.table=queue_log
sqlPreset.2.f_time_id=time_id
sqlPreset.2.f_call_id=call_id
sqlPreset.2.f_queue=queue
sqlPreset.2.f_agent=agent
sqlPreset.2.f_verb=verb
sqlPreset.2.f_partition=
sqlPreset.2.f_data1=data1
sqlPreset.2.f_data2=data2
sqlPreset.2.f_data3=data3
sqlPreset.2.f_data4=data4
sqlPreset.2.f_incr=unique_row_count

#Is the calls panel in the realtime page invisible by default? 0 false, 1 true
realtime.calls_invisible=0

#Is the agents panel in the realtime page invisible by default? 0 false, 1 true   
realtime.agents_invisible=0

#Are not  the only agents to be shown on the realtime page those who are "known" for the queue? 0 false, 1 true
realtime.members_only=1

#In how many seconds is the realtime page to refresh?
realtime.refresh_time=18


# Do we consider callback agents permanent until logoff (default as Asterisk 1.2), or do they get disconnected at restart?
default.permanentCallBackAgents=true

# Do we take into consideration sessions and calls that are not complet eyet for the main analysis?
default.considerIncompletetEntities=true

#callFile spool dir, set to blank for no call files at all.
callfile.dir=/var/spool/asterisk/outgoing

callfile.monitoring.enabled=true
callfile.monitoring.channel=Local/$EM@from-internal/n
callfile.monitoring.extension=11
callfile.monitoring.context=queuemetrics

callfile.outmonitoring.enabled=true
callfile.outmonitoring.channel=Local/$EM@from-internal/n
callfile.outmonitoring.extension=14
callfile.outmonitoring.context=queuemetrics

callfile.agentdial.enabled=true
callfile.agentdial.channel=Local/13@queuemetrics/n
callfile.agentdial.extension=10
callfile.agentdial.context=queuemetrics

callfile.calloutcome.enabled=true
callfile.calloutcome.channel=Local/12@queuemetrics/n
callfile.calloutcome.extension=10
callfile.calloutcome.context=queuemetrics

callfile.agentlogin.enabled=true
callfile.agentlogin.channel=Local/20@queuemetrics/n
callfile.agentlogin.extension=10
callfile.agentlogin.context=queuemetrics

callfile.agentlogoff.enabled=true
callfile.agentlogoff.channel=Local/21@queuemetrics/n
callfile.agentlogoff.extension=10
callfile.agentlogoff.context=queuemetrics

callfile.agentpause.enabled=true
callfile.agentpause.channel=Local/22@queuemetrics/n
callfile.agentpause.extension=10
callfile.agentpause.context=queuemetrics

callfile.agentunpause.enabled=true
callfile.agentunpause.channel=Local/23@queuemetrics/n
callfile.agentunpause.extension=10
callfile.agentunpause.context=queuemetrics


# Rewrites Local/XXX@ext channels in the format Agent/XXX
default.rewriteLocalChannels=true

# DO NOT CHANGE
realtime.use_sql_now=false

#The default time zone offset. Valid values -24...24 hours
default.timeZoneOffset=0

#If an ongoing call has a wait time that exceeds this value, drop it. 0: ignore
default.maxOngoingWaitTime=1000

#If an ongoing call has a talk time that exceeds this value, drop it. 0: ignore
default.maxOngoingTalkTime=2000

#Ignore QUEUESTART statements.
default.ignoreQueueStarts=false


#The hour of the day to start realtime monitoring or sXX: sliding window of XX hours
realtime.startHour=0


# The default locale for QueueMetrics. DO NOT CHANGE unless you know what you're doing.
default.language=fr
default.country=FR

# Which channel name to show for a call: True: last one seen - False: first one found
default.useEndingChannelName=true

# How to create Excel files: True: Excel 2003 XML - False: CSV
default.useXmlExcel=false

# Show the queue composition or just the main queue name
default.showQueueComposition=true


# how long is an hour for hourly breakdown; default 60 minutes
default.hourly_slot=15

#Add the following key to enable default showing of all subqueues (default: no):
realtime.all_subqueues=0

# Join multi-stint calls as a default
default.joinMultiStintCalls=false

# Uses the starting or ending channel name in case they're different.
default.useEndingChannelName=false


# Decide whether to check for alarms on the wait time of ongoing conversations.
realtime.waitAlarmOnLiveCalls=true
sound.yellowAlarm=../img/sounds/dingdong.wav
sound.redAlarm=../img/sounds/ringer.wav



# Cluster to poll for RT data
# list of pipe-separated members of the cluster
# if callfilesdir = "", the commands will be sent through the manager API
cluster.servers=aleph|trix

cluster.aleph.manager=tcp:dial:12345@10.10.3.5
cluster.aleph.queuelog=sql:P001
cluster.aleph.monitored_calls=z:/qm_streamcall/server_aleph
cluster.aleph.callfilesdir=
cluster.aleph.audioRpcServer=
cluster.aleph.agentSecurityKey=

cluster.trix.manager=tcp:admin:amp111@127.0.0.1
cluster.trix.queuelog=sql:P002
cluster.trix.monitored_calls=z:/qm_streamcall/server_trix
cluster.trix.callfilesdir=
cluster.trix.audioRpcServer=
cluster.trix.agentSecurityKey=


# If true, hide export buttons on the Realtime page
realtime.hideExportButtons=false

# If true, show all agent sessions. If false, show only agent sessions with at least one call.
default.useRawAgentSessions=false

# If true, the agent cannot change their code in the login/logoff/pause popups.
default.lockedAgentPopupCode=false

#If true, the user will not be able to monitor without a given location.
realtime.assignedLocationsOnly=false