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!

GlobalDBAgent ERROR

Newbie Spellweaver
Joined
Aug 15, 2006
Messages
85
Reaction score
2
logs:
[Fri Sep 12 2008 03:19:05.195171 3086751440]: open log file '/var/log/cabal/GlobalDBAgent.log'
[Fri Sep 12 2008 03:19:05.196241 3086751440]: LOG LEVEL: 3
[Fri Sep 12 2008 03:19:05.196534 3086751440]: MemPoolUnitSizeClass(0): 14336Bytes
[Fri Sep 12 2008 03:19:05.201029 3086751440]: Start GlobalDBAgent Server
[Fri Sep 12 2008 03:19:05.204886 3086751440]: UseEcryptText (Off)
[Fri Sep 12 2008 03:19:05.209722 3086748560]: CProcessLayer(0)::svc Start [3086748560]
[Fri Sep 12 2008 03:19:05.210702 3076258704]: CProcessLayer(0)::svc Start [3076258704]
[Fri Sep 12 2008 03:19:05.211738 3065768848]: CProcessLayer(0)::svc Start [3065768848]
[Fri Sep 12 2008 03:19:05.212758 3055278992]: CProcessLayer(0)::svc Start [3055278992]
[Fri Sep 12 2008 03:19:05.213724 3044789136]: CProcessLayer(0)::svc Start [3044789136]
[Fri Sep 12 2008 03:19:05.214546 3034299280]: CProcessLayer(0)::svc Start [3034299280]
[Fri Sep 12 2008 03:19:05.215648 3023809424]: CProcessLayer(0)::svc Start [3023809424]
[Fri Sep 12 2008 03:19:05.216316 3013319568]: CProcessLayer(0)::svc Start [3013319568]
[Fri Sep 12 2008 03:19:05.217425 3086751440]: try listening 38180 port
[Fri Sep 12 2008 03:19:05.218734 3002829712]: CProcessLayer(0)::svc Start [3002829712]
[Fri Sep 12 2008 03:19:05.219471 2992339856]: CProcessLayer(0)::svc Start [2992339856]
[Fri Sep 12 2008 03:19:06.830476 3086751440]: accept success 8(192.168.0.107:2035)
[Fri Sep 12 2008 03:19:06.834703 3086751440]: 1.open user 8 [8E1D818] (192.168.0.107)
[Fri Sep 12 2008 03:19:57.636690 3086751440]: accept success 10(192.168.0.107:2046)
[Fri Sep 12 2008 03:19:57.691030 3086751440]: 2.open user 10 [8E2BF30] (192.168.0.107)
[Fri Sep 12 2008 03:25:55.764377 3002829712]: Database Connect success!
[Fri Sep 12 2008 03:25:55.904201 3002829712]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Fri Sep 12 2008 03:25:55.904419 3002829712]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Could not find stored procedure 'cabal_sp_auth'.
[Fri Sep 12 2008 03:25:55.904574 3002829712]: [##ERROR##] DB ERROR(CODE) : 2812
[Fri Sep 12 2008 03:25:55.904721 3002829712]: [##ERROR##] DB ERROR(VAR_INFO) :
[Fri Sep 12 2008 03:25:55.904862 3002829712]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Fri Sep 12 2008 03:25:55.905218 3002829712]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ? , ? , ? , ? )}
[Fri Sep 12 2008 03:25:56.141652 3002829712]: Database Connect success!
[Fri Sep 12 2008 03:25:56.146453 3002829712]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Fri Sep 12 2008 03:25:56.147040 3002829712]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(192.168.0.107)
 
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
Does the stored procedure cabal_sp_auth exist and does the account you are connecting to the db with have access to it?
 
Upvote 0
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
The sp definitely exists in my databases and there is a db connect success in there so it isn't being denied access to the server. That just leaves permissions to the SP itself. Try configuring the server to use your "sa" logon for MSSQL or check the permissions on your databases and stored procedures, or make sure the logon you are using has access to both the databases and SPs. The "sa" logon should have access to everything by default so i am assuming you are using a different logon for the centos machine.
 
Upvote 0
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
Then check cabal_sp_auth as that SP is the problem. I can't see your exact databases but i am using the same ones and it is working for me in both sql 2000 and 2005 so you are going to need to do some investigating work on why the procedure fails. What happens if you try executing it from the DB directly?
 
Upvote 0
Newbie Spellweaver
Joined
Aug 15, 2006
Messages
85
Reaction score
2
i use db from darkxl (acc, gdb) and now all work.
@chumpywumpy tnx for help.... u do great job
 
Upvote 0
Back
Top