[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
question about openldap+mysql :(
Hi all:
I am trying to test my openlap-2.1.16 with backDB-mysql on
redhat8.0
before i install the openldap ,i have made the "unixodbc+MySQL
+MyODBC" worked very well on my rh8.0 ,but i do not have access suite such as OpenLink DAS(i dont known what it is?)
next,with the directives of openldap-2.1.16/servers/slapd/back-sql/docs/install ,i have run testdb_create.sql,testdb_data.sql, and testdb_metadata.sql scripts
and i can see the database and tables created in mysql server.
then i add the fowllings to slapd.conf
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
database sql
suffix "o=sql,c=RU"
rootdn "cn=root,o=sql,c=RU"
rootpw secret
dbname ldap_mysql
dbuser root
dbpasswd NULL
subtree_cond "ldap_entries.dn LIKE CONCAT('%',?)"
insentry_query "INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval) VALUES (?,?,?,?)"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
and set "odbc.ini" adding
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[sql]
Description = myodbc-openldap
Driver = myodbc
Server = localhost
Database = ldap_mysql
Port = 3306
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
then i try to run : /usr/local/libexec/slapd -d 5
and encounter connection problems as following
*************************************************
<<< dnPrettyNormal: <cn=root,o=sql,c=RU>, <cn=root,o=sql,c=ru>
==>backsql_db_config()
<==backsql_db_config(): dbname=ldap_mysql
==>backsql_db_config()
<==backsql_db_config(): dbuser=root
==>backsql_db_config()
<==backsql_db_config(): dbpasswd=xxxx
==>backsql_db_config()
<==backsql_db_config(): subtree_cond=ldap_entries.dn LIKE CONCAT('%',?)
==>backsql_db_config()
<==backsql_db_config(): insentry_query=INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval) VALUES (?,?,?,?)
matching_rule_use_init .......
... ...
slapd startup: initiated.
bdb_db_open: dbenv_open(/usr/local/var/openldap-data)
==>backsql_db_open(): testing RDBMS connection
backsql_db_open(): concat func not specified (use "concat_pattern" directive in slapd.conf)
backsql_db_open(): setting 'ldap_entries.dn=?' as default
backsql_db_open(): objectclass mapping SQL statement not specified (use "oc_query" directive in slapd.conf)
backsql_db_open(): setting 'SELECT id,name,keytbl,keycol,create_proc,delete_proc,expect_return FROM ldap_oc_mappings' by default
backsql_db_open(): attribute mapping SQL statement not specified (use "at_query" directive in slapd.conf)
backsql_db_open(): setting 'SELECT name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return,sel_expr_u FROM ldap_attr_mappings WHERE oc_map_id=?' by default
backsql_db_open(): entry deletion SQL statement not specified (use "delentry_query" directive in
slapd.conf)
backsql_db_open(): setting 'DELETE FROM ldap_entries WHERE id=?' by default
==>backsql_get_db_conn()
==>backsql_open_db_conn()
backsql_open_db_conn: SQLConnect() to database 'ldap_mysql' as user 'root' failed:
Return code: -1
Native error code: 0
SQL engine state: IM002
Message: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
backsql_get_db_conn(): could not get connection handle -- returning NULL
backsql_db_open(): connection failed, exiting
backend_startup: bi_db_open(1) failed! (1)
***************************************************
i know how to do now ,would you please help me ?
thanks !! :)
______________________________________
===================================================================