[Date Prev][Date Next]
how to use polyhedra db as a backend to LDAP (ITS#1171)
Full_Name: Moon-Sun, Kim
OS: sunOS 5.7
Submission from: (NULL) (22.214.171.124)
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'
, then I had an error.
The error is as this :
==>backsql_search(): base='O=SQL,C=RU', filter='(objectClass=*)', scope=2,
=0, attrsonly=0, attributes to load: all
backsql_open_db_conn(): connected, adding to tree
Constructed query: SELECT DISTINCT ldap_entries.id,persons.id, 'inetOrgPerson'
S objectClass, ldap_entries.dn AS dn FROM ldap_entries,persons WHERE
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
tries.id,persons.id, 'inetOrgPerson' as objectclass, ldap_entries.dn as dn from
ldap_entries,persons where persons.id=ldap_entries.keyval and
I think that the syntax of constructed query generated by slapd doesn't match
of polyhedra db.
my slapd.conf is as this:
suffix "o=sql, c=RU"
rootdn "cn=Manager, o=sql, c=RU"
subtree_cond "ldap_entries.dn LIKE '%'+?"
Does anybody know where I can get instructions on how to
please respond to me as soon as possible..