Custom database connection not working

Hi Team,

We are experiencing a weird behavior when migrate the users with custom database. We have created the Staging db connection, that connects to our postgresql database url.

When we selected Try for Login and Get User script, they are both working

Selection_423 Selection_422

However, when we select Try Connection and enter the exact same email/password, it pops out the Wrong email and password error.

To add to this, we have 2 Database connection, one for production and one for staging that only differs in database_url configuration. The one on production worked fine. Will it affect staging connection?

Any idea why this happened?

It’s confusing, we have setup a new user to test and it worked for that new user, but still failing for that previous user. We didn’t change anything to the code.

Do you have any information in the tenant logs?