Unable to finish "JDBC connection tester"

[mhcordeiro]

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

[QueueMetrics]

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...

[mhcordeiro]

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

[QueueMetrics]

This is okay - but are you sure you did upload the database?

[mhcordeiro]

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...

[QueueMetrics]

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).



 

[mhcordeiro]

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

[mhcordeiro]

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

[QueueMetrics]

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.