pg_hba.conf problem
I'm trying to set up the cyrus imap server using PostgreSQL as the
authentication backend.
Currently, the issue I'm having is that I'm unable to connect via psql
on the loopback address (127.0.0.1).
I believe I have the pg_hba.conf file correct, though I've tried a
number of variations other than what I've included below. After each
change to pg_hba.conf, I bounce postgresql (stop start), but still get
a FATAL error re: missing entries for 127.0.0.1.
I'm stumped. I'm probably missing something simple, but I've looked at
a number of samples on usenet and in the PostgreSQL doco, but I haven't
been able to clear this up.
pg_hba.conf
===========
local all all ident sameuser
host all all 127.0.0.1/32 password
command and error
=================
[root@netfinity root]# psql mail -U mail -W -h 127.0.0.1 <
/var/www/html/web-cyradm-0.5.3-1/scripts/create_pgsql.sql
Password: *********
psql: FATAL: No pg_hba.conf entry for host 127.0.0.1, user mail,
database mail
[root@netfinity root]#
Any ideas?
-David
David Nedrow writes:
pg_hba.conf
===========local all all ident sameuser
host all all 127.0.0.1/32 passwordcommand and error
=================[root@netfinity root]# psql mail -U mail -W -h 127.0.0.1 <
/var/www/html/web-cyradm-0.5.3-1/scripts/create_pgsql.sql
Password: *********
psql: FATAL: No pg_hba.conf entry for host 127.0.0.1, user mail,
database mail
The syntax x.x.x.x/y is only supported in 7.4, but you appear to be using
something older than 7.4.
--
Peter Eisentraut peter_e@gmx.net
Peter,
Note that I've also tried the following straight for the original
pg_hba.conf file itself. No luck.
# TYPE DATABASE USER IP-ADDRESS IP-MASK
METHOD
host all all 127.0.0.1 255.255.255.255
password
On Nov 30, 2003, at 14:05, Peter Eisentraut wrote:
Show quoted text
David Nedrow writes:
pg_hba.conf
===========local all all ident sameuser
host all all 127.0.0.1/32 passwordcommand and error
=================[root@netfinity root]# psql mail -U mail -W -h 127.0.0.1 <
/var/www/html/web-cyradm-0.5.3-1/scripts/create_pgsql.sql
Password: *********
psql: FATAL: No pg_hba.conf entry for host 127.0.0.1, user mail,
database mailThe syntax x.x.x.x/y is only supported in 7.4, but you appear to be
using
something older than 7.4.--
Peter Eisentraut peter_e@gmx.net
On Sun, Nov 30, 2003 at 06:10:08PM -0500, David Nedrow wrote:
Note that I've also tried the following straight for the original
pg_hba.conf file itself. No luck.host all all 127.0.0.1 255.255.255.255
password
Huh, did you cause the postmaster to reload the pg_hba.conf file after
changing it? You should send it SIGHUP (kill -HUP) or use pg_ctl reload.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Crear es tan dif�cil como ser libre" (Elsa Triolet)
Alvaro,
Thanks for the reply. I previously did both of those, as well as
shutting postmaster down altogether and restarting. Still no luck.
I'm sure postmaster is seeing the file, since I can break "local"
support by changing that line. <G>
-David
On Nov 30, 2003, at 18:32, Alvaro Herrera wrote:
Show quoted text
On Sun, Nov 30, 2003 at 06:10:08PM -0500, David Nedrow wrote:
Note that I've also tried the following straight for the original
pg_hba.conf file itself. No luck.host all all 127.0.0.1 255.255.255.255
passwordHuh, did you cause the postmaster to reload the pg_hba.conf file after
changing it? You should send it SIGHUP (kill -HUP) or use pg_ctl
reload.--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Crear es tan difícil como ser libre" (Elsa Triolet)
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
On Sun, Nov 30, 2003 at 06:10:08PM -0500, David Nedrow wrote:
Note that I've also tried the following straight for the original
pg_hba.conf file itself. No luck.
Huh, did you cause the postmaster to reload the pg_hba.conf file after
changing it? You should send it SIGHUP (kill -HUP) or use pg_ctl reload.
He said he was using full postmaster restarts, which certainly ought to
do the trick.
The only other idea I can think of is he's editing the wrong pg_hba.conf
file; we've seen a couple of people make that mistake. (David, the
right pg_hba.conf file is the one in the $PGDATA directory. If you
don't see a postmaster.pid file in the same directory that appears and
disappears when you start and stop the postmaster, then you're in the
wrong directory ...)
regards, tom lane
On Nov 30, 2003, at 21:01, Tom Lane wrote:
The only other idea I can think of is he's editing the wrong
pg_hba.conf
file; we've seen a couple of people make that mistake. (David, the
right pg_hba.conf file is the one in the $PGDATA directory. If you
don't see a postmaster.pid file in the same directory that appears and
disappears when you start and stop the postmaster, then you're in the
wrong directory ...)
Ta-Da!
That was it. For some reason, I had an old pgsql/data tree laying
around that I was futzing with. Looking for postmaster.pid did the
trick.
What I can't figure out is how I was breaking "local" access by editing
the non-local file. Maybe I was just too tired after 18 hours of
debugging Mozilla stuff. <G>
Thanks for the help.
-David