Re: encrypt/decrypt password with authenticate

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 41965
interpreted = N
texte = Just a guess, but shouldn't be:[showif [NotFound]=[lookupdb=members.db&lookinField=user&value=[uppercase][username][/uppercase]&returnField=user¬Found=NotFound]]?GK> I'm stymied.> Why won't these procedures authenticate a password encrypted and writtento> a database?>>> Following a procedure outlined by Ken I came across in the archives . . .>> I copied the users.db database and renamed it members.db> I copied MultiGroupChecker and renamed it MemberChecker> Placed both of the new files in the same folder as pages I want to protect>>> I use this to write a username/password combo into a database.>> [append> db=members.db]user=[uppercase][user][/uppercase]&pass=[url][url][encrypt>seed=1234][uppercase][pass][/uppercase][/encrypt][/url][/url]&groups=e-info[/append]>>> On top of pages to protect I have:> [include file=MemberChecker&groups=e-info]>> In my MemberChecker I have the following:>> [!] check for user in members.db[/!]> [showif NotFound=[lookup>db=members.db&lookinField=user&value=[uppercase][username][/uppercase]&returnField=user¬Found=NotFound]]> [authenticate Bad User]> [/showif]>> [!] Check password of user in members.db[/!]> [showif [uppercase][password][/uppercase]![lookup>db=members.db&lookinField=user&value=[uppercase][username][/uppercase]&returnField=[decrypt> seed=1234][unurl][unurl]pass[/unurl][/unurl][/decrypt]¬Found=NotFound]> [authenticate Bad Password]> [/showif]>>>> To make sure I was encrypting and decrypting the password properly> I made another page with the following:>>> [text]public=Ginny+me^$1234[/text]>> [text]private=[url][url][encrypt> seed=1234][uppercase][public][/uppercase][/encrypt][/url][/url][/text]>> [text]resurrection=[decrypt> seed=1234][unurl][unurl][private][/unurl][/unurl][/decrypt][/text]>> public=[public]

> private=[private]

> resurrection=[resurrection]

>> All went well with the above test code . . .>> . . .>> I just can't get my procedures to work with authenticate . . . .> All stops at Bad Password-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: encrypt/decrypt password with authenticate (Brian Fries 2002) Re: encrypt/decrypt password with authenticate (Lester Emo 2002) Re: encrypt/decrypt password with authenticate (Alain Russell 2002) Re: encrypt/decrypt password with authenticate (Gary Krockover 2002) encrypt/decrypt password with authenticate (Lester Emo 2002)

Just a guess, but shouldn't be:[showif [NotFound]=[lookupdb=members.db&lookinField=user&value=[uppercase][username][/uppercase]&returnField=user¬Found=NotFound]]?GK> I'm stymied.> Why won't these procedures authenticate a password encrypted and writtento> a database?>>> Following a procedure outlined by Ken I came across in the archives . . .>> I copied the users.db database and renamed it members.db> I copied MultiGroupChecker and renamed it MemberChecker> Placed both of the new files in the same folder as pages I want to protect>>> I use this to write a username/password combo into a database.>> [append> db=members.db]user=[uppercase][user][/uppercase]&pass=[url][url][encrypt>seed=1234][uppercase][pass][/uppercase][/encrypt][/url][/url]&groups=e-info[/append]>>> On top of pages to protect I have:> [include file=MemberChecker&groups=e-info]>> In my MemberChecker I have the following:>> [!] check for user in members.db[/!]> [showif NotFound=[lookup>db=members.db&lookinField=user&value=[uppercase][username][/uppercase]&returnField=user¬Found=NotFound]]> [authenticate Bad User]> [/showif]>> [!] Check password of user in members.db[/!]> [showif [uppercase][password][/uppercase]![lookup>db=members.db&lookinField=user&value=[uppercase][username][/uppercase]&returnField=[decrypt> seed=1234][unurl][unurl]pass[/unurl][/unurl][/decrypt]¬Found=NotFound]> [authenticate Bad Password]> [/showif]>>>> To make sure I was encrypting and decrypting the password properly> I made another page with the following:>>> [text]public=Ginny+me^$1234[/text]>> [text]private=[url][url][encrypt> seed=1234][uppercase][public][/uppercase][/encrypt][/url][/url][/text]>> [text]resurrection=[decrypt> seed=1234][unurl][unurl][private][/unurl][/unurl][/decrypt][/text]>> public=[public]

> private=[private]

> resurrection=[resurrection]

>> All went well with the above test code . . .>> . . .>> I just can't get my procedures to work with authenticate . . . .> All stops at Bad Password-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Gary Krockover

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

RE: Can a database get stomped by simultaneous access? (1997) Protect (1997) Random sort is not random at all..... (2000) Signal Raised Error (1997) Emailer help....! (1997) Passing WebCat Vars with Javascript (2000) Multiple Ad databases? (1997) re: emailer prob (1998) WebCat2 beta 11 - new prefs ... (1997) searchable list archive (1997) multi-paragraph fields (1997) More on the email templates (1997) Search design (1997) pipe delimited crconvert database (2002) Feature requests (1998) Stumped (1999) Emailer help....! (1997) Problems passing [SKU] with $Replace in 2.0 (1997) Claris HomePage messes up the code (1997) Search Results (1998)