Mysql+ODBC+OpenLDAP

# 1、安装相关软件
yum install wget unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel -y
yum install mysql-connector-odbc autoconf automake cmake freetype-devel gcc gcc-c++ git libtool make groff -y

yum -y install mysql-server
service mysqld start
chkconfig mysqld on

mysql_secure_installation

mysql -uroot -pdsideal
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
CREATE USER 'ldap'@'%' IDENTIFIED BY 'ldap';
GRANT ALL PRIVILEGES ON ldap.* TO 'ldap'@'%';
CREATE USER 'ldap'@'localhost' IDENTIFIED BY 'ldap';
GRANT ALL PRIVILEGES ON ldap.* TO 'ldap'@'localhost';
FLUSH PRIVILEGES;
show databases;


# 2、开始配置ODBC
vi /etc/odbcinst.ini
#=======================================================
# Example driver definitions

# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description     = ODBC for PostgreSQL
Driver          = /usr/lib/psqlodbc.so
Setup           = /usr/lib/libodbcpsqlS.so
Driver64        = /usr/lib64/psqlodbc.so
Setup64         = /usr/lib64/libodbcpsqlS.so
FileUsage       = 1


# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib64/libmyodbc5.so
Setup = /usr/lib64/libodbcmyS.so
FileUsage = 1
#====================================================
vi /etc/odbc.ini

[mysql]
Description           = MySQL connection to 'asterisk' database
Driver                = MySQL
Database              = openldap
Server                = 127.0.0.1
UserName              = root
Password              = dsideal
Port                  = 3306
Socket                = /var/lib/mysql/mysql.sock
charset               = UTF8
option                = 3
#======================================
# 测试UnixODBC的安装正确性
echo "select 1" | isql -v mysql
#======================================
# 3、安装OpenLDAP
cd /opt
wget ftp://ftp.openldap.org/pub/OpenLDAP/openldap-release/openldap-2.4.45.tgz
tar xvfz openldap-2.4.45.tgz
rm -rf openldap-2.4.45.tgz
mv openldap-2.4.45 openldap
cd /opt/openldap
./configure --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var --mandir=/usr/share/man --infodir=/usr/share/info --enable-sql --disable-bdb --disable-ndb --disable-hdb
make depend
make && make install

此时安装已经完成，接着配置LDAP，首先生成自己的LDAP密码：

slappasswd

我获取了：{SSHA}j5cp4ebCG79mcx/5jdM6dL+XtJ0ztlKs

vi /etc/openldap/slapd.conf

#在第5行下面添加如下内容
include         /etc/openldap/schema/cosine.schema
include         /etc/openldap/schema/inetorgperson.schema

#修改第55行内容
database sql
#修改第56、57行的dc值（这里最好设置为example，因为后面要用ldap的数据库数据，如果这里使用别的值，那么对应的要把数据库中的所有dn都改掉）
suffix "dc=example,dc=com"
rootdn "cn=Manager,dc=example,dc=com"

#修改第61行rootpw的值，就是之前获取到的加密密码
rootpw {SSHA}j5cp4ebCG79mcx/5jdM6dL+XtJ0ztlKs

#注释掉第65、67行的内容
#directory /var/openldap-data
#index objectClass eq
#在第61行rootpw下面添加如下内容
rootpw {SSHA}XDEtT6s3MTzrSbHeJl7OlRoqk0w1By1X
dbname ldap
dbuser ldap
dbpasswd ldap
has_ldapinfo_dn_ru no
subtree_cond "ldap_entries.dn LIKE CONCAT('%',?)"


mysql -uldap -pldap
CREATE DATABASE IF NOT EXISTS ldap;
use ldap;
source /opt/openldap/servers/slapd/back-sql/rdbms_depend/mysql/backsql_create.sql
source /opt/openldap/servers/slapd/back-sql/rdbms_depend/mysql/testdb_create.sql
source /opt/openldap/servers/slapd/back-sql/rdbms_depend/mysql/testdb_data.sql
source /opt/openldap/servers/slapd/back-sql/rdbms_depend/mysql/testdb_metadata.sql

此时运行LDAP
/opt/openldap/servers/slapd/slapd -d 5 -h 'ldap:/// ldapi:///' -f /etc/openldap/slapd.conf &