[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