Bugs item #1000600, was opened at 2006-03-27 18:44
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000600&group_id=1000125
Category: Interface (example)
Group: v1.0 (example)
Status: Closed
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: odbc via the local net (lan & Wan)
Initial Comment:
When you have installed the odbc driver local where the db also is installed, it does work.
When you have istalled the odbc driver local on a client machine, the connection failed - it is always looking for the
pg_hba.conffile.
-
log:
LIBPQ returned -> FATAL: missing or erroneous pg_hba.conf file
HINT: See server log for details.
[1452]CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect', errnum=113, sqlstate=08001, errmsg='FATAL:
missingor erroneous pg_hba.conf file
HINT: See server log for details.
'
[1452][SQLGetDiagRecW]
----------------------------------------------------------------------
>Comment By: Dave Page (dpage)
Date: 2010-05-05 10:58
Message:
Yes, the error does come from the server. psqlODBC doesn't have any way to read the pg_hba.conf file - that is *always*
doneby the server, which will return the error shown if it cannot parse the file.
If you believe I am incorrect, please feel free to check the source code and see for yourself.
----------------------------------------------------------------------
Comment By: Sorin Cristescu (scr53005)
Date: 2010-05-05 10:26
Message:
Hi,
I have the same problem. The pg_hba.conf is NOT missing and does NOT contain an error : the server works fine AND
psqlODBCworks fine AS LONG AS I set the "Server" as 127.0.0.1 when defining a psqlODBC-based DSN. BUT ... when I
replace127.0.0.1 with 10.128.54.77 (IP address of the Postgres server ...) I get a "missing or erroneous pg_hba.conf".
Theerror is NOT reported by the server, it only appears when defining a DSN in odbcad32.exe
----------------------------------------------------------------------
Comment By: Dave Page (dpage)
Date: 2006-04-28 08:24
Message:
This error is being reported by the server because your pg_hba.conf file is missing or contains an error. This is not
apsqlodbc problem.
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000600&group_id=1000125