MYSQL Connection(xwiki)

Help / Discuss
1

Hi,I followed these steps but I could not connect to the MYSQL db.I’m getting a HTTP 500 error.
I could not fix this error in any way.
What can I do?

Thanks for your help :slight_smile:

2

Can you post the relevant section of hibernate.cfg.xml (username and password removed, of course)?

Did you comment out the default database parameters (lines 82-101)?

3

xwiki%20mysql

->error occurs when this section is enabled

xwiki%20mysql2
(lines 82-101)

4

Can you paste the full file please? Use pastebin for example. Thx

5

Actually seems you didn’t comment out the HSQLDB part :slight_smile:

6

The doc was saying on https://www.xwiki.org/xwiki/bin/view/Documentation/AdminGuide/Installation/InstallationWAR/InstallationMySQL/ :

Now you need to tell XWiki to use MySQL. To do this, edit the WEB-INF/hibernate.cfg.xml file where you have expanded the XWiki WAR file and replace the matching properties with the following ones:

I’ve now modified it to be:

Now you need to tell XWiki to use MySQL. To do this, edit the WEB-INF/hibernate.cfg.xml file where you have expanded the XWiki WAR file and replace the matching properties with the following ones (you can also comment out the HSQLDB part and uncomment the MySQL one):

It was already clear but I hope it’s even more clear now :wink:

7

I installed MYSQL 5.7.21.0 and problem solved :slight_smile:(I installed MYSQL 8.0.11)

Thanks for your help vmassol :slight_smile:

8

Indeed seems we have a problem with MySQL 8.x: Loading...

I’ve now added a warning at https://www.xwiki.org/xwiki/bin/view/Documentation/AdminGuide/Installation/InstallationWAR/InstallationMySQL/

Thanks for reporting the problem.