Re: Troubles with l2j Epilogue
Posted: Tue Apr 13, 2010 4:44 pm
Up. How to start CommunityServer and configure it? 
http://l2jserver.com/wiki/Community_Board_ServerBUDU_KRATOK wrote:Up. How to start CommunityServer and configure it?
Page 2 of 4
Re: Troubles with l2j Epilogue
Posted: Tue Apr 13, 2010 8:07 pm
Re: Troubles with l2j Epilogue
Posted: Wed Apr 14, 2010 12:29 pm
Thx.
Configured it:
Server ID: 120
Hexid: 36a805c5f13c8c44601e4fe83faa46c9
1.1) Edit your CommunityServerHexId/CommunityServerSqlDpId, in this file: gameserver\config\CommunityServer.properties
..done
3.1) Edit the gameservers table. 'serverId' = 'CommunityServerSqlDpId', 'hex_id' = 'CommunityServerHexId'.
..done
Server ID: 120
Hexid: 36a805c5f13c8c44601e4fe83faa46c9
4.) Now, edit the community\data\top\servertopdir.xml file. Add your own GameServer(s) '<server sqlDPId="200" dir="Bartz" />' line, or change the file as your needs.
..done:
<server sqlDPId="120" dir="x5" />
Start all bin's (Community, Login, Game) and...
GameServer:
CommunityServerThread: Trying to connect to 127.0.0.1 on port 9013.
CommunityServerThread: TCP Connection lost!
CommunityServer:
[14 ряЁ 16:23:23] Received connection: 127.0.0.1
[14 ряЁ 16:23:23] Invalid HexId. Closing connection...
[14 ряЁ 16:23:23] Connection lost!
java.io.IOException: TCP Read: Not initialized.
at com.l2jserver.communityserver.network.netcon.NetConnection.read(NetCo
nnection.java:88)
at com.l2jserver.communityserver.network.GameServerThread.run(GameServer
Thread.java:81)
and reconnct...
wtf?)
Configured it:
Server ID: 120
Hexid: 36a805c5f13c8c44601e4fe83faa46c9
1.1) Edit your CommunityServerHexId/CommunityServerSqlDpId, in this file: gameserver\config\CommunityServer.properties
..done
3.1) Edit the gameservers table. 'serverId' = 'CommunityServerSqlDpId', 'hex_id' = 'CommunityServerHexId'.
..done
Server ID: 120
Hexid: 36a805c5f13c8c44601e4fe83faa46c9
4.) Now, edit the community\data\top\servertopdir.xml file. Add your own GameServer(s) '<server sqlDPId="200" dir="Bartz" />' line, or change the file as your needs.
..done:
<server sqlDPId="120" dir="x5" />
Start all bin's (Community, Login, Game) and...
GameServer:
CommunityServerThread: Trying to connect to 127.0.0.1 on port 9013.
CommunityServerThread: TCP Connection lost!
CommunityServer:
[14 ряЁ 16:23:23] Received connection: 127.0.0.1
[14 ряЁ 16:23:23] Invalid HexId. Closing connection...
[14 ряЁ 16:23:23] Connection lost!
java.io.IOException: TCP Read: Not initialized.
at com.l2jserver.communityserver.network.netcon.NetConnection.read(NetCo
nnection.java:88)
at com.l2jserver.communityserver.network.GameServerThread.run(GameServer
Thread.java:81)
and reconnct...
wtf?)
Re: Troubles with l2j Epilogue
Posted: Wed Apr 14, 2010 3:32 pm
Help plz 
Re: Troubles with l2j Epilogue
Posted: Wed Apr 14, 2010 3:51 pm
use ONLY numeric characters in hexid on CB server.
also better start to read what server wrote to you
also better start to read what server wrote to you
[14 ряЁ 16:23:23] Received connection: 127.0.0.1
[14 ряЁ 16:23:23] Invalid HexId. Closing connection...
Re: Troubles with l2j Epilogue
Posted: Wed Apr 14, 2010 6:55 pm
Ehm ok, thx)
Re: Troubles with l2j Epilogue
Posted: Thu Apr 15, 2010 5:34 pm
hm... use hexid "3680" server id "120" - Invalid =(
hexid "120" server_id "120" - invalid =(
Show you hexid and server_id plz
Help plz, i'm really don't understand why it's don't work =(
hexid "120" server_id "120" - invalid =(
Show you hexid and server_id plz
Help plz, i'm really don't understand why it's don't work =(
Re: Troubles with l2j Epilogue
Posted: Fri Apr 16, 2010 2:48 am
use same hexid in sql and in xml file...its logical, doesnt it?
and server id same in config file...
all of parameters created not for just be it...its needed for communication. try to realize it in your mind and you start to understand of mechanism
and server id same in config file...
all of parameters created not for just be it...its needed for communication. try to realize it in your mind and you start to understand of mechanism
Re: Troubles with l2j Epilogue
Posted: Fri Apr 16, 2010 6:27 am
=\
CommunityServer.properties
DB, table "gameservers"
xml file servertopdir.xml
Result:
[16 ряЁ 10:20:47] Received connection: 127.0.0.1
[16 ряЁ 10:20:47] Invalid HexId. Closing connection...
[16 ряЁ 10:20:47] Connection lost!
I'm understand mechanism, i'm don't understand why it don't work =\
CommunityServer.properties
Code: Select all
#CommunityServerSqlDpId = [i]120[/i] #CommunityServerHexId = [b]3680[/b]Code: Select all
server_id hexid[i]120[/i] [b]3680[/b] Code: Select all
<server sqlDPId="[i]120[/i]" dir="x5" />Result:
[16 ряЁ 10:20:47] Received connection: 127.0.0.1
[16 ряЁ 10:20:47] Invalid HexId. Closing connection...
[16 ряЁ 10:20:47] Connection lost!
I'm understand mechanism, i'm don't understand why it don't work =\
Re: Troubles with l2j Epilogue
Posted: Fri Apr 16, 2010 6:30 am
try to hexid lik 689786896967
more digits, should work, and use as in example - 200 id of server, may be it some how limits...check later
more digits, should work, and use as in example - 200 id of server, may be it some how limits...check later
Re: Troubles with l2j Epilogue
Posted: Fri Apr 16, 2010 6:44 am
Don't work.
Maybe recompile bild of gameserver/community?
Stop. Table "gameservers" or "registered_gameservers"?
ID any or onlу next after GameServer?
P.S. Парень, ты ведь Русский, растолкуй мне бестолковому
Нашёл тутор со сборки RT: http://forum.l2-j.ru/index.php?PHPSESSI ... topics;u=5
Он несколько отличается от того, что на вики. Но там всё работает
ADDED: Update wiki plz.
3.1) Edit the gameservers table. 'serverId' = 'CommunityServerSqlDpId', 'hex_id' = 'CommunityServerHexId'.
Code: Select all
[16 ряЁ 10:38:58] Received connection: 127.0.0.1[16 ряЁ 10:38:58] Invalid HexId. Closing connection...[16 ряЁ 10:38:58] Connection lost!java.io.IOException: TCP Read: Not initialized. at com.l2jserver.communityserver.network.netcon.NetConnection.read(NetConnection.java:88) at com.l2jserver.communityserver.network.GameServerThread.run(GameServerThread.java:81)Maybe recompile bild of gameserver/community?
Stop. Table "gameservers" or "registered_gameservers"?
ID any or onlу next after GameServer?
P.S. Парень, ты ведь Русский, растолкуй мне бестолковому
Нашёл тутор со сборки RT: http://forum.l2-j.ru/index.php?PHPSESSI ... topics;u=5
Он несколько отличается от того, что на вики. Но там всё работает
ADDED: Update wiki plz.
3.1) Edit the gameservers table. 'serverId' = 'CommunityServerSqlDpId', 'hex_id' = 'CommunityServerHexId'.
Re: Troubles with l2j Epilogue
Posted: Fri Apr 16, 2010 6:57 am
table gameservers is used for registering gameserver at loginserver and should be in the loginserver database.
table registered_gameservers is used for registering gameserver at community server and should be in community database.
the two hexid - gameserver->loginserver and gameserver->communityserver dont have to be the same, exactly can't be same.
table registered_gameservers is used for registering gameserver at community server and should be in community database.
the two hexid - gameserver->loginserver and gameserver->communityserver dont have to be the same, exactly can't be same.
Re: Troubles with l2j Epilogue
Posted: Fri Apr 16, 2010 7:07 am
Ok.
New error
In CommunityServer:
GameServer:
Error in mysql request, it's is a bug on CommunityServer sources or in process compilling?
Added:
And when shutting down CS:
[16 ряЁ 11:04:09] error while saving new Forum to db com.mysql.jdbc.exceptions.j
dbc4.MySQLSyntaxErrorException: Unknown column 'serverId' in 'field list'
New error
In CommunityServer:
Code: Select all
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'serverId' in 'where clause'at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)...and more..Code: Select all
COMMUNITY_SERVER_THREAD: Auth 0Added:
And when shutting down CS:
[16 ряЁ 11:04:09] error while saving new Forum to db com.mysql.jdbc.exceptions.j
dbc4.MySQLSyntaxErrorException: Unknown column 'serverId' in 'field list'
Re: Troubles with l2j Epilogue
Posted: Fri Apr 16, 2010 7:14 am
you did something terribly wrong.. really..
Re: Troubles with l2j Epilogue
Posted: Fri Apr 16, 2010 7:19 am
Really?
Ok, thx for answering my stupid questions
More about new problem:
CS:
GS:
In game Community Board don't work.
P.S. Sorry, MOTD don't support russian?
Ok, thx for answering my stupid questions
More about new problem:
CS:
Code: Select all
[16 ряЁ 11:57:22] Received connection: *IP here*[16 ряЁ 11:57:22] GameServer connected![16 ряЁ 11:57:22] Transfering needed data for CommunityServer![16 ряЁ 11:57:23] CB successfully get 9 player(s) data.[16 ряЁ 11:57:23] CB successfully get 1 clan(s) data.[16 ряЁ 11:57:23] CB successfully get 9 castle(s) data.com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'serverId' in 'where clause' 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:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2261) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at com.l2jserver.communityserver.communityboard.CommunityBoardManager.loadDataBase(CommunityBoardManager.java:99) at com.l2jserver.communityserver.communityboard.CommunityBoardManager.setLoaded(CommunityBoardManager.java:380) at com.l2jserver.communityserver.network.GameServerThread$loadingData.run(GameServerThread.java:336) at java.lang.Thread.run(Unknown Source)[16 ряЁ 11:57:23] Requesting 0 clan notices from GS.Code: Select all
CommunityServerThread: Trying to connect to *IP here* on port 9013.Transfering 1 Clan data to CB server.Transfering 9 character data to CB server.Transfering 9 castles data to CB server.Server connected in 1 secondsCOMMUNITY_SERVER_THREAD: Auth 0P.S. Sorry, MOTD don't support russian?