Directus credentials no longer working

[robi]

@igaudette I only suggested to try setting the env var to help you with your password reset from the CLI

[igaudette]

@robi I tried but this hasn't resolved my problem. Thanks for the suggestion tho.

[nebulon]

Were there any updates being made to Cloudron or the app between the working timeframe and not? At least there were no package updates from our side at that point. Last directus is from December 19.

I guess first thing would be to restore the superadmin login, just to rule out OpenID integration, but odd that both stopped working at the same time.

To run the cli tool for the user subcommand it appears that it requires the DB credentials in a specific way, so export those in the terminal first (just copy and paste them and hit enter) and then run the npx ...:

export DB_CLIENT="pg" 
export DB_HOST="$CLOUDRON_POSTGRESQL_HOST"
export DB_PORT="$CLOUDRON_POSTGRESQL_PORT"
export DB_DATABASE="$CLOUDRON_POSTGRESQL_DATABASE"
export DB_USER="$CLOUDRON_POSTGRESQL_USERNAME"
export DB_PASSWORD="$CLOUDRON_POSTGRESQL_PASSWORD"

[igaudette]

@nebulon

I've been able to change the password using CLI following your commands, however, I'm still unable to log into Directus. Still says wrong username or password.

I confirm no changes or updates have been made to Cloudron or Directus since the 20th December... and on 27th everything was still working fine.

[igaudette]

@nebulon I want to add that the problem only affects the superadmin user... my other users work great! Can we restore the OpenID integration so I can log in via Cloudron and then create a new administrator?

[nebulon]

seems like a directus issue itself then if the built-in usermanagement doesn't work. Have you tried to find something upstream or contact them?

For OpenID I am not sure I understand, what should be restored if it works great? You can probably set one of the cloudron users to be a superadmin in the app via the cli?

[igaudette]

@nebulon Okay I will check on Directus side for the connection issue.

For OpenID, for some reason I'm unable to log in with my Cloudron admin user.. when I choose "Log in via Cloudron", it says service unavailable.

I have seen in the Cloudron documentation for Directus that Cloudron users inherited automatically the administrator role.. so if I can make the Cloudron integration work, I could create a new administrator user and get my issue fixed quickly.

[nebulon]

Can you login via OpenID from other apps on the Cloudron? If that is the case, maybe something went off in directus itself, as I can't see what else would have changed in that timeframe....maybe you have a backup of that app to clone a new app instance?

[igaudette]

@nebulon Yes OpenAI works with other app.

I've been able to recover my admin account by creating a new admin account using the CLI (Thanks for the steps to follow!)

Then I realized my mistake.. in my account profile, I did set the provider to "Cloudron" instead of "Default". It's why I wasn't able to log in back into my account. I switched it back to Default with my new admin account and now I'm able to log in!

Thanks again for your support

[nebulon]

oh glad it worked out in the end.