Account creation failure

[internalflame]

I'm setting up my databases for chumpy's v2.5 repack and when i'm using the

exec dbo.cabal_tool_registerAccount 'test123' , 'test123'

query i get the error

Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 10
Cannot insert the value NULL into column 'Password', table 'ACCOUNT.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 16
Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(1 row(s) affected)

also when i use chumpy's GM tools i get the msg

Duplicate row. Player already exist?

not sure if i've done something wrong but i was following the video guide for chumpy's v2 repack. I am using vista home premium 64 bit but i don't think that's the problem, i'm using the v2 databases because i couldn't find any new ones for the v2.5 repack.

sorry if this has already been posted, i searched but couldn't find anything relevant.

[MentaL]

[maxgo1]

Select the Database (ACCOUNT)

[cypher]

please triple check that you have installed properly xp_md5 extended procedure.

[internalflame]

@maxgo1
i've already made sure of that

@cypher
i'll check again

*when I execute the query again I get the message it has already been placed in the db

[maxgo1]

try to place different username and pass
If same than try to RESTORE other backup of ACCOUNT DB

[internalflame]

try to place different username and pass
If same than try to RESTORE other backup of ACCOUNT DB

I will try it again tomorrow my head hurts :p thanks for the help though

[cypher]

i`m 100% sure that the main problem is that you lack the md5 procedure.

[maxgo1]

i`m 100% sure that the main problem is that you lack the md5 procedure.

Cypher ..
buth

Cannot insert the value NULL into column 'UserNum'

This is wrong DB(Not correctly created :S) i think

[cypher]

actually he gets the error in usernum because the first insert has failed. and the first insert has failed because of the md5 problem.

[D e v i L]

actually he gets the error in usernum because the first insert has failed. and the first insert has failed because of the md5 problem.

True. I believe it is because of the md5. I got this problem before but when i searched the forums thoroughly i came across chumpywumpy's guides.. just follow it and you'll succeed for sure... you can take my word for it. =)

ps. Hey chumpy your server files got some things mixed up like in TG, procyon won the war but it was Capella who got the winning bonus. Also, in "cabal_rates static" in centos... alz bomb and alz rate are mixed up just wanted to inform you...

[chumpywumpy]

This is definitely broken md5 support, i have seen it a lot. If you run the query below and get a "null" back your md5 isn't working, if you get letters and numbers it is. Check for the xp_md5 in the extended procedures folder in mssql and check the path to the dll is correct and that the .dll allows the "everyone" group read access at least.

select account.dbo.fn_md5('test')

ps. Hey chumpy your server files got some things mixed up like in TG, procyon won the war but it was Capella who got the winning bonus. Also, in "cabal_rates static" in centos... alz bomb and alz rate are mixed up just wanted to inform you...

Yes i am ware of a few wierd bugs i TG, i didn't know about the rates bug though. Thatk's for letting me know ;)

[internalflame]

I tried the query and i'm getting NULL back, now when i checked to make sure that the path was correct it was, i tried it in a few different places making sure that the path was still correct and i'm still getting NULL from that query. i think it might be time to just reinstall mssql again fresh and do everything right from the start

*k i've reinstalled and done it again, i still cannot get it to work.
I found it under system databases/master/programmability/extended stored procedure/dbo.xp_md5 from what you said i shouldn't have to search that deep

[cypher]

that`s why i hate mssql 2k5, i don`t work with it, if you would`ve done it in mssql 2k it would work.

[internalflame]

mssql 2k doesn't work on vista :( oh well it's not that important to make a server. thanks for the help anyways

[chumpywumpy]

2005 should not be a problem at all as many use it. I recommend putting the dll in c:\windows\system32 and using the following query to add it to mssql.

EXEC SP_ADDEXTENDEDPROC 'xp_md5','xp_md5.dll'

It is worth checking the permissions on the .dll allow read access to the "everyone" group as i have seen that cause this problem before.

Is your Vista machine 64-bit? If so then this might help:

http://forum.ragezone.com/f460/cabal...ghlight=xp_md5

[internalflame]

i've tried it again with the dll in my system32 folder and still nothing

i do have vista home premium x64 so i tried the guide on that post up until you start installing vmware and still it's not working but it doesn't matter much anyways i'll always have other people's servers to use

[cypher]

mssql 2k works on vista -_-'

[internalflame]

mssql 2k works on vista -_-'

not 64 bit vista

[xyb3r_5urf3r]

Had the same problem but was able to resolve it...

Here's what I did...

1. Performed the following query

EXEC SP_DROPEXTENDEDPROC 'xp_md5';

2. Made sure that the xp_md5.dll file is on c:\windows\system32

3. Performed the query

EXEC SP_ADDEXTENDEDPROC 'xp_md5','C:\WINDOWS\SYSTEM32\xp_md5.dll'

Take note that I included the complete path where the dll file is. It might be different if you placed the dll file on a different directory.

Was able to create an account since then.

Hope it helps.

[internalflame]

that doesn't work because with step 3 i get an error when i execute it, but if i take the extension off the first xp_md5.dll it executes fine, but still won't let me create an account

[xyb3r_5urf3r]

Sorry, wrong syntax...

Try the procedures one last try and let me know...