LuckPerms

LuckPerms

41.4k Downloads

Can't connect using MySQL SSL

ConstructorLeo opened this issue · 5 comments

commented

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.

commented

Here’s the error that showed up in console. https://pastebin.com/fM33Jbb4

commented

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.

commented

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.

commented

Would you mind explaining what you did to fix, just incase anyone else has the same problem in the future? :)

commented

All fixed