Problem with MySQL SSL connection

[drupaladmin]

Hi Releem Team

I recently have activated SSL for my MariaDB clients. I´ve succesfuly connect all my db users except Reléemelos agent

Removed the server from the web Dashboard and try to reinstal the agent.

Here are the results:

% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 21341 100 21341 0 0 121k 0 --:--:-- --:--:-- --:--:-- 121k

• Installing dependences...

• Downloading Releem Agent, architecture x86_64...
  % Total % Received % Xferd Average Speed Time Time Time Current
  Dload Upload Total Spent Left Speed
  100 21673 100 21673 0 0 169k 0 --:--:-- --:--:-- --:--:-- 169k
  % Total % Received % Xferd Average Speed Time Time Time Current
  Dload Upload Total Spent Left Speed
  100 19.9M 100 19.9M 0 0 21.5M 0 --:--:-- --:--:-- --:--:-- 21.4M

• Configure the application...

• Detected service name for appling config

• Configure catalog for copy recommend config

• The /etc/mysql/my.cnf file is used for automatic Releem settings.

• Adding directive includedir to the MySQL configuration /etc/mysql/my.cnf.

• Configure MySQL user for collect data

• Using MySQL root user

Connect to MySQL - successful

Created new user releem

Connecting to MySQL with user releem - successfull

• Configure mysql memory limit

• Saving variables to Releem Agent configuration

• Adding API key to the Releem Agent configuration: /opt/releem/releem.conf
• Adding Releem Configuration Directory /opt/releem/conf to Releem Agent configuration: /opt/releem/releem.conf
• Adding user and password mysql to the Releem Agent configuration: /opt/releem/releem.conf
• Adding Memory Limit to the Releem Agent configuration: /opt/releem/releem.conf
• Adding MySQL restart command to the Releem Agent configuration: /opt/releem/releem.conf
• Adding MySQL include directory to the Releem Agent configuration /opt/releem/releem.conf.
• Adding autodetected hostname to the Releem Agent configuration: /opt/releem/releem.conf

• Configure crontab...

• Executing Releem Agent for first time...
  INFO : [Main] - 2024/05/28 22:28:22 main.go:85: Starting releem-agent of version is 1.16.0
  INFO : [Main] - 2024/05/28 22:28:22 config.go:46: Loading config /opt/releem/releem.conf
  INFO : [Main] - 2024/05/28 22:28:22 main.go:155: InstanceType is Local
  ERROR : [Main] - 2024/05/28 22:28:22 main.go:179: GOT ERROR Connection failed Error 1045 (28000): Access denied for user 'releem'@'127.0.0.1' (using password: YES)
  INFO : [Worker] - 2024/05/28 22:28:22 runner.go:73: * Collecting metrics to recommend a config...
  ERROR : [DbConf] - 2024/05/28 22:28:22 dbConf.go:39: Error 1045 (28000): Access denied for user 'releem'@'127.0.0.1' (using password: YES)
  ERROR : [DbInfo] - 2024/05/28 22:28:22 dbInfo.go:44: Error 1045 (28000): Access denied for user 'releem'@'127.0.0.1' (using password: YES)
  ERROR : [DbMetricsBase] - 2024/05/28 22:28:22 dbMetricsBase.go:43: Error 1045 (28000): Access denied for user 'releem'@'127.0.0.1' (using password: YES)
  ERROR : [Worker] - 2024/05/28 22:28:22 runner.go:254: Problem getting metrics from gatherer
  INFO : [Main] - 2024/05/28 22:28:22 main.go:85: Starting releem-agent of version is 1.16.0
  INFO : [Main] - 2024/05/28 22:28:22 config.go:46: Loading config /opt/releem/releem.conf
  INFO : [Main] - 2024/05/28 22:28:22 main.go:155: InstanceType is Local
  ERROR : [Main] - 2024/05/28 22:28:22 main.go:179: GOT ERROR Connection failed Error 1045 (28000): Access denied for user 'releem'@'127.0.0.1' (using password: YES)
  ERROR : [DbConf] - 2024/05/28 22:28:23 dbConf.go:39: Error 1045 (28000): Access denied for user 'releem'@'127.0.0.1' (using password: YES)
  ERROR : [DbInfo] - 2024/05/28 22:28:23 dbInfo.go:44: Error 1045 (28000): Access denied for user 'releem'@'127.0.0.1' (using password: YES)
  ERROR : [DbMetricsBase] - 2024/05/28 22:28:23 dbMetricsBase.go:43: Error 1045 (28000): Access denied for user 'releem'@'127.0.0.1' (using password: YES)
  ERROR : [Worker] - 2024/05/28 22:28:23 runner.go:254: Problem getting metrics from gatherer
  INFO : [Worker] - 2024/05/28 22:28:25 runner.go:51: Exiting

• Installing and starting Releem Agent service to collect metrics..

Installing Releem Agent - successful

Restarting Releem Agent - successful

• Enabling Performance schema and SlowLog to collect metrics...

• Performance schema and SlowLog are enabled for metrics collection.

• Releem Agent is successfully installed.

• To view Releem recommendations and MySQL metrics, visit https://app.releem.com/dashboard

Thanks in advance for the answers

[drupaladmin]

We’ve added SSL support.

Please reinstall Releem Agent and add this env variable to the command RELEEM_MYSQL_SSL_MODE=true