[Desperate as fuck] GlobalManager Problem, JUST COME IN!!!!

[iDarky]

Hello, im creating my server for the first time ever so excuse my low knowledge, i recently got an error with GlobalManager, it says:

PHP Code:

cannot occupy db session : update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 64 


PHP Code:

cannot occupy db session : select * from SK_SilkChange_BY_Web 


And also, non of the other files work: i mean the farm manager, Gateway server and stuff, they dont work if GlobalManager doesnt work i guess. Some info u need to know:

1)My server will run on hamachi
2)When im on SQL managment studio(not connected yet) the server name is HUSSEIN so this is what i should write in the ini files right ?
3) Those are my ini files:

SrGlobalService:

PHP Code:

[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=HUSSEIN\SQLEXPRESS Name;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=omglol;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697 


SrNodeType:

PHP Code:

[global]
count=1
[entry0]
id=335
operation_type=22
name=SRO Vietnam TestLocal
wip=5.86.31.19
nip=5.86.31.19
machine_manager_node_id=699 


SrShard:

PHP Code:

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=HUSSEIN\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=omglol;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=HUSSEIN\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=omglol;DATABASE=Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0 


Please note that my ID and PW are working on SQL server and also the IP is my hamachi's IP and its also the one which appeared in the cmd "IPConfig" it was iPv4. I would rly rly appreciate it if u help me.
Thanks.

P.S: for ppl whom are going to say: hamachi server? fail! noob, stop creating servers and stuff, my server will never go public, its only for me to have some fun as a GM and test some stuff xD

[✗EpicSoul✗]

try .\SQLEXPRESS

[iDarky]

Originally Posted by glialka

SERVER=HUSSEINSQLEXPRESS
try
SERVER=HUSSEIN/SQLEXPRESS
or
SERVER=127.0.0.1,1433
or
SERVER=LOCAL
or
SERVER=HUSSEIN

Originally Posted by ✗EpicSoul✗

try .\SQLEXPRESS

Non of these worked

[xXMagicalXx]

Tried HUSSEIN\SQLEXPRESS ?

[iDarky]

Originally Posted by xXMagicalXx

Tried HUSSEIN\SQLEXPRESS ?

Thats the one i had actually but it didnt work.

[pH33n1x<3]

try (local) or (local)\SQLEXPRESS

[iDarky]

Originally Posted by pH33n1x<3

try (local) or (local)\SQLEXPRESS

Without the brackets right?
Another thing, i think its related to the ODBC cuz i had an error and i couldnt install it but used registry files.

EDIT: It didnt work

[✗EpicSoul✗]

you need brackets !!

[iDarky]

Originally Posted by ✗EpicSoul✗

you need brackets !!

k, i'll try, can i have ur skype ?

[youngvegas]

I also have a question similar to this

You see where it says SRO Vietnam TestLocal

Will it mess up if you change that to the name of your sever?

like where it says that and sroland i changed it to the name of my sever

Originally Posted by iDarky

Hello, im creating my server for the first time ever so excuse my low knowledge, i recently got an error with GlobalManager, it says:

PHP Code:

cannot occupy db session : update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 64 


PHP Code:

cannot occupy db session : select * from SK_SilkChange_BY_Web 


And also, non of the other files work: i mean the farm manager, Gateway server and stuff, they dont work if GlobalManager doesnt work i guess. Some info u need to know:

1)My server will run on hamachi
2)When im on SQL managment studio(not connected yet) the server name is HUSSEIN so this is what i should write in the ini files right ?
3) Those are my ini files:

SrGlobalService:

PHP Code:

[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=HUSSEIN\SQLEXPRESS Name;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=omglol;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697 


SrNodeType:

PHP Code:

[global]
count=1
[entry0]
id=335
operation_type=22
name=SRO Vietnam TestLocal
wip=5.86.31.19
nip=5.86.31.19
machine_manager_node_id=699 


SrShard:

PHP Code:

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=HUSSEIN\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=omglol;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=HUSSEIN\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=omglol;DATABASE=Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0 


Please note that my ID and PW are working on SQL server and also the IP is my hamachi's IP and its also the one which appeared in the cmd "IPConfig" it was iPv4. I would rly rly appreciate it if u help me.
Thanks.

P.S: for ppl whom are going to say: hamachi server? fail! noob, stop creating servers and stuff, my server will never go public, its only for me to have some fun as a GM and test some stuff xD

GO to your Database Priviledge your Hamachi IP , and then Config all the ini files with SEVER= YOURPCNAME\SQLEXPRESS

Example: SEVER=JOHN-PC\SQLEXPRESS

[iDarky]

I found out something, in my DB, the Priviliged IP table, the first row is written that way:

5	86	31	19	188	138	101	188

and my hamachi IP is: 5.86.31.19

and i cant delete any number after 19, so maybe thats the error ?

[youngvegas]

Right click the table click edit all rows depending on your studio 200 or 2005 or 2008 r2 edit all rows and you can and wne u do it should look like
5 86 31 19 5 86 31 19

[iDarky]

a new error appears now "Cant connect to account DB"

Did what u all guys said, still having an error, thats why i asked about ur skypes so we can use teamviewer or something.

[youngvegas]

Thats the thing i'm having trouble too. I have LAN to my router i'm using this laptop for holding sever. But when i open SR_SHARD and SR_Gamesever last two sever files i get DB Connection Failed

[iDarky]

So, can anybody help us?

What i think is there is something wrong in the ODBC, may this be the error ? i mean the ODBC have something installed wrong so this error comes up in the GlobalManager ?