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
