I tried reconfiguring my JDBC security realm to store the username an password and group in a single table (since the user only needs one group).
The table is set up as username,password(md5),group
And I get this error in Glassfish
The FileRealm classname, "com.sun.enterprise.security.auth.realm.jdbc.JDBCRealm" does not extend "com.sun.enterprise.security.auth.realm.file.FileRealm".
Jun 22, 2007 2:01:54 PM org.apache.coyote.tomcat5.CoyoteRequest setCharacterEncoding
WARNING: PWC4011: Unable to set request character encoding to UTF-8 from context /CIWeb, because request parameters have already been read, or ServletRequest.getReader() has already been called
Jun 22, 2007 2:01:58 PM com.sun.enterprise.security.auth.realm.jdbc.JDBCRealm findGroups
SEVERE: SEC1111: Cannot load group for JDBC realm user [tony].
Jun 22, 2007 2:01:58 PM com.sun.enterprise.security.auth.LoginContextDriver doPasswordLogin
INFO: SEC5046: Audit: Authentication refused for [tony].
Jun 22, 2007 2:01:58 PM com.sun.web.security.RealmAdapter authenticate
WARNING: Web login failed: Login failed: javax.security.auth.login.LoginException: Security Exception
[Message sent by forum member 'amattas' (amattas)]
http://forums.java.net/jive/thread.jspa?messageID=223593