shiller
Posts: 20
|
| Posted: 01/25/2008, 6:04 AM |
|
Dear Experts,
I'm a new to CodeCharge, I'm using CodeCharge with an Access Database and the code language is ASP 3.0.
I need help setting up Encrypt Passwords...
I click on Project> Settings > Security > Advanced .... I see the "Encrypt passwords using"... "Database function" but there is no explanation on how to set it up.
Could anyone please help....
|
 |
 |
mrachow
Posts: 509
|
| Posted: 01/28/2008, 1:28 AM |
|
This feature is related to the users you are managing for your website (e.g. not the database login itself).
When storing your users passwords you have to use the same function you enter here as Code Expression.
Example: MD5({password})
_________________
Best regards,
Michael |
 |
 |
shiller
Posts: 20
|
| Posted: 01/31/2008, 5:43 AM |
|
Hello,
Do you happen to know how to go about implementing that into my Access database, logins and passwords are stored in the table user in my Access database... CodeCharge user guide doesn't really address the issue in details...
Thanks,
|
 |
 |
shiller
Posts: 20
|
| Posted: 02/01/2008, 7:52 AM |
|
I've converted my passwords into MD5 format in my Access database.... and I added MD5 in the database function under security settings in CodeCharge... When I try to login, I keep getting "Login or Password is Incorrect" error message...
Has anyone successfully use MD5 function in CodeCharge?
Please help...
|
 |
 |
shiller
Posts: 20
|
| Posted: 02/01/2008, 1:23 PM |
|
I finally got it to work,
1) Like Graham R Seach recommended in a previous posting on usergroup, I downloaded
the MD5 class from http://www.freevbcode.com/ShowCode.Asp?ID=741, put
clsMD5.cls into a standard module. ***don't put clsMD5.cls in a class module, because you'll receive an "undefined error message..."***
2) I use the function "DigestStrToHexStr(password_field)" to convert all passwords to MD5 format in my Access Database.
3) Project > Security > Advanced > put a check mark in "Encrypt passwords using" and put MD5({password}) in Code Expression.
4) Then create or recreate your login form and all the new settings will be implemented in it.
Hopefully somebody can benefit from this.
Shiller
|
 |
 |
iandbige
Posts: 1
|
| Posted: 03/08/2008, 6:48 PM |
|
ok
_________________
IanDbigE |
 |
 |