Thread: JDBC driver problem ?
Hello to all,
This is my first question, so don't be mad if it is gonna be a silly one.
I have a psql account on a psql server that runs psql 7.2.1. I want to
connect to it by using java (jdbc).
I downloaded the JDBC 2.0 driver (pgjdbc2.jar) and I am doing the following:
System.out.println(" + Loading the driver" );
Class.forName( "org.postgresql.Driver" ) ;
System.out.println(" + Creating a connection " );
con = DriverManager.getConnection(
"jdbc:postgresql://myserver:5432/Test",
"myaccount",
"mypasswd" ) ;
Loading the driver works. But can't obtain a connection due to:
Exception: Something unusual has occured to cause the driver to fail. Please
report this exception: Exception: java.sql.SQLException: FATAL 1: Password
authentication failed for user "dovle"
Stack Trace:
java.sql.SQLException: FATAL 1: Password authentication failed for user
"myaccount"
at org.postgresql.Connection.openConnection(Connection.java:178)
at org.postgresql.Driver.connect(Driver.java:149)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at Main.main(Main.java:18)
End of Stack Trace
But the password is correct!!!
What could be wrong ?
What should happen if the postgres does not run with the -i parameter ? Could
this be the wrong thing that happened ?
dovle
The "FATAL 1" message comes from the backend (server), so this means
you're able to connect to it at the network level, so it must be running
with -i.
It's probably a problem in the authentication setup of the server.
(pg_hba.conf). I don't know which types of authentication the driver
supports, but we use "trust" for our internal network:
host all 192.168.0.0 255.255.0.0 trust
On Fri, 2002-11-08 at 11:34, Alex Dovlecel wrote:
> Hello to all,
> This is my first question, so don't be mad if it is gonna be a silly one.
>
> I have a psql account on a psql server that runs psql 7.2.1. I want to
> connect to it by using java (jdbc).
>
> I downloaded the JDBC 2.0 driver (pgjdbc2.jar) and I am doing the following:
>
> System.out.println(" + Loading the driver" );
> Class.forName( "org.postgresql.Driver" ) ;
>
> System.out.println(" + Creating a connection " );
> con = DriverManager.getConnection(
> "jdbc:postgresql://myserver:5432/Test",
> "myaccount",
> "mypasswd" ) ;
>
> Loading the driver works. But can't obtain a connection due to:
>
> Exception: Something unusual has occured to cause the driver to fail. Please
> report this exception: Exception: java.sql.SQLException: FATAL 1: Password
> authentication failed for user "dovle"
>
> Stack Trace:
>
> java.sql.SQLException: FATAL 1: Password authentication failed for user
> "myaccount"
>
> at org.postgresql.Connection.openConnection(Connection.java:178)
> at org.postgresql.Driver.connect(Driver.java:149)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:171)
> at Main.main(Main.java:18)
> End of Stack Trace
>
>
> But the password is correct!!!
>
> What could be wrong ?
>
> What should happen if the postgres does not run with the -i parameter ? Could
> this be the wrong thing that happened ?
>
> dovle
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
[]'s
Daniel Serodio
Tx for the answer,
Glad to hear this... but I have no clue about what should I do next
I had tried to use an older driver (7.1 driver, jar called like this:
jdbc7.1-1.2.jar) but gives me the following exception :
Exception: The authentication type 5 is not supported. Check that you have
configured the pg_hba.conf file to include the clients IP address or Subnet,
and that it is using an authentication scheme supported by the driver.
Do you have any sugestions?
Tx,
dovle
> The "FATAL 1" message comes from the backend (server), so this means
> you're able to connect to it at the network level, so it must be running
> with -i.
>
> It's probably a problem in the authentication setup of the server.
> (pg_hba.conf). I don't know which types of authentication the driver
> supports, but we use "trust" for our internal network:
>
> host all 192.168.0.0 255.255.0.0 trust
>
> On Fri, 2002-11-08 at 11:34, Alex Dovlecel wrote:
> > Hello to all,
> > This is my first question, so don't be mad if it is gonna be a silly one.
> >
> > I have a psql account on a psql server that runs psql 7.2.1. I want to
> > connect to it by using java (jdbc).
> >
> > I downloaded the JDBC 2.0 driver (pgjdbc2.jar) and I am doing the
> > following:
> >
> > System.out.println(" + Loading the driver" );
> > Class.forName( "org.postgresql.Driver" ) ;
> >
> > System.out.println(" + Creating a connection " );
> > con = DriverManager.getConnection(
> > "jdbc:postgresql://myserver:5432/Test",
> > "myaccount",
> > "mypasswd" ) ;
> >
> > Loading the driver works. But can't obtain a connection due to:
> >
> > Exception: Something unusual has occured to cause the driver to fail.
> > Please report this exception: Exception: java.sql.SQLException: FATAL 1:
> > Password authentication failed for user "dovle"
> >
> > Stack Trace:
> >
> > java.sql.SQLException: FATAL 1: Password authentication failed for user
> > "myaccount"
> >
> > at org.postgresql.Connection.openConnection(Connection.java:178)
> > at org.postgresql.Driver.connect(Driver.java:149)
> > at java.sql.DriverManager.getConnection(DriverManager.java:512)
> > at java.sql.DriverManager.getConnection(DriverManager.java:171)
> > at Main.main(Main.java:18)
> > End of Stack Trace
> >
> >
> > But the password is correct!!!
> >
> > What could be wrong ?
> >
> > What should happen if the postgres does not run with the -i parameter ?
> > Could this be the wrong thing that happened ?
> >
> > dovle
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
Looking at the source code for 7.2.1, which is what I have here, it
looks like the driver supports the 'password', 'crypt', 'md5' and of
course, 'trust' authentication schemes. Try using
DriverManager.setLogStream(System.out) before getting the connection,
the driver should print the auth scheme to System.out.
On Fri, 2002-11-08 at 12:30, Alex Dovlecel wrote:
> Tx for the answer,
> Glad to hear this... but I have no clue about what should I do next
>
> I had tried to use an older driver (7.1 driver, jar called like this:
> jdbc7.1-1.2.jar) but gives me the following exception :
>
> Exception: The authentication type 5 is not supported. Check that you have
> configured the pg_hba.conf file to include the clients IP address or Subnet,
> and that it is using an authentication scheme supported by the driver.
>
> Do you have any sugestions?
>
> Tx,
> dovle
>
>
> > The "FATAL 1" message comes from the backend (server), so this means
> > you're able to connect to it at the network level, so it must be running
> > with -i.
> >
> > It's probably a problem in the authentication setup of the server.
> > (pg_hba.conf). I don't know which types of authentication the driver
> > supports, but we use "trust" for our internal network:
> >
> > host all 192.168.0.0 255.255.0.0 trust
> >
> > On Fri, 2002-11-08 at 11:34, Alex Dovlecel wrote:
> > > Hello to all,
> > > This is my first question, so don't be mad if it is gonna be a silly one.
> > >
> > > I have a psql account on a psql server that runs psql 7.2.1. I want to
> > > connect to it by using java (jdbc).
> > >
> > > I downloaded the JDBC 2.0 driver (pgjdbc2.jar) and I am doing the
> > > following:
> > >
> > > System.out.println(" + Loading the driver" );
> > > Class.forName( "org.postgresql.Driver" ) ;
> > >
> > > System.out.println(" + Creating a connection " );
> > > con = DriverManager.getConnection(
> > > "jdbc:postgresql://myserver:5432/Test",
> > > "myaccount",
> > > "mypasswd" ) ;
> > >
> > > Loading the driver works. But can't obtain a connection due to:
> > >
> > > Exception: Something unusual has occured to cause the driver to fail.
> > > Please report this exception: Exception: java.sql.SQLException: FATAL 1:
> > > Password authentication failed for user "dovle"
> > >
> > > Stack Trace:
> > >
> > > java.sql.SQLException: FATAL 1: Password authentication failed for user
> > > "myaccount"
> > >
> > > at org.postgresql.Connection.openConnection(Connection.java:178)
> > > at org.postgresql.Driver.connect(Driver.java:149)
> > > at java.sql.DriverManager.getConnection(DriverManager.java:512)
> > > at java.sql.DriverManager.getConnection(DriverManager.java:171)
> > > at Main.main(Main.java:18)
> > > End of Stack Trace
> > >
> > >
> > > But the password is correct!!!
> > >
> > > What could be wrong ?
> > >
> > > What should happen if the postgres does not run with the -i parameter ?
> > > Could this be the wrong thing that happened ?
> > >
> > > dovle
--
[]'s
Daniel Serodio