LuniPlay
Пользователь
- Сообщения
- 103
- Решения
- 6
- Плагин
- MoonCases
- Ядро сервера
- Purpur
- Версия сервера
- 1.21
Здраствуйте, у меня такая проблема с подключением базы данных к плагину MoonCases.
В конфигурации ввёл всё правильно, без никаких ошибок. Логи с консоли:
[11:04:05 WARN]: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
[11:04:05 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
[11:04:05 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
[11:04:05 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
[11:04:05 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
[11:04:05 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
[11:04:05 WARN]: at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
[11:04:05 WARN]: at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
[11:04:05 WARN]: at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
[11:04:05 WARN]: at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
[11:04:05 WARN]: at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
[11:04:05 WARN]: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:681)
[11:04:05 WARN]: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:252)
[11:04:05 WARN]: at MoonCases.jar//1.i.I.L.l.l(Unknown Source)
[11:04:05 WARN]: at MoonCases.jar//1.i.I.L.l.l(Unknown Source)
[11:04:05 WARN]: at MoonCases.jar//1.i.I.1.1L(Unknown Source)
[11:04:05 WARN]: at MoonCases.jar//1.i.I.1.1I(Unknown Source)
[11:04:05 WARN]: at MoonCases.jar//1.i.I.1.onEnable(Unknown Source)
[11:04:05 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264)
[11:04:05 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:370)
[11:04:05 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:541)
[11:04:05 WARN]: at PluginManager.jar//net.lenni0451.spm.utils.PluginUtils.enablePlugin(PluginUtils.java:137)
[11:04:05 WARN]: at PluginManager.jar//net.lenni0451.spm.utils.PluginUtils.loadPlugin(PluginUtils.java:274)
[11:04:05 WARN]: at PluginManager.jar//net.lenni0451.spm.utils.PluginUtils.loadPlugin(PluginUtils.java:219)
[11:04:05 WARN]: at PluginManager.jar//net.lenni0451.spm.commands.subs.Reload_Sub.execute(Reload_Sub.java:38)
[11:04:05 WARN]: at PluginManager.jar//net.lenni0451.spm.commands.PluginManager_Command.lambda$onCommand$0(PluginManager_Command.java:94)
[11:04:05 WARN]: at PluginManager.jar//net.lenni0451.spm.commands.PluginManager_Command.onCommand(PluginManager_Command.java:110)
[11:04:05 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:45)
[11:04:05 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:172)
[11:04:05 WARN]: at org.bukkit.craftbukkit.v1_18_R2.CraftServer.dispatchCommand(CraftServer.java:906)
[11:04:05 WARN]: at net.minecraft.server.network.PlayerConnection.a(PlayerConnection.java:2390)
[11:04:05 WARN]: at net.minecraft.server.network.PlayerConnection.a(PlayerConnection.java:2201)
[11:04:05 WARN]: at net.minecraft.server.network.PlayerConnection.a(PlayerConnection.java:2182)
[11:04:05 WARN]: at net.minecraft.network.protocol.game.PacketPlayInChat.a(PacketPlayInChat.java:46)
[11:04:05 WARN]: at net.minecraft.network.protocol.game.PacketPlayInChat.a(PacketPlayInChat.java:6)
[11:04:05 WARN]: at net.minecraft.network.protocol.PlayerConnectionUtils.lambda$ensureRunningOnSameThread$1(PlayerConnectionUtils.java:51)
[11:04:05 WARN]: at net.minecraft.server.TickTask.run(TickTask.java:18)
[11:04:05 WARN]: at net.minecraft.util.thread.IAsyncTaskHandler.d(IAsyncTaskHandler.java:153)
[11:04:05 WARN]: at net.minecraft.util.thread.IAsyncTaskHandlerReentrant.d(IAsyncTaskHandlerReentrant.java:24)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:1427)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:188)
[11:04:05 WARN]: at net.minecraft.util.thread.IAsyncTaskHandler.y(IAsyncTaskHandler.java:126)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.be(MinecraftServer.java:1404)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.y(MinecraftServer.java:1397)
[11:04:05 WARN]: at net.minecraft.util.thread.IAsyncTaskHandler.c(IAsyncTaskHandler.java:136)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.x(MinecraftServer.java:1375)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:1257)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.lambda$spin$1(MinecraftServer.java:321)
[11:04:05 WARN]: at java.base/java.lang.Thread.run(Thread.java:840)
[11:04:05 WARN]: Caused by: com.mysql.cj.exceptions.CJException: Public Key Retrieval is not allowed
[11:04:05 WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:04:05 WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
[11:04:05 WARN]: at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[11:04:05 WARN]: at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
[11:04:05 WARN]: at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
[11:04:05 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
[11:04:05 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
[11:04:05 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
[11:04:05 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:124)
[11:04:05 WARN]: at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:153)
[11:04:05 WARN]: at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:49)
[11:04:05 WARN]: at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:440)
[11:04:05 WARN]: at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:210)
[11:04:05 WARN]: at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1369)
[11:04:05 WARN]: at com.mysql.cj.NativeSession.connect(NativeSession.java:133)
[11:04:05 WARN]: at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
[11:04:05 WARN]: ... 42 more
[11:04:05 WARN]: Caused by: com.mysql.cj.exceptions.UnableToConnectException: Public Key Retrieval is not allowed
[11:04:05 WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:04:05 WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
[11:04:05 WARN]: at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[11:04:05 WARN]: at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
[11:04:05 WARN]: at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
[11:04:05 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
[11:04:05 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
[11:04:05 WARN]: at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:130)
[11:04:05 WARN]: ... 48 more
Я не понимаю как это решить, но мне обязательно нужно подключить этот плагин к базе данных. Надеюсь Вы мне поможете с:
Базу данных я несколько раз пересоздавал, и изменял пароль, но ничего с этого не помогло.
В конфигурации ввёл всё правильно, без никаких ошибок. Логи с консоли:
[11:04:05 WARN]: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
[11:04:05 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
[11:04:05 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
[11:04:05 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
[11:04:05 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
[11:04:05 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
[11:04:05 WARN]: at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
[11:04:05 WARN]: at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
[11:04:05 WARN]: at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
[11:04:05 WARN]: at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
[11:04:05 WARN]: at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
[11:04:05 WARN]: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:681)
[11:04:05 WARN]: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:252)
[11:04:05 WARN]: at MoonCases.jar//1.i.I.L.l.l(Unknown Source)
[11:04:05 WARN]: at MoonCases.jar//1.i.I.L.l.l(Unknown Source)
[11:04:05 WARN]: at MoonCases.jar//1.i.I.1.1L(Unknown Source)
[11:04:05 WARN]: at MoonCases.jar//1.i.I.1.1I(Unknown Source)
[11:04:05 WARN]: at MoonCases.jar//1.i.I.1.onEnable(Unknown Source)
[11:04:05 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264)
[11:04:05 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:370)
[11:04:05 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:541)
[11:04:05 WARN]: at PluginManager.jar//net.lenni0451.spm.utils.PluginUtils.enablePlugin(PluginUtils.java:137)
[11:04:05 WARN]: at PluginManager.jar//net.lenni0451.spm.utils.PluginUtils.loadPlugin(PluginUtils.java:274)
[11:04:05 WARN]: at PluginManager.jar//net.lenni0451.spm.utils.PluginUtils.loadPlugin(PluginUtils.java:219)
[11:04:05 WARN]: at PluginManager.jar//net.lenni0451.spm.commands.subs.Reload_Sub.execute(Reload_Sub.java:38)
[11:04:05 WARN]: at PluginManager.jar//net.lenni0451.spm.commands.PluginManager_Command.lambda$onCommand$0(PluginManager_Command.java:94)
[11:04:05 WARN]: at PluginManager.jar//net.lenni0451.spm.commands.PluginManager_Command.onCommand(PluginManager_Command.java:110)
[11:04:05 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:45)
[11:04:05 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:172)
[11:04:05 WARN]: at org.bukkit.craftbukkit.v1_18_R2.CraftServer.dispatchCommand(CraftServer.java:906)
[11:04:05 WARN]: at net.minecraft.server.network.PlayerConnection.a(PlayerConnection.java:2390)
[11:04:05 WARN]: at net.minecraft.server.network.PlayerConnection.a(PlayerConnection.java:2201)
[11:04:05 WARN]: at net.minecraft.server.network.PlayerConnection.a(PlayerConnection.java:2182)
[11:04:05 WARN]: at net.minecraft.network.protocol.game.PacketPlayInChat.a(PacketPlayInChat.java:46)
[11:04:05 WARN]: at net.minecraft.network.protocol.game.PacketPlayInChat.a(PacketPlayInChat.java:6)
[11:04:05 WARN]: at net.minecraft.network.protocol.PlayerConnectionUtils.lambda$ensureRunningOnSameThread$1(PlayerConnectionUtils.java:51)
[11:04:05 WARN]: at net.minecraft.server.TickTask.run(TickTask.java:18)
[11:04:05 WARN]: at net.minecraft.util.thread.IAsyncTaskHandler.d(IAsyncTaskHandler.java:153)
[11:04:05 WARN]: at net.minecraft.util.thread.IAsyncTaskHandlerReentrant.d(IAsyncTaskHandlerReentrant.java:24)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:1427)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:188)
[11:04:05 WARN]: at net.minecraft.util.thread.IAsyncTaskHandler.y(IAsyncTaskHandler.java:126)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.be(MinecraftServer.java:1404)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.y(MinecraftServer.java:1397)
[11:04:05 WARN]: at net.minecraft.util.thread.IAsyncTaskHandler.c(IAsyncTaskHandler.java:136)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.x(MinecraftServer.java:1375)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:1257)
[11:04:05 WARN]: at net.minecraft.server.MinecraftServer.lambda$spin$1(MinecraftServer.java:321)
[11:04:05 WARN]: at java.base/java.lang.Thread.run(Thread.java:840)
[11:04:05 WARN]: Caused by: com.mysql.cj.exceptions.CJException: Public Key Retrieval is not allowed
[11:04:05 WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:04:05 WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
[11:04:05 WARN]: at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[11:04:05 WARN]: at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
[11:04:05 WARN]: at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
[11:04:05 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
[11:04:05 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
[11:04:05 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
[11:04:05 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:124)
[11:04:05 WARN]: at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:153)
[11:04:05 WARN]: at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:49)
[11:04:05 WARN]: at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:440)
[11:04:05 WARN]: at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:210)
[11:04:05 WARN]: at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1369)
[11:04:05 WARN]: at com.mysql.cj.NativeSession.connect(NativeSession.java:133)
[11:04:05 WARN]: at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
[11:04:05 WARN]: ... 42 more
[11:04:05 WARN]: Caused by: com.mysql.cj.exceptions.UnableToConnectException: Public Key Retrieval is not allowed
[11:04:05 WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[11:04:05 WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
[11:04:05 WARN]: at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[11:04:05 WARN]: at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
[11:04:05 WARN]: at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
[11:04:05 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
[11:04:05 WARN]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
[11:04:05 WARN]: at com.mysql.cj.protocol.a.authentication.CachingSha2PasswordPlugin.nextAuthenticationStep(CachingSha2PasswordPlugin.java:130)
[11:04:05 WARN]: ... 48 more
Я не понимаю как это решить, но мне обязательно нужно подключить этот плагин к базе данных. Надеюсь Вы мне поможете с:
Базу данных я несколько раз пересоздавал, и изменял пароль, но ничего с этого не помогло.
