ERROR: for greenlight_db_1 Cannot start service db: driver failed programming external connectivity on endpoint greenlight_db_1

[davorb...@gmail.com]

Hey guys, I'm having troubles to start greenlight. Yesterday I've used cron task:

crontab -e 

0 22 * * * /sbin/shutdown -r +5

and today I can't start greenlight, I got 404 Not Found (nginx). This is the error I have:

I've already tried:

1. bbb-conf --restart
2. docker-compose down & docker-compose up -d
3. sudo systemctl restart nginx
4. docker-compose build --no-cache
   
5. updating to newest version of greenlight
6. docker run --rm bigbluebutton/greenlight:v2 cat ./greenlight.nginx | sudo tee /etc/bigbluebutton/nginx/greenlight.nginx
   
7. docker run --rm bigbluebutton/greenlight:v2 cat ./docker-compose.yml > docker-compose.yml
   
8. export pass=$(openssl rand -hex 8); sed -i 's/POSTGRES_PASSWORD=password/POSTGRES_PASSWORD='$pass'/g' docker-compose.yml;sed -i 's/DB_PASSWORD=password/DB_PASSWORD..........etc
9. /sbin/reboot

And I can confirm that following exists or works fine:

1. /etc/bigbluebutton/nginx/greenlight.nginx - checked
   
2. .env file is correct

I've used google, stackoverflow and this forum but I wasn't lucky fixing it by myself. Could anyone help me with this one?

Thanks mates

[Philipp Memmel]

Your screenshot says that docker can't register postgres database server because port is already blocked by a running process. Looks like you need to make sure to shutdown all running postgres services before. Is maybe an old version of greenlight already/still running? If you reboot your server standard greenlight docker-compose file makes sure greenlight is starting up again automatically. Try "docker-compose down" multiple times to shut down all processes, check if port 5432 is free and try "docker-compose up" again.

In addition to that executing your step 8 probably has reset your database password in greenlight config. If there was a working postgres database container before you now might have issues connecting to it because you changed the password. If you wanna start over from scratch, make sure, all existing docker images (including postgres images) are stop and properly removed before: Use "docker container list" and "docker images" to check.

Hope that helps.