The password encryption in DB doesn't match MD5 or SHA1 or PASSWORD either in Automatic mode or Manual mode! How to know the encryption used?
What DB?
MySql? In Ignition.
No, is the DB one you created yourself or one created by Ignition?
What is writing to the table?
If it is a script then please show the script.
Created by Ignition (automatic mode). Then I want to use the same encryption approach for my manual creation of passwords.
always alteast salt and hash stored passowrds
The DB automatic user profile is pretty outdated and just using sha1, no salt. You can do better unless you’re trying to be compatible for some reason.
The internal user source profile uses sha256 with a salt.
I am trying to decipher the encryption used for an encrypted and known password from its encrypted value. Is it possible? If salt is used then the same password may get encrypted differently, I guess. But if it's the same for multiple instances of the same password I guess it may be possible? I have no clue how to decipher the algorithm used!
Are you trying to recover the password? That ain’t happening. They aren’t encrypted. They are hashed. Non-reversible.
Oh, that's an important information. Thanks a lot!
Basically I am trying to see what encryption/encoding/hashing algorithm I can specify in my authentication query such as "....AND password = MD5(?)" for an existing user table!
uf yikes yeah it should be impossible to reverse… else that would be a mayor security flaw, DO NOT save passowords like that.
Basically, I am trying to see what encryption/encoding/hashing algorithm I can specify in my authentication query such as “…AND password = MD5(?) ” for an existing user table having 'password' stored as string W6ph5Mm5Pz8GgiULbPgzG37mj9g=