Date: Tue, 10 Aug 1999 08:52:00 -0400 From: Jon Parise <jcptch@osfmail.isc.rit.edu> To: FreeBSD ISP <freebsd-isp@freebsd.org> Subject: Re: your mail Message-ID: <19990810085200.G31932@osfmail.isc.rit.edu> In-Reply-To: <Pine.LNX.4.05.9908101141050.1983-100000@linux1.usls.edu>; from francis@usls.edu on Tue, Aug 10, 1999 at 11:51:55AM %2B0800 References: <Pine.LNX.4.05.9908101141050.1983-100000@linux1.usls.edu>
next in thread | previous in thread | raw e-mail | index | archive | help
On Tue, Aug 10, 1999 at 11:51:55AM +0800, Francis A. Vidal wrote: > however, adding, deleting, disabling, and changing user information is > quite a task for 7,200 accounts with only a couple of full-time staff. > what tools do we need to manage these accounts? it would also be nice if > all the accounts were stored in a SQL server. i have looked into the > possibility of using these packages: > > OS -- FreeBSD > SQL server -- MySql 3.22.25 > MTA -- Postfix (supports SQL server lookups) > IMAP & POP -- Cyrus > Web Interface -- TWIG or IMP > Web Server -- Apache 1.3.6 + SSL + PHP3 It looks like you could easily get away with storing your user information in a mysql database. Use 'mod_auth_mysql' to authenticate web users in apache. I'm not sure if cyrus will play nice with sql, so that might be your only hack. You could also run cistron radius with the mysql patches. I believe freebsd will can do authentication from a radius server using a pam module. I haven't really played with this before, so this information might be incorrect. > the problem is how to `glue' these packages together for easier > management. it's also good if the users were able to change the password > themselves via a web interface and not to call us everytime they want to > change their passwords. That should be trivial if you're storing your user information in a database. Just make sure they're properly authenticated beforehand and that the connection is secure. -- Jon Parise (parise@pobox.com) . Rochester Inst. of Technology http://www.pobox.com/~parise/ : Computer Science House Member To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?19990810085200.G31932>