Hi,
The Glassfish JDBCRealm is available soon.
Regards,
Shing Wai Chan
Dennis Gesker wrote:
> I was attempting to implement a jdbcReal as described at:
> http://jroller.com/page/brviking?entry=glassfish_for_tomcat_users_jdbc
>
>
> *
> However, I seem have run into some trouble as I keep getting this module to work and I'm wondering if there is
> something special required with regard to the setup of the database tables (sql below). I was
> suprised to see a stack trace as opposed to just a 'login failed message':*
>
>
> (JdbcRealm)User gesker valid: false|#]
>
> com.sun.enterprise.security.LoginException: (JdbcLoginModule) Login failed!
> at org.nbcommunity.glassfish.jdbcAuthModule.JdbcLoginModule.authenticate(JdbcLoginModule.java:61)
> at com.sun.enterprise.security.auth.login.PasswordLoginModule.authenticateUser(PasswordLoginModule.java:77)
> at com.sun.appserv.security.AppservPasswordLoginModule.login(AppservPasswordLoginModule.java:171)
> at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at javax.security.auth.login.LoginContext.invoke(LoginContext.java:769)
> at javax.security.auth.login.LoginContext.access$000(LoginContext.java:186)
> at javax.security.auth.login.LoginContext$4.run(LoginContext.java:683)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680)
> at javax.security.auth.login.LoginContext.login(LoginContext.java:579)
> at com.sun.enterprise.security.auth.LoginContextDriver.doPasswordLogin(LoginContextDriver.java:283)
> at com.sun.enterprise.security.auth.LoginContextDriver.login(LoginContextDriver.java:158)
> at com.sun.enterprise.security.auth.LoginContextDriver.login(LoginContextDriver.java:111)
> at com.sun.web.security.RealmAdapter.authenticate(RealmAdapter.java:419)
> at com.sun.web.security.RealmAdapter.authenticate(RealmAdapter.java:359)
> at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:238)
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:534)
> at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:557)
> at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)
> at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
> at com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
> at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
> at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:231)
> at com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667)
> at com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
> at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844)
> at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
> at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
> at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
> at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)
> |#]
> JAAS authentication aborted.
> SEC5046: Audit: Authentication refused for [gesker].
>
>
>
>
> *
> On startup of the server I see in the logs:*
>
>
> JdbcRealm initialization successfull, debug on!
> JdbcRealm will execute queries against jdbc/operations|#]
> JdbcRealm will login with select count(*) from auth where username = ? and password = ?|#]
> JdbcRealm will get roles with select role from authrole where username = ?|#]
> JdbcRealm will get all roles with select distinct role from authrole|#]
> [snip]
> Logging in user [gesker] into realm: jdbcRealmAddOn using JAAS module: jdbcRealm
> Login module initialized: class org.nbcommunity.glassfish.jdbcAuthModule.JdbcLoginModule
>
>
> *Which leads me to believe that I have most of the configuration options correct.
> My sql to setup my database tables is pretty straight forward as well:*
>
> create table auth(
> id int NOT NULL IDENTITY PRIMARY KEY,
> username char(10) NOT NULL UNIQUE,
> password char(10) NOT NULL
> )
>
> create table authrole(
> id int NOT NULL IDENTITY PRIMARY KEY,
> username char(10) NOT NULL REFERENCES auth(username) ON UPDATE CASCADE ON DELETE CASCADE,
> role char(10) NOT NULL,
> rolecode char(10)
> )
>
> insert into auth(username, password) values ('gesker','password')
> insert into authrole (username, role) values ('gesker','employee')
> insert into authrole (username, role) values ('gesker','supervisor')
> insert into authrole (username, role) values ('gesker','manager')
> insert into authrole (username, role) values ('gesker','admin')
> insert into authrole (username, role) values ('gesker','quality')
> insert into authrole (username, role) values ('gesker','sysadmin')
>
>
> *Could someone offer a hint?
>
> Dennis
> *
>
>
>
> --
> Dennis R. Gesker
> email: dennis_at_alamon.com
> gpg key: 0xEFA10A51
>
>
>