OpenLdap配置mysql作为后台数据库&phpldapadmin搭建

OpenLdap配置mysql作为后台数据库&phpldapadmin搭建

一、安装依赖包

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

二、安装mysql

1. 下载和安裝mysql源

//下载源
wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
//安装源
yum -y localinstall mysql80-community-release-el7-1.noarch.rpm

2. 在线安装Mysql

yum -y install mysql-community-server

3. 启动Mysql

//启动mysql服务
systemctl start mysqld
//查看进程
ps -ef |grep mysql
//设置开机自启动
systemctl enable mysqld

4. 修改root登录密码，设置Mysql可远程访问
   mysql安裝完成之後，在/var/log/mysqld.log文件中給root生成了一个临时的默认密码，用grep命令搜一下

   grep -R "password" /var/log/mysqld.log 
   //2019-08-14T07:15:07.717147Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: yourpassword
   

   通过root临时密码进入数据库：

   mysql -u root -p yourpassword
   

   修改密码：

   alter user 'root'@'localhost' identified by 'newpassword';
   

   开启远程访问：

   update mysql.user set host='%' where user='root';
   flush privileges;
   

5. 创建openldap所需的mysql数据库

   mysql> create database ldap;
   mysql> CREATE USER 'ldap'@'%' IDENTIFIED BY 'ldap';
   mysql> GRANT ALL PRIVILEGES ON ldap.* TO 'ldap'@'%';
   //查看创建的数据库
   mysql> show databases;
   

三、安装配置ODBC驱动

1. 安装 ODBC

yum install unixODBC mysql-connector-odbc

2. 配置ODBC
   打开配置文件

vim /etc/odbc.ini

//添加如下内容：
[ldap]
Description = LdapToMysql
Driver = MySQL
Database = ldap
Server = localhost
User = ldap
Password = ldap
Port = 3306
charset