From owner-freebsd-questions Mon Jul 29 14:45:16 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id BB33B37B400 for ; Mon, 29 Jul 2002 14:45:13 -0700 (PDT) Received: from pd5mo1so.prod.shaw.ca (h24-71-223-10.cg.shawcable.net [24.71.223.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1705C43E5E for ; Mon, 29 Jul 2002 14:45:08 -0700 (PDT) (envelope-from dmacpher@vfs.com) Received: from pd4mr1so.prod.shaw.ca (pd4mr1so-qfe3.prod.shaw.ca [10.0.141.212]) by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12 2002)) with ESMTP id <0H0100I8N5R7M9@l-daemon> for freebsd-questions@FreeBSD.ORG; Mon, 29 Jul 2002 15:45:07 -0600 (MDT) Received: from pn2ml5so.prod.shaw.ca (pn2ml5so-qfe0.prod.shaw.ca [10.0.121.149]) by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12 2002)) with ESMTP id <0H01003AN5R73W@l-daemon> for freebsd-questions@FreeBSD.ORG; Mon, 29 Jul 2002 15:45:07 -0600 (MDT) Received: from D (h24-78-251-193.vc.shawcable.net [24.78.251.193]) by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12 2002)) with ESMTP id <0H01005Q05R7QP@l-daemon> for freebsd-questions@FreeBSD.ORG; Mon, 29 Jul 2002 15:45:07 -0600 (MDT) Date: Mon, 29 Jul 2002 14:43:29 -0700 From: Derrick MacPherson Subject: Question regarding user accounts - moving to a DB, interaction with other systems, etc To: freebsd-questions@FreeBSD.ORG Message-id: <003e01c23748$fa375b20$c1fb4e18@D> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Mailer: Microsoft Outlook, Build 10.0.2616 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Importance: Normal X-Priority: 3 (Normal) X-MSMail-priority: Normal Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG I am looking at moving my current user accounts (~2500) from the traditional /etc/master.passwd (users have a shell that tells them they are not allowed to access trough the terminal, only through webmail (squirrelmail and exim as the MTA). I would like to move all but a small number of administrator accounts into a database. I would like to be able to At least store real names, email/login name, and passwords. I am hoping to maybe also hold quota data, there would be probably only 2 or 3 different sizes of quotas, is this info able to be held in a DB? I believe I can do the webmail (apache) authentication to the DB, and the email accounts (MTA). I should then be able as well to setup SMTP Auth using this as well. One of the big 'I doubt I can do it, and even if I could, I don't think it's wise' bonus's would be EITHER to use this DB as authentication for ANOTHER server, that is just used for FTP/HTTP accounts for users. and the 'yeah right, jeez the weed is good in Vancouver' job would be: is it possible to have user account (username, real name and password) info be taken from a W2K server? (active Directory is LDAP I believe, but I don't work with W2K that much) at least initially, reason is that as it stands now, the poor schmuck that has to create the user accounts, has to do them on three different machines (webmail, FTP, W2K)... Other than the last couple dreams/nightmares I mentioned at the end there, is there some suggestions for a way to convert the current user accounts into a DB? Anything here that reeks of stupidity or is there some info somewhere that is out there that someone has something like this done, or similar? Thanks people, I do realize the last couple points might be stretching it a bit, but what the hell, if I am going to be pulling rabbits out of hats, I might as well ask if it can be a Volkswagen Rabbit. :) To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message