Can't create character

I know this problem has been posted so many times and I did the search :)

"Cannot proceed the command due to unknown DB error" when creating new character

I tried the solution posted on http://forum.ragezone.com/3765659-post2.htmlI follow all the linked server setting but still get the same error. I tried :Linked server provider string WITHOUT username and pwd, WITH username and pwd, change "server" to localhost, Computer Name, IP, checked all on server option, security be made without using a security context, still get the same error.
On MS Knowledge Base article, I failed on the first step

Quote:

1. Log on to the computer by using the SQL Server start up account.

My SQL Server startup account is the default one (NTAuthority/Network Service) so I cannot logon using that username and pass.
I restored ACCOUNT database with 09/08/2008 copy - still fail
I delete everything on /var/log/cabal/ , restart the server, and see the new logs. All clean, no visible errors, but still can't create my char :((

Here is my log file

DBAgent_05.log

Quote:

[Tue Oct 7 2008 20:19:11.948328 3086726864]: open log file '/var/log/cabal/DBAgent_05.log'
[Tue Oct 7 2008 20:19:11.948495 3086726864]: LOG LEVEL: 3
[Tue Oct 7 2008 20:19:11.948541 3086726864]: MemPoolUnitSizeClass(2): 24576Bytes
[Tue Oct 7 2008 20:19:11.949720 3086726864]: Start DBAgent_05 Server
[Tue Oct 7 2008 20:19:11.950371 3086726864]: UseEcryptText (Off)
[Tue Oct 7 2008 20:19:11.950899 3086726864]: try listening 38181 port
[Tue Oct 7 2008 20:19:11.951277 3086723984]: CProcessLayer(0)::svc Start [3086723984]
[Tue Oct 7 2008 20:19:11.951423 3076234128]: CProcessLayer(0)::svc Start [3076234128]
[Tue Oct 7 2008 20:19:11.951507 3065744272]: CProcessLayer(0)::svc Start [3065744272]
[Tue Oct 7 2008 20:19:11.951587 3055254416]: CProcessLayer(0)::svc Start [3055254416]
[Tue Oct 7 2008 20:19:11.951671 3044764560]: CProcessLayer(0)::svc Start [3044764560]
[Tue Oct 7 2008 20:19:12.501470 3086726864]: accept success 8(127.0.0.1:45447)
[Tue Oct 7 2008 20:19:12.504658 3086726864]: 1.open user 8 [948DBB0] (127.0.0.1)
[Tue Oct 7 2008 20:19:13.045824 3086726864]: accept success 10(127.0.0.1:45449)
[Tue Oct 7 2008 20:19:13.046047 3086726864]: 2.open user 10 [949C2A8] (127.0.0.1)
[Tue Oct 7 2008 20:19:13.630446 3086726864]: accept success 11(127.0.0.1:45453)
[Tue Oct 7 2008 20:19:13.630622 3086726864]: 3.open user 11 [94A84E0] (127.0.0.1)
[Tue Oct 7 2008 20:19:22.026472 3086723984]: Database Connect success!
[Tue Oct 7 2008 20:19:22.061515 3076234128]: Database Connect success!
[Tue Oct 7 2008 20:19:22.080788 3065744272]: Database Connect success!
[Tue Oct 7 2008 20:19:22.092148 3086723984]: sock 11=> sendBuf is growed (size:32768). len(657), 16924, 131072
[Tue Oct 7 2008 20:19:45.949661 3076234128]: sock 10=> sendBuf is growed (size:32768). len(657), 17000, 131072
[Tue Oct 7 2008 20:19:46.955280 3055254416]: Database Connect success!

GlobalDBAgent.log

Quote:

[Tue Oct 7 2008 20:19:10.580486 3086493392]: open log file '/var/log/cabal/GlobalDBAgent.log'
[Tue Oct 7 2008 20:19:10.580663 3086493392]: LOG LEVEL: 3
[Tue Oct 7 2008 20:19:10.580708 3086493392]: MemPoolUnitSizeClass(0): 14336Bytes
[Tue Oct 7 2008 20:19:10.581874 3086493392]: Start GlobalDBAgent Server
[Tue Oct 7 2008 20:19:10.582531 3086493392]: UseEcryptText (Off)
[Tue Oct 7 2008 20:19:10.583148 3086490512]: CProcessLayer(0)::svc Start [3086490512]
[Tue Oct 7 2008 20:19:10.583303 3076000656]: CProcessLayer(0)::svc Start [3076000656]
[Tue Oct 7 2008 20:19:10.583398 3065510800]: CProcessLayer(0)::svc Start [3065510800]
[Tue Oct 7 2008 20:19:10.583478 3055020944]: CProcessLayer(0)::svc Start [3055020944]
[Tue Oct 7 2008 20:19:10.583574 3044531088]: CProcessLayer(0)::svc Start [3044531088]
[Tue Oct 7 2008 20:19:10.583926 3086493392]: try listening 38180 port
[Tue Oct 7 2008 20:19:10.584217 3034041232]: CProcessLayer(0)::svc Start [3034041232]
[Tue Oct 7 2008 20:19:10.584309 3023551376]: CProcessLayer(0)::svc Start [3023551376]
[Tue Oct 7 2008 20:19:10.584403 3013061520]: CProcessLayer(0)::svc Start [3013061520]
[Tue Oct 7 2008 20:19:10.584487 3002571664]: CProcessLayer(0)::svc Start [3002571664]
[Tue Oct 7 2008 20:19:10.584579 2992081808]: CProcessLayer(0)::svc Start [2992081808]
[Tue Oct 7 2008 20:19:11.208037 3086493392]: accept success 8(127.0.0.1:55736)
[Tue Oct 7 2008 20:19:11.208833 3086493392]: 1.open user 8 [92D13C8] (127.0.0.1)
[Tue Oct 7 2008 20:19:21.795156 3086493392]: accept success 10(127.0.0.1:55748)
[Tue Oct 7 2008 20:19:21.795508 3086493392]: 2.open user 10 [92DFAE8] (127.0.0.1)

LoginSvr01.log

Quote:

[Tue Oct 7 2008 20:19:14.891177 3086055920]: open log file '/var/log/cabal/LoginSvr_01.log'
[Tue Oct 7 2008 20:19:14.891347 3086055920]: LOG LEVEL: 3
[Tue Oct 7 2008 20:19:14.891392 3086055920]: MemPoolUnitSizeClass(0): 14336Bytes
[Tue Oct 7 2008 20:19:14.892588 3086055920]: Start LoginSvr_01 Server
[Tue Oct 7 2008 20:19:14.892665 3086055920]: SITE_CHN, GAMEGUARD_V25, APEX_V10
[Tue Oct 7 2008 20:19:14.892707 3086055920]: TestChannelGroupIdxStartPoint=50
[Tue Oct 7 2008 20:19:14.892788 3086055920]: affiliatedCorpIP=121.170.135.;
[Tue Oct 7 2008 20:19:14.892826 3086055920]: AdminIP=121.170.135.;
[Tue Oct 7 2008 20:19:14.892864 3086055920]: client_version=22
[Tue Oct 7 2008 20:19:14.892897 3086055920]: IgnoreClientVersion(1)
[Tue Oct 7 2008 20:19:14.892937 3086055920]: UseAntiOnlineGameAddictionSystem(1)
[Tue Oct 7 2008 20:19:14.892971 3086055920]: AdultAge(18)
[Tue Oct 7 2008 20:19:14.893005 3086055920]: DefaultAgeAdult(1)
[Tue Oct 7 2008 20:19:14.893038 3086055920]: UsePSS(0)
[Tue Oct 7 2008 20:19:14.893070 3086055920]: CachedPSS(0)
[Tue Oct 7 2008 20:19:14.893102 3086055920]: PssCacheDurationMin(1440)
[Tue Oct 7 2008 20:19:14.893136 3086055920]: CutIfPssUserNotFound(0)
[Tue Oct 7 2008 20:19:14.893169 3086055920]: PssLogLevel(0)
[Tue Oct 7 2008 20:19:14.893201 3086055920]: InstantPlayTimeClearIntervalMin(300)
[Tue Oct 7 2008 20:19:14.893235 3086055920]: IDC(1)
[Tue Oct 7 2008 20:19:14.893268 3086055920]: SharedPssPersonId(0)
[Tue Oct 7 2008 20:19:14.893302 3086055920]: NormalClientMagicKey(1168110)
[Tue Oct 7 2008 20:19:14.893336 3086055920]: UseImageAuth(0)
[Tue Oct 7 2008 20:19:14.893370 3086055920]: ImageAuthDataPath(./ImageAuth/)
[Tue Oct 7 2008 20:19:14.893403 3086055920]: ImageAuthMaxTryCount(5)
[Tue Oct 7 2008 20:19:14.893435 3086055920]: ImageAuthWaitTime(120000)
[Tue Oct 7 2008 20:19:14.893469 3086055920]: BlockIfImageAuthFail(0)
[Tue Oct 7 2008 20:19:14.893502 3086055920]: UseServerListManualOrder(0)
[Tue Oct 7 2008 20:19:14.893531 3086055920]: 00:00 => 0
[Tue Oct 7 2008 20:19:14.893572 3086055920]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0
[Tue Oct 7 2008 20:19:14.893603 3086055920]: ImageAuthDataMgr Init Begin
[Tue Oct 7 2008 20:19:21.790785 3086055920]: ImageAuthDataMgr Init End(Count:1995)
[Tue Oct 7 2008 20:19:21.792227 3086055920]: try connect 127.0.0.1:38170, Sync
[Tue Oct 7 2008 20:19:21.793397 3086055920]: sock 7 ->LinkHandler Open
[Tue Oct 7 2008 20:19:21.793497 3086055920]: SendIPSConnect2Svr (195:128:01:00)
[Tue Oct 7 2008 20:19:21.793617 3086055920]: try connect 127.0.0.1:38180, Sync
[Tue Oct 7 2008 20:19:21.793824 3086055920]: sock 9 ->LinkHandler Open
[Tue Oct 7 2008 20:19:21.793883 3086055920]: SendIPSConnect2Svr (195:128:01:00)
[Tue Oct 7 2008 20:19:21.793968 3086055920]: try listening 38101 port
[Tue Oct 7 2008 20:19:21.795978 3077753744]: CProcessLayer(0)::svc Start [3077753744]
[Tue Oct 7 2008 20:19:21.796134 3077753744]: ServerState changed(0 -> 0)

GlobalMgrServer.log

Quote:

[Tue Oct 7 2008 20:19:11.031089 3086567136]: open log file '/var/log/cabal/GlobalMgrSvr.log'
[Tue Oct 7 2008 20:19:11.031276 3086567136]: LOG LEVEL: 3
[Tue Oct 7 2008 20:19:11.031324 3086567136]: MemPoolUnitSizeClass(0): 14336Bytes
[Tue Oct 7 2008 20:19:11.032476 3086567136]: Start GlobalMgrSvr Server
[Tue Oct 7 2008 20:19:11.032846 3086567136]: LoadServerAndChannelType(1)
[Tue Oct 7 2008 20:19:11.032916 3086567136]: channelType[1][1]: 0
[Tue Oct 7 2008 20:19:11.032954 3086567136]: maxUserName[1][1]: 100
[Tue Oct 7 2008 20:19:11.034616 3086567136]: channelType[2][1]: 1
[Tue Oct 7 2008 20:19:11.034654 3086567136]: maxUserName[2][1]: 100
[Tue Oct 7 2008 20:19:11.036607 3086567136]: channelType[3][1]: 8
[Tue Oct 7 2008 20:19:11.036657 3086567136]: maxUserName[3][1]: 100
[Tue Oct 7 2008 20:19:11.038604 3086567136]: channelType[4][10]: 16908368
[Tue Oct 7 2008 20:19:11.038651 3086567136]: maxUserName[4][10]: 100
[Tue Oct 7 2008 20:19:11.040129 3086567136]: channelType[5][1]: 0
[Tue Oct 7 2008 20:19:11.040166 3086567136]: maxUserName[5][1]: 100
[Tue Oct 7 2008 20:19:11.040236 3086567136]: maxUserName[5][4]: 100
[Tue Oct 7 2008 20:19:11.040343 3086567136]: channelType[5][10]: 16908368
[Tue Oct 7 2008 20:19:11.041850 3086567136]: channelType[6][1]: 0
[Tue Oct 7 2008 20:19:11.041888 3086567136]: maxUserName[6][1]: 100
[Tue Oct 7 2008 20:19:11.041956 3086567136]: channelType[6][4]: 8
[Tue Oct 7 2008 20:19:11.041993 3086567136]: maxUserName[6][4]: 100
[Tue Oct 7 2008 20:19:11.042097 3086567136]: channelType[6][10]: 16908368
[Tue Oct 7 2008 20:19:11.042133 3086567136]: maxUserName[6][10]: 100
[Tue Oct 7 2008 20:19:11.043722 3086567136]: channelType[7][1]: 1
[Tue Oct 7 2008 20:19:11.043760 3086567136]: maxUserName[7][1]: 100
[Tue Oct 7 2008 20:19:11.043827 3086567136]: channelType[7][4]: 8
[Tue Oct 7 2008 20:19:11.043864 3086567136]: maxUserName[7][4]: 100
[Tue Oct 7 2008 20:19:11.043968 3086567136]: channelType[7][10]: 16908368
[Tue Oct 7 2008 20:19:11.044004 3086567136]: maxUserName[7][10]: 100
[Tue Oct 7 2008 20:19:11.045577 3086567136]: channelType[8][1]: 1
[Tue Oct 7 2008 20:19:11.045614 3086567136]: maxUserName[8][1]: 100
[Tue Oct 7 2008 20:19:11.045683 3086567136]: channelType[8][4]: 4
[Tue Oct 7 2008 20:19:11.045719 3086567136]: maxUserName[8][4]: 100
[Tue Oct 7 2008 20:19:11.045761 3086567136]: channelType[8][5]: 12
[Tue Oct 7 2008 20:19:11.045797 3086567136]: maxUserName[8][5]: 100
[Tue Oct 7 2008 20:19:11.045888 3086567136]: channelType[8][10]: 16908368
[Tue Oct 7 2008 20:19:11.045924 3086567136]: maxUserName[8][10]: 100
[Tue Oct 7 2008 20:19:11.047471 3086567136]: channelType[9][1]: 1
[Tue Oct 7 2008 20:19:11.047508 3086567136]: maxUserName[9][1]: 100
[Tue Oct 7 2008 20:19:11.047551 3086567136]: channelType[9][2]: 4
[Tue Oct 7 2008 20:19:11.047586 3086567136]: maxUserName[9][2]: 100
[Tue Oct 7 2008 20:19:11.047640 3086567136]: channelType[9][4]: 8
[Tue Oct 7 2008 20:19:11.047676 3086567136]: maxUserName[9][4]: 100
[Tue Oct 7 2008 20:19:11.047781 3086567136]: channelType[9][10]: 16908368
[Tue Oct 7 2008 20:19:11.047817 3086567136]: maxUserName[9][10]: 100
[Tue Oct 7 2008 20:19:11.049375 3086567136]: channelType[10][1]: 0
[Tue Oct 7 2008 20:19:11.049416 3086567136]: maxUserName[10][1]: 100
[Tue Oct 7 2008 20:19:11.049459 3086567136]: channelType[10][2]: 4
[Tue Oct 7 2008 20:19:11.049495 3086567136]: maxUserName[10][2]: 100
[Tue Oct 7 2008 20:19:11.049549 3086567136]: channelType[10][4]: 5
[Tue Oct 7 2008 20:19:11.049585 3086567136]: maxUserName[10][4]: 100
[Tue Oct 7 2008 20:19:11.049626 3086567136]: channelType[10][5]: 12
[Tue Oct 7 2008 20:19:11.049662 3086567136]: maxUserName[10][5]: 100
[Tue Oct 7 2008 20:19:11.049754 3086567136]: channelType[10][10]: 16908368
[Tue Oct 7 2008 20:19:11.049790 3086567136]: maxUserName[10][10]: 100
[Tue Oct 7 2008 20:19:11.068948 3086567136]: channelType[24][1]: 1
[Tue Oct 7 2008 20:19:11.068989 3086567136]: maxUserName[24][1]: 100
[Tue Oct 7 2008 20:19:11.207535 3086567136]: try connect 127.0.0.1:38180, Sync
[Tue Oct 7 2008 20:19:11.209575 3086567136]: sock 7 ->LinkHandler Open
[Tue Oct 7 2008 20:19:11.209716 3086567136]: SendIPSConnect2Svr (246:128:00:00)
[Tue Oct 7 2008 20:19:11.209803 3086567136]: try listening 38170 port
[Tue Oct 7 2008 20:19:11.211042 3086097296]: CProcessLayer(0)::svc Start [3086097296]
[Tue Oct 7 2008 20:19:12.499931 3086567136]: accept success 10(127.0.0.1:55965)
[Tue Oct 7 2008 20:19:12.500264 3086567136]: 1.open user 10 [8A52FE8] (127.0.0.1)
[Tue Oct 7 2008 20:19:12.502880 3086097296]: new chatnode session (05:01)
[Tue Oct 7 2008 20:19:12.506009 3086097296]: new chat server session (250:05:01)
[Tue Oct 7 2008 20:19:13.044533 3086567136]: accept success 11(127.0.0.1:55967)
[Tue Oct 7 2008 20:19:13.044743 3086567136]: 2.open user 11 [8A59748] (127.0.0.1)
[Tue Oct 7 2008 20:19:13.629189 3086567136]: accept success 12(127.0.0.1:55971)
[Tue Oct 7 2008 20:19:13.629358 3086567136]: 3.open user 12 [8A5F9C8] (127.0.0.1)
[Tue Oct 7 2008 20:19:13.633931 3086097296]: new server session (05:10)
[Tue Oct 7 2008 20:19:21.792595 3086567136]: accept success 13(127.0.0.1:55975)
[Tue Oct 7 2008 20:19:21.792796 3086567136]: 4.open user 13 [8A65C58] (127.0.0.1)
[Tue Oct 7 2008 20:19:21.794372 3086097296]: new server session (128:01)
[Tue Oct 7 2008 20:19:22.017427 3086097296]: ChannelType(5,10): WarMapId(1), Type(80)
[Tue Oct 7 2008 20:19:22.017499 3086097296]: ChannelType(5,10): WarMapId(1), Type(80)
[Tue Oct 7 2008 20:19:43.363350 3086097296]: new server session (05:01)

Any other solution?

Re: Can't create character

The server itself is starting up ok but it does sound very much like a linked server problem. As you have tried localhost, ip and computer name in there that can't be the problem.

Can you try creating a new char and see what error ends up in the logs as that bit is missing (great info otherwise though!).

Also, are you using MSSQL 2000 or 2005?

Re: Can't create character

I finally solved the problem. The logs SEEMS ok because I took it before making connection from the game client. I took it right after service cabal start :)
The result after I connect with my game client showed some errors.
I am using MS SQL 2005, and it is a permission problem.
The quick solution I did: re-run cabal config script, use sa username and pwd, and on DB server delete the cabal login/pwd previously created, and takeover DB ownership to sa login.
It is now working fine :)
note: this is not the best solution for ppl who wants to run their private server on the internet, I am using sa login because my server is for playing around only.

Re: Can't create character

can you please explain clearly how you fix this problem?

anyway thanks for the hints

Re: Can't create character

Quote:

Originally Posted by an2ny_18

can you please explain clearly how you fix this problem?

anyway thanks for the hints

Basically he/she re-ran cabal_config.sh (this is only in my files, not darkxl's) and when asked about the MSSQL database details used the server "sa" logon instead of "cabal". The sa logon is the admin logon and has full access and ownership of everything by default so it is an easy way to eliminate permissions problems. Granting ownership probably wasn't necessary but then it never hurts to be thorough.

Re: Can't create character

yes, but the thing is, when I create the cabal userid and take ownership on account, managerdb, event, etc.. there is one table that cannot be changed (still belong to sa)

Account -> cabaluserid
cabal_managerdb ->cabaluserid
Cabal_stat ->cabaluserid
CabalCash ->cabaluserid
Event ->cabaluserid
Gamedb -> still owned by sa, can't change owner to cabaluserid (always sql query failure)

see, so no matter which login I used, it won't work because different owners on necessary DBs.

When I try to take ownership back to SA, always sql query failure (permission related)
That's why I delete all the DBs and cabaluserid, create new ones, restore them all, so every db will belong to sa login, and re run chumpy's config :)

oh, by the way, me a he chumpy.

Re: Can't create character

@ikanpar1
You're right. Cabal can't own GameDB anymore.
My MSSQL2005 getting the same problem. I am attempting to use sa user now.
Report :
Still shows unknown DB errors when create a char. T-T

Re: Can't create character

My problem at CabalTools. heres the logs:

2012-12-21 @ 22:51:46 : com.microsoft.sqlserver.jdbc.SQLServerException: The OLE DB provider "MSDASQL" for linked server "GAMESERVER" does not contain the table ""GAMEDB"."DBO"."cabal_character_table"". The table either does not exist or the current user does not have permissions on that table.

what is the correct permission configuration at MSSQL? Please help me:argh:

Re: Can't create character

u dont have cereate Linked Server or is die

go GameDB --> stored procedure --> create Character