Patterns

config files necessary to get OpenLDAP/MySQL working:
[root@ns01 ~]# cat /etc/odbc.ini
[MySQL]
Description = MySQL
Driver = MySQL
Trace = Yes
TraceFile = /var/log/mysql.odbc.log
Server = localhost
Port = 3306
Database = ldap_mysql
User = user
Password = password

[root@ns01 ~]# cat /etc/odbcinst.ini
[MySQL]
Description = MySQL Driver
Driver = /usr/lib/libmyodbc.so.2
Setup = /usr/lib/libodbcmyS.so
FileUsage = 1



[root@ns01 ~]# cat /etc/openldap/slapd.conf
# $OpenLDAP: pkg/ldap/servers/slapd/back-sql/rdbms_depend/mysql/slapd.conf,v 1.3.4.2 2004/01/20 23:44:21 kurt Exp $
#
# See slapd.conf(5) for details on configuration options.
# This file should NOT be world readable.
#
include /usr/share/openldap/schema/core.schema
include /usr/share/openldap/schema/cosine.schema
include /usr/share/openldap/schema/inetorgperson.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 secret
dbname MySQL
dbuser “user”
dbpasswd “password”
subtree_cond “ldap_entries.dn LIKE CONCAT(‘%’,?)”
insentry_query “INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval) VALUES (?,?,?,?)”
upper_func “upper”
strcast_func “text”
concat_pattern “?||?”
has_ldapinfo_dn_ru no