Lists: | pgsql-general |
---|
From: | itishree sukla <itishree(dot)sukla(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | FATAL: no pg_hba.conf entry for host “::1***" |
Date: | 2011-02-23 06:38:04 |
Message-ID: | AANLkTikCTGAsyCs__DNTaHxjxa+YDQrJ_H=92huQouRy@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Hi All,
I am using System DSN, that connects to postgreSQL, to fetch data from the
database, and put into xls sheet .Its working fine with most of the machines
and connects fine but on 1 machine i am getting this FATAL: no pg_hba.conf
entry for host “::1******”, user “postgres”, database “myDatabase", SSL off
error. Any idea why it is so, please suggest.
Thanks in advance ...
Regards,
Itishree
From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] FATAL: no pg_hba.conf entry for host “::1***" |
Date: | 2011-02-23 07:09:15 |
Message-ID: | 4D64B29B.9000405@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On 02/22/11 10:38 PM, itishree sukla wrote:
> Hi All,
> I am using System DSN, that connects to postgreSQL, to fetch data
> from the database, and put into xls sheet .Its working fine with most
> of the machines and connects fine but on 1 machine i am getting this
> FATAL: no pg_hba.conf entry for host “::1******”, user “postgres”,
> database “myDatabase", SSL off error. Any idea why it is so, please
> suggest.
> Thanks in advance ...
>
::1 is the IPv6 localhost. sounds like this system has ipv6 configured,
so you probably want a line in pg_hba.conf like...
hosts all all ::1 md5
(replace the md5 with whatever you normally use on the localhost linet
hat looks like
hosts all all 127.0.0.0/8 md5
the other common value is 'trust'. md5 requires a password, trust doesn't.
From: | itishree sukla <itishree(dot)sukla(at)gmail(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Re: [GENERAL] FATAL: no pg_hba.conf entry for host “::1***" |
Date: | 2011-02-23 08:19:45 |
Message-ID: | AANLkTikaEzaEToMawPLL3h_WMnSFyLe0=s=yL1m2M-=+@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Hi John,
Thanks for your reply, however the the address is starting with host
"58.137.154.189". It was working fine before, however not working in new
system.
On Wed, Feb 23, 2011 at 12:39 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> On 02/22/11 10:38 PM, itishree sukla wrote:
>
>> Hi All,
>> I am using System DSN, that connects to postgreSQL, to fetch data from
>> the database, and put into xls sheet .Its working fine with most of the
>> machines and connects fine but on 1 machine i am getting this FATAL: no
>> pg_hba.conf entry for host “::1******”, user “postgres”, database
>> “myDatabase", SSL off error. Any idea why it is so, please suggest.
>> Thanks in advance ...
>>
>>
> ::1 is the IPv6 localhost. sounds like this system has ipv6 configured, so
> you probably want a line in pg_hba.conf like...
>
>
> hosts all all ::1 md5
>
> (replace the md5 with whatever you normally use on the localhost linet hat
> looks like
>
> hosts all all 127.0.0.0/8 md5
>
> the other common value is 'trust'. md5 requires a password, trust
> doesn't.
>
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | itishree sukla <itishree(dot)sukla(at)gmail(dot)com> |
Cc: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Re: [GENERAL] Re: [GENERAL] FATAL: no pg_hba.conf entry for host “::1***" |
Date: | 2011-02-23 11:13:41 |
Message-ID: | 4D64EBE5.6030605@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On 23/02/2011 08:19, itishree sukla wrote:
> Hi John,
> Thanks for your reply, however the the address is starting with host
> "58.137.154.189". It was working fine before, however not working in
> new system.
>
Well, that's an IPv4 address, and as John said it looks as if your new
system is trying to connect over IPv6.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie