Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

L2O [Guide] How to build a Lineage 2 private server

Joined
Oct 5, 2006
Messages
4,293
Reaction score
103
Hello. In this tutorial I'll be explaining how to build a Lineage 2 private server. This applies to C4, C5 and Interlude "official" servers, afterall all the C5 and Interlude servers are mere C4 PTS servers with extenders, given the fact C5 and Interlude official files were never leaked.

That being said, let's begin.


1. The basics:

The first thing you have to understand is that Lineage 2 OFF servers consume a shitload of resources and if you are opening a serious server, it sure will cost you an average amount of money. So from own experience, I can suggest these pre-requisites for required and recommended specs:

Required:

Athlon 64 4200+ Processor
4GB RAM
200GB HDD
10mbit dedicated connection
Windows 2003 x64 Server OS

Recommended:

Dual Intel Xeon 2.8ghz
8GB or 16GB RAM
2x or 3x 200GB 10k+ RPM HDDs.
100mbit dedicated connection
Windows 2003 x64 Server OS

Make sure the operating system is a 64-bits system, since L2Server won't work in a 32-bits system.

With the "Required" specs you'll be able to get about 300 ~ 500 players with no lag. Anything above that will cause unwanted lag.
With the "Recommended" specs you'll be able to get about 1000 ~ 1500 players with 8GB RAM and with 16GB RAM it should take on 2000 ~ 3000 players without major problems.

2. Understanding the server:

Before I start explaining furthermore, first you'll need to understand how the server works.
Lineage 2 OFF servers database system is SQL. All kinds of information about characters, accounts etc. are stored in the SQL database. Therefore, you'll need MSSQL, which can be downloaded below.

There's something else you also need to know. Lineage 2 OFF servers basically consist of the following:

AuthD (Login Server)
CacheD (Acts like a bridge between L2Server.exe and SQL)
L2Server.exe (Game Server)
L2NPC.exe (Loads all NPCs in the Game Server)

Besides that, there are several folders with all several types of files.
The most important folders, that means... Those you will be dealing with all the time to edit items, NPCs, skills, terrain issues, quests and so on are the following:

Script
HTML
Geodata



3. Server files:

Alright, so you already got your server?

That's great. Now we need to get some files.

You'll need to download the following files:

1. Server Files
2. MSSQL server
[/URL] 3. CacheD Serial Generator



4.1. Configuring the Database:

1. Install MSSQL server to any folder of your choice. It's a very basic installation, you'll mainly just choose "Yes" all the time. When it asks you for what kind of installation, choose "Complete". This should avoid any problems in the future. When it asks for what user to choose, leave it as "sa" and choose whatever password you wish.

2. Once it's finished installing, go on start menu and look for the SQL Server Management Studio. Open it. It should prompt a connection window. If the connection name isn't "localhost", type it down there and click on "Connect"

3. Click on "New Query", then go to your PPC Release folder and look for a folder named DBScript. Open the file "0_create-db.sql" with notepad then copy and paste all content to the New Query window, right click and press "Execute Query". You can also simply click 0_create-db.sql twice and it'll automatically perform the query. After you've done that, all databases and tables should be created. (lin2world, lin2db etc.)

4. Close the New Query window. Look at the left side for "Databases". Open it, then go to lin2db > tables. Right click on dbo.server and choose "Open Table". Now you'll configure the server settings in this table.



ID: 1 (2, 3, 4 and so on for more servers)
Name: Pick a 11 characters (no more, no less) name.
IP: Insert the WAN IP here. (To get your WAN IP, )
inner_ip: Insert your localhost (127.0.0.1) IP here.
ageLimit: 0
pk_flag: 1
kind: 0
port: 7777
region: 0 (1, 2, 3 and so on for more servers)


4.2. Configuring the OBDC:


This should be piece of cake. You'll have to configure your OBDC in order for this to function correctly.
1. Go on Start > Administrative Tools > Data Sources (OBDC):

DaRkAnGeL - [Guide] How to build a Lineage 2 private server - RaGEZONE Forums



2. Go to "File DSN" tab and click on "Set Directory":


DaRkAnGeL - [Guide] How to build a Lineage 2 private server - RaGEZONE Forums



3. Write the adress that appears in this window somewhere for your own records and then press "Yes" to set that directory as default for OBDC file DSNs:
P.S: It usually is always the same: 'C:\Program Files\Common Files\OBDC\Data Sources'


DaRkAnGeL - [Guide] How to build a Lineage 2 private server - RaGEZONE Forums



4. Go to that place in your computer, and create two file DSNs:

lin2world.dsn
lin2db.dsn

After you do that, open the DSNs with notepad and insert this:


lin2world.dsn:
[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=lin2world
WSID=host_name
APP=Microsoft Data Access Components
Trusted_Connection=Yes
SERVER=host_name
lin2db.dsn:
[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=lin2db
WSID=host_name
APP=Microsoft Data Access Components
Trusted_Connection=Yes
SERVER=host_name
If you're going to use other tables such as l2comm and so on, simply make more DSN files with respective names and alter the DATABASE line.
As you can see in WSID and SERVER lines you'll have to replace host_name with your actual computer Host Name, which can be found by performing ipconfig /all.

5. Go back to Start > Administrative Tools > Data Sources (OBDC), then go to "File DSN" tab. The DSNs you've just created should be listed there. If they still do not list up, click on "Add", choose "SQL Server", browse the DSNs where they are located and press OK.

It should then look like this:

DaRkAnGeL - [Guide] How to build a Lineage 2 private server - RaGEZONE Forums


Congratulations, you've successfully configured your OBDC!
 
Last edited:
Joined
Oct 5, 2006
Messages
4,293
Reaction score
103
5. Building the Server:

Now that you understand how the server works, I'll be explaining this with a bit more technical terms. If you fail to understand any of this, feel free to
click here and read the section "Understanding the Server".

Let's get to work.


1. Unzip the PPC Release to any folder of your choice in your server.

2. Go to Start > Run, type cmd and press enter. A new prompt window will be showed. Type ipconfig /all and press enter.
You'll see a bunch of text like this:

C:\Documents and Settings\Administrator>ipconfig /all

Windows IP Configuration

Host Name . . . . . . . . . . . . : u8714
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Unknown
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : NVIDIA nForce Networking Controller #2
Physical Address. . . . . . . . . : 00-18-F3-DA-E8-21
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
IP Address. . . . . . . . . . . . : 89.163.145.74
Subnet Mask . . . . . . . . . . . : 255.255.240.0
Default Gateway . . . . . . . . . : 89.145.78.6
DHCP Server . . . . . . . . . . . : 211.205.230.16
DNS Servers . . . . . . . . . . . : 216.192.221.194
. . . . . . . . . . . . . . . . . . . . : 89.166.247.171
Lease Obtained. . . . . . . . . . : Montag, 4. Februar 2008 22:02:41
Lease Expires . . . . . . . . . . : Dienstag, 5. Februar 2008 00:02:41

This basically shows all kinds of information regarding your network you'll need to know. Keep this window open, it'll be useful for many things beyond this point.

3. Open the CacheD Serial Generator you've downloaded earlier. It should look like this:

Insert the Mac Adress and the Machine Name (Host name) you've found in ipconfig /all in that CacheD Generator and generate the serial number.
Once you've done that, open CacheD.exe. It'll open a box asking for you to insert the Serial Number in. Insert the generated serial number in there.

Close it and restart it. It should ask for three things:

Database: You'll type lin2world here. If it's already "linworld", change it to "lin2world".
Username: You'll type sa or whatever user you set to MSSQL here.
Password: You'll type the password you've chosen for your database here.


Once you've inserted that and pressed OK, it should start CacheD. Congratulations, you've successfully configured CacheD.


4. Go to the PPC release folder > AuthD. Open config.txt.

Make sure it looks like this:

serverPort = 2104
serverExPort = 2106
serverIntPort = 2108
worldport = 7777
DBConnectionNum=10
encrypt = true
numServerThread = 2
numServerExThread = 2
numServerIntThread = 2
logDirectory="c:\work\log"
;30206 : l2, 30310 : Sl
ProtocolVersion = 30810
;8:lineage2, 4 halo
GameID=8
DesApply=false
PacketSizeType = 3
useForbiddenIPList=true
ReadLocalServerList=false
OneTimeLogOut=true
CountryCode=2
DevConnectOuter=true
DevServerIP="insert_your_WAN_ip_here"
 
Upvote 0
Initiate Mage
Joined
Nov 18, 2006
Messages
29
Reaction score
0
i think with a AMD Athlon you can't do something, i think a Xeon dual core to start, and recomend a 2x(CPU) Xeon quad core, thx.
 
Upvote 0
Initiate Mage
Joined
Jun 1, 2008
Messages
1
Reaction score
0
i think with a AMD Athlon you can't do something, i think a Xeon dual core to start, and recomend a 2x(CPU) Xeon quad core, thx.
cpu doesn't matter in l2 server, only sql needs it but even if you have more than 1.5k players online the cpu usage won't go over 20-30%
 
Upvote 0
Initiate Mage
Joined
Apr 21, 2007
Messages
4
Reaction score
0
Sorry, but i am a noob in this......... What is PPC Release and where can I find it????????
 
Upvote 0
Initiate Mage
Joined
Apr 21, 2007
Messages
4
Reaction score
0
Thx man.... O.. and if u are using studio 2005 when u said the connection name do u mean server name??? If u do, I am getting an error, no idea why though!!!!!!

should i move/ copy and paste/ cut and paste the PPC Release folder i use for the MSSQL to the server?????

O... and where can i find a CacheD Serial Generator???????

and is MAC address same as ip address if so what should u type if u wana play in offline mode?????

Can someone plz answer me ASAP cuz I am sort of in a hurry...........
 
Last edited:
Upvote 0
Initiate Mage
Joined
Jul 3, 2007
Messages
12
Reaction score
0
i think with a AMD Athlon you can't do something, i think a Xeon dual core to start, and recomend a 2x(CPU) Xeon quad core, thx.

Totally wrong.

I've had 2000 players online on my server using an AMD Athlon 3700+.

Of course Dual CPU's are better but any 3Ghz processor works as a start.
 
Upvote 0
Initiate Mage
Joined
Nov 18, 2006
Messages
29
Reaction score
0
hahahaha u are jocking with me?!
AMD Athlon 3700+ dont exist man!
and you never will get this on athlon! you are mad?
 
Upvote 0
Initiate Mage
Joined
Apr 15, 2007
Messages
4
Reaction score
0
y have a proplem i instal the mssql 2000 x86 version but when go to the service manager no have local y have tis YO-49CT61JOAMJX the name of my pc

y have windows server 2003 standard edition r2 x64

motherbord ASUS DSAN-DX

16 gb ram

2 procesor Procesador Quad-Core Intel
 
Upvote 0
Initiate Mage
Joined
Sep 27, 2007
Messages
8
Reaction score
0
Hey guys i need your advice, shall i try to run l2off server on:
Intel Core 2 Quad Q6600, 2400 MHz
8GB of RAM
100 mbit dedicated connection
Windows 2003 x64 Server OS
Possible one pc? I have other Intel Pentium 4 but he is on same net "router"
 
Upvote 0
Initiate Mage
Joined
Sep 27, 2007
Messages
8
Reaction score
0
on one pc i can run all the server? and how much players can handle ?
ty no, l2j is killing me ;]
 
Last edited:
Upvote 0
Back
Top