From owner-freebsd-questions@FreeBSD.ORG  Tue Mar 16 09:20:45 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 4BC7316A4CE
	for <freebsd-questions@freebsd.org>;
	Tue, 16 Mar 2004 09:20:45 -0800 (PST)
Received: from gw02.mail.saunalahti.fi (gw02.mail.saunalahti.fi
	[195.197.172.116])
	by mx1.FreeBSD.org (Postfix) with ESMTP id CE5BB43D1F
	for <freebsd-questions@freebsd.org>;
	Tue, 16 Mar 2004 09:20:44 -0800 (PST)	(envelope-from mj@sci.fi)
Received: from fw.netauth.com (roswell.pp.jippii.fi [62.142.244.198])
	by gw02.mail.saunalahti.fi (Postfix) with SMTP id DE200F1BF77
	for <freebsd-questions@freebsd.org>;
	Tue, 16 Mar 2004 19:20:43 +0200 (EET)
Received: (qmail 9717 invoked from network); 16 Mar 2004 17:20:28 -0000
Received: from unknown (HELO gentoo.netauth.com) (192.168.1.2)
  by fw.netauth.com with SMTP; 16 Mar 2004 17:20:28 -0000
Received: (qmail 6821 invoked by uid 1000); 16 Mar 2004 17:20:42 -0000
Date: Tue, 16 Mar 2004 19:20:42 +0200
From: Mike Jackson <mj@sci.fi>
To: zhengyibiao@vnet.citiz.net
Message-ID: <20040316172042.GA6815@gentoo.pp.jippii.fi>
Mail-Followup-To: zhengyibiao@vnet.citiz.net,
	freebsd-questions@freebsd.org
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.6i
cc: freebsd-questions@freebsd.org
Subject: Re: store freebsd accounts in mysql ???
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 16 Mar 2004 17:20:45 -0000

zhengyibiao@vnet.citiz.net (zhengyibiao@vnet.citiz.net) wrote:
>  
> Hi: 
> I am using freebsd5.2, because i have a large number of users counted by ten thousand, use the passwd file to store user accounts and password lead to unbearable delay. I want to know if freebsd support store accounts in places other than '/etc/passwd' file, best support mysql database for passwd database backend. 
> any hints is welcome. 
> regards billy 

Hi,
 Newest versions of FreeBSD support PAM authentication, which can
abstract the authentication database to anything which there is a PAM
module available.

 I would advise against storing user accounts in MySQL, but rather store
them in OpenLDAP (or your LDAP server software of choice). To perform
user lookup you need "nss_ldap", and to perform authentication you need
"pam_ldap".

BR,
Mike