[Date Prev][Date Next] [Chronological] [Thread] [Top]
(ITS#6401) openldap doesn't start......

To: openldap-its@OpenLDAP.org
Subject: (ITS#6401) openldap doesn't start......
From: luisvm87@gmail.com
Date: Tue, 24 Nov 2009 18:20:32 GMT
Auto-submitted: auto-generated (OpenLDAP-ITS)
Full_Name: Luis Vargas Mieles
Version: 2.4.19
OS: centOS
URL: ftp://ftp.openldap.org/incoming/
Submission from: (NULL) (200.93.195.131)


Hello

when I started the slapd, it generates these sentences...

[root@localhost ~]# /usr/local/libexec/slapd -d 1
@(#) $OpenLDAP: slapd 2.4.19 (Nov 23 2009 19:03:54) $
        root@localhost.localdomain:/usr/src/openldap-2.4.19/servers/slapd
ldap_pvt_gethostbyname_a: host=localhost.localdomain, r=0
daemon_init: listen on ldap:///
daemon_init: 1 listeners to open...
ldap_url_parse_ext(ldap:///)
daemon: listener initialized ldap:///
daemon_init: 2 listeners opened
ldap_create
slapd init: initiated server.
slap_sasl_init: initialized!
bdb_back_initialize: initialize BDB backend
bdb_back_initialize: Berkeley DB 4.8.24: (August 14, 2009)
hdb_back_initialize: initialize HDB backend
hdb_back_initialize: Berkeley DB 4.8.24: (August 14, 2009)
==>sql_back_initialize()
<==sql_back_initialize()
==>backsql_db_init()
==>backsql_init_db_env()
<==backsql_init_db_env()=0
<==backsql_db_init()
>>> dnPrettyNormal: <o=sql,c=RU>
<<< dnPrettyNormal: <o=sql,c=RU>, <o=sql,c=ru>
>>> dnPrettyNormal: <cn=root,o=sql,c=RU>
<<< dnPrettyNormal: <cn=root,o=sql,c=RU>, <cn=root,o=sql,c=ru>
==>backsql_db_config()
<==backsql_db_config(): dbname=example
==>backsql_db_config()
<==backsql_db_config(): dbuser=root
==>backsql_db_config()
<==backsql_db_config(): dbpasswd=xxxx
==>backsql_db_config()
<==backsql_db_config(): subtree_cond=ldap_entries.dn LIKE CONCAT('%',?)
==>backsql_db_config()
<==backsql_db_config(): insentry_stmt=INSERT INTO ldap_entries
(dn,oc_map_id,parent,keyval) VALUES (?,?,?,?)
==>backsql_db_config()
<==backsql_db_config(): has_ldapinfo_dn_ru=no
>>> dnNormalize: <cn=Subschema>
<<< dnNormalize: <cn=subschema>
matching_rule_use_init
    1.2.840.113556.1.4.804 (integerBitOrMatch): matchingRuleUse: (
1.2.840.113556.1.4.804 NAME 'integerBitOrMatch' APPLIES ( supportedLDAPVersion $
entryTtl $ uidNumber $ gidNumber $ olcConcurrency $ olcConnMaxPending $
olcConnMaxPendingAuth $ olcIdleTimeout $ olcIndexSubstrIfMinLen $
olcIndexSubstrIfMaxLen $ olcIndexSubstrAnyLen $ olcIndexSubstrAnyStep $
olcIndexIntLen $ olcLocalSSF $ olcMaxDerefDepth $ olcReplicationInterval $
olcSockbufMaxIncoming $ olcSockbufMaxIncomingAuth $ olcThreads $ olcToolThreads
$ olcWriteTimeout $ olcDbCacheFree $ olcDbCacheSize $ olcDbDNcacheSize $
olcDbIDLcacheSize $ olcDbSearchStack $ olcDbShmKey $ olcSpSessionlog $
mailPreferenceOption ) )
    1.2.840.113556.1.4.803 (integerBitAndMatch): matchingRuleUse: (
1.2.840.113556.1.4.803 NAME 'integerBitAndMatch' APPLIES ( supportedLDAPVersion
$ entryTtl $ uidNumber $ gidNumber $ olcConcurrency $ olcConnMaxPending $
olcConnMaxPendingAuth $ olcIdleTimeout $ olcIndexSubstrIfMinLen $
olcIndexSubstrIfMaxLen $ olcIndexSubstrAnyLen $ olcIndexSubstrAnyStep $
olcIndexIntLen $ olcLocalSSF $ olcMaxDerefDepth $ olcReplicationInterval $
olcSockbufMaxIncoming $ olcSockbufMaxIncomingAuth $ olcThreads $ olcToolThreads
$ olcWriteTimeout $ olcDbCacheFree $ olcDbCacheSize $ olcDbDNcacheSize $
olcDbIDLcacheSize $ olcDbSearchStack $ olcDbShmKey $ olcSpSessionlog $
mailPreferenceOption ) )
    1.3.6.1.4.1.1466.109.114.2 (caseIgnoreIA5Match): matchingRuleUse: (
1.3.6.1.4.1.1466.109.114.2 NAME 'caseIgnoreIA5Match' APPLIES ( altServer $
olcDbConfig $ c $ mail $ dc $ associatedDomain $ email $ aRecord $ mDRecord $
mXRecord $ nSRecord $ sOARecord $ cNAMERecord $ janetMailbox ) )
    1.3.6.1.4.1.1466.109.114.1 (caseExactIA5Match): matchingRuleUse: (
1.3.6.1.4.1.1466.109.114.1 NAME 'caseExactIA5Match' APPLIES ( altServer $
olcDbConfig $ c $ mail $ dc $ associatedDomain $ email $ aRecord $ mDRecord $
mXRecord $ nSRecord $ sOARecord $ cNAMERecord $ janetMailbox ) )
    2.5.13.39 (certificateListMatch):     2.5.13.38 (certificateListExactMatch):
matchingRuleUse: ( 2.5.13.38 NAME 'certificateListExactMatch' APPLIES (
authorityRevocationList $ certificateRevocationList $ deltaRevocationList ) )
    2.5.13.35 (certificateMatch):     2.5.13.34 (certificateExactMatch):
matchingRuleUse: ( 2.5.13.34 NAME 'certificateExactMatch' APPLIES (
userCertificate $ cACertificate ) )
    2.5.13.30 (objectIdentifierFirstComponentMatch): matchingRuleUse: (
2.5.13.30 NAME 'objectIdentifierFirstComponentMatch' APPLIES ( supportedControl
$ supportedExtension $ supportedFeatures $ ldapSyntaxes $
supportedApplicationContext ) )
    2.5.13.29 (integerFirstComponentMatch): matchingRuleUse: ( 2.5.13.29 NAME
'integerFirstComponentMatch' APPLIES ( supportedLDAPVersion $ entryTtl $
uidNumber $ gidNumber $ olcConcurrency $ olcConnMaxPending $
olcConnMaxPendingAuth $ olcIdleTimeout $ olcIndexSubstrIfMinLen $
olcIndexSubstrIfMaxLen $ olcIndexSubstrAnyLen $ olcIndexSubstrAnyStep $
olcIndexIntLen $ olcLocalSSF $ olcMaxDerefDepth $ olcReplicationInterval $
olcSockbufMaxIncoming $ olcSockbufMaxIncomingAuth $ olcThreads $ olcToolThreads
$ olcWriteTimeout $ olcDbCacheFree $ olcDbCacheSize $ olcDbDNcacheSize $
olcDbIDLcacheSize $ olcDbSearchStack $ olcDbShmKey $ olcSpSessionlog $
mailPreferenceOption ) )
    2.5.13.27 (generalizedTimeMatch): matchingRuleUse: ( 2.5.13.27 NAME
'generalizedTimeMatch' APPLIES ( createTimestamp $ modifyTimestamp ) )
    2.5.13.24 (protocolInformationMatch): matchingRuleUse: ( 2.5.13.24 NAME
'protocolInformationMatch' APPLIES protocolInformation )
    2.5.13.23 (uniqueMemberMatch): matchingRuleUse: ( 2.5.13.23 NAME
'uniqueMemberMatch' APPLIES uniqueMember )
    2.5.13.22 (presentationAddressMatch): matchingRuleUse: ( 2.5.13.22 NAME
'presentationAddressMatch' APPLIES presentationAddress )
    2.5.13.20 (telephoneNumberMatch): matchingRuleUse: ( 2.5.13.20 NAME
'telephoneNumberMatch' APPLIES ( telephoneNumber $ homePhone $ mobile $ pager )
)
    2.5.13.17 (octetStringMatch): matchingRuleUse: ( 2.5.13.17 NAME
'octetStringMatch' APPLIES ( userPassword $ olcDbCryptKey ) )
    2.5.13.16 (bitStringMatch): matchingRuleUse: ( 2.5.13.16 NAME
'bitStringMatch' APPLIES x500UniqueIdentifier )
    2.5.13.14 (integerMatch): matchingRuleUse: ( 2.5.13.14 NAME 'integerMatch'
APPLIES ( supportedLDAPVersion $ entryTtl $ uidNumber $ gidNumber $
olcConcurrency $ olcConnMaxPending $ olcConnMaxPendingAuth $ olcIdleTimeout $
olcIndexSubstrIfMinLen $ olcIndexSubstrIfMaxLen $ olcIndexSubstrAnyLen $
olcIndexSubstrAnyStep $ olcIndexIntLen $ olcLocalSSF $ olcMaxDerefDepth $
olcReplicationInterval $ olcSockbufMaxIncoming $ olcSockbufMaxIncomingAuth $
olcThreads $ olcToolThreads $ olcWriteTimeout $ olcDbCacheFree $ olcDbCacheSize
$ olcDbDNcacheSize $ olcDbIDLcacheSize $ olcDbSearchStack $ olcDbShmKey $
olcSpSessionlog $ mailPreferenceOption ) )
    2.5.13.13 (booleanMatch): matchingRuleUse: ( 2.5.13.13 NAME 'booleanMatch'
APPLIES ( hasSubordinates $ olcAddContentAcl $ olcGentleHUP $ olcHidden $
olcLastMod $ olcMirrorMode $ olcMonitoring $ olcReadOnly $ olcReverseLookup $
olcDbChecksum $ olcDbNoSync $ olcDbDirtyRead $ olcDbLinearIndex $ olcSpNoPresent
$ olcSpReloadHint ) )
    2.5.13.11 (caseIgnoreListMatch): matchingRuleUse: ( 2.5.13.11 NAME
'caseIgnoreListMatch' APPLIES ( postalAddress $ registeredAddress $
homePostalAddress ) )
    2.5.13.8 (numericStringMatch): matchingRuleUse: ( 2.5.13.8 NAME
'numericStringMatch' APPLIES ( x121Address $ internationaliSDNNumber ) )
    2.5.13.7 (caseExactSubstringsMatch): matchingRuleUse: ( 2.5.13.7 NAME
'caseExactSubstringsMatch' APPLIES ( serialNumber $ destinationIndicator $
dnQualifier ) )
    2.5.13.6 (caseExactOrderingMatch): matchingRuleUse: ( 2.5.13.6 NAME
'caseExactOrderingMatch' APPLIES ( serialNumber $ destinationIndicator $
dnQualifier ) )
    2.5.13.5 (caseExactMatch): matchingRuleUse: ( 2.5.13.5 NAME 'caseExactMatch'
APPLIES ( supportedSASLMechanisms $ vendorName $ vendorVersion $ ref $ name $ cn
$ uid $ labeledURI $ description $ olcConfigFile $ olcConfigDir $ olcAccess $
olcAllows $ olcArgsFile $ olcAttributeOptions $ olcAttributeTypes $
olcAuthIDRewrite $ olcAuthzPolicy $ olcAuthzRegexp $ olcBackend $ olcDatabase $
olcDisallows $ olcDitContentRules $ olcInclude $ olcLdapSyntaxes $ olcLimits $
olcLogFile $ olcLogLevel $ olcModuleLoad $ olcModulePath $ olcObjectClasses $
olcObjectIdentifier $ olcOverlay $ olcPasswordCryptSaltFormat $ olcPasswordHash
$ olcPidFile $ olcPlugin $ olcPluginLogFile $ olcReferral $ olcReplica $
olcReplicaArgsFile $ olcReplicaPidFile $ olcReplogFile $ olcRequires $
olcRestrict $ olcRootDSE $ olcRootPW $ olcSaslAuxprops $ olcSaslHost $
olcSaslRealm $ olcSaslSecProps $ olcSecurity $ olcServerID $ olcSizeLimit $
olcSortVals $ olcSubordinate $ olcSyncrepl $ olcTCPBuffer $ olcTimeLimit $
olcTLSCACertificateFile $ olcTLSCACertificatePath $ olcTLSCertificateFile $
olcTLSCertificateKeyFile $ olcTLSCipherSuite $ olcTLSCRLCheck $ olcTLSCRLFile $
olcTLSRandFile $ olcTLSVerifyClient $ olcTLSDHParamFile $ olcTLSProtocolMin $
olcUpdateRef $ olcDbDirectory $ olcDbCheckpoint $ olcDbCryptFile $ olcDbPageSize
$ olcDbIndex $ olcDbLockDetect $ olcDbMode $ olcSpCheckpoint $
knowledgeInformation $ sn $ serialNumber $ c $ l $ st $ street $ o $ ou $ title
$ businessCategory $ postalCode $ postOfficeBox $ physicalDeliveryOfficeName $
destinationIndicator $ givenName $ initials $ generationQualifier $ dnQualifier
$ houseIdentifier $ dmdName $ pseudonym $ textEncodedORAddress $ info $ drink $
roomNumber $ userClass $ host $ documentIdentifier $ documentTitle $
documentVersion $ documentLocation $ personalTitle $ co $ uniqueIdentifier $
organizationalStatus $ buildingName $ documentPublisher $ carLicense $
departmentNumber $ displayName $ employeeNumber $ employeeType $
preferredLanguage ) )
    2.5.13.4 (caseIgnoreSubstringsMatch): matchingRuleUse: ( 2.5.13.4 NAME
'caseIgnoreSubstringsMatch' APPLIES ( serialNumber $ destinationIndicator $
dnQualifier ) )
    2.5.13.3 (caseIgnoreOrderingMatch): matchingRuleUse: ( 2.5.13.3 NAME
'caseIgnoreOrderingMatch' APPLIES ( serialNumber $ destinationIndicator $
dnQualifier ) )
    2.5.13.2 (caseIgnoreMatch): matchingRuleUse: ( 2.5.13.2 NAME
'caseIgnoreMatch' APPLIES ( supportedSASLMechanisms $ vendorName $ vendorVersion
$ ref $ name $ cn $ uid $ labeledURI $ description $ olcConfigFile $
olcConfigDir $ olcAccess $ olcAllows $ olcArgsFile $ olcAttributeOptions $
olcAttributeTypes $ olcAuthIDRewrite $ olcAuthzPolicy $ olcAuthzRegexp $
olcBackend $ olcDatabase $ olcDisallows $ olcDitContentRules $ olcInclude $
olcLdapSyntaxes $ olcLimits $ olcLogFile $ olcLogLevel $ olcModuleLoad $
olcModulePath $ olcObjectClasses $ olcObjectIdentifier $ olcOverlay $
olcPasswordCryptSaltFormat $ olcPasswordHash $ olcPidFile $ olcPlugin $
olcPluginLogFile $ olcReferral $ olcReplica $ olcReplicaArgsFile $
olcReplicaPidFile $ olcReplogFile $ olcRequires $ olcRestrict $ olcRootDSE $
olcRootPW $ olcSaslAuxprops $ olcSaslHost $ olcSaslRealm $ olcSaslSecProps $
olcSecurity $ olcServerID $ olcSizeLimit $ olcSortVals $ olcSubordinate $
olcSyncrepl $ olcTCPBuffer $ olcTimeLimit $ olcTLSCACertificateFile $
olcTLSCACertificatePath $ olcTLSCertificateFile $ olcTLSCertificateKeyFile $
olcTLSCipherSuite $ olcTLSCRLCheck $ olcTLSCRLFile $ olcTLSRandFile $
olcTLSVerifyClient $ olcTLSDHParamFile $ olcTLSProtocolMin $ olcUpdateRef $
olcDbDirectory $ olcDbCheckpoint $ olcDbCryptFile $ olcDbPageSize $ olcDbIndex $
olcDbLockDetect $ olcDbMode $ olcSpCheckpoint $ knowledgeInformation $ sn $
serialNumber $ c $ l $ st $ street $ o $ ou $ title $ businessCategory $
postalCode $ postOfficeBox $ physicalDeliveryOfficeName $ destinationIndicator $
givenName $ initials $ generationQualifier $ dnQualifier $ houseIdentifier $
dmdName $ pseudonym $ textEncodedORAddress $ info $ drink $ roomNumber $
userClass $ host $ documentIdentifier $ documentTitle $ documentVersion $
documentLocation $ personalTitle $ co $ uniqueIdentifier $ organizationalStatus
$ buildingName $ documentPublisher $ carLicense $ departmentNumber $ displayName
$ employeeNumber $ employeeType $ preferredLanguage ) )
    1.2.36.79672281.1.13.3 (rdnMatch):     2.5.13.1 (distinguishedNameMatch):
matchingRuleUse: ( 2.5.13.1 NAME 'distinguishedNameMatch' APPLIES ( creatorsName
$ modifiersName $ subschemaSubentry $ entryDN $ namingContexts $
aliasedObjectName $ dynamicSubtrees $ distinguishedName $ seeAlso $
olcDefaultSearchBase $ olcRootDN $ olcSchemaDN $ olcSuffix $ olcUpdateDN $
olcRelay $ member $ owner $ roleOccupant $ manager $ documentAuthor $ secretary
$ associatedName $ dITRedirect ) )
    2.5.13.0 (objectIdentifierMatch): matchingRuleUse: ( 2.5.13.0 NAME
'objectIdentifierMatch' APPLIES ( supportedControl $ supportedExtension $
supportedFeatures $ supportedApplicationContext ) )
slapd startup: initiated.
backend_startup_one: starting "cn=config"
config_back_db_open
config_build_entry: "cn=config"
config_build_entry: "cn=schema"
config_build_entry: "cn={0}core"
config_build_entry: "cn={1}cosine"
config_build_entry: "cn={2}inetorgperson"
config_build_entry: "olcDatabase={-1}frontend"
config_build_entry: "olcDatabase={0}config"
WARNING: No dynamic config support for database sql.
config_build_entry: "olcDatabase={1}sql"
backend_startup_one: starting "o=sql,c=RU"
==>backsql_db_open(): testing RDBMS connection
backsql_db_open(): concat func not specified (use "concat_pattern" directive in
slapd.conf)
backsql_db_open(): children search SQL condition not specified (use
"children_cond" directive in slapd.conf); preparing default
backsql_db_open(): setting "ldap_entries.dn LIKE CONCAT('%,',?)" as default
"children_cond"
backsql_db_open(): DN match search SQL condition not specified (use
"dn_match_cond" directive in slapd.conf); preparing default
backsql_db_open(): setting "ldap_entries.dn=?" as default "dn_match_cond"
backsql_db_open(): objectclass mapping SQL statement not specified (use
"oc_query" 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,delete_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_stmt" directive in slapd.conf)
backsql_db_open(): setting "DELETE FROM ldap_entries WHERE id=?" by default
backsql_db_open(): entry deletion SQL statement not specified (use
"renentry_stmt" directive in slapd.conf)
backsql_db_open(): setting "UPDATE ldap_entries SET dn=?,parent=?,keyval=? WHERE
id=?" by default
backsql_db_open(): objclasses deletion SQL statement not specified (use
"delobjclasses_stmt" directive in slapd.conf)
backsql_db_open(): setting "DELETE FROM ldap_entry_objclasses WHERE entry_id=?"
by default
==>backsql_get_db_conn()
==>backsql_open_db_handle()
<==backsql_open_db_handle()
<==backsql_get_db_conn()
==>backsql_load_schema_map()
backsql_load_schema_map(): oc_query "SELECT
id,name,keytbl,keycol,create_proc,delete_proc,expect_return FROM
ldap_oc_mappings"
objectClass: id="1" name="inetOrgPerson" keytbl="persons" keycol="id"
create_proc="" create_keyval="" delete_proc="" expect_return="0"create_hint="" 
backsql_load_schema_map(): objectClass "inetOrgPerson":
    keytbl="persons" keycol="id"
    expect_return: add=0, del=0; attributes:
objectClass: id="2" name="document" keytbl="documents" keycol="id"
create_proc="" create_keyval="" delete_proc="" expect_return="0"create_hint="" 
backsql_load_schema_map(): objectClass "document":
    keytbl="documents" keycol="id"
    expect_return: add=0, del=0; attributes:
objectClass: id="3" name="organization" keytbl="institutes" keycol="id"
create_proc="" create_keyval="" delete_proc="" expect_return="0"create_hint="" 
backsql_load_schema_map(): objectClass "organization":
    keytbl="institutes" keycol="id"
    expect_return: add=0, del=0; attributes:
objectClass: id="4" name="referral" keytbl="referrals" keycol="id"
create_proc="" create_keyval="" delete_proc="" expect_return="0"create_hint="" 
backsql_load_schema_map(): objectClass "referral":
    keytbl="referrals" keycol="id"
    expect_return: add=0, del=0; attributes:
backsql_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 oc_map_id=?"
backsql_oc_get_attr_mapping(): executing 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 oc_map_id=?"
    for objectClass "document"
    with param oc_id="2"
attributeType: name="description" sel_expr="documents.abstract" from="documents"
join_where="" add_proc="" delete_proc="" sel_expr_u=""
backsql_oc_get_attr_mapping(): preconstructed query "SELECT documents.abstract
AS description FROM documents WHERE documents.id=? ORDER BY description"
attributeType: name="documentTitle" sel_expr="documents.title" from="documents"
join_where="" add_proc="" delete_proc="" sel_expr_u=""
backsql_oc_get_attr_mapping(): preconstructed query "SELECT documents.title AS
documentTitle FROM documents WHERE documents.id=? ORDER BY documentTitle"
attributeType: name="documentAuthor" sel_expr="documentAuthor.dn"
from="ldap_entries AS documentAuthor,documents,authors_docs,persons"
join_where="documentAuthor.keyval=persons.id AND documentAuthor.oc_map_id=1 AND
authors_docs.doc_id=documents.id AND aut
backsql_oc_get_attr_mapping(): preconstructed query "SELECT documentAuthor.dn AS
documentAuthor FROM ldap_entries AS
documentAuthor,documents,authors_docs,persons WHERE documents.id=? AND
documentAuthor.keyval=persons.id AND documentAuthor.oc_map_id=1 AND
authors_docs.doc_id=documents.id AND authors_docs.pers_id=persons.id ORDER BY
documentAuthor"
attributeType: name="documentIdentifier" sel_expr="concat('document
',documents.id)" from="documents" join_where="documentAuthor.keyval=persons.id
AND documentAuthor.oc_map_id=1 AND authors_docs.doc_id=documents.id AND
authors_docs.pers_id=persons.id" add
backsql_oc_get_attr_mapping(): preconstructed query "SELECT concat('document
',documents.id) AS documentIdentifier FROM documents WHERE documents.id=? ORDER
BY documentIdentifier"
backsql_load_schema_map("document"): autoadding 'objectClass' and 'ref'
mappings
backsql_oc_get_attr_mapping(): executing 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 oc_map_id=?"
    for objectClass "referral"
    with param oc_id="4"
attributeType: name="ou" sel_expr="referrals.name" from="referrals"
join_where="" add_proc="" delete_proc="" sel_expr_u=""
backsql_oc_get_attr_mapping(): preconstructed query "SELECT referrals.name AS ou
FROM referrals WHERE referrals.id=? ORDER BY ou"
attributeType: name="ref" sel_expr="referrals.url" from="referrals"
join_where="" add_proc="" delete_proc="" sel_expr_u=""
backsql_oc_get_attr_mapping(): preconstructed query "SELECT referrals.url AS ref
FROM referrals WHERE referrals.id=? ORDER BY ref"
backsql_load_schema_map("referral"): autoadding 'objectClass' and 'ref'
mappings
backsql_oc_get_attr_mapping(): executing 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 oc_map_id=?"
    for objectClass "organization"
    with param oc_id="3"
attributeType: name="o" sel_expr="institutes.name" from="institutes"
join_where="" add_proc="" delete_proc="" sel_expr_u=""
backsql_oc_get_attr_mapping(): preconstructed query "SELECT institutes.name AS o
FROM institutes WHERE institutes.id=? ORDER BY o"
attributeType: name="dc" sel_expr="lower(institutes.name)"
from="institutes,ldap_entries AS dcObject,ldap_entry_objclasses as
auxObjectClass" join_where="institutes.id=dcObject.keyval AND
dcObject.oc_map_id=3 AND dcObject.id=auxObjectClass.entry_id AND au
backsql_oc_get_attr_mapping(): preconstructed query "SELECT
lower(institutes.name) AS dc FROM institutes,ldap_entries AS
dcObject,ldap_entry_objclasses AS auxObjectClass WHERE institutes.id=? AND
institutes.id=dcObject.keyval AND dcObject.oc_map_id=3 AND
dcObject.id=auxObjectClass.entry_id AND auxObjectClass.oc_name='dcObject' ORDER
BY dc"
backsql_load_schema_map("organization"): autoadding 'objectClass' and 'ref'
mappings
backsql_oc_get_attr_mapping(): executing 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 oc_map_id=?"
    for objectClass "inetOrgPerson"
    with param oc_id="1"
attributeType: name="cn" sel_expr="concat(persons.name,' ',persons.surname)"
from="persons" join_where="" add_proc="" delete_proc="" sel_expr_u=""
backsql_oc_get_attr_mapping(): preconstructed query "SELECT
concat(persons.name,' ',persons.surname) AS cn FROM persons WHERE persons.id=?
ORDER BY cn"
attributeType: name="telephoneNumber" sel_expr="phones.phone"
from="persons,phones" join_where="phones.pers_id=persons.id" add_proc=""
delete_proc="" sel_expr_u=""
backsql_oc_get_attr_mapping(): preconstructed query "SELECT phones.phone AS
telephoneNumber FROM persons,phones WHERE persons.id=? AND
phones.pers_id=persons.id ORDER BY telephoneNumber"
attributeType: name="givenName" sel_expr="persons.name" from="persons"
join_where="phones.pers_id=persons.id" add_proc="" delete_proc="" sel_expr_u=""
backsql_oc_get_attr_mapping(): preconstructed query "SELECT persons.name AS
givenName FROM persons WHERE persons.id=? ORDER BY givenName"
attributeType: name="sn" sel_expr="persons.surname" from="persons"
join_where="phones.pers_id=persons.id" add_proc="" delete_proc="" sel_expr_u=""
backsql_oc_get_attr_mapping(): preconstructed query "SELECT persons.surname AS
sn FROM persons WHERE persons.id=? ORDER BY sn"
attributeType: name="userPassword" sel_expr="persons.password" from="persons"
join_where="persons.password IS NOT NULL" add_proc="" delete_proc=""
sel_expr_u=""
backsql_oc_get_attr_mapping(): preconstructed query "SELECT persons.password AS
userPassword FROM persons WHERE persons.id=? AND persons.password IS NOT NULL
ORDER BY userPassword"
attributeType: name="seeAlso" sel_expr="seeAlso.dn" from="ldap_entries AS
seeAlso,documents,authors_docs,persons" join_where="seeAlso.keyval=documents.id
AND seeAlso.oc_map_id=2 AND authors_docs.doc_id=documents.id AND
authors_docs.pers_id=persons.id" add
backsql_oc_get_attr_mapping(): preconstructed query "SELECT seeAlso.dn AS
seeAlso FROM ldap_entries AS seeAlso,documents,authors_docs,persons WHERE
persons.id=? AND seeAlso.keyval=documents.id AND seeAlso.oc_map_id=2 AND
authors_docs.doc_id=documents.id AND authors_docs.pers_id=persons.id ORDER BY
seeAlso"
attributeType: name="userCertificate" sel_expr="certs.cert" from="persons,certs"
join_where="certs.pers_id=persons.id" add_proc="" delete_proc="" sel_expr_u=""
backsql_oc_get_attr_mapping(): preconstructed query "SELECT certs.cert AS
userCertificate FROM persons,certs WHERE persons.id=? AND
certs.pers_id=persons.id ORDER BY userCertificate"
backsql_load_schema_map("inetOrgPerson"): autoadding 'objectClass' and 'ref'
mappings
<==backsql_load_schema_map()
==>backsql_free_db_conn()
==>backsql_close_db_handle(0x932e428)
<==backsql_close_db_handle(0x932e428)
<==backsql_free_db_conn()
<==backsql_db_open(): test succeeded, schema map loaded
slapd starting

........ and slapd never start -.- I don't know where the mistake is... I
checked the configuration files slapd.conf, odbc.ini, odbcinst.ini and I can't
find the mistake, please help me =)

here we have the configuration files

+++++slapd.conf+++++++
# $OpenLDAP: /servers/slapd/back-sql/rdbms_depend/mysql/slapd.conf,v 1.5.2.1
2005/01/20 18:04:03 kurt Exp $
#
# 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.

# 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/run/slapd.pid
argsfile	/usr/local/var/run/slapd.args

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

database	sql
suffix		"o=sql,c=RU"
rootdn		"cn=root,o=sql,c=RU"
rootpw		{SSHA}J3tV8vA0ouDU6LfnaPraZDPebsQdIrqe
dbname		example
dbuser		root
dbpasswd	admin
subtree_cond	"ldap_entries.dn LIKE CONCAT('%',?)"
insentry_stmt	"INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval) VALUES
(?,?,?,?)"
has_ldapinfo_dn_ru	no


+++++++odbc.ini+++++++
[example]
Description         = Example for OpenLDAP's back-sql
Driver              = MySQL
#Trace               = No
Database            = example
Server	            = localhost
Port		    = 3306
Socket              = /var/lib/mysql/mysql.sock
User	            = root
Password            = admin
#ReadOnly            = No
#RowVersioning       = No
#ShowSystemTables    = No
#ShowOidColumn       = No
#FakeOidIndex        = No
#ConnSettings        =

+++++++odbcinst.ini++++++++
# Example driver definitinions
#
#

# Included in the unixODBC package
[PostgreSQL]
Description	= ODBC for PostgreSQL
Driver		= /usr/lib/libodbcpsql.so
Setup		= /usr/lib/libodbcpsqlS.so
FileUsage	= 1


# Driver from the MyODBC package
# Setup from the unixODBC package
#[MySQL]
#Description	= ODBC for MySQL
#Driver		= /usr/lib/libmyodbc.so
#Setup		= /usr/lib/libodbcmyS.so
#FileUsage	= 1


[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib/libmyodbc3.so
Setup		= /usr/lib/libodbcmyS.so
FileUsage       = 1

+++++++++++++++++++++++++++++++++++++++++++++++

thanks for your attention :)
Prev by Date: Re: (ITS#6395) Web site release readme needs BDB version compatibility update
Next by Date: Re: (ITS#6401) openldap doesn't start......
Index(es):
- Chronological
- Thread