From owner-freebsd-isp  Thu Dec  7  4: 6: 7 2000
From owner-freebsd-isp@FreeBSD.ORG  Thu Dec  7 04:06:04 2000
Return-Path: <owner-freebsd-isp@FreeBSD.ORG>
Delivered-To: freebsd-isp@freebsd.org
Received: from gate.trident-uk.co.uk (mail.trident-uk.co.uk [195.166.16.10])
	by hub.freebsd.org (Postfix) with ESMTP id B688637B400
	for <freebsd-isp@freebsd.org>; Thu,  7 Dec 2000 04:06:03 -0800 (PST)
Received: from [194.207.93.139] by gate.trident-uk.co.uk
	for daniel@albanyis.com.au
	id MAA20468; Thu Dec  7 12:04:24 2000
Organization: Psi-Domain Ltd.
Subject: Re: Change password via web
Date: Thu, 7 Dec 2000 11:58:19 +0000
X-Mailer: KMail [version 1.0.28]
Content-Type: text/plain
References: <5.0.0.25.2.20001207194659.0241cb50@mail.albanyis.com.au>
In-Reply-To: <5.0.0.25.2.20001207194659.0241cb50@mail.albanyis.com.au>
MIME-Version: 1.0
Message-Id: <0012071209470B.03569@freefire.psi-domain.co.uk>
Content-Transfer-Encoding: 8bit
To: Daniel <daniel@albanyis.com.au>
From: Jamie Heckford <heckfordj@psi-domain.co.uk>
Reply-To: heckfordj@psi-domain.co.uk
Cc: freebsd-isp@freebsd.org
Sender: owner-freebsd-isp@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.org

I did this - took me ages to figure out how ;)

This was my method:-

1. Create a web form, thats asks for there username, current password, new pass,
verify new pass.

2. Have there current password verified against a MySQL database with a perl
script.

3. If ok, drop there new password into a plain text file with the format
username,password \n . Have a seperate plain text file that will have there new
password in a SQL UPDATE statement in, say, newpass.sql

4. Every ten minutes, have another perl script on cron process the plain text
files.

Process the MySQL with something like "mysql -upass -padmin passworddb <
/var/passtmp/newpass.sql

Then process the password plain text file, with something like this:

open (UD, "</var/passtmp/newpass-add");
if (!defined UD) {
  print "Fuck! Error!\n\n";
  exit;
}

$passcount = 0;
@PASSCOUNT = "";
while (<UD>) {
 @LINE = split /,/;
 foreach $value (@LINE) {

Put your own hack here :)  

}

I'll give you a clue for updating the passwords with your own hack, and that is
adduser is a perl script ;)

I copied the adduser script and then hacked it to include my own processing for
the web stuff and ran it seperatly.

Have Fun

Jamie

On Thu, 07 Dec 2000, you wrote:
> Hi, i've just started using FreeBSD and i've just started to work at an ISP 
> in my local, and i've been asked to make a web page so that our clients can 
> change their passwords on the web.  Has anyone done this sort of thing 
> before or know of any places i could get reference material from?  Anything 
> would be apperciated.
> 
> 
> Thanks
> 
> 
> Dan
> 
> 
> 
> To Unsubscribe: send mail to majordomo@FreeBSD.org
> with "unsubscribe freebsd-isp" in the body of the message
-- 
Jamie Heckford
Chief Network Engineer
Psi-Domain - Innovative Linux Solutions. Ask Us How.

===================================
email:     heckfordj@psi-domain.co.uk
web:	 http://www.psi-domain.co.uk/

tel:	   +44 (0)1737 789 246
fax:	   +44 (0)1737 789 245
mobile:	   +44 (0)7779 646 529
===================================


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-isp" in the body of the message