zEssentials icon indicating copy to clipboard operation
zEssentials copied to clipboard
verified publisher icon Maxlego08

Public Key Retrieval is not allowed

Open Q2297045667 opened this issue 7 months ago • 0 comments

Terms

  • [x] I'm using the very latest version of zEssentials and its dependencies (zMenu and PlaceholdersAPI).
  • [x] I am sure this is a bug and it is not caused by a misconfiguration or by another plugin.
  • [x] I've looked for already existing issues on the Issue Tracker and haven't found any.
  • [x] I already searched on the plugin wiki to know if a solution is already known.
  • [x] I already searched on the discord to check if anyone already has a solution for this.
  • [x] I tested this with just zEssentials and its dependencies and with a vanilla client of the same version as the Server.
  • [x] I enabled the debug mode in config.yml and sql debug

Discord Username (optional)

Missing_Love

Server Version

1.21.4

Server Software

This server is running Paper version 1.21.5-77-main@a252581 (2025-05-11T20:34:22Z) (Implementing API version 1.21.5-R0.1-SNAPSHOT)

zEssentials Version

Successfully registered internal expansion: zmenu [1.0.4.1]

zMenu Version

Enabling zMenu v1.0.4.1

What happened?

Public Key Retrieval is not allowed Need to provide the option allowPublicKeyRetrieval=true

Steps to reproduce the issue

Start the server and connect to MySQL

Full Server Log

https://mclo.gs/L8IKr1n

Error (optional)

`[04:31:52 ERROR]: [com.zaxxer.hikari.pool.HikariPool] sarah-0 - Exception during pool initialization.
java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:102) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:837) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:420) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:238) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:180) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/fr.maxlego08.essentials.libs.sarah.HikariDatabaseConnection.initializeDataSource(HikariDatabaseConnection.java:83) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/fr.maxlego08.essentials.libs.sarah.HikariDatabaseConnection.<init>(HikariDatabaseConnection.java:34) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/fr.maxlego08.essentials.storage.storages.SqlStorage.<init>(SqlStorage.java:135) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/fr.maxlego08.essentials.storage.ZStorageManager.<init>(ZStorageManager.java:35) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/fr.maxlego08.essentials.ZEssentialsPlugin.onEnable(ZEssentialsPlugin.java:233) ~[zEssentials-1.0.2.2.jar:?]
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:280) ~[paper-api-1.21.5-R0.1-SNAPSHOT.jar:?]
        at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:202) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at io.papermc.paper.plugin.manager.PaperPluginManagerImpl.enablePlugin(PaperPluginManagerImpl.java:109) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:520) ~[paper-api-1.21.5-R0.1-SNAPSHOT.jar:?]
        at org.bukkit.craftbukkit.CraftServer.enablePlugin(CraftServer.java:653) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:608) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at net.minecraft.server.MinecraftServer.loadWorld0(MinecraftServer.java:741) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at net.minecraft.server.MinecraftServer.loadLevel(MinecraftServer.java:486) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at net.minecraft.server.dedicated.DedicatedServer.initServer(DedicatedServer.java:280) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1161) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at net.minecraft.server.MinecraftServer.lambda$spin$2(MinecraftServer.java:308) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at java.base/java.lang.Thread.run(Thread.java:1447) ~[?:?]
Caused by: com.mysql.cj.exceptions.UnableToConnectException: Public Key Retrieval is not allowed
        at java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:62) ~[?:?]
        at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) ~[?:?]
        at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:483) ~[?:?]
        at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:52) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:76) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:122) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:40) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:436) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:206) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1333) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.NativeSession.connect(NativeSession.java:155) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:961) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        ... 27 more
[04:31:52 ERROR]: Error occurred while enabling zEssentials v1.0.2.2 (Is it up to date?)
com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Public Key Retrieval is not allowed
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:596) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:582) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/fr.maxlego08.essentials.libs.sarah.HikariDatabaseConnection.initializeDataSource(HikariDatabaseConnection.java:83) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/fr.maxlego08.essentials.libs.sarah.HikariDatabaseConnection.<init>(HikariDatabaseConnection.java:34) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/fr.maxlego08.essentials.storage.storages.SqlStorage.<init>(SqlStorage.java:135) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/fr.maxlego08.essentials.storage.ZStorageManager.<init>(ZStorageManager.java:35) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/fr.maxlego08.essentials.ZEssentialsPlugin.onEnable(ZEssentialsPlugin.java:233) ~[zEssentials-1.0.2.2.jar:?]
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:280) ~[paper-api-1.21.5-R0.1-SNAPSHOT.jar:?]
        at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:202) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at io.papermc.paper.plugin.manager.PaperPluginManagerImpl.enablePlugin(PaperPluginManagerImpl.java:109) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:520) ~[paper-api-1.21.5-R0.1-SNAPSHOT.jar:?]
        at org.bukkit.craftbukkit.CraftServer.enablePlugin(CraftServer.java:653) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:608) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at net.minecraft.server.MinecraftServer.loadWorld0(MinecraftServer.java:741) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at net.minecraft.server.MinecraftServer.loadLevel(MinecraftServer.java:486) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at net.minecraft.server.dedicated.DedicatedServer.initServer(DedicatedServer.java:280) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1161) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at net.minecraft.server.MinecraftServer.lambda$spin$2(MinecraftServer.java:308) ~[paper-1.21.5.jar:1.21.5-77-a252581]
        at java.base/java.lang.Thread.run(Thread.java:1447) ~[?:?]
Caused by: java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:102) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:837) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:420) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:238) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:180) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[zEssentials-1.0.2.2.jar:?]
        ... 19 more
Caused by: com.mysql.cj.exceptions.UnableToConnectException: Public Key Retrieval is not allowed
        at java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:62) ~[?:?]
        at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) ~[?:?]
        at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:483) ~[?:?]
        at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:52) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:76) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:122) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:40) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:436) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:206) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1333) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.NativeSession.connect(NativeSession.java:155) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:961) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:420) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:238) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:180) ~[mysql-connector-j-9.2.0.jar:9.2.0]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) ~[zEssentials-1.0.2.2.jar:?]
        at zEssentials-1.0.2.2.jar/com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[zEssentials-1.0.2.2.jar:?]
        ... 19 more`

Other files, you can drag and drop them here to upload. (optional)

No response

Screenshots/Videos (you can drag and drop files or paste links)

No response

Q2297045667 avatar May 15 '25 04:05 Q2297045667