[Date Prev][Date Next]
Re: Question about Openldap+Oracle10g
It seemed this problem had been solved.
But I cannot search it by ldapsearch command.
# extended LDIF
# base <o=fjh,c=jp> with scope sub
# filter: objectclass=*
# requesting: ALL
# search result
result: 0 Success
# numResponses: 1
By Openlink Oracle Driver, for using SQLForeignKeys and
SQLPrimaryKeys functions, run odbccat10.sql is necessary.
Now the searching can be executed.
I'm glad you made it.
This problem has not been solved.
Continued, add an entry "cn=test,o=fjh,c=jp", so the error below
adding new entry "cn=test,o=fjh,c=jp"
ldap_add: Internal (implementation specific) error (80)
additional info: SQL-backend error
Look debug log, I found:
<= root access granted
backsql_add("cn=test,o=fjh,c=jp"): executing "call create_person(?)"
backsql_add("cn=test,o=fjh,c=jp"): create_proc execution failed
Return code: -1
Native error code: 0
SQL engine state: 07001
Message: [OpenLink][ODBC][Driver]Wrong number of parameters
send_ldap_result: conn=0 op=1 p=3
send_ldap_result: err=80 matched="" text="SQL-backend error"
By read the explanation of "Wrong number of parameters", I'm not sure maybe
the sql definition or back-sql has sth. wrong.
I'd guess the problem is in the "create_proc" field you stored in table
ldap_oc_mappings for that objectClass; in fact, the create procedure
doesn't take any input parameters, and may return the ID of the newly
created row if the "expect_return" flag is set for the ADD operation
(i.e. expect_return |= 0x1). The template call that's shown in your
logs, "call create_person(?)", looks incorrect. It should rather be
"call create_preson()", like in the PostgreSQL example.
SysNet - via Dossi,8 27100 Pavia Tel: +390382573859 Fax: +390382476497