trololo1234 0 Опубликовано 5 января, 2017 (изменено) Доброго времени суток, господа. Вкратце - пилил на Lucera 1.7(euro-pvp, interlude) на локалке, изначально стоял обычный MySQL 5.1, всё работало как часы на всех стадиях. Дошёл до обвязки, удалил старый MySQL, поставил OpenServer 5.2.2 (конф=Apache-2.2, PHP-5.3, MySQL-5.5), залил туда SW13, создал чистую базу, залил туда дамп. В итоге - сайт работает, ЛС и ГС стартуют нормально, но как только в клиенте ввожу логин и пароль, то в самом клиенте ноль эмоций, а на ЛС и ГС выскакивает вот это: Could not load allowedIp:com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.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:411)at com.mysql.jdbc.Util.getInstance(Util.java:386)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1269)at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1261)at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4261)at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4227)at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)at ru.catssoftware.loginserver.manager.LoginManager.getAllowedIP(LoginManager.java:621)at ru.catssoftware.loginserver.manager.LoginManager.tryAuthLogin(LoginManager.java:231)at ru.catssoftware.loginserver.clientpackets.RequestAuthLogin.run(RequestAuthLogin.java:106)at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)at java.lang.Thread.run(Unknown Source)Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet successfully received from the server was 120 004 milliseconds ago. The last packet sent successfully to the server was 2 milliseconds ago.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:411)at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3589)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3478)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4019)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at ru.catssoftware.loginserver.manager.LoginManager$ConnectionCheck.run(LoginManager.java:84)Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3039)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3489)... 10 more[05.01.17 08:51:14] LoginManager: Unable to retrive accountcom.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.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:411)at com.mysql.jdbc.Util.getInstance(Util.java:386)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1269)at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1261)at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4261)at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4227)at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)at ru.catssoftware.loginserver.manager.LoginManager.getAccount(LoginManager.java:381)at ru.catssoftware.loginserver.manager.LoginManager.loginValid(LoginManager.java:450)at ru.catssoftware.loginserver.manager.LoginManager.loginValid(LoginManager.java:425)at ru.catssoftware.loginserver.manager.LoginManager.tryAuthLogin(LoginManager.java:241)at ru.catssoftware.loginserver.clientpackets.RequestAuthLogin.run(RequestAuthLogin.java:106)at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)at java.lang.Thread.run(Unknown Source)Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet successfully received from the server was 120 004 milliseconds ago. The last packet sent successfully to the server was 2 milliseconds ago.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:411)at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3589)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3478)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4019)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at ru.catssoftware.loginserver.manager.LoginManager$ConnectionCheck.run(LoginManager.java:84)Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3039)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3489)... 10 more[05.01.17 08:51:14] LoginManager: Unable to modify accountcom.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.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:411)at com.mysql.jdbc.Util.getInstance(Util.java:386)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1269)at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1261)at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4261)at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4227)at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)at ru.catssoftware.loginserver.manager.LoginManager.addOrUpdateAccount(LoginManager.java:589)at ru.catssoftware.loginserver.manager.LoginManager.handleAccountNotFound(LoginManager.java:575)at ru.catssoftware.loginserver.manager.LoginManager.loginValid(LoginManager.java:457)at ru.catssoftware.loginserver.manager.LoginManager.loginValid(LoginManager.java:425)at ru.catssoftware.loginserver.manager.LoginManager.tryAuthLogin(LoginManager.java:241)at ru.catssoftware.loginserver.clientpackets.RequestAuthLogin.run(RequestAuthLogin.java:106)at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)at java.lang.Thread.run(Unknown Source)Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet successfully received from the server was 120 004 milliseconds ago. The last packet sent successfully to the server was 2 milliseconds ago.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:411)at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3589)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3478)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4019)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at ru.catssoftware.loginserver.manager.LoginManager$ConnectionCheck.run(LoginManager.java:84)Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3039)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3489)... 10 more[05.01.17 08:51:14] LoginManager: Unable to retrive accountcom.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.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:411)at com.mysql.jdbc.Util.getInstance(Util.java:386)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1269)at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1261)at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4261)at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4227)at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)at ru.catssoftware.loginserver.manager.LoginManager.getAccount(LoginManager.java:381)at ru.catssoftware.loginserver.manager.LoginManager.tryAuthLogin(LoginManager.java:257)at ru.catssoftware.loginserver.clientpackets.RequestAuthLogin.run(RequestAuthLogin.java:106)at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)at java.lang.Thread.run(Unknown Source)Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet successfully received from the server was 120 004 milliseconds ago. The last packet sent successfully to the server was 2 milliseconds ago.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:411)at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3589)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3478)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4019)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)at ru.catssoftware.loginserver.manager.LoginManager$ConnectionCheck.run(LoginManager.java:84)Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3039)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3489)... 10 more L2DatabaseFactory: Failed to retrieve database connection!com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.at sun.reflect.GeneratedConstructorAccessor58.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:411)at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)at com.mysql.jdbc.MysqlIO.(MysqlIO.java:350)at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2408)at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2445)at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2230)at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:813)at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)at sun.reflect.GeneratedConstructorAccessor60.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:411)at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:79)at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)at ru.catssoftware.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:128)at ru.catssoftware.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:122)at ru.catssoftware.gameserver.network.daemons.L2TopCommentsRU$2.run(L2TopCommentsRU.java:205)at java.lang.Thread.run(Unknown Source)Caused by: java.net.ConnectException: Connection refused: connectat java.net.TwoStacksPlainSocketImpl.socketConnect(Native Method)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.(Unknown Source)at java.net.Socket.(Unknown Source)at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:259)at com.mysql.jdbc.MysqlIO.(MysqlIO.java:300)... 21 more Поменял в OpenServer MySQL на 5.1 (вместо 5.5), всё перезалил, перезагрузил, но всё тоже самое. Помогите пожалуйста куда копать, с меня ++++ Изменено 5 января, 2017 пользователем trololo1234 Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
zGosu 396 Опубликовано 5 января, 2017 (изменено) А после перехода на другую версию Вы меняли mysql-connector-java? проблема решена указанием bind address = 127.0.0.1 Изменено 5 января, 2017 пользователем zGosu Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
trololo1234 0 Опубликовано 5 января, 2017 А после перехода на другую версию Вы меняли mysql-connector-java? проблема решена указанием bind address = 127.0.0.1 нет, расскажите, пожалуйста поподробней, я в этом пока не очень.... Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
zGosu 396 Опубликовано 5 января, 2017 нет, расскажите, пожалуйста поподробней, я в этом пока не очень.... bind address = 127.0.0.1 эта настройка находится в my.cnf mysql-connector-java этот файл обычно лежит в сборке в папке libs. Замените ее на более новую версию. Еще слышал что это ошибка на люцере может быть из-за неправильного переноса БД. Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
se1dhe 501 Опубликовано 7 января, 2017 @@trololo1234, курите мануалы по настройке MySQL Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
trololo1234 0 Опубликовано 14 января, 2017 Этот бой я проиграл, но в итоге поставил всё на денвер и заработало) Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты