Auth0 is not looking in the custom database if user was not found in the Username-Password-Authentication

Hi !

We have a WordPress site with Login by Auth0 plugin, with user migration enabled.

A custom database is setup to connect to the WordPress database and the Try login works perfectly.

  • A user exists in WordPress database
  • When the user tries to log via Universal Login, Auth0 does not yet find this user in Username-Password-Authentication database
  • Auth0 should then check in the custom database to see if the user can be authenticated there…

But Auth0 does not check in the custom database. We can see in the Auth0 log that the authentication failed with Username-Password-Authentication, but the custom database is never queried.

The custom database connection is enabled in the Auth0 application: Annotation on 2024-09-26 at 14-35-34.png - Droplr

The Auth0 application is seen as enabled in the custom database connection / applications: Annotation on 2024-09-26 at 14-36-35.png - Droplr

The organisation specified in the Universal Login has the custom database connection activated: Annotation on 2024-09-26 at 14-37-59.png - Droplr

What are we missing ?

Thanks!!!

Did many other tests and tried many things. I can’t get 2 connections to work.

If I only enable the Username-Password-Authentication connection, a user that is present in Auth0 will be able to log in.

If I only enable the custom database connection, a user that is present in Wordpress will be able to log in.

But If I enable both connection in the Application, only the first connection will work, never the other.

My understanding was that, when 2 connection are enabled for an application, Universal Login checks to see if the user is available in the first connection, and if not, will try with the second connection.

What am I missing?

Thanks for your help!