Cloudron Forum

In documentation it says: "The nginx configuration, provided with the base image, can be used by adding an application specific config".
In my understanding it seems that all i have to do to add my custom config is:

FROM cloudron/base:2.0.0

CLOUDRON related stuff eg WORKDIR

ADD nginx-custom.conf /etc/nginx/sites-enabled/nginx-custom.conf

OTHER CUSTOM STUFF required by my app

Am I wrong? It will work like that? Will cloudron forward ports to my container port 8000 if

server {
  listen 8000;

  root /app/code/dist;

  location /api/v1/ {
    proxy_pass http://127.0.0.1:8001;
    proxy_http_version 1.1;
    proxy_set_header Upgrade $http_upgrade;
    proxy_set_header Connection "upgrade";
    proxy_read_timeout 86400;
  }
}

will be my custom configuration?

@mehdi, you've say that you "packaged" few apps for cloudron, can you tell us one authored by you? like this one authored by @girish : https://git.cloudron.io/cloudron/wordpress-unmanaged-app/-/tree/master

The postgres custom configuration parameter is used in my app logic for database tables row-level audit purposes. As in git where we have diffs and rollback strategies for files but this time for database entries. And here: https://stackoverflow.com/questions/34476062/setting-a-configuration-parameter-for-functions-implemented-in-pl-pgsql is the perfect question and answer that reflects my needs, including the accepted answer, were found there is a way to bypass server global config and rely on defining custom parameters for a database (the "ALTER database ... SET custom.param ...." SQL command approach).

Regarding static assets delivery, there are app (my app) users (logged in members) uploaded files (not for public download), and the upload size and types (mainly videos, docs, and archives) have only a few limits. And nginx does a perfect job when handling this kind of files, especially for concurrent hits. So this would be my first approach because the app is already filled up with a lot of uploaded files. With a config in my php-app I can delegate the download hard work to php (this is already codded and optimized). The third option (minio) is a great approach but not (yet) implemented as a storage backend in my app. So I guess I will let minio for further app upgrades and rely for the moment only on local storage. p.s. could minio be added/run as an "addon" (like mysql, redis, localstorage, postgres)?

I still have one more question before spawning a playground VPS (with cloudron PaaS inside) to try to build/run/install a custom cloudron app for the need.
I've advanced in cloudron learning curve and here:
https://docs.cloudron.io/custom-apps/guide/ found this:
"The nginx configuration, provided with the base image, can be used by adding an application specific config file under /etc/nginx/sites-enabled/ when building the docker image." along with "ADD <app config file> /etc/nginx/sites-enabled/<app config file>" dockerfile line and a app-nginx.conf example (port 8000).
Is above documentation still up to date, does this means that I can add my custom nginx conf file to the image?

Hi again,
@girish , first, please accept my apologies for being ignorant or otherwise not quite ok in this relation.
You are right, my app is already developed with offloading strategy concepts (eg delegate some database load to memcached, delegate assets downloads to nginx). I think that in a serverless architecture there is no need to do that (where databases and cloud storage automatically scales based on current loads). I don't mind taking a new learning curve (regarding cloudron) if one available to provide this support.
Indeed, I can change some of my app logic to fit inside cloudron paas, and here is the state of what I need, what is provided, and what could be provided within cloudron:

• Database support: I need postgresql database and access to some postgres contrib modules (eg hstore):
  OK - cloudron provide the postgresql image/container/add-on with all (required by my app ) contrib modules;
• Database support: I need to add a postgres custom config variable to the play; usually this is done by editing postgresql.conf file and add there this var; this can't be done in cloudron postgres container directly but I think this can be done on cloudron at the database logic (eg: ALTER DATABASE db_name SET myappname.key TO 'something'; ) and if yes then everything fine regarding database; I'm pretty sure this can be done on cloudron but if one could check/confirm will be perfect.
• I need an Apache webserver and a php handler (DSO is perfect for cloudron environment):
  OK, just a quick (maybe dumb) question (and I think i have an obsession regarding this - I guess that trying to be "green" by doing/requesting optimizations is my second nature), would be possible (maybe through manifest.json) to delegate Apache .htaccess entries to vhost.conf files and then disable AllowOverride?

I need a way to efficiently deliver protected assets (eg download files that request an auth layer in front): I'm currently using nginx for that (auth by php) but this approach requires some location entries to the nginx server (app) block; Again I was thinking (because the nature of nginx that can include extra custom conf files) that this can be achieved throught manifest.json; Otherwise I have two approaches: a) let php do the entire job alone; b) use a minio server for storage; In cloudron the a) approach is OK, can be b) used (eg add a minio server to the cloudron stack)?

Dear @girish,

My full-time job is to develop web-based applications. Those applications are usually developed and then hosted in managed VPSs/metal servers. The important word here is "managed"; because all I do is to ask for a hosting configuration and then this is pushed by a sysadmin just as requested, I don't care how they do it.

So, a webserver (apache) + a php handler (let it be DSO as long as apache is running only my app, but normally php FPM should be the new default) + a postgres database with just a small extra configuration (one variable inside the postgresql.conf) + a NGINX server in front of apache (also with few custom location directives) + a memcached server, is all I need.

I already suppose that all of the aforementioned server software are updated to maintained versions, perfectly tuned for performance and security (A+ on SSL, mod_security, database config for SSD usage, etc., you name it). And of course, just if i ever need to host a damn simple WordPress presentation site or maybe opensource e-commerce, a varnish server shall be added to the stack

Are those requirements intimidating?
Shall be a customer private data be hosted on an unmanaged server or hosting solution?
Could the above plan be implemented using containers? Of course, I have used this approach in the past (inside my computer, now cloud VMs are cheaper and even free to bother with).
Could the above plan be implemented on cloudron containers? This is where you have to answer.

I won't be bothering you anymore with this topic, if the answer is yes (and by yes I suppose everything in place - for me just connection details for S/FTP/S + logs + database will suffice).

Hi there,
I always used VPSs/standard hosting logic to host my custom web applications. In a standard hosting server it's easy to create the required stack: eg: nginx server block that listen to 443/80 - has a proxy location for apache (8080), a "static" location for static files, a "protected" location for protected static files (X-ACCEL), etc, (eg a proxy locations for nodejs apps);
On the same host, postgresql database (including contrib extensions), php-fpm (including extensions) and memcahed also exists, I can fine tune any of this software (eg add custom locations to nginx server block, add custom parameters to postgresql for SSD/HDD optimizations purpose or just to be available at the runtime for api access, i can fine tune php for security or optimizations, etc)

Now, if I want to host this web app using the cloudron stack logic, where shall I start? I know that cloudron seems to be an advanced docker-containers orchestration tool, so following a docker rule i think i shall create multiple containers, eg: one for php-fpm, one for apache, one for postgresql, one for memcached ... what about nginx? What if I need to fine tune nginx, php-fpm and postgresql?

I know there is documentation regarding custom apps but i have to start from scratch so a starting point (and logic behind), maybe some real advanced tutorials will help a lot.

I know how Linux and virtualization is working, i think i know what is the logic behind containerized solutions, but no experience with docker (except concept and basics of how a container is build using a docker file) ... and no experience at all in using cloudron to build a container/containers that fulfill my hosting needs.

Thank You!

"The postgresql addon whitelists the hstore and pg_trgm extensions to be installable by the database owner." - https://cloudron.io/documentation/custom-apps/addons/#localstorage.
Both hstore and pg_trgm are part of postgresql contrib, why other contrib extensions can't be used (btree_gist and unaccent are two more extension that I need to install )?

How a postgresql database can be managed via a GUI (eg in a web browser using phpPgAdmin - or using PgAdmin via a ssh tunnel connection )?

HI, I need to host a custom PHP app that is using memcache for query caching, so both memcached and php-memcached extension shall be available inside the container. Is this possible?