939792298 发表于 2016-01-07 11:27

在Centos下,将mysql数据库作为openldap的后台数据库,图中错误求解答,谢谢了

本帖最后由 939792298 于 2016-01-07 12:11 编辑



求各位大神帮我看下了:emn16:



1.操作iodbctest出现测错误

# iodbctest
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0709.0909

Enter ODBC connect string (? shows list): ?

DSN                              | Driver                                 
------------------------------------------------------------------------------
ldap                           | MySQL LDAP DSN                        

Enter ODBC connect string (? shows list): DSN=ldap
1: SQLDriverConnect = OB . rvrFie(0) SQLSTATE=l$
1: ODBC_Connect = OB . rvrFie  (0) SQLSTATE=

2.我的odbcinst.ini配置文件
# Example driver definitions


# Driver from the postgresql-odbc package
# Setup from the unixODBC package

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

Description   = ODBC for MySQL
Driver          = /usr/lib/libmyodbc5.so
Setup         = /usr/lib/libodbcmyS.so
Driver64      = /usr/lib64/libmyodbc5.so
Setup64         = /usr/lib64/libodbcmyS.so
FileUsage       = 1

3.这是我的odbc.ini 配置文件

ldap =MySQL LDAP DSN


Driver = /usr/lib64/libmyodbc5.so
Description = OpenLDAP Database
Host = localhost
ServerType = MySQL
Port = 3306
FetchBufferSize = 99
User = root
Password = 123456
Database = ldap
ReadOnly = no
CHARSET = UTF8
Socket = /var/lib/mysql/mysql.sock


InstallDir=/usr/lib64/


如何才能实现这样子的操作
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.




939792298 发表于 2016-01-07 12:24

:Q自己顶一下

939792298 发表于 2016-01-20 17:40

939792298 发表于 2016-01-20 17:41

939792298 发表于 2016-01-20 17:43

SeAL80s 发表于 2016-01-21 09:40

解决了,留下解决方案就好了.你知道现在QQ里基本都不讨论正事吗?
况且,加你QQ,还要等你验证,又多了一层手续,耽误了有相同问题者解决问题的时间.又不是什么保密/创新的东西,贴出来就好了
页: [1]
查看完整版本: 在Centos下,将mysql数据库作为openldap的后台数据库,图中错误求解答,谢谢了