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

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
>