DatabaseServerLoginModule error
richaud Dec 17, 2003 8:08 AMHi,
I'm trying to replace the LdapLoginModule by the DatabaseServerLoginModule and I'm having a strange error.
As requested, I created a table for users and one for roles (in fact this is the same table, but I have 2 distinct queries).
From my web app, I can access the database (I use Hibernate) and do whatever I want. But not to authenticate my users. I 'm getting the following exception whenever a user tries to login :
org.jboss.util.NestedSQLException: Wrong credentials passed to getConnection!; - nested throwable: (org.jboss.resource.J BossResourceException: Wrong credentials passed to getConnection!) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106) at org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(DatabaseServerLoginModule.java:96) at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:143) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at javax.security.auth.login.LoginContext.invoke(LoginContext.java:675) at javax.security.auth.login.LoginContext.access$000(LoginContext.java:129) at javax.security.auth.login.LoginContext$4.run(LoginContext.java:610) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:607) at javax.security.auth.login.LoginContext.login(LoginContext.java:534) at org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurityManager.java:462) at org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityManager.java:417) at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java:244) at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java:219) at org.jboss.jetty.security.JBossUserRealm$JBossUserPrincipal.isAuthenticated(JBossUserRealm.java:92) at org.jboss.jetty.security.JBossUserRealm$JBossUserPrincipal.authenticate(JBossUserRealm.java:154) at org.jboss.jetty.security.JBossUserRealm.authenticate(JBossUserRealm.java:323) at org.mortbay.http.BasicAuthenticator.authenticated(BasicAuthenticator.java:50) at org.mortbay.http.SecurityConstraint.check(SecurityConstraint.java:401) at org.mortbay.http.HttpContext.checkSecurityConstraints(HttpContext.java:1456) at org.mortbay.jetty.servlet.ServletHttpContext.checkSecurityConstraints(ServletHttpContext.java:137) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:235) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558) at org.mortbay.http.HttpContext.handle(HttpContext.java:1714) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507) at org.mortbay.http.HttpContext.handle(HttpContext.java:1664) ....
I'm using mysql on a Windows 2003 server. My version of JBosss is 3.2.1.
I can also post my mysql-ds.xml file as well login-config.xml if someone needs it (didn't find how to attach files - not my day -).
Regards.
Olivier.