Re: FATAL: no pg_hba.conf entry for host "???", user "rajaram", database "template1", SSL off

["Brian A. Seklecki" <lavalamp(at)spiritual-machines(dot)org>]

Something to do with gethostbyaddr(3) on HP.  Maybe the code in socket(2) 
that distinqushes between loopback and TCP connections:

        PF_LOCAL Host-internal protocols, formerly called PF_UNIX,
        PF_UNIX Host-internal protocols, deprecated, use PF_LOCAL,
        PF_INET Internet version 4 protocols,

~~BAS

On Sun, 19 Aug 2007, Rajaram J wrote:

> Hi
>
> I just wanted to add a few more things
>
> I have sucessfully compiled on a PA box with the same OS using a gcc compiler 
> and in the IA box im using cc compiler.
>
> The configure options I'm using in the m/c are as follows
>
> PA
> ----
> export LDFLAGS="-Wl,+nodefaultrpath"
> export LIBS="-lkrb5 -lk5crypto -lcom_err -Wl,+nodefaultrpath"
> export 
> PATH="/usr/local/pa20_64/bin:$PATH:/usr/contrib/bin:/usr/local/bin:/usr/ccs/bin"
>
> ./configure CC=/usr/local/bin/gcc --prefix=/opt/sfmdb/pgsql 
> --with-pgport=10864 --with-krb5=/usr --with-openssl=/opt/openssl 
> --enable-integer-datetimes --without-zlib --without-readline
>
>
>
> IA
> ----
> export LDFLAGS="-Wl,+nodefaultrpath"
> export LIBS="-lkrb5 -lk5crypto -lcom_err"
> export CC="/usr/bin/cc +DD64"
>
> ./configure --prefix=/opt/sfmdb/pgsql --libdir=/opt/sfmdb/pgsql/lib/hpux64 
> --with-pgport=10864 --with-krb5=/usr --with-openssl=/opt/openssl 
> --enable-integer-datetimes --without-readline --without-zlib
>
>
>
>
> ----- Original Message ----- From: "Rajaram J" <rajarj(at)hotmail(dot)com>
> To: <pgsql-novice(at)postgresql(dot)org>
> Sent: Sunday, August 19, 2007 1:48 PM
> Subject: [NOVICE] FATAL: no pg_hba.conf entry for host "???", user "rajaram", 
> database "template1", SSL off
>
>
> > Hi
> >
> > I built PostGreSql 7.4.17 on HP-UX 11.23 m/c IA m/c.
> >
> > After compilation when i do a gmake check as a diff user as recomended i 
> > get the message
> >
> >
> > ============== creating database "regression"         ==============
> > createdb: could not connect to database template1: FATAL:  no pg_hba.conf 
> > entry for host "???", user "rajaram", database "template1", SSL off
> > pg_regress: createdb failed
> > gmake[2]: *** [check] Error 2
> > gmake[2]: Leaving directory 
> > `/postgresql/postgresql-7.4.17/src/test/regress'
> > gmake[1]: *** [check] Error 2
> > gmake[1]: Leaving directory `/postgresql/postgresql-7.4.17/src/test'
> > gmake: *** [check] Error 2
> >
> >
> > my pg_hba.conf entry is
> >
> > # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
> > local   all         all                                             trust
> >
> > # IPv4-style local connections:
> > host all         all         127.0.0.1          255.255.255.255 trust
> >
> > # IPv6-style local connections:
> > host    all         all         ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff 
> > trust
> >
> >
> > the message in the postmaster.log file is
> > ....
> > FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database 
> > "template1", SSL off
> > FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database 
> > "template1", SSL off
> > FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database 
> > "template1", SSL off
> > FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database 
> > "template1", SSL off
> > FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database 
> > "template1", SSL off
> > FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database 
> > "template1", SSL off
> > FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database 
> > "template1", SSL off
> > LOG:  received fast shutdown request
> > LOG:  shutting down
> > LOG:  database system is shut down
> >
> >
> >
> > when i added one more entry to the file pg_hba.conf
> > # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
> > local   all         all                                             trust
> >
> > # IPv4-style local connections:
> > host all         all         127.0.0.1          255.255.255.255 trust
> > host all         all         15.11.135.124          255.255.255.255 trust
> >
> > # IPv6-style local connections:
> > host    all         all         ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff 
> > trust
> >
> >
> >
> > createdb: could not connect to database template1: FATAL:  no pg_hba.conf 
> > entry for host "???", user "rajaram", database "template1", SSL off
> >
> > the message in the postmaster.log file is the same
> >
> >
> > I have ran out of options, Can any one please help.
> >
> > Regards
> >
> > Rajaram J
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> >               http://www.postgresql.org/docs/faq
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>      message can get through to the mailing list cleanly