Hi
I have tested some java code to connect to PostgreSQL database using 'trust'
relationship, which works.
quote:
----------------------------------------------------------------------------
----
[snathan@sip008 security]$ java Sample
DAtabase :PostGRESQL
Inside Main of Sample ####
Here
Database Driver rg.postgresql.Driver
Database Datasource :jdbcostgresql://192.168.66.3:5432/test
Database Login :u_test
Database Password :u_test
----------------------------------------------------------------------------
----
However, when I change the pg_hba.conf to have 'password' or 'md5' or
'crypt', the connection fails with the above error. But, I am able to
connect using 'psql' ...
quote:
----------------------------------------------------------------------------
----
[snathan@sip008 security]$ java Sample
DAtabase :PostGRESQL
Inside Main of Sample ####
Here
Database Driver rg.postgresql.Driver
Database Datasource :jdbcostgresql://192.168.66.3:5432/test
Database Login :u_test
Database Password :u_test
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 "u_test"
Stack Trace:
java.sql.SQLException: FATAL 1: Password authentication failed for user
"u_test"
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 Sample.getConnectionToDatabase(Sample.java:58)
at Sample.main(Sample.java:22)
End of Stack Trace
at org.postgresql.Driver.connect(Driver.java:166)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at Sample.getConnectionToDatabase(Sample.java:58)
at Sample.main(Sample.java:22)
----------------------------------------------------------------------------
----
Thanks for your valuable input.
Best Regards.
Godson R.
Chennai, India.