pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
dblink not working in FC5
2+ messages / 2 participants
[nested] [flat]

* dblink not working in FC5
@ 2006-04-19 22:26 Manish Gupta <ml_gupta@hotmail.com>
  2006-04-19 23:35 ` Re: dblink not working in FC5 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Manish Gupta @ 2006-04-19 22:26 UTC (permalink / raw)
  To: pgsql-admin

Recently, I upgraded one of my server from FC4 to FC5.  This also upgraded 
postgresql to 8.1.3. The upgrade was flawless. Unfortunately, I cannot get 
dblink to work in this version of postgresql. I created two fresh databases 
and tried... still no luck. I keep getting the following error:

bulbulbo=# select dblink_connect('hostaddr=127.0.0.1 dbname=bulbulfo 
user=bulbul password=password');
ERROR:  could not establish connection
DETAIL:  could not connect to server: Permission denied
       Is the server running on host "127.0.0.1" and accepting
       TCP/IP connections on port 5432?

bulbulbo=# select dblink_connect('dbname=bulbulfo user=bulbul');
ERROR:  could not establish connection
DETAIL:  could not connect to server: Permission denied
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?


My pg_hba.conf is as follows:
----------------------
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          password
host    all         all         192.168.0.0/24        password
host    all         all         10.1.2.0/24           password

# IPv6 local connections:
host    all         all         ::1/128               sameuser
--------------------


The error seems to be client authentication error. I researched and found 
that the message "could not establish connection" seems to coming from 
dblink.c (inside contrib/dblink), and it gets triggred when it is unable to 
create connection to the database. I though that this may be happening 
because libpq is not working properly. So, I compiled a simple program, 
written in C, that uses libpq and that  program  works fine.

I have kind of hit the roadblock. Any help would be appreciated.

Thanks

Manish

"An informed citizenry is the bulwark of a democracy"
http://www.SUNITI.org : Self-governance for an informed citizen





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: dblink not working in FC5
  2006-04-19 22:26 dblink not working in FC5 Manish Gupta <ml_gupta@hotmail.com>
@ 2006-04-19 23:35 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2006-04-19 23:35 UTC (permalink / raw)
  To: Manish Gupta <ml_gupta@hotmail.com>; +Cc: pgsql-admin

"Manish Gupta" <ml_gupta@hotmail.com> writes:
> bulbulbo=# select dblink_connect('hostaddr=127.0.0.1 dbname=bulbulfo 
> user=bulbul password=password');
> ERROR:  could not establish connection
> DETAIL:  could not connect to server: Permission denied
>        Is the server running on host "127.0.0.1" and accepting
>        TCP/IP connections on port 5432?

"Permission denied" seems a bit odd here.  Just as a wild guess: do you
have SELinux running in enforcement mode, and if so, does switching it
to permissive mode make this work?  (See /usr/sbin/getenforce and
setenforce)  Another thing to try is a non-TCP connection, ie, leave out
the hostaddr bit.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-04-19 23:35 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-19 22:26 dblink not working in FC5 Manish Gupta <ml_gupta@hotmail.com>
2006-04-19 23:35 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox