users@glassfish.java.net

Re: JDBC Realm stops working after first login

From: Venu <K.Venugopal_at_Sun.COM>
Date: Fri, 11 Jan 2008 17:46:33 +0530

Hi Stephen,

Which build of Glassfish are you using, can you help us reproduce this
problem. This error can occur if the password is invalid
or if appserver is not able to connect to the database. Can you cross
check if you are able to connect to the database after the first login.

Can you also change the log level to FINE and check.


Regards,
Venu

glassfish_at_javadesktop.org wrote:
> 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
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>