Author Topic: Table 'queuemetrics.arch_classes' doesn't exist  (Read 4920 times)

Luffy49

  • Newbie
  • *
  • Posts: 7
  • Karma: 0
    • View Profile
Table 'queuemetrics.arch_classes' doesn't exist
« on: October 05, 2009, 11:59:02 »
Hi,

I try to install queuemetrics on Centos with asterisk 1.6

I had install queuemetrics like that :

yum install queuemetrics.

But when i run :

http://192.168.1.5:8080/queuemetrics/

All is OK exept :

Checking if exists database table: 'arch_classes'     Error     Java Error: Problema DB: java.sql.SQLException: Table 'queuemetrics.arch_classes' doesn't exist The required database table 'arch_classes' is missing or unreadable.


How can i solve it ?

Luffy49

  • Newbie
  • *
  • Posts: 7
  • Karma: 0
    • View Profile
Re: Table 'queuemetrics.arch_classes' doesn't exist
« Reply #1 on: October 05, 2009, 12:05:49 »
I run installDb.sh

and now i have :

Java Error: Errore DB: java.sql.SQLException: Unknown column 'lic_version' in 'field list' The required database table 'dbversion' is missing some fields. Are you updating from a previous version of QM?

Luffy49

  • Newbie
  • *
  • Posts: 7
  • Karma: 0
    • View Profile
Re: Table 'queuemetrics.arch_classes' doesn't exist
« Reply #2 on: October 05, 2009, 12:20:34 »
I solve my issue by executing database_sample.sql but i have another one :

I don't understand how queuemetrics and asterisk are linked. because in queueMetrics I don't have my asterisk queue.

and no information in stat


Luffy49

  • Newbie
  • *
  • Posts: 7
  • Karma: 0
    • View Profile
Re: Table 'queuemetrics.arch_classes' doesn't exist
« Reply #3 on: October 05, 2009, 16:55:26 »
OK all works

exept i don't see my queue and agent in interface :(

i only see DSP and Test queues

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Table 'queuemetrics.arch_classes' doesn't exist
« Reply #4 on: October 06, 2009, 09:01:19 »
1. are QM and Asterisk on the same box or on different boxes?
2. you should create the queues you are using in QM, so QM can report on them....