EbenezerIbiza
On how to host TwentyCRM on Debian VPS using Docker compose and external PostgreSQL
Hello @charles
Thank you for your response! And thank you so much for making this awesome software!
1: For using external postgresql, does this mean that I then only need to supply the postgres url in .env and the remaining postgres vars should not be set at all?
2: How to migrate from the internal postgres to the external one?
Would the following work?
First, upgrade twentycrm with the internal docker postgres; then do a pg_dump inside the db container.
Then load the pg_dump on the external postgres.
Would this work?
Actually, I guess I might be missing a way to get the users/roles out of the internal postgres. How to do?
3: When this is all working, I just remove the db container from the docker-compose.yml?
10 replies
Bug - Issue with Companies and People Views
@Prastoin great to hear!
I hope someone knows how to host twenty in docker: https://discord.com/channels/1130383047699738754/1338567830903197828
8 replies
Bug - Issue with Companies and People Views
Hello. Yes, I have experienced this also. Random fails and also those empty lists. I thought I had made some mistake in my setup (https://discord.com/channels/1130383047699738754/1338567830903197828) but since you are experiencing this as well, it seems it is a bug.
8 replies
On how to host TwentyCRM on Debian VPS using Docker compose and external PostgreSQL
Tuning
Another thing I have been wondering:
The docs calls for a VPS of at least 2 GB RAM. To me, this seems like a huge amount of RAM. Is all of this really consumed by twenty? Or is it something that can be tuned to consume less? I mean, I will be one or max two concurrent users on this app.
10 replies
On how to host TwentyCRM on Debian VPS using Docker compose and external PostgreSQL
Backup issues:
Am I right in that the only thing I need to backup from twenty is the postgresql database as well as the docker-compose.yml and .env file?
Will I then be able to re-create everything on another host if need be?
If so, what are the steps to get everything up and running agian on a different host while loading the backup?
10 replies
On how to host TwentyCRM on Debian VPS using Docker compose and external PostgreSQL
Continuation of postgres issue:
When I eventually succeed in making twenty utilize my external postgresql server, I guess I will have to tell it not to start the containers with its own postgres in it (and perhaps more stuff needs to be disabled - I see there is mentioning of Patroni in the docker logs).
How do I disable/remove such conatiner?
Do I just edit the docker-compose.yml file directly? I think this might not be the way to go as I fear this is overwritten next time I want to update/upgrade twenty?
Firewall issues
I have an external nginx running as ingress on the docker host.
While this works with nginx being reverse proxy for twenty and letsencrypt certs set up using certbot, I notice that the direct docker port for twenty (tcp/3000) is reachable from the outside. This is not supposed to happen.
I have a firewall script that loads on bootup that sets the following rules:
* INPUT policy DROP
* Allow already established TCP connections
* Allow loopback
* Allow ICMP Ping
* Allow whitelisted ssh connections
* Allow tcp port 80 and 443
* Allow a few udp ports
* Drop the rest
But then it seems docker has added a whole bunch of rules to FORWARD, OUTPUT chains as well as a few DOCKER-specific chains as well. I guess this is what causes the issues.
(full iptables -L -v -n output here: https://paste.yt/p26954.html )
How to go about hardening twenty for production run on internet to block off requests not going through nginx/ingress?
10 replies