Форум администраторов игровых серверов

Форум администраторов игровых серверов (https://forum.zone-game.info/TT.php)
-   Lineage II (https://forum.zone-game.info/forumdisplay.php?f=34)
-   -   Проблема с registergameserver.sh (https://forum.zone-game.info/showthread.php?t=6281)

DeniM_FAGoT 01.02.2010 10:00

Проблема с 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 = мой_пароль

Navvy 01.02.2010 11:13

Re: Проблема с registergameserver.sh
 
Цитата:

Сообщение от DeniM_FAGoT (Сообщение 53383)
P.S.S. в конфиге
Driver = com.mysql.jdbc.Driver
URL = jdbc:mysql://localhost/l2open_db
Login = root
Password = мой_пароль

Это из настроек логин сервера?

registergameserver.sh берет данные для подключения из настроек логин сервера.

Проверьте в my.cnf строку:
#bind-address = 127.0.0.1

Что у вас там?

DeniM_FAGoT 01.02.2010 11:19

Re: Проблема с registergameserver.sh
 
Цитата:

Сообщение от Navvy (Сообщение 53387)
Это из настроек логин сервера?

да

Цитата:

Сообщение от Navvy (Сообщение 53387)
Проверьте в my.cnf строку:
#bind-address = 127.0.0.1

Что у вас там?

bind-address = 127.0.0.1

Navvy 01.02.2010 11:32

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 адресах вашего сервера

DeniM_FAGoT 01.02.2010 16:54

Re: Проблема с registergameserver.sh
 
Спасибо за помощь!!! Вы были правы!


Текущее время: 19:26. Часовой пояс GMT +3.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd. Перевод: zCarot