Self-host workspace invite

[xiaolecn]

What happened?

I need to invite more account to my self host work space
but cannot receive the the invite email, the account shows pending.

Distribution version

Windows x64

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

No response

Are you self-hosting?

• Yes

Relevant log output

Anything else?

No response

[affine-issue-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.}}

[forehalo]

it's truly that a lot of users fail on configuring mail system the make the workspace invitation work. we will add an option to let owner to copy invitation link directly on members panel

[yaninsanity]

I used to have such issue. But @xiaolecn Did you check you mail send box, which is still a way that you can re-forward to you co-worker to get into your work space.

Another way I suggest to practice is that:
you can go psql and check with db,
(if you are using docker, you can run docker exec -it postgres psql -U admin -d affinew <---change to as your setting)

Once you check db with your user id and workspace id, you can run

UPDATE workspace_user_permissions
SET accepted = true, status = 'Accepted'
WHERE user_id = '168a8e77-6b42-4dcc-acc0-c69e0c145a34'          <-----change u teammate user id
AND workspace_id = 'cc17ec32-d5d8-441b-92e5-2504f58b3307';   <--- change to your workspace