Can't connect using MySQL SSL
ConstructorLeo opened this issue · 5 comments
Hi,
LuckPerms isn't connecting to MySQL SSL. We can manually connect to the MySQL database using the MySQL command, LiteBans which is also using MySQL SSL works just fine on the same machine, LuckPerms still has issues with a different machine, the LuckPerms and LiteBans databases are setup exactly the same.
Thanks.
Here’s the error that showed up in console. https://pastebin.com/fM33Jbb4
Here are some updates, been talking to the moderators.
https://prnt.sc/r5i6tj
https://prnt.sc/r5i7l0
https://prnt.sc/r5i7ms
https://prnt.sc/r5i7qs
eletroniccat also said our SSL is busted, but it's not as we are still able to connect to our MySQL databases over SSL from any of our machines, i.e LuckPerms is the only plugin having issues with MySQL.
This wiki page is most relevant.
https://github.com/lucko/LuckPerms/wiki/Storage-system-errors
LuckPerms delegates absolutely all connection handling with MySQL to HikariCP and the underlying JDBC driver.
Aside from possibly tweaking the Hikari configuration, see:
or upgrading the MySQL driver version used, there's absolutely nothing I can do to attempt to fix the problem.
Would you mind explaining what you did to fix, just incase anyone else has the same problem in the future? :)