[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..