Postgres Pro
Downloads
Home   >   mailing lists

Thread: JDBC from remote

JDBC from remote

From
Alex Turner
Date:
Well.. now I have my JDBC driver working with PostgreSQL I have run into
another problem.

Whenever I try to connect from a remote site, I get an Authentication
failure.  This has happens whatever user I try (I have created two in
addition to the dba).  The database I am try to gain access to is
currently empty, I don't know if this is a problem, but I can access it
at localhost fine :(

Hope someone can help

Alex T

Re: [INTERFACES] JDBC from remote

From
Benoit Foucher
Date:
Hi Alex,

You may have a look at pg_hba.conf to see if the remote host is authorized
to access your database (this file is in the data directory of your database
server). 

Regards,

Alex Turner wrote:
> 
> Well.. now I have my JDBC driver working with PostgreSQL I have run into
> another problem.
> 
> Whenever I try to connect from a remote site, I get an Authentication
> failure.  This has happens whatever user I try (I have created two in
> addition to the dba).  The database I am try to gain access to is
> currently empty, I don't know if this is a problem, but I can access it
> at localhost fine :(
> 
> Hope someone can help
> 
> Alex T

-- 
Benoit Foucher                                      mailto:benoit@ooc.com
Object-Oriented Concepts, Inc.  (trainee) 
44 Manning Road
Billerica, MA 01821

Re: [INTERFACES] JDBC from remote

From
Alex Turner
Date:
Well... I have the line:

host         all        0.0.0.0       0.0.0.0           trust

in the pg_hba.conf file...

But I still can't seem to get remote authentication..

Any ideas?

Benoit Foucher wrote:

> Hi Alex,
>
> You may have a look at pg_hba.conf to see if the remote host is authorized
> to access your database (this file is in the data directory of your database
> server).
>
> Regards,
>
> Alex Turner wrote:
> >
> > Well.. now I have my JDBC driver working with PostgreSQL I have run into
> > another problem.
> >
> > Whenever I try to connect from a remote site, I get an Authentication
> > failure.  This has happens whatever user I try (I have created two in
> > addition to the dba).  The database I am try to gain access to is
> > currently empty, I don't know if this is a problem, but I can access it
> > at localhost fine :(
> >
> > Hope someone can help
> >
> > Alex T