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:

WebMerchant Mac 3.0 beta available (1998) Search Question (2003) [ModDate] & [ModTime] ? (1997) Request for help on a new *automated* WebCatalog function ... (1998) Associative lookup style? + bit more (1997) WebCat2 several catalogs? (1997) OUTSIDE LINKS TO SHOW SHOPPING CART????????? (1998) JavaScript form question (2001) Public Beta for WebCatalog 4.0 is Available (2000) using showpage and showcart commands (1996) The force has left me. (2002) Newbie search question (between two dates) (2001) IIS4/WebCat3.0 Authentication (1999) Formulas.db + Users.db (1997) SKU lookup (1997) bulletin board spell check (2001) all records returned. (1997) New Command prefs ... (1997) Memory Parameters (1998) [WebDNA] Writefile size limit? (2011)