[HELP] Session Server

07/12/2009 02:14 Hylkutje#1

Hi all... I'm having a problem when I try to start my server.
This is what happens:

I start-up my cast server, then I start up my log-in server, then I start up my messenger server and then I start up my session server...

Everything goes well untill I get to the session server. This is the whole log I get when the session server crashes:

Code:

[1084] CastServer Started
[2628] Japan GameChu Login module loading Fail...
[2628] <------------- Login Server Started ------------>
[2448] MsgServer Started
[1084] Provider::initialize()
[1084] Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()).]De SQL-server bestaat niet of de toegang tot de server is geweigerd.      *the server doesn't exist or you have no accesibility... Translated that part for you guys :)
[1084] [CRITICAL ERROR] SP_GUILD_SERVER_ID_SET SUCCESS
[3792] Session Server Ready
[2628] ------------------ Connect Session Server IP : [ 5.181.63.113 ] ------------------
[3792] Provider::initialize()
[3792] Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()).]De SQL-server bestaat niet of de toegang tot de server is geweigerd.      *the server doesn't exist or you have no accesibility... Translated that part for you guys :)
[3792] >> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
[3792] File: .\Config\Provider.cpp, Line: 79

I am using: mssql 2005 express edition with windows xp sp3
I have: 4 gb physical ram memory and a extra 4 gb of visual ram memory...

This is my config file of the session server:

Code:

DATABASE_ADDRESS	= 5.181.63.113,1433
DATABASE_DATABASE	= CHARACTER
DATABASE_ACCOUNT	= sa
DATABASE_PASSWORD	= blankeneger
SESSION_SERVER_ID	= 1100

LOG_PATH		= ..\LogFiles\
BILLING			= 0
NO_CHARGE_CODE	= NODATA

and yes that account and password is correct...
and yes the IP adress is also correct... :)

I hope there is someone who can help me out on this...
I'm trying to figure this out for more then 5 days now :)

07/12/2009 17:45 janvier123#2

[Only registered and activated users can see links. Click Here To Register...]

Quote:

[Only registered and activated users can see links. Click Here To Register...]

07/13/2009 00:38 Hylkutje#3

Quote:

Originally Posted by janvier123

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

@janvier123:

beleave me... I have SEARCHED before I have posted... and I haven't found more then you did :)

07/13/2009 01:43 darkmage9292#4

janvier123 stop say always same thing -.- you've to use search button before answer -.-

Hylkutje are you sure that

DATABASE_ACCOUNT = sa
DATABASE_PASSWORD = blankeneger

are correct?

have you changed it also in cast folder (config.ini) ? (not only in session folder)

p.s. srry for my bad english...i hope you've understood me :P

07/13/2009 02:56 Hylkutje#5

Quote:

Originally Posted by darkmage9292

janvier123 stop say always same thing -.- you've to use search button before answer -.-

Hylkutje are you sure that

DATABASE_ACCOUNT = sa
DATABASE_PASSWORD = blankeneger

are correct?

have you changed it also in cast folder (config.ini) ? (not only in session folder)

p.s. srry for my bad english...i hope you've understood me :P

yes I am 100% sure of that.... And yes I have changed that...

Here is the proof :):

Code:

;
CAST_PORT		= 7882
DATABASE_ADDRESS	= 5.181.63.113,1433
DATABASE_DATABASE	= CHARACTER
DATABASE_ACCOUNT	= sa
DATABASE_PASSWORD	= blankeneger
CAST_SERVER_ID		= 1101
LOG_PATH		= ..\LogFiles\

Someone else told me to get mssql 2000 with sp4...
So I did that but I still have the same error...

Also, can anyone tell me how the hell session server is supposed to connect to a database while it doesn't even know the name of the server :S?
I mean... I haven't seen anything where I should enter the name of a server for example: MSSQL$BELIAL2...
And what does hamachi have to do with connecting to that server... :S?
If someone can just tell me what is going on and how this is working instead of telling me what to do to make it work I would appreciate it :)
(and if you do have the answer to my problem ofcourse please let me know and I'll be more then happy to know :D)

07/13/2009 09:04 gedimazs#6

Quote:
Originally Posted by Hylkutje
yes I am 100% sure of that.... And yes I have changed that...

Here is the proof :):
Code:
;
CAST_PORT		= 7882
DATABASE_ADDRESS	= 5.181.63.113,1433
DATABASE_DATABASE	= CHARACTER
DATABASE_ACCOUNT	= sa
DATABASE_PASSWORD	= blankeneger
CAST_SERVER_ID		= 1101
LOG_PATH		= ..\LogFiles\
Someone else told me to get mssql 2000 with sp4...
So I did that but I still have the same error...

Also, can anyone tell me how the hell session server is supposed to connect to a database while it doesn't even know the name of the server :S?
I mean... I haven't seen anything where I should enter the name of a server for example: MSSQL$BELIAL2...
And what does hamachi have to do with connecting to that server... :S?
If someone can just tell me what is going on and how this is working instead of telling me what to do to make it work I would appreciate it :)
(and if you do have the answer to my problem ofcourse please let me know and I'll be more then happy to know :D)

Have you done SN with query analizer? That's why you get session crash everytime you are trying to start. And I suggest you to use MSSQL 2000 + SP4

07/13/2009 11:53 Hylkutje#7

Quote:

Originally Posted by gedimazs

Have you done SN with query analizer? That's why you get session crash everytime you are trying to start. And I suggest you to use MSSQL 2000 + SP4

yes I have used query analizer and as I said in my post above yours... I tryed installing mssql 2000 with sp4 but it also gave me the same error...

07/13/2009 12:18 Recaci#8

Try downloading a diffrent pserver and use the session server folder from it.
I have ran into a few cases where no matter what I did the session server would crash and I had to use a diffrent version in order or it to work. What I ended up doing was copying one from a diffrent one over to the one I was using and ran it that way and it ran fine after that.

07/13/2009 12:32 Hylkutje#9

Quote:

Originally Posted by Recaci

Try downloading a diffrent pserver and use the session server folder from it.
I have ran into a few cases where no matter what I did the session server would crash and I had to use a diffrent version in order or it to work. What I ended up doing was copying one from a diffrent one over to the one I was using and ran it that way and it ran fine after that.

ok thanks for the tip I'll try that a couple of times... I have tryed a lot of things so far but nothing seems to help so this might work :D

EDIT: DAMN>< still doesnt work :( maybe this has something to do with that it can't connect to my server because it doesn't know the name of my server? :S Or it could have something to do with the Provider.ccp (I searched for it in windows explorer and cant find anything!)

07/13/2009 20:42 Recaci#10

Ommm may try and make sure your port number is correct?
The server confiles do not need your server name, thats what your ip address is for.
Here is copy of my config.
;
CAST_PORT = 7882
DATABASE_ADDRESS = 127.0.0.1,1433
DATABASE_DATABASE = CHARACTER
DATABASE_ACCOUNT = sa
DATABASE_PASSWORD = 123456
CAST_SERVER_ID = 1101
LOG_PATH = ..\LogFiles\

The 127.0.0.1 is saying that I am hosting the sever on the same system as database.
The 127.0.0.1 is your ip address of your database.
GL

07/13/2009 20:51 AlishaTHEGREAT#11

1sec,
why are you telling everyone your db username and pass
RTFM

07/14/2009 09:39 gedimazs#12

Quote:

Originally Posted by AlishaTHEGREAT

1sec,
why are you telling everyone your db username and pass
RTFM

lol, i have noticed that too but did not say anything . But there is no problem he can change pass whenever he wants.

07/14/2009 13:15 Hylkutje#13

Quote:

Originally Posted by Recaci

Ommm may try and make sure your port number is correct?
The server confiles do not need your server name, thats what your ip address is for.
Here is copy of my config.
;
CAST_PORT = 7882
DATABASE_ADDRESS = 127.0.0.1,1433
DATABASE_DATABASE = CHARACTER
DATABASE_ACCOUNT = sa
DATABASE_PASSWORD = 123456
CAST_SERVER_ID = 1101
LOG_PATH = ..\LogFiles\

The 127.0.0.1 is saying that I am hosting the sever on the same system as database.
The 127.0.0.1 is your ip address of your database.
GL

ow lol, do you have to port forward these ports or not :P? eather ways I'll try what you did :)
but... is that really nessesary? because my cast server works properly... :) only my session doesn't... Do I also have to use 127.0.0.1 at session then? and all the other servers?
EDIT: nevermind my cast server doesn't work properly, just figured that out XD

Quote:

1sec,
why are you telling everyone your db username and pass
RTFM

maybe it isn't my real pass ^^....
You won't know untill you test it and then still... I'm only making this server for me and a few friends... Later on I will make it a bigger server for more people to play but passwords doesn't matter now :)

EDIT: hmmm doesnt seem to work to change them to 127.0.0.1 :S Is it always that IP? Or do I have to find out what my database IP is?