loomio - helps groups make better decisions together

[jdaviescoates]

I contacted Loomio about this and one of their lead developers responded saying:

Hi Josepf,

Cloudron looks like a great system. It should be possible to modify Loomios Dockerfile to support it.

If you know anyone with the inclination I'm happy to support them with that. Otherwise I may get around to it in the next couple of months - I think we could do with a Cloudron host for Loomio stuff.

Kind regards,
Robert

I'll point Robert to this thread and hopefully someone will pick it up!

[nebulon]

That would be great, we are happy to help packaging.

[jdaviescoates]

@nebulon I prompted Robert to check out this thread and pointed out Loomio is currently the 5th most wanted app. He said:

Thanks for this Josef, very exciting.

I'm just totally, and completely full and can't see myself doing work on this in the near term. We're going to need to recruit someone else to help to get this done.

[yusf]

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

The people behind it:
http://enspiral.com/

Loomio (the software) is developed and run by Loomio (the coop) as far as I can tell. In-depth interview.

I’m quite interested in getting this software packaged. I could of course use the hosted version but then I can’t automatically bring my userbase with me.

[jdaviescoates]

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

Loomio (the software) is developed and run by Loomio (the coop) as far as I can tell.

It is, and Loomio is one of the Enspiral ventures, so everyone is correct

https://enspiral.com/pages/ventures

[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?

[jdaviescoates]

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

Bit of the way through packaging,

Great to hear, thanks @jimcavoli !

[girish]

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

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

[jimcavoli]

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

[girish]

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

[jdaviescoates]

any update on this @jimcavoli ? Thanks!

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

[yusf]

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

[jimcavoli]

@yusf Will do!

[jdaviescoates]

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

[jimcavoli]

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)

[marcusquinn]

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

[robi]

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

You can request a specific Cloudron to get the update sooner

[girish]

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