Register for your free account! | Forgot your password?

Go Back   elitepvpers > Silkroad Online > SRO PServer - Discussions / Questions > SRO PServer Guides & Releases
You last visited: Today at 08:05

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


[Guide] Custom certification errors , Privileged ip table / simple guide for newbies

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2008
Posts: 124
Received Thanks: 45
Exclamation [Guide] Custom certification errors , Privileged ip table / simple guide for newbies

This is not a full guide on how to make a server , it's just critical points that must be taken care of in order to start the server properly (for newbies , whom Im considered one of them till the moment)

1- Database initial size :
- In most of the tutorials , the default initial size of the db was "3 mb" , but when I was making a new database , my default value was "2 mb" , dun know even it's importance , but i thought it's better to make it just like the tutorials say (till I know why we should change it to 3mb)
* before : * after :
- Also you should go to (options tab) whilst restoring any database backup file (.bak) and select the option to "overwrite the existing database"

2- Hamashi ip \ static ip [Certification problems - CustomCertificationServer.bat closing suddenly \ showing error] :
- Most of the tutorials just skip this part and only mention that you should write down your ip , so most of people including me put their ipv4 which is usually 192.168.1.2 ~ 192.168.1.8 , and then they get the error during the certification process
So basically to solve this problem , you should either have a static ip (which is not an easy choice) or you use the free hamashi network
Then go to download hamashi through the normal way , install it normally , then you'll be able to get "YOUR REAL IP" that you are going to use in :
Code:
1- \CustomCertificationServer\bin\ini\srNodeType.ini
2- \server.cfg
3- \GameServer.exe [patch your ip through sr_patcher]
4- \AgentServer.exe [patch your ip through sr_patcher]
5- \MachineManager.exe [patch your ip through sr_patcher]
6- \smc\ServiceManager.cfg
7- \smc\smc_updater.cfg
8- \media.pk2 [patch it manually]
9- dbo._privilegedip
* To get your hamashi-ip , just do as the pic , and choose "Copy ipv4 address"

3- Privileged ip table :
In some DBs , you'll find that the privilegedip table is totally different from the tutorials , as it takes that look
and i didn't find any information about how to deal with that format of table , so i've worked out a solution through copying that table from any other clean account_db (attached below) , and here's the steps :
  1. Make a new database , and name it for ex : testdb
  2. Restore any normal account database (attached below)
  3. Head to your original db (usually SRO_VT_ACCOUNT) and delete the dbo._PrivilegedIp table
  4. Restart your mssql server
  5. Execute the following query - Change the XXXX to ur new db name (in our example it was "testdb") :
    Code:
    SELECT * INTO SRO_VT_ACCOUNT.dbo._PrivilegedIP from XXXX.dbo._PrivilegedIP
  6. Restart the mssql server once more , then restart the management studio , and voila

So here we go now , and just to remember , those tips are meant mainly to help newbies , so please no need for such brilliant replies like "useless" or "it's too easy"

press the Thanks button if i helped you out
Attached Files
File Type: rar SRO_VT_ACCOUNT (normal privilegedip table).rar (1.37 MB, 98 views)



danger9 is offline  
Thanks
4 Users
Old   #2
Chat Killer In Duty

 
elite*gold: 5
Join Date: May 2008
Posts: 15,428
Received Thanks: 5,892
#Approved


PortalDark is offline  
Old   #3
 
elite*gold: 0
Join Date: Jan 2010
Posts: 692
Received Thanks: 147
Nice tutorial and easy to understand
bxxb is offline  
Thanks
1 User
Old   #4
 
elite*gold: 0
Join Date: Feb 2008
Posts: 124
Received Thanks: 45
Quote:
Originally Posted by bxxb View Post
Nice tutorial and easy to understand
Thanks


danger9 is offline  
Old   #5
 
elite*gold: 480
Join Date: Jan 2012
Posts: 654
Received Thanks: 575
Quote:
Originally Posted by bxxb View Post
Nice tutorial and easy to understand
I agree, I already knew that ^^ but it will be useful for "newbies" =P ,thanks. =)
Justin1337* is offline  
Old   #6
 
elite*gold: 0
Join Date: Feb 2008
Posts: 124
Received Thanks: 45
Quote:
Originally Posted by Justin1337 View Post
I agree, I already knew that ^^ but it will be useful for "newbies" =P ,thanks. =)
Yea , that's my pleasure ^^
danger9 is offline  
Old   #7
 
elite*gold: 0
Join Date: Sep 2009
Posts: 3
Received Thanks: 0
i got a static ip but same thing.... look


ronia123 is offline  
Old   #8
 
elite*gold: 0
Join Date: Feb 2008
Posts: 124
Received Thanks: 45
Quote:
Originally Posted by ronia123 View Post
i got a static ip but same thing.... look

Ummm Im not quite sure where's the error ..
but anyway are you sure that you followed the guide correctly ?

give me your feedback
danger9 is offline  
Old   #9
 
elite*gold: 480
Join Date: Jan 2012
Posts: 654
Received Thanks: 575
Quote:
Originally Posted by danger9 View Post
Ummm Im not quite sure where's the error ..
I was going to ask the same thing. :P

Quote:
Originally Posted by ronia123 View Post
i got a static ip but same thing.... look


ya, we need some more info dude. =)
Justin1337* is offline  
Old   #10
 
elite*gold: 0
Join Date: Feb 2008
Posts: 17
Received Thanks: 0
Sorry but , where do i find a Sr_Patcher? :O
Thanks in advanced
esam01 is offline  
Old   #11
 
elite*gold: 480
Join Date: Jan 2012
Posts: 654
Received Thanks: 575
Quote:
Originally Posted by esam01 View Post
Sorry but , where do i find a Sr_Patcher? :O
Thanks in advanced
Here you go
Full credit to Chern0byl:

Edit: You must have .NET Framework 4.0 at least, to run this version.


Justin1337* is offline  
Reply

Tags
certification privileged



« Previous Thread | Next Thread »

Similar Threads
FB Guide.. For All Newbies!
Forced Blader Guide For Lvl 79 only.. Sword Skills: Fade Step - lvl 9 Dash - lvl 9 Force Assault - lvl 20 Force Slash ...
11 Replies - Cabal Guides & Templates
Wizards Guide.. For All Newbies!
Just Download the File.. Read and Enjoy.. If you Have Suggestions.. Do email me at. [email protected]
5 Replies - Cabal Guides & Templates
FA Guide.. For All Newbies!
Just Download the File.. Read and Enjoy.. If you Have Suggestions.. Do email me at. [email protected]
4 Replies - Cabal Guides & Templates
complete sro guide (newbies)
Table of Contents 1. Your Character A. Stats B. Weapons C. Armors D. Mods E. Status Effects F. Elements G. Skill Points & Experience
19 Replies - SRO Guides & Templates
Guide for all newbies in archlord.
Let's start: Weapons: Till level 20 you do not need stones, but the level of 20 must include elemental stone, but the class will depend on which...
7 Replies - Archlord



All times are GMT +2. The time now is 08:05.


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

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