Sha1 Problem.

[Killzon32]

I can log into account manager but not any of my account's.
I am using sha1 I don't understand what is wrong.
encryptionType = "SHA1"
I have been using sha1 for along time.

Can anyone help me?

 

[JoSePh15_]

yup i know that

Go to database, find account 1, change password to:
356a192b7913b04c54574d18c28d46e6395428ab

Then it works. 1/1

@QUOTED FROM ZNOTE'S POST!
http://otland.net/f132/0-4-account-manager-problem-help-98028/index2.html#post1031036

 

[Killzon32]

You don't understand the exact problem... Account manager works all other accounts do not.

 

[Killzon32]

Update: I used

UPDATE `accounts` SET `password` = sha1(`password`);

To try and fix the problem but i think thats what the problem is.. It seems like it changed every password to something else.. its weird cause if i am using sha1 and i use that why did it mess up? I no if i don't need to reset everyone Their has to be a way to fix this.

 

[Kavvson]

UPDATE `accounts` SET `password` = sha1(`password`) WHERE account_id= 1;

 

[Killzon32]

#1054 - Unknown column 'account_id' in 'where clause'

 

[mayel]

Ye, it's probably id and not account_id i believe

 

[dianagirl]

hmm,then make sha1 instead SHA1 ,and restart ur ot,maybe it works?,by me it was so too.

 

[Killzon32]

Well that made it so I can log into new accounts that i create with account manager but i still cant log into older accounts

 

[Killzon32]

i need help

 

[Kavvson]

You execute my sql while you are in the accounts table ... rofl

 

[Killzon32]

Explain more please.. Do you mean use in sql when your in accounts, in database?
cause this is what it gives me #1054 - Unknown column 'account_id' in 'where clause'

 

[Diazapam]

I think your members just have to get themselfs a new password, it might have been that you now double encrypted them (encrypted the SHA1 password a 2nd time to SHA1).

Just set the lost account interface and spam their mail

 

[Killzon32]

I don't no how i can do this if I have ingame account manager and most people make accounts without email... Though if worst comes to worst I think I can just reset everyones password to 1. or something and then they can just change it on website,

 

[Lessaire]

http://otland.net/f481/converting-existing-mysql-plaintext-database-use-sha1-102356/

 

[Killzon32]

I don't need to make plaintext to sha1 i need sha1 work D: seems like i double encrypted my sha1 (( By chance anyone know how i can change all passwords to x in database?

 

[Diazapam]

[COLOR=#000000][COLOR=#0000BB]UPDATE [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]accounts[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]SET [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#DD0000]password[/COLOR][COLOR=#007700]` = 'Very_big_security_risk';[/COLOR][COLOR=#007700] [/COLOR][/COLOR]

 

[Lessaire]

I don't need to make plaintext to sha1 i need sha1 work D: seems like i double encrypted my sha1 (( By chance anyone know how i can change all passwords to x in database?

If you have a recent database backup with plaintext passwords, that little tutorial would do exactly that. Conversion of plaintext to SHA1 on the original column is irreversible. There are no comprehensive SHA1 reverse lookup dictionaries.

If you'll notice from my tut, password column settings work efficiently with these setttings for SHA1: CHAR( 40 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL. And then just change the parameters in the config.lua of course.

 

[Killzon32]

I no people have the chance of hacking someone elses account but its still better then them losing it lol. and theres only about 10-20 people on my ot.

 

[Killzon32]

bump