[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Re[2]: OpenLDAP + pgSQL
Hello Luca,
Wednesday, May 12, 2004, 10:48:22 AM, you wrote:
Just added.
Doesn't not help.
LS> I would try including the back_sql module.
LS> just my 2 cents
LS> Dev Zero G disse:
>> Hello,
>>
>> I try to explain the whole problem.
>>
>> I have FreeBSD 4.9-R, OpenLDAP 2.2.10-server and PostgreSQL 7.4
>>
>> Here's list of slapd.conf:
>>
>> #
>> # See slapd.conf(5) for details on configuration options.
>> # This file should NOT be world readable.
>> #
>> include /usr/local/etc/openldap/schema/core.schema
>> include /usr/local/etc/openldap/schema/cosine.schema
>> include /usr/local/etc/openldap/schema/corba.schema
>> include /usr/local/etc/openldap/schema/inetorgperson.schema
>> include /usr/local/etc/openldap/schema/java.schema
>> #include /usr/local/etc/openldap/schema/krb5-kdc.schema
>> #include
>> /usr/local/etc/openldap/schema/kerberosobject.schema
>> include /usr/local/etc/openldap/schema/misc.schema
>> include /usr/local/etc/openldap/schema/nis.schema
>> include /usr/local/etc/openldap/schema/openldap.schema
>> include /usr/local/etc/openldap/schema/samba.schema
>>
>> # Define global ACLs to disable default read access.
>>
>> # Do not enable referrals until AFTER you have a working directory #
>> service AND an understanding of referrals.
>> #referral ldap://root.openldap.org
>>
>> pidfile /var/run/openldap/slapd.pid
>> argsfile /var/run/openldap/slapd.args
>>
>> defaultsearchbase dc=some,dc=domain,dc=com
>>
>> # Load dynamic backend modules:
>> modulepath /usr/local/libexec/openldap
>> moduleload back_bdb.la
>> moduleload back_ldap.la
>> moduleload back_ldbm.la
>> moduleload back_passwd.la
>> moduleload back_shell.la
>>
>> # Timeout in seconds, 0 = never
>> idletimeout 0
>> threads 32
>> # Debuging level, 0 = none
>> loglevel 64
>>
>> access to *
>> by self write
>> by * read
>> access to * by dn="cn=admin,dc=some,dc=domain,dc=com" write
>>
>> security ssf=1 update_ssf=112 simple_bind=64
>>
>> access to dn.base="" by * read
>> access to dn.base="cn=Subschema" by * read
>> access to *
>> by self write
>> by users read
>> by anonymous auth
>>
>> allow bind_v2
>>
>> database sql
>> suffix "dc=some,dc=domain,dc=com"
>> rootdn "cn=admin,dc=some,dc=domain,dc=com"
>> rootpw secret
>> dbname pg_ldap
>> dbuser test
>> dbpasswd test
>> lastmod off
>> insentry_query "insert into ldap_entries
>> (id,dn,oc_map_id,parent,keyval) values ((select max(id)+ upper_func
>> "upper"
>> strcast_func "text"
>> concat_pattern "?||?"
>> has_ldapinfo_dn_ru no
>>
>> #Specify ciphers
>> TLSCipherSuite HIGH:MEDIUM:+SSLv2:+SSLv3
>> #TLS keyfile locations
>> TLSCertificateFile /etc/ldap/slapd_cert.pem
>> TLSCertificateKeyFile /etc/ldap/slapd_key.pem
>>
>> #Sasl
>> sasl-host localhost
>>
>> PostgreSQL configured by default.
>>
>> Here's what I have in logs:
>> May 12 09:48:35 palladium-bsd slapd[287]: @(#) $OpenLDAP:
>> slapd 2.2.10(May 11 2004 09:41:45) $
>> root@palladium-bsd.ua.devzerog.com:/usr/ports/net/openldap22-server/work/openldap-2.2.10/servers/slapd
>> May 12 09:48:35 palladium-bsd /kernel: May 12 09:48:35 palladium-bsd May
>> 12 09:48:35 palladium-bsd slapd[287]: bdb_initialize: Sleepycat
>> Software: Berkeley DB 4.2.52: (December 3, 2003)
>> May 12 09:48:35 palladium-bsd /kernel: May 12 09:48:35 palladium-bsd
>> slapd[287]: bdb_initialize: Sleepycat Software: Berkeley DB 4.2.52:
>> (December 3, 2003) May 12 09:48:35 palladium-bsd slapd[287]:
>> bdb_initialize: Sleepycat Software: Berkeley DB 4.2.52: (December 3,
>> 2003)
>> May 12 09:48:35 palladium-bsd slapd[287]: line 44 (access to *
>> by self write by * read)
>> May 12 09:48:35 palladium-bsd /kernel: May 12 09:48:35 palladium-bsd
>> slapd[287]: bdb_initialize: Sleepycat Software: Berkeley DB 4.2.52:
>> (December 3, 2003) May 12 09:48:35 palladium-bsd /kernel: May 12
>> 09:48:35 palladium-bsd slapd[287]: line 44 (access to * by self
>> write by * read) May 12 09:48:35 palladium-bsd slapd[287]: line
>> 45 (access to * by
>> dn="cn=admin,dc=some,dc=domain,dc=com" write)
>> May 12 09:48:35 palladium-bsd slapd[287]: line 138 (database sql)
>> May 12 09:48:35 palladium-bsd /kernel: May 12 09:48:35 palladium-bsd
>> slapd[287]: line 140 (suffix "dc=some,dc=domain,dc=com")
>> May 12 09:48:35 palladium-bsd /kernel: May 12 09:48:35 palladium-bsd
>> slapd[287]: line 142 (rootdn
>> "cn=root,dc=some,dc=domain,dc=com")
>> May 12 09:48:35 palladium-bsd slapd[287]: line 144 (rootpw ***)
>> May 12 09:48:35 palladium-bsd slapd[287]: line 145 (dbname
>> pg_ldap) May 12 09:48:35 palladium-bsd slapd[287]: line 146 (dbuser
>> test) May 12 09:48:35 palladium-bsd slapd[287]: line 147 (dbpasswd
>> ***)
>> May 12 09:48:35 palladium-bsd slapd[287]: line 148 (lastmod off)
>> May 12 09:48:35 palladium-bsd slapd[287]: line 149 (insentry_query
>> "insert into ldap_entries (id,dn,oc_map_id,parent,keyval) values
>> ((select max(id)+1 from ldap_entries),?,?,?,?)") May 12 09:48:35
>> palladium-bsd slapd[287]: line 150 (upper_func "upper") May 12
>> 09:48:35 palladium-bsd slapd[287]: line 151 (strcast_func "text") May
>> 12 09:48:35 palladium-bsd slapd[287]: line 152 (concat_pattern "?||?")
>> May 12 09:48:35 palladium-bsd slapd[287]: line 153 (has_ldapinfo_dn_ru
>> no) May 12 09:48:35 palladium-bsd slapd[287]: line 163
>> (TLSCipherSuite HIGH:MEDIUM:+SSLv2:+SSLv3) May 12 09:48:35 palladium-bsd
>> slapd[287]: line 165 (TLSCertificateFile /etc/ldap/slapd_cert.pem) May
>> 12 09:48:35 palladium-bsd slapd[287]: line 166 (TLSCertificateKeyFile
>> /etc/ldap/slapd_key.pem) May 12 09:48:35 palladium-bsd slapd[287]:
>> line 169 (sasl-host localhost) May 12 09:48:35 palladium-bsd slapd[288]:
>> backend_startup: bi_db_open(0) failed! (1) May 12 09:48:35 palladium-bsd
>> slapd[288]: slapd stopped.
>> May 12 09:48:35 palladium-bsd slapd[288]: connections_destroy: nothing
>> to destroy.
>>
>> Any ideas?
>>
>> --
>> Regards,
>>
>> Sergey
>> Dev Zero G Ltd
>> w: http://devzerog.com
>> e: sergey.p@ua.devzerog.com
--
Best regards,
Sergey mailto:sergey.p@ua.devzerog.com