[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 !! :)
 




______________________________________

===================================================================