Details
-
Type: Bug
-
Status: Closed
-
Priority: Blocker
-
Resolution: Not a Bug
-
Affects Version/s: sprint 10: 10-17-2012, Aquidneck
-
Fix Version/s: 2.0.0, sprint 11: 10-31-2012, Aquidneck
-
Component/s: Security Framework
-
Labels:None
-
Environment:
sapi 138
-
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:
[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]:
[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
[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'
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
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