Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Database connection error

Newbie Spellweaver
Joined
Nov 16, 2006
Messages
45
Reaction score
0
this is the error which i get :

Code:
[Fri Aug 15 2008 14:57:09.510986 3075799952]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Fri Aug 15 2008 14:57:09.511087 3075799952]: [##ERROR##] DB ERROR(CODE)     : 0
[Fri Aug 15 2008 14:57:09.511190 3075799952]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Fri Aug 15 2008 14:57:09.511236 3075799952]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Fri Aug 15 2008 14:57:09.511275 3075799952]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Fri Aug 15 2008 14:57:09.511315 3075799952]: [##ERROR##] Database Connect Fail (uid=signofdoom;pwd=*******;dsn=CabalGame24;APP=DBAgent_24)
[Fri Aug 15 2008 14:57:09.511356 3075799952]: [##ERROR##] check 'pDB' fail
[Fri Aug 15 2008 14:57:09.511394 3075799952]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Fri Aug 15 2008 14:57:09.511437 3075799952]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(78.111.71.224)     <== thats the centos ip

i think it means i use the fals uid or pwd, but i tired it again and again with different logins but nothing works.

please help me
 
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
Check DBAgent_24.ini and make sure the DSN in there are correct first. Now check odbc.ini has a [CabalGame24] section and that it has the right details too.

Also try it with your sa logon and password as it could be that your signofdoom user doesn't have access to the cabal databases.
 
Upvote 0
Newbie Spellweaver
Joined
Nov 16, 2006
Messages
45
Reaction score
0
this is in my DBAgent.ini:
Code:
[DBAgent]
ServerIdx=1
DBProcessTNum=5
DSN=CabalGame01

[DSN]
DBId=gdbac
DBPwd=gdbpasswd
DBAppName=DaemonName
this is in my odbc.ini:
Code:
[CabalGame24]
Driver      = FreeTDS
Address     = my mssql ip
Port        = 1433
Database    = GAMEDB
TDS_Version = 8.0

[CabalAccount]
Driver      = FreeTDS
Address     = my mssql ip
Port        = 1433
Database    = ACCOUNT
TDS_Version = 8.0

[CabalCash]
Driver      = FreeTDS
Address     = my mssql ip
Port        = 1433
Database    = CabalCash
TDS_Version = 8.0

if i change the database ip, i get anither error, so i think it find it but it cant connect
 
Upvote 0
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
No, check your DBAgent_24.ini because that one really isn't right.
 
Upvote 0
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
DBAgent.ini is a template file and isn't use by the server unless DBAgent_24.ini doesn't exist. The file you posted has a DSN of CabalGame01 but your odbc.ini doesn't have a CabalGame01 section it has Cabalgame24. The database username and password in DBAgent.ini is also a default one that gen_config.sh should eplace with the correct one when it copies it to DBAgent_24.ini.

Do you not have a DBAgent_24.ini? If not that is the problem so copy DBAgent to DBAgent_24 and edit those details at the bottom.
 
Upvote 0
Newbie Spellweaver
Joined
Nov 16, 2006
Messages
45
Reaction score
0
i posted you my DBAgent.ini so i think i have it.

i understand you as follow:

Code:
[DBAgent]
ServerIdx=1
DBProcessTNum=5
DSN=CabalGame01 < this must be CabalGame24

[DSN]
DBId=gdbac < this is my mssql id
DBPwd=gdbpasswd < this is my mssql pw
DBAppName=DaemonName

am i right?
 
Upvote 0
Back
Top