Author Topic: Errors installing quemetrics on trixbox 2.4  (Read 2690 times)

jeandn23

  • Newbie
  • *
  • Posts: 4
  • Karma: 0
    • View Profile
    • Email
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
 




QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Errors installing quemetrics on trixbox 2.4
« Reply #1 on: July 26, 2008, 16:51:27 »
Looks like the DB was not installed successfully.
Try dropping the database "queuemetrics" and repeating steps 3 and 4.