[Date Prev][Date Next] [Chronological] [Thread] [Top]

Problems with openldap2.1.16/PostGreSQL7.3



Dear

Thanks a lot for Mr Pierangelo Masarati's mail.

Sorry, I found another question. 
Last week, I could start openldap and postgresql satisfactorily, and could not
run ldapadd commond.
But...,
>From this morning, I found I could not start openldap.
The slapd log is:
-------------------------------------------------------------------------------
...
    2.5.13.1 (distinguishedNameMatch): matchingRuleUse: ( 2.5.13.1 NAME 'disting
uishedNameMatch' APPLIES ( dITRedirect $ associatedName $ secretary $ documentAu
thor $ manager $ seeAlso $ roleOccupant $ owner $ member $ distinguishedName $ a
liasedObjectName $ namingContexts $ subschemaSubentry $ modifiersName $ creators
Name ) )
    2.5.13.0 (objectIdentifierMatch): matchingRuleUse: ( 2.5.13.0 NAME 'objectId
entifierMatch' APPLIES ( supportedApplicationContext $ supportedFeatures $ suppo
rtedExtension $ supportedControl $ structuralObjectClass $ objectClass ) )
TLS: PRNG not been seeded with enough data
slapd startup: initiated.
==>backsql_db_open(): testing RDBMS connection
backsql_db_open(): setting 'upper(ldap_entries.dn)=upper(?)' as default
backsql_db_open(): objectclass mapping SQL statement not specified (use "oc_quer
y" directive in slapd.conf)
backsql_db_open(): setting 'SELECT id,name,keytbl,keycol,create_proc,delete_proc
,expect_return FROM ldap_oc_mappings' by default
backsql_db_open(): attribute mapping SQL statement not specified (use "at_query"
 directive in slapd.conf)
backsql_db_open(): setting 'SELECT name,sel_expr,from_tbls,join_where,add_proc,d
elete_proc,param_order,expect_return,sel_expr_u FROM ldap_attr_mappings WHERE oc
_map_id=?' by default
backsql_db_open(): entry deletion SQL statement not specified (use "delentry_que
ry" directive in slapd.conf)
backsql_db_open(): setting 'DELETE FROM ldap_entries WHERE id=?' by default
==>backsql_get_db_conn()
==>backsql_open_db_conn()
backsql_open_db_conn(): connected, adding to tree
<==backsql_open_db_conn()
backsql_get_db_conn(): first call -- reading schema map
==>load_schema_map()
load_schema_map(): at_query 'SELECT name,sel_expr,from_tbls,join_where,add_proc,
delete_proc,param_order,expect_return,sel_expr_u FROM ldap_attr_mappings WHERE o
c_map_id=?'
load_schema_map(): objectClass 'i' is not defined in schema
==>backsql_free_db_conn()
backsql_free_db_conn(): closing db connection
==>backsql_close_db_conn()
<==backsql_close_db_conn()
<==backsql_free_db_conn()
backsql_db_open(): connection failed, exiting
backend_startup: bi_db_open(0) failed! (1)
slapd shutdown: initiated
==>backsql_db_close()
<==backsql_db_close()
slapd shutdown: freeing system resources.
==>backsql_db_destroy()
==>backsql_free_db_env()
<==backsql_free_db_env()
==>destroy_schema_map()
<==destroy_schema_map()
<==backsql_db_destroy()
slapd stopped.
connections_destroy: nothing to destroy.
-------------------------------------------------------------------------------
I configured openldap by 
"./configure --disable-bdb --without-cyrus-sasl --with-threads --with-readline --with-tls 
--enable-spasswd --enable-dynamic --enable-wraPpers --enable-passwd --enable-aci 
--enable-dnssrv --enable-rlookups --enable-crypt --enable-sql".

Created th pg_ldap followed these steps: (it's just followed the "Openldap/PostgreSql HOWTO")

# /usr/local/pgsql/bin/createdb pg_ldap
# /usr/local/pgsql/bin/psql pg_ldap  < /space/home/minko/work/pgsql/backsql_create.sql
# /usr/local/pgsql/bin/psql -d pg_ldap < /space/home/minko/work/pgsql/testdb_create.sql
# /usr/local/pgsql/bin/psql -d pg_ldap < /space/home/minko/work/pgsql/testdb_metadata.sql
# /usr/local/pgsql/bin/psql -d pg_ldap < /space/home/minko/work/pgsql/testdb_data.sql
# /usr/local/pgsql/bin/psql -d pg_ldap -c "GRANT ALL ON ldap_attr_mappings,ldap_entries,ldap_entry_objclasses,ldap_oc_mappings,ldap_referrals TO test;"
# /usr/local/pgsql/bin/psql -d pg_ldap -c "GRANT ALL ON ldap_attr_mappings_id_seq,ldap_entries_id_seq,ldap_oc_mappings_id_seq TO test;"
# /usr/local/pgsql/bin/psql -d pg_ldap -c "GRANT ALL ON authors_docs,documents,institutes,persons,phones TO test;"
# /usr/local/pgsql/bin/psql -d pg_ldap -c "GRANT ALL ON documents_id_seq,institutes_id_seq,persons_id_seq,phones_id_seq TO test;"

And when I start Openldap by "./slapd -h ldap://mickey:40389 -d -1", it will not be worked.

It is the slapd.conf file:
-------------------------------------------------------------------------------
# $OpenLDAP: pkg/ldap/servers/slapd/slapd.conf,v 1.23 2002/02/02 05:23:12 kurt E
xp $
#
# 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/inetorgperson.schema

# Define global ACLs to disable default read access.
access to *
        by self write
        by * read
access to * by dn="cn=root,o=sql,c=RU" write
#defaultaccess none

# Do not enable referrals until AFTER you have a working directory
# service AND an understanding of referrals.
#referral       ldap://root.openldap.org

pidfile         /usr/local/var/slapd.pid
argsfile        /usr/local/var/slapd.args

#######################################################################
# sql database definitions
#######################################################################

database        sql
suffix          "o=sql,c=RU"
rootdn          "cn=root,o=sql,c=RU"
rootpw          secret
dbname          PgSQL
dbuser          test
dbpasswd        test
subtree_cond    "upper(ldap_entries.dn) LIKE '%'||?"
insentry_query  "insert into ldap_entries (id,dn,oc_map_id,parent,keyval) values
 ((select max(id)+1 from ldap_entries),?,?,?,?)"
#insentry_query "insert into ldap_entries (id,dn,oc_map_id,parent,keyval) values
(?,?,?,?,?)"
upper_func      "upper"
strcast_func    "text"
concat_pattern  "?||?"
has_ldapinfo_dn_ru      no
-------------------------------------------------------------------------------

Suggest me please.
Thank you!

zhang
zhang@fjh.fujitsu.com