After restoring the gateway from a snapshot the ssg service would not start. Below are the last errors in the ssg_0_0.log:
2020-04-20T20:04:51.051+0200 INFO 1 com.l7tech.server.service.ServiceWsdlImportChecker: Checking WSDL imports for SOAP services.
2020-04-20T20:05:56.004+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP1//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:06:59.018+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP2/ServiceBeantwoordVraag.svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:08:02.042+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP3//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:09:05.058+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP4//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:10:08.084+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP5//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:11:11.096+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP6//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:12:14.130+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP7//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:13:17.156+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP8//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:15:23.211+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP9//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:16:26.231+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP10//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:17:29.243+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP11//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:18:32.276+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP12//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:19:35.298+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP13//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:19:37.632+0200 INFO 1 com.l7tech.server.transport.SsgConnectorManagerImpl: Default HTTP port: 8080
2020-04-20T20:19:37.637+0200 INFO 1 com.l7tech.server.transport.SsgConnectorManagerImpl: Default HTTPS port: 8443
2020-04-20T20:19:38.521+0200 INFO 1 com.l7tech.server.log.SinkManager: Redirecting logging to configured log sinks.
2020-04-20T20:19:38.553+0200 INFO 1 com.l7tech.server.log.SinkManager: Redirected logging to configured log sinks.
Release : 9.4
Component : API GATEWAY
It looks like the gateway was trying to load a WSDL in cache from a host that was not reachable.
We were able to fix this by disabling the services that had an issue directly within the database.
1. We have listed all of the services with the issue by executing the following:
mysql ssg -e "select * from published_service where wsdl_xml like'%Service..svc?wsdl%';"
2. To disable services with the issue:
mysql ssg -e "update published_service set disabled='1' where wsdl_xml like'%Service..svc?wsdl%';"
3. and restarted the ssg service
SSG Service is now running and we are able to login to the gateway.
4. to enable those services back, make sure that gateway can reach out to the host.
Then run this:
mysql ssg -e "update published_service set disabled='0' where wsdl_xml like'%Service..svc?wsdll%';"
service ssg restart