loomio - helps groups make better decisions together

[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

[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

[robi]

@jimcavoli ask away, nginx is pretty straight fwd.

[girish]

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

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

[marcusquinn]

@jimcavoli