- Баллы
- 1
как только я подключаю базу данный, то сервер крашится, помогите пожалуйста)
Решено крашит при подключении базы данных к authme
- Автор темы susiska_sus
- Дата начала
- Баллы
- 98
- Ник в Minecraft
- OverwriteMC
Ты бы логи скинул
- Баллы
- 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!
- Баллы
- 98
- Ник в Minecraft
- Dymeth
MySQL-сервер использует SSL-сертификат, которому нет доверия. Или наоборот не использует, если это требуется клиенту.
Вот тут предлагают поменять mySQLUseSSL с true на false в конфиге плагина:
https://github.com/AuthMe/AuthMeReloaded/issues/1824#issuecomment-498125668
Если не поможет, то нужно больше информации:
Где установлен MySQL-сервер? Имеешь ли ты доступ к его настройке?
- Баллы
- 1
почему я раньше не додумался! спасибо за помощь!