Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-608

Error getting security token via soap

    Details

    • Sprint:
      Sprint 11

      Description

      Here are the requests that I have used. They all result is the same error, listed below.

      username: optus@thesearchagency.com
      realm: optus
      password: optus

      username: admin+thesearchagency.com
      realm: com.thesearchagency
      password: admin

      username: admin+thesearchagency.com
      realm: thesearchagency
      password: admin

      Soap response: <data contentType="null" contentLength="0"><![CDATA[]]></data>

      Error in the logs:
      [2012-10-17 14:34:38,504]-3970723 [http-8080-4] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - handleMessage
      [2012-10-17 14:34:38,505]-3970724 [http-8080-4] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Received query string: username=optus%40thesearchagency.com&realm=optus&password=optus
      [2012-10-17 14:34:38,505]-3970724 [http-8080-4] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Extracted parameters:

      {username=[optus%40thesearchagency.com], realm=[optus], password=[optus]}

      [2012-10-17 14:34:38,505]-3970724 [http-8080-4] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - No context found, using guest context
      [2012-10-17 14:34:38,505]-3970724 [http-8080-4] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - Adding (token 1808015915949855:[e042e3b8-b281-4851-a76d-acfabb994dec]:{}) context to message
      [2012-10-17 14:34:38,506]-3970725 [http-8080-4] WARN org.apache.cxf.jaxrs.utils.JAXRSUtils - No operation matching request path "/sapi/rest/security/tokens" is found, Relative Path: /tokens, HTTP Method: GET, ContentType: /, Accept: application/json,. Please enable FINE/TRACE log level for more details.
      [2012-10-17 14:34:38,506]-3970725 [http-8080-4] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - handleMessage
      [2012-10-17 14:34:38,506]-3970725 [http-8080-4] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - No method found. Exiting message handling
      [2012-10-17 14:34:40,160]-3972379 [http-8080-5] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - handleMessage
      [2012-10-17 14:34:40,161]-3972380 [http-8080-5] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Received query string: null
      [2012-10-17 14:34:40,161]-3972380 [http-8080-5] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Using context from header: X-TSA-Authenticate
      [2012-10-17 14:34:40,161]-3972380 [http-8080-5] DEBUG com.thesearchagency.security.TokenizedSecurityContext - Token:XMKVVUH7JKPOBGZBQRJ7MGYQQ2BZX6JYETLB7GQR4PPJDGW4DOOLI6U6PPQX2FJH5T3GN6C762RSGDTF76ZSGQMDTOUWF5LZNSOVBDD3BFBGSJIC2G4VFK4GQ62ASSUKA7FPDXFZFFAVI43PTUEQTMVZKPE64HIKYBVCTA24QIUNFE4TRNCUEI54JQKOGPMHGLJS3I5FHTIIE===
      [2012-10-17 14:34:40,164]-3972383 [http-8080-5] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - Adding (token 1808015915949855:[e042e3b8-b281-4851-a76d-acfabb994dec, c7542d20-f6ba-4784-842b-9202a92190e2]:

      {realm=com.thesearchagency}) context to message
      [2012-10-17 14:34:40,165]-3972384 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- Beginning request conversion ----------
      [2012-10-17 14:34:40,165]-3972384 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found security context for c7542d20-f6ba-4784-842b-9202a92190e2
      [2012-10-17 14:34:40,165]-3972384 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found tokenized security context: (token 1808015915949855:[e042e3b8-b281-4851-a76d-acfabb994dec, c7542d20-f6ba-4784-842b-9202a92190e2]:{realm=com.thesearchagency}

      )
      [2012-10-17 14:34:40,166]-3972385 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- End request conversion ----------
      [2012-10-17 14:34:40,166]-3972385 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting request context for c7542d20-f6ba-4784-842b-9202a92190e2 in realm com.thesearchagency
      [2012-10-17 14:34:40,166]-3972385 [http-8080-5] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory - Property set for settings/com.thesearchagency.properties is

      {maxClicks=3000, maxPrice=100.00, minClicks=3, minPrice=1.0}

      [2012-10-17 14:34:40,166]-3972385 [http-8080-5] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - handleMessage
      [2012-10-17 14:34:40,166]-3972385 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants(com.thesearchagency.saas.core.services.IRequestContext,java.lang.String)
      [2012-10-17 14:34:40,166]-3972385 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Excuting getMerchants
      [2012-10-17 14:34:40,166]-3972385 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants
      [2012-10-17 14:34:40,166]-3972385 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Getting connection for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager
      [2012-10-17 14:34:40,168]-3972387 [http-8080-5] ERROR jdbc.audit - 538. PreparedStatement.executeQuery() SELECT users.email,users.realm_id,users.id,users.salt,users.password FROM users WHERE users.id='c7542d20-f6ba-4784-842b-9202a92190e2'
      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

      The last packet successfully received from the server was 314,586 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:132)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:179)
      at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:40)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.getPermissions(TSASecurityManager.java:199)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.isPermitted(TSASecurityManager.java:131)
      at com.thesearchagency.saas.core.services.security.SecurityServiceComponent.isPermitted(SecurityServiceComponent.java:83)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.isAuthorized(PermissionsCheckingInterceptor.java:102)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.handleMessage(PermissionsCheckingInterceptor.java:61)
      at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
      at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
      at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211)
      at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)
      at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154)
      at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:146)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:679)
      Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)
      ... 40 more
      [2012-10-17 14:34:40,169]-3972388 [http-8080-5] ERROR jdbc.sqlonly - 538. PreparedStatement.executeQuery() SELECT users.email,users.realm_id,users.id,users.salt,users.password FROM users WHERE users.id='c7542d20-f6ba-4784-842b-9202a92190e2'
      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

      The last packet successfully received from the server was 314,586 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:132)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:179)
      at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:40)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.getPermissions(TSASecurityManager.java:199)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.isPermitted(TSASecurityManager.java:131)
      at com.thesearchagency.saas.core.services.security.SecurityServiceComponent.isPermitted(SecurityServiceComponent.java:83)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.isAuthorized(PermissionsCheckingInterceptor.java:102)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.handleMessage(PermissionsCheckingInterceptor.java:61)
      at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
      at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
      at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211)
      at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)
      at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154)
      at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:146)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:679)
      Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)
      ... 40 more
      [2012-10-17 14:34:40,170]-3972389 [http-8080-5] ERROR jdbc.sqltiming - 538. PreparedStatement.executeQuery() FAILED! SELECT users.email,users.realm_id,users.id,users.salt,users.password FROM users WHERE users.id='c7542d20-f6ba-4784-842b-9202a92190e2'

      {FAILED after 1 msec}

      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

      The last packet successfully received from the server was 314,586 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:132)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:179)
      at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:40)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.getPermissions(TSASecurityManager.java:199)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.isPermitted(TSASecurityManager.java:131)
      at com.thesearchagency.saas.core.services.security.SecurityServiceComponent.isPermitted(SecurityServiceComponent.java:83)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.isAuthorized(PermissionsCheckingInterceptor.java:102)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.handleMessage(PermissionsCheckingInterceptor.java:61)
      at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
      at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
      at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211)
      at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)
      at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154)
      at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:146)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:679)
      Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)
      ... 40 more
      [2012-10-17 14:34:40,171]-3972390 [http-8080-5] ERROR com.thesearchagency.database.storage.JDBCStorageManager - Exception thrown in get()
      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

      The last packet successfully received from the server was 314,586 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:132)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:179)
      at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:40)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.getPermissions(TSASecurityManager.java:199)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.isPermitted(TSASecurityManager.java:131)
      at com.thesearchagency.saas.core.services.security.SecurityServiceComponent.isPermitted(SecurityServiceComponent.java:83)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.isAuthorized(PermissionsCheckingInterceptor.java:102)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.handleMessage(PermissionsCheckingInterceptor.java:61)
      at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
      at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
      at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211)
      at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)
      at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154)
      at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:146)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:679)
      Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)
      ... 40 more
      [2012-10-17 14:34:40,172]-3972391 [http-8080-5] ERROR com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Exception thrown handling authorization request
      java.lang.RuntimeException: com.thesearchagency.database.storage.StorageManagerException: package com.thesearchagency.database.storage.INTERNAL_ERROR_EXCEPTION
      at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:43)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.getPermissions(TSASecurityManager.java:199)
      at com.thesearchagency.saas.core.services.security.manager.TSASecurityManager.isPermitted(TSASecurityManager.java:131)
      at com.thesearchagency.saas.core.services.security.SecurityServiceComponent.isPermitted(SecurityServiceComponent.java:83)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.isAuthorized(PermissionsCheckingInterceptor.java:102)
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.handleMessage(PermissionsCheckingInterceptor.java:61)
      at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
      at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
      at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211)
      at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)
      at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154)
      at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:146)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:679)
      Caused by: com.thesearchagency.database.storage.StorageManagerException: package com.thesearchagency.database.storage.INTERNAL_ERROR_EXCEPTION
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:156)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:179)
      at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:40)
      ... 27 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

      The last packet successfully received from the server was 314,586 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735)
      at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:132)
      ... 29 more
      Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990)
      ... 40 more
      [2012-10-17 14:34:40,173]-3972392 [http-8080-5] WARN org.apache.cxf.phase.PhaseInterceptorChain - Interceptor for

      {http://security.services.sapi.thesearchagency.com/}

      SecurityService has thrown exception, unwinding now
      org.apache.cxf.interceptor.security.AccessDeniedException: Failure checking for permissions
      at com.thesearchagency.sapi.security.PermissionsCheckingInterceptor.handleMessage(PermissionsCheckingInterceptor.java:67)
      at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
      at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
      at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211)
      at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)
      at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154)
      at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:146)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:679)
      [2012-10-17 14:34:40,174]-3972393 [http-8080-5] INFO com.thesearchagency.sapi.security.SecurityExceptionInterceptor - Setting HTTP status code to 403

        Attachments

          Activity

            People

            • Assignee:
              pwynne Patrick Wynne
              Reporter:
              jelliott Jen Clarke (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: