Cloudron Forum

Is it possible to install plugins that serve content from the plugins folder? I've tried installing a few of the QR code related plugins and all seem to require serving up new content in the admin interface. Without changing any Apache settings (e.g. in htaccess), the plugins fail to load content with 403 errors.

Yes thanks I think this is resolved!

Thank you!

@james yes I am also not sure this app has the option to disable email configuration even presented in the UI which would make sense since there's no check in the start.sh to respect a UI pref.

If I want to persist my own outgoing email server settings within the application, what's the best way to go about doing that? I can see that start.sh is overwriting email settings every time the app restarts.

I'm not sure this was fully solved. While we have functioning websocket connections now on the instance I'm running, new drafts still retain a user's previous html card content and attachments [from other drafts]. Is anyone else seeing this behavior?

Thanks! Changing the channels domain from ws to channels helped!

Is there anything else I need to change @girish ? I can see the updated Locations tab

I'm still getting WebSocket connection to 'wss://hocuspocus.loomio.example.nyc/' failed:

Thank you!

I suspect this is related to the v2.25.0 release including a new docker-compose service and requiring a new cname entry. I'm definitely getting websocket errors in my console for failures to connect to hocuspocus.loomio.example.com

Some time fairly recently, I've started to experience the following behavior:
When I attempt to create a new Decision, the description details and html cards are pre-populated with the values from a previously created Decision. I'm currently running v2.25.2 within Cloudron. Has anyone else seen this behavior?

Ah I think I've found it. You're setting group_concat_max_len = 65536 on line 66 of database.js.
Looks like this commit: https://git.cloudron.io/cloudron/box/-/commit/94a196bfa00ff689b0862fe797d64a917111a91d

@girish Good news I was able to isolate a little more. It seems like 65536 bytes is the length at which the group_concat was actually being truncated. So setting group_concat_max_len = 65536 wasn't doing anything. But if I set that to a sufficiently higher value, e.g. group_concat_max_len = 4294967295, we can get the full group membership within mysql. I have not yet been able to get the full response from the API though.

mysql> SHOW VARIABLES LIKE '%group_concat%';+----------------------+------------+
| Variable_name        | Value      |
+----------------------+------------+
| group_concat_max_len | 4294967295 |
+----------------------+------------+
1 row in set (0.01 sec)

mysql> SELECT length(GROUP_CONCAT(groupMembers.userId))-length(replace(GROUP_CONCAT(groupMembers.userId),',','')) AS userIds FROM userGroups LEFT OUTER JOIN groupMembers ON userGroups.id = groupMembers.groupId WHERE userGroups.id = 'gid-4802e498-4b29-4eec-bcee-57186b126aa4';
+---------+
| userIds |
+---------+
|    6047 |
+---------+
1 row in set (0.01 sec)

Hmm nm I looked at max_allowed_packet and presumably the default of 64MB is not constraining the response.

Unfortunately the response is the same so far after updating the config file and restarting mysql on the server. I am going to try set max_allowed_packet to a larger value as well.

Yes it's truncated with a simple curl as well. What's weird is that the truncation also occurs within the response for the specific group at the /groups endpoint and not just the groups/:groupId endpoint.

the deletion dialog has the understated member count:

This group still has 1599 member(s). Are you sure this group is not used?

+----------+
| count(*) |
+----------+
| 6048 |
+----------+

I was wrong. The UI also has truncated group membership. Here's the console:

Yes both /api/v1/groups/:groupId and /api/v1/groups/ produce the same behavior.
I don't see any errors in the NGINX log

here's a relevant line for a GET

[no timestamp]  - - [06/Oct/2024:23:59:19 +0000] "GET /api/v1/groups/gid-4802e498-4b29-4eec-bcee-57186b126aa4 HTTP/1.1" 200 36890 "-" "axios/1.7.4"

And the UI does show all group members