Re: sql-backend

[Otto Kucera <ok@72pixel.at>]

hi!

thanx for your answer :)

Pierangelo Masarati wrote:

> > but there is a new problem :(
> >
> > openldap # ldapadd -D "cn=manager,dc=sql,dc=hosting" -W -f base21.ldif
> > Enter LDAP Password:
> > adding new entry "dc=sql, dc=hosting"
> > ldapadd: update failed: dc=sql, dc=hosting
> > ldap_add: Server is unwilling to perform (53)
> >        additional info: operation not permitted within namingContext
> >
> > other people posted this problem but never a solution. what did you
> > do?
> >    
>
> Can you show the base21.ldif contents and a full log
> of the server?  You should admit that the amount of
> information you're revealing is of very scarce help.
> A mention of the version of OpenLDAP's slapd could be
> of use, even though back-sql doesn't change quite often.
>
> p.
>
>  
ok the base21.ldif:
dn: dc=sql, dc=hosting
objectclass: dcObject
objectclass: organization
o: geeks.at
dc: sql

this worked for my other database base21.ldif:
dn: dc=my, dc=hosting
objectclass: dcObject
objectclass: organization
o: geeks.at
dc: my

i toke this form the offical guide 
(http://www.openldap.org/doc/admin21/guide.html)


slapd.conf:
[...]
#######################################################################
# ldbm database definitions
#######################################################################

database        bdb
suffix          "dc=my,dc=hosting"
rootdn          "cn=Manager,dc=my,dc=hosting"
rootpw          {CRYPT}crFvPJwvnpm3U
directory       /var/lib/openldap-data
Indices to maintain
index   objectClass     eq


#######################################################################
# sql database definitions
#######################################################################
database        sql
# suffix                "o=sql,c=RU"
# rootdn                "cn=Manager,o=sql,c=RU"
suffix          "dc=sql,dc=hosting"
rootdn          "cn=manager,dc=sql,dc=hosting"
rootpw          {MD5}5WRd2F3rEA/R1x0OjWcQkQ==
dbname          ldap
dbuser          ldap
dbpasswd        ldap
subtree_cond    "ldap_entries.dn LIKE CONCAT('%',?)"
insentry_query  "INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval) 
VALUES (?,?,?,?)"
upper_func      "upper"
strcast_func    "text"
concat_pattern  "?||?"

os is gentoo linux with openldap21.1.23 witch is build:

emerge -pv openldap-2.1.23.ebuild

These are the packages that I would merge, in order:

Calculating dependencies ...done!
[ebuild   R   ] net-nds/openldap-2.1.23  +berkdb +crypt -debug +gdbm 
-ipv6 -kerberos +odbc +perl +readline +samba +sasl -slp +ssl +tcpd

otto

--
-----------------------------------
Otto Kucera
A-1020 Wien Engerthstrasse 137/6/7
Tel: +43 699 1 942 30 91 [neue Nummer!]
Email: ok@72pixel.at
Icq: 65351173
-----------------------------------

And root said rm -rf /     ......and there was nothing
*BSD is like a wigwam: NO windows, NO gates and an Apache inside!

Your mailserver MUST resolve properly (Fully Qualified Domain Name) or the
mail will not go through!