BUG #2696: odbc driver cannot connect

From: "Ergin Ozekes" <ozekes(at)ankara(dot)edu(dot)tr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2696: odbc driver cannot connect
Date: 2006-10-16 14:52:08
Message-ID: 200610161452.k9GEq8Hn020295@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2696
Logged by: Ergin Ozekes
Email address: ozekes(at)ankara(dot)edu(dot)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(at)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(at)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 ?? ()

Browse pgsql-bugs by date

  From Date Subject
Next Message Paul Laughlin 2006-10-16 16:16:46 duplicate key violates unique constraint pg_toast_635216540
Previous Message Tom Lane 2006-10-16 14:28:06 Re: [HACKERS] BUG #2683: spi_exec_query in plperl returns