ODBC from win2k to postgres on Linux HELL
ODBC from win2k to postgres on Linux HELL
I get the following error message:
no pg_hba.conf entry for host 192.168.0.4 user postgres database gims_dev
despite the following line is in the pg_hba.conf file.
host all 192.168.0.4 255.255.255.255 trust
I restarted the server too.
Very frustrated...
________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag
---- On Wed, 6 Mar 2002, Patrick Welche (prlw1@newn.cam.ac.uk) wrote:
Show quoted text
On Wed, Mar 06, 2002 at 12:30:20PM -0500, Eric Webber wrote:
I just now added a line which reads:
host all 192.168.0.0 255.255.255.0 trust
do I have to restart the server ?
At least kill -HUP it - can always restart to be on the safe side..
I believe I compiled with ODBC support, but how do I check
for sure ?I don't think you need to compile in ODBC support - what you installed
is on the windoze box, and it talks directly to the postmaster..BTW remember the -i flag..
Patrick
-----Original Message-----
From: Eric Webber [mailto:streethockey@ureach.com]
Sent: 06 March 2002 20:28
To: Patrick Welche; pgsql-general@postgresql.org;
pgsql-odbc@postgresql.org
Subject: [ODBC] ODBC from win2k to postgres on Linux HELLODBC from win2k to postgres on Linux HELL
I get the following error message:
no pg_hba.conf entry for host 192.168.0.4 user postgres
database gims_devdespite the following line is in the pg_hba.conf file.
host all 192.168.0.4 255.255.255.255 trust
I restarted the server too.
Very frustrated...
Do you have any entries in the file _before_ this one that might reject your
connection? The entries are tried sequentially, so the first match will be
used.
Regards, Dave.
Import Notes
Resolved by subject fallback
Did you fix the problem? If not,
1) Which Linux distro do you use?
2) What is your PostgreSQL version?
/Jean-Michel POURE
fixed the problem, thanks for everyones help !!
---- On Thu, 7 Mar 2002, Jean-Michel POURE
(jm.poure@freesurf.fr) wrote:
Did you fix the problem? If not,
1) Which Linux distro do you use?
2) What is your PostgreSQL version?
/Jean-Michel POURE---------------------------(end of broadcast)-----------------
----------
TIP 5: Have you checked our extensive FAQ?
________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag
Import Notes
Resolved by subject fallback