Dear Team,
if i change the default passwords in the .env File at the installtion, the Crontab Container is not working.
In /var/log/cron.log i have an Error user docker access denied to mysql password yes.
it looks like the cron container does not fetch the credentials from the .env file.
Hello,
Setting the MySQL password in the .env file is only possible before the initial docker-compose run (before the MySQL container is built).
If you want to change it afterward, you need to do so manually inside the MySQL container.
After that, please check that the values pulled into the eramba and cron containers match what you have set in the .env file.
Hello,
i edited the file before these lines:
docker compose -f docker-compose.simple-install.yml down
docker compose -f docker-compose.simple-install.yml up -d
as shown in the installtionguide.
Hi,
It seems you already completed the compose step earlier, since you mentioned you ran the down command first. This is what Sam was referring to. Because the instance was already composed, you will need to change the password directly in the MySQL container.
Hi,
i am sure that is edited the .env file before the first docker-compose, but any way .. i started again completly.
[root@LAB-DH01 docker]# git clone https://github.com/eramba/docker
Klone nach 'docker'...
remote: Enumerating objects: 545, done.
remote: Counting objects: 100% (152/152), done.
remote: Compressing objects: 100% (32/32), done.
remote: Total 545 (delta 137), reused 125 (delta 120), pack-reused 393 (from 3)
Empfange Objekte: 100% (545/545), 178.18 KiB | 4.05 MiB/s, fertig.
Löse Unterschiede auf: 100% (260/260), fertig.
[root@LAB-DH01 docker]# mv docker eramba
[root@LAB-DH01 docker]# cd eramba/
[root@LAB-DH01 eramba]# nano .env
[root@LAB-DH01 eramba]# nano docker-compose.simple-install.yml
[root@LAB-DH01 eramba]# curl https://support-v3.eramba.org/ping.html
Success![root@LAB-DH01 edocker compose -f docker-compose.simple-install.yml downyml down
WARN[0000] The "fV" variable is not set. Defaulting to a blank string.
WARN[0000] The "fV" variable is not set. Defaulting to a blank string.
WARN[0000] The "fV" variable is not set. Defaulting to a blank string.
WARN[0000] The "fV" variable is not set. Defaulting to a blank string.
[root@LAB-DH01 eramba]# docker compose -f docker-compose.simple-install.yml up -d
WARN[0000] The "fV" variable is not set. Defaulting to a blank string.
WARN[0000] The "fV" variable is not set. Defaulting to a blank string.
WARN[0000] The "fV" variable is not set. Defaulting to a blank string.
WARN[0000] The "fV" variable is not set. Defaulting to a blank string.
[+] up 72/72
✔ Image mysql:8.4.3-oracle Pulled 30.5s
✔ Image ghcr.io/eramba/eramba:latest Pulled 38.2s
✔ Image redis:7.4.2-alpine Pulled 27.1s
✔ Network eramba_default Created 0.1s
✔ Volume eramba_data Created 0.0s
✔ Volume eramba_app Created 0.0s
✔ Volume eramba_logs Created 0.0s
✔ Volume eramba_db-data Created 0.0s
✔ Container eramba-redis Created 0.3s
✔ Container eramba-mysql Created 0.3s
✔ Container eramba Created 6.4s
✔ Container eramba-cron Created 0.0s
[root@LAB-DH01 eramba]#
and again cron is not running as it should:
And on the cron container i have in cron.log the following error:
Caused by: [PDOException] SQLSTATE[HY000] [1045] Access denied for user 'docker'@'172.27.0.5' (using password: YES) in /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Database/Driver.php on line 190
Stack Trace:
- CORE/src/Database/Driver.php:190
- CORE/src/Core/Retry/CommandRetry.php:71
- CORE/src/Database/Driver.php:199
- CORE/src/Database/Driver/Mysql.php:158
- CORE/src/Database/Driver.php:251
- CORE/src/Database/Driver.php:394
Did you also remove the volumes? In any case, reach out to us at support@eramba.org, and we can look into this in more depth there.
Yes, I deleted everything, even the images.