Re: FATAL: no pg_hba.conf entry for host "???", user "rajaram", database "template1", SSL off - Mailing list pgsql-novice

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@hotmail.com>
To: <pgsql-novice@postgresql.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
>