Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 18 Dec 2002 12:54:03 -0500 (EST)
From:      Jason Hunt <leth@primus.ca>
To:        Lee Johnston <lee@wildcardinternet.co.uk>
Cc:        "Dave [Hawk-Systems]" <dave@hawk-systems.com>, <freebsd-isp@FreeBSD.ORG>
Subject:   RE: Web Based Control for FreeBSD (LDAP/MySQL)
Message-ID:  <20021218111756.W42746-100000@lethargic.dyndns.org>
In-Reply-To: <EBEOJMPKJEAGIGLPCFBBCEBJCAAA.lee@wildcardinternet.co.uk>

next in thread | previous in thread | raw e-mail | index | archive | help
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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20021218111756.W42746-100000>