5 Replies Latest reply on Jun 17, 2005 3:08 AM by Ramesh Polisetty

    Problem with DatabaseServerLoginModule connecting to mysql

    Ramesh Polisetty Newbie

      Hi,
      We are using the following combination for our App on windows XP platform:

      JBoss 4.0.0
      Mysql 4.1.8
      Mysql-connector-java-3.1.7-bin.jar

      DefaultDS is Hypersonic but, the security information is in mysql with the following data source definition:


      <local-tx-datasource>
      <jndi-name>mysqlDS</jndi-name>
      <connection-url>jdbc:mysql://localhost:3306/bl5_db </connection-url>
      <driver-class>com.mysql.jdbc.Driver</driver-class>
      <user-name>myuser</user-name>
      mypassword
      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

      <type-mapping>mySQL</type-mapping>

      </local-tx-datasource>




      Defined the following security in login-config.xml:


      <login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule"
      flag = "required">
      <module-option name = "dsJndiName">java:/mysqlDS</module-option>
      <module-option name = "principalsQuery">SELECT ESAPASSWORD FROM T_USER WHERE ESALOGINNAME=?</module-option>
      <module-option name = "rolesQuery">SELECT 'esa-role', 'Roles' FROM T_USER WHERE ESALOGINNAME=?</module-option>
      </login-module>


      When we login thru the form based authentication, the first login after JBoss startup,
      I am always getting the following exception but, after that authentication is working fine for this and all other the users.

      2005-06-03 12:03:25,696 285261 WARN [connectionmanager.JBossManagedConnectionPool] (http-0.0.0.0-7001-Processor25:) Throwable while attempting to get a new connection: null
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost:3306/bl5_db)

      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:161)


      Can anyone tell me why this might be happening or if you know of a work around for this?
      I would greatly appreciate any help you can provide.
      Thank you very much.
      Ramesh

      =============================================
      2005-06-03 12:03:25,656 285221 TRACE [plugins.JaasSecurityManager] (http-0.0.0.0-7001-Processor25:) Constructing
      2005-06-03 12:03:25,656 285221 DEBUG [plugins.JaasSecurityManagerService] (http-0.0.0.0-7001-Processor25:) Created securityMgr=org.jboss.security.plugins.JaasSecurityManager@696d5c
      2005-06-03 12:03:25,656 285221 DEBUG [JaasSecurityManager.esasecurity] (http-0.0.0.0-7001-Processor25:) CachePolicy set to: org.jboss.util.TimedCachePolicy@1862621
      2005-06-03 12:03:25,656 285221 DEBUG [plugins.JaasSecurityManagerService] (http-0.0.0.0-7001-Processor25:) setCachePolicy, c=org.jboss.util.TimedCachePolicy@1862621
      2005-06-03 12:03:25,656 285221 DEBUG [plugins.JaasSecurityManagerService] (http-0.0.0.0-7001-Processor25:) Added esasecurity, org.jboss.security.plugins.SecurityDomainContext@315e08 to map
      2005-06-03 12:03:25,656 285221 TRACE [login.XMLLoginConfigImpl] (http-0.0.0.0-7001-Processor25:) Begin getAppConfigurationEntry(esasecurity), size=11
      2005-06-03 12:03:25,656 285221 TRACE [login.XMLLoginConfigImpl] (http-0.0.0.0-7001-Processor25:) End getAppConfigurationEntry(esasecurity), authInfo=AppConfigurationEntry[]:
      [0]
      LoginModule Class: org.jboss.security.auth.spi.DatabaseServerLoginModule
      ControlFlag: LoginModuleControlFlag: required
      Options:name=rolesQuery, value=SELECT 'esa-role', 'Roles' FROM T_USER WHERE ESALOGINNAME=?
      name=principalsQuery, value=SELECT ESAPASSWORD FROM T_USER WHERE ESALOGINNAME=?
      name=dsJndiName, value=java:/mysqlDS

      2005-06-03 12:03:25,686 285251 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor25:) initialize
      2005-06-03 12:03:25,686 285251 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor25:) DatabaseServerLoginModule, dsJndiName=java:/mysqlDS
      2005-06-03 12:03:25,686 285251 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor25:) principalsQuery=SELECT ESAPASSWORD FROM T_USER WHERE ESALOGINNAME=?
      2005-06-03 12:03:25,686 285251 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor25:) rolesQuery=SELECT 'esa-role', 'Roles' FROM T_USER WHERE ESALOGINNAME=?
      2005-06-03 12:03:25,686 285251 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor25:) login
      2005-06-03 12:03:25,696 285261 WARN [connectionmanager.JBossManagedConnectionPool] (http-0.0.0.0-7001-Processor25:) Throwable while attempting to get a new connection: null
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost:3306/bl5_db)

      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:161)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:508)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:207)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:534)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:396)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:299)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:448)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:838)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
      at org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(DatabaseServerLoginModule.java:97)
      at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:156)
      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:491)
      at org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityManager.java:442)
      at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java:257)
      at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java:232)
      at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.authenticate(JBossSecurityMgrRealm.java:239)
      at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:235)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:446)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
      at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
      at java.lang.Thread.run(Thread.java:536)
      Caused by: org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost:3306/bl5_db
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:288)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:150)
      ... 48 more
      2005-06-03 12:03:25,727 285292 ERROR [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor25:) Query failed
      org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost:3306/bl5_db); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost:3306/bl5_db))
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)
      at org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(DatabaseServerLoginModule.java:97)
      at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:156)
      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:491)
      at org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityManager.java:442)
      at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java:257)
      at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java:232)
      at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.authenticate(JBossSecurityMgrRealm.java:239)
      at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:235)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:446)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
      at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
      at java.lang.Thread.run(Thread.java:536)
      Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost:3306/bl5_db)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:161)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:508)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:207)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:534)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:396)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:299)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:448)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:838)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
      ... 40 more
      Caused by: org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost:3306/bl5_db
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:288)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:150)
      ... 48 more
      2005-06-03 12:03:25,737 285302 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor25:) abort
      2005-06-03 12:03:25,737 285302 TRACE [JaasSecurityManager.esasecurity] (http-0.0.0.0-7001-Processor25:) Login failure
      javax.security.auth.login.LoginException: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost:3306/bl5_db); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost:3306/bl5_db))
      at org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(DatabaseServerLoginModule.java:115)
      at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:156)
      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:491)
      at org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityManager.java:442)
      at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java:257)
      at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java:232)
      at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.authenticate(JBossSecurityMgrRealm.java:239)
      at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:235)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:446)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
      at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
      at java.lang.Thread.run(Thread.java:536)
      2005-06-03 12:04:17,658 337223 TRACE [login.XMLLoginConfigImpl] (http-0.0.0.0-7001-Processor24:) Begin getAppConfigurationEntry(esasecurity), size=11
      2005-06-03 12:04:17,658 337223 TRACE [login.XMLLoginConfigImpl] (http-0.0.0.0-7001-Processor24:) End getAppConfigurationEntry(esasecurity), authInfo=AppConfigurationEntry[]:
      [0]
      LoginModule Class: org.jboss.security.auth.spi.DatabaseServerLoginModule
      ControlFlag: LoginModuleControlFlag: required
      Options:name=rolesQuery, value=SELECT 'esa-role', 'Roles' FROM T_USER WHERE ESALOGINNAME=?
      name=principalsQuery, value=SELECT ESAPASSWORD FROM T_USER WHERE ESALOGINNAME=?
      name=dsJndiName, value=java:/mysqlDS

      2005-06-03 12:04:17,658 337223 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor24:) initialize
      2005-06-03 12:04:17,658 337223 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor24:) DatabaseServerLoginModule, dsJndiName=java:/mysqlDS
      2005-06-03 12:04:17,658 337223 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor24:) principalsQuery=SELECT ESAPASSWORD FROM T_USER WHERE ESALOGINNAME=?
      2005-06-03 12:04:17,668 337233 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor24:) rolesQuery=SELECT 'esa-role', 'Roles' FROM T_USER WHERE ESALOGINNAME=?
      2005-06-03 12:04:17,668 337233 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor24:) login
      2005-06-03 12:04:17,678 337243 TRACE [connectionmanager.JBossManagedConnectionPool] (http-0.0.0.0-7001-Processor24:) supplying new ManagedConnection: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1b277f0[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1e0338f handles=0 lastUse=1117825457678 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@592bb1 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@438d57]
      2005-06-03 12:04:17,678 337243 TRACE [connectionmanager.JBossManagedConnectionPool] (http-0.0.0.0-7001-Processor24:) Getting connection from pool org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1b277f0[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1e0338f handles=0 lastUse=1117825457678 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@592bb1 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@438d57] [InUse/Available/Max]: [1/19/20]
      2005-06-03 12:04:17,909 337474 TRACE [connectionmanager.JBossManagedConnectionPool] (http-0.0.0.0-7001-Processor24:) putting ManagedConnection back into pool kill=false cl=org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1b277f0[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1e0338f handles=0 lastUse=1117825457678 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@592bb1 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@438d57]
      2005-06-03 12:04:17,909 337474 TRACE [connectionmanager.JBossManagedConnectionPool] (http-0.0.0.0-7001-Processor24:) Returning connection to pool org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1b277f0[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1e0338f handles=0 lastUse=1117825457909 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@592bb1 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@438d57] [InUse/Available/Max]: [0/20/20]
      2005-06-03 12:04:17,909 337474 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor24:) User 'adminuser' authenticated, loginOk=true
      2005-06-03 12:04:17,909 337474 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor24:) commit, loginOk=true
      2005-06-03 12:04:17,909 337474 TRACE [connectionmanager.JBossManagedConnectionPool] (http-0.0.0.0-7001-Processor24:) supplying ManagedConnection from pool: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1b277f0[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1e0338f handles=0 lastUse=1117825457909 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@592bb1 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@438d57]
      2005-06-03 12:04:17,909 337474 TRACE [connectionmanager.JBossManagedConnectionPool] (http-0.0.0.0-7001-Processor24:) Getting connection from pool org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1b277f0[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1e0338f handles=0 lastUse=1117825457909 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@592bb1 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@438d57] [InUse/Available/Max]: [1/19/20]
      2005-06-03 12:04:17,929 337494 TRACE [spi.DatabaseServerLoginModule] (http-0.0.0.0-7001-Processor24:) Assign user to role esa-role
      2005-06-03 12:04:17,929 337494 TRACE [connectionmanager.JBossManagedConnectionPool] (http-0.0.0.0-7001-Processor24:) putting ManagedConnection back into pool kill=false cl=org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1b277f0[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1e0338f handles=0 lastUse=1117825457909 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@592bb1 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@438d57]
      2005-06-03 12:04:17,929 337494 TRACE [connectionmanager.JBossManagedConnectionPool] (http-0.0.0.0-7001-Processor24:) Returning connection to pool org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1b277f0[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1e0338f handles=0 lastUse=1117825457929 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@592bb1 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@438d57] [InUse/Available/Max]: [0/20/20]
      2005-06-03 12:04:17,929 337494 TRACE [JaasSecurityManager.esasecurity] (http-0.0.0.0-7001-Processor24:) updateCache, subject=Subject:
      Principal: adminuser
      Principal: Roles(members:esa-role)

      2005-06-03 12:04:18,460 338025 INFO [tiles.TilesRequestProcessor] (http-0.0.0.0-7001-Processor24:) Tiles definition factory found for request processor ''.
      2005-06-03 12:04:18,551 338116 INFO [STDOUT] (http-0.0.0.0-7001-Processor24:) In GoToUserHomeAction, user=adminuser