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


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. App Wishlist
  3. loomio - helps groups make better decisions together

loomio - helps groups make better decisions together

Scheduled Pinned Locked Moved Solved App Wishlist
60 Posts 11 Posters 11.1k Views 17 Watching
  • 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.
  • jimcavoliJ Offline
    jimcavoliJ Offline
    jimcavoli
    App Dev
    wrote on last edited by
    #10

    Bit of the way through packaging, running up against a permission failure with PostgreSQL:

    PG::InsufficientPrivilege: ERROR:  permission denied to create extension "citext"
    HINT:  Must be superuser to create this extension.
    

    Not the first time I've hit a hard stop due to the PG extensions missing - wonder if there's a more systematic way to solve for PG extensions going forward?

    jdaviescoatesJ 1 Reply Last reply
    2
    • jimcavoliJ jimcavoli

      Bit of the way through packaging, running up against a permission failure with PostgreSQL:

      PG::InsufficientPrivilege: ERROR:  permission denied to create extension "citext"
      HINT:  Must be superuser to create this extension.
      

      Not the first time I've hit a hard stop due to the PG extensions missing - wonder if there's a more systematic way to solve for PG extensions going forward?

      jdaviescoatesJ Offline
      jdaviescoatesJ Offline
      jdaviescoates
      wrote on last edited by
      #11

      @jimcavoli said in loomio - helps groups make better decisions together:

      Bit of the way through packaging,

      Great to hear, thanks @jimcavoli !

      I use Cloudron with Gandi & Hetzner

      1 Reply Last reply
      1
      • girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #12

        @jimcavoli postgresql has this plugin whitelist, so we have to add citext to it. It's easy to do.

        1 Reply Last reply
        1
        • girishG Offline
          girishG Offline
          girish
          Staff
          wrote on last edited by
          #13

          @jimcavoli If you update the /home/yellowtent/box/src/infra_version.js to have the latest postgresql container (the hash is in https://git.cloudron.io/cloudron/box/-/commit/23c455043033b4c4a5e7739a1748a2a38c6a9457), then citext should be part of it.

          jimcavoliJ 1 Reply Last reply
          1
          • girishG girish

            @jimcavoli If you update the /home/yellowtent/box/src/infra_version.js to have the latest postgresql container (the hash is in https://git.cloudron.io/cloudron/box/-/commit/23c455043033b4c4a5e7739a1748a2a38c6a9457), then citext should be part of it.

            jimcavoliJ Offline
            jimcavoliJ Offline
            jimcavoli
            App Dev
            wrote on last edited by
            #14

            @girish Thanks! trying to figure out where to submit changes for additional extensions - unclear on that from what you've linked, but bumping the infra version got citext out of the way. This time I got smart and checked the rest of them - I believe hstore is already enabled, and plpgsql, so that just leaves pg_stat_statements - which I hadn't brought up previously, but is handy for many reasons, but also required in to get loom up.

            Full list of extensions used by loomio:

              enable_extension "citext"
              enable_extension "hstore"
              enable_extension "pg_stat_statements"
              enable_extension "plpgsql"
            
            1 Reply Last reply
            1
            • girishG Offline
              girishG Offline
              girish
              Staff
              wrote on last edited by
              #15

              @jimcavoli Thanks, I have added those extensions as well now for the coming release.

              jdaviescoatesJ 1 Reply Last reply
              3
              • girishG girish

                @jimcavoli Thanks, I have added those extensions as well now for the coming release.

                jdaviescoatesJ Offline
                jdaviescoatesJ Offline
                jdaviescoates
                wrote on last edited by
                #16

                any update on this @jimcavoli ? Thanks! 🙂

                I use Cloudron with Gandi & Hetzner

                1 Reply Last reply
                3
                • jimcavoliJ Offline
                  jimcavoliJ Offline
                  jimcavoli
                  App Dev
                  wrote on last edited by
                  #17

                  Still pending; I missed an extension in the earlier ask, but that's been merged, so hopefully this will release shortly after the next Cloudron patch version. It's at the top of my list, so as soon as I can get it working, I'll update here.

                  yusfY 1 Reply Last reply
                  5
                  • jimcavoliJ jimcavoli

                    Still pending; I missed an extension in the earlier ask, but that's been merged, so hopefully this will release shortly after the next Cloudron patch version. It's at the top of my list, so as soon as I can get it working, I'll update here.

                    yusfY Offline
                    yusfY Offline
                    yusf
                    wrote on last edited by
                    #18

                    @jimcavoli That is good news. Ping if you need testing.

                    jimcavoliJ jdaviescoatesJ 2 Replies Last reply
                    3
                    • yusfY yusf

                      @jimcavoli That is good news. Ping if you need testing.

                      jimcavoliJ Offline
                      jimcavoliJ Offline
                      jimcavoli
                      App Dev
                      wrote on last edited by
                      #19

                      @yusf Will do!

                      1 Reply Last reply
                      3
                      • yusfY yusf

                        @jimcavoli That is good news. Ping if you need testing.

                        jdaviescoatesJ Offline
                        jdaviescoatesJ Offline
                        jdaviescoates
                        wrote on last edited by
                        #20

                        @yusf said in loomio - helps groups make better decisions together:

                        @jimcavoli That is good news. Ping if you need testing.

                        It's GREAT news! 😄

                        Thanks @jimcavoli!

                        I use Cloudron with Gandi & Hetzner

                        1 Reply Last reply
                        3
                        • jimcavoliJ Offline
                          jimcavoliJ Offline
                          jimcavoli
                          App Dev
                          wrote on last edited by
                          #21

                          I believe this should run on cloudron 6 without issue, but I'm waiting for that update to hit the machine I use to make sure and then we should be able to get this out. The new 2.5 update has some excellent features as well! (which I see no issues with running in this package as soon as it's ready to go)

                          1 Reply Last reply
                          4
                          • marcusquinnM Offline
                            marcusquinnM Offline
                            marcusquinn
                            wrote on last edited by
                            #22

                            Very nice, looks like a better alternative to this that I'm seeing used often for Twitter community groups: https://www.mightynetworks.com/

                            Web Design https://www.evergreen.je
                            Development https://brandlight.org
                            Life https://marcusquinn.com

                            1 Reply Last reply
                            0
                            • robiR Offline
                              robiR Offline
                              robi
                              wrote on last edited by
                              #23

                              This will be useful in at least 2-3 of my many projects.

                              You can request a specific Cloudron to get the update sooner 😉

                              Conscious tech

                              1 Reply Last reply
                              2
                              • girishG Offline
                                girishG Offline
                                girish
                                Staff
                                wrote on last edited by
                                #24

                                @jimcavoli If you want to move this along further, that postgresql extension is now enabled in 6.0

                                jimcavoliJ 1 Reply Last reply
                                2
                                • girishG girish

                                  @jimcavoli If you want to move this along further, that postgresql extension is now enabled in 6.0

                                  jimcavoliJ Offline
                                  jimcavoliJ Offline
                                  jimcavoli
                                  App Dev
                                  wrote on last edited by
                                  #25

                                  @girish Yeah, I've picked it back up and all the basics are looking good. I've got it booting up completely on my dev box. Trying to work out the websockets piece now, which is pretty important. Just banging head against nginx for the most part

                                  robiR 1 Reply Last reply
                                  2
                                  • jimcavoliJ jimcavoli

                                    @girish Yeah, I've picked it back up and all the basics are looking good. I've got it booting up completely on my dev box. Trying to work out the websockets piece now, which is pretty important. Just banging head against nginx for the most part

                                    robiR Offline
                                    robiR Offline
                                    robi
                                    wrote on last edited by
                                    #26

                                    @jimcavoli ask away, nginx is pretty straight fwd.

                                    Conscious tech

                                    1 Reply Last reply
                                    1
                                    • girishG Offline
                                      girishG Offline
                                      girish
                                      Staff
                                      wrote on last edited by
                                      #27

                                      Yeah, nginx/websocket requires this magic incantation - http://nginx.org/en/docs/http/websocket.html (if that is what is blocking you)

                                      1 Reply Last reply
                                      3
                                      • jimcavoliJ Offline
                                        jimcavoliJ Offline
                                        jimcavoli
                                        App Dev
                                        wrote on last edited by
                                        #28

                                        I had a breakthrough with the dumb websockets issue. Hooray! This one should be ready shortly. I know it's been highly requested and hotly anticipated (for me as well) so it's my top packaging to finish. At this point, after a few other tweaks, I'm fairly sure I've got this working. I'll do some final testing tonight, but I expect that I should have an initial build together by this weekend.

                                        marcusquinnM 1 Reply Last reply
                                        8
                                        • jimcavoliJ jimcavoli

                                          I had a breakthrough with the dumb websockets issue. Hooray! This one should be ready shortly. I know it's been highly requested and hotly anticipated (for me as well) so it's my top packaging to finish. At this point, after a few other tweaks, I'm fairly sure I've got this working. I'll do some final testing tonight, but I expect that I should have an initial build together by this weekend.

                                          marcusquinnM Offline
                                          marcusquinnM Offline
                                          marcusquinn
                                          wrote on last edited by
                                          #29

                                          @jimcavoli 🙌

                                          Web Design https://www.evergreen.je
                                          Development https://brandlight.org
                                          Life https://marcusquinn.com

                                          1 Reply Last reply
                                          1
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Bookmarks
                                          • Search