Error TIMED OUT when connecting to MySQL database
TheDogHusky opened this issue · 6 comments
Description
When I'm trying to connect LuckPerms on a MySQL database, its timing out... But when I connect LuckPerms to this same database in another server, it work succesfully.
Reproduction steps
- Open config.ylm file
- enter the database infos (username, password, etc..) and change storage-method to MySQL
- restart server
- See error
Expected behaviour
LuckPerms connects to the database and I can synchronize my perms on differents servers.
Environment details
- Server type/version:
Spigot 1.12.2
and for the server chere it connect succeffuly:Spigot 1.15.2
- LuckPerms version:
LuckPerms-Bukkit-5.2.35
https://gist.github.com/TheDogHusky/9b9423c1d72d9eaaceb895ccc2ce3ec5
Any other relevant details
Caused by: me.lucko.luckperms.lib.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Your database just cant be access by your server, nothing much luckperms can do.
see https://luckperms.net/wiki/Storage-system-errors#luckperms-cannot-connect-to-my-mysql-server
I see the wiki, but if I want to connect 3 luckperms to the same database, I need to reduce the luckperms connections ? Per default, it’s 10 but I need to change to 3 or 4 ?
The error you sent has nothing to do with the max-connection limit, luckperms isn't even able to communicate with your database server.