Troubles with l2j Epilogue

[BUDU_KRATOK]

Up. How to start CommunityServer and configure it?

[LasTravel]

Up. How to start CommunityServer and configure it?

http://l2jserver.com/wiki/Community_Board_Server

[BUDU_KRATOK]

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?)

[BUDU_KRATOK]

Help plz

[denser]

use ONLY numeric characters in hexid on CB server.
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...

[BUDU_KRATOK]

Ehm ok, thx)

[BUDU_KRATOK]

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 =(

[denser]

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

[BUDU_KRATOK]

=\

CommunityServer.properties

Code: Select all

#CommunityServerSqlDpId = [i]120[/i] #CommunityServerHexId = [b]3680[/b]

DB, table "gameservers"

Code: Select all

server_id   hexid[i]120[/i]           [b]3680[/b] 

xml file servertopdir.xml

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 =\

[denser]

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

[BUDU_KRATOK]

Don't work.

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'.

[janiii]

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.

[BUDU_KRATOK]

Ok.

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..

GameServer:

Code: Select all

COMMUNITY_SERVER_THREAD: Auth 0

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'

[janiii]

you did something terribly wrong.. really..

[BUDU_KRATOK]

Really?

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.

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 0

In game Community Board don't work.

P.S. Sorry, MOTD don't support russian?