Messages

1

QueueMetrics installation / Errors installing quemetrics on trixbox 2.4

« on: July 24, 2008, 07:59:48 »

This is a fresh installation of trixbox 2.4

I did the following as on the manual:

1) wget -P /etc/yum.repos.d http://yum.loway.ch/loway.repo
2) yum install queuemetrics
3) cd /usr/local/queuemetrics/webapps/queuemetrics-1.4.4/WEB-INF/README
4) ./installDb.sh


i get the following error when accessing the web interface at port 8080:


A problem occurred in QueueMetrics.

The following error occurred in the Transaction handler:
"Errore tecnico nella classe 'it.loway.app.queuemetrics.autenticazione.caricaDatiIniziali'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - Errore DB: java.sql.SQLException: Table 'queuemetrics.code_possibili' doesn't exist - at it.loway.tpf.SQL.selectLtt(Unknown Source) - at it.loway.app.queuemetrics.autenticazione.caricaDatiIniziali.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.doGet(Unknown Source) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) - at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) - at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) - at java.lang.Thread.run(Thread.java:595) - -- End Inner Exception -- - " 


--------------------------------------------------------------
Now testing the JDBC connection...
# 1 Checking for the XML parser Ok
# 2 Reading JDBC URL from WEB-INF/web.xml Ok
# 3 Loading MySQL JDBC driver Ok
# 4 Connecting to the database Ok
# 5 Checking database table: arch_classes Error
 Problem encountered:
The required database table 'arch_classes' is missing or unreadable.
Java Error:
Problema DB: java.sql.SQLException: Table 'queuemetrics.arch_classes' doesn't exist
 

2

General Asterisk configuration / Re: Queue login error

« on: March 03, 2008, 07:14:27 »

Hi

Yes, It does exist.

Created from freepbx, of course Asterisk was restated, when applying changes from freepbx.

Thanks

3

General Asterisk configuration / Re: Queue login error

« on: February 29, 2008, 20:37:08 »

agents.conf:

; This section contains the agent definitions, in the form:
;
; agent => agentid,agentpassword,name
;

autologoff=15
wrapuptime=5000
ackcall=no

group=1
agent => 444101,,Ben


I have create extension 444101 from the freepbx.

So when i dial 298, it asks for " please enter your agent number followed by #" i have entered 444101#, then it will ask for the extension, i have entered 444101#


I am using trixbox 2.2.8


Then it will agent logged in , then say " your call can not be completed as dialed, then hang up"


Any idea?

4

General Asterisk configuration / Queue login error

« on: February 29, 2008, 09:07:24 »

I have followed the lasted queue metrics trixbox guide.

When i try to call 298 to log in, it asks for agent then extension.

I enter 444101# then 444101#  , then it says agent logged in.

And then it will that your extension can not be dialed.

I was watching the Asterisk CLI and it looks like it is trying to play "silence"


Here is the CLI messages:

Feb 29 01:54:51 VERBOSE[15048] logger.c: -- Executing NoCDR("SIP/444101-0874f2f0", "") in new stack
Feb 29 01:54:51 NOTICE[15048] cdr.c: CDR on channel 'SIP/444101-0874f2f0' not posted
Feb 29 01:54:51 NOTICE[15048] cdr.c: CDR on channel 'SIP/444101-0874f2f0' lacks end
Feb 29 01:54:51 VERBOSE[15048] logger.c: -- Executing Wait("SIP/444101-0874f2f0", "1") in new stack
Feb 29 01:54:52 VERBOSE[15048] logger.c: -- Executing Playback("SIP/444101-0874f2f0", "silence/1&cannot-complete-as-dialed&check-number-dial-again|noanswer") in new stack
Feb 29 01:54:52 VERBOSE[15048] logger.c: -- Playing 'silence/1' (language 'en')
Feb 29 01:54:53 VERBOSE[15048] logger.c: -- Playing 'cannot-complete-as-dialed' (language 'en')
Feb 29 01:54:56 VERBOSE[15048] logger.c: -- Playing 'check-number-dial-again' (language 'en')
Feb 29 01:54:58 VERBOSE[15048] logger.c: -- Executing Wait("SIP/444101-0874f2f0", "1") in new stack
Feb 29 01:54:59 VERBOSE[15048] logger.c: == Spawn extension (from-internal, 298, 5) exited non-zero on




Any ideas how to resolve this?


Thanks