Unable create users for authentication using Postgres in emqx

[Suryaobulareddy2932]

Hello,

I'm using postgres as authenicator and authorization in emqx (V5.3). When I tried to add a user by using below curl command, it was giving me bad request. For your reference, I'm attaching the request and response

Request:

curl --location 'http://localhost:18083/api/v5/authentication/password_based:postgresql/users' \
--header 'accept: application/json' \
--header 'Content-Type: application/json' \
--header 'Authorization: Basic <token>' \
--data '{
  "password": "12345678",
  "user_id": "user4"
}'

Response: code: 400

{
    "code": "BAD_REQUEST",
    "message": "User error: unsupported_operation"
}

FYI,

1. I have tried by inserting the values into db into their respective table. It is working as intended.
2. I have used above curl command by changing the authenicator id to in-built-database. It also worked for me.

But with postgresql I'm getting the above error

If anyone is aware of this issue, please help me out

Thanks

[NVerban]

I'm experiencing the same problem. Found a related issue https://github.com/emqx/emqx/issues/10963

Only built_in_databse supports user management at the moment. We'll add such information to the returned error message in the API.

https://github.com/emqx/emqx/issues/10963#issuecomment-1581460316