docker icon indicating copy to clipboard operation
docker copied to clipboard

No connection to database on fresh install via Portainer

Open Zeitverschreib opened this issue 1 year ago • 2 comments

Hello.

I have tried to install a new instance via Portainer, following this script:

https://mariushosting.com/how-to-install-friendica-on-your-synology-nas/

The installation finishes just fine and I can log into the instance. However, the cron.sh is never executed because it can't run a health check on the database:

Waiting for MySQL friendica-db initialization...

The database container shows failed connection attempts:

`2024-12-22 17:26:59 20 [Warning] Aborted connection 20 to db: 'unconnected' user: 'unauthenticated' host: '172.22.0.5' (This connection closed normally without authentication) 2024-12-22 17:26:58 6 [Warning] Aborted connection 6 to db: 'friendica20241222' user: 'friendicauser' host: '172.22.0.5' (Got an error reading communication packets) 2024-12-22 17:23:52 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'unauthenticated' host: '172.22.0.5' (This connection closed normally without authentication) Version: '11.4.4-MariaDB-ubu2404' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution

I tried this installation on a Synology DS920+ and also on a freshly installed Raspberry Pi 4. The behaviour of the containers/scripts is exactly the same on both machines.

What am I missing?

Thanks in advance.

Zeitverschreib avatar Dec 22 '24 16:12 Zeitverschreib

It seems as if the cron container is using wrong credentials. I don't know the Portainer setup but both, the app container and the cron container needs to have the same connection parameters for the database.

ne20002 avatar Jan 31 '25 10:01 ne20002

@Zeitverschreib Is the issue still unresolved?

ne20002 avatar Apr 21 '25 16:04 ne20002