[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
OpenLDAP and MySQL
Hello all,
I've been researching and attempting to get OpenLDAP and MySQL to play
nice together now for a little over a week. Unfortunately, I cannot get
them to do so (I've even threatened time out, but alas, they still
misbehave).
I've been following the HowTo here:
http://www.flatmtn.com/computer/Linux-LDAP.html only to find it lacking
major detail and non working config scripts. I've since started 'on my
own' and now slapd starts without any errors now. The problems are:
1. Short of no errors, I cant get any data INTO or OUT OF the LDAP server
2. As such, no user info can be authenticated
3. GUI's (yup, I've even tried them) such as phpLDAP have vague errors
such as:
Could not bind to the LDAP server.
LDAP said: Undefined attribute type
Error number: 0x11 (LDAP_UNDEFINED_TYPE)
Description: The attribute type specified is invalid.
My end goal for the first step is to have LDAP use MySQL as the DB, and
to authenticate SAMBA clients this way. The DB is necessary because I
already have a big database of user accounts/passwords for
IMAP/POP/SASL/Postfix that would be way too much of a pain to migrate
the accounts, then how they would be stored on the file system (phase
two is to have that username/password base authenticate the SAMBA
clients). Would anyone mind pointing me in the right direction with
getting LDAP-MySQL to work?
System: Slackware 10.0
OpenLDAP: 2.3.22
Samba: 3.0.22
MySQL: 4.0.24
MyODBC: 2.50.39 (3.51.12 compiled with way to many warnings and exited
on a few vague errors)
libiodbc: 3.52.4
slapd.conf
===
# $OpenLDAP:
pkg/ldap/servers/slapd/back-sql/rdbms_depend/mysql/slapd.conf,v 1.5.2.1
2005/01/20 18:04:03 kurt Exp $
#
# See slapd.conf(5) for details on configuration options.
# This file should NOT be world readable.
#
include /usr/local/etc/openldap/schema/core.schema
include /usr/local/etc/openldap/schema/cosine.schema
include /usr/local/etc/openldap/schema/inetorgperson.schema
include /usr/local/etc/openldap/schema/nis.schema
include /etc/openldap/schema/samba.schema
# Define global ACLs to disable default read access.
# Do not enable referrals until AFTER you have a working directory
# service AND an understanding of referrals.
#referral ldap://root.openldap.org
pidfile /usr/local/var/slapd.pid
argsfile /usr/local/var/slapd.args
#######################################################################
# sql database definitions
#######################################################################
database sql
suffix "o=sql,c=RU"
rootdn "cn=root,o=sql,c=RU"
rootpw >snip<
dbname ldap
dbuser root
dbpasswd >snip<
subtree_cond "ldap_entries.dn LIKE CONCAT('%',?)"
insentry_stmt "INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval)
VALUES (?,?,?,?)"
has_ldapinfo_dn_ru no
Thanks!