Unable to delete user with stalwart cli and postgres

[D3an1el]

Hi i have an issue with deleting users with stalwart

i use the command:

./stalwart-cli -u https://127.0.0.1:8090 database delete test

it authenticates with oauth and the following output happens

stalwart cli output= Request Failed: {"type":"about:blank","status":404,"title":"Not found","detail":"Account not found."}

I have added the log level trace output:
stalwart log "trace"

DEBUG session{instance="jmap" protocol=Jmap remote.ip="" remote.port=8553}: jmap::api::http: event="request" uri="/.well-known/oauth-authorization-server"
DEBUG session{instance="jmap" protocol=Jmap remote.ip="" remote.port=31913}: jmap::api::http: event="request" uri="/auth/device"
DEBUG session{instance="jmap" protocol=Jmap remote.ip="" remote.port=51996}: jmap::api::http: event="request" uri="/auth"
DEBUG session{instance="jmap" protocol=Jmap remote.ip="" remote.port=51996}: jmap::api::http: event="request" uri="/favicon.ico"
DEBUG session{instance="jmap" protocol=Jmap remote.ip="" remote.port=51996}: jmap::api::http: event="request" uri="/auth"
DEBUG session{instance="jmap" protocol=Jmap remote.ip="" remote.port=43822}: jmap::api::http: event="request" uri="/auth/token"
DEBUG session{instance="jmap" protocol=Jmap remote.ip="" remote.port=13111}: jmap::api::http: event="request" uri="/admin/account/delete/test"

also added the postgres queries if that helps:

[directory."postgres".query]
name = "SELECT name, type, secret, description, quota FROM accounts WHERE name = $1 AND active = true"
members = "SELECT member_of FROM group_members WHERE name = $1"
recipients = "SELECT name FROM emails WHERE address = $1"
emails = "SELECT address FROM emails WHERE name = $1 AND type != 'list' ORDER BY type DESC, address ASC"
verify = "SELECT address FROM emails WHERE address LIKE '%' || $1 || '%' AND type = 'primary' ORDER BY address LIMIT 5"
expand = "SELECT p.address FROM emails AS p JOIN emails AS l ON p.name = l.name WHERE p.type = 'primary' AND l.address = $1 AND l.type = 'list' ORDER BY p.address LIMIT 50"
domains = "SELECT 1 FROM emails WHERE address LIKE '%@' || $1 LIMIT 1"

[mdecimus]

Account deletion has to be done from your SQL database. Use the CLI only to delete the data stored for that account on Stalwart. If the account never logged in Stalwart then you'll get an account not found error.