Re: (ITS#6365) Bad slapcat output when slapd running
by hyc＠symas.com
masarati(a)aero.polimi.it wrote:
>> Howard Chu wrote:
>>> Of course, no one is saying for certain that this is the explanation,
>>> yet.
>>
>> It sounds reasonable to me :)
> Based on my *very incomplete and possibly wrong* analysis, the problem
> would be automatically cured by using back-bdb. Also, fixing back-hdb *if
> it's broken at all* should be possible.
Quite certain this is not the explanation, since syncrepl will call
syncrepl_add_glue() whenever it needs to store an entry that doesn't yet have
its parent.
--
-- Howard Chu
CTO, Symas Corp. http://www.symas.com
Director, Highland Sun http://highlandsun.com/hyc/
Chief Architect, OpenLDAP http://www.openldap.org/project/
13 years, 10 months
Re: (ITS#6401) openldap doesn't start......
by quanah＠zimbra.com
--On Tuesday, November 24, 2009 6:20 PM +0000 luisvm87(a)gmail.com wrote:
> Full_Name: Luis Vargas Mieles
> Version: 2.4.19
> OS: centOS
> URL: ftp://ftp.openldap.org/incoming/
> Submission from: (NULL) (200.93.195.131)
> 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 =)
How are you checking on whether or not slapd ever "started"? Is there a
slapd process? Maybe it is waiting on a connection to the mysql server.
In any case, the ITS system is not for questions about how to use/configure
OpenLDAP. Please direct such questions to the
openldap-software(a)openldap.org mailing list.
--Quanah
--
Quanah Gibson-Mount
Principal Software Engineer
Zimbra, Inc
--------------------
Zimbra :: the leader in open source messaging and collaboration
13 years, 10 months
(ITS#6401) openldap doesn't start......
by luisvm87＠gmail.com
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 :)
13 years, 10 months
(ITS#6400) Different-sized CSNs confuse accesslog
by h.b.furuseth＠usit.uio.no
Full_Name: Hallvard B Furuseth
Version:
OS:
URL:
Submission from: (NULL) (129.240.6.233)
Submitted by: hallvard
Given CSNs of different lengths, overlays/accesslog.c:log_old_lookup()
remembers truncated versions of the longer CSNs as "max CSN". The
remembered length shrinks but never grows as CSNs change.
I think the test
if ( len > pd->csn.bv_len )
len = pd->csn.bv_len;
should be
if ( len > LDAP_PVT_CSNSTR_BUFSIZE )
len = LDAP_PVT_CSNSTR_BUFSIZE;
since as far as I can tell pd->csn.bv_val is always csnbuf from
accesslog_purge().
The compare just below must be fixed to match. It is buggy now anyway,
CSNs of different lengths can compare equal.
13 years, 10 months
Re: (ITS#6398) quiet valgrind (tool -F parsing)
by h.b.furuseth＠usit.uio.no
richton(a)nbcs.rutgers.edu writes:
> Quiets a valgrind "definitely lost" leak complaint.
> I submit this patch as public domain.
Thanks. Fixed in HEAD.
--
Hallvard
13 years, 10 months
Re: (ITS#6397) accesslog + syncprov crash
by h.b.furuseth＠usit.uio.no
Poking a bit more in the backtrace (with a new coredump, sorry)
shows that the filter given to test_filter() is NULL because
*ss = {
s_base = {bv_len = 6, bv_val = 0x1f94c5a0 "cn=log"},
s_eid = 1,
s_op = 0x1f948310 {
o_hdr = 0x1f948480 {all nulls},
o_controls = 0x1f9485c8 [(void *) 0x0]},
s_rid = 1, s_sid = -1, s_flags = 1, s_inuse = 1,
<fields with null values omitted>
}
in frame 1, syncprov_matchops (op=0x42ec6690, opc=0x1f958ca0, saveit=1) at
syncprov.c:1304: rc = test_filter( &op2, e, ss->s_op->ors_filter );
I have ss == si->si_ops != sm->sm_op.
*si = {
si_ops = 0x1f951c20,
si_ctxcsn = 0x1f74fa70,
si_contextdn = {bv_len = 6, bv_val = 0x1f4e4310 "cn=log"},
si_sids = 0x1f74fae0 [0],
si_numcsns = 1, si_numops = 49, si_nopres = 1, si_usehint = 1,
si_mods = 0x1fa615b0 {avl_data = 0x1fa61d20},
si_ops_mutex = {
__data = {__lock = 1, __owner = 26790, __nusers = 1},
__size = "\001\000\000\000\000\000\000\000\246h\000\000\001", '\0' <repeats 26 times>,
__align = 1}}
Following si->si_mods: sml_mod.sm_type is garbage, is that relevant?
*((modtarget *) si->si_mods->avl_data)->mt_mods->mi_op = {
o_hdr = 0x42ec6800, o_tag = 102 <LDAP_REQ_MODIFY>,
o_time = 1259003422, o_tincr = 0,
o_bd = 0x42ec62d0,
o_req_dn = {bv_len = 6, bv_val = 0x1f4e4400 "cn=log"},
o_req_ndn = {bv_len = 6, bv_val = 0x1f4e4310 "cn=log"},
o_request.oq_modify = {
rs_mods = {
rs_modlist = 0x42ec64c0 {
sml_mod = {
sm_desc = 0x1f4a46e0 <entryCSN>,
sm_values = 0x42ec6500 &[
{bv_len = 40, bv_val = 0x42ec6530 "20091123191016.381756Z#000000#000#000000\311_\214\031="},
BER_BVNULL],
sm_numvals = 1,
sm_op = 2,
sm_flags = 1,
sm_type = {bv_len = 4222451713, bv_val = 0x42ec6680 ""}}},
rs_no_opattrs = 1 '\001'}},
o_no_schema_check = 1 '\001',
o_ctrlflag = '\0' <repeats 14 times>, "\002", '\0' <repeats 16 times>,
o_controls = 0x42ec6948 &[(void *) 0x0],
o_authz = {
sai_dn = {bv_len = 28, bv_val = 0x1f4e46f0 "cn=Manager,dc=example,dc=com"},
sai_ndn = {bv_len = 28, bv_val = 0x1f4e4d90 "cn=manager,dc=example,dc=com"}},
o_callback = 0x1f958c80,
o_csn = {bv_len = 40, bv_val = 0x42ec6530 "20091123191016.381756Z#000000#000#000000\311_\214\031="},
o_extra = {slh_first = 0x1f958d28}}
(gdb) backtrace
#0 0x0000000000452066 in test_filter (op=0x42ec5bf0, e=0x1f577e48, f=0x0) at filterentry.c:69
#1 0x0000000000529cd1 in syncprov_matchops (op=0x42ec6690, opc=0x1f958ca0, saveit=1) at syncprov.c:1304
#2 0x000000000052c524 in syncprov_op_mod (op=0x42ec6690, rs=0x42ec6620) at syncprov.c:2064
#3 0x00000000004b3f0f in overlay_op_walk (op=0x42ec6690, rs=0x42ec6620, which=op_modify, oi=0x1f4e47e0, on=0x1f4e49c0) at backover.c:659
#4 0x00000000004b41a1 in over_op_func (op=0x42ec6690, rs=0x42ec6620, which=op_modify) at backover.c:721
#5 0x00000000004b42b7 in over_op_modify (op=0x42ec6690, rs=0x42ec6620) at backover.c:760
#6 0x0000000000521c67 in accesslog_purge (ctx=0x42ec6d60, arg=0x1f4e4760) at accesslog.c:699
#7 0x00000000005478ed in ldap_int_thread_pool_wrapper (xpool=0x1f4ae8a0) at tpool.c:685
#8 0x0000003d1a4064a7 in start_thread () from /lib64/libpthread.so.0
#9 0x0000003d198d3c2d in clone () from /lib64/libc.so.6
--
Hallvard
13 years, 10 months
Re: (ITS#6396) slow reads on slaves after many changes in master
by quanah＠zimbra.com
--On Monday, November 23, 2009 8:38 PM +0200 rolnas(a)gmail.com wrote:
> I raised (twice) to:
>
> cachesize 20000
> idlcachesize 100000
Ok, make sure dncachesize is set to zero as well. ;)
> BDB software is 4.6.21.4 (from FreeBSD ports as OpenLDAP itself).
>
> I have no time (sorry) to try compile and run current CVS version.
Well, as I said, there are a number of known problems with the entry cache
in 2.4.19 which are fixed in CVS. So when you find the time, I'd suggest
building the CVS version and using it instead. If it still occurs there,
the developers will probably want additional information.
--Quanah
--
Quanah Gibson-Mount
Principal Software Engineer
Zimbra, Inc
--------------------
Zimbra :: the leader in open source messaging and collaboration
13 years, 10 months
