Cloudron Forum

@jdaviescoates @LoudLemur

What would be the minimum spec for the maximum increase in performance for such a server?

I'm running it on a Hetzner CPX31 VPS with tops 30 people using NC Talk simultaneously and I think I've never seen it go beyond 70% CPU usage. Honestly I could probably scale it down to a CPX21.

What are the features that we would want to find, so that we can be cost effective?

Any VPS should do, really. It's nothing fancy, just a SFU/Turn server.

If we run several nextclouds, could we setup on HPB and then use it for all the different nextclouds?

Yes, I'm using it on four different NC instances simultaneously no problems.

GNU/Linux Debian based or is GNU/Linux Debian a requirement? For example, would an Ubuntu VPS do as well?

Debian is a requirement for this installation. But you can simply use a different install method and Ubuntu should work too.

@bvxzee I thought about packaging the HPB for cloudron but eventually decided against it because it would negate most of the benefits. Cloudron has pretty strict firewall restrictions which make the built in turn-server so unreliable to begin with. I can highly recommend this installation: https://github.com/sunweaver/nextcloud-high-performance-backend-setup

I'm using it very successfully on a separate VPS.

@girish Weirdly I didn't get a notification for this, just saw this by accident only. Unfortunately it's not dockerized, it's building from source on bare metal: https://github.com/sunweaver/nextcloud-high-performance-backend-setup/blob/main/setup-nextcloud-hpb.sh

I'm using NC Talk pretty reliably with up to 30 people simultaneously (I am running a HPB on the side though)

@mazarian Go to https://my.tld.com/#/services and increase memory if necessary and/or reboot that service

@Kubernetes I don't think it's wanted because they'd prefer to make it an add-on not as an app.

@Joseph Asked Claude to help me troubleshoot lol. Apparently this is a common PostgreSQL sequence issues in Rails applications.

I'ts generally not adviced to run things next to cloudron. I was exploring similar strategies but ended up just packaging my needs.

I believe I solved this.

1. My system was creating contacts for incoming emails
2. When trying to create conversations, it failed with: null value in column "display_id" violates not-null constraint
3. This caused all emails to be dropped

How I fixed it:

1. I checked for the sequence in PostgreSQL:

   SELECT last_value FROM conversations_display_id_seq;
   

   Got error: relation "conversations_display_id_seq" does not exist

2. I checked available sequences and found only:

   • conversation_participants_id_seq
   • conversations_id_seq

3. I created the missing sequence:

   CREATE SEQUENCE conversations_display_id_seq;
   

4. I linked it to the conversations table:

   ALTER TABLE conversations ALTER COLUMN display_id SET DEFAULT nextval('conversations_display_id_seq');
   

5. I initialized it with current data:

   SELECT setval('conversations_display_id_seq', (SELECT COALESCE(MAX(display_id), 1) FROM conversations), false);
   

6. Then I restarted my Chatwoot app to apply these changes.

7. Seems to all work now.

@andreasdueren said in Chatwoot 4.0.2 is a beta release candidate:

I'll try to add another one and see if that works.

Didn't seem to work either

@ntnsndr said in Best practices or guide for Nextcloud 5.0.4?:

On that point, I am seeing an issue: Despite being an admin account, after the update, under the Accounts preferences, for most accounts on NextCloud I am getting this message: "You do not have permissions to see the details of this account." (For some reason, the admin account and one additional user account, the most recently created one, are editable.) In particular, this means I am unable to add or remove accounts from groups, which is a major problem.

Does anyone have ideas about what could be causing this?

Yes I had the same issue. The problem is, that the other user in question needs to log in once. Otherwise they are all in some weird intermediate state. I used impersonation to do that.

@Joseph Yup I think that was it!

@Joseph It does if you didn't make an OICD user admin first.

@girish Yes I updated/resaved the inbox configuration various times. I don't really want to delete the whole inbox because then I would loose all my custom data like private comments and outwards communication. I'll try to add another one and see if that works.

@Joseph I thought @service was different and there was another one. But maybe I'm wrong.

@andreasdueren said in Elasticsearch:

@Kubernetes Recommended is occ fulltextsearch:live as per the docs

There was a cron command that ran once upon starting. @girish what was that again?

Yes you absolutely can! But you'll likely need to create a custom app: https://docs.cloudron.io/packaging/tutorial/

@Kubernetes Recommended is occ fulltextsearch:live as per the docs

@Kubernetes You need to manually start the index with occ fulltextsearch:index you might want to test the configuration with occ fulltextsearch:test first

@Kubernetes said in Elasticsearch:

It was a bit tricky to understand where to use the curl to create the indices. Best was to execute it inside of the container (IPADDRESS 127.0.0.1)

I did that in the nextcloud apps terminal since I also set up the configuration there. But yes maybe good to clarify in the docs.