Can't import my database in openfre

Openfire Openfire Support
1

Hi Guys,

May I ask for your help. I’ve installed Openfire 4.4.2 and MySQL 8.0.18 in Ubuntu 16.04. The problem is, I cannot import the database in GUI. It always says:
“A connection to the database could not be made. View the error message by opening the “/logs/error.log” log file, then go back to fix the problem.”

Database URL: jdbc:mysql://127.0.0.1:3306/sparksdb?rewriteBatchedStatements=true

I also tried the localhost, servername and server IP, but still error appear.

2

Have you checked the error.log?

3

Sorry, but where is the error logs located?

4

Hi,

My issue was resolved by old version of MySQL.

Thank you,

5

Logs are in openfire installation folder /logs/error.log or all.log

Do you mean you have installed older version of MySQL? Which one? New version of Openfire should work with the latest version of MySQL. But it might require additional configuration which error log can tell about. Of course, you can use older version of DB, but in future you can run into a problem with Openfire updates, if older version support is dropped.