[ psqlodbc-Bugs-1010368 ] connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0 - Mailing list pgsql-odbc

Bugs item #1010368, was opened at 2008-03-31 09:31
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010368&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Sebastian Reitenbach (buzzdee)
Assigned to: Nobody (None)
Summary: connection problem with postgresql driver 8.03.0100 to postgresql 8.3.0

Initial Comment:
I compiled postgres odbc driver version 8.03.0100, but when I try to connect
to a 8.3.0 postgres database, then there connection/authentication problems
happen:

isql FIS MyUser MyPassword -v
[28000][unixODBC]Communication error during authentication;
Error while reading from the socket.
[ISQL]ERROR: Could not SQLConnect
dbuser@dbhost:~> isql FIS MyDatabase MyDatabase -v
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

I can only connect to the database by a chance of 1/10. Also when I get
connected, then when I try entering a SQL statement, I get error messages
about not being connected anymore.

and below the postgres log from the tries:


 LOG:  connection authorized: user=MyUser database=MyDatabase
LOG:  unexpected EOF on client connection
LOG:  disconnection: session time: 0:00:00.002 user=MyUser
database=MyDatabase
host=192.168.15.106 port=52224
DEBUG:  server process (PID 19939) exited with exit code 0
LOG:  connection received: host=192.168.15.106 port=52225
DEBUG:  forked new backend, pid=19941 socket=6
LOG:  connection authorized: user=MyUser database=MyDatabase
LOG:  unexpected EOF on client connection
LOG:  disconnection: session time: 0:00:00.003 user=MyDatabase
database=MyDatabase
host=192.168.15.106 port=52225
DEBUG:  server process (PID 19941) exited with exit code 0
LOG:  connection received: host=192.168.15.106 port=52226
DEBUG:  forked new backend, pid=19943 socket=6
LOG:  connection authorized: user=MyUser database=MyDatabase
LOG:  statement:
LOG:  statement: select version()
LOG:  statement: set DateStyle to 'ISO'
LOG:  statement: set geqo to 'OFF'
LOG:  statement: set extra_float_digits to 2
LOG:  statement: select oid, typbasetype from pg_type where typname = 'lo'
LOG:  statement: select pg_client_encoding()
ERROR:  synt x error at or near " at character 1
LOG:  could not send data to client: Broken pipe
LOG:  unexpected EOF on client connection

This is the part of the configuration from my odbc.ini:
[FIS]
Description             = PostgreSQL DB
Driver                  = PostgreSQL
commlog = yes
Database                = MyDatabase
Host       = localhost
Server     = localhost
ServerName = pdtest106.pdtest.intern
Username                = MyUser
Password                = MyPassword
Port                    = 5430
Protocol                = 6.4
ReadOnly                = No
RowVersioning           = No
ShowSystemTables        = No
ShowOidColumn           = No
FakeOidIndex            = No
ConnSettings            =

Actually, I have no idea, what the protocol version number means. The
version 6.4 was the one I found most of the time in the net. I also tried to
set it to 8.3, and 8.3.0, but with no difference. Any pointer to an
explanation would be great.

when I exchange the odbc driver file, with an older one, odbc drvier version
8.1.2, then I do not have connection/login problems at all.

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2008-03-31 12:23

Message:
Could you attach the Mylog output ?
You will be able to take the log (/tmp/mylog_xxxx.log) by adding the line
Debug = 1
to your odbc.ini.

regards,
Hiroshi Inoue


----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010368&group_id=1000125