[Guide]Making a interlude server

[xXxExosoulerxXx]

I saw many ppl doing a LOT of wrong things and asking me for support w. the Interlude install so here i go again ... (I cant edit the another guide because its too old).

 

THIS GUIDE ISNT FOR MINE PRE-CONFIGURED SERVER PACKS !!!

 

First Step : Preparing ur system and the server

 

Well, Like before ull need few programs :

 

1- JavaJDK

2- MySQL server

3- Navicat(check the L2J tools folder)

4- For Server/Data Pack Files Visit:http://forum.ragezone.com/f323/share-server-packs-repository-tools-329892/ <<There you will find the Latest Revs Of Each Team>>

 

Now lets beggin....

 

1º- Install JavaJDK (u wont hve any problems on it).

 

2º- Lets Install the MySQL server:

- Run the Executable file and start the installation.

- After the install, a window called "MySQL server instance configuration" will appear, than follow these steps to configure it.

 

- Create a new instance and than Select "Detailed Configuration"

 

 

- Choose "Server Machine"

 

 

- Press Next til the screen above.

- U can choose the first option if u do not pretend to hve more of 20 players, or use the third option ("Manual setting") where in the "concurrent connections" field , u put how many ppl do u like to join ur server.

 

 

- Keep pressing next til the SECURITY SETTINGS screen.

- On it , Uncheck the "modify security settings" than next.

 

 

- Now press the EXECUTE button (note: if it gave the error 0 return to the DATABASE USAGE window and choose TRANSACTIONAL DATABASE instead of MULTIFUNCTIONAL DATABASE !).

 

 

-Ok ur MySQL server is setted up ! Login: Root , without password and port 3306.

 

3º- Now lets setup the NAVICAT (MySQL GUY). (For who dont know what is that , just imagine this way: MySQL is like the Internet and the NAVICAT is like the Explorer or Firefox).

 

-Intall NAVICAT , than open it.

 

-In NAVICAT , click on CONNECTION than fill up the spaces like the image above.

 

 

-After that will appear a new connection, into connections field, called Localhost. Right click on it than choose NEW DATABASE. A small window will popup asking for the DB name. Use the name l2jdb than click ok. Well done DATABASE created !

 

 

4º- Extract the contents of the server pack in a folder of ur choice.

 

5º- Now lets put all the info of the SQL files into ur database.

 

-Ull find a file called Database_installer.bat at the Tools folder that will be inside ur server's folder.

 

-Right click on it and choose EDIT.

 

-Insert in the line "set mysqlBinPath=" the correct address of ur MySQL BIN FOLDER, than save it.

 

-Execute the modified file. A Ms-dos window will open giving u choices. Press "F" (full installation) every time it ask u to choose.

 

-Okay . Ur database is ready to use !

 

6º- Now we will edit few stuffs to setup the server correctly.

 

-Go into the folder gameserver/config/ and open w. a notepad the server.proprierties file.

 

-Ull need to edit few lines :

 

ExternalHostname= UR EXTERNAL IP HERE ( U can discover it using the site WhatIsMyIP.com - 208.116.34.18 . If u only want to play alone and dont want ppl out of ur network to join, u can left it blank).

 

InternalHostname= UR INTERNAL IP HERE (If ur pc is connect in a network, put ur pc network IP. If not, put 127.0.0.1 ).

 

MinProtocolRevision = 1

MaxProtocolRevision = 999 (edit these both using these number to avoid a protocol error).

 

-Now go into ur LOGIN folder. Run the file "RegisterGameServer.bat".

 

-A ms-dos window will show up and will ask u for an ID. Choose the ID 1 (only need to type 1 ).

 

-Done it a file called hexid(id 1 or something like).txt will appear into ur login folder. Rename it to hexid.txt , copy and paste inside ur gameserver/config/ folder.

 

-Now just need to start the "startloginserver.bat" (login folder) and "startgameserver.bat" (gameserver folder). It will be opened when stops on the following lines (check the image). Remember, ur server is setted up to autocreate accounts so u dont need to execute "startaccountmanager.bat" this time.

 

http://img525.imageshack.us/img525/7012/serversva8.jpg[/img]

 

Okay ! Server is running fellows !

 

PS: If u are under a router, dont forget to open the ports 7777 (game server), and 2106 (login server).

 

Second Step : Preparing the client

 

For it ull need to get L2ENCDEC and hve a updated INTERLUDE client (just need to run the laucher.exe of the game).

 

1º- Extract all the MAIN files of L2encdec into ur ORIGINAL SYSTEM FOLDER and run the patcher.exe .A ms-dos window will appear and ill run few process. Wait it finish.

 

http://img528.imageshack.us/img528/7084/systemux4.jpg[/img]

 

2º-Open a ms-dos console (start > run > cmd) and try to reach the system folder via console (keep typing cd.. until reach c: , than type cd progra* (to reach the folder program files). cd lineag* (to reach lineage II folder). cd system . Okay now u are inside the system folder.

 

3º- Type l2encdec -s l2.ini .It will decrypt the l2.ini in a new file called dec-l2.ini . U can open it using the notepad and edit the line "serveraddr=" inserting the server Internal (urself and same network players) or External (outside players) IP than save it.

 

http://img503.imageshack.us/img503/6295/decan7.jpg[/img]

 

4º- Erase the original L2.ini file. than return to console and type l2encdec -h 413 dec-l2.ini . It will encrypt the dec-l2.ini file in a new file called enc-dec-l2.ini . Just rename it to l2.ini .

 

5º- Just start the L2 using the l2.exe that is INSIDE the system folder !

 

OBS: To make a gm char, First of all ull need to create a new character and be sure that char ISNT connected (just open the game type any login and pass because it will be created automatically , and create a new char).

 

-Open Navicat , click on "localhost" , than click on l2jdb. Many tables will show up. Open the table characters by double clicking it. Find the LINE of ur character than find the COLLUM ACCESS LEVEL of it. Change the number 0 for 100 and log in ! Done !

 

Well... I know it dont hve a HUGE diference in comparison w the old guide but as i sad, a LOT of ppl are asking me a lot of things about interlude configuration... Hope it help. Good luck buddies !

 

PS: For who is getting erros when trying to dec-enc the l2.ini file using the l2encdec, try to download the L2FileEdit C6. U can find it on My Shared Folder > L2J tools . I really dont think a tuto is needed for it. Just open up the program and ull know what to do ^^.

PS2: Patching the system folder is needed in BOTH WAYS !!!!

 

 

 

src:ragezone

credit:nargen

[eKoIce]

At least Put the Screens where are provided from Nargen at Ragezone.

 

[Auryx]

Tnx for posting! It will be usefull for newbies

[fdLP.]

Very Nice Guide Exosouler!! Very good For Newbies!

[Stefoulis15]

Nice Guide Exosouler.. gratz

 

[bourbouli8ras]

nice guide for starters,good pictures.

[Exofil]

man i think the guide is like .::WaterKiller::. guide

http://www.maxcheaters.com/forum/index.php?topic=15069.0

 

or i am wrong ? :D

[eKoIce]

man i think the guide is like .::WaterKiller::. guide

http://www.maxcheaters.com/forum/index.php?topic=15069.0

 

or i am wrong ? :D

 

yeah, but the waterkillers one is in GREEK, this is in ENGLISH.

 

and to the threadstarter: TRY to create something YOURS not only brings Guides from other forums. we are tired of COPY-PASTE

 

ALSO, put the PREFIX at the Title of your topic.

[archonko]

>:( i have problem at 6. step (-Now go into ur LOGIN folder. Run the file "RegisterGameServer.bat".)... I run it.. and write this.. Here u have log: http://leteckaposta.cz/781186645 (click down at java.log) Pls help me ...

[Makyura]

rly useful, thx alot ;D

[Webster_200x]

can i use it to make a server on windows vista x64 or i need diferent sql/java

[eragontr]

THX

[SeiferRealm]

Thx For Much :P

[SeiferRealm]

Thx :P

[Yeroul]

when i start the gameserver it says this:

Starting l2jfree

 

INFO logging initialized

=============================================================-[ Configuration ]

INFO loading ./config/server.properties

INFO loading ./config/hexid.txt

INFO loading ./config/subnets.properties

INFO loading ./config/rates.properties

INFO loading ./config/enchant.properties

INFO loading ./config/pvp.properties

INFO loading ./config/telnet.properties

INFO loading ./config/options.properties

INFO loading ./config/other.properties

INFO loading ./config/geodata.properties

INFO loading ./config/altsettings.properties

INFO loading ./config/clans.properties

INFO loading ./config/champions.properties

INFO loading ./config/lottery.properties

INFO loading ./config/wedding.properties

INFO loading ./config/siege.properties

INFO loading ./config/fortsiege.properties

INFO loading ./config/clanhall.properties

INFO loading ./config/castle.properties

INFO loading ./config/idfactory.properties

INFO loading ./config/fun_engines.properties

INFO loading ./config/sevensigns.properties

INFO loading ./config/GMAccess.properties

INFO loading ./config/command-privileges.properties

INFO loading ./config/irc.properties

INFO loading ./config/boss.properties

INFO loading ./config/sayfilter.txt

INFO loading ./config/elayne.properties

==================================================================-[ Database ]

INFO : MLog clients using log4j logging.

INFO : Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace

: 10]

INFO : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acq

uireIncrement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 500, autoCom

mitOnClose -> true, automaticTestTable -> connection_test_table, breakAfterAcqui

reFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null,

connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester,

dataSourceName -> 1hge1457ym1lmn51tbi25r|100ab23, debugUnreturnedConnectionStack

Traces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, fact

oryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityTo

ken -> 1hge1457ym1lmn51tbi25r|100ab23, idleConnectionTestPeriod -> 3600, initial

PoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost/l2jdb, maxAdministrativeTaskTi

me -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -

> 0, maxPoolSize -> 50, maxStatements -> 0, maxStatementsPerConnection -> 100, m

inPoolSize -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -

> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, p

ropertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout ->

false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> fa

lse ]

==============================================================-[ Preparations ]

 

 

 

___      ___

/\_ \    /'___`\  __  /'___\

\//\ \  /\_\ /\ \ /\_\/\ \__/  _ __    __    __

  \ \ \ \/_/// /__\/\ \ \ ,__\/\`'__\/'__`\ /'__`\

  \_\ \_  // /_\ \\ \ \ \ \_/\ \ \//\  __//\  __/

  /\____\/\______/_\ \ \ \_\  \ \_\\ \____\ \____\

  \/____/\/_____//\ \_\ \/_/  \/_/ \/____/\/____/

                  \ \____/

                  \/___/  [starting Version: -1]

INFO Preparations: done

=====================================================================-[ World ]

INFO L2World: Setting up World Regions

INFO L2World: (191 by 271) World Region Grid set up.

INFO Telnet Server is currently disabled.

INFO MapRegionManager: Loaded 38 restartpoint(s).

INFO MapRegionManager: Loaded 23 restartareas with 145 arearegion(s).

INFO MapRegionManager: Loaded 235 zoneregion(s).

INFO MapRegionManager: Loaded 4 race depending redirects.

SEVERE Table 'l2jdb.character_friends' doesn't exist

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.characte

r_friends' doesn't exist

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

 

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

rce)

        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:1031)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)

        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)

        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)

        at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStat

ement.java:64)

        at com.l2jfree.gameserver.idfactory.IdFactory.cleanUpDB(IdFactory.java:1

87)

        at com.l2jfree.gameserver.idfactory.IdFactory.<init>(IdFactory.java:124)

 

        at com.l2jfree.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFacto

ry.java:65)

        at com.l2jfree.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:13

5)

        at com.l2jfree.gameserver.GameServer.<init>(GameServer.java:161)

        at com.l2jfree.gameserver.GameServer.main(GameServer.java:439)

 

INFO ThreadPoolManager v1: Initialized with 50 threads...

SEVERE BitSet ID Factory could not be initialized correctly

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.characte

rs' doesn't exist

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

 

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

 

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

rce)

        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:1031)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)

        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)

        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)

        at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStat

ement.java:64)

        at com.l2jfree.gameserver.idfactory.IdFactory.extractUsedObjectIDTable(I

dFactory.java:266)

        at com.l2jfree.gameserver.idfactory.BitSetIDFactory.initialize(BitSetIDF

actory.java:79)

        at com.l2jfree.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFacto

ry.java:67)

        at com.l2jfree.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:13

5)

        at com.l2jfree.gameserver.GameServer.<init>(GameServer.java:161)

        at com.l2jfree.gameserver.GameServer.main(GameServer.java:439)

 

INFO IDFactory: 102912 id's avaliable.

SEVERE Could not read object IDs from DB. Please Check Your Data.

Exception in thread "main" java.lang.Exception: Could not initialize the ID fact

ory

        at com.l2jfree.gameserver.GameServer.<init>(GameServer.java:164)

        at com.l2jfree.gameserver.GameServer.main(GameServer.java:439)

after that it just stops... how can i solve it?