MySQL problem - Klaros Test Management - Forum - Klaros Test Management
MySQL problem
Anders Forslund, modified 10 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
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:
Tobias Schmitt, modified 10 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
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 10 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
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:
Tobias Schmitt, modified 10 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
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 10 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
The 2 hibernate.properties files are attached.
Its the same machine that i have MySQL and Klaros installed on.
Regards
Anders
Attachments:
Christian Petry, modified 10 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
Greetings,
Christian
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 PostsChristian 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
Greetings,
Christian
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!
Torsten Stolpmann, modified 13 Years ago.
RE: MySQL problem
Jedi Council Member Posts: 755 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
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.
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 10 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
Thanks for the tip, will try directly after lunch.
Regards
Anders
Anders Forslund, modified 10 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
i have other questions during the product. Possibility to get mailcontact ?
Best Regars
Anders
Now its working with MySQL database, thanks for helping a nobe out
i have other questions during the product. Possibility to get mailcontact ?
Best Regars
Anders
Tobias Schmitt, modified 10 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
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
Christian Petry, modified 10 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
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