SOLVED LAMP stack with Postgres

[makemrproper]

Hi

Any plans to create a LAMP stack with Postgres?

It would make hosting all my favorite Postgres enabled applications possible.

I guess it would make it LAPP or something.

Thanks!

[mehdi]

@makemrproper You really should try packaging them as proper Cloudron apps! It's really easy to do, and would allow other people to use them too

[girish]

@makemrproper You have to make a custom app as @mehdi suggested. Try a guide like this one - https://cloudron.io/documentation/guides/multiple-databases-lamp/ . In the addons, instead of "mysql", put in "postgresql" and you will get CLOUDRON_POSTGRESQL_* environment variables to connect to.

[makemrproper]

Hey. Thank you for responding. Okay challenge accepted.

If I ever package something generic I'll make sure to upstream the code / publish it.

[andirahmat]

@girish Hi. I've tried this as you and @mehdi suggested. But when i run "cloudron install" the result shown below :

=> Wait for health check ...................................................................................................................................................................................................................................................................................................................................................................................................................................................................

App installation error: getaddrinfo ENOTFOUND my.domain.com

In the control panel the app status "Not responding"

i've also tried "cloudron install --no-wait"
the result are the same.

In the control panel the app status "Starting"

Am I missing something?

This happened only when i use postgresql. With mysql it running normal.

[girish]

@andirahmat I think there are two separate errors:

• the ENOTFOUND is because some DNS resolution did not work on your PC/laptop where you are using the CLI tool. This is probably some temporary error. Can you try cloudron list to see if it works? If it does, you can ignore the temporary ENOTFOUND error.

• The other issue is that app is saying "Starting..." This is because the app you deployed is not responding to health checks. Is it return 200 status code for the health check route listed in the CloudronManifest.json ? You can see the logs (App -> Console -> Logs) to see what it is returning for the healthcheck route.

[girish]

I put a package at https://git.cloudron.io/cloudron/php7.3-postgres-app/ . This is a PHP 7.3 app that has postgres.