PostgreSQL and Memcached in LAMP
-
I have a client that built a custom web app, I think it won't be a problem to run it on the LAMP container but the client is asking for PostgreSQL & Memcached, both don't seem to be enabled on the current LAMP.
This is the client requirement :
Apache2.4. proxied by Nginx 1.14+ (ssl, static resources);
Nginx shall be compiled with X-Accel, http2, ssl at a minimum
Database server: PostgresSQL 11 with contrib packages
PHP 7.3+ (fpm or fastcgi if multiple sites are hosted on the same server, dso (mod-php) otherwise )
Serverside extra-security will be a plus (eg: Suhosin for PHP, apache security modules)I think the current LAMP container already provide all of this but I need to know if it's possible to also provide PostgreSQl and Memcached, any help is much appreciated.
-
-
here is another piece : https://git.cloudron.io/cloudron/php7.3-postgres-app/
Combined with this tutorial https://cloudron.io/documentation/guides/multiple-databases-lamp/ there is everything to install this custom app to one's cloudron -
@girish by the way, is there some kind of phpmyadmin built in this image to handle PostgreSQL from a web interface ?
the agency my non profit client hired is asking me for this :
How can the PostgreSQL database can be managed? eg phpPgAdmin would be a web based sollution (phpPgAdmin needs to be added to the container as well) or via a SSH tunnel (can I connect to the container using SSH?) ? Then please confirm that PostgreSQL extensions: btree_gist, hstore, pg_trgm, plpgsql, unaccent can be installed. ----
Regarding memcache :
Regardind memcached server and the php-memcached extension, the installation can be done in one RUN line inside the container dockerfile.
-
@rmdes I suggested adminer.org here as an omnipurpose interface that works with more DB types:
-
Would be great to add this http://phppgadmin.sourceforge.net/doku.php?id=about to the current LAMP PostgreSQL app, so that it's easier to manage databases inside this app.