{Guide/Release} SQL Server configuration For vsro files & Patches options

[mertcoskun]

mashandra you sad '1433'...what is that do you explain how can ı connect second pc's gameserver with 1433? the virtual pc can not connect db

[MaShanDra]

Originally Posted by buriko_0007

@Dr.Abdelfattah

I have Only 1 problem with ITEM BUG ! How to FIX ?

Please Help Me Come Tw And Set DB Write/Read Permission

can you tell me how you fixed the login prblem?

Originally Posted by mertcoskun

mashandra you sad '1433'...what is that do you explain how can ı connect second pc's gameserver with 1433? the virtual pc can not connect db

it dont works with Vmware...

it means you need to connect to database with yourip,1433 from secon machine to db on main machine!!

look
the normal string in your cert looks like this
query=DRIVER={SQL Server};SERVER=\SQLEXPRESS;DSN=your dsn;UID=sa;PWD=xxxxx;DATABASE=yourdb

now you need to change this for 2 machine

query=DRIVER={SQL Server};SERVER=yourip,1433;DSN=yourdsnT;UID=sa;PWD =xxxxx;DATABASE=yourdb

try this in cert for secon machine because second machine is connecting to database with remote so the old string dont works

[omier44]

I did everything said in the first post, but i still get the "cannot occupy db session..." error messages in GlobalManager.

[MaShanDra]

Originally Posted by omier44

I did everything said in the first post, but i still get the "cannot occupy db session..." error messages in GlobalManager.

you using Vmware? or 2 real machines?

read my last post for new DB connection String from 2 Machine!

[mertcoskun]

Originally Posted by MaShanDra

can you tell me how you fixed the login prblem?




it dont works with Vmware...

it means you need to connect to database with yourip,1433 from secon machine to db on main machine!!

look
the normal string in your cert looks like this
query=DRIVER={SQL Server};SERVER=\SQLEXPRESS;DSN=your dsn;UID=sa;PWD=xxxxx;DATABASE=yourdb

now you need to change this for 2 machine

query=DRIVER={SQL Server};SERVER=yourip,1433;DSN=yourdsnT;UID=sa;PWD =xxxxx;DATABASE=yourdb

try this in cert for secon machine because second machine is connecting to database with remote so the old string dont works

thank you regards brouther!

[MaShanDra]

Originally Posted by mertcoskun

thank you regards brouther!

np bro =)

[Miki Maus]

Well i can basically approve this stuff works but there's one issue i can't get fixed:

CLIENT GETS STUCK AT LOADING SCREEN WHEN PORTING TO AREA ASSIGNED TO EITHER SERV1->SERV2 or vice-verse.

So if anyone has any solution for this i'd like to get some knownledge share

btw: when i turn off the client with task manager at stuck time and start client again login and i appear in the other town so i guess there's still something little missing..

[Tazdingo7]

Nice work abdel.

I can use for example virtualbox to create a VPS and then use it for a second machine without problems ? Obviously if i have for example 16gb Ram.

Thxs

[skeyline]

i got the same problem as Miki Maus said. FarmManager show up a warning after teleport to another gameserver.

[pezant]

Well I was able to get it to work on VMWare. I have 2 servers setup through VMWare and I didn't really run into any issues. The only thing that I was having issues with is not being able to login to any character that I previously created when I had 1 gameserver setup. It's not a big deal but I figured I'd see if anyone had any insight into this. This is the error I'm getting in the farmmanager.

unhandled msg received CFarmManagerMainProcess : IP:x.x.x.x NoDir:0x0209 (0xB001) (MsgType:2), 7 - 7
unhandled msg received CFarmManagerMainProcess : IP:x.x.x.x NoDir:0x0209 (0x34A5) (MsgType:2), 6 - 6
unhandled msg received CFarmManagerMainProcess : IP:x.x.x.x NoDir:0x0209 (0x3013) (MsgType:2), 2066 - 2066
unhandled msg received CFarmManagerMainProcess : IP:x.x.x.x NoDir:0x0209 (0x34A6) (MsgType:2), 6 - 6
unhandled msg received CFarmManagerMainProcess : IP:x.x.x.x NoDir:0x0209 (0x3020) (MsgType:2), 14 - 14

Thanks.

[ass35]

it is working for me, but for some reason i am getting c9 error after i fill in capatcha code.. anyone know a solution ?

[Dr.Abdelfattah]

Originally Posted by ass35

it is working for me, but for some reason i am getting c9 error after i fill in capatcha code.. anyone know a solution ?

in _PrivilegedIP try to put 2 rows of ips

first row 2 ips as u know
and secound one 2 ips too

[ass35]

this is what happends...



DEP is not disabled... do u think this couses the problem ?

[Dr.Abdelfattah]

maybe change ur client ip from 127.0.0.1 to ur ipv4 ip

----------------------------------
ah i find the real problem
u have just 1 ipv4 from ur router
and u write 192.168.1.100 ~ 192.168.1.110
so u must got dc if gateway give ip 192.168.1.101 or so to 110 cuz u have only 192.168.1.100
so u must right 192 168 1 100 192 168 1 100

[MaShanDra]

@ Dr Abdelfattah some problems with Gameserver 2 i f i run it he will not start correctly and and write cert problem in SMC



Associtaion Reputation Check faild too

i use patch 3.1 and tried 3.0 out

the secon gameserver wouldnt load regions but i set it in DB

dunno this problem

i hope you have a solution