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

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@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
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>
>
>
>
>
>
>