[HOW-TO] Setup 9.1

~~ismokedrow~~ · 03/30/2015, 00:15

Just because I know the other senior dev's have been pummeled and I find the setup process unbearably easy. I'm going to give you guys the 411.

FIRST and foremost, the following assumes that you have:

Installed Microsoft SQL Server 2014 (FULL) Evaluation [180 days] with the following settings
Default (NOT NAMED!) instance [VERY IMPORTANT]

Mixed Authentication Mode

TCP/IP Enabled (In SQL Configuration Manager under protocols) enabled
Caution: It is advised to not only firewall lock 1433 but if you MUST have external use to use a custom port and change it often couple with strict permission based database accounts.

Downloaded and extracted the (Thanks Team Revolution )

Downloaded and extracted the 9.1 Client for your region

Installed

Warnings:

If you do not meet the above requirements this guide does not apply to you, you should stop right now!

To make the server public:
Open the following ports in your Windows Firewall + any router based fire-wall that may be applicable! [Ports: 58422, 32214, 15574]

Change 'S:io.ip_address:127.0.0.1' setting in gameserver.opt to your external ip [you can find ]

Moving on...

For the sake of this guide we're gonna use a specific folder setup, failure to follow the below guide will result in 'NO SUPPORT FOR YOU' keep that in mind.

Step One

Create a new folder on your Desktop called: server_bin

Create folder called: Auth_Bin

Create a folder inside [Auth_Bin] called upload

Download the (Thanks Glandu2 )

Open the Auth Emulator package
Example:

Spoiler

Extract RappelzAuthServer.exe to the folder you created [Auth_Bin]
Create a new file in notepad++ and paste the following code into it, edit as needed and save as auth.opt in the 'Auth_Bin' folder
Code:
Spoiler
Code:
#Database configuration
auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:auth
auth.db.account:sa

auth.clients.maxpublicserveridx:10

#Server Index Offset Column Name
sql.db_account.column.serveridxoffset:server_list_mask

#include config in common.opt
%include:common.opt
Create a new file in notepad++ and paste the following code into it, edit as needed and save as common.opt in the 'Auth_Bin' folder
Code:
Spoiler
Code:
#Write trace log messages to file and show only info log messages on console
core.log.level:trace
core.log.consolelevel:info

#Enable traffic dump, will be in traffic_log folder (default off)
#trafficdump.enable:true

#The password is in plain text if you have one
auth.db.password:REPLACE.ME.WITH.YOUR.AUTH.DB.USER.PASSWORD.IN.PLAIN.TEXT
auth.db.salt:5dd23
#You can make auth.dbo.Accounts.[password] by visiting: 
# http://www.miraclesalad.com/webtools/md5.php (KEY+PASSWORD = hashed password)[No spaces between KEY and PASSWORD]
# Copy the resulting md5 into the password field of your account entry


#Where clients will connect (this is default values)
auth.clients.ip:0.0.0.0
auth.clients.port:58422
auth.clients.des_key:MERONG

#Where the gameserver will connect (this is default values)
auth.gameserver.ip:127.0.0.1
auth.gameserver.port:4502

#Upload configuration, use "upload" directory for guild icons
upload.dir=upload
upload.clients.ip=0.0.0.0
upload.clients.port=32214
#Use port 5000 for the guild icon mini webserver (the listen ip is also upload.clients.ip)
upload.clients.webport:5000

#Where the gameserver will connect (this is default values)
upload.gameserver.ip:127.0.0.1
upload.gameserver.port:4616

#Only for SQL Server: speed up selects with NOLOCK
sql.db_account.query:SELECT * FROM Accounts WITH(NOLOCK) WHERE login_name = ? AND password = ?;
Open the 9.1 package
Example:

Spoiler

Open GameEngine, extract all contents [Except for Auth_Bin] to the previously created [server_bin] folder

Download (for gameserver.opt) and extract it's contents to the [server_bin]/[game_bin] folder

Bring 9.1 package back to front

Back out of GameEngine and enter dbs folder

Extract arcadia ONLY (Billing/Telecaster are not needed) to the root of your Local Disk (e.g. C:\)

Download my (place it also in the root of your Local Disk)
Download my (place it also in the root of your Local Disk)

Minimize the 9.1 Package for now

Step Two

Open SSMS and right click 'Databases' then click 'Restore Database'
Example:

Spoiler

In the prompt the pops up, select the 'From Device' radio button and press the browse [...] button
Example:

Spoiler

Press add and navigate to the root of your Local Disk [where you previously extract the contents of the dbs folder]
Example:

Spoiler

Restore Arcadia/Auth/Telecaster in this manner

UPDATE: Download the
UPDATE: Download the (Thanks LadySeraph for heads up!)
Extract the .sql's to your Local Disk root and then double click them to open them in SSMS

Make sure they are targeting the Telecaster table

Execute and Billing is fixed

Collapse 'Databases' tree and double click 'Security' tree to expand it
Create a new file in notepad++ and copy the following template into it:
Template:
Spoiler
Code:
#Database Information:
-----------------------------------------------------
-----------------------------------------------------
-----------------------------------------------------
Auth ----------------------------------------------
-----------------------------------------------------
Table Name:
User Name:
User Password:
-----------------------------------------------------
-----------------------------------------------------
-----------------------------------------------------
Arcadia -------------------------------------------
-----------------------------------------------------
Table Name:
User Name:
User Password:
-----------------------------------------------------
-----------------------------------------------------
-----------------------------------------------------
Telecaster ----------------------------------------
-----------------------------------------------------
Table Name:
User Name:
User Password:
-----------------------------------------------------
-----------------------------------------------------
-----------------------------------------------------
Visit my favorite
Generate a unique key for each field of the file you just create (this will be a reference for you later)

Save this list wherever you will not lose it. Name it what you like, as long as you will remember
I cannot say at this time but the Game Server may reject mixed-case passwords. If you keep getting 'Login for '<login-name>' failed' you may want to try an ALL LOWER variation of your passwords

Right click 'Logins' and click 'New Login'
Example:

Spoiler

Click the 'SQL Server Authentication' radio button

Uncheck 'Enforce Password Expiration'
Example:

Spoiler

Using this form create the three logins from the file you created recently.

Step Three

With the 'Security > Logins' branch still expanded, right click the user you have created for Auth and double-click it

Click the 'Mappings' label to the left of the window
Example:

Spoiler

In the 'Users mapped to this Login:' section, check the 'auth' table

In the 'Database Role Membership:' section, check appropriate roles:
Auth Roles: db_reader/db_writer

Arcadia Roles: db_reader

Telecaster Roles: db_reader/db_writer

Do this for each name (we have already done auth, now do arcadia and telecaster using the above Roles)

Collapse the 'Security' branch and expand your Auth table (double-click)

Expand the 'Security' branch of your Auth Database

Expand the 'Schema' branch
Example:

Spoiler

Double click the 'db_reader' / 'db_writer' role (one by one) according to the accounts roles to open the Schema Settings

Click the 'Permissions' label to the left side of the window

Beside 'Users or Roles' click 'Search' button

In search prompt click 'Browse'

Check the name of your Auth account who you mapped previously
Example:

Spoiler

Press 'Ok' on the search prompt

Back inside the 'Permissions' section of the schema settings make sure your previously searched user is highlighted

In the 'Permissions for <name>' section check the appropriate permissions for the role and database being done
Auth db_reader permissions: Select

Auth db_writer permissions: Insert

Arcadia db_reader permissions: Select

Telecaster db_reader permissions: Select

Telecaster db_writer permissions: Insert/Update/Delete

Set the permissions for Arcadia, Telecaster in the same manner using the above permissions.

Collapse the branches back down so that you can see all three databases [auth, telecaster, arcadia]

For Auth/Telecaster ONLY Right click and click 'Properties'

For Auth/Telecaster ONLY Click the 'Permissions' label to the left of the window
Example:

Spoiler

Make sure that the access name for your table is listed in the 'Users or Roles:' section and make sure to click it to select it (if its not selected)

Scroll down and check 'Execute' and save/exit the window

Step Four

We are done with SSMS so you can close/minimize it for now.
Navigate to the [server_bin]/[game_bin] folder and open the gameserver.opt

Immediately replace it's entire contents with the following code:

Code:

Spoiler

Code:

S:app.name:REPLACE.ME.WITH.TITLEBAR.NAME
T:auth.server_idx:1
S:auth.server_name:MyVeryOwn91Server
S:db.c.server:127.0.0.1
S:db.c.name:arcadia
S:db.c.account:sa
S:db.c._password:REPLACE.ME.WITH.PYROK.TOOL.GENERATED.PASSWORD
S:db.user.server:127.0.0.1
S:db.user.name:telecaster
S:db.user.account:sa
S:db.user._password:REPLACE.ME.WITH.PYROK.TOOL.GENERATED.PASSWORD
N:io.port:15574
S:io.auth.ip:127.0.0.1
S:io.ip_address:127.0.0.1
S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:0
T:log.working:0
T:log.disable:1
S:game.mem_usage_info_save_interval:9999999
F:game.base_ethereal_durability_consumption_on_damage:.30
F:game.base_ethereal_durability_consumption_on_skill_attack:.40
F:game.base_ethereal_durability_consumption_on_normal_attack:.10
F:game.pvp_damage_rate_for_summon:.12
F:game.pvp_damage_rate_for_player:.08
S game.exp_rate:5
S game.item_drop_rate:1
S game.gold_drop_rate:2
S game.chaos_drop_rate:2
T game.apply_stamina_bonus_in_premium_pcb:0
F game.premium_pcbang_bonus_rate:.30
F game.premium_pcbang_chaos_bonus_rate:.30
F game.premium_pcbang_gold_bonus_drop_rate:.30
F game.premium_pcbang_item_bonus_drop_rate:.30
F game.premium_pcbang_chaos_bonus_drop_rate:.30
F game.ally_pcbang_bonus_rate:.30
S game.ally_pcbang_chaos_bonus_rate:.30
T:game.update.version:24
T:game.max_level:180
T:game.PKServer:0
T:game.AdultServer:0
T:game.cash_usable_server:1
S:game.local_flag:4
T:game.min_global_chat_usable_level:10
T:game.use_auto_trap:0
T:game.use_auto_jail:0
T:game.ServiceServer:0
N:console.port:44554
S:console.allow_ip:127.0.0.1
S:console._password:REPLACE.ME.WITH.PYROK.TOOL.GENERATED.PASSWORD
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:game.guild_icon_base_url:http://127.0.0.1/guild/
S:game.url_list:guild.url|http://127.0.0.1/login.aspx|guild_test_download.url|guild/|web_download|5.196.124.242|web_download_port|0|shop.url|http://shop.rappelz.co|ghelp_url|http://help.gamepower7.com/help/help-page/help-page.html|guild_icon_upload.ip|5.196.124.242|guild_icon_upload.port|4617

S:game.server_screenshot_url:http://rappelz.co/launcher/server.html
S:game.helpdesk_url:http://help.gamepower7.com/help/help-page/help-page.html
S:game.newbiehelp_asura_url:http://help.gamepower7.com/help/info_asura.html
S:game.newbiehelp_deva_url:http://help.gamepower7.com/help/info_deva.html
S:game.newbiehelp_gaia_url:http://help.gamepower7.com/help/info_gaia.html
S:game.local_setting_list:log.ip|log.chat.ip|io.auth.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
T:game.disable_trade:0
T:game.disable_booth:0
S:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:2500
T:db.user.thread:4

IMPORTANT! Setting S:game.local_flag:4 must be set to your proper locale refer to the spoiler below

locale_codes:

Spoiler

All instances of local_flag in the arcadia database will need to be set to your locale code or 0 to show in-game when launched in your specific local. For instance, ASCII/US will need S:game.local_flag:4 and any NPC/FieldProp/Dungeon I wanted to be available to me would need to have a local_flag of 0 or 4
Where in most cases local_flag 4 OR 0 is applicable it seems in NPCResource it must be 0 not 4 [CONFIRMED]
Edit the gameserver.opt as you needed and save, now compress it by dragging it ontop of the Rappelz Compressor which should be in the same folder
- For database details refer to the file you created earlier with the login information
- Example:
  
  Spoiler

If you have followed the above guide correctly you should now have a fully working server for you and/or your friends, so just enter the Auth_Bin folder and launcher the RappelzAuthServer executable. Back out of the Auth_Bin folder and enter the Game_bin folder and launch CaptainHerlockServer.exe.

You DO NOT have to type 'start_service' or 'set game.open_external'

The rest is pretty simple:

Final Steps

Bring the 9.1 Package back into focus and enter the 'Launcher' folder

Extract 'RappelzCmdLauncher.exe' into your 9.1 clients root folder

Create a new file in notepad++ and copy the following code into it:
Replace it's contents with the following:
Code:
Spoiler
Code:
RappelzCmdLauncher.exe sframe.exe /auth_ip:127.0.0.1 /auth_port:58422 /use_nprotect:0 /help_url_w:611 /help_url_h:625 /locale:ASCII /country:US /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631

<DO NOT COPY BELOW THIS LINE>
# Locales: ASCII = US / windows-1256 MOST EU Regions
# Country: US/EU/DE/KR etc..
# REMEMBER! With ASCII/US Locale and Country you must use S:game.local_flag_:4 and db local_flag = 4 or 0
# auth_port: Must match the port in your auth.opt file
Save the file as 'Start.Bat' with File Type: 'All' into your 9.1 client directory

Open/Bring SSMS back into focus

Double click your Auth table to expand it

Visit

Create the password for your Admin Account
Example:

Spoiler

The MD5 hash [result of md5_key+plain-text-password] goes in the 'password' field of the dbo.Accounts table in the Auth Database

Create the account entry in dbo.Accounts and login!

I wish you the best on getting your server setup and I'm going to be honest -- I may not have the time to answer any and every question that comes through this thread, so don't be offended if I miss your question. I hope other dev's in the community will help to answer your questions, this is just a tool to aid them!

If you have any suggestions to this guide feel free to post them (within reason)

GOOD LUCK!

tokesbowls · 03/30/2015, 00:24

Very nice, Wanna bet you still get questions? LOLOL

Sherock · 03/30/2015, 05:55

thanks

RavenLords · 03/30/2015, 08:46

Thank you man get some time off work so i'm getting back in to rappelz

Modamer9 · 03/30/2015, 09:53

this thread i hope stop spam

Sherock · 03/30/2015, 12:25

for Auth and common if I using them for local ip do i have to change any thing ?

and if have a host its true that i have to replace all 127.0.0.1 by host's ip ?

^ some help?

hocinemessi · 03/30/2015, 14:50

i know this thinks but waht about the RDB files or let me say how to export it ?? :/
is different from the old because it is not hashed (try edit some file 9.1 RDB with notepad ++ you will know )
sorry for the bad english

ThunderNikk · 03/30/2015, 15:47

Sherock, do you see the link next to the red X stop symbol.

Click on it and it will tell you what is wrong.

madesoki · 03/30/2015, 16:29

I can't see most of this topic images please re-upload them
+ Can i use SQL 2014 express instead of evaluation ??
+ thanks for full guide

Sherock · 03/30/2015, 17:02

Quote:

Originally Posted by thndr

Sherock, do you see the link next to the red X stop symbol.

Click on it and it will tell you what is wrong.

^

ThunderNikk · 03/30/2015, 18:26

Sherock you missed reading the first part of the guide that said you would need MSSQL 2014.

You are running 2012.

I am working on a clean 2012 Telecaster, should be done tonight sometime but for now you will either need to upgrade to MSSQL 2014 or use the 30 gigabyte Telecaster and an older Auth from previous server releases.

Modamer9 · 03/30/2015, 18:38

i have mssql 2012 and the server 9.1 work to me correct 100% ... u can shrink your db (telecaster) to fix size

madesoki · 03/30/2015, 18:54

Quote:

Originally Posted by Sherock

^

You must use SQL 2014 version not 2012

Sherock · 03/30/2015, 19:06

any one have ULR or knows the size of this version ?

medaion · 03/30/2015, 19:10

Sherlock is you noob? we have marked several have taken 2014 as thou hast the 2012 ... so wake up & download 2014