BUG #2696: odbc driver cannot connect
От | Ergin Ozekes |
---|---|
Тема | BUG #2696: odbc driver cannot connect |
Дата | |
Msg-id | 200610161452.k9GEq8Hn020295@wwwmaster.postgresql.org обсуждение исходный текст |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 2696 Logged by: Ergin Ozekes Email address: ozekes@ankara.edu.tr PostgreSQL version: 8.0 Operating system: ubuntu Description: odbc driver cannot connect Details: I have installed openldap with back-sql.I have not connected to postgres via openldap.I have get an error below.What is the problem? Please help me! Thanks! root@ergin-linux:/etc# /usr/local/libexec/slapd -f /etc/ldap/slapd.conf -d 1 @(#) $OpenLDAP: slapd 2.2.26 (Oct 22 2006 14:50:40) $ root@ergin-linux:/opt/openLdap/openldap-src/servers/slapd daemon_init: listen on ldap:/// daemon_init: 1 listeners to open... ldap_url_parse_ext(ldap:///) daemon: initialized ldap:/// daemon_init: 2 listeners opened slapd init: initiated server. ==>backsql_initialize() <==backsql_initialize() >>> dnNormalize: <cn=Subschema> => ldap_bv2dn(cn=Subschema,0) ldap_err2string <= ldap_bv2dn(cn=Subschema)=0 Success => ldap_dn2bv(272) ldap_err2string <= ldap_dn2bv(cn=subschema)=0 Success <<< dnNormalize: <cn=subschema> ==>backsql_db_init() ==>backsql_init_db_env() <==backsql_init_db_env()=0 <==backsql_db_init() >>> dnPrettyNormal: <o=sql,c=RU> => ldap_bv2dn(o=sql,c=RU,0) ldap_err2string <= ldap_bv2dn(o=sql,c=RU)=0 Success => ldap_dn2bv(272) ldap_err2string <= ldap_dn2bv(o=sql,c=RU)=0 Success => ldap_dn2bv(272) ldap_err2string <= ldap_dn2bv(o=sql,c=ru)=0 Success <<< dnPrettyNormal: <o=sql,c=RU>, <o=sql,c=ru> >>> dnPrettyNormal: <cn=root,o=sql,c=RU> => ldap_bv2dn(cn=root,o=sql,c=RU,0) ldap_err2string <= ldap_bv2dn(cn=root,o=sql,c=RU)=0 Success => ldap_dn2bv(272) ldap_err2string <= ldap_dn2bv(cn=root,o=sql,c=RU)=0 Success => ldap_dn2bv(272) ldap_err2string <= ldap_dn2bv(cn=root,o=sql,c=ru)=0 Success <<< dnPrettyNormal: <cn=root,o=sql,c=RU>, <cn=root,o=sql,c=ru> ==>backsql_db_config() <==backsql_db_config(): dbname=PgSQL ==>backsql_db_config() <==backsql_db_config(): dbuser=ldap ==>backsql_db_config() <==backsql_db_config(): dbpasswd=xxxx ==>backsql_db_config() <==backsql_db_config(): insentry_query=insert into ldap_entries (id,dn,oc_map_id,parent,keyval) values ((select max(id)+1 from ldap_entries),?,?,?,?) ==>backsql_db_config() <==backsql_db_config(): upper_func=upper ==>backsql_db_config() <==backsql_db_config(): strcast_func=text ==>backsql_db_config() <==backsql_db_config(): concat_pattern="?||?" ==>backsql_db_config() <==backsql_db_config(): has_ldapinfo_dn_ru=no matching_rule_use_init 1.2.840.113556.1.4.804 (integerBitOrMatch): matchingRuleUse: ( 1.2.840.113556.1.4.804 NAME 'integerBitOrMatch' APPLIES ( mailPreferenceOption $ supportedLDAPVersion ) ) 1.2.840.113556.1.4.803 (integerBitAndMatch): matchingRuleUse: ( 1.2.840.113556.1.4.803 NAME 'integerBitAndMatch' APPLIES ( mailPreferenceOption $ supportedLDAPVersion ) ) 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 ( janetMailbox $ cNAMERecord $ sOARecord $ nSRecord $ mXRecord $ mDRecord $ aRecord $ email $ associatedDomain $ dc $ mail $ altServer ) ) 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 ( janetMailbox $ cNAMERecord $ sOARecord $ nSRecord $ mXRecord $ mDRecord $ aRecord $ email $ associatedDomain $ dc $ mail $ altServer ) ) 2.5.13.35 (certificateMatch): matchingRuleUse: ( 2.5.13.35 NAME 'certificateMatch' APPLIES ( cACertificate $ userCertificate ) ) 2.5.13.34 (certificateExactMatch): matchingRuleUse: ( 2.5.13.34 NAME 'certificateExactMatch' APPLIES ( cACertificate $ userCertificate ) ) 2.5.13.30 (objectIdentifierFirstComponentMatch): matchingRuleUse: ( 2.5.13.30 NAME 'objectIdentifierFirstComponentMatch' APPLIES ( supportedApplicationContext $ ldapSyntaxes $ supportedFeatures $ supportedExtension $ supportedControl ) ) 2.5.13.29 (integerFirstComponentMatch): matchingRuleUse: ( 2.5.13.29 NAME 'integerFirstComponentMatch' APPLIES ( mailPreferenceOption $ supportedLDAPVersion ) ) 2.5.13.27 (generalizedTimeMatch): matchingRuleUse: ( 2.5.13.27 NAME 'generalizedTimeMatch' APPLIES ( modifyTimestamp $ createTimestamp ) ) 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 ( pager $ mobile $ homePhone $ telephoneNumber ) ) 2.5.13.17 (octetStringMatch): matchingRuleUse: ( 2.5.13.17 NAME 'octetStringMatch' APPLIES userPassword ) 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 ( mailPreferenceOption $ supportedLDAPVersion ) ) 2.5.13.13 (booleanMatch): matchingRuleUse: ( 2.5.13.13 NAME 'booleanMatch' APPLIES hasSubordinates ) 2.5.13.11 (caseIgnoreListMatch): matchingRuleUse: ( 2.5.13.11 NAME 'caseIgnoreListMatch' APPLIES ( homePostalAddress $ registeredAddress $ postalAddress ) ) 2.5.13.8 (numericStringMatch): matchingRuleUse: ( 2.5.13.8 NAME 'numericStringMatch' APPLIES ( internationaliSDNNumber $ x121Address ) ) 2.5.13.7 (caseExactSubstringsMatch): matchingRuleUse: ( 2.5.13.7 NAME 'caseExactSubstringsMatch' APPLIES ( dnQualifier $ destinationIndicator $ serialNumber ) ) 2.5.13.6 (caseExactOrderingMatch): matchingRuleUse: ( 2.5.13.6 NAME 'caseExactOrderingMatch' APPLIES ( dnQualifier $ destinationIndicator $ serialNumber ) ) 2.5.13.5 (caseExactMatch): matchingRuleUse: ( 2.5.13.5 NAME 'caseExactMatch' APPLIES ( preferredLanguage $ employeeType $ employeeNumber $ displayName $ departmentNumber $ carLicense $ documentPublisher $ buildingName $ organizationalStatus $ uniqueIdentifier $ co $ personalTitle $ documentLocation $ documentVersion $ documentTitle $ documentIdentifier $ host $ userClass $ roomNumber $ drink $ info $ textEncodedORAddress $ uid $ pseudonym $ dmdName $ houseIdentifier $ dnQualifier $ generationQualifier $ initials $ givenName $ destinationIndicator $ physicalDeliveryOfficeName $ postOfficeBox $ postalCode $ businessCategory $ description $ title $ ou $ o $ street $ st $ l $ c $ serialNumber $ sn $ knowledgeInformation $ labeledURI $ cn $ name $ ref $ vendorVersion $ vendorName $ supportedSASLMechanisms ) ) 2.5.13.4 (caseIgnoreSubstringsMatch): matchingRuleUse: ( 2.5.13.4 NAME 'caseIgnoreSubstringsMatch' APPLIES ( dnQualifier $ destinationIndicator $ serialNumber ) ) 2.5.13.3 (caseIgnoreOrderingMatch): matchingRuleUse: ( 2.5.13.3 NAME 'caseIgnoreOrderingMatch' APPLIES ( dnQualifier $ destinationIndicator $ serialNumber ) ) 2.5.13.2 (caseIgnoreMatch): matchingRuleUse: ( 2.5.13.2 NAME 'caseIgnoreMatch' APPLIES ( preferredLanguage $ employeeType $ employeeNumber $ displayName $ departmentNumber $ carLicense $ documentPublisher $ buildingName $ organizationalStatus $ uniqueIdentifier $ co $ personalTitle $ documentLocation $ documentVersion $ documentTitle $ documentIdentifier $ host $ userClass $ roomNumber $ drink $ info $ textEncodedORAddress $ uid $ pseudonym $ dmdName $ houseIdentifier $ dnQualifier $ generationQualifier $ initials $ givenName $ destinationIndicator $ physicalDeliveryOfficeName $ postOfficeBox $ postalCode $ businessCategory $ description $ title $ ou $ o $ street $ st $ l $ c $ serialNumber $ sn $ knowledgeInformation $ labeledURI $ cn $ name $ ref $ vendorVersion $ vendorName $ supportedSASLMechanisms ) ) 2.5.13.1 (distinguishedNameMatch): matchingRuleUse: ( 2.5.13.1 NAME 'distinguishedNameMatch' APPLIES ( dITRedirect $ associatedName $ secretary $ documentAuthor $ manager $ seeAlso $ roleOccupant $ owner $ member $ distinguishedName $ aliasedObjectName $ namingContexts $ subschemaSubentry $ modifiersName $ creatorsName ) ) 2.5.13.0 (objectIdentifierMatch): matchingRuleUse: ( 2.5.13.0 NAME 'objectIdentifierMatch' APPLIES ( supportedApplicationContext $ supportedFeatures $ supportedExtension $ supportedControl ) ) slapd startup: initiated. backend_startup: starting "o=sql,c=RU" ==>backsql_db_open(): testing RDBMS connection backsql_db_open(): subtree search SQL condition not specified (use "subtree_cond" directive in slapd.conf) backsql_db_open(): setting "upper(ldap_entries.dn) LIKE upper('%'||?)" as default backsql_db_open(): setting "upper(ldap_entries.dn)=upper(?)" as default 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_r eturn,sel_expr_u FROM ldap_attr_mappings WHERE oc_map_id=?" by default backsql_db_open(): entry deletion SQL statement not specified (use "delentry_query" directive in slapd.conf) backsql_db_open(): setting "DELETE FROM ldap_entries WHERE id=?" by default backsql_db_open(): objclasses deletion SQL statement not specified (use "delobjclasses_query" directive in slapd.conf) backsql_db_open(): setting "DELETE FROM ldap_entry_objclasses WHERE entry_id=?" by default backsql_db_open(): referrals deletion SQL statement not specified (use "delreferrals_query" directive in slapd.conf) backsql_db_open(): setting "DELETE FROM ldap_referrals WHERE entry_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 ==>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" Segmentation fault (core dumped) iodbc version 3.52.3-1 odbc-postgresql version 08.01.0102-1 GNU gdb 6.4-debian Copyright 2005 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "i486-linux-gnu"...(no debugging symbols found) Using host libthread_db library "/lib/tls/i686/cmov/libthread_db.so.1". (no debugging symbols found) Core was generated by `/usr/local/libexec/slapd -f /etc/ldap/slapd.conf -d 1'. Program terminated with signal 11, Segmentation fault. warning: Can't read pathname for load map: Input/output error. Reading symbols from /usr/lib/libiodbc.so.2...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libiodbc.so.2 Reading symbols from /usr/lib/i686/cmov/libssl.so.0.9.8...(no debugging symbols found)...done. Loaded symbols for /usr/lib/i686/cmov/libssl.so.0.9.8 Reading symbols from /usr/lib/i686/cmov/libcrypto.so.0.9.8...(no debugging symbols found)...done. Loaded symbols for /usr/lib/i686/cmov/libcrypto.so.0.9.8 Reading symbols from /lib/tls/i686/cmov/libcrypt.so.1...(no debugging symbols found)...done. Loaded symbols for /lib/tls/i686/cmov/libcrypt.so.1 Reading symbols from /lib/tls/i686/cmov/libresolv.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/tls/i686/cmov/libresolv.so.2 Reading symbols from /lib/tls/i686/cmov/libpthread.so.0... (no debugging symbols found)...done. Loaded symbols for /lib/tls/i686/cmov/libpthread.so.0 Reading symbols from /lib/tls/i686/cmov/libc.so.6...(no debugging symbols found)...done. Loaded symbols for /lib/tls/i686/cmov/libc.so.6 Reading symbols from /usr/lib/libiodbcinst.so.2...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libiodbcinst.so.2 Reading symbols from /lib/tls/i686/cmov/libdl.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/tls/i686/cmov/libdl.so.2 Reading symbols from /usr/lib/libz.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libz.so.1 Reading symbols from /lib/ld-linux.so.2... (no debugging symbols found)...done. Loaded symbols for /lib/ld-linux.so.2 Reading symbols from /lib/tls/i686/cmov/libnss_files.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/tls/i686/cmov/libnss_files.so.2 Reading symbols from /lib/tls/i686/cmov/libnss_compat.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/tls/i686/cmov/libnss_compat.so.2 Reading symbols from /lib/tls/i686/cmov/libnsl.so.1...(no debugging symbols found)...done. Loaded symbols for /lib/tls/i686/cmov/libnsl.so.1 Reading symbols from /lib/tls/i686/cmov/libnss_nis.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/tls/i686/cmov/libnss_nis.so.2 Reading symbols from /usr/lib/postgresql/lib/psqlodbc.so... (no debugging symbols found)...done. Loaded symbols for /usr/lib/postgresql/lib/psqlodbc.so Reading symbols from /usr/lib/libpq.so.4...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libpq.so.4 Reading symbols from /usr/lib/libodbcinst.so.1...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libodbcinst.so.1 Reading symbols from /usr/lib/libkrb5.so.3...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libkrb5.so.3 Reading symbols from /usr/lib/libk5crypto.so.3...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libk5crypto.so.3 Reading symbols from /lib/libcom_err.so.2... (no debugging symbols found)...done. Loaded symbols for /lib/libcom_err.so.2 Reading symbols from /usr/lib/libltdl.so.3...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libltdl.so.3 Reading symbols from /usr/lib/libkrb5support.so.0...(no debugging symbols found)...done. Loaded symbols for /usr/lib/libkrb5support.so.0 #0 0xb7c6246e in free () from /lib/tls/i686/cmov/libc.so.6 (gdb) backtrace #0 0xb7c6246e in free () from /lib/tls/i686/cmov/libc.so.6 #1 0xb7c64411 in malloc () from /lib/tls/i686/cmov/libc.so.6 #2 0xb7db5f7e in OPENSSL_stderr () from /usr/lib/i686/cmov/libcrypto.so.0.9.8 #3 0xb7db64fb in CRYPTO_malloc () from /usr/lib/i686/cmov/libcrypto.so.0.9.8 #4 0xb7e1fb6e in EVP_DigestInit_ex () from /usr/lib/i686/cmov/libcrypto.so.0.9.8 #5 0xb7dcdaba in HMAC_Init_ex () from /usr/lib/i686/cmov/libcrypto.so.0.9.8 #6 0xb7ecf6ca in tls1_mac () from /usr/lib/i686/cmov/libssl.so.0.9.8 #7 0xb7ecb054 in ssl3_write_pending () from /usr/lib/i686/cmov/libssl.so.0.9.8 #8 0xb7ecb0a7 in ssl3_write_pending () from /usr/lib/i686/cmov/libssl.so.0.9.8 #9 0xb7ecb1db in ssl3_write_bytes () from /usr/lib/i686/cmov/libssl.so.0.9.8 #10 0xb7ec9531 in ssl3_write () from /usr/lib/i686/cmov/libssl.so.0.9.8 #11 0xb7ed8916 in SSL_write () from /usr/lib/i686/cmov/libssl.so.0.9.8 #12 0xb7b3ffdf in pqsecure_write () from /usr/lib/libpq.so.4 #13 0xb7b385e4 in pqReadData () from /usr/lib/libpq.so.4 #14 0xb7b35ea1 in PQsendQuery () from /usr/lib/libpq.so.4 #15 0xb7b36569 in PQexec () from /usr/lib/libpq.so.4 #16 0xb7b5e04a in LIBPQ_execute_query () from /usr/lib/postgresql/lib/psqlodbc.so #17 0xb7b5e5fc in CC_send_query () from /usr/lib/postgresql/lib/psqlodbc.so #18 0xb7b7b252 in SC_execute () from /usr/lib/postgresql/lib/psqlodbc.so #19 0xb7b694d8 in PGAPI_Prepare () from /usr/lib/postgresql/lib/psqlodbc.so #20 0xb7b69a98 in PGAPI_Execute () from /usr/lib/postgresql/lib/psqlodbc.so #21 0xb7b804cb in SQLExecute () from /usr/lib/postgresql/lib/psqlodbc.so #22 0xb7efdee1 in SQLExecute () from /usr/lib/libiodbc.so.2 #23 0x080a8ca6 in ?? () #24 0x0816b920 in ?? () #25 0xbfb5f578 in ?? () #26 0x0815d160 in ?? () #27 0x00000000 in ?? ()
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Martijn van OosterhoutДата:
Сообщение: Re: [HACKERS] BUG #2683: spi_exec_query in plperl returns