Some DB error

devn142 · Dec 5, 2008

I installed SQL & Centos on 2 different PCs.... and connect using Hamachi..... I used Chumpy Server pack V2.5
well i was able to login in-game but while creating a Char.. I am getting a DB error....

I m using a Router ...I also did the port forwarding .....

plz tell me wher I am wrong..I search the forum for this error but didn't got the solution....

Code:

[Fri Dec  5 2008 11:23:19.314347 3086563008]: open log file  '/var/log/cabal/DBAgent_01.log'
[Fri Dec  5 2008 11:23:19.315197 3086563008]: LOG LEVEL: 3
[Fri Dec  5 2008 11:23:19.315252 3086563008]: MemPoolUnitSizeClass(2): 24576Bytes
[Fri Dec  5 2008 11:23:19.318955 3086563008]: Start DBAgent_01 Server
[Fri Dec  5 2008 11:23:19.321195 3086563008]: UseEcryptText (Off)
[Fri Dec  5 2008 11:23:19.337270 3086560160]: CProcessLayer(0)::svc Start [3086560160]
[Fri Dec  5 2008 11:23:19.338172 3076070304]: CProcessLayer(0)::svc Start [3076070304]
[Fri Dec  5 2008 11:23:19.340038 3086563008]: try listening 38181 port
[Fri Dec  5 2008 11:23:19.341196 3065580448]: CProcessLayer(0)::svc Start [3065580448]
[Fri Dec  5 2008 11:23:19.341336 3055090592]: CProcessLayer(0)::svc Start [3055090592]
[Fri Dec  5 2008 11:23:19.342109 3044600736]: CProcessLayer(0)::svc Start [3044600736]
[Fri Dec  5 2008 11:23:19.948081 3086563008]: accept success 8(127.0.0.1:33081)
[Fri Dec  5 2008 11:23:19.951021 3086563008]: 1.open user 8 [A0BBF98] (127.0.0.1)
[Fri Dec  5 2008 11:23:20.542543 3086563008]: accept success 10(127.0.0.1:33083)
[Fri Dec  5 2008 11:23:20.542979 3086563008]: 2.open user 10 [A0CA6C0] (127.0.0.1)
[Fri Dec  5 2008 11:24:36.299277 3076070304]: Database Connect success!
[Fri Dec  5 2008 11:24:36.352311 3086560160]: Database Connect success!
[Fri Dec  5 2008 11:24:38.170222 3065580448]: Database Connect success!
[Fri Dec  5 2008 11:24:38.275209 3044600736]: Database Connect success!
[Fri Dec  5 2008 11:26:41.743192 3065580448]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 8)
[Fri Dec  5 2008 11:26:41.743401 3065580448]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]The OLE DB provider "MSDASQL" for linked server "GAMESERVER" does not contain the table ""account"."dbo"."cabal_newCharData_table"". The table either does not exist or the current user does not have permissions on that table.
[Fri Dec  5 2008 11:26:41.743441 3065580448]: [##ERROR##] DB ERROR(CODE)     : 7314
[Fri Dec  5 2008 11:26:41.744030 3065580448]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Fri Dec  5 2008 11:26:41.744065 3065580448]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Fri Dec  5 2008 11:26:41.744209 3065580448]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ?              , ?         , ?         , ?         )}
[Fri Dec  5 2008 11:26:41.807368 3065580448]: Database Connect success!
[Fri Dec  5 2008 11:32:20.606052 3055090592]: Database Connect success!
[Fri Dec  5 2008 11:35:14.479692 3044600736]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 8)
[Fri Dec  5 2008 11:35:14.479803 3044600736]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]The OLE DB provider "MSDASQL" for linked server "GAMESERVER" does not contain the table ""account"."dbo"."cabal_newCharData_table"". The table either does not exist or the current user does not have permissions on that table.
[Fri Dec  5 2008 11:35:14.480240 3044600736]: [##ERROR##] DB ERROR(CODE)     : 7314
[Fri Dec  5 2008 11:35:14.480276 3044600736]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Fri Dec  5 2008 11:35:14.480309 3044600736]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Fri Dec  5 2008 11:35:14.480342 3044600736]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ?              , ?         , ?         , ?         )}
[Fri Dec  5 2008 11:35:14.555620 3044600736]: Database Connect success!

jdla1990 · Dec 5, 2008

I also had this problem check this.

Clic Here.

BanHammer · Dec 5, 2008

Well, I'm pretty new on the Cabal community, but taking a look to your logs:

Code:

[Fri Dec  5 2008 11:26:41.743192 3065580448]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 8)
[Fri Dec  5 2008 11:26:41.743401 3065580448]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]The OLE DB provider "MSDASQL" for linked server "GAMESERVER" does not contain the table ""account"."dbo"."cabal_newCharData_table"". The table either does not exist or the current user does not have permissions on that table.
[Fri Dec  5 2008 11:26:41.743441 3065580448]: [##ERROR##] DB ERROR(CODE)     : 7314
[Fri Dec  5 2008 11:26:41.744030 3065580448]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Fri Dec  5 2008 11:26:41.744065 3065580448]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Fri Dec  5 2008 11:26:41.744209 3065580448]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ?              , ?         , ?         , ?         )}

Second line refers to a nonexistent Table, try to find it by yourself and check if there is any info, simply nulls or nothing at all.
Also go look for the cabal_sp_newchar Store Procedure, but anyway, if the first line failed, what you see below it is just chained errors.

That's my best guess, I also had the same problem