Zdravím, nevím si rady jak napojit plugin stats na mysql
Web pluginu : http://dev.bukkit.org/bukkit-plugins/lolmewnstats/files/65-stats-v3-0-1-dev/
config:
Spoiler: zobrazit
Kód: Vybrat vše
# Only use this file if you've set "storage" to "mysql" in config.yml
# Otherwise this file will be ignored.
host: 195900_mysql_db
port: 3306
user: 195900_mysql_db
pass: *heslo*
database: Stats
prefix: Stats3_error:
Spoiler: zobrazit
Kód: Vybrat vše
> [23:26:57 INFO]: The table causing the error: null
> [23:26:57 ERROR]: null
nl.lolmewn.stats.api.storage.StorageException: Something went wrong while loading the user!
at nl.lolmewn.stats.mysql.MySQLStorage.load(MySQLStorage.java:124) ~[Stats3.jar:?]
at nl.lolmewn.stats.user.StatsUserManager$1.run(StatsUserManager.java:73) [Stats3.jar:?]
at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71) [minecraft_server.jar:git-Spigot-0359393-9a17f01]
at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53) [minecraft_server.jar:git-Spigot-0359393-9a17f01]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [?:1.7.0_51]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [?:1.7.0_51]
at java.lang.Thread.run(Thread.java:744) [?:1.7.0_51]
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (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 org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2152) ~[Stats3.jar:?]
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) ~[Stats3.jar:?]
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) ~[Stats3.jar:?]
at nl.lolmewn.stats.mysql.MySQLStorage.load(MySQLStorage.java:52) ~[Stats3.jar:?]
... 6 more
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) ~[?:1.7.0_51]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_51]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_51]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_51]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at sun.reflect.GeneratedConstructorAccessor66.newInstance(Unknown Source) ~[?:?]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_51]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_51]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) ~[Stats3.jar:?]
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) ~[Stats3.jar:?]
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2162) ~[Stats3.jar:?]
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148) ~[Stats3.jar:?]
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) ~[Stats3.jar:?]
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) ~[Stats3.jar:?]
at nl.lolmewn.stats.mysql.MySQLStorage.load(MySQLStorage.java:52) ~[Stats3.jar:?]
... 6 more
Caused by: java.net.UnknownHostException: 195900_mysql_db: Name or service not known
at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method) ~[?:1.7.0_51]
at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:901) ~[?:1.7.0_51]
at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1293) ~[?:1.7.0_51]
at java.net.InetAddress.getAllByName0(InetAddress.java:1246) ~[?:1.7.0_51]
at java.net.InetAddress.getAllByName(InetAddress.java:1162) ~[?:1.7.0_51]
at java.net.InetAddress.getAllByName(InetAddress.java:1098) ~[?:1.7.0_51]
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:244) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at sun.reflect.GeneratedConstructorAccessor66.newInstance(Unknown Source) ~[?:?]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_51]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_51]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[minecraft_server.jar:git-Spigot-0359393-9a17f01]
at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) ~[Stats3.jar:?]
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) ~[Stats3.jar:?]
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2162) ~[Stats3.jar:?]
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148) ~[Stats3.jar:?]
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) ~[Stats3.jar:?]
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) ~[Stats3.jar:?]
at nl.lolmewn.stats.mysql.MySQLStorage.load(MySQLStorage.java:52) ~[Stats3.jar:?]
... 6 morenevíte kde je chyba?
Předem díky
Templary
