JDBC data not populated for tomcat added by Prometheus
To configure JDBC metrics in tomcat exporter
1) Open the below file from tomcat installation directory.
$CATALINA_BASE/conf/server.xml
2) Add the following configuration under <GlobalNamingResources> tag in the server.xml file.
<Resource name="<CUSTOM_RESOURCE_NAME>"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
jdbcInterceptors="nl.nlighten.prometheus.tomcat.TomcatJdbcInterceptor(logFailed=true,logSlow=true,threshold=1000,buckets=.01|.05|.1|1|10,slowQueryBuckets=1|10|30)"
username="<DB_USERNAME>"
password="<DB_PASSWORD>"
driverClassName="<JDBC_DRIVER_NAME>"
url="<JDBC_CONNECTION_URL>"/>
3) Restart tomcat server/pod and access the metrics URL: http://host:port/metrics. Check if JDBC metrics are generated or not.
Eg.
Eg.
4) Check if the metrics are scraped by Prometheus using PromQL query tool. A query execution example is shown below.
5) Now poll the monitor from Applications Manager and verify if JDBC data is populated in the UI.
New to ADSelfService Plus?
Resources
Related Articles
Data is not being properly populated for Tomcat 5 and above versions in APM. How can I check for correct data?
To check whether data collected properly or not, access the below URLs : For versions below 5.x: http://<Tomcat Host>:<Port>/adventnet/DataServlet For Versions 5.x and above: Server Info: http://<Tomcat ...How to configure Tomcat Exporter to scrape metrics from Prometheus?
To setup exporter, follow the steps given below: Install a standalone Tomcat-sever or as a container as kubernetes cluster. Download the Tomcat exporter servlet file in .war format from here. Rename the file as metrics.war and deploy it in the ...Applications Manager is not collecting data from Tomcat Server.
If the proxy settings are configured wrong, then Tomcat Data collection will not happen correctly as Applications Manager uses HTTP requests for data collection from Tomcat Server. Check if you are able to access the Tomcat Server from browser in ...No data available (or) error in SharePoint monitor added in WMI mode
If data is not available or if you encounter any error during data collection for SharePoint server monitor added in WMI mode, follow the steps below: If you are using AppManager version 15470 and above, you can navigate to Admin > Self Help Tools ...Data is not being populated in the monitor, but is visible when the script is executed in the Powershell Window
Problem: Data is not being populated in the monitor, but is visible when the script is executed in the Powershell Window. Solution: The problem could be due to the any of the following: 1) Verify if AppManager service has permission to run the ...