Re: (ITS#7499)

[benintechnologies@yahoo.fr]

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 ?

thanks
BT


Le 24/01/2013 00:39, quanah@zimbra.com a écrit :
> --On Wednesday, January 23, 2013 10:58 PM +0000 benintechnologies@yahoo.fr
> wrote:
>
>> I just noticed I forgot some infos, so here is the problem again :
>>
>> If I edit slapd.d/cn=config/olcDatabase={1}sql.ldif and I comment the
>> line starting with olcSqlInsEntryStmt, then slapd starts fine.
>>
>> So what's the right syntax for olcSqlInsEntryStmt ???
> > From the man page:
>
>
>         insentry_stmt<SQL expression>
> 	The statement that is used  to  insert  a  new  entry  in  table
> 	      ldap_entries;  see  "METAINFORMATION  USED"  for	details.   The
> 	      default is "INSERT INTO  ldap_entries  (dn,  oc_map_id,  parent,
> 	      keyval) VALUES (?, ?, ?, ?)".
>
> --Quanah
>
> --
>
> Quanah Gibson-Mount
> Sr. Member of Technical Staff
> Zimbra, Inc
> A Division of VMware, Inc.
> --------------------
> Zimbra ::  the leader in open source messaging and collaboration
>
>
>