LuckPerms

LuckPerms

41.4k Downloads

Warn in console when using MySQL

weaves7 opened this issue ยท 4 comments

commented

Just started setting up LuckPerms for my bungee network with MySQL after using Pex (not with MySQL though) for years. So i am not familar with LP yet, so sorry if i am just missing something. But i get this warning on startup.

10.12 18:07:07 [Server] WARN Sun Dec 10 18:07:07 EST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

commented

If you searched the issue tracker you would have came across this #285 (comment)

commented

Sorry, when I looked at the issues I forgot about the "is:open" filter. Also I did some more research and found that if I added the following it would no longer have the warning. This may help others looking for a fix.

Note the placement of "?useSSL=FALSE"

data:
  #Uses standard DB engine port by default
  #MySQL: 3306, PostgreSQL: 5432, MongoDB: 27017
  #Specify as "host:port" if differs
  address: 0.0.0.0

  database: mydatabase?useSSL=false
  username: myusername
  password: mypassword

This can be tagged fixed or whatever and closed btw

commented

The correct fix for this is to specify a property.

data:
  pool-settings:
    # This setting allows you to define extra properties for connections.
    properties:
      useSSL: false
commented

The correct fix for this is to specify a property.

Perhaps add this to https://github.com/lucko/LuckPerms/wiki/FAQ#luckperms-cannot-connect-to-my-mysql-server or modify the config files within Luckperms with a remark/comment @lucko