Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved LAMP stack with Postgres

    Support
    lamp postgresql
    4
    7
    540
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      makemrproper last edited by girish

      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 1 Reply Last reply Reply Quote 1
      • mehdi
        mehdi App Dev @makemrproper last edited by

        @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 🙂

        1 Reply Last reply Reply Quote 0
        • girish
          girish Staff last edited by

          @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.

          A 1 Reply Last reply Reply Quote 1
          • M
            makemrproper last edited by 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.

            1 Reply Last reply Reply Quote 1
            • A
              andirahmat @girish last edited by 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.

              1 Reply Last reply Reply Quote 0
              • girish
                girish Staff last edited by

                @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.

                1 Reply Last reply Reply Quote 0
                • girish
                  girish Staff last edited by

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

                  1 Reply Last reply Reply Quote 2
                  • Referenced by  E eddowding 
                  • Referenced by  jan.reinhardt jan.reinhardt 
                  • First post
                    Last post
                  Powered by NodeBB