Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: sprint 9: 10-03-2012, Aquidneck
-
Fix Version/s: 2.0.0, sprint 11: 10-31-2012, Aquidneck
-
Component/s: Budget Estimator
-
Labels:None
-
Environment:
aq-qa-tomcat1
-
Sprint:Sprint 10, Sprint 11
Description
This is what I sent via soapUI: campaigns (services in ('google',) and businessAreaId in ('2000040') and locationId in ('18363'))
Expected Error: INVALID_TARGETING_CRITERIA_ERROR
Actual Error: permissions error
[2012-10-02 15:15:57,754]-1549405 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - handleMessage
[2012-10-02 15:15:57,754]-1549405 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Received query string: null
[2012-10-02 15:15:57,754]-1549405 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Using context from header: X-TSA-Authenticate
[2012-10-02 15:15:57,755]-1549406 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext - Token:CHD6Z35UIB52P23SWVTJ6LQLWWO6LSLPGRAZEZBHMKPQYDDW3E5SODSRGIL7RHBWQ5I3VEFI5DP3ALA5H6JSWDCIBYBJZI6USK3QYTXBAM6ZXR4CHJIMFZ2WHJV7BLUTUU7IK2YO2PW5T23V2Q5XC57HIA======
[2012-10-02 15:15:57,758]-1549409 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - Adding (token 4421618960868944:[e042e3b8-b281-4851-a76d-acfabb994dec, c7542d20-f6ba-4784-842b-9202a92190e2]:{}) context to message
[2012-10-02 15:15:57,760]-1549411 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- Beginning request conversion ----------
[2012-10-02 15:15:57,760]-1549411 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found security context for c7542d20-f6ba-4784-842b-9202a92190e2
[2012-10-02 15:15:57,760]-1549411 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found tokenized security context: (token 4421618960868944:[e042e3b8-b281-4851-a76d-acfabb994dec, c7542d20-f6ba-4784-842b-9202a92190e2]:{})
[2012-10-02 15:15:57,760]-1549411 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- End request conversion ----------
[2012-10-02 15:15:57,760]-1549411 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting request context for c7542d20-f6ba-4784-842b-9202a92190e2 in realm null
[2012-10-02 15:15:57,761]-1549412 [http-8080-1] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory - Property set for settings/null.properties is {}
[2012-10-02 15:15:57,762]-1549413 [http-8080-1] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - handleMessage
[2012-10-02 15:15:57,762]-1549413 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.campaign.CampaignService.getCampaignEstimate(com.thesearchagency.saas.core.services.IRequestContext,java.lang.String)
[2012-10-02 15:15:57,762]-1549413 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Excuting getCampaignEstimate
[2012-10-02 15:15:57,763]-1549414 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.campaign.CampaignService.getCampaignEstimate
[2012-10-02 15:15:57,763]-1549414 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Getting connection for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager
[2012-10-02 15:15:57,764]-1549415 [http-8080-1] ERROR jdbc.audit - 25. 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 139,916 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:176)
at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:38)
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.doPost(AbstractHTTPServlet.java:141)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
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-02 15:15:57,766]-1549417 [http-8080-1] ERROR jdbc.sqlonly - 25. 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 139,916 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:176)
at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:38)
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.doPost(AbstractHTTPServlet.java:141)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
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-02 15:15:57,767]-1549418 [http-8080-1] ERROR jdbc.sqltiming - 25. 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 139,916 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:176)
at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:38)
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.doPost(AbstractHTTPServlet.java:141)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
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-02 15:15:57,769]-1549420 [http-8080-1] 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 139,916 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:176)
at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:38)
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.doPost(AbstractHTTPServlet.java:141)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
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-02 15:15:57,771]-1549422 [http-8080-1] 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:41)
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.doPost(AbstractHTTPServlet.java:141)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
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:157)
at com.thesearchagency.database.storage.JDBCStorageManager.get(JDBCStorageManager.java:176)
at com.thesearchagency.saas.core.services.security.manager.dao.StorageManagerSecurityDAO.getPrincipalById(StorageManagerSecurityDAO.java:38)
... 27 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 139,916 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-02 15:15:57,774]-1549425 [http-8080-1] 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.doPost(AbstractHTTPServlet.java:141)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
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-02 15:15:57,775]-1549426 [http-8080-1] INFO com.thesearchagency.sapi.security.SecurityExceptionInterceptor - Setting HTTP status code to 403