[GUIDE] New Server Setup Guide +files

[aeigis]

INDEX​

.1. - Introduction
.1a. - Version Notes
.2. - Files and Links Needed
.3. - Recommended Setup
.3a. - Alternate Setup
.4. - Installing and configuring MSSQL 2008
.5. - Configuring server
.6. - Web Registration
.7. - Client Modification​

​

.1. Introduction
Hello, I have been messing with these files a little and would like to present my vanilla release and setup guide.

These files contain no mods and also were stripped of all unnecessary files. (making the download much smaller)

If you would like to upload mirrors please do so! The more the better for the community. If you are unable to access any of my links in your ISP region please let me know what sites work for you and I will work on another mirror for you.

~aeigis

.1a. Version Notes

1.0 - Completed setup guide to get server functional

To Do - Web Registration Guide (files already included in 1.0)
- Client Modification (Launcher Making etc...)


.2. Files and Links Needed

Lets start you out with getting the proper files needed before you begin setting up

You must be registered to see links

You must be registered to see links

You must be registered to see links

You must be registered to see links

Game Client

You must be registered to see links

You must be registered to see links

.3. Recommended Setup

If you are planning on playing with a few friends and plan on hosting the server on your own machine you should consider using a product like VMWARE to emulate a server without installing a ton of extra stuff on your own computer. I will not provide support or setup instruction for VMWARE considering there is more than enough support on their site. With the link I provided you will need to register (free) and download their software (also free). Obtain your own copy of which ever windows operating system you prefer. I state this as the preferred method because it is the most secure for you and your private information. After you have VMWARE installed continue to .4.

.3a. Alternate Setup

If you do not wish to use VMWARE or you are installing the server on a standalone server continue to .4.

.4. - Installing and configuring MSSQL 2008

I am borrowing a majority of the MSSQL 2008 Setup from sockie who has a guide posted in the sticky section. Why re-create the wheel - his guide is perfect.

Step 1:

Install Microsoft SQL 2008 R2

Click next all the way till Database Engine Configuration

Security Mode — select Mixed Mode Authentication
Username - sa
Password - whatever you want
Server Name - RAIDERZSQL

Step 2:

Extract Database and the server files.

Open up Microsoft SQL 2008 R2

You will be presented with this:

Follow the screenshot, password would be the one you input @ step 1.

Once your done, we can move on to creating the database.

Right click Database:

Select New database, database name would be: RZ_ACCOUNTDB
Do the same for RZ_GAMEDB and RZ_LOGDB

Now you got the databases setup, but you still need to restore them.

Restoring:

To database -> RZ_ACCOUNTDB
Select 'From device:' and select the RZ_ACCOUNTDB.BAK from where you had extracted it in the starting of step 2.
Tick RESTORE

After that, go the OPTIONS in the top left hand corner.

Tick: 'Overwrite the existing database'

Do this for RZ_GAMEDB and RZ_LOGDB also.

Now right click RZ_ACCOUNTDB and click Properties.
When the window pops up, click on options and match my settings
(you will need this so that web registration works)

Now we are done for the database.

Step 3:

Setting up ODBCAD

Go to start>run type odbcad32.exe

Click System DSN tab.

Click Add

Click SQL Server Native client 10.0 and click finish

Name: whatever you want
Description: whatever you want
Server: YOURCOMPUTERNAME\RAIDERZSQL (remember this you will need it later)

NOTE: You can find your computer name by right clicking computer in the start menu and clicking on properties.

Click next, tick SQL Server authentication

Login ID: sa
Password: whatever you input in step 1

Click next

Tick Change the default database to:

and select RZ_ACCOUNTDB and click your done.

.5. Configuring Server

Ok let's start by editing the config files
Open Up you AppServer folder and double click on Server.ini
I've done the liberty of adding in commented examples any line that has a ; infront is an example how how it should look when you are done.

Remember the blue text in the MSSQL setup section, the part I told you to remember? that is the text you put in the spots that say SERVER = "YOURSQLSERVER"

Your LAN IP you should be able to figure out. If you are even attempting this guide without that basic knowledge..... I recommend Google.

USERNAME = "sa"
PASSWORD = "password used in step 1 during MSSQL setup"

The same information is required in all server.ini files
However Gameserver2 has one additional string PUBLIC_IP
you can get this by going to

You must be registered to see links

If you would like to use a

You must be registered to see links

forward, you may also do so.

After the above steps are completed properly your server will run without error. I create shortcuts to the server .exes and place them all in one location (like my desktop)

.6. Web Registration Setup
COMING SOON
(needed files already included in this setup)


.7. Client Modification

You must be registered to see links

You must be registered to see links

(client already provided, change connect.ini)

 

[DriftCity]

Good job!
Nice File release, Nice tutorial.

Edit:
I've got an error, Could I get support?


Thanks.

 

[aeigis]

Good job!
Nice File release, Nice tutorial.

Edit:
I've got an error, Could I get support?



Thanks.

whats the error you are having?

 

[Hycker]

lvl25 still endgame or this rls based on PWE open beta client?

 

[DriftCity]

whats the error you are having?

Getting a Cannot load dbghelp.dll from the gameserver.exe
And then it crashes.

 

[Shuyalucard]

I have a problem with the launcher. I cannot launch it. When i double click on it, i have to wait aprox 30 Secs and i get error from windows telling that it has to close application.

 

[aeigis]

I have a problem with the launcher. I cannot launch it. When i double click on it, i have to wait aprox 30 Secs and i get error from windows telling that it has to close application.

Which launcher the client or a server end exe?

Getting a Cannot load dbghelp.dll from the gameserver.exe
And then it crashes.

I will post a new fix for that, thanks for the input

lvl25 still endgame or this rls based on PWE open beta client?

Same files that have been around, I'm just compiling everything in one guide and modifying the server configs so that there is less editing to be done on the end user side.

 

[Shuyalucard]

i have a problem on the client and on the server
for now i'll focus on server only. When i finished configuring all, i double click on appserver and it close as fast as i opened it.

here is the log:

11:04:53 - "C:\Users\Setsuna\Desktop\eTekServer\AppServer\AppServer.exe" 11:04:53 - Start application without service mode
11:04:53 - application_commandline : "C:\Users\Setsuna\Desktop\eTekServer\AppServer\AppServer.exe"
11:04:53 - Server Socket Opened. (Port = 7502)
[e] 11:04:53 - Init GameDB fail.
11:04:53 - Can't Connect To DBMS
[e] 11:04:53 - Failed! InitDB
[e] 11:04:53 - Server Init Failed: 1: DB에 연결할 수 없음
11:04:53 - Server Closed

my ini file:


; AppServer server.ini

[SERVER_INFO]
NAME = "AppServer"
SERVER_ID = 102
WORLD_ID = 1
ODBC = "SQL Client"
SOCKET_POOL_SIZE = 100

[CONFIG]
PORT = 7502

[MASTER_SERVER]
IP = "192.168.0.1"
;IP = "192.168.1.102"
PORT = 7500


[DB]
SERVER = "Alucard\RAIDERZSQL"
DATABASE = "RZ_GAMEDB"
USERNAME = "sa"
PASSWORD = "123321"

[LOGDB]
SERVER = "Alucard\RAIDERZSQL"
DATABASE = "RZ_LOGDB"
USERNAME = "sa"
PASSWORD = "123321"

[PATH]
SYSTEM = "system"

[LOG]
LOG_PATH = "log"
LOG_LEVEL = 0

MY sql acces is:

Server name: .\RAIDERZSQL
auth : sql server auth
login: sa
pass: 123321

Here is a screen of MSSQL 2008

You must be registered to see links

EDIt: PROBLEM SOLVED !!! has to replace SQL client to SQL server in server.ini.

but now i wish to know how to create a game account please if you can help me on that

 

[ladiladi85]

I get this error when I try to open GameServer2

 

[Jesemos]

I got my server working. When I try to launch the raiderz launcher it crashes after some seconds. I don't want to use xampp and the register files. I would like to get the client launcher working with the database.

 

[aeigis]

i have a problem on the client and on the server
for now i'll focus on server only. When i finished configuring all, i double click on appserver and it close as fast as i opened it.

here is the log:

11:04:53 - "C:\Users\Setsuna\Desktop\eTekServer\AppServer\AppServer.exe" 11:04:53 - Start application without service mode
11:04:53 - application_commandline : "C:\Users\Setsuna\Desktop\eTekServer\AppServer\AppServer.exe"
11:04:53 - Server Socket Opened. (Port = 7502)
[e] 11:04:53 - Init GameDB fail.
11:04:53 - Can't Connect To DBMS
[e] 11:04:53 - Failed! InitDB
[e] 11:04:53 - Server Init Failed: 1: DB에 연결할 수 없음
11:04:53 - Server Closed

my ini file:


; AppServer server.ini

[SERVER_INFO]
NAME = "AppServer"
SERVER_ID = 102
WORLD_ID = 1
ODBC = "SQL Client"
SOCKET_POOL_SIZE = 100

[CONFIG]
PORT = 7502

[MASTER_SERVER]
IP = "192.168.0.1"
;IP = "192.168.1.102"
PORT = 7500


[DB]
SERVER = "Alucard\RAIDERZSQL"
DATABASE = "RZ_GAMEDB"
USERNAME = "sa"
PASSWORD = "123321"

[LOGDB]
SERVER = "Alucard\RAIDERZSQL"
DATABASE = "RZ_LOGDB"
USERNAME = "sa"
PASSWORD = "123321"

[PATH]
SYSTEM = "system"

[LOG]
LOG_PATH = "log"
LOG_LEVEL = 0

MY sql acces is:

Server name: .\RAIDERZSQL
auth : sql server auth
login: sa
pass: 123321

Could you better explain what you changed here? What I am gathering is that you changed ODBC = "SQL Client" to ODBC = "SQL Server" - Am I correct?

I got my server working. When I try to launch the raiderz launcher it crashes after some seconds. I don't want to use xampp and the register files. I would like to get the client launcher working with the database.

I am not currently providing client support. I recommend making your own launcher - The one provided with my files is only a starting point. The C# launcher works just fine but it requires a web server to be up and running with a "patch" destination. If I get some time I will put up a client that connects to my host for temporary use.... But I highly recommend figuring out the C# launcher source on these forums. I will not have my launcher up forever.. and I could just drop a patch in that would redirect all of your players to my server :


I'm tied up with some busy stuff real life - I'm preparing to leave for Afghanistan for 5 months. I will however, have internet access where I am going but I will not have time for updates and troubleshooting.

 

[Jesemos]

There isn't gameserver1 in the server files.

 

[aeigis]

There isn't gameserver1 in the server files.

This is correct, it is not necessary - I edited the necessary files to run only one game server instance - if you would like to run two game servers copy and rename the gameserver2 folder - then edit the number of servers by un-commenting the necessary lines in serverlist.xml - located in masterserver/data and in your new server folder edit server.ini and change server id to 2

 

[RoonZilla]

Hello, Aeigis.
WOW, you have been a member for a while! :O
Anyway, I like this tutorial.
Has a lot of software that I have not yet had chance to 'give-it-a-shot' however, I will definitely have to give this a little of my time.
Great tutorial +1!

 

[aeigis]

Hello, Aeigis.
WOW, you have been a member for a while! :O
Anyway, I like this tutorial.
Has a lot of software that I have not yet had chance to 'give-it-a-shot' however, I will definitely have to give this a little of my time.
Great tutorial +1!

Glad you found this helpful, and yes I've been around for quite some time, I used to be heavily involved with the l2off stuff before l2j had its first stable database I did not do much here aside from meet and greets - spent most of my time as a server admin lol.

 

[Jesemos]

Aegis, are you familar with the korean language? I would like to have the gm commands translated in english, I have made screenshots of them.
I also can't find them in the xml files.

 

[aeigis]

Aegis, are you familar with the korean language? I would like to have the gm commands translated in english, I have made screenshots of them.
I also can't find them in the xml files.

I am not familiar sorry, I believe they are compiled in the EXE's...

Who ever coded this server - was def less than community college level educated. That's the best way I can explain the mass chaos and unorganized programming involved with these server files :blink:

 

[Crypticus]

Compiled in the EXEs? Bingo.

[COLOR="Blue"]void[/COLOR] [COLOR="Teal"]XConsoleCmds[/COLOR]::InitGMCmds()

...mass chaos and unorganized programming involved with these server files :blink:

Before we go any further... may I ask if you've even seen the source code itself yet? No? Okay
If your answer was actually "yes", my bad; but you're judging low-level code with a high-level perspective!

It's a feature, not a bug

 

[Jesemos]

Compiled in the EXEs? Bingo.

[COLOR="Blue"]void[/COLOR] [COLOR="Teal"]XConsoleCmds[/COLOR]::InitGMCmds()

Nice found, but what can we do with this? I would like to get the full list of gmcommands to translate.

 

[Crypticus]

Nice found, but what can we do with this?

Nothing. I'm merely confirming suspicions; it's in the exe, not the xml, nor the lua.
GM commands do not require translating.