Cloudron Forum

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

My attempts to get a group with many members via the API seems to truncate the number of members returned at 1599 [and the 1599th member uid is truncated mid-string]. Is there a way to paginate a group or groups GET or return the full membership?

Hmm I definitely don't remember installing it with Cloudron SSO and the Cloudron SSO is not working. Is there somewhere where I can look for the settings that would have been set on install?

I am pretty sure that I installed Metabase without Cloudron authentication and access for users. However, Metabase is now showing as configured to use Cloudron credentials in my app dashboard. This is not the case though I would like to add the Cloudron authentication option...

What are the steps for configuring Metabase for this to work? Since it seems like Cloudron has native support for Metabase SSO and Metabase is managed within the Cloudron, I don't want to necessarily configure Metabase as a custom, generic external application.

Oops nm I figured out the right Wordpress login url and redirect pattern to use

I'm trying to set it up so that my Cloudron users can log into an external Wordpress instance via an App Link in Cloudron. I have the "OpenID Connect Generic" plugin installed and configured in Wordpress and I am able to login via a login link on the Wordpress itself which redirects to Cloudron login.

Ideally, I'd like for users clicking on the App Link in Cloudron to be automatically logged in and for users navigating directly to the Wordpress instance to be logged in automatically if they already have a valid session but I can't figure out how to get either to work. Is there a special URL I should use for the App Link?

fyi this seems to be a recurring issue. systemctl restart box does restore the healthcheck but i'm not sure why it's stopping