basicauth extension while monitoring oracledb using Splunk Otel

[sagar-yakkundi]

Hi,

Instead of passing the username and password in a plain text format, I was trying the basicauth extension for authentication and monitoring the oracledb and require some assistance, as after adding the below details in the agent_config.yml , The splunk otel collector is not starting up and am seeing error.

Kindy help.

In agent_config.yml

extensions:
   basicauth:
   htpasswd:
       file: /etc/otel/collector/.htpasswd

receivers:
  oracledb/demo:
  protocols:
     http:
       auth:
          authenticator: basicauth
   endpoint: <hostname:port>
   service: <DBname>

service:
   metrics:
       receivers: [oracledb/demo]

[bishida · Accepted solution]

Hi,

Probably worth mentioning--the oracledb receiver is not something that is accessed with http, so you don't want to try to use ".htaccess". You need to use a service account within oracle that has some basic grant privileges. The receiver connects to your Oracle DB and pulls out the metrics for monitoring. The config for this will look like this:

receivers:
  oracledb:
    datasource: "oracle://USERNAME:PASSWORD@HOST:PORT/DATABASE"

https://docs.splunk.com/observability/en/gdi/opentelemetry/components/oracledb-receiver.html