Self-hosted not unrestricted​

[deckerjulian]

What happened?

The Github README names: "Self-Host Begin with Docker to deploy your own feature-rich, unrestricted version of AFFiNE. Our team is diligently updating to the latest version. For more information on how to self-host AFFiNE, please refer to our documentation."

but after deploying the self-hosted Version and login I see a "Free" Label beside the Username having all restrictions like 10GB and only 3 members per Workspace. How to get the unrestricted self-hosted Version?

Distribution version

macOS x64 (Intel)

What browsers are you seeing the problem on if you're using web version?

No response

Are you self-hosting?

• [ ] Yes

Relevant log output

No response

Anything else?

No response

[affine-issue-bot[bot]]

Issue Status: 🆕 *Untriaged

*🆕 Untriaged**

The team has not yet reviewed the issue. We usually do it within one business day. Docs: https://github.com/toeverything/AFFiNE/blob/canary/docs/issue-triaging.md

^{_{This is an automatic reply by the bot.}}

[pengx17]

We will provide more options to config these settings in the future.

[StudyingLover]

When will provide more options? :sob: We deploy self-hosted version. My team is more than 10 people, but pro user only invite 10 people to a workspace.

[Macbook-Specter]

Hello, how to lift the 10GB restriction? I have self-host and limit storage.

[StudyingLover]

@Macbook-Specter https://github.com/toeverything/AFFiNE/issues/6156#issuecomment-2084366898 Maybe it useful for you. You can change storageQuota I think. (btw, I never try)

[Macbook-Specter]

@StudyingLover Thank you very much

[deckerjulian]

Hey,

for everyone wanted to change limitations on a self-hosted instance until there's an update in the future to do this with a gui:

• Enter Docker PostgreSQL Server docker exec -it affine_postgres psql -U affine
• List possible feature id's select id, feature, configs from features;
• List users with id's select * from users;
• List features assigned to users select * from user_features;
• assigne for example 'pro_plan_v1' to the user feature_id = YOUR FEATURE ID YOU WANT TO ASSIGN (get it from 'List possible feature id's') user_id = YOUR USER ID YOU WANT TO CHANGE (get it from 'List users with id's') update user_features set feature_id = 35 where user_id = 'xxxxxx-xxxx-xxxxxxx-xxxx-xxxxxxxxxxxxxx';

[deckerjulian]

For everyone need more than the pro plan limitations: It is also possible to update the feature configs to change limitations like members for e.x.

update features set configs = '{"name":"Pro","blobLimit":104857600,"storageQuota":107374182400,"historyPeriod":2592000000,"memberLimit":100,"copilotActionLimit":10}' where id = 14;

Just restart the docker container afterwards. Now the limit of the members should be 100.

[lennon101]

update features set configs = '{"name":"Pro","blobLimit":104857600,"storageQuota":107374182400,"historyPeriod":2592000000,"memberLimit":100,"copilotActionLimit":10}' where id = 14;

Thannks for this, but where do I run this command? Can you please provide a little more detail? Is there a docker compose environment variable that I can add to edit this setting? or needs to be done via the terminal only?

[deckerjulian]

update features set configs = '{"name":"Pro","blobLimit":104857600,"storageQuota":107374182400,"historyPeriod":2592000000,"memberLimit":100,"copilotActionLimit":10}' where id = 14;

Thannks for this, but where do I run this command? Can you please provide a little more detail? Is there a docker compose environment variable that I can add to edit this setting? or needs to be done via the terminal only?

Hey there, changes have to be done in the PostgreSQL Database. Access is possible with the commands mentioned above:

Enter Docker PostgreSQL Server docker exec -it affine_postgres psql -U affine List possible feature id's select id, feature, configs from features;