QueueMetrics forum
QueueMetrics => QueueMetrics installation => Topic started by: mhcordeiro on October 01, 2009, 22:31:19
-
Hello All,
I'm installing a brand new asterisk server, and started to install Queuemetrics on it. It is a Suse 10 Server.
Everything went well during installation, however, when I tried to access the application thru my browser (http://myip:8080/queuemetrics), I'm being forwarded to "JDBC connection tester" page.
I then choose to start the data base check. Then in the next page I have the following warning:
"Your database needs updating to run this version of QueueMetrics."
Following below in the same page, I have a table with many itens checked OK, except for 01 error in the end as follows:
Checking current version of table: 'dbversion'
Error
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?
I click on the "next" button to continue the wizard and have the following response:
"The database upgrade and repair process was terminated successfully. "
But in the same page I have an error as follows:
"Below you can find the performed check details: "
|Test performed |Result
1.2.0 | Adding the row counter on queue_log table | Err
Then, after going thru all the wizard, when I have the Start Queuemetrics button available, I click on it, and I'm taken back to the beginning of the process again, and keep on this eternal loop.
Could anybody help?
Thanks in advance,
Marco
-
Didi you upload the initial database? it's trying to update a version that is very very old, so I expect it's a mistake...
-
That's what I thought as weel, however I'm installing version queuemetrics-1.5.4.
As I already mentioned in installing in a Suse server, so I downloaded the RPM packages from http://loway.fileburst.com/RPMS/ , and installed them.
Is this ok? Is it possible to be done that way?
Marco
-
This is okay - but are you sure you did upload the database?
-
By uploading the database you mean the following command?
# mysql -p < queuemetrics_sample.sql
if yes, yes I did.
However, when I was installing "mysql-connector-java-3.1.12-4.noarch.rpm" thru RPM, it gave a notice mentioning that it has mysql server dependency, even though the mysql server was already installed during the server instalation.
I performed the rpm command with the --nodeps option, and it went thru. Now I`m wondering if that has something to do.
Hope not... Mysql Server installed is version 5
Thanks again...
-
Because the error you seem to have is that a table is missing, but that table is created by default since a very old installation.
The MySQL connector has no "physical" dependencies - is it available in the WEB-INF/lib/ path? (even if it is installed on the system, QM may not see it if it's not copied in the correct location).
-
MYSQL Connector is there. I checked WEB-INF/lib path and it had a logical link pointing to the file. Just to make sure I copied the file to the location, but it still not working.
I tried to load database configuration again (mysql -p < queuemetrics_sample.sql
) , and I get the following error:
ERROR 1046 (3D000) at line 28: No database selected
-
Sorry my bad!! I was executing the load of the MYSQL Database in a wrong way, not specifying the destination database to the queuemetrics_sample.sql file.
After doing it in the right way as showed below, problem was solved.
mysql --user=queuemetrics --password=javadude queuemetrics < queuemetrics_sample.sql
Thanks,
Marco
-
So the problem was that Qm was not finding its own tables in the DB. Maybe we should add a sanity check - if there are no tables in the DB, just refuse to upgrade.