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:

Database and Log file merged..... (2000) Meet your competition (2000) I find this type=num search strange (2003) Template - Inventory (2000) SIMS & WebCat .... Alias Folder (2002) Bug Report, maybe (1997) Large databases in WebCat (1997) Running 2 two WebCatalog.acgi's (1996) More questions about serial number dishing (1997) [WebDNA] Best WebDNA version for OS X Server 10.5.8 on PowerPC? (2010) New Web Site Developers Database (1996) WebDNA / Java Chat (2004) Variables containing ! breaking HIDEIF's (1999) New WebCatalog 402 (UNIX) patch available... (2001) Emailer setup (1997) FW: ANother SHOWIF problem (1997) Document Contains No Data! (1997) searching by date range help needed (1997) Exclamation point (1997) Calculating multiple shipping... (1997)