Security Provider Database User Login

Hello,

I have a DB and a table users with ID, username & password.

The password in de DB is encrypted. How do i read / decrypt / encrypt the password in de form to match the DB password.

When i set the security provider to Single it works like a charm.

Hello,
In the login step, when you set the post variable, you need to apply the same hashing and salt as you used for your create/register user server action:

this way both hashes will be compared on log in.

In PHPMyAdmin i have following options:

AES_ENCRYPT, DES_ENCRYPT, ENCRYPT, MD5, SHA1 (Does not ask for Encrypting key)

It works if if i set it to SHA1 and then in Wappler no salt key

If you want to use some of other hashing methods, for example SHA512, you need to create an update/create user form, and use any of the methods in the data formatter on update/insert.

Ok i see, thank you for the info !

1 Like