Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 18:34

  • Please register to post and access all features, it's quick, easy and FREE!

 

[HOW-TO] Setup 9.1

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
[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 (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
  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 (Thanks Glandu2 )
  5. Open the Auth Emulator package
    • Example:
  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:
  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:
  9. Open the 9.1 package
    • Example:
  10. Open GameEngine, extract all contents [Except for Auth_Bin] to the previously created [server_bin] folder
  11. Download Pyroks Password Generator (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 auth database (place it also in the root of your Local Disk)
  16. Download my telecaster database (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:
  • In the prompt the pops up, select the 'From Device' radio button and press the browse [...] button
    • Example:
  • Press add and navigate to the root of your Local Disk [where you previously extract the contents of the dbs folder]
    • Example:
  • Restore Arcadia/Auth/Telecaster in this manner
  • UPDATE: Download the 9.1 Telecaster PaidItem (Billing) SMP fixes
  • UPDATE: Download the 9.1 Telecaster PaidItem (Billing) Table Insert Script (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:
  • 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:
  • Click the 'SQL Server Authentication' radio button
  • Uncheck 'Enforce Password Expiration'
    • Example:
    • 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:
  • 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:
  • 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:
  • 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:
  • 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:
  • IMPORTANT! Setting S:game.local_flag:4 must be set to your proper locale refer to the spoiler below
    • locale_codes:
  • 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:

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:
  • 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:
    • 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!



ismokedrow is offline  
Thanks
43 Users
Old   #2
 
elite*gold: 0
Join Date: Nov 2009
Posts: 303
Received Thanks: 30
Very nice, Wanna bet you still get questions? LOLOL


tokesbowls is offline  
Old   #3
 
elite*gold: 0
Join Date: Oct 2013
Posts: 382
Received Thanks: 25
thanks
Sherock is offline  
Old   #4
 
elite*gold: 0
Join Date: Jan 2012
Posts: 2
Received Thanks: 0
Thank you man get some time off work so i'm getting back in to rappelz


RavenLords is offline  
Old   #5
 
elite*gold: 0
Join Date: Aug 2011
Posts: 170
Received Thanks: 32
this thread i hope stop spam
Modamer9 is offline  
Old   #6
 
elite*gold: 0
Join Date: Oct 2013
Posts: 382
Received Thanks: 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?
Sherock is offline  
Old   #7
 
elite*gold: 0
Join Date: Jul 2014
Posts: 7
Received Thanks: 1
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
hocinemessi is offline  
Old   #8
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,002
Received Thanks: 957
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 is offline  
Old   #9
 
elite*gold: 0
Join Date: Feb 2015
Posts: 2
Received Thanks: 0
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
madesoki is offline  
Old   #10
 
elite*gold: 0
Join Date: Oct 2013
Posts: 382
Received Thanks: 25
Quote:
Originally Posted by thndr View Post
Sherock, do you see the link next to the red X stop symbol.

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


^
Sherock is offline  
Old   #11
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,002
Received Thanks: 957
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.
ThunderNikk is offline  
Old   #12
 
elite*gold: 0
Join Date: Aug 2011
Posts: 170
Received Thanks: 32
i have mssql 2012 and the server 9.1 work to me correct 100% ... u can shrink your db (telecaster) to fix size
Modamer9 is offline  
Old   #13
 
elite*gold: 0
Join Date: Feb 2015
Posts: 2
Received Thanks: 0
Quote:
Originally Posted by Sherock View Post


^
You must use SQL 2014 version not 2012
madesoki is offline  
Old   #14
 
elite*gold: 0
Join Date: Oct 2013
Posts: 382
Received Thanks: 25
any one have ULR or knows the size of this version ?
Sherock is offline  
Old   #15
 
elite*gold: 0
Join Date: Sep 2014
Posts: 50
Received Thanks: 0
Sherlock is you noob? we have marked several have taken 2014 as thou hast the 2012 ... so wake up & download 2014


medaion is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Microsoft .NET Framework 3.5 Setup - Setup Fehler
ich will netframe instahlieren wo er fertig ist kommt nurnoch das http://s14.directupload.net/images/130722/vedlkevr.png Kann wer helfen?
10 Replies - Technical Support
Microsoft .NET Framework 3.5 Setup - Setup Fehler
bitte close doppelpost
3 Replies - Technical Support
setup Net microsoft net Framework sp 3.5 sp1 log all setup Net microsoft net Framewo
setup Net microsoft net Framework sp 3.5 sp1 log all setup Net microsoft net Framework sp 3.5 sp1 log all some proplem this ): here ...........
0 Replies - Rappelz
What VirtualPC download is better? -32 BIT/setup.exe30.4MB 64 BIT/setup.exe30.5MB
32 BIT/setup.exe30.4MB Download 64 BIT/setup.exe30.5MB Download TELL ME !
1 Replies - Metin2 PServer - Discussions / Questions



All times are GMT +2. The time now is 18:34.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.