Prob. MSSQL2005

[LucaWeb93]

When i try to create mine game account i have this error :



I've used this database pack : http://rapidshare.com/files/13610892...b_9.8.2008.rar

Help

[MentaL]

[chumpywumpy]

Null errors when registering accounts are always the same thing. Your xp_md5 support isn't working. Open the "master" database, find the extended procedures folder and locate xp_md5. Check it's properties and make sure the dll is in the right place.

You can use the query below to test if it's working and if you get a NULL back instead of a password hash it is not working right.

select account.dbo.fn_md5('test')

[LucaWeb93]

i must make me sure the xp_md5.dll are in c:\program files\microsoft sql server ???????

Or not ? , i did not understand very well......

[cypher]

no the xp_md5 you downloaded with the server and you can either place it on c:/ or in c:/windows/system32 or anywhere your PATH variable is set!

[LucaWeb93]

And where i can setting it

[cypher]

in the extended procedures of master table , make a new one to point out to {your path to xp_md5.dll}

[LucaWeb93]

Now i created the table : dbo.fn_md5 in the ( master's table) , now what i must do??


( thank for help , this is my first cabal online server...)

[cypher]

not table, extended procedure...

[chumpywumpy]

Delete the xp_md5 entry from the extended procedures folder in the master database, put the dll in c:\windows\system32 and then run the query below.

EXEC sp_addextendedproc 'xp_md5', 'xp_md5.dll'

[LucaWeb93]

Ok i have created mine account in manager studio express, and now i have this problem when i try to start the 2.5 server i have a problem:

[cypher]

adduser cabal

[LucaWeb93]

I've created the account. whit the query in managment studio ... i must create in Sql > GameDB > cabal_character_table ????

[striker1010]

You don't create any tables o_o As far as I know when you "restore" the databases everything is set and ready to go on the sql part. Then again I haven't touched this stuff in well over 4 months. So lemme go verify that.


I think cypher means that you need to create a "cabal" user for the sql itself.
So that the server can connect to the database. I maybe getting this wrong though. But you don't create any users in the SQL database files. That's for in-game stuff.

[LucaWeb93]

striker i've resolved the ''database problem'' now i must create a new player of cabal, and i don't know if i must create from : Sql > GameDB > cabal_character_table or waht?

[striker1010]

cabal_character_table is an already existing table, to create a new character just log into the game and make one.

If you mean to create an account use the stored procedure "cabal_tool_registerAccount" in ACCOUNT database. Or you can just use one of the GMTools provided in the forums to make an account.

[LucaWeb93]

Ok i try whit gmtools

[cypher]

NO, just type
adduser cabal
in centos terminal.

[striker1010]

cypher...what is he trying to do? make an in-game character account? or..is he trying to make a character..or what..i am confused lol

[chumpywumpy]

The errors in the screenshot say the user "cabal" doesn't exist on Centos and it needs to. This should have been created when the cabal .rpm was installed but "adduser cabal" would create it manually.

[LucaWeb93]

When i type '''adduser cabal'' in centos terminal it answer that the user: CABAL EXIST

[FaUZaNeVVa]

What version of CentOS You're currently using, bud? I'm using CentOS-4.7.ServerCD-i386A and everything is Ok.

Maybe You need to reinstall it :|

[LucaWeb93]

I have your centos version and it work ok ............, i can try to delete the user ''cabal' and create it again ... but which is the command for delete a user ?

[FaUZaNeVVa]

[root@cabal ~]# userdel
usage: userdel [-r] name

userdel -r cabal :P

[LucaWeb93]

thanks :D .

[LucaWeb93]

Now i've this error :




-.-'''''''

ps:cypher anchio sono italiano se mi devi spiegare qualcosa spiegala in italiano grazie :P