Can not get into maintenance mode

marcasellkhelaifi · 12 Jun 2021, 03:08

Hi, I just downloaded and ran FusionAuth by following the guide here : https://fusionauth.io/download/. After running startup.sh, I got an error so I can not run FusionAuth. Here is the full log : https://pastebin.com/K3wUgfgN. Any help will be appreciated, thank you.

marcasellkhelaifi · 12 Jun 2021, 03:15

After I checked, I decided to run ``./shutdown.shand executed./start.sh`.

Next, I found this error : ERROR com.inversoft.maintenance.db.JDBCMaintenanceModeDatabaseService - No [MySQL] Driver found. The [Connector/J jar] may be missing or not be accessible.

How should I fix this ?

marcasellkhelaifi · 14 Jun 2021, 13:30

Pardon me, would you mind helping this issue @dan ?... Otherwise, could you please give me a documentation link that cover this ? Thank you..

robotdan · 14 Jun 2021, 16:01

We cannot ship the MySQL due to licensing restrictions. This means we have to download it once you select MySQL, and outbound network access is required to download the correct MySQL connector.

https://fusionauth.io/docs/v1/tech/installation-guide/system-requirements/#network-access

Ensure you have allowed for outbound network access, or if you must air gap the installation, ensure you have copied the MySQL JDBC connector into the correct location.

If you are running Docker, here is an example to package the driver.
https://github.com/FusionAuth/fusionauth-containers/blob/master/docker/fusionauth/fusionauth-app-mysql/Dockerfile

dan · 15 Jun 2021, 01:49

@marcasellkhelaifi I hope Dan's answer helps. Just to be clear, here are our technical support guidelines: https://fusionauth.io/technical-support/ We want to be super transparent about what we commit to.

FusionAuth team members and community members like to help each other out. The best way to get help is to outline your problem in as much detail as you can and show the community the troubleshooting steps you've taken. While it never hurts to ask, the more details you can provide the better. (If you need guaranteed response time, please consider a support contract.)

Thanks for helping out @robotdan .

marcasellkhelaifi · 15 Jun 2021, 07:26

@robotdan Thank you @robotdan and @dan , I appreciate your time.

I have installed MySQL/J connector. Then I got an error saying : The database and schema exist, but for some reason the ordinary user you specified cannot connect to it. Perhaps the user already existed and you provided the wrong password. The error from the database was [Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.]..

This is how Maintenance Mode Database Configuration looks :

I once provided a user credentials with superuser privileges but it still did not work and got the same error. Could you please give a clue ? Thank you...

joshua · 15 Jun 2021, 16:48

Linking to existing conversation:

https://fusionauth.io/community/forum/topic/1086/how-may-i-see-the-name-of-database-created-used-by-fusionauth-in-local-mysql?_=1623774571813

marcasellkhelaifi · 16 Jun 2021, 04:05

Thank you @joshua , I will continue this thread in that post.

marcasellkhelaifi · 16 Jun 2021, 06:34

This issue, in my opinion, has been resolved in this thread : https://fusionauth.io/community/forum/topic/1086/how-may-i-see-the-name-of-database-created-used-by-fusionauth-in-local-mysql?_=1623774571813.

If anyone has the same issue, I hope it will be helpful. Thank you.