Setting up OpenLDAP with MySQL backend 用mysql作后臺(tái)數(shù)據(jù)庫安裝openldap author: TBONIUS OpenLDAP is an X.500 Lightweight Directory Access Server used for centralized authentication and directory lookups. This article covers configuring this

Setting up OpenLDAP with MySQL backend

用mysql作后臺(tái)數(shù)據(jù)庫安裝openldap

author: TBONIUS

OpenLDAP is an X.500 Lightweight Directory Access Server used for

centralized authentication and directory lookups. This article covers configuring this service to utilize SQL services in order to store its data object. Having these objects stored in a SQL database allow for third party applications access to manage these objects.

openldap是一個(gè)基于x.500協(xié)議用來集中認(rèn)證和目錄搜索的級(jí)目錄訪問服務(wù)器。這篇文章包含的內(nèi)容是：利用sql服務(wù)來配置這個(gè)服務(wù)器 ，用來保存對(duì)象和數(shù)據(jù)。允許第三方應(yīng)用訪問、管理這些保存在SQL數(shù)據(jù)庫里的對(duì)象。

Ports that are needed:

需要的ports有：

MySQL 4.x server : /usr/ports/databases/mysql41-server

MySQL 4.x client : /usr/ports/databases/mysql41-client

LibIODBC 3.x : /usr/ports/databases/libiodbc

MyODBC 3.x : /usr/ports/databases/myodbc

OpenLDAP 2.x : /usr/ports/databases/openldap21-server WITH_ODBC="YES"

Configuring the MySQL server

配置mysql服務(wù)器

OpenLDAP has the option to use many different kinds of databases, in this case we will use MySQL. The first step in setting this up is to create a MySQL database for which OpenLDAP will use.

openldap可選很多不同種類的數(shù)據(jù)庫。在這種情況下，我將使用mysql。要完成這個(gè)任務(wù)的第一步是建立一個(gè)openldap將要使用的mysql數(shù)據(jù)庫

root@host # mysqladmin create ldap

Next we will create a MySQL account that OpenLDAP will use for our newly created ldap database

下面我將建立一個(gè)openldap會(huì)用的mysql帳號(hào),對(duì)應(yīng)我們新建立的ldap數(shù)據(jù)庫。

root@host # mysql

Welcome to the MySQL monitor. Commands end with ; or g.

Your MySQL connection id is 10 to server version: 4.0.18

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql>;grant all privileges on ldap.* to 'ldap'@'localhost'

->;identified by 'password' with grant option;

Query OK, 0 rows affected (0.13 sec)

We of course want to substitute 'password' with the actual password we wish to use for this particular user account

對(duì)特定的用戶帳號(hào)，我們當(dāng)然想用我們真正想用的密碼替換'password'。

Configuring LibIODBC to use the MyODBC driver

配置LibODBC使用MyODBC驅(qū)動(dòng)。

Quite simply we need to edit two file here to get LibODBC to use the MyODBC driver in accessing the MySQL server.

事實(shí)上我們只需要簡(jiǎn)單得修改這里的兩個(gè)文件就可讓LibODBC使用MyODBC驅(qū)動(dòng)來訪問MySQL服務(wù)器。

Take a look at the /usr/local/etc/libiodbc/odbcinst.ini file and make the following changes

看看這個(gè)文件/usr/local/etc/libiodbc/odbcinst.ini并修改內(nèi)容：

[ODBC Drivers]

MySQL = Installed

[MySQL]

Description=ODBC for MySQL

Driver=/usr/local/lib/libmyodbc3.so

Take a look at the /usr/local/etc/libiodbc/odbc.ini and make the following changes

看看這個(gè)文件/usr/local/etc/libiodbc/odbc.ini并作如下修改：

[ODBC Data Sources]

ldap = MySQL LDAP DSN

[ldap]

Driver = /usr/local/lib/libmyodbc3.so

Description = OpenLDAP Database

Host = localhost

ServerType = MySQL

Port = 3306

FetchBufferSize = 99

User = ldap

Password = password

Database = ldap

ReadOnly = no

Socket = /tmp/mysql.sock

[ODBC]

InstallDir=/usr/local/lib

Again, substitute password for the actual password we created for the ldap user of the MySQL database.

再次，為我們?cè)趍ysql數(shù)據(jù)庫建立的ldap用戶的密碼。

We can test our current configuration before installing and configuring OpenLDAP. LibIODBC provides a test utility to check DSN configurations.

在安裝配置openldap以前，，我們可以測(cè)試我們當(dāng)前的配置。LibIODBC提供了檢測(cè)DSN配置的測(cè)試工具。

Note from darxpryte: Upon following this tutorial I've found that iodbctest was not built automatically. This may be fixed later but if you find this to be the case you'll need to do the following:

darxpryte提示：在這篇指南的下面，我發(fā)現(xiàn)iodbctest沒有自動(dòng)建立，以后或許會(huì)修正這個(gè)問題，不過如果你需要如此的話，按照修面的操作：

cd /usr/ports/databases/libiodbc/

make extract

cd work/libiodbc-3.52.2/samples

make install

This will install iodbctest into /usr/local/bin/

這將把iodbctest安裝到/usr/local/bin/

Once you install iodbctest, you can do the following to test your connection:

一旦你安裝了iodbctest，你就可以安裝下面的方法來測(cè)試你的連接：

root@host # iodbctest

iODBC Demonstration program

This program shows an interactive SQL processor

Driver Manager: 03.51.0001.0908

Enter ODBC connect string (? shows list): ?

DSN | Description

---------------------------------------------------------------

ldap | MySQL LDAP DSN

Enter ODBC connect string (? shows list):DSN=ldap

Driver: 03.51.06

SQL>;show tables;

Tables_in_ldap

---------------------

authors_docs

documents

institutes

ldap_attr_mappings

ldap_entries

ldap_entry_objclasses

ldap_oc_mappings

ldap_referrals

persons

phones

result set 1 returned 10 rows.

This shows us that the DSN is configured correctly for LibIODBC to use the MyODBC driver in order to connect to our ldap database we set up on our MySQL Server

這表示，DSN已經(jīng)為L(zhǎng)ibIODBC配置好使用MyODBC驅(qū)動(dòng)，好用來連接到我們?cè)趍ysql服務(wù)器上安裝的ldap數(shù)據(jù)庫。

If you have problems displaying the DSN names defined in the odbc.ini file via the test program, try exporting the following shell environmental variable:

如果你通過測(cè)試程序時(shí)有問題(顯示定義在odbc.ini里面的DSN名字)，嘗試輸入下面的shell環(huán)境變量：

For csh or tcsh:

對(duì)于csh或者tcsh:

setenv ODBCINI /usr/local/etc/libiodbc/odbc.ini

For sh or bash:

對(duì)于sh或者bash:

export ODBCINI=/usr/local/etc/libiodbc/odbc.ini

Configuring OpenLDAP to use MySQL

配置openldap使用mysql

During the build of OpenLDAP, we need to pass the WITH_ODBC="YES" option so that the server build the appropriate SQL configurations

在編譯openldap的時(shí)候，我們需要跳過　WITH_ODBC="YES"選項(xiàng)，這樣，服務(wù)器編譯專用的sql配置。

After the make install process, we will copy over the slapd.conf file that is configured to use a SQL backend. This file is buried under the OpenLDAP ports directory in the following path:

在安裝過程完畢后，我們將復(fù)制使用SQL作后臺(tái)的slapd.conf文件，這個(gè)文件在openldap的ports目錄的下面的路徑中生成：

work/openldap-2.1.30/servers/slapd/back-sql/rdbms_depend/mysql

Change to this directory, from the ports directory of OpenLDAP, and copy the configuration file over

>; cp slapd.conf /usr/local/etc/openldap

Then we can import the back SQL file from this directory into our running MySQL server database

root@host # mysql < backsql_create.sql ldap

root@host # mysql < testdb_create.sql ldap

Optionally we can import the testdb_data and testdb_metadata files into the database so that we can have example data with which to work

本條技術(shù)文章來源于互聯(lián)網(wǎng)，如果無意侵犯您的權(quán)益請(qǐng)點(diǎn)擊此處反饋版權(quán)投訴

本文系統(tǒng)來源：php中文網(wǎng)

總結(jié)

以上是生活随笔為你收集整理的openldap范例数据库mysql_用mysql作openldap的后台数据库的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。