Admin Panel Missing
Hello
I am hosting a self-hosted version but am unable to find the admin panel UI.
ChatGPT tells me that this is the right way":
Open Postgres in the container
docker compose exec db psql -U postgres -d postgres
Give your user the required flags (replace the email)
SELECT id, email, "canImpersonate", "canAccessFullAdminPanel"
FROM core."user"
ORDER BY email;
UPDATE core."user"
SET "canImpersonate" = TRUE,
"canAccessFullAdminPanel" = TRUE
WHERE email = 'you@yourdomain.com';
but I am unsure if this or a setting / flag in .env/docker-compose.yml will see it through.
Can anybody guide?
Thank you in advance
Parvessh
7 Replies
coul you check what is send back by your /metadata getCurrentUser query in your browser?
(example)
Hello @charles Please find attached
Hello @parvesh as you can see in above screenshot your current workspace member does not have the permissions to access the admin panel
You will need to update specific user permissions in database directly
Hello @prastoin Is this the command to do it - just doubel ensuring I am doing the right thing:
ELECT id, email, "canImpersonate", "canAccessFullAdminPanel"
FROM core."user"
ORDER BY email;
UPDATE core."user"
SET "canImpersonate" = TRUE,
"canAccessFullAdminPanel" = TRUE
WHERE email = 'you@yourdomain.com';
and will it update for all workspaces or do I need to change it for specific workspaces?
It will update for all workspaces
OK thank you!