I've been trying to use PostgreSQL with the Enhydra Java Servlet-based applications
server. The system throws an SQL Exception stating:
java.sql.SQLException: User authentication failed
at postgresql.Connection.(Connection.java:229)
at postgresql.Driver.connect(Driver.java:87)
at java.sql.DriverManager.getConnection(DriverManager.java:83)
at java.sql.DriverManager.getConnection(DriverManager.java:126)
at
com.lutris.appserver.server.sql.standard.StandardDBConnection.(StandardDBConnection.java:150)
... and so on
The connect URL, user ID and password I put in the Enhydra config file have all worked
fine in other
contexts, so I suspect that Enhydra is substituting something in the connection
process.
It's brought up a sore spot. I'd like a nice tidy little log of connections and their
sources, both successful
and failed, like the /var/log/secure file in Linux or the Samba logs. The last time I
had this much of a problem, I ended up patching the PostgreSQL authenticator to make
it rat on the offender.
Presently I'm running an RPM version, which has further muddied the waters, as I tried
creating a pg_options
file and discovered that the "data" directory doesn't exist (I used /var/lib/pgsql as
the most likely alternative, but nothing obvious happened). I also started the
postmaster with the -d flag, but while it gets
verbose about connections via psql, jdbc attempts only display "User authentication
failed"
Query: Is there a feature I'm missing out on, or is an authentication logging facility
something that I can contribute?
Thanks,
Tim Holloway
MTS Associates, Inc.
************
