From: | "Stefan Viljoen" <viljoens(at)verishare(dot)co(dot)za> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client |
Date: | 2015-07-21 07:11:50 |
Message-ID: | 000301d0c384$83ffc060$8bff4120$@verishare.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi List
The problems continue - I've now raised the debug logging values to maximum
on the 9.4 instance here that I cannot connect to via unixODBC in Centos
6.5.
This is what the log looks like if I run
---
isql -v pgdb-cdr dbuser dbpass
---
:
---
< 2015-07-21 09:05:11.187 SAST >LOG: 00000: connection received:
host=[local]
< 2015-07-21 09:05:11.187 SAST >LOCATION: BackendInitialize,
postmaster.c:4007
< 2015-07-21 09:05:11.188 SAST >LOG: 00000: connection authorized:
user=dbuser database=dbpass
< 2015-07-21 09:05:11.188 SAST >LOCATION: PerformAuthentication,
postinit.c:258
< 2015-07-21 09:05:11.193 SAST >LOG: 08006: could not send data to client:
Broken pipe
< 2015-07-21 09:05:11.193 SAST >LOCATION: internal_flush, pqcomm.c:1368
< 2015-07-21 09:05:11.193 SAST >FATAL: 08006: connection to client lost
< 2015-07-21 09:05:11.193 SAST >LOCATION: ProcessInterrupts,
postgres.c:2885
< 2015-07-21 09:05:11.193 SAST >LOG: 00000: disconnection: session time:
0:00:00.006 user=dbuser database=dbpass host=[local]
< 2015-07-21 09:05:11.193 SAST >LOCATION: log_disconnections,
postgres.c:4511
---
This generates on the commandline
---
# isql -v pgdb-cdr dbuser dbpass
[S1000][unixODBC]The database does not exist on the server
or user authentication failed.
[ISQL]ERROR: Could not SQLConnect
---
so the real problem is a broken UNIX pipe when isql is trying to connect to
Postgres.
Any idea what I can do with this new information in order to solve the ODBC
connection problem from isql?
Thanks
Stefan
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Viljoen | 2015-07-21 07:31:33 | Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client |
Previous Message | Stefan Viljoen | 2015-07-20 13:14:38 | Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client |