Skip site navigation (1) Skip section navigation (2)

Re: psqlODBC driver does not work

From: "Yury Koles" <fresh_impression(at)hotmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: psqlODBC driver does not work
Date: 2004-05-16 07:00:48
Message-ID: BAY16-F61wwAZm7eSpy00024a7e@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Still a problem...  I need suggestions of how do I
troubleshoot.  Any tools or techniques I might use?
Thank you for all your previous help!

Some info about my case, in case if needed:
RedHat 9, PostgreSQL 7.4.2, unixODBC 2.2.8 (driver
manager), psqlODBC 07.03.0200 driver.  The driver's
directory: /usr/local/lib/psqlodbc.so

>Are you using the full path to psqlodbc.so in your
>odbcinst.ini ?
Yes.

I modified the 'odbcinst.ini' as suggested:

--- odbcinst.ini ---
[PostgreSQL_psqlODBC]
Description	= psqlODBC for PostgreSQL
Driver = /usr/local/lib/psqlodbc.so
#Setup = /usr/local/lib/libodbcpsqlS.so
FileUsage	= 1
CommLog = 1
Debug = 1
---(END) odbcinst.ini ---

But still, if I enter literally (I set my **PostgreSQL
account** password to 'pword' which is different from
my reqular user account password).

isql -v examples_ODBC yury pword

'isql' hangs and I have to kill it with ^C.
Same thing happens if I uncomment
'Setup = /usr/local/lib/libodbcpsqlS.so'
and the same log files are produced. Similarly, the
'DataManager' or 'DataManagerII (what's a difference?)
GUI applications hang once I enter the password and
also produces the same log files.  More advanced
software such as OpenOffice's data sources obviously do
not work (they work with the JDBC driver though and do
that even using md5-encrypted passwords).  Here are two
debugging log files:

---mylog_yury6543.log---
[1074834880]CC_connect: entering...
[1074834880]CC_connect(): DSN = 'examples_ODBC', server
= 'localhost', port = '5432', database = 'examples',
username = 'yury', password='xxxxx'
[1074834880]connecting to the server socket...
[1074834880]connection to the server socket succeeded.
[1074834880]sizeof startup packet = 292
[1074834880]sent the authentication block.
[1074834880]sent the authentication block successfully.
[1074834880]gonna do authentication
[1074834880]read 15, global_socket_buffersize=4096
[1074834880]auth got 'R'
[1074834880]areq = 0
[1074834880]auth got 'K'
[1074834880]auth got 'Z'
[1074834880]sending an empty query...
[1074834880]send_query(): conn=134628032, query=' '
---(END) mylog_yury6543.log---

---psqlodbc_yury6543.log-----------------------------
conn = 134628032, PGAPI_Connect(DSN='examples_ODBC',
UID='yury', PWD='xxxxx') Global Options:
Version='07.03.0200', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254,
max_longvarchar_size=8190
                disable_optimizer=1, ksqo=1,
                unique_index=1, use_declarefetch=0
                text_as_longvarchar=1,
                unknowns_as_longvarchar=0,
                bools_as_char=1 NAMEDATALEN=64
                extra_systable_prefixes='dd_;',
                conn_settings='' conn_encoding='OTHER'
conn=134628032, query=' '
---(END) psqlodbc_yury6543.log--------------------

I either don't see or don't understand the trouble in
the log files (no explicit ERROR messages).  I also
tried leaving my system wide open securitywise as the
rest of my config files suggest.  unixODBC driver did
not work with 'md5' or 'crypt' passwords, but did work
with 'trust' or 'password' in 'pg_hba.conf'.

---.odbc.ini---
[ODBC Data Sources]
examples_ODBC = Database Examples

[examples_ODBC]
Database = examples
Description	= Various tutorial examples
ReadOnly = No
Servername = localhost
Port = 5432
Protocol = 7.4
Driver = PostgreSQL_psqlODBC
Username =
Password =
Trace = Yes
Tracefile = /tmp/ODBC.log
CommLog = 1
Debug = 1
---(END) .odbc.ini-----

My systemwide 'odbc.ini' is empty.

---postgresql.conf---
tcpip_socket = true
max_connections = 63
password_encryption = false
lc_messages = 'en_US.UTF-8'
lc_monetary = 'en_US.UTF-8'
lc_numeric = 'en_US.UTF-8'
lc_time = 'en_US.UTF-8'
# The rest are defaults.
---(END) postgresql.conf---

---pg_hba.conf---
local all all              trust
host  all all 127.0.0.1/32 trust
---(END) pg_hba.conf---

Again, I will be thankful for your good advice!

Yury


>	By the way, I think you can drop the Setup variable from your
>odbcinst.ini. I think that only had meaning for the unixODBC version of
>the driver. Here's what the postgres entry in my odbcinst.ini looks
>like.
>
>[PostgreSQL]
>Description		= PostgreSQL 7.4.2 driver (psqlodbc-7.3.2)
>Driver			= /opt3/lib/psqlodbc.so
>FileUsage		= 1
>CPTimeout		=
>CPReuse			=
>CommLog			= 1
>Debug			= 1
>
>
>Cheers,
>Bob
>

_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from McAfee 
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


pgsql-odbc by date

Next:From: Andre Felipe MachadoDate: 2004-05-16 12:45:01
Subject: Re: BLOB issue(s) & questions
Previous:From: Tom LaneDate: 2004-05-15 18:17:00
Subject: Re: psqlODBC driver does not work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group