[Date Prev][Date Next] [Chronological] [Thread] [Top]

problem with database sql for ldap




Hi 

i am using openldap-2.0-15  with backend mysql.
i have installed mysql already 
and added the data according to the concept file of
doc

 i have installed the following rpms

libiodbc-2.50-3
libiodbc-devel-2.50-3

Extracted the tar
openldap-2.0-15.tar

cd openldap-2.0-15

./configure --enable-sql 

make depend
make
make install
make test

edit /etc/odbc.ini file 

edit slapd.cong file

add /usr/local/lin into /etc/ld.so.conf file

and started the slapd server but :-((
did not work. can anyone tell me where am i going
wrong
Help please


###########################################

;  odbc.ini
;
[ODBC Data Sources]
OpenLink = OpenLink (MT)

[OpenLink]
Driver          = /usr/lib/libiodbc.so.2
Description     = Sample OpenLink MT DSN
Host            = localhost
ServerType      = MySQL 
FetchBufferSize = 99
UserName        = mmmm
Password        = mmmm
Database        = ldap_mysql
ServerOptions   = 
ConnectOptions  = 
Options         = 
TraceFile       = /tmp/odbc.trace
Trace           = 1
ReadOnly        = no

[Default]
;Driver = /home/openlink/lib/oplodbc.so.1
Driver          = /usr/lib/libiodbc.so.2


##########################################################



include        
/usr/local/etc/openldap/schema/core.schema
include        
/usr/local/etc/openldap/schema/cosine.schema
include        
/usr/local/etc/openldap/schema/inetorgperson.schema

pidfile         /usr/local/var/slapd.pid
argsfile        /usr/local/var/slapd.args

# Load dynamic backend modules:
# modulepath    /usr/local/libexec/openldap
# moduleload    back_ldap.la
# moduleload    back_ldbm.la
# moduleload    back_passwd.la
# moduleload    back_shell.la

database        sql
suffix          "dc=ldapsql,dc=com"
rootdn          "cn=Manager,dc=ldapsql,dc=com"
rootpw          secret


#dbname         /usr/lib/libiodbc.so
dbname          OpenLink


dbuser          dist
dbpasswd        operator
oc_query        "SELECT
id,name,keytbl,keycol,create_pro


at_query        "SELECT
name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return
FROM ldap_attr_mappings WHERE oc_map_id=?"

subtree_cond   "ldap_entries.dn LIKE CONCAT('%',?)"

insentry_query  "INSERT INTO ldap_entries
(dn,oc_map_id,parent,keyval) VALUES (?,?,?,?)"
delentry_query  "DELETE FROM ldap_entries WHERE id=?"

#####################################################

ouptput of slapd run under debug mode of 5
@(#) $OpenLDAP: slapd 2.0.15-Release (Tue Nov 20
13:35:49 IST 2001) $
       
root@l1000:/tesri/openldap-2.0.15/servers/slapd
daemon_init: ldap://l1000
daemon_init: listen on ldap://l1000
daemon_init: 1 listeners to open...
ldap_url_parse_ext(ldap://l1000)
daemon: initialized ldap://l1000
daemon_init: 1 listeners opened
l1000 init: initiated server.
==>backsql_initialize()
<==backsql_initialize()
==>backsql_db_init()
==>backsql_init_db_env()
<==backsql_init_db_env()
<==backsql_db_init()
==>backsql_db_config()
<==backsql_db_config(): dbname=OpenLink
==>backsql_db_config()
<==backsql_db_config(): dbuser=mmmm
==>backsql_db_config()
<==backsql_db_config(): dbpasswd=mmmm
==>backsql_db_config()
<==backsql_db_config(): oc_query=SELECT
id,name,keytbl,keycol,create_proc,delete_proc,expect_return
FROM ldap_oc_mappings
==>backsql_db_config()
<==backsql_db_config(): at_query=SELECT
name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return
FROM ldap_attr_mappings WHERE oc_map_id=?
==>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
(?,?,?,?)
==>backsql_db_config()
<==backsql_db_config(): delentry_query=DELETE FROM
ldap_entries WHERE id=?
l1000 startup: initiated.
==>backsql_db_open(): testing RDBMS connection
==>backsql_get_db_conn()
==>backsql_open_db_conn()



regards 
reeti