MySQL problem - Klaros Test Management - Forum - Klaros-Testmanagement
MySQL problem
Anders Forslund, geändert vor 10 Jahren.
MySQL problem
Youngling Beiträge: 12 Beitrittsdatum: 27.01.10 Neueste Beiträge
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
Anhänge:
Tobias Schmitt, geändert vor 10 Jahren.
RE: MySQL problem
Padawan Beiträge: 71 Beitrittsdatum: 12.02.09 Neueste Beiträge
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, geändert vor 10 Jahren.
RE: MySQL problem
Youngling Beiträge: 12 Beitrittsdatum: 27.01.10 Neueste Beiträge
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
Anhänge:
Tobias Schmitt, geändert vor 10 Jahren.
RE: MySQL problem
Padawan Beiträge: 71 Beitrittsdatum: 12.02.09 Neueste Beiträge
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, geändert vor 10 Jahren.
RE: MySQL problem
Youngling Beiträge: 12 Beitrittsdatum: 27.01.10 Neueste Beiträge
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
Anhänge:
Christian Petry, geändert vor 10 Jahren.
RE: MySQL problem (Antwort)
Youngling Beiträge: 3 Beitrittsdatum: 12.02.09 Neueste Beiträge
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, geändert vor 13 Jahren.
RE: MySQL problem
Youngling Beiträge: 11 Beitrittsdatum: 23.04.11 Neueste BeiträgeChristian 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, geändert vor 13 Jahren.
RE: MySQL problem
Jedi Council Member Beiträge: 755 Beitrittsdatum: 12.02.09 Neueste Beiträge
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, geändert vor 13 Jahren.
RE: MySQL problem
Youngling Beiträge: 11 Beitrittsdatum: 23.04.11 Neueste Beiträge
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, geändert vor 10 Jahren.
RE: MySQL problem
Youngling Beiträge: 12 Beitrittsdatum: 27.01.10 Neueste Beiträge
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, geändert vor 10 Jahren.
RE: MySQL problem
Youngling Beiträge: 12 Beitrittsdatum: 27.01.10 Neueste Beiträge
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, geändert vor 10 Jahren.
RE: MySQL problem
Padawan Beiträge: 71 Beitrittsdatum: 12.02.09 Neueste Beiträge
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, geändert vor 10 Jahren.
RE: MySQL problem
Youngling Beiträge: 3 Beitrittsdatum: 12.02.09 Neueste Beiträge
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