Re: (ITS#7499)

[hyc@symas.com]

Benin Technologies wrote:
>   >>>>Yes, it's a bug. The conversion should have used double-quotes on these
>   >>>>parameters. Will be fixed shortly.
>
>
> ok thanks, I added manually the double-quotes on olcSqlInsEntryStmt in
> the file olcDatabase={1}sql.ldif, like this :
>
> olcSqlInsEntryStmt: "insert into ldap_entries (id,dn,oc_map_id,parent,keyval) values ((select max(id)+1 from ldap_entries),?,?,?,?)"
>
>
> Now slapd starts, but ldapsearch returns "80 Other (e.g., implementation
> specific error)". With the old "slapd.conf", ldapsearch works fine. Is
> there anything else to do when converting slapd.conf to cn=config on a
> back-sql implementation ?

Yes, actually the quotes are optional, but you must get the fix from git.
Commit 56a0d9004f0fba943028041ea5af62338b6dfccd
>
>
>
>
> Le 24/01/2013 02:44, hyc@symas.com a écrit :
>> benintechnologies@yahoo.fr wrote:
>>> Hi,
>>>
>>> thank you for your reply
>>>
>>> I simply took the slapd.conf file adapted to PostgreSQL in the source
>>> (/openldap-2.4.33/servers/slapd/back-sql/rdbms_depend/pgsql)
>>>
>>> In that file, we have :
>>> olcSqlInsEntryStmt: insert into ldap_entries
>>> (id,dn,oc_map_id,parent,keyval) values ((select max(id)+1 from
>>> ldap_entries),?,?,?,?)
>>>
>>> it works with static configuration (slapd.conf) : I successfully managed
>>> to insert some data into the postgresql tables
>>>
>>> But after having converted it to cn=config (slaptest -f slapd.conf -F
>>> slapd.d) slapd doesn't start anymore :
>>> 0ff3f0a<<<  dnPrettyNormal:<cn=root,dc=example,dc=com>,
>>> <cn=root,dc=example,dc=com>
>>> 50ff3f0a olcSqlInsEntryStmt: value #0:<olcSqlInsEntryStmt>  extra cruft
>>> after<SQL expression>.
>>> 50ff3f0a config error processing olcDatabase={1}sql,cn=config:
>>> <olcSqlInsEntryStmt>  *extra cruft after<SQL expression>*
>>> 50ff3f0a send_ldap_result: conn=-1 op=0 p=0
>>> 50ff3f0a send_ldap_result: err=19 matched="" text=""
>>> 50ff3f0a slapd destroy: freeing system resources.
>>> 50ff3f0a slapd stopped.
>>> 50ff3f0a connections_destroy: nothing to destroy.
>>>
>>> I believe it's a bug, no ?
>
>


-- 
   -- Howard Chu
   CTO, Symas Corp.           http://www.symas.com
   Director, Highland Sun     http://highlandsun.com/hyc/
   Chief Architect, OpenLDAP  http://www.openldap.org/project/