[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
how to use polyhedra db as a backend to LDAP (ITS#1171)
Full_Name: Moon-Sun, Kim
Version: 2.0.7
OS: sunOS 5.7
URL:
Submission from: (NULL) (211.216.216.37)
Hi..
I would like to know how to use Polyhedra DB as a backend to OpenLDAP,
I can't find this issue in mailing lists.
I installed poly4.0 and iodbc 2.50.3.
I made the tables of polyhedra and metadata
based upon the examples in /servers/back-sql/rdbms_depend/mysql
After running slapd, I ran the command of ldapsearch -b 'o=sql, c=RU'
'(objectclass=*)'
, then I had an error.
The error is as this :
==>backsql_search(): base='O=SQL,C=RU', filter='(objectClass=*)', scope=2,
deref
=0, attrsonly=0, attributes to load: all
==>backsql_get_db_conn()
==>backsql_open_db_conn()
backsql_open_db_conn(): connected, adding to tree
<==backsql_open_db_conn()
<==backsql_get_db_conn()
==>backsql_oc_get_candidates(): oc='inetOrgPerson'
==>backsql_srch_query()
==>backsql_process_filter()
<==backsql_process_filter()
<==backsql_srch_query()
Constructed query: SELECT DISTINCT ldap_entries.id,persons.id, 'inetOrgPerson'
A
S objectClass, ldap_entries.dn AS dn FROM ldap_entries,persons WHERE
persons.id=
ldap_entries.keyval AND ldap_entries.oc_map_id=? AND ldap_entries.dn LIKE '%'+?
AND NOT ('inetOrgPerson' IS NULL)
backsql_oc_get_candidates(): error executing query
Return code: -1
Native error code: -2080374432
SQL engine state: HY000
Message: [Polyhedra][ODBC Driver]syntax error at line 1: select distinct
ldap_en
tries.id,persons.id, 'inetOrgPerson' as objectclass, ldap_entries.dn as dn from
ldap_entries,persons where persons.id=ldap_entries.keyval and
ldap_entries.oc_ma
p_id=:<integer...
I think that the syntax of constructed query generated by slapd doesn't match
the syntax
of polyhedra db.
my slapd.conf is as this:
include /usr/local/ldap/etc/openldap/schema/core.schema
include /usr/local/ldap/etc/openldap/schema/cosine.schema
include /usr/local/ldap/etc/openldap/schema/inetorgperson.schema
database sql
suffix "o=sql, c=RU"
rootdn "cn=Manager, o=sql, c=RU"
rootpw secret
dbhost localhost
dbport 8002
dbname tcp/211.192.212.182:8002
dbuser SYSTEM
dbpasswd system
subtree_cond "ldap_entries.dn LIKE '%'+?"
Does anybody know where I can get instructions on how to
do this?
please respond to me as soon as possible..
thanks..