[Risolto] AuthMeReloaded non carica il database MySQL

Codice:
[AuthMe] Connection arguments loaded, Hikari ConnectionPool ready!
[Server thread] INFO fr.xephi.authme.libs.zaxxer.hikari.HikariDataSource - AuthMeMYSQLPool - Starting...
[AuthMe] Could not create data source: [RuntimeException]: Failed to get driver instance for jdbcUrl=jdbc:mysql://:/authme
[AuthMe] Aborting initialization of AuthMe: [IllegalStateException]: Error during initialization of data source
LOG:

Codice:
[11-01 11:53:57]: [WARN] Aborting initialization of AuthMe: [IllegalStateException]: Error during initialization of data source
[11-01 11:53:57]: java.lang.IllegalStateException: Error during initialization of data source
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:52)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:26)
at fr.xephi.authme.libs.jalu.injector.handlers.provider.ProviderHandlerImpl$UninitializedProviderInstantiation.instantiateWith(ProviderHandlerImpl.java:141)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.instantiate(InjectorImpl.java:181)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.get(InjectorImpl.java:155)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:56)
at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:246)
at fr.xephi.authme.AuthMe.initialize(AuthMe.java:221)
at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:136)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:335)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.loadPlugin(CraftServer.java:356)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.enablePlugins(CraftServer.java:316)
at net.minecraft.server.v1_8_R1.MinecraftServer.q(MinecraftServer.java:402)
at net.minecraft.server.v1_8_R1.MinecraftServer.k(MinecraftServer.java:370)
at net.minecraft.server.v1_8_R1.MinecraftServer.a(MinecraftServer.java:325)
at net.minecraft.server.v1_8_R1.DedicatedServer.init(DedicatedServer.java:211)
at net.minecraft.server.v1_8_R1.MinecraftServer.run(MinecraftServer.java:505)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:mysql://:/authme
at fr.xephi.authme.libs.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:110)
at fr.xephi.authme.libs.zaxxer.hikari.pool.PoolBase.initializeDataSource(PoolBase.java:342)
at fr.xephi.authme.libs.zaxxer.hikari.pool.PoolBase.<init>(PoolBase.java:117)
at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:109)
at fr.xephi.authme.libs.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:97)
at fr.xephi.authme.datasource.MySQL.getConnection(MySQL.java:157)
at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:164)
at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:69)
at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:72)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:49)
... 19 more
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at fr.xephi.authme.libs.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:103)
... 28 more

Il database l'ho creato e gli altri plugins riescono a connettersi tranquillamente. (Modificato 01/11/2018, 21:07 da alex3025.)
Se ti sono stato utile, lasciami un like oppure clicca su +1! Asd
Non hai inserito correttamente i dati nel config di AuthMe.
Infatti il plugin prova a connettersi a: "jdbcUrl=jdbc:mysql://:/authme", che indica che non hai inserito l'username, la password, l'IP e la porta del Database.
Se ti sono stato d'aiuto, mi offriresti una birra?
[Immagine: MnksU9y.png]

Rip Maxcraft
Ecco cosa ottengo se aggiungo ip, porta, user e psw.

Codice:
[AuthMe] Connection arguments loaded, Hikari ConnectionPool ready!
[16:43:28 WARN]: [Server thread] INFO fr.xephi.authme.libs.zaxxer.hikari.HikariDataSource - AuthMeMYSQLPool - Starting...
[16:43:29 WARN]: [Server thread] ERROR fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool - AuthMeMYSQLPool - Exception during pool initialization.
[16:43:29 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cannot connect to MySQL server on localhost:3306.

Make sure that there is a MySQL server running on the machine/port you are trying to connect to and that the machine this software is running on is able to connect to this host/port (i.e. not firewalled). Also make sure that the server has not been started with the --skip-networking flag.


[16:43:29 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[16:43:29 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[16:43:29 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[16:43:29 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[16:43:29 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[16:43:29 WARN]:        at com.mysql.jdbc.Util.getInstance(Util.java:382)
[16:43:29 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
[16:43:29 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
[16:43:29 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
[16:43:29 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
[16:43:29 WARN]:        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:827)
[16:43:29 WARN]:        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[16:43:29 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[16:43:29 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[16:43:29 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[16:43:29 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[16:43:29 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[16:43:29 WARN]:        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
[16:43:29 WARN]:        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
[16:43:29 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:117)
[16:43:29 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:123)
[16:43:29 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:375)
[16:43:29 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:204)
[16:43:29 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:445)
[16:43:29 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:516)
[16:43:29 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:116)
[16:43:29 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:97)
[16:43:29 WARN]:        at fr.xephi.authme.datasource.MySQL.getConnection(MySQL.java:157)
[16:43:29 WARN]:        at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:164)
[16:43:29 WARN]:        at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:69)
[16:43:29 WARN]:        at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:72)
[16:43:29 WARN]:        at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:49)
[16:43:29 WARN]:        at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:26)
[16:43:29 WARN]:        at fr.xephi.authme.libs.jalu.injector.handlers.provider.ProviderHandlerImpl$UninitializedProviderInstantiation.instantiateWith(ProviderHandlerImpl.java:141)
[16:43:29 WARN]:        at fr.xephi.authme.libs.jalu.injector.InjectorImpl.instantiate(InjectorImpl.java:181)
[16:43:29 WARN]:        at fr.xephi.authme.libs.jalu.injector.InjectorImpl.get(InjectorImpl.java:155)
[16:43:29 WARN]:        at fr.xephi.authme.libs.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:56)
[16:43:29 WARN]:        at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:246)
[16:43:29 WARN]:        at fr.xephi.authme.AuthMe.initialize(AuthMe.java:221)
[16:43:29 WARN]:        at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:136)
[16:43:29 WARN]:        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
[16:43:29 WARN]:        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:335)
[16:43:29 WARN]:        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
[16:43:29 WARN]:        at org.bukkit.craftbukkit.v1_8_R1.CraftServer.loadPlugin(CraftServer.java:356)
[16:43:29 WARN]:        at org.bukkit.craftbukkit.v1_8_R1.CraftServer.enablePlugins(CraftServer.java:316)
[16:43:29 WARN]:        at net.minecraft.server.v1_8_R1.MinecraftServer.q(MinecraftServer.java:402)
[16:43:29 WARN]:        at net.minecraft.server.v1_8_R1.MinecraftServer.k(MinecraftServer.java:370)
[16:43:29 WARN]:        at net.minecraft.server.v1_8_R1.MinecraftServer.a(MinecraftServer.java:325)
[16:43:29 WARN]:        at net.minecraft.server.v1_8_R1.DedicatedServer.init(DedicatedServer.java:211)
[16:43:29 WARN]:        at net.minecraft.server.v1_8_R1.MinecraftServer.run(MinecraftServer.java:505)
[16:43:29 WARN]:        at java.lang.Thread.run(Unknown Source)
[16:43:29 WARN]: Caused by: java.lang.UnsupportedOperationException: The method shutdownInput() is not supported in SSLSocket
[16:43:29 WARN]:        at sun.security.ssl.BaseSSLSocketImpl.shutdownInput(Unknown Source)
[16:43:29 WARN]:        at com.mysql.jdbc.MysqlIO.forceClose(MysqlIO.java:506)
[16:43:29 WARN]:        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2404)
[16:43:29 WARN]:        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
[16:43:29 WARN]:        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
[16:43:29 WARN]:        ... 40 more
(Modificato 01/11/2018, 17:46 da alex3025.)
Se ti sono stato utile, lasciami un like oppure clicca su +1! Asd
Codice:
Cannot connect to MySQL server on localhost:3306.

Make sure that there is a MySQL server running on the machine/port you are trying to connect to and that the machine this software is running on is able to connect to this host/port (i.e. not firewalled). Also make sure that the server has not been started with the --skip-networking flag

Sei sicuro di avere creato e avviato un server con un database chiamato "authme" nella stessa macchina che contiene il server Minecraft?

Potresti voler disinstallare e reinstallare MySQL da capo, assicurandoti di fare tutto correttamente.
Se ti sono stato d'aiuto, mi offriresti una birra?
[Immagine: MnksU9y.png]

Rip Maxcraft
Si, ho creato correttamente il database.

Provo a reinstallare. (Modificato 01/11/2018, 21:07 da alex3025.)
Se ti sono stato utile, lasciami un like oppure clicca su +1! Asd
Codice:
[19:18:11 WARN]: [Server thread] INFO fr.xephi.authme.libs.zaxxer.hikari.HikariDataSource - AuthMeMYSQLPool - Starting...
[19:18:12 WARN]: [Server thread] ERROR fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool - AuthMeMYSQLPool - Exception during pool initialization.
[19:18:12 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cannot connect to MySQL server on localhost:3306.

Make sure that there is a MySQL server running on the machine/port you are trying to connect to and that the machine this software is running on is able to connect to this host/port (i.e. not firewalled). Also make sure that the server has not been started with the --skip-networking flag.


[19:18:12 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[19:18:12 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[19:18:12 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[19:18:12 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[19:18:12 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[19:18:12 WARN]:        at com.mysql.jdbc.Util.getInstance(Util.java:382)
[19:18:12 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
[19:18:12 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
[19:18:12 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
[19:18:12 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
[19:18:12 WARN]:        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:827)
[19:18:12 WARN]:        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[19:18:12 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[19:18:12 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[19:18:12 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[19:18:12 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[19:18:12 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[19:18:12 WARN]:        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
[19:18:12 WARN]:        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
[19:18:12 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:117)
[19:18:12 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:123)
[19:18:12 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:375)
[19:18:12 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:204)
[19:18:12 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:445)
[19:18:12 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:516)
[19:18:12 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:116)
[19:18:12 WARN]:        at fr.xephi.authme.libs.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:97)
[19:18:12 WARN]:        at fr.xephi.authme.datasource.MySQL.getConnection(MySQL.java:157)
[19:18:12 WARN]:        at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:164)
[19:18:12 WARN]:        at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:69)
[19:18:12 WARN]:        at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:72)
[19:18:12 WARN]:        at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:49)
[19:18:12 WARN]:        at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:26)
[19:18:12 WARN]:        at fr.xephi.authme.libs.jalu.injector.handlers.provider.ProviderHandlerImpl$UninitializedProviderInstantiation.instantiateWith(ProviderHandlerImpl.java:141)
[19:18:12 WARN]:        at fr.xephi.authme.libs.jalu.injector.InjectorImpl.instantiate(InjectorImpl.java:181)
[19:18:12 WARN]:        at fr.xephi.authme.libs.jalu.injector.InjectorImpl.get(InjectorImpl.java:155)
[19:18:12 WARN]:        at fr.xephi.authme.libs.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:56)
[19:18:12 WARN]:        at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:246)
[19:18:12 WARN]:        at fr.xephi.authme.AuthMe.initialize(AuthMe.java:221)
[19:18:12 WARN]:        at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:136)
[19:18:12 WARN]:        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
[19:18:12 WARN]:        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:335)
[19:18:12 WARN]:        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
[19:18:12 WARN]:        at org.bukkit.craftbukkit.v1_8_R1.CraftServer.loadPlugin(CraftServer.java:356)
[19:18:12 WARN]:        at org.bukkit.craftbukkit.v1_8_R1.CraftServer.enablePlugins(CraftServer.java:316)
[19:18:12 WARN]:        at net.minecraft.server.v1_8_R1.MinecraftServer.q(MinecraftServer.java:402)
[19:18:12 WARN]:        at net.minecraft.server.v1_8_R1.MinecraftServer.k(MinecraftServer.java:370)
[19:18:12 WARN]:        at net.minecraft.server.v1_8_R1.MinecraftServer.a(MinecraftServer.java:325)
[19:18:12 WARN]:        at net.minecraft.server.v1_8_R1.DedicatedServer.init(DedicatedServer.java:211)
[19:18:12 WARN]:        at net.minecraft.server.v1_8_R1.MinecraftServer.run(MinecraftServer.java:505)
[19:18:12 WARN]:        at java.lang.Thread.run(Unknown Source)
[19:18:12 WARN]: Caused by: java.lang.UnsupportedOperationException: The method shutdownInput() is not supported in SSLSocket
[19:18:12 WARN]:        at sun.security.ssl.BaseSSLSocketImpl.shutdownInput(Unknown Source)
[19:18:12 WARN]:        at com.mysql.jdbc.MysqlIO.forceClose(MysqlIO.java:506)
[19:18:12 WARN]:        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2404)
[19:18:12 WARN]:        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
[19:18:12 WARN]:        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
[19:18:12 WARN]:        ... 40 more
Nessun risultato Sad
Se ti sono stato utile, lasciami un like oppure clicca su +1! Asd
Ti consiglio di riguardare tutti i vari file di configurazione e il firewall.
Il Database e il server non riescono a comunicare, non posso aiutarti oltre.
Se ti sono stato d'aiuto, mi offriresti una birra?
[Immagine: MnksU9y.png]

Rip Maxcraft
Risolto, potete chiudere.

Ho semplicemente disabilitato l'SSL da authme visto che evidentemente il mio database non lo supportava e per evitare un altro piccolo bug con il database, ho installato MySQL 5.6.
Se ti sono stato utile, lasciami un like oppure clicca su +1! Asd
Discussioni simili
Risposta di iAmGio
10/11/2018, 23:09
Risposta di Maxetto
31/10/2018, 00:45

Utente(i) che stanno guardando questa discussione: 1 Ospite(i)