Çözüldü AuthmeReloaded MySQL sorunu

[Harun553]

Sunucumda AuthmeReloaded v5.4 kullanıyordum. Plugin MySqL bağlıydı. İlk başlarda sorun yoktu. Bir gün bot saldırısı yedik suncucu kapandı. Açmaya çalışınca AuthmeMySQLPool - starting dedi sonrasında sunucu kapandı. Authme'yi MySQL bağlayınca sunucu açılmıyor bağlamayınca kayıtlar gelmiyor. Bu kayıtları geri almanın bir yolu var mı? MySQL'dan veriyi playerdata'ya aktarabilir miyim ya da tekrar MySQL üzerinden kayıtları geri getirebilir miyim?

NOT: MySQL bağlantısında ve FireWall'da sorun yoktur.

Spoyler: Crash Kodu:

[06-15 11:29:12]: [INFO] Connection arguments loaded, Hikari ConnectionPool ready!
[06-15 11:29:33]: [WARN] Can't initialize the MySQL database: [CommunicationsException]: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[06-15 11:29:33]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at fr.xephi.authme.libs.com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:353)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:562)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
at fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
at fr.xephi.authme.datasource.MySQL.getConnection(MySQL.java:163)
at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:170)
at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:72)
at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:66)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:47)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:25)
at fr.xephi.authme.libs.ch.jalu.injector.handlers.instantiation.ProviderHandler$InstantiationByProviderClass.instantiateWith(ProviderHandler.java:129)
at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolveContext(InjectorImpl.java:164)
at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolve(InjectorImpl.java:133)
at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:72)
at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:237)
at fr.xephi.authme.AuthMe.initialize(AuthMe.java:212)
at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:127)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:357)
at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:317)
at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:414)
at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:378)
at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:333)
at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:263)
at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:525)
at java.lang.Thread.run(Unknown Source)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
... 43 more

[06-15 11:29:33]: [WARN] Please check your database settings in the config.yml file!
[06-15 11:29:33]: [WARN] Could not create data source: [CommunicationsException]: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[06-15 11:29:33]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at fr.xephi.authme.libs.com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:353)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:562)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
at fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
at fr.xephi.authme.datasource.MySQL.getConnection(MySQL.java:163)
at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:170)
at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:72)
at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:66)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:47)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:25)
at fr.xephi.authme.libs.ch.jalu.injector.handlers.instantiation.ProviderHandler$InstantiationByProviderClass.instantiateWith(ProviderHandler.java:129)
at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolveContext(InjectorImpl.java:164)
at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolve(InjectorImpl.java:133)
at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:72)
at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:237)
at fr.xephi.authme.AuthMe.initialize(AuthMe.java:212)
at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:127)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:357)
at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:317)
at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:414)
at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:378)
at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:333)
at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:263)
at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:525)
at java.lang.Thread.run(Unknown Source)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
... 43 more

[06-15 11:29:33]: [WARN] Aborting initialization of AuthMe: [IllegalStateException]: Error during initialization of data source
[06-15 11:29:33]: java.lang.IllegalStateException: Error during initialization of data source
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:50)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:25)
at fr.xephi.authme.libs.ch.jalu.injector.handlers.instantiation.ProviderHandler$InstantiationByProviderClass.instantiateWith(ProviderHandler.java:129)
at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolveContext(InjectorImpl.java:164)
at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.resolve(InjectorImpl.java:133)
at fr.xephi.authme.libs.ch.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:72)
at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:237)
at fr.xephi.authme.AuthMe.initialize(AuthMe.java:212)
at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:127)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:357)
at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:317)
at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:414)
at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:378)
at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:333)
at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:263)
at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:525)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at fr.xephi.authme.libs.com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:353)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:562)
at fr.xephi.authme.libs.com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
at fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
at fr.xephi.authme.datasource.MySQL.getConnection(MySQL.java:163)
at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:170)
at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:72)
at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:66)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:47)
... 19 more
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
... 43 more

[06-15 11:29:33]: [WARN] THE SERVER IS GOING TO SHUT DOWN AS DEFINED IN THE CONFIGURATION!
[06-15 11:29:33]: [INFO] AuthMe 5.6.0-beta1-b2226 disabled!
[06-15 11:30:45]: [INFO] Created column 'ukayit_tarih' and set the current timestamp, 1560587445146, to all 0 rows
[06-15 11:30:45]: [INFO] SQLite Setup finished
[06-15 11:30:45]: [INFO] No supported permissions system found! Permissions are disabled!
[06-15 11:30:46]: [INFO] [LICENSE] This product includes GeoLite2 data created by MaxMind, available at

Değerli ziyaretçimiz, içeriği görebilmek için şimdi giriş yapın veya kayıt olun.

[06-15 11:30:46]: [INFO] Hooked successfully into Multiverse-Core
[06-15 11:30:46]: [WARN] WARNING! The protectInventory feature requires ProtocolLib! Disabling it...

 

[CAN147]

Makinaya restart atın deneyin o olmaz ise authme'nin 4.5 versiyonunu indirip deneyin

 

[Harun553]

Makinaya restart atın deneyin o olmaz ise authme'nin 4.5 versiyonunu indirip deneyin

Reis Authme 4.5'i bulamadım varsa atar mısın?

 

[Abdullah T.]

Reis Authme 4.5'i bulamadım varsa atar mısın?

Banada Lazım 4.5 Bende Bulamıyorum

 

[Silinen üye 92065]

5.6 sürümünü öneririm şahsen kendi sunucum da kullanıyorum bir sorun yaşamadım.

Değerli ziyaretçimiz, içeriği görebilmek için şimdi giriş yapın veya kayıt olun.

 

[Harun553]

5.6 sürümünü öneririm şahsen kendi sunucum da kullanıyorum bir sorun yaşamadım.

Değerli ziyaretçimiz, içeriği görebilmek için şimdi giriş yapın veya kayıt olun.

5.6 denedim gene sorun çıkarttı

 

[Harun553]

Arkadaşlar sorunumu çözemedim, yardım bekliyorum..