1. Вы находитесь в сообществе Rubukkit. Мы - администраторы серверов Minecraft, разрабатываем собственные плагины и переводим на различные языки плагины наших коллег из других стран.
    Скрыть объявление
Скрыть объявление
В преддверии глобального обновления, мы проводим исследования, которые помогут нам сделать опыт пользования форумом ещё удобнее. Помогите нам, примите участие!

Решено крашит при подключении базы данных к authme

Тема в разделе "Помощь", создана пользователем susiska_sus, 25 дек 2022.

  1. Автор темы
    susiska_sus

    susiska_sus Ньюби

    Баллы:
    1
    как только я подключаю базу данный, то сервер крашится, помогите пожалуйста)
     
    susiska_sus, 25 дек 2022
    #1
  2. Overwrite

    Overwrite Активный участник Пользователь

    Баллы:
    98
    Имя в Minecraft:
    artcart
    Ты бы логи скинул
     
    Overwrite, 25 дек 2022
    #2
  3. Автор темы
    susiska_sus

    susiska_sus Ньюби

    Баллы:
    1
    Код:
    The last packet successfully received from the server was 2,204 milliseconds ago. The last packet sent successfully to the server was 2,197 milliseconds ago.
[18:18:28] [Server thread/WARN]: [AuthMe] Please check your database settings in the config.yml file!
[18:18:28] [Server thread/WARN]: [AuthMe] Could not create data source: [CommunicationsException]: Communications link failure
The last packet successfully received from the server was 2,204 milliseconds ago. The last packet sent successfully to the server was 2,197 milliseconds ago.
[18:18:28] [Server thread/WARN]: [AuthMe] Aborting initialization of AuthMe: [IllegalStateException]: Error during initialization of data source
[18:18:28] [Server thread/WARN]: java.lang.IllegalStateException: Error during initialization of data source
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:52)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:25)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.libs.ch.jalu.injector.handlers.instantiation.ProviderHandler$InstantiationByProviderClass.instantiateWith(ProviderHandler.java:129)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolveContext(InjectorImpl.java:164)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolve(InjectorImpl.java:133)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:72)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:245)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.AuthMe.initialize(AuthMe.java:221)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:145)
[18:18:28] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:263)
[18:18:28] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:342)
[18:18:28] [Server thread/WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:480)
[18:18:28] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_16_R3.CraftServer.enablePlugin(CraftServer.java:492)
[18:18:28] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_16_R3.CraftServer.enablePlugins(CraftServer.java:406)
[18:18:28] [Server thread/WARN]: at net.minecraft.server.v1_16_R3.MinecraftServer.loadWorld(MinecraftServer.java:554)
[18:18:28] [Server thread/WARN]: at net.minecraft.server.v1_16_R3.DedicatedServer.init(DedicatedServer.java:257)
[18:18:28] [Server thread/WARN]: at net.minecraft.server.v1_16_R3.MinecraftServer.w(MinecraftServer.java:928)
[18:18:28] [Server thread/WARN]: at net.minecraft.server.v1_16_R3.MinecraftServer.lambda$0(MinecraftServer.java:273)
[18:18:28] [Server thread/WARN]: at java.base/java.lang.Thread.run(Thread.java:829)
[18:18:28] [Server thread/WARN]: Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
[18:18:28] [Server thread/WARN]:
[18:18:28] [Server thread/WARN]: The last packet successfully received from the server was 2,204 milliseconds ago. The last packet sent successfully to the server was 2,197 milliseconds ago.
[18:18:28] [Server thread/WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[18:18:28] [Server thread/WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[18:18:28] [Server thread/WARN]: at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[18:18:28] [Server thread/WARN]: at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:202)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4869)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1656)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.init(ConnectionImpl.java:768)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.JDBC4Connection.init(JDBC4Connection.java:47)
[18:18:28] [Server thread/WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[18:18:28] [Server thread/WARN]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[18:18:28] [Server thread/WARN]: at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[18:18:28] [Server thread/WARN]: at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.init(HikariPool.java:115)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.datasource.MySQL.getConnection(MySQL.java:172)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:180)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.datasource.MySQL.init(MySQL.java:77)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:67)
[18:18:28] [Server thread/WARN]: at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:49)
[18:18:28] [Server thread/WARN]: ... 18 more
[18:18:28] [Server thread/WARN]: Caused by: javax.net.ssl.SSLHandshakeException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:349)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:292)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:287)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:654)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.onCertificate(CertificateMessage.java:473)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.consume(CertificateMessage.java:369)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:392)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:443)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:421)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:182)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:172)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1426)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1336)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:450)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:421)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:187)
[18:18:28] [Server thread/WARN]: ... 45 more
[18:18:28] [Server thread/WARN]: Caused by: java.security.cert.CertificateException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:303)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:1510)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:638)
[18:18:28] [Server thread/WARN]: ... 57 more
[18:18:28] [Server thread/WARN]: Caused by: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
[18:18:28] [Server thread/WARN]: at java.base/sun.security.provider.certpath.PKIXCertPathValidator.validate(PKIXCertPathValidator.java:157)
[18:18:28] [Server thread/WARN]: at java.base/sun.security.provider.certpath.PKIXCertPathValidator.engineValidate(PKIXCertPathValidator.java:83)
[18:18:28] [Server thread/WARN]: at java.base/java.security.cert.CertPathValidator.validate(CertPathValidator.java:309)
[18:18:28] [Server thread/WARN]: at com.mysql.jdbc.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:296)
[18:18:28] [Server thread/WARN]: ... 59 more
[18:18:28] [Server thread/WARN]: [AuthMe] THE SERVER IS GOING TO SHUT DOWN AS DEFINED IN THE CONFIGURATION!
     
    susiska_sus, 25 дек 2022
    #3
  4. Dymeth

    Dymeth Активный участник Пользователь

    Баллы:
    98
    Имя в Minecraft:
    Dymeth
    MySQL-сервер использует SSL-сертификат, которому нет доверия. Или наоборот не использует, если это требуется клиенту.

    Вот тут предлагают поменять mySQLUseSSL с true на false в конфиге плагина:
    https://github.com/AuthMe/AuthMeReloaded/issues/1824#issuecomment-498125668

    Если не поможет, то нужно больше информации:
    Где установлен MySQL-сервер? Имеешь ли ты доступ к его настройке?
     
    Dymeth, 25 дек 2022
    #4
  5. Автор темы
    susiska_sus

    susiska_sus Ньюби

    Баллы:
    1
    почему я раньше не додумался! спасибо за помощь!
     
    susiska_sus, 26 дек 2022
    #5

Поделиться этой страницей