Install Database Monitoring on Linux (RPM)

This page describes the steps required to install Database Collector on Linux (RPM).

Ensure that the machine on which you install the Database Collector has network access to the databases you want to monitor.

Perform the following steps:

Add the Splunk AppDynamics repository by creating the /etc/yum.repos.d/artifactory.repo file with the following content:
```
[Artifactory]
name=Artifactory
baseurl=https://appdynamics.jfrog.io/artifactory/rpm-hosted/
enabled=1
gpgcheck=0
```
CODE
Find the package in the repository:
```
yum search appddbcollector
```
CODE
Install the package:
```
yum install appddbcollector.aarch64
```
CODE

Update the configuration file /opt/appdynamics/appddbcol/conf/appddbcollector.yaml:

appddbcollector.yaml

appdynamics_credentials:
  client_id: <client-id>
  client_secret: <secret>
  endpoint: <data-endpoint>
  token_url: <auth-endpoint>  

# Set below fields in the config to provide SSL details
# tlsConfig:
#  certificate: <certificate>
#  hostNameInCertificate: <hostname>

# Set below field in the config to specify environment (defaults to self-hosted)
# environment:
#  platform: self-hosted # Other possible properties "AWS", "Azure"

monitoring_config:
  sqlserver/1:
    configName: ${CONFIG_NAME}
    hostname: ${HOSTNAME}
    hostport: ${HOSTPORT}
    username: ${USERNAME}
    password: ${PASSWORD}
    database: ${DATABASE}
    tlsConfig:
      certificate: ${CERTIFICATE_CRT}
      hostNameInCertificate: ${HOSTNAMEINCERTIFICATE}
    environment:
      platform: ${CLOUD_CONFIG}
  mysql/1:
    configName: ${CONFIG_NAME}
    hostname: ${HOSTNAME}
    hostport: ${HOSTPORT}
    username: ${USERNAME}
    password: ${PASSWORD}
    environment:
      platform: ${CLOUD_CONFIG}
    tlsConfig:
      certificate: ${CERTIFICATE_CRT}
      hostNameInCertificate: ${HOSTNAMEINCERTIFICATE}
  aurora-mysql/1:
    configName: ${CONFIG_NAME}
    hostname: ${HOSTNAME}
    hostport: ${HOSTPORT}
    username: ${USERNAME}
    password: ${PASSWORD}
    environment:
      platform: ${CLOUD_CONFIG}
    tlsConfig:
      certificate: ${CERTIFICATE_CRT}
      hostNameInCertificate: ${HOSTNAMEINCERTIFICATE}
  mariadb/1:
    configName: ${CONFIG_NAME}
    hostname: ${HOSTNAME}
    hostport: ${HOSTPORT}
    username: ${USERNAME}
    password: ${PASSWORD}
    environment:
      platform: ${CLOUD_CONFIG}
    tlsConfig:
      certificate: ${CERTIFICATE_CRT}
      hostNameInCertificate: ${HOSTNAMEINCERTIFICATE} 
  aurora-postgresql/1:
    configName: ${CONFIG_NAME}
    hostname: ${HOSTNAME}
    hostport: ${HOSTPORT}
    username: ${USERNAME}
    password: ${PASSWORD}
    environment:
      platform: ${CLOUD_CONFIG}
    tlsConfig:
      certificate: ${CERTIFICATE_CRT}
  postgres/1:
    configName: ${CONFIG_NAME}
    hostname: ${HOSTNAME}
    hostport: ${HOSTPORT}
    username: ${USERNAME}
    password: ${PASSWORD}
    environment:
      platform: ${CLOUD_CONFIG}
    tlsConfig:
      certificate: ${CERTIFICATE_CRT}

YML

Specify aws or azure on the platform field. Keep the field empty if you are not using any of these platforms.
By default, logs are available in the /opt/appdynamics/appddbcol/logs directory.

Restart the service:

systemctl restart appddbcollector

CODE

You can check the logs using the following command:

tail -f /opt/appdynamics/appddbcol/logs/appddbcollector.log

CODE