Problem with DatabaseServerLoginModule connecting to mysql
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
