2013-02-05 14:40:47,133-233163 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 78 Address: http://reseller1.aq-qa-tomcat1:8080/sapi/rest/merchants/d7a705c4-497d-4ee2-a1e4-b5dfcb5327f5 Encoding: ISO-8859-1 Http-Method: PUT Content-Type: application/json Headers: {Accept=[application/json, text/plain], accept-charset=[ISO-8859-1,utf-8;q=0.7,*;q=0.3], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8,ja;q=0.6], connection=[keep-alive], Content-Length=[248], content-type=[application/json], host=[reseller1.aq-qa-tomcat1:8080], origin=[http://reseller1.aq-qa-tomcat1:8080], referer=[http://reseller1.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17], x-tsa-authenticate=[X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======]} Payload: {"active":true,"comments":"comment","contactEmail":"24test@24test.com","contactName":"24test@24test.com","contactPhoneNumber":"1234454545667","customerId":"24test","displayName":"24 test","id":"d7a705c4-497d-4ee2-a1e4-b5dfcb5327f5","name":"24test"} -------------------------------------- 2013-02-05 14:40:47,134-233164 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - handleMessage 2013-02-05 14:40:47,134-233164 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Received query string: null 2013-02-05 14:40:47,134-233164 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Using context from header: X-TSA-Authenticate 2013-02-05 14:40:47,134-233164 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext [] - Token:X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY====== 2013-02-05 14:40:47,137-233167 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Adding (token 2013-02-05T14:37:21.387Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) context to message 2013-02-05 14:40:47,139-233169 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext [timezone=UTC, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Token:X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY====== 2013-02-05 14:40:47,142-233172 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found security context for 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-05 14:40:47,142-233172 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found tokenized security context: (token 2013-02-05T14:37:21.387Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) 2013-02-05 14:40:47,142-233172 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting request context for 273c4aab-e844-42d1-8c5a-2063ca535bba in realm com.reseller1 2013-02-05 14:40:47,142-233172 [http-8080-1] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Property set for settings/com.reseller1.properties is {} 2013-02-05 14:40:47,143-233173 [http-8080-1] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - handleMessage 2013-02-05 14:40:47,143-233173 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.merchant.MerchantService.updateMerchant(com.thesearchagency.saas.core.services.IRequestContext,java.lang.String,com.thesearchagency.sapi.data.Merchant) 2013-02-05 14:40:47,143-233173 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Executing updateMerchant 2013-02-05 14:40:47,144-233174 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking if the principal is active 2013-02-05 14:40:47,144-233174 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-05 14:40:47,155-233185 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-05 14:40:47,157-233187 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.merchant.MerchantService.updateMerchant 2013-02-05 14:40:47,157-233187 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager 2013-02-05 14:40:47,158-233188 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-05 14:40:47,159-233189 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Attempting to get permissions for principal 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-05 14:40:47,175-233205 [http-8080-1] INFO com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - matching 'SAPI:execute:com.thesearchagency.sapi.services.merchant.MerchantService.updateMerchant'.matches('.*:.*:.*') -> true 2013-02-05 14:40:47,176-233206 [http-8080-1] DEBUG com.thesearchagency.sapi.services.merchant.MerchantService [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - updateMerchant(d7a705c4-497d-4ee2-a1e4-b5dfcb5327f5,com.thesearchagency.sapi.data.Merchant@6964085) 2013-02-05 14:40:47,176-233206 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-05 14:40:47,177-233207 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-05 14:40:47,178-233208 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-05 14:40:47,179-233209 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-05 14:40:47,215-233245 [http-8080-1] DEBUG com.thesearchagency.sapi.services.SapiServiceSecurityHelper [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - user: {WorkPhone=+1-111-111-1111, Type=USER, Organization=tsa, LastModifiedDate=1970-01-01 01:01:01.0, Salt=496620796f75206265636f6d6520746f6f20736572696f75732c20796f752077696c6c206c6f736520796f7572207761792e, LastModifiedBy=tsa, HashedPassword=66dfa38993e9c88db6724d9b72f6ef115ee4630ce3ce7bd87371cdf95e936a67635037f00b7068846373f7d036b34ed7001a20c731d95dcd96f44ac3046f4940, LastName=lName, HomePhone=+1-111-111-1111, LastLoginDate=2013-02-05 14:37:42.0, Birthday=1970-01-01 01:01:01.0, Timezone=EST, Realm=com.reseller1, FirstName=fName, CountryCode=US, MobilePhone=+1-111-111-1111, Description=Principal representing the reseller1 admin user, DisplayName=Reseller1 admin user, Active=true, Email=reseller1@thesearchagency.com, Gender=MALE, HomePage=http://www.thesearchagency.com, CreatedBy=tsa, CreatedDate=1970-01-01 01:01:01.0, Language=en, Id=273c4aab-e844-42d1-8c5a-2063ca535bba} 2013-02-05 14:40:47,216-233246 [http-8080-1] DEBUG com.thesearchagency.sapi.services.SapiServiceSecurityHelper [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - subject: com.thesearchagency.sapi.data.Merchant@6964085 2013-02-05 14:40:47,217-233247 [http-8080-1] DEBUG com.thesearchagency.sapi.services.SapiServiceSecurityHelper [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - permissions: [{Name=any, Data=*:*:*, Active=true, Description=Ability to do anything, Type=REGEX, Realm=com.*, CreatedDate=1970-01-01 01:01:01.0, CreatedBy=admin, LastModifiedDate=1970-01-01 01:01:01.0, Id=b59fa344-7ae0-47ec-a5a3-dd8e51caac9d, LastModifiedBy=admin}, {Name=matching-realms, Data=(subject.getRealm()==null||user.getRealm().equals("com.thesearchagency"))||(user.getRealm().equals(subject.getRealm())), Active=true, Description=Checks that the user and subject are in the same realm, Type=EXPRESSION, Realm=com.*, CreatedDate=1970-01-01 01:01:01.0, CreatedBy=admin, LastModifiedDate=1970-01-01 01:01:01.0, Id=04518081-0906-4c0e-8fb4-e279b50b4829, LastModifiedBy=admin}] 2013-02-05 14:40:47,226-233256 [http-8080-1] DEBUG com.thesearchagency.sapi.services.merchant.MerchantService [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - doValidateData 2013-02-05 14:40:47,230-233260 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_merchant_MerchantServiceComponent 2013-02-05 14:40:47,233-233263 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-05 14:40:47,235-233265 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-05 14:40:47,237-233267 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-05 14:40:47,238-233268 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_merchant_MerchantServiceComponent 2013-02-05 14:40:47,240-233270 [http-8080-1] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - update statement: com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager$4@3318eeda 2013-02-05 14:40:47,241-233271 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=939e5726-6615-4e17-89fa-37d302b5afd3, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-05 14:40:47,250-233280 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Headers: null 2013-02-05 14:40:47,250-233280 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Expires header 2013-02-05 14:40:47,250-233280 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Cache-Control header 2013-02-05 14:40:47,250-233280 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Pragma header 2013-02-05 14:40:47,252-233282 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 78 Response-Code: 200 Content-Type: application/json Headers: {Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[939e5726-6615-4e17-89fa-37d302b5afd3], Date=[Tue, 05 Feb 2013 14:40:47 GMT]} Payload: ["Comments","Description","ContactName","ContactEmail","ContactPhoneNumber","LastModifiedDate","PhoneNumber","LastModifiedBy","UserId","DisplayName","GroupId","ResellerId","CreatedByName","Name","Active","Url","CustomerId","LastModifiedByName","CreatedBy","CreatedDate","Realm","Id"] -------------------------------------- 2013-02-05 14:40:47,354-233384 [http-8080-3] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 79 Address: http://reseller1.aq-qa-tomcat1:8080/sapi/rest/orders?q=SELECT%20%20WHERE%20(associatedMerchant.id%20%3D%20'null')%20ORDER%20BY%20modificationDate%20DESC Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], accept-charset=[ISO-8859-1,utf-8;q=0.7,*;q=0.3], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8,ja;q=0.6], connection=[keep-alive], Content-Type=[null], host=[reseller1.aq-qa-tomcat1:8080], referer=[http://reseller1.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17], x-tsa-authenticate=[X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======]} -------------------------------------- 2013-02-05 14:40:47,354-233384 [http-8080-3] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - handleMessage 2013-02-05 14:40:47,355-233385 [http-8080-3] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Received query string: q=SELECT%20%20WHERE%20(associatedMerchant.id%20%3D%20'null')%20ORDER%20BY%20modificationDate%20DESC 2013-02-05 14:40:47,355-233385 [http-8080-3] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Extracted parameters: {q=[SELECT WHERE (associatedMerchant.id = 'null') ORDER BY modificationDate DESC]} 2013-02-05 14:40:47,355-233385 [http-8080-3] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Using context from header: X-TSA-Authenticate 2013-02-05 14:40:47,355-233385 [http-8080-3] DEBUG com.thesearchagency.security.TokenizedSecurityContext [] - Token:X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY====== 2013-02-05 14:40:47,358-233388 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 80 Address: http://reseller1.aq-qa-tomcat1:8080/sapi/rest/orders?q=SELECT%20WHERE%20((associatedMerchant.id%20%3D%20'null')%20AND%20(state%20!%3D%20'QUOTE'))%20ORDER%20BY%20modificationDate%20DESC%20LIMIT%201 Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], accept-charset=[ISO-8859-1,utf-8;q=0.7,*;q=0.3], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8,ja;q=0.6], connection=[keep-alive], Content-Type=[null], host=[reseller1.aq-qa-tomcat1:8080], referer=[http://reseller1.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17], x-tsa-authenticate=[X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======]} -------------------------------------- 2013-02-05 14:40:47,358-233388 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - handleMessage 2013-02-05 14:40:47,359-233389 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Received query string: q=SELECT%20WHERE%20((associatedMerchant.id%20%3D%20'null')%20AND%20(state%20!%3D%20'QUOTE'))%20ORDER%20BY%20modificationDate%20DESC%20LIMIT%201 2013-02-05 14:40:47,359-233389 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Extracted parameters: {q=[SELECT WHERE ((associatedMerchant.id = 'null') AND (state != 'QUOTE')) ORDER BY modificationDate DESC LIMIT 1]} 2013-02-05 14:40:47,359-233389 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Using context from header: X-TSA-Authenticate 2013-02-05 14:40:47,359-233389 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext [] - Token:X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY====== 2013-02-05 14:40:47,359-233389 [http-8080-3] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Adding (token 2013-02-05T14:37:21.387Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) context to message 2013-02-05 14:40:47,362-233392 [http-8080-3] DEBUG com.thesearchagency.security.TokenizedSecurityContext [timezone=UTC, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Token:X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY====== 2013-02-05 14:40:47,364-233394 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Adding (token 2013-02-05T14:37:21.387Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) context to message 2013-02-05 14:40:47,366-233396 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext [timezone=UTC, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Token:X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY====== 2013-02-05 14:40:47,368-233398 [http-8080-3] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found security context for 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-05 14:40:47,368-233398 [http-8080-3] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found tokenized security context: (token 2013-02-05T14:37:21.387Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) 2013-02-05 14:40:47,369-233399 [http-8080-3] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting request context for 273c4aab-e844-42d1-8c5a-2063ca535bba in realm com.reseller1 2013-02-05 14:40:47,369-233399 [http-8080-3] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Property set for settings/com.reseller1.properties is {} 2013-02-05 14:40:47,370-233400 [http-8080-3] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - handleMessage 2013-02-05 14:40:47,370-233400 [http-8080-3] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.order.OrderService.getOrders(com.thesearchagency.saas.core.services.IRequestContext,com.thesearchagency.query.dml.Select) 2013-02-05 14:40:47,371-233401 [http-8080-3] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Executing getOrders 2013-02-05 14:40:47,371-233401 [http-8080-3] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking if the principal is active 2013-02-05 14:40:47,371-233401 [http-8080-3] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-05 14:40:47,372-233402 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found security context for 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-05 14:40:47,373-233403 [http-8080-3] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-05 14:40:47,373-233403 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found tokenized security context: (token 2013-02-05T14:37:21.387Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) 2013-02-05 14:40:47,374-233404 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting request context for 273c4aab-e844-42d1-8c5a-2063ca535bba in realm com.reseller1 2013-02-05 14:40:47,374-233404 [http-8080-1] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Property set for settings/com.reseller1.properties is {} 2013-02-05 14:40:47,375-233405 [http-8080-1] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - handleMessage 2013-02-05 14:40:47,376-233406 [http-8080-3] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.order.OrderService.getOrders 2013-02-05 14:40:47,377-233407 [http-8080-3] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager 2013-02-05 14:40:47,376-233406 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.order.OrderService.getOrders(com.thesearchagency.saas.core.services.IRequestContext,com.thesearchagency.query.dml.Select) 2013-02-05 14:40:47,377-233407 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Executing getOrders 2013-02-05 14:40:47,377-233407 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking if the principal is active 2013-02-05 14:40:47,377-233407 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-05 14:40:47,378-233408 [http-8080-3] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-05 14:40:47,379-233409 [http-8080-3] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Attempting to get permissions for principal 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-05 14:40:47,379-233409 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-05 14:40:47,387-233417 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.order.OrderService.getOrders 2013-02-05 14:40:47,388-233418 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager 2013-02-05 14:40:47,389-233419 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-05 14:40:47,390-233420 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Attempting to get permissions for principal 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-05 14:40:47,404-233434 [http-8080-3] INFO com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - matching 'SAPI:execute:com.thesearchagency.sapi.services.order.OrderService.getOrders'.matches('.*:.*:.*') -> true 2013-02-05 14:40:47,410-233440 [http-8080-3] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Search returned 0 results 2013-02-05 14:40:47,410-233440 [http-8080-3] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=0b4297b7-13aa-46bf-9465-9ce1bb08a7a0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - 0 matches have been identified 2013-02-05 14:40:47,411-233441 [http-8080-1] INFO com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - matching 'SAPI:execute:com.thesearchagency.sapi.services.order.OrderService.getOrders'.matches('.*:.*:.*') -> true 2013-02-05 14:40:47,413-233443 [http-8080-3] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Headers: null 2013-02-05 14:40:47,413-233443 [http-8080-3] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Expires header 2013-02-05 14:40:47,413-233443 [http-8080-3] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Cache-Control header 2013-02-05 14:40:47,413-233443 [http-8080-3] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Pragma header 2013-02-05 14:40:47,415-233445 [http-8080-3] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 79 Response-Code: 200 Content-Type: application/json Headers: {Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[0b4297b7-13aa-46bf-9465-9ce1bb08a7a0], Date=[Tue, 05 Feb 2013 14:40:47 GMT]} Payload: {"total":0,"count":0,"pages":0,"current":1} -------------------------------------- 2013-02-05 14:40:47,418-233448 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Search returned 0 results 2013-02-05 14:40:47,418-233448 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=c1b2f1be-758f-45e3-a869-83b1b8b92be6, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - 0 matches have been identified 2013-02-05 14:40:47,419-233449 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Headers: null 2013-02-05 14:40:47,419-233449 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Expires header 2013-02-05 14:40:47,419-233449 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Cache-Control header 2013-02-05 14:40:47,419-233449 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Pragma header 2013-02-05 14:40:47,422-233452 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 80 Response-Code: 200 Content-Type: application/json Headers: {Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[c1b2f1be-758f-45e3-a869-83b1b8b92be6], Date=[Tue, 05 Feb 2013 14:40:47 GMT]} Payload: {"total":0,"count":0,"pages":0,"current":1} -------------------------------------- 2013-02-05 14:40:47,506-233536 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 81 Address: http://reseller1.aq-qa-tomcat1:8080/sapi/rest/orders?q=SELECT%20%20WHERE%20(state%20%3D%20'QUOTE'%20AND%20associatedMerchant.id%20%3D%20'null')%20ORDER%20BY%20modificationDate%20DESC Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], accept-charset=[ISO-8859-1,utf-8;q=0.7,*;q=0.3], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8,ja;q=0.6], connection=[keep-alive], Content-Type=[null], host=[reseller1.aq-qa-tomcat1:8080], referer=[http://reseller1.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17], x-tsa-authenticate=[X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======]} -------------------------------------- 2013-02-05 14:40:47,506-233536 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - handleMessage 2013-02-05 14:40:47,506-233536 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Received query string: q=SELECT%20%20WHERE%20(state%20%3D%20'QUOTE'%20AND%20associatedMerchant.id%20%3D%20'null')%20ORDER%20BY%20modificationDate%20DESC 2013-02-05 14:40:47,506-233536 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Extracted parameters: {q=[SELECT WHERE (state = 'QUOTE' AND associatedMerchant.id = 'null') ORDER BY modificationDate DESC]} 2013-02-05 14:40:47,506-233536 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Using context from header: X-TSA-Authenticate 2013-02-05 14:40:47,506-233536 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext [] - Token:X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY====== 2013-02-05 14:40:47,509-233539 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Adding (token 2013-02-05T14:37:21.387Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) context to message 2013-02-05 14:40:47,510-233540 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext [timezone=UTC, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Token:X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY====== 2013-02-05 14:40:47,513-233543 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found security context for 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-05 14:40:47,513-233543 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found tokenized security context: (token 2013-02-05T14:37:21.387Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) 2013-02-05 14:40:47,513-233543 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting request context for 273c4aab-e844-42d1-8c5a-2063ca535bba in realm com.reseller1 2013-02-05 14:40:47,514-233544 [http-8080-1] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Property set for settings/com.reseller1.properties is {} 2013-02-05 14:40:47,514-233544 [http-8080-1] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - handleMessage 2013-02-05 14:40:47,515-233545 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.order.OrderService.getOrders(com.thesearchagency.saas.core.services.IRequestContext,com.thesearchagency.query.dml.Select) 2013-02-05 14:40:47,515-233545 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Executing getOrders 2013-02-05 14:40:47,515-233545 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking if the principal is active 2013-02-05 14:40:47,515-233545 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-05 14:40:47,516-233546 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-05 14:40:47,518-233548 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.order.OrderService.getOrders 2013-02-05 14:40:47,518-233548 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager 2013-02-05 14:40:47,518-233548 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-05 14:40:47,520-233550 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Attempting to get permissions for principal 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-05 14:40:47,537-233567 [http-8080-1] INFO com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - matching 'SAPI:execute:com.thesearchagency.sapi.services.order.OrderService.getOrders'.matches('.*:.*:.*') -> true 2013-02-05 14:40:47,542-233572 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Search returned 0 results 2013-02-05 14:40:47,542-233572 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=efec7094-2111-4eea-bb91-bd031e53caa0, locale=en_US, authToken=X2CU34D5NWDJVRADZBO7Q7EXUNFJF76NCB2KHMXA26BXBPJOYWKODZE4X3E5CN46FAYAZGWESQGXUYB7WPH6LYCK2NIXCFSSDE6UQPFHZPKVL7PSSKJLQIF22NUYB77PYRT4JZYWUNBSM7HJD2OS4ETCUC4NKTZFXZ457WX23K2FQYHU6GMRB5FW56JKQHWWYVZWNFNUWRIYEYXWPPSXKBCMYY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - 0 matches have been identified 2013-02-05 14:40:47,543-233573 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Headers: null 2013-02-05 14:40:47,543-233573 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Expires header 2013-02-05 14:40:47,543-233573 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Cache-Control header 2013-02-05 14:40:47,543-233573 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Pragma header 2013-02-05 14:40:47,544-233574 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 81 Response-Code: 200 Content-Type: application/json Headers: {Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[efec7094-2111-4eea-bb91-bd031e53caa0], Date=[Tue, 05 Feb 2013 14:40:47 GMT]} Payload: {"total":0,"count":0,"pages":0,"current":1} -------------------------------------- 2013-02-05 14:41:29,717-275747 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Search returned 0 results 2013-02-05 14:41:29,718-275748 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - 0 matches have been identified 2013-02-05 14:41:29,718-275748 [order-update-timer-factory] INFO com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Beginning update for 0 orders.