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
[HOW-TO] Setup 9.1
04/06/2015 03:42
nimoht#61
04/06/2015 04:28
ismokedrow#62
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!
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!
04/06/2015 05:04
Tomminater#63
04/06/2015 06:29
Tommyboy555#64
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.
04/06/2015 12:48
glandu2#65
@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
by:
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)
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
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
04/06/2015 12:55
ThunderNikk#66
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?
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?
04/06/2015 13:18
nimoht#67
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 :confused: .
Your guide is clear and explicit but SQL SERVER MANAGEMENT user configuration can be disturbing :rtfm:.
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 .
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 :confused: .
Your guide is clear and explicit but SQL SERVER MANAGEMENT user configuration can be disturbing :rtfm:.
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 .
04/06/2015 17:25
Tomminater#68
The passwords are actually the same, the forum just breaks up long strings like that. Any other possible sources of error?Quote:
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?
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?
04/06/2015 18:21
ThunderNikk#69
Nulled for security reasons
04/06/2015 18:31
ismokedrow#70
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.
04/06/2015 18:41
ThunderNikk#71
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.
I will stop trying to help then as to not mislead people in your updated security.
04/06/2015 18:56
ismokedrow#72
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.
04/06/2015 19:20
Tomminater#73
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.
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.
04/06/2015 20:55
ThunderNikk#74
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.
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.
04/07/2015 03:06
Tommyboy555#75
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.
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.