drupaladmin
commented
3 months ago We’ve added SSL support.
Please reinstall Releem Agent and add this env variable to the command RELEEM_MYSQL_SSL_MODE=true
Closed drupaladmin closed 2 months ago
drupaladmin
commented
3 months ago We’ve added SSL support.
Please reinstall Releem Agent and add this env variable to the command RELEEM_MYSQL_SSL_MODE=true
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
releemConnecting to MySQL with user
releem- successfullConfigure 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