Author Topic: Unable to finish "JDBC connection tester"  (Read 5558 times)

mhcordeiro

  • Newbie
  • *
  • Posts: 12
  • Karma: 0
    • View Profile
    • Email
Unable to finish "JDBC connection tester"
« 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

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Unable to finish "JDBC connection tester"
« Reply #1 on: October 02, 2009, 12:35:36 »
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

  • Newbie
  • *
  • Posts: 12
  • Karma: 0
    • View Profile
    • Email
Re: Unable to finish "JDBC connection tester"
« Reply #2 on: October 07, 2009, 19:45:58 »
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

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Unable to finish "JDBC connection tester"
« Reply #3 on: October 08, 2009, 17:36:52 »
This is okay - but are you sure you did upload the database?

mhcordeiro

  • Newbie
  • *
  • Posts: 12
  • Karma: 0
    • View Profile
    • Email
Re: Unable to finish "JDBC connection tester"
« Reply #4 on: October 08, 2009, 19:18:34 »
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

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Unable to finish "JDBC connection tester"
« Reply #5 on: October 09, 2009, 08:04:00 »
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

  • Newbie
  • *
  • Posts: 12
  • Karma: 0
    • View Profile
    • Email
Re: Unable to finish "JDBC connection tester"
« Reply #6 on: October 09, 2009, 15:24:41 »
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

  • Newbie
  • *
  • Posts: 12
  • Karma: 0
    • View Profile
    • Email
Re: Unable to finish "JDBC connection tester"
« Reply #7 on: October 09, 2009, 16:20:42 »
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

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Unable to finish "JDBC connection tester"
« Reply #8 on: October 10, 2009, 09:32:26 »
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.