1
QueueMetrics installation / emergency problems updating from 1.5 to 1.6.0.1
« on: April 20, 2010, 23:05:16 »
one of IT guys run a yum update in the queueemetrics server and now we have this page:
QueueMetrics JDBC connection tester
We have detected that your QueueMetrics database needs updating.
Your current configuration is:
* XML configuration file found at:
/usr/local/queuemetrics/webapps/queuemetrics-1.6.0.1/WEB-INF/web.xml
* JDBC URI configured as:
jdbc:mysql://localhost/queuemetrics?autoReconnect=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude
Under this configuration you are ready to run the JDBC connection tester.
This wizard will guide you between steps required to check and update, if required, the QueueMetrics database. Please click on the button below to start the procedure.
when i run the wizard it gives me error :
Checking current version of table: 'agenti_noti' Error Java Error: Errore DB: java.sql.SQLException: Unknown column 'group_by' in 'field list' The required database table 'agenti_noti' is missing some fields. Are you updating from a previous version of QM?
and when i continue give me :
Below you can find the performed check details:
Test performed Test result
1.5.2 Increase queue name in queue_log Err
and i can't get the QM back to work, need help asap
thanks
QueueMetrics JDBC connection tester
We have detected that your QueueMetrics database needs updating.
Your current configuration is:
* XML configuration file found at:
/usr/local/queuemetrics/webapps/queuemetrics-1.6.0.1/WEB-INF/web.xml
* JDBC URI configured as:
jdbc:mysql://localhost/queuemetrics?autoReconnect=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude
Under this configuration you are ready to run the JDBC connection tester.
This wizard will guide you between steps required to check and update, if required, the QueueMetrics database. Please click on the button below to start the procedure.
when i run the wizard it gives me error :
Checking current version of table: 'agenti_noti' Error Java Error: Errore DB: java.sql.SQLException: Unknown column 'group_by' in 'field list' The required database table 'agenti_noti' is missing some fields. Are you updating from a previous version of QM?
and when i continue give me :
Below you can find the performed check details:
Test performed Test result
1.5.2 Increase queue name in queue_log Err
and i can't get the QM back to work, need help asap
thanks