Mysqld_exporter to connect to the DB using exporter user with mTLS and not plain-text password

raj8885 · November 14, 2023, 10:36pm

Description:

I need to convert the mysqld_exporter to connect to the DB using exporter user with mTLS but I do not see any available options in the web-config.yml to pass the certs location to authenticate with the exporter user subject string and create a connection. Has anyone achieved the same using the latest version of Pecona mysqld_exporter ?

Steps to Reproduce:

[Step-by-step instructions on how to reproduce the issue, including any specific settings or configurations]

Version:

[Insert the version number of the software]

Logs:

[If applicable, include any relevant log files or error messages]

Expected Result:

[What the user expected to see or happen before the issue occurred]

Actual Result:

[What actually happened when the user encountered the issue]

Additional Information:

[Include any additional information that could be helpful to diagnose the issue, such as browser or device information]

Ivan_Groenewold · November 15, 2023, 5:33pm

Hi, I haven’t tested this myself but here is an example of the format you should be using:

github.com

prometheus/exporter-toolkit/blob/master/docs/web-configuration.md

# Web configuration

Exporters and services instrumented with the Exporter Toolkit share the same
web configuration file format. This is *experimental* and might change in the
future.

To specify which web configuration file to load, use the `--web.config.file` flag.

The file is written in [YAML format](https://en.wikipedia.org/wiki/YAML),
defined by the scheme described below.
Brackets indicate that a parameter is optional. For non-list parameters the
value is set to the specified default.

The file is read upon every http request, such as any change in the
configuration, so the certificates are picked up immediately.

Generic placeholders are defined as follows:

* `<boolean>`: a boolean that can take the values `true` or `false`
* `<filename>`: a valid path in the current working directory

This file has been truncated. show original

Let me know how that goes

Topic		Replies	Views
PMM2 Custom password for mysqld exporter PMM 2.x	9	1805	February 8, 2021
PMM Graph breaks and MySQL Export is weird PMM 1.x	4	918	April 14, 2019
Secure exporter endpoint using web.config Percona Monitoring and Management (PMM) mysql , postgres , new-release	2	540	February 10, 2023
What mysqld_exporter is included in pmm2? PMM 2.x	3	608	October 12, 2023
PMM2 - Client Configuration issue - Connection check failed Percona XtraBackup mysql	3	1423	August 17, 2020