danielbrendel / hortusfox-web

Self-hosted collaborative plant management and tracking system for plant enthusiasts
https://www.hortusfox.com
MIT License
673 stars 34 forks source link

DB issues - Connection refused #135

Closed HerrTim closed 8 months ago

HerrTim commented 8 months ago

Hi, I'd love to use your solution via docker and compose file. I use Portainer and added your docker-compose.yml as config for a new stack. Edited the Volumes, changed DB ports from 3306 to 3307 and hit deploy. It deploys succesfull, but always returns Error 500: connection refused. When I restart the app container and have a look to the docker logs it always shows me an error:

`Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] Connection refused in /var/www/html/vendor/danielbrendel/asatru-php-framework/src/database.php:1198 Stack trace:

0 /var/www/html/vendor/danielbrendel/asatru-php-framework/src/database.php(1198): PDO->__construct('mysql:host=db;p...', 'root', Object(SensitiveParameterValue), Array)

1 /var/www/html/asatru(32): require_once('/var/www/html/v...')

2 {main}

thrown in /var/www/html/vendor/danielbrendel/asatru-php-framework/src/database.php on line 1198 ERROR 1146 (42S02) at line 1: Table 'hortusfox.AppModel' doesn't exist App settings profile does not exist. Creating... App settings profile created. ERROR 1146 (42S02) at line 1: Table 'hortusfox.AppModel' doesn't exist ERROR 1146 (42S02) at line 1: Table 'hortusfox.users' doesn't exist Admin user (dummy@dummy.de) does not exist. Creating... ERROR 1146 (42S02) at line 1: Table 'hortusfox.users' doesn't exist`

I've changed the DB password, removed the db on the file system and restart the containers, same problem.

Any ideas?

Thank you!

HerrTim commented 8 months ago

Update: It works with external DB.