Facing authentication error on postgres 9.2 -> dblink functions

Started by Dev Kumkaralmost 13 years ago7 messages

devdas.kumkar@gmail.com

almost 13 years ago

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..

Albe Laurenz

laurenz.albe@wien.gv.at

almost 13 years ago

In reply to: Dev Kumkar (#1)

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

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

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Andrew Dunstan

andrew@dunslane.net

almost 13 years ago

In reply to: Dev Kumkar (#1)

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

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

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Dev Kumkar

devdas.kumkar@gmail.com

almost 13 years ago

In reply to: Albe Laurenz (#2)

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

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:

Show quoted text

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

Dev Kumkar

devdas.kumkar@gmail.com

almost 13 years ago

In reply to: Andrew Dunstan (#3)

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

Apologies for posting on multiple lists, surely will take care of this next
time.

Yup adding user=username resolved this. Thanks to 'Laurenz Albe' and you
too.

Regards - Dev

On Wed, Feb 6, 2013 at 7:12 PM, Andrew Dunstan <andrew@dunslane.net> wrote:

Show quoted text

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

Dev Kumkar

devdas.kumkar@gmail.com

almost 13 years ago

In reply to: Dev Kumkar (#4)

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

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:

Show quoted text

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

Dev Kumkar

devdas.kumkar@gmail.com

almost 13 years ago

In reply to: Dev Kumkar (#6)

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

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:

Show quoted text

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