Payload authentication to MongoDB always fails

[Angh0r]

I'm not sure why, but I can't start dev.
Each time there is an error that DB Authentication failed.

I've checked the connection string twice. Compass instance on the same PC works like a charm. Payload doesn't.

My MongoDB server is a container on my Synology, but it shouldn't matter... As mentioned above, Compass has no issues with the credentials.,

Error:
ERROR: Error: cannot connect to MongoDB. Details: Authentication failed.
err: {
"type": "MongoServerError",
"message": "Authentication failed.",
"stack":
MongoServerError: Authentication failed.
at Connection.sendCommand (D:\Web\Private\tda-payload\node_modules.pnpm\mongodb@6.16.0_@aws-sdk+credential-providers@3.913.0\node_modules\mongodb\lib\cmap\connection.js:299:27)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async Connection.command (D:\Web\Private\tda-payload\node_modules.pnpm\mongodb@6.16.0_@aws-sdk+credential-providers@3.913.0\node_modules\mongodb\lib\cmap\connection.js:327:26)
at async executeScram (D:\Web\Private\tda-payload\node_modules.pnpm\mongodb@6.16.0_@aws-sdk+credential-providers@3.913.0\node_modules\mongodb\lib\cmap\auth\scram.js:79:22)
at async ScramSHA256.auth (D:\Web\Private\tda-payload\node_modules.pnpm\mongodb@6.16.0_@aws-sdk+credential-providers@3.913.0\node_modules\mongodb\lib\cmap\auth\scram.js:39:16)
at async performInitialHandshake (D:\Web\Private\tda-payload\node_modules.pnpm\mongodb@6.16.0_@aws-sdk+credential-providers@3.913.0\node_modules\mongodb\lib\cmap\connect.js:104:13)
at async connect (D:\Web\Private\tda-payload\node_modules.pnpm\mongodb@6.16.0_@aws-sdk+credential-providers@3.913.0\node_modules\mongodb\lib\cmap\connect.js:24:9)
"errorLabelSet": {},
"errorResponse": {
"ok": 0,
"errmsg": "Authentication failed.",
"code": 18,
"codeName": "AuthenticationFailed"
},
"ok": 0,
"code": 18,
"codeName": "AuthenticationFailed",
"connectionGeneration": 0
}

[Angh0r]

Found that the problem is quite well known on the mongoose forums. Its root is in fact that basic configuration uses admin collection as authentication source, so DATABASE_URI should have that info added at the end: ?authSource=admin.
Now everything works like a charm