MySQL problem

Anders Forslund, modified 11 Years ago.

MySQL problem

Youngling Posts: 12 Join Date: 1/27/10 Recent Posts
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:

thumbnail
Tobias Schmitt, modified 11 Years ago.

RE: MySQL problem

Padawan Posts: 71 Join Date: 2/12/09 Recent Posts
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
Anders Forslund, modified 11 Years ago.

RE: MySQL problem

Youngling Posts: 12 Join Date: 1/27/10 Recent Posts
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:

thumbnail
Tobias Schmitt, modified 11 Years ago.

RE: MySQL problem

Padawan Posts: 71 Join Date: 2/12/09 Recent Posts
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
Anders Forslund, modified 11 Years ago.

RE: MySQL problem

Youngling Posts: 12 Join Date: 1/27/10 Recent Posts
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:

thumbnail
Christian Petry, modified 11 Years ago.

RE: MySQL problem (Answer)

Youngling Posts: 3 Join Date: 2/12/09 Recent Posts
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

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


Greetings,
Christian
Charles So, modified 13 Years ago.

RE: MySQL problem

Youngling Posts: 11 Join Date: 4/23/11 Recent Posts
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

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


Greetings,
Christian


Hello,

What parameters should I use if PostgreSQL is used?

Much thanks!
thumbnail
Torsten Stolpmann, modified 13 Years ago.

RE: MySQL problem

Jedi Council Member Posts: 759 Join Date: 2/12/09 Recent Posts
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
Charles So, modified 13 Years ago.

RE: MySQL problem

Youngling Posts: 11 Join Date: 4/23/11 Recent Posts
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.
Anders Forslund, modified 11 Years ago.

RE: MySQL problem

Youngling Posts: 12 Join Date: 1/27/10 Recent Posts
Hi Christian!

Thanks for the tip, will try directly after lunch.

Regards

Anders
Anders Forslund, modified 11 Years ago.

RE: MySQL problem

Youngling Posts: 12 Join Date: 1/27/10 Recent Posts
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
thumbnail
Tobias Schmitt, modified 11 Years ago.

RE: MySQL problem

Padawan Posts: 71 Join Date: 2/12/09 Recent Posts
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
thumbnail
Christian Petry, modified 11 Years ago.

RE: MySQL problem

Youngling Posts: 3 Join Date: 2/12/09 Recent Posts
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