Received: from smtp012.mail.yahoo.com (smtp012.mail.yahoo.com [216.136.173.32]) by postgresql.org (8.11.3/8.11.4) with SMTP id fBR2wom44003 for ; Wed, 26 Dec 2001 21:58:50 -0500 (EST) (envelope-from wolff_borg@yahoo.com.au) Received: from cpe-144-137-118-35.nsw.bigpond.net.au (HELO p1g) (144.137.118.35) by smtp.mail.vip.sc5.yahoo.com with SMTP; 27 Dec 2001 02:58:48 -0000 From: "Stephan Borg" To: "'Vince Vielhaber'" Cc: Subject: Re: WWW-Authentication and Postgresql Date: Thu, 27 Dec 2001 14:00:53 +1100 Message-ID: <001801c18e82$ba9dc900$1400a8c0@p1g> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200112/30 X-Sequence-Number: 805 I have found the mod_auth_pgsql module to be the easiest way to implement this function. Does anyone know if it takes the points mentioned below into consideration? Stephan -----Original Message----- From: Vince Vielhaber [mailto:vev@michvhf.com] Sent: Wednesday, 26 December 2001 2:25 PM To: Andrew McMillan Cc: Stephan Borg; pgsql-php@postgresql.org Subject: Re: [PHP] WWW-Authentication and Postgresql A couple of quick gotchas. 1) make sure you filter out all unwanted characters so someone can't execute sql calls inside of a username or password. 2) On failure make sure you send a 401 to the browser just like you do initially when asking for the password to clear out the old one - you can also use this to handle logouts. Vince. -- ======================================================================== == Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ======================================================================== == _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com