I’m configuring the authentication using PostgreSQL. I’ve configured the emqx query that you can see in the emqx_query.jpg image and my PostgreSQL table is the one you can see in the postgre_table.jpg image.
So my problem is that when I try to connect with a client it only connects when I use a user that has the password “public” (The users with the password rounded with red in the image), when I use a user with another passwork it does not connect.
Can you please help me find why is that happening. I have no idea what could provoke this, it doen not make any sense.
Can you dump the schema of your database? Also can you please show how you configured authentication chain? Perhaps there is some other backend in the chain that shadows Postgres.