apache / skywalking

APM, Application Performance Monitoring System
https://skywalking.apache.org/
Apache License 2.0
23.71k stars 6.5k forks source link

UI problem: Database and Infrastructure monitoring #6869

Closed bpadulareply closed 3 years ago

bpadulareply commented 3 years ago

Please answer these questions before submitting your issue.


Question

log error Error

I am trying to setup a working enviroment for Apache skywalking. I successfully instrumented a Java agent running in a tomcat10 application. Next I've tried to implement an infrastucture monitoring following this guide: https://skywalking.apache.org/blog/2021-02-07-infrastructure-monitoring/ I successfully installed the Prometheus exporter and a local instance of OpenTelemetry (at first I used docker but had some problem with networking). As you can see from the logs the enviroment seems to be working. Unfortunately I can't see the vm on my UI, i've tried different configuration or test but I had no success.

The problem that I want to solve: noVmUI

Prometheus on remote WindowsMachine prometheusMetrics

Metrics acquired from otel OtelMetrics

Active connection (otel->skywalkingOAP, otel->Prometheus) activeConnections

Otel configuration OtelConf

application.yaml file SKWcoreConf SKWotelConf

webapp.yaml file SKWwebappConf

Lastly I moved to a mysql db agent: I used this configuration: https://github.com/apache/skywalking/blob/master/docs/en/setup/backend/backend-storage.md I activate the mysql module in the selector, downloaded the driver (mysql-connector-java-5.1.46.jar) as required and I have tested all the db connection that are working properly right now.

application.yaml file SKWmysqlConf

Unfortunately I have the same exact problem as for the previous agent, do you get any suggestion on what to do in order to see the vm or the database in the SkyWalking UI? Is the webapp error related to it? I couldn't find anything useful about this error.

wu-sheng commented 3 years ago

First about database metrics, currently, database-related metrics are from your language agent detection. If you can see spans of trace include DB access and SQL in it. You will see the metrics. application.yaml's MySQL is indicating SkyWalking requires MySQL as storage, nothing about monitoring.

wu-sheng commented 3 years ago

I don't think our OS monitoring has Windows related setup, it should be a Linux kernel. If you want to monitor Windows, you have to learn and write MAL as we provided in default, https://github.com/apache/skywalking/blob/master/oap-server/server-bootstrap/src/main/resources/otel-oc-rules/vm.yaml

Read the documentation about MAL and take reference to what we gave.

At last, how to use docker and how to make the network connectable for docker env is the capability and skill you should learn. Or if you don't like docker, you could use OpenTelemetry's binary to do so.