pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedJDBC from remote
5+ messages / 3 participants
[nested] [flat]
* JDBC from remote
@ 1999-05-20 18:00 Alex Turner <aturner@maaco.com>
0 siblings, 1 reply; 5+ messages in thread
From: Alex Turner @ 1999-05-20 18:00 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] JDBC from remote
@ 1999-05-20 19:29 Benoit Foucher <benoit@ooc.com>
parent: Alex Turner <aturner@maaco.com>
0 siblings, 1 reply; 5+ messages in thread
From: Benoit Foucher @ 1999-05-20 19:29 UTC (permalink / raw)
To: Alex Turner <aturner@maaco.com>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] JDBC from remote
@ 1999-05-20 20:31 Alex Turner <aturner@maaco.com>
parent: Benoit Foucher <benoit@ooc.com>
0 siblings, 0 replies; 5+ messages in thread
From: Alex Turner @ 1999-05-20 20:31 UTC (permalink / raw)
To: benoit@ooc.com; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [INTERFACES] JDBC from remote
@ 1999-05-21 06:53 Peter Mount <petermount@it.maidstone.gov.uk>
0 siblings, 1 reply; 5+ messages in thread
From: Peter Mount @ 1999-05-21 06:53 UTC (permalink / raw)
To: Alex Turner <aturner@maaco.com>; benoit@ooc.com; +Cc: pgsql-interfaces
Even though you are using trust, are you supplying a password to the
driver?
Passing null or "" as a password doesn't work. As long as the password
exists (doesn't have to be correct for trust authentication) it should
work.
Peter
--
Peter T Mount, Enterprise Support
petermount@it.maidstone.gov.uk
Anything I write here are my own views, and cannot be taken as the
official words of Maidstone Borough Council
-----Original Message-----
From: Alex Turner [mailto:aturner@maaco.com]
Sent: Thursday, May 20, 1999 9:31 PM
To: benoit@ooc.com
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] JDBC from remote
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] JDBC from remote
@ 1999-05-21 12:36 Alex Turner <aturner@maaco.com>
parent: Peter Mount <petermount@it.maidstone.gov.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Alex Turner @ 1999-05-21 12:36 UTC (permalink / raw)
To: Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: benoit@ooc.com; pgsql-interfaces
Peter Mount wrote:
> Even though you are using trust, are you supplying a password to the
> driver?
>
> Passing null or "" as a password doesn't work. As long as the password
> exists (doesn't have to be correct for trust authentication) it should
> work.
>
> Peter
>
> --
> Peter T Mount, Enterprise Support
> petermount@it.maidstone.gov.uk
> Anything I write here are my own views, and cannot be taken as the
> official words of Maidstone Borough Council
>
> -----Original Message-----
> From: Alex Turner [mailto:aturner@maaco.com]
> Sent: Thursday, May 20, 1999 9:31 PM
> To: benoit@ooc.com
> Cc: pgsql-interfaces@postgreSQL.org
> Subject: Re: [INTERFACES] JDBC from remote
>
> 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
Well:
public boolean makeConnection(String url,String usr,String pwd)
{
System.out.println("Attempting to forge connection to
"+url);
try {
db=DriverManager.getConnection(url,usr,pwd);
dbmd=db.getMetaData();
st=db.createStatement();
is the head of what I have trying to connect to the DB.
I am running java -Djdbc.drivers=postgresql.Driver <programme>
and postmaster -i &
It's picking up the DB file because I can connect using psql tool localy,
and the code works when I connect just to localhost?
Hope you can help
Alex T
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1999-05-21 12:36 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-05-20 18:00 JDBC from remote Alex Turner <aturner@maaco.com>
1999-05-20 19:29 ` Benoit Foucher <benoit@ooc.com>
1999-05-20 20:31 ` Alex Turner <aturner@maaco.com>
1999-05-21 06:53 RE: [INTERFACES] JDBC from remote Peter Mount <petermount@it.maidstone.gov.uk>
1999-05-21 12:36 ` Alex Turner <aturner@maaco.com>
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