From owner-freebsd-isp Wed Dec 18 9:53:59 2002 Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 043B637B401 for ; Wed, 18 Dec 2002 09:53:58 -0800 (PST) Received: from zephir.primus.ca (mail.tor.primus.ca [216.254.136.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6837F43EC2 for ; Wed, 18 Dec 2002 09:53:57 -0800 (PST) (envelope-from leth@primus.ca) Received: from dialin-164-70.tor.primus.ca ([216.254.164.70]) by zephir.primus.ca with esmtp (Exim 3.36 #3) id 18OiOD-0005wj-0A; Wed, 18 Dec 2002 12:53:49 -0500 Date: Wed, 18 Dec 2002 12:54:03 -0500 (EST) From: Jason Hunt X-X-Sender: leth@lethargic.dyndns.org To: Lee Johnston Cc: "Dave [Hawk-Systems]" , Subject: RE: Web Based Control for FreeBSD (LDAP/MySQL) In-Reply-To: Message-ID: <20021218111756.W42746-100000@lethargic.dyndns.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org On Wed, 18 Dec 2002, Lee Johnston wrote: > I was really after something that stored account info, domain details, > apache config in MySQL but looking around, it seems that people are leaning > towards LDAP and using pam_ldap for user authentication. > > Has anyone got an opinion with regards to the stability and usability of > OpenLDAP vs. MySQL? I've never really experimented with LDAP! > Well, I think that both products are quite stable, so that should not be a deciding factor. Usability is where it matters. MySQL is an SQL RDBMS (Relation DataBase Management System). OpenLDAP is an LDAP Directory. SQL is better for transaction-based operations and where you require complex queries, while LDAP is designed for read-intensive operations where you are constantly querying the server for information and not writing to it as often. Also, from my experience, LDAP is easier to replicate. I think that LDAP makes more sense for storing user account information. Not too long ago there was a website, and I believe it was www.ldap.org, which had some good articles on the differences between SQL and LDAP. However, now when I go to ldap.org I get one of those stupid Ultimate Search pages. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message