[tsaapp@optus-qa-smb1 jboss-5.1.0.GA]$ tail -f tsa_messaging_node_server.log 18:22:03,160 INFO [AuditorServiceBD] Exiting the audit method... 18:22:03,161 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 2851 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload:
11
failuredeploymentIPAddress: may not be null -------------------------------------- 18:22:48,453 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 18:22:48,453 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 18:22:48,454 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 18:22:48,471 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 18:23:28,742 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 2852 Address: /Optus-SG/SiteGenerationService Encoding: UTF-8 Content-Type: text/xml;charset=UTF-8 Headers: {content-type=[text/xml;charset=UTF-8], host=[localhost:9991], Content-Length=[474], SOAPAction=["http://www.thesearchagency.com/SiteGenerationService/deploySite"], user-agent=[Jakarta Commons-HttpClient/3.1], accept-encoding=[gzip,deflate], Content-Type=[text/xml;charset=UTF-8]} Payload:
1 1
789654123-123456 -------------------------------------- 18:23:28,743 INFO [SiteGenerationServiceWSImpl] SGS: RemoveSiteRequest received 18:23:28,744 INFO [AuditorServiceBD] Entering the audit method... 18:23:28,744 DEBUG [JdbcTemplate] Executing prepared SQL query 18:23:28,744 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?] 18:23:28,745 DEBUG [JdbcTemplate] Executing prepared SQL query 18:23:28,745 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?] 18:23:28,745 DEBUG [JdbcTemplate] Executing prepared SQL update 18:23:28,745 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)] 18:23:28,757 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:23:28,758 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 18:23:28,761 DEBUG [JdbcTemplate] Executing prepared SQL update 18:23:28,761 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)] 18:23:28,766 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:23:28,766 INFO [AuditorServiceBD] Exiting the audit method... 18:23:28,767 INFO [SiteServiceBD] Inside queueRequest() 18:23:28,796 INFO [AuditorServiceBD] Entering the audit method... 18:23:28,796 DEBUG [JdbcTemplate] Executing prepared SQL query 18:23:28,796 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?] 18:23:28,797 DEBUG [JdbcTemplate] Executing prepared SQL query 18:23:28,797 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?] 18:23:28,798 DEBUG [JdbcTemplate] Executing prepared SQL update 18:23:28,798 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)] 18:23:28,802 INFO [SiteServiceRequestMDB] Processing Inbound SiteServiceRequest Message 18:23:28,805 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:23:28,805 INFO [SiteServiceBD] Inside removeSite() 18:23:28,805 INFO [AuditorServiceBD] Entering the audit method... 18:23:28,805 DEBUG [JdbcTemplate] Executing prepared SQL query 18:23:28,805 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?] 18:23:28,808 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 18:23:28,811 DEBUG [JdbcTemplate] Executing prepared SQL update 18:23:28,811 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)] 18:23:28,816 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:23:28,816 INFO [AuditorServiceBD] Exiting the audit method... 18:23:28,817 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 2852 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload:
11
queuedCustomerId [789654123-123456] Site has been queued for removal. -------------------------------------- 18:23:28,821 DEBUG [JdbcTemplate] Executing prepared SQL query 18:23:28,821 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?] 18:23:28,823 DEBUG [JdbcTemplate] Executing prepared SQL update 18:23:28,823 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)] 18:23:28,823 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:23:28,823 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 18:23:28,833 DEBUG [JdbcTemplate] Executing prepared SQL update 18:23:28,833 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)] 18:23:28,834 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:23:28,834 INFO [AuditorServiceBD] Exiting the audit method... 18:23:28,835 DEBUG [JdbcTemplate] Executing prepared SQL query 18:23:28,835 DEBUG [JdbcTemplate] Executing prepared SQL statement [select customerId,hostingServerID,domain,dateAssigned,status from hostingAssignments where customerId = ? ] 18:23:28,846 WARN [OptusSiteAdapter] Attempting to remove site [www.cust4-qa-domain.com] for customerId [789654123-123456]. 18:23:29,170 INFO [OptusSiteAdapter] Removing Site from remote host... 18:23:29,170 INFO [OptusSiteAdapter] Removing Site www.cust4-qa-domain.com from Hosting Server 50.57.178.216 18:23:29,170 INFO [OptusSiteAdapter] Remote Hosting Site Directory :/var/www/html/customer-sites/c/u/www.cust4-qa-domain.com 18:23:29,956 INFO [OptusSiteAdapter] SCPing files to web_page_transfer@50.57.178.216:/var/www/html/customer-sites/c/u/www.cust4-qa-domain.com 18:23:29,956 INFO [OptusSiteAdapter] Files to SCP :: 18:23:29,956 INFO [OptusSiteAdapter] File [1] : [/var/www/sites/c/u/www.cust4-qa-domain.com/.htaccess] 18:23:30,184 DEBUG [JdbcTemplate] Executing prepared SQL update 18:23:30,185 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into hostingAssignments(customerId, hostingServerID, domain, dateAssigned, status) values(?,?,?,?,?)] 18:23:30,186 DEBUG [JdbcTemplate] Executing prepared SQL update 18:23:30,186 DEBUG [JdbcTemplate] Executing prepared SQL statement [update hostingAssignments set hostingServerID = ?, status = ?, dateAssigned = ?, domain = ? where customerId = ?] 18:23:30,189 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:23:30,190 INFO [SiteServiceBD] Inside queueResponse() 18:23:30,190 INFO [SiteServiceBD] Site Deployment Status: 1null 18:23:30,222 INFO [AuditorServiceBD] Entering the audit method... 18:23:30,223 DEBUG [JdbcTemplate] Executing prepared SQL query 18:23:30,223 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?] 18:23:30,224 INFO [SiteServiceResponseMDB] Processing Outbound SiteServiceResponse Message 18:23:30,227 DEBUG [JdbcTemplate] Executing prepared SQL query 18:23:30,227 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?] 18:23:30,228 DEBUG [JdbcTemplate] Executing prepared SQL update 18:23:30,228 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)] 18:23:30,229 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:23:30,229 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 18:23:30,233 DEBUG [JdbcTemplate] Executing prepared SQL update 18:23:30,233 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)] 18:23:30,234 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:23:30,234 INFO [AuditorServiceBD] Exiting the audit method... 18:23:30,234 WARN [SiteServiceRequestMDB] Site removed for : 789654123-123456 from 50.57.178.216 - requestId : 1 18:23:30,236 INFO [CallbackEventAdapterOptus] Sending PublishDeployStatusReq 18:23:30,238 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 2853 Address: http://50.57.178.209:8080/Optus-CB/OptusCallbackService Encoding: UTF-8 Content-Type: text/xml Headers: {SOAPAction=[""], Accept=[*/*]} Payload:
11
site_generation789654123-123456return_codesuccess -------------------------------------- 18:23:30,241 INFO [DeployCallbackImpl] Executing operation publishDeployResult 18:23:30,241 INFO [STDOUT] com.thesearchagency.optus.service.callback.service.PublishDeployResultRequest@35e83279 18:23:30,243 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 2853 Response-Code: 200 Encoding: UTF-8 Content-Type: text/xml;charset=UTF-8 Headers: {content-type=[text/xml;charset=UTF-8], Date=[Fri, 11 Jan 2013 07:23:30 GMT], Content-Length=[380], X-Powered-By=[Servlet 2.5; JBoss-5.0/JBossWeb-2.1], Server=[Apache-Coyote/1.1]} Payload: 11success -------------------------------------- 18:23:30,244 DEBUG [CallbackEventAdapterOptus] Received PublishDeployStatusResp. Indicated result: COMPLETED 18:23:30,245 INFO [AuditorServiceBD] Entering the audit method... 18:23:30,245 DEBUG [JdbcTemplate] Executing prepared SQL query 18:23:30,245 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?] 18:23:30,246 DEBUG [JdbcTemplate] Executing prepared SQL query 18:23:30,246 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?] 18:23:30,247 DEBUG [JdbcTemplate] Executing prepared SQL update 18:23:30,247 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)] 18:23:30,248 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:23:30,248 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 18:23:30,252 DEBUG [JdbcTemplate] Executing prepared SQL update 18:23:30,252 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)] 18:23:30,253 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:23:30,253 INFO [AuditorServiceBD] Exiting the audit method...