GlobalDBAgent ERROR

[Twiddle]

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)

 

[chumpywumpy]

Does the stored procedure cabal_sp_auth exist and does the account you are connecting to the db with have access to it?

 

[Twiddle]

chumpywumpy, i use your files and dbs

 

[chumpywumpy]

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.

 

[Twiddle]

i try use sa and cabal. error on all logins

 

[chumpywumpy]

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?

 

[Twiddle]

i use db from darkxl (acc, gdb) and now all work.
@chumpywumpy tnx for help.... u do great job