mysql goes on comunication link failure with non localhost host

[mattymatty97]

Before reporting an issue make sure you are running the latest build of the plugin and checked for duplicate issues!

What behaviour is observed:

What happened? when connecting to a mysql database the plugin stops saying "Communications link failure"

What behaviour is expected:

What did you expect? plugin correctly connect to mysql database as other plugins do

Steps/models to reproduce:

The actions that cause the issue mysql

Plugin list:

This can be found by running /pl ActionBarAPI-1.5.3 AddLight-4.2.0 AsyncWorldEdit-ActionBarAPI AsyncWorldEditInjector AsyncWorldEdit AuthMe-5.5.0-SNAPSHOT AuthMeBridge-1.6.2 ConsoleSay EssentialsX-2.0.1 EssentialsXChat-2.0.1 FastLogin Holograms-2.5.0-SNAPSHOT Multiverse-Core-2.5 NametagEdit PermissionsEx-1.23.4 PluginManager-Reloaded-1.0.2 ProtocolLib SkinsRestorer-v13.1.4-BETA Vault VoidGenerator-1.1.0 WirelessRedstone worldedit-bukkit-6.1.7.3 worldguard-legacy-6.2.2-SNAPSHOT-dist

Environment description

Standalone server/Bungeecord network, SQLite/MySql, ... spigot server networked by bungeecord but authme is server side

AuthMe build number:

This can be found by running /authme version AuthMe-5.5.0-SNAPSHOT

Error Log:

Pastebin/Hastebin/Gist link of the error logo or stacktrace (if any)

https://pastebin.com/CSfyaP2Z

Configuration:

Pastebin/Hastebin/Gist link of your config.yml file (remember to delete any sensitive data) https://pastebin.com/AL3E5W9v

[sgdc3]

Is the mysql server on the same machine?

[mattymatty97]

no its on a vps

[mattymatty97]

other plugins like pex, worldguard and skin restorer correctly conntects and from my laptop i can connect whit the authme credentials to authme datatabase

[sgdc3]

MySql or MariaDB?

[mattymatty97]

actually mysql

[sgdc3]

maxLifetime: 200000000000000

Wtf? Set it back to 1800...

[mattymatty97]

sorry it a bit old config i'v tried expanding timeout value but the error hannes also whit normal one

[sgdc3]

try with 300

[mattymatty97]

trying it now

[mattymatty97]

nope same error

[sgdc3]

Sounds very strange, set poolSize to 4

[mattymatty97]

nope error repeats again

[sgdc3]

make sure the connection between the 2 servers is stable

[sgdc3]

uh, found it: disable mySQLUseSSL

[sgdc3]

@mattymatty97

[mattymatty97]

ssl is active on mysql and the connection is stable, one is on optic fibre and the other on a vps in germany. one think is the verify-server-certificate that i've had to diable it for hide some warning in other plugins

[mattymatty97]

ps: sorry for my wrong spellings😌

[mattymatty97]

like this uri: mysql://84.201.37.95/PermissionEx?verifyServerCertificate=false&useSSL=true

[mattymatty97]

bump, no one have found a solution?

[krusic22]

Can you connect using a normal mysql client?

[mattymatty97]

yes normal mysql clients and other plugins correctly connect and modify

[mattymatty97]

err 1th what qestion is unanswered? and 2th is still not working sadly

[hex3l]

Which is your SSL provider/certificate authority?
Which Java version are you using? Can you list me all the plugin that are correctly connecting to your mysql server?