Обсуждение: 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
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 >
Re: FATAL: no pg_hba.conf entry for host "???", user "rajaram", database "template1", SSL off
От
"Brian A. Seklecki"
Дата:
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
>
>
>
>
>
>
>