Help me about this error. pls ...

[Emc]

Hi, there

I just made a Cabal server. I can login the server well but i can't make a new character. There is a unknown GAMEDB error. I deleted and made new "ACCOUNT" database and i checked 2 etc folders there are 2 ODBC.ini files. But i can't make a char. Could you helpme about that. Btw i get this error lines in /var/log/cabal/DBAgent_24.log;

[Sat Aug 23 2008 02:18:06.534432 3055057824]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 13)
[Sat Aug 23 2008 02:18:06.540427 3055057824]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Login failed for user ''.
[Sat Aug 23 2008 02:18:06.540484 3055057824]: [##ERROR##] DB ERROR(CODE)     : 18456
[Sat Aug 23 2008 02:18:06.540532 3055057824]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Aug 23 2008 02:18:06.540579 3055057824]: [##ERROR##] DB ERROR(SQLSTATE) : 28000
[Sat Aug 23 2008 02:18:06.540626 3055057824]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ?              , ?         , ?         , ?         )}
[Sat Aug 23 2008 02:18:06.577209 3055057824]: Database Connect success!

I hope that can be help, and then you can help to me. Thx a lot ...

 

[terzo]

Hmm, i remember what this error, here i can see maybe 800+ topics with the solution
RESTORE .BAK AND DON'T USE MDF~LDF FILE!

USE SEARCH BUTTOM

 

[Emc]

Yes you can rebemember that, But mine is a little different. As you SEE;
[Sat Aug 23 2008 02:18:06.540427 3055057824]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Login failed for user '(null)'.
my user name is coming null, and then i read almost 800+ topics there. By the way I'm using SQL Server 2005. There is no .Bak file for restore. I'm using chumby's database files. Thanks ....

Well, i just restored ACCOUNT db with blackxl's .BAK file , still i'm getting same error. :'( ...

 

[chumpywumpy]

Both darkxl's databases and mine require a linked server (we know it as the "GAMESERVER" setting) or you get a message in the client telling you that there was an unknown database error. I will be getting rid of that reuirement in mine eventually but i have more serious things to look at first.

The (null) error is caused by the xp_md5.dll support either being missing from the server or the path in the setting is wrong and it can't find the .dll. You need to run the command below and correct the path to where your copy of the .dll is:

EXEC SP_ADDEXTENDEDPROC 'xp_md5','d:\cabal\xp_md5.dll'

Personally i recommend putting the .dll in c:\windows\system32\ so you don't need to use a full path you can just use the .dll name.

If you get an error about the extended procedure already existing you need to drop the current entry from the extended procedures section in your "master" database.

@terzo - most of the server releases don't actually have the .bak on the end they are extensionless files which is why people get confused and just attach the mdf/ldf. It is one of several reasons why i made my own repack, i could get rid of the garbage that is causing the confusion

 

[Emc]

I think my "linked server" isn't working. How can i test it. I load to my linux server Database manager (aquasoft) i can connect to sql server from linux with aquamanager i can add new records erc. but when i try to create new char with client isn't work.

By the way as u said in your pdf guide chump i copied md5.dll to System32 folder already. when i tty to add again "Msg 17753, Level 16, State 0, Procedure sp_addextendedproc, Line 24
sp_addextendedproc can only be executed in the master database.
" Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 24
There is already an object named 'xp_md5' in the database.
" How can i remove and add again md5.dll Thx for help Chumpy ...

By the way i'm using XP pro+ SP3 and sql 2005 but i can't install the SQL server 2000 on XP+SP3 :S

 

[chumpywumpy]

Open your master database->Extended procedures and find dbo.xp_md5 using your management studio and delete it. You should now be able to re-add.

If you open the linked server in the management studio you should be able to click on Tables and see things in there but if you get an error it isn't working and you need to check the connection string (it is usually the hostname that is a problem).

SQL 2000 will install on XP SP3 because that is what i am using (i only have SP3a and not 4 too). I have a legit copy of the developer edition though so it could be that you have a slightly different version (standard or whatever).

 

[Emc]

Well, I unistalled my sql server and then i installed again databases, now i'm getting this error when i try to make a new character;

[Sat Aug 23 2008 23:44:35.725456 3055213472]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 13)
[Sat Aug 23 2008 23:44:35.725884 3055213472]: [##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.
[Sat Aug 23 2008 23:44:35.725973 3055213472]: [##ERROR##] DB ERROR(CODE)     : 7314
[Sat Aug 23 2008 23:44:35.726022 3055213472]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Aug 23 2008 23:44:35.726069 3055213472]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sat Aug 23 2008 23:44:35.726115 3055213472]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ?              , ?         , ?         , ?         )}
[Sat Aug 23 2008 23:44:36.076252 3055213472]: Database Connect success!

 

[chumpywumpy]

That error is telling you that your gameserver setting is wrong and the server can't see the tables through it. If you try viewing the tables as i suggested before do you see anything in there?

 

[[hidden]]

remember the sql part (linked servers "GAMESERVER") double check the last tab. and check everything (5 squares). (also on the second tab, make sure you chose the third option) [open it so you'll be able to understand clearly what i mean] save settings, clear logs, reboot server, recheck logs.

 

[francis688]

HELP! how to do the in game database error





HELP PLS!!!! T_T

 

[cypher]

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