rider953727 28 Опубликовано 6 октября, 2014 поставил сервер на машинку ДЦ (линукс ОС) но он не запускается подскажите конкретно в чём проблемма это в логин сервере: 06 (21:11:24)#Welcome to pwLogin. 06 (21:11:24)#Configs: loaded. 06 (21:11:24)#Black IPs: 0 loaded. 06 (21:11:24)#White IPs: loaded. 06 (21:11:24)#DATABASE: [ERROR] Failed initializing. 06 (21:11:24)#Reason: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://192.168.101.206/gs308, username = ga308. Terminating connection pool. Original Exception: ------ java.sql.SQLException: null, message from server: "Host '192.168.101.202' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'" at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1128) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2336) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) at java.sql.DriverManager.getConnection(DriverManager.java:579) at java.sql.DriverManager.getConnection(DriverManager.java:221) at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:295) at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:333) at com.jolbox.bonecp.BoneCPDataSource.maybeInit(BoneCPDataSource.java:150) at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:112) at net.sf.l2j.L2DatabaseFactory.<init>(L2DatabaseFactory.java:68) at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:123) at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:175) at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:64) ------ это в геймсервере: Oct 06, 2014 9:05:30 PM net.sf.l2j.Config load INFO: #Configs: loaded. Oct 06, 2014 9:05:30 PM net.sf.l2j.gameserver.GameServer main INFO: #Welcome to pwServer. Exception in thread "main" java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://192.168.101.206/gs308, username = gs308. Terminating connection pool. Original Exception: ------ java.sql.SQLException: null, message from server: "Host '192.168.101.202' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'" at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1104) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2412) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2445) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2230) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334) at java.sql.DriverManager.getConnection(DriverManager.java:579) at java.sql.DriverManager.getConnection(DriverManager.java:221) at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:295) at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:333) at com.jolbox.bonecp.BoneCPDataSource.maybeInit(BoneCPDataSource.java:150) at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:112) at net.sf.l2j.L2DatabaseFactory.load(L2DatabaseFactory.java:65) at net.sf.l2j.L2DatabaseFactory.init(L2DatabaseFactory.java:40) at net.sf.l2j.gameserver.GameServer.main(GameServer.java:557) ------ at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:340) at com.jolbox.bonecp.BoneCPDataSource.maybeInit(BoneCPDataSource.java:150) at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:112) at net.sf.l2j.L2DatabaseFactory.load(L2DatabaseFactory.java:65) at net.sf.l2j.L2DatabaseFactory.init(L2DatabaseFactory.java:40) at net.sf.l2j.gameserver.GameServer.main(GameServer.java:557) Caused by: java.sql.SQLException: null, message from server: "Host '192.168.101.202' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'" at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1104) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2412) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2445) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2230) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334) at java.sql.DriverManager.getConnection(DriverManager.java:579) at java.sql.DriverManager.getConnection(DriverManager.java:221) at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:295) at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:333) ... 5 more сборка pw soft очень нужна помощь Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
sharp1k 321 Опубликовано 6 октября, 2014 (изменено) mysqladmin flush-hosts в консоль иногда достаточно просто прочитать лог ошибки чтобы понять.. Изменено 6 октября, 2014 пользователем sharp1k Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
hoske 117 Опубликовано 6 октября, 2014 нет соединения с бд Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
rider953727 28 Опубликовано 6 октября, 2014 спасибо, всё решил=) банальная ошибочка... Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты