nlu
nlu2mo ago

No root login after update (user not active)

Selfhosted Zitadel with docker compose and an external PostgreSQL DB here. I updated from version 3.3.0 to 3.4.0 and then to 3.4.2, When I try to login to zitadel via the console with the root user, using the format "root@zitadel.{ourdomain}" I get an error message before even entering the password, stating
Benutzer ist nicht aktiv (EVENT-Zws3s) (user is not active)
Other users can log in as usual. What can I do to restore root access? I cannot confidently say that this is a bug, as I did not try to login just before the update.
11 Replies
Ask Inkeep
Ask Inkeep2mo ago
Hi @nlu, I'm an AI assistant for ZITADEL. While a team member reviews this question, I'll see if I can find relevant sources for your question. Answer I wasn't able to find a direct answer about root user deactivation after version updates in the available sources. However, I found some relevant information about database access and login issues: 1. How to Access the PostgreSQL Database Behind Your ZITADEL Helm Deployment : This provides guidance on accessing the PostgreSQL database directly for troubleshooting purposes. 2. [Bug]: Not possible to log in : This discusses login issues after updates, though not specifically about root user deactivation. You might want to click the "Ask for help" button to tag a team member who can provide specific guidance on reactivating the root user after a version update. Feel free to tag @Ask Inkeep with additional questions. Got it. Tagging @Rajat for additional help.
Rajat
Rajat2mo ago
hey @nlu welcome to the server and thanks for your question, have you tried reactivating your user?
nlu
nluOP2mo ago
This is the root user and I do not have an additional one or an API key that would allow for that. I have full access to the database though.
Rajat
Rajat2mo ago
does it still works on the older 3.3.0 and 3.4.0?
nlu
nluOP2mo ago
I did not yet try to roll back to 3.3.0. I can do that later in the evening. What if? I do want to update one day. Is there a way to restore the root user by reinstalling using one of the install options?
Rajat
Rajat2mo ago
I cant think of a reason possibly tbh, if it was a test cluster, try starting again from latest imo.
nlu
nluOP2mo ago
It's a production system with some hundreds of users. Is there a simple way to reimport users from the database?
Rajat
Rajat2mo ago
ah okay,let me check with my team
nlu
nluOP4w ago
I just tried to downgrade to 3.3.0 - successfully! I can log in as root again. Now I am going to check, if I can find anything in the pertaining release notes. I have since tried to upgrade in the smallest possible steps. The error occurs on the upgrade from 3.3.4 to 3.3.5. The root user gets deactivated. I have opened a Bug for this.
Rajat
Rajat4w ago
hey @nlu thanks for opening the bug ticket, can you pls link it here?. Thanks
nlu
nluOP4w ago
GitHub
[Bug]: Upgrade from 3.3.4 to 3.3.5 leads to "user not active" on ro...
Preflight Checklist I could not find a solution in the documentation, the existing issues or discussions I have joined the ZITADEL chat Environment Self-hosted Version 3.3.4 Database PostgreSQL Dat...

Did you find this page helpful?