Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create a database table to hold login credentials #2

Closed
gurusami opened this issue Feb 16, 2022 · 5 comments
Closed

Create a database table to hold login credentials #2

gurusami opened this issue Feb 16, 2022 · 5 comments
Assignees
Labels
enhancement New feature or request

Comments

@gurusami
Copy link
Owner

Anyone who needs to make use of the iragu application need to have the user name and password stored in this table. I think ir_login would be a suitable name for this table. The user name should be the same as the nick name stored in the ir_people table.

@gurusami gurusami self-assigned this Feb 16, 2022
@gurusami
Copy link
Owner Author

For storing passwords, I think we can make use of SHA2() function available in MySQL.
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html

@gurusami gurusami added the enhancement New feature or request label Feb 16, 2022
@gurusami
Copy link
Owner Author

Consider the Web Crypto API, which can do the encryption in the client browser itself.
https://developer.mozilla.org/en-US/docs/Web/API/Web_Crypto_API

@gurusami
Copy link
Owner Author

Another one to explore is CryptoJS JavaScript library.
https://cryptojs.gitbook.io/docs/

@gurusami
Copy link
Owner Author

This looks like the best option available.
https://developer.mozilla.org/en-US/docs/Web/API/SubtleCrypto/digest

gurusami added a commit that referenced this issue Feb 17, 2022
@gurusami
Copy link
Owner Author

commit fc8ca43

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant