Database structure not deploying after setting up portainer and traefik

[halindra]

Hello,

I had the database working on my digitalocean droplet. Then, I followed the tutorial to set up portainer and traefik Using Custom Domains and SSL with Let's Encrypt and Traefik.

Now after deploying it again, the database structure is gone. I tried to dump the db_save.sql file that I previously backed up to the db_init folder but the database structure still won’t rebuild. Does it have something to do with the new docker-compose.yml?

I did face some issues with port allocation while setting up traefik and ended up removing local containers and restarting docker. But, I doubt it has anything to do with this.

[George]

A very common issue is that you haven’t cleared the port as stated in:

Using Custom Domains and SSL with Let's Encrypt and Traefik

When you deploy your site you want it to be accessible under your own domain name and also secured with certificate, so that you see the lock icon in your browser and the site is accessible with HTTPS In this Wappler update, we are introducing a new way to handle custom domains and automatically generate free SSL certificates to secure them. All that thanks to two new services: Traefik for easy managing your site and services redirection, working together with Let’s Encrypt for issuing free s…

So eventually you site is not starting up because of conflict with Traefik.

[halindra]

Hey George,

yeah I read that and solved the port issues, although I had to go a bit further and remove my containers because killing the processes did not free the port somehow (I spent hours trying many ways from all over).

I was able to fix the db issue by conecting to the db and then running the db_save.sql directly in SequelAce (didn’t know this was possible, still learning).