Thread: Facing authentication error on postgres 9.2 -> dblink functions

Facing authentication error on postgres 9.2 -> dblink functions

From

Dev Kumkar

Date:

06 February 2013, 16:09:21

Hello Everyone,

I am using postgres 9.2 and when executing function dblink facing a fatal error while trying to execute dblink_connect as follows:

SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres password=test')

ERROR: could not establish connection DETAIL: FATAL: password authentication failed for user "NETWORK SERVICE"

What this error is related to? Do I need to modify pg_hba.conf file by any chance?

Thanks..

Re: Facing authentication error on postgres 9.2 -> dblink functions

From

Albe Laurenz

Date:

06 February 2013, 16:31:59

Dev Kumkar wrote:
> I am using postgres 9.2 and when executing function dblink facing a fatal error while trying to
> execute dblink_connect as follows:
>
>     SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres password=test')
>
>     ERROR: could not establish connection DETAIL: FATAL: password authentication failed for user
> "NETWORK SERVICE"
>
> What this error is related to? Do I need to modify pg_hba.conf file by any chance?

You should specify a user=username option in the connection string,
otherwise that defaults to your operating system user name.

Yours,
Laurenz Albe

Re: [HACKERS] Facing authentication error on postgres 9.2 -> dblink functions

From

Andrew Dunstan

Date:

06 February 2013, 16:43:08

On 02/06/2013 08:09 AM, Dev Kumkar wrote:
> Hello Everyone,
>
> I am using postgres 9.2 and when executing function dblink facing a
> fatal error while trying to execute dblink_connect as follows:
>
> /SELECT * FROM dblink_connect('host=127.0.0.1 port=5432
> dbname=postgres password=test')/
>
> *ERROR*: could not establish connection DETAIL: FATAL: password
> authentication failed for user "NETWORK SERVICE"
>
> What this error is related to? Do I need to modify pg_hba.conf file by
> any chance?
>
> Thanks..
>

Do NOT send questions to multiple lists. That is a waste of everybody's
time. So do NOT follow up this email. This question belongs on
pgsql-general. If you have further questions pleease ask there.

The short answer is that you need to provide the user name in your
connect string.

cheers

andrew

Re: Facing authentication error on postgres 9.2 -> dblink functions

From

Dev Kumkar

Date:

06 February 2013, 20:55:03

Great.. thanks a lot Laurenz Albe!

Works perfect !!

Regards - Dev

On Wed, Feb 6, 2013 at 7:00 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:

Dev Kumkar wrote:
> I am using postgres 9.2 and when executing function dblink facing a fatal error while trying to
> execute dblink_connect as follows:
>
> SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres password=test')
>
> ERROR: could not establish connection DETAIL: FATAL: password authentication failed for user
> "NETWORK SERVICE"
>
> What this error is related to? Do I need to modify pg_hba.conf file by any chance?

You should specify a user=username option in the connection string,
otherwise that defaults to your operating system user name.

Yours,
Laurenz Albe

Re: Facing authentication error on postgres 9.2 -> dblink functions

From

Dev Kumkar

Date:

06 February 2013, 22:19:27

Hey went ahead and tried to query across machines and facing following error:

SELECT * FROM dblink_connect('host=x.x.x.x port=5432 dbname=postgres user=postgres password=test')

could not connect to server: Connection timed out (0x0000274C/10060)
    Is the server running on host "x.y.z.com" (x.x.x.x) and accepting
    TCP/IP connections on port 5432?

Tried modifying pg_hba as follows:
1st try
host    all             all             0.0.0.0/0            md5

2nd try
host    all             all             .z.com            md5

postgresql.conf looks good for connections and authentication:
         listen_addresses = '*'

Please suggest?

Thanks...

On Wed, Feb 6, 2013 at 11:25 PM, Dev Kumkar <devdas.kumkar@gmail.com> wrote:

Great.. thanks a lot Laurenz Albe!

Works perfect !!

Regards - Dev

On Wed, Feb 6, 2013 at 7:00 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Dev Kumkar wrote:
> I am using postgres 9.2 and when executing function dblink facing a fatal error while trying to
> execute dblink_connect as follows:
>
> SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres password=test')
>
> ERROR: could not establish connection DETAIL: FATAL: password authentication failed for user
> "NETWORK SERVICE"
>
> What this error is related to? Do I need to modify pg_hba.conf file by any chance?

You should specify a user=username option in the connection string,
otherwise that defaults to your operating system user name.

Yours,
Laurenz Albe

Re: Facing authentication error on postgres 9.2 -> dblink functions

From

Dev Kumkar

Date:

06 February 2013, 23:18:07

Checked further netstat and could see following lines:
TCP 0.0.0.0:5432 0.0.0.0:0 LISTENING

Then checked from remote machine 'telnet' to target database machine and could see connection failing, looking further port was blocked and unblocking port resolved this. Queries working fine.

So far so good..

Thanks...

On Thu, Feb 7, 2013 at 12:49 AM, Dev Kumkar <devdas.kumkar@gmail.com> wrote:

Hey went ahead and tried to query across machines and facing following error:

SELECT * FROM dblink_connect('host=x.x.x.x port=5432 dbname=postgres user=postgres password=test')

could not connect to server: Connection timed out (0x0000274C/10060)
    Is the server running on host "x.y.z.com" (x.x.x.x) and accepting
    TCP/IP connections on port 5432?

Tried modifying pg_hba as follows:
1st try
host    all             all             0.0.0.0/0            md5

2nd try
host    all             all             .z.com            md5

postgresql.conf looks good for connections and authentication:
         listen_addresses = '*'

Please suggest?

Thanks...

On Wed, Feb 6, 2013 at 11:25 PM, Dev Kumkar <devdas.kumkar@gmail.com> wrote:
Great.. thanks a lot Laurenz Albe!

Works perfect !!

Regards - Dev

On Wed, Feb 6, 2013 at 7:00 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Dev Kumkar wrote:
> I am using postgres 9.2 and when executing function dblink facing a fatal error while trying to
> execute dblink_connect as follows:
>
> SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres password=test')
>
> ERROR: could not establish connection DETAIL: FATAL: password authentication failed for user
> "NETWORK SERVICE"
>
> What this error is related to? Do I need to modify pg_hba.conf file by any chance?

You should specify a user=username option in the connection string,
otherwise that defaults to your operating system user name.

Yours,
Laurenz Albe