Service Mapping Tomcat does not show database connection even if added manually

[smouazzen]

We are on version Vancouver and trying to create a Service Map for multiple applications. Some of our applications are running Tomcat behind a load balancer and the Service Mapping works up to the Tomcat application server, but will not show the MySQL database server. Both servers are discovered and the Tomcat application server CI (in cmdb_ci_app_server_tomcat) show a "Depends on" relationship with the MySQL Server. 

The MySQL server does show up as a Suggested Connections, and when added manually, does not show in the Service Map (the diagram).

[Prabhjyot Sing1]

Hi @smouazzen 

I have a few questions before I can help you out with the issue.

1. Is the MySQL Server discoverable by horizontal discovery?

2. What type of endpoint is used while creating the manual connection with the Tomcat? 

3. Do you see any errors related to the database when you create the manual connection - Ex- No application running on port etc. ?

[smouazzen]

Hi Prabhjyot and thanks for the reply, 

1. Yes, the MySQL server is discovered and shows a upstream relationships as "Runs" MySQL and "used by" the Tomcat server.

2.  Not sure how to determine the type of connection, here is the connection suggestion details:

3. I did not receive any errors when the suggested connections was added. 

Thanks,

smouazzen

 

[Prabhjyot Sing1]

Hi @smouazzen ,

To add the connection suggestion to the map, you will have to approve the suggestion.

As you can see the decision for the suggestion still shows undecided you can open this suggestion and change the value to "Added Manually" to add it to the map.

Also attaching reference to connection suggestion in service mapping - https://docs.servicenow.com/en-US/bundle/vancouver-it-operations-management/page/product/service-map...

[smouazzen]

Hi Prabhjyot,

I did change it to "Added manually", still not showing on the map. Are we missing a step? 

Thanks,

smouazzen