[HOW-TO] Setup 9.1

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 [Only registered and activated users can see links. Click Here To Register...] (Thanks Team Revolution ;) )
• Downloaded and extracted the 9.1 Client for your region
• Installed [Only registered and activated users can see links. Click Here To Register...]

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 [Only registered and activated users can see links. Click Here To Register...]]

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

1. Create a new folder on your Desktop called: server_bin
2. Create folder called: Auth_Bin
3. Create a folder inside [Auth_Bin] called upload
4. Download the [Only registered and activated users can see links. Click Here To Register...] (Thanks Glandu2 ;) )
5. Open the Auth Emulator package
   • Example:
      Spoiler

     [Only registered and activated users can see links. Click Here To Register...]
6. Extract RappelzAuthServer.exe to the folder you created [Auth_Bin]
7. 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

8. 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 = ?;

9. Open the 9.1 package
   • Example:
      Spoiler

     [Only registered and activated users can see links. Click Here To Register...]
10. Open GameEngine, extract all contents [Except for Auth_Bin] to the previously created [server_bin] folder
11. Download [Only registered and activated users can see links. Click Here To Register...](for gameserver.opt) and extract it's contents to the [server_bin]/[game_bin] folder
12. Bring 9.1 package back to front
13. Back out of GameEngine and enter dbs folder
14. Extract arcadia ONLY (Billing/Telecaster are not needed) to the root of your Local Disk (e.g. C:\)
15. Download my [Only registered and activated users can see links. Click Here To Register...] (place it also in the root of your Local Disk)
16. Download my [Only registered and activated users can see links. Click Here To Register...] (place it also in the root of your Local Disk)
17. Minimize the 9.1 Package for now

Step Two

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

    [Only registered and activated users can see links. Click Here To Register...]
• In the prompt the pops up, select the 'From Device' radio button and press the browse [...] button
  • Example:
     Spoiler

    [Only registered and activated users can see links. Click Here To Register...]
• Press add and navigate to the root of your Local Disk [where you previously extract the contents of the dbs folder]
  • Example:
     Spoiler

    [Only registered and activated users can see links. Click Here To Register...]
• Restore Arcadia/Auth/Telecaster in this manner
• UPDATE: Download the [Only registered and activated users can see links. Click Here To Register...]
• UPDATE: Download the [Only registered and activated users can see links. Click Here To Register...] (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 :D
• 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 [Only registered and activated users can see links. Click Here To Register...]
  • 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

    [Only registered and activated users can see links. Click Here To Register...]
• Click the 'SQL Server Authentication' radio button
• Uncheck 'Enforce Password Expiration'
  • Example:
     Spoiler

    [Only registered and activated users can see links. Click Here To Register...]
  • 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

    [Only registered and activated users can see links. Click Here To Register...]
• 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

    [Only registered and activated users can see links. Click Here To Register...]
• 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

    [Only registered and activated users can see links. Click Here To Register...]
• 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

    [Only registered and activated users can see links. Click Here To Register...]
• 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

    Code:

    --LOCAL_INFO_KOREA = 1
    --LOCAL_INFO_HONGKONG = 2
    --LOCAL_INFO_AMERICA = 4
    --LOCAL_INFO_GERMANY = 8
    --LOCAL_INFO_JAPAN = 16
    --LOCAL_INFO_TAIWAN = 32
    --LOCAL_INFO_CHINA = 64
    --LOCAL_INFO_FRANCE = 128
    --LOCAL_INFO_RUSSIA = 256
    --LOCAL_INFO_MALAYSIA = 512
    --LOCAL_INFO_SINGAPORE = 1024
    --LOCAL_INFO_VIETNAM = 2048
    --LOCAL_INFO_THAILAND = 4096 
    --LOCAL_INFO_MIDDLE_EAST = 8192
    --LOCAL_INFO_TURKEY = 16384
    --LOCAL_INFO_POLAND = 32768
    --LOCAL_INFO_ITALY = 65536

• 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

    [Only registered and activated users can see links. Click Here To Register...]

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 [Only registered and activated users can see links. Click Here To Register...]
• Create the password for your Admin Account
  • Example:
     Spoiler

    [Only registered and activated users can see links. Click Here To Register...]
  • 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!

Very nice, Wanna bet you still get questions? LOLOL

thanks

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

this thread i hope stop spam

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 ?

[Only registered and activated users can see links. Click Here To Register...]


^ some help?

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

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

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

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

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.

[Only registered and activated users can see links. Click Here To Register...]

^

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.

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

Quote:

Originally Posted by Sherock [Only registered and activated users can see links. Click Here To Register...] ^

You must use SQL 2014 version not 2012

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

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