I have setup a Connection which uses a Custom DB to check the user credentials.
I have also enabled the Requires Username flag since there are users that will use their e-mail and others their username.
My login script runs the following DML:
'SELECT ... FROM users WHERE Email = ? or UserName = ?'
I have tried the script through the Custom Database → Login screen (Try button) and it works. But when I try it through the Auth0 login page, unfortunately I get the following error message: WRONG USERNAME OR PASSWORD.
I am a bit puzzled and I honestly think there’s a bug in Auth0. It all works fine when I disable the Requires Username flag, but I can only use the e-mail and I need to use both.
Any help is very much appreciated!