[GENERAL] Re: [GENERAL] Re: [GENERAL] Re: [GENERAL] FATAL: no pg_hba.conf entry for host “::1***"
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 r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Re: [GENERAL] Re: [GENERAL] FATAL: no pg_hba.conf entry for host “::1***"
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 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
[GENERAL] Re: [GENERAL] FATAL: no pg_hba.conf entry for host “::1***"
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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] FATAL: no pg_hba.conf entry for host “::1***"
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
Re: [GENERAL] FATAL: no pg_hba.conf entry for host “::1”
morny writes: > # IPv4 local connections: > host all all 127.0.0.1/32 md5 > # IPv6 local connections: > #host all all ::1/128 md5 > So the issue seems to be with the last line on IPv6, Yup: it's commented out. Get rid of the '#'. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] FATAL: no pg_hba.conf entry for host “::1”
Hi, > > So the issue seems to be with the last line on IPv6, to be honest i dont > even know what IPv6 is, could disabling IPv6 do the trick or do i need to > add something? Your machine is connecting to PostgreSQL using IPv6's "localhost" address. IPv6 is a newer format of IP addressing that allows for more IP addresses - ::1 = 127.0.0.1, basically. Newer TCP/IP stacks attempt to connect to localhost using the IPv6 address first, instead of IPv4 (the current format.) When you connect, try passing "-h 127.0.0.1" to psql or whatever app/library you're using. That should force it to connect over IPv4. Or just uncomment the IPv6 line in your pg_hba.conf and restart PostgreSQL. > > The funny thing is with the exact same details a different application > connects to postgreSQL fine? Any ideas and bare in mind im a newbie when > explaining Is the different application on a different server? If so, it could be that the other app's OS is using IPv4 by default instead of IPv6. Or the app is connecting over an IPv4 address (e.g. 127.0.0.1) instead of "localhost." Regards, Andy