Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 16:02

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

 

[HOW-TO] Setup 9.1

Reply
 
Old   #61
 
elite*gold: 0
Join Date: Apr 2012
Posts: 99
Received Thanks: 34
For sa user it is proprietary of databases not needed to set authority on the database just use the password you use to connect to sql management studio : non hache in common.opt and hashed on game.opt



nimoht is offline  
Old   #62
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,412
nimoht please don't come and circumvent my guide, I did make a warning that GS may reject mixed-case password. In which case just make password lower-case and hash as normal.

If you follow the guide step by step you should have no issue with setting up security properly and for those planning to put their server public you should DEFINITELY do the security steps!


ismokedrow is offline  
Old   #63
 
elite*gold: 0
Join Date: May 2012
Posts: 7
Received Thanks: 1
Thanks OP, I feel like I've followed your guide to the letter and nimoht and tommy have fixed my authserver, but I am still experiencing no luck with Herlock no matter what I do:


Any other suggestions? My MSSQL setup here:

As a reference, my gameserver.opt:
Tomminater is offline  
Old   #64
 
elite*gold: 0
Join Date: Oct 2008
Posts: 10
Received Thanks: 3
My next problem that I am stuck at is that when using the official (downloaded from webzen) client characters and NPC's are invisible. I've tried downloading different clients but have had no success. Any pointers would be awesome and appreciated.


Tommyboy555 is offline  
Old   #65
 
elite*gold: 0
Join Date: Apr 2012
Posts: 449
Received Thanks: 770
@ismokedrow (and others who want to use the upload server for guild icons)
In the common.opt file of the auth emu (Step One, 8.), can you replace
Code:
#Use port 5000 for the guild icon mini webserver (the listen ip is also upload.clients.ip)
upload.clients.webport:5000
by:
Code:
#Where the client will connect to download guild icons
upload.iconserver.ip=0.0.0.0
#Use port 5000 for the guild icon mini webserver
upload.iconserver.port:5000
The "upload.clients.webport" config was replaced by "upload.iconserver.port" in the v3 of the emu but i forgot to update that in the main thread. (it's updated now)
glandu2 is offline  
Old   #66
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,041
Received Thanks: 977
Tomminater How do you have different passwords for "sa"?

4556000003001fe39e431976c88c54e56 6d89b6771e7b76767676e05721067

4556000003001fe39e431976c88c54 e566d89b6771e7b76767676e05721067

I mean they are the same but what is putting the space in there and at different spots because because a space is a character.

Tommyboy555 Did you follow the local_flag instructions?
ThunderNikk is offline  
Thanks
1 User
Old   #67
 
elite*gold: 0
Join Date: Apr 2012
Posts: 99
Received Thanks: 34
Thank's Glandu2 , with this modif , it's working like a charm

Hy Ismokedrow , i'm know for the security .

I do not want around your method, which simply help TommyBoy555 already in trouble with the usual method .

Your guide is clear and explicit but SQL SERVER MANAGEMENT user configuration can be disturbing .

Your guide works very well if followed to the letter

ps: i'll say to Tomminater without spaces and delete # rows on game.opt of my example , also upload and screenshot rows need to be adapted at his config .
nimoht is offline  
Old   #68
 
elite*gold: 0
Join Date: May 2012
Posts: 7
Received Thanks: 1
Quote:
Originally Posted by thndr View Post
Tomminater How do you have different passwords for "sa"?

4556000003001fe39e431976c88c54e56 6d89b6771e7b76767676e05721067

4556000003001fe39e431976c88c54 e566d89b6771e7b76767676e05721067

I mean they are the same but what is putting the space in there and at different spots because because a space is a character.

Tommyboy555 Did you follow the local_flag instructions?
The passwords are actually the same, the forum just breaks up long strings like that. Any other possible sources of error?

I'm thinking it might be in the first part of step 3: "With the 'Security > Logins' branch still expanded, right click the user you have created for Auth and double-click it".
I created a new login "forTheguide200112" with the same password as 'sa' and used it to grant permissions for the 3 databases. Is this a problem?
Tomminater is offline  
Old   #69
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,041
Received Thanks: 977
Nulled for security reasons
ThunderNikk is offline  
Old   #70
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,412
Sounds like some people aren't following the mapping process that is laid out in the guide. You should never in good practice set a db_user as owner. This automatically gives that db_user FULL permissions for that database. (e.g. ALTER, EXECUTE, DELETE, INSERT, UPDATE and TRUNCATE)( You should def follow the mapping procedure.
ismokedrow is offline  
Old   #71
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,041
Received Thanks: 977
Oh sorry smoke, as my server isn't a public server I don't follow the new guide security suggestions.

I will stop trying to help then as to not mislead people in your updated security.
ThunderNikk is offline  
Old   #72
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,412
Well I just don't know how many of these people are gonna try to throw these servers live. I will update the guide to state you don't have to follow security guide for local but should always follow for public.
ismokedrow is offline  
Old   #73
 
elite*gold: 0
Join Date: May 2012
Posts: 7
Received Thanks: 1
Thanks for the warning smoke. Mine is going to be private for the most part so I'm not worried about security.

If creating the user forTheguide200112 isn't an issue, does the user get referenced anywhere? In gameserver.opt, S:db.user.account:sa and changing the account to forTheguide200112 does not get rid of the error.
Attached Files
File Type: txt Arcadia 2015-04-06 13-13-08.txt (18.8 KB, 78 views)
Tomminater is offline  
Thanks
1 User
Old   #74
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,041
Received Thanks: 977
Following smokes guide whatever user you map for the database and that users password is what you should put in the .opt files.

For auth it should be the auth user with the auths user password in plain text in the .opt

For game server it should be the game server users Arcadia and Telecaster with the game server user passwords hashed with the new tool from Pyrok.
ThunderNikk is offline  
Thanks
1 User
Old   #75
 
elite*gold: 0
Join Date: Oct 2008
Posts: 10
Received Thanks: 3
My local flag is set to "S:game.local_flag:4" in gameserver.opt (I'm in the US). I've deleted all # comments and taken out all spaces between lines in gameserver.opt. The NPC's in dbo.NPCResource with the local_flag of 0 should be visible (If I understand Smoke's directions correctly) but there aren't any NPC's inside of town or mobs outside of town that are visible. My .bat file contains the proper local info of "/locale:ASCII /country:US".

I do notice a few lines in the Herlock window to the effect of "Lua run string failed. mob......." but also several lines to the effect of "Total 1552 Instance Dungeon Monster Respawn info loaded..."

I apologize for being a nuisance. I do appreciate you guy's help.


Tommyboy555 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 16:02.


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

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