error at call cabal_sp_newchar

[themike48]

hi mates,

i got strange prob:

server is running, and i can login at client, but when i try to create a new char i get "... Unkown DB error. Please try it again"

i allready read the FAQ's in Sticky (http://forum.ragezone.com/f460/commo...s-faqs-469775/)
and i configured the linked serever exactly like i should.

but im not able to create a char!?

anybody has in idea for me?

Using full Chumpy files

thnx

[root@cabal cabal]# service cabal status
GlobalDBAgent (pid 7861) is running...
GlobalMgrSvr (pid 7909) is running...
CashDBAgent (pid 7948) is running...
DBAgent_01 (pid 7996) is running...
ChatNode_01 (pid 8039) is running...
WorldSvr_01_01 (pid 8085) is running...
LoginSvr_01 (pid 8124) is running...

[Tue Oct  7 2008 06:17:38.954973 3086772720]: open log file  '/var/log/cabal/DBAgent_01.log'
[Tue Oct  7 2008 06:17:38.968211 3086772720]: LOG LEVEL: 3
[Tue Oct  7 2008 06:17:38.968423 3086772720]: MemPoolUnitSizeClass(2): 24576Bytes
[Tue Oct  7 2008 06:17:38.973538 3086772720]: Start DBAgent_01 Server
[Tue Oct  7 2008 06:17:38.976956 3086772720]: UseEcryptText (Off)
[Tue Oct  7 2008 06:17:38.979775 3086769040]: CProcessLayer(0)::svc Start [3086769040]
[Tue Oct  7 2008 06:17:38.980498 3076279184]: CProcessLayer(0)::svc Start [3076279184]
[Tue Oct  7 2008 06:17:38.981778 3086772720]: try listening 38181 port
[Tue Oct  7 2008 06:17:38.983113 3065789328]: CProcessLayer(0)::svc Start [3065789328]
[Tue Oct  7 2008 06:17:38.983649 3055299472]: CProcessLayer(0)::svc Start [3055299472]
[Tue Oct  7 2008 06:17:38.984354 3044809616]: CProcessLayer(0)::svc Start [3044809616]
[Tue Oct  7 2008 06:17:40.267492 3086772720]: accept success 8(127.0.0.1:40380)
[Tue Oct  7 2008 06:17:40.412980 3086772720]: 1.open user 8 [8578BA8] (127.0.0.1)
[Tue Oct  7 2008 06:17:41.831416 3086772720]: accept success 10(127.0.0.1:40382)
[Tue Oct  7 2008 06:17:41.832053 3086772720]: 2.open user 10 [85872D0] (127.0.0.1)
[Tue Oct  7 2008 06:18:40.719869 3086769040]: Database Connect success!
[Tue Oct  7 2008 06:18:40.747463 3065789328]: Database Connect success!
[Tue Oct  7 2008 06:18:42.336606 3044809616]: Database Connect success!
[Tue Oct  7 2008 06:18:42.422690 3086769040]: sock 10=> sendBuf is growed (size:32768). len(657), 17000, 131072
[Tue Oct  7 2008 06:18:42.441753 3076279184]: Database Connect success!
[Tue Oct  7 2008 06:21:41.852941 3055299472]: Database Connect success!
[Tue Oct  7 2008 06:26:04.295224 3044809616]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 40)
[Tue Oct  7 2008 06:26:04.295808 3044809616]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Login failed for user ''.
[Tue Oct  7 2008 06:26:04.295883 3044809616]: [##ERROR##] DB ERROR(CODE)     : 18456
[Tue Oct  7 2008 06:26:04.295950 3044809616]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Oct  7 2008 06:26:04.296017 3044809616]: [##ERROR##] DB ERROR(SQLSTATE) : 28000
[Tue Oct  7 2008 06:26:04.296083 3044809616]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ?              , ?         , ?         , ?         )}
[Tue Oct  7 2008 06:26:04.523418 3044809616]: Database Connect success!

[MentaL]

[chumpywumpy]

It sounds like there is some form of permissions problem, "Login failed for user ''" makes me think that it isn't seeing a userid. Are you using an "sa" logon or another as no permissions problems should be able to affect an "sa" logon but might affect others.

Also, check your ini files in /etc/cabal/ and make sure the pass***** are showing up at the bottom of the ones that lost a user and password.

Can you post a screenshot of the linked server settings?

EDIT: Also try this and see if it works: http://forum.ragezone.com/f460/query...ewchar-477206/

[themike48]

It sounds like there is some form of permissions problem, "Login failed for user ''" makes me think that it isn't seeing a userid. Are you using an "sa" logon or another as no permissions problems should be able to affect an "sa" logon but might affect others.

Also, check your ini files in /etc/cabal/ and make sure the pass***** are showing up at the bottom of the ones that lost a user and password.

Can you post a screenshot of the linked server settings?

sure he we go :)
and im connecting with SA user .ini files seems to be okay... shall i try connect with "cabal" user?

EDIT: Also try this and see if it works: http://forum.ragezone.com/f460/query...ewchar-477206/

tryed already, same error in SQL Manager Studio

Meldung 18456, Ebene 14, Status 1, Zeile 1
Login failed for user ''.
OLE DB provider "SQLNCLI" for linked server "GAMESERVER" returned message "Invalid connection string attribute".

maybe this will help ;)

[themike48]

Push ;d

[cypher]

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

[chumpywumpy]

Aha, it's the linked server. You have yours set to "SQL native client" (next to Anbieter) and it should be "Microsoft OLE DB Provider for ODBC".

Are you using a 64-bit operating system? I have seen something similar happen there. If you are using sql 2005 express get the "Microsoft SQL Server 2005 Express Edition with Advanced Services" from microsoft.com (free) as some of the 32 bit drivers don't work well on 64 bit under express i think. Make sure you read the notes on the download page about 64 bit .net too.

Also read the tips for 64 bit servers john_d posted (linked on the sticky in this section).

[themike48]

tnx Cumpy, everything is working now :)

have a nice day

[clever]

your SQL is different, what version is that dude?