Re: (ITS#7499)
by 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(a)zimbra.com a écrit :
> --On Wednesday, January 23, 2013 10:58 PM +0000 benintechnologies(a)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
>
>
>