一、安装依赖包yum -y install unixODBC.x86_64 unixODBC-devel.x86_64 libdbi-devel.x86_64 libdbi.x86_64 libdbi-dbd-mysql.x86_64 openssl openssl-devel
二、安装mysqlyum -y install mysql-server mysql mysql-connector-odbc.x86_64
1、启动MySQL服务/etc/init.d/mysqld start
2、配置开机自启动chkconfig mysqld on
3、初始化MySQL密码mysql_secure_installation
4、创建openldap所需要的数据库mysql> create database sso;
mysql> grant all privileges on sso.* to openldap@'localhost' identified by 'openldap'; mysql> grant all privileges on sso.* to openldap@'127.0.0.1' identified by 'openldap'; mysql> flush privileges;
5、依次导入范例数据库cd /usr/share/doc/openldap-servers-sql-2.4.40/rdbms_depend/mysql
mysql -uopenldap -popenldap sso
6、配置ODBC此处我测试使用的远程主机上的数据库
vim /etc/odbc.ini [ldap] Description = The Database for mysql Trace = On TraceFile = stderr Driver = MySQL SERVER