Zdravím,
neví někdo v čem by mohla být chyba? Programuji plugin na bungeecord a potřebuji se připojit na databází, ale nějak se to nechce chytit
Kód v javě:
Kód: Vybrat vše
private Connection con = null;
private String _connectionString = "jdbc:mysql://casa28.fakaheda.eu:3306/BungeeServers?autoReconnect=true&failOverReadOnly=false&maxReconnects=10";
private String _userName = "203154_mysql_db";
private String _password = "neřeknu :(";
private static String CREATE_TABLE = "CREATE TABLE IF NOT EXISTS BungeeMotd (id INT NOT NULL AUTO_INCREMENT, motd VARCHAR(256), PRIMARY KEY (id));";
private static String RETRIEVE_MOTD = "SELECT motd FROM BungeeMotd;";místo casa28.fakaheda.eu jsem zkoušel dávat normální IP databáze, ale nechce.
Error v konzoli:
Kód: Vybrat vše
[spoiler] 14:47:10 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 10 times. Giving up.
14:47:10 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
14:47:10 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
14:47:10 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
14:47:10 [SEVERE] at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
14:47:10 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
14:47:10 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:360)
14:47:10 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
14:47:10 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
14:47:10 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
14:47:10 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
14:47:10 [SEVERE] at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2144)
14:47:10 [SEVERE] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2069)
14:47:10 [SEVERE] at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)
14:47:10 [SEVERE] at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
14:47:10 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
14:47:10 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
14:47:10 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
14:47:10 [SEVERE] at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
14:47:10 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
14:47:10 [SEVERE] at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:395)
14:47:10 [SEVERE] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
14:47:10 [SEVERE] at java.sql.DriverManager.getConnection(DriverManager.java:664)
14:47:10 [SEVERE] at java.sql.DriverManager.getConnection(DriverManager.java:247)
14:47:10 [SEVERE] at cz.fightgames.bungee.motd.MotdRepository.initialize(MotdRepository.java:26)
14:47:10 [SEVERE] at cz.fightgames.bungee.motd.MotdManager.<init>(MotdManager.java:21)
14:47:10 [SEVERE] at cz.fightgames.bungee.FightGamesBungee.onEnable(FightGamesBungee.java:17)
14:47:10 [SEVERE] at net.md_5.bungee.api.plugin.PluginManager.enablePlugins(PluginManager.java:227)
14:47:10 [SEVERE] at net.md_5.bungee.BungeeCord.start(BungeeCord.java:256)
14:47:10 [SEVERE] at net.md_5.bungee.BungeeCordLauncher.main(BungeeCordLauncher.java:55)
14:47:10 [SEVERE] at net.md_5.bungee.Bootstrap.main(Bootstrap.java:15)
14:47:10 [SEVERE] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user '203154_mysql_db'@'%' to database 'BungeeServers'
14:47:10 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
14:47:10 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
14:47:10 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
14:47:10 [SEVERE] at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
14:47:10 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
14:47:10 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:360)
14:47:10 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
14:47:10 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
14:47:10 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
14:47:10 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)
14:47:10 [SEVERE] at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1659)
14:47:10 [SEVERE] at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1206)
14:47:10 [SEVERE] at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2234)
14:47:10 [SEVERE] at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2085)
14:47:10 [SEVERE] ... 19 more
14:47:10 [INFO] Initialized MOTD.
14:47:28 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 10 times. Giving up.
14:47:28 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
14:47:28 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
14:47:28 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
14:47:28 [SEVERE] at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
14:47:28 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
14:47:28 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:360)
14:47:28 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
14:47:28 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
14:47:28 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
14:47:28 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
14:47:28 [SEVERE] at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2144)
14:47:28 [SEVERE] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2069)
14:47:28 [SEVERE] at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)
14:47:28 [SEVERE] at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
14:47:28 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
14:47:28 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
14:47:28 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
14:47:28 [SEVERE] at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
14:47:28 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
14:47:28 [SEVERE] at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:395)
14:47:28 [SEVERE] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
14:47:28 [SEVERE] at java.sql.DriverManager.getConnection(DriverManager.java:664)
14:47:28 [SEVERE] at java.sql.DriverManager.getConnection(DriverManager.java:247)
14:47:28 [SEVERE] at cz.fightgames.bungee.count.PlayerCountRepository.initialize(PlayerCountRepository.java:42)
14:47:28 [SEVERE] at cz.fightgames.bungee.count.PlayerCount.<init>(PlayerCount.java:25)
14:47:28 [SEVERE] at cz.fightgames.bungee.FightGamesBungee.onEnable(FightGamesBungee.java:18)
14:47:28 [SEVERE] at net.md_5.bungee.api.plugin.PluginManager.enablePlugins(PluginManager.java:227)
14:47:28 [SEVERE] at net.md_5.bungee.BungeeCord.start(BungeeCord.java:256)
14:47:28 [SEVERE] at net.md_5.bungee.BungeeCordLauncher.main(BungeeCordLauncher.java:55)
14:47:28 [SEVERE] at net.md_5.bungee.Bootstrap.main(Bootstrap.java:15)
14:47:28 [SEVERE] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user '203154_mysql_db'@'%' to database 'BungeeServers'
14:47:28 [SEVERE] at sun.reflect.GeneratedConstructorAccessor3.newInstance(Unknown Source)
14:47:28 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
14:47:28 [SEVERE] at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
14:47:28 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
14:47:28 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:360)
14:47:28 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
14:47:28 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
14:47:28 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
14:47:28 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)
14:47:28 [SEVERE] at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1659)
14:47:28 [SEVERE] at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1206)
14:47:28 [SEVERE] at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2234)
14:47:28 [SEVERE] at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2085)
14:47:28 [SEVERE] ... 19 more[/spoiler]