Проблема с registergameserver.sh
И так:
ОС: Ubuntu Server 9.10 (Иксов нет) java -version: java version "1.6.0_15" Java(TM) SE Runtime Environment (build 1.6.0_15-b03) Java HotSpot(TM) Client VM (build 14.1-b02, mixed mode, sharing) MySQL стоит и работает. сервер находится по адресу: /home/user/la2 В общем когда запускаешь ./registergameserver.sh, то получаешь в ответ [SPOILER]================================================== ================================================== ===============================-[ Main ] ================================================== ================================================== ============================-[ Network ] ================================================== ================================================== ========================-[ Versionning ] FATAL: Failed loading GameServerTable. Reason: 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. com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce ption: 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.newInsta nce0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Construc tor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6) at com.mysql.jdbc.SQLError.createCommunicationsExcept ion(SQLError.java:1074) at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onImpl.java:2214) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.java:781) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connect ion.java:46) at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Construc tor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6) at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onImpl.java:352) at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:284) at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManagerDataSource.java:119) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnection(WrapperConnectionPoolDataSou rce.java:143) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnection(WrapperConnectionPoolDataSou rce.java:132) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAutomaticTestTable(C3P0PooledConn ectionPoolManager.java:772) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooledConnectionPool(C3P0PooledConnec tionPoolManager.java:696) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0PooledConnectionPoolManager.jav a:257) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0PooledConnectionPoolManager.jav a:271) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(AbstractPoolBackedDataSource.jav a:128) at com.l2open.L2DatabaseFactory.<init>(L2DatabaseFact ory.java:83) at com.l2open.L2DatabaseFactory.getInstance(L2Databas eFactory.java:176) at com.l2open.loginserver.GameServerTable.loadRegiste redGameServers(GameServerTable.java:145) at com.l2open.loginserver.GameServerTable.<init>(Game ServerTable.java:83) at com.l2open.loginserver.GameServerTable.load(GameSe rverTable.java:68) at com.l2open.gsregistering.GameServerRegister.main(G ameServerRegister.java:41) Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce ption: 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.newInsta nce0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Construc tor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6) at com.mysql.jdbc.SQLError.createCommunicationsExcept ion(SQLError.java:1074) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onImpl.java:2137) ... 23 more Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(Abstrac tPlainSocketImpl.java:310) at java.net.AbstractPlainSocketImpl.connectToAddress( AbstractPlainSocketImpl.java:176) at java.net.AbstractPlainSocketImpl.connect(AbstractP lainSocketImpl.java:163) at java.net.SocksSocketImpl.connect(SocksSocketImpl.j ava:384) at java.net.Socket.connect(Socket.java:542) at java.net.Socket.connect(Socket.java:492) at java.net.Socket.<init>(Socket.java:389) at java.net.Socket.<init>(Socket.java:232) at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.java:253) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292) ... 24 more[/SPOILER] Помогите плиз с решением данной проблемы:help: P.S. такое на сборках l2j и l2open P.S.S. в конфиге Driver = com.mysql.jdbc.Driver URL = jdbc:mysql://localhost/l2open_db Login = root Password = мой_пароль |
Re: Проблема с registergameserver.sh
Цитата:
registergameserver.sh берет данные для подключения из настроек логин сервера. Проверьте в my.cnf строку: #bind-address = 127.0.0.1 Что у вас там? |
Re: Проблема с registergameserver.sh
Цитата:
Цитата:
|
Re: Проблема с registergameserver.sh
Если перед bind-address = 127.0.0.1 не стоит # значит сервер работает только на локальном IP 127.0.0.1
Следовательно в настройках нужно указывать: Driver = com.mysql.jdbc.Driver URL = jdbc:mysql://127.0.0.1/l2open_db Login = root Password = мой_пароль Или закоментируйте #bind-address = 127.0.0.1 Тогда MySQL будет доступен на всех IP адресах вашего сервера |
Re: Проблема с registergameserver.sh
Спасибо за помощь!!! Вы были правы!
|
Текущее время: 19:26. Часовой пояс GMT +3. |
Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd. Перевод: zCarot