Categories » Questions and Answers » MySQL problem
Combination View Flat View Tree View
Threads [ Previous | Next ]
MySQL problem
toggle
MySQL problem
1/28/11 4:43 PM
Hallo!

I´m having problem getting MySQL database working with Klaros.

Have changed the file hibernate.properties with info from Manual, but get some errors during startup and then ending using the apache db insted.

Have you got any other sugestions?

Best Regards

Anders
Attachments: localhost.2010-01-27.log.zip (3.2k)
Flag Flag
RE: MySQL problem
1/28/11 4:43 PM as a reply to Anders Forslund.
Hello Mr. Forslund,

thank you for the attached log file. It seems to me that you try to connect to a non-exisiting database. If you want to connect to a full grown database like MySQL or PostgreSQL you have to create the database 'klaros' on this server first. At the moment we are not able to do that from Klaros-Testmanagement.
Furthermore, the user you are using must have the permissions to create, alter and drop tables on this database.

Of course you can choose a different name for the database. Just use the name you want in the connection url of the "hibernate.properties".

Regards,

Tobias
Flag Flag
RE: MySQL problem
1/28/11 4:43 PM as a reply to Tobias Schmitt.
Hallo Tobias!

Thanks for your quick answer.

I have assumed that klaros testmanagment create all tables in a clean MySQL db, is that correct?

I have created an emty database named klaros, but still it dosent work. Is there anywhere else i should change the search path?
Seams that it cannot connect to the MySQL db anyway, but will insted use Derby.


Anything else you could have in mind helping me out ?

Best Regards

Anders
Attachments: localhost.2010-01-27.log.zip (3.8k)
Flag Flag
RE: MySQL problem
1/28/11 4:43 PM as a reply to Anders Forslund.
Hello Anders,

that's correct Klaros-Testmanagement will create all needed tables on an emtpy database.

To find out what the problem is I need some more information. Can you send me your "hibernate.properties" from your Klaros home folder please? Are your MySQL server and your Klaros-Testmanagement installed on your local machine?

Regards,

Tobias
Flag Flag
RE: MySQL problem
1/28/11 4:43 PM as a reply to Anders Forslund.
Hello Anders,

we tried to reproduce your problem and got the same stacktrace as you when we connected as root to a non-existing database.

Maybe the name of the database and the name in the connection URL do not match.

Greetings,
Christian
Flag Flag
RE: MySQL problem
1/28/11 4:43 PM as a reply to Tobias Schmitt.
Hi again Tobias!

The 2 hibernate.properties files are attached.

Its the same machine that i have MySQL and Klaros installed on.

Regards

Anders
Attachments: hibernate.zip (1.0k)
Flag Flag
RE: MySQL problem
Answer Answer (Unmark)
1/28/11 4:43 PM as a reply to Anders Forslund.
Hello Anders,

it is not necessary to edit the configuration files inside the klaros installation folder. You only have to change the hibernate.properties file in the Klaros home folder (i.e. the .klaros folder in your home directory).

Please revert the changes in the klaros installation folder and change the content of the hibernate.properties file in the Klaros home folder to

1hibernate.dialect=org.hibernate.dialect.MySQLDialect
2hibernate.connection.driver_class=com.mysql.jdbc.Driver
3hibernate.connection.url=jdbc:mysql://localhost:3306/klaros?autoReconnect=true
4hibernate.connection.username=root
5hibernate.connection.password=root


Greetings,
Christian
Flag Flag
RE: MySQL problem
1/28/11 4:43 PM as a reply to Christian Petry.
Hi Christian!

Thanks for the tip, will try directly after lunch.

Regards

Anders
Flag Flag
RE: MySQL problem
1/28/11 4:43 PM as a reply to Christian Petry.
Hi again!

Now its working with MySQL database, thanks for helping a nobe out emoticon

i have other questions during the product. Possibility to get mailcontact ?

Best Regars

Anders
Flag Flag
RE: MySQL problem
1/28/11 4:43 PM as a reply to Anders Forslund.
Hello Anders,

I'm glad to hear that it's working now. For all your remaining questions feel free to contact us at support@verit.de.


Regards,

Tobias
Flag Flag
RE: MySQL problem
4/25/11 6:24 PM as a reply to Christian Petry.
Christian Petry:
Hello Anders,

it is not necessary to edit the configuration files inside the klaros installation folder. You only have to change the hibernate.properties file in the Klaros home folder (i.e. the .klaros folder in your home directory).

Please revert the changes in the klaros installation folder and change the content of the hibernate.properties file in the Klaros home folder to

1hibernate.dialect=org.hibernate.dialect.MySQLDialect
2hibernate.connection.driver_class=com.mysql.jdbc.Driver
3hibernate.connection.url=jdbc:mysql://localhost:3306/klaros?autoReconnect=true
4hibernate.connection.username=root
5hibernate.connection.password=root


Greetings,
Christian


Hello,

What parameters should I use if PostgreSQL is used?

Much thanks!
Flag Flag
RE: MySQL problem
4/25/11 6:28 PM as a reply to Charles So.
Hi Charles,

this information can be found in the manual here: http://www.klaros-testmanagement.com/files/doc/html/User-Manual.Installation.changeDB.html

Regards,

Torsten
Flag Flag
RE: MySQL problem
4/25/11 6:34 PM as a reply to Torsten Stolpmann.
Hi Torsten

Thank you very much.

Never know it is in the User's Manual. I would've thought it is in the Admin Manual and it couldn't be found.
Flag Flag