users@glassfish.java.net

JDBC Realm stops working after first login

From: <glassfish_at_javadesktop.org>
Date: Thu, 10 Jan 2008 11:32:40 PST

Hello,

I've had a JDBC realm working for the past couple of months, but over the last couple of days, it has nearly stopped working. The behavior I'm seeing now is after the first user logs in after a server restart, any other user login will fail, and we'll see the log messages listed below. None of the configuration has changed: in the JDBC Realm, JDBC resource, connection pool, database views, or the web app configuration. I'm at a bit of a loss. Any thoughts or suggestions would be greatly appreciated.


[#|2008-01-10T07:16:08.318-0500|SEVERE|sun-appserver9.1|javax.enterprise.system.core.security|_ThreadID=23;_ThreadName=httpSSLWorkerThread-1208
0-1;komodo;_RequestID=d098c20b-e87e-437a-b595-5b31ce13b546;|SEC1112: Cannot validate user [komodo] for JDBC realm.|#]

[#|2008-01-10T07:16:08.323-0500|INFO|sun-appserver9.1|javax.enterprise.system.core.security|_ThreadID=23;_ThreadName=httpSSLWorkerThread-12080-
1;komodo;|SEC5046: Audit: Authentication refused for [komodo].|#]

[#|2008-01-10T07:16:08.323-0500|WARNING|sun-appserver9.1|javax.enterprise.system.container.web|_ThreadID=23;_ThreadName=httpSSLWorkerThread-120
80-1;_RequestID=d098c20b-e87e-437a-b595-5b31ce13b546;|Web login failed: Login failed: javax.security.auth.login.LoginException: Security Except
ion|#]

[#|2008-01-10T07:16:51.720-0500|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=httpWorkerThread-12048-3;|
The FileRealm classname, "com.sun.enterprise.security.auth.realm.certificate.CertificateRealm" does not extend "com.sun.enterprise.security.aut
h.realm.file.FileRealm".|#]

[#|2008-01-10T07:16:56.424-0500|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=18;_ThreadName=httpWorkerThread-12048-3;|
The FileRealm classname, "com.sun.enterprise.security.auth.realm.jdbc.JDBCRealm" does not extend "com.sun.enterprise.security.auth.realm.file.F
ileRealm".|#]

Thanks,
-Stephen
[Message sent by forum member 'cupahjoe' (cupahjoe)]

http://forums.java.net/jive/thread.jspa?messageID=253256