-
Some DB error
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!
-
Re: Some DB error
I also had this problem check this.
Clic Here.
-
Re: Some DB error
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 :D
-
Re: Some DB error
men check here..
http://forum.ragezone.com/f460/setti...2005-a-503557/
u're problem is conexion to mssql...
