NoSQLBooster for MongoDB (formerly MongoBooster)
New Topic
NoSQLBooster for MongoDB (formerly MongoBooster)TopicProblem
Properties
Category Uncategorized
Tags authSource, SCRAM-SHA-1, MongoDB 3.6

NoSQLBooster 11.1.6 loses explicit SCRAM-SHA-1 mechanism for MongoDB 3.6 connection

Yaroslav V. shared this problem 17 hours ago
In Progress

Environment

  • NoSQLBooster: 11.1.6
  • MongoDB Server: 3.6

Problem

MongoDB 3.6 does not support SCRAM-SHA-256.

When I import a connection URI with an explicitly specified authentication mechanism: 

mongodb://user:password@host:27017/?authSource=admin&authMechanism=SCRAM-SHA-1
the Test Connection succeeds.

However, after saving the connection and connecting using the saved connection profile, NoSQLBooster attempts to authenticate using: 

SCRAM-SHA-256
and MongoDB returns: 

{
  "name" : "MongoServerError",
  "message" : "Unsupported mechanism SCRAM-SHA-256",
  "supportedMechanisms" : [
    "MONGODB-CR",
    "MONGODB-X509",
    "SCRAM-SHA-1"
  ],
  ...
}
Steps to reproduce

  1. Open NoSQLBooster 11.1.6.
  2. Import a MongoDB URI containing:

authMechanism=SCRAM-SHA-1
  1. Run Test Connection.
  2. Connection succeeds.
  3. Save the connection.
  4. Connect using the saved connection.
  5. Authentication fails because SCRAM-SHA-256 is used.

Expected behavior

The saved connection should preserve: 

authMechanism=SCRAM-SHA-1
or the driver should correctly negotiate SCRAM-SHA-1 with a MongoDB 3.6 server.

Actual behavior

After the connection is saved, NoSQLBooster initiates authentication using SCRAM-SHA-256.

1 The same problem 0  

Replies (1)

photo
1
qinghai (support@nosqlbooster.com) ● 16 hours ago

We have confirmed that this problem
is resolved by removing authMechanism=SCRAM-SHA-1 from the connection URI. NoSQLBooster's Basic (Username/Password) authentication mode supports SCRAM-SHA-256, SCRAM-SHA-1 and MONGODB-CR, and when the mechanism is not explicitly specified, the built-in driver negotiates it with the server automatically. Since MongoDB 3.6 only supports SCRAM-SHA-1 (SCRAM-SHA-256 was introduced in MongoDB 4.0), the driver selects SCRAM-SHA-1, so both Test Connection and the saved connection work normally with: 

mongodb://user:password@host:27017/?authSource=admin
In other words, on a MongoDB 3.6 server the authMechanism option is unnecessary - simply leave it out and no further change is required.

For your reference, starting with v11.1.4 NoSQLBooster also removes a redundant SCRAM-SHA mechanism automatically from the connection configuration and lets the driver auto-negotiate it, so this option is no longer required in current versions (v11.1.6 is the latest release).

Reply
This comment is in trash! Restore
photo
1
Yaroslav V. ● 16 hours ago

Thank you for the clarification.

However, removing authMechanism from the connection URI does not resolve the issue on my side.

I tested the connection using: 

mongodb://user:password@host:27017/?authSource=admin
without specifying authMechanism, but the connection still fails with the same error: 

Unsupported mechanism SCRAM-SHA-256

This comment is in trash! Restore
photo
1
qinghai (support@nosqlbooster.com) ● 16 hours ago

Thank you for the update, and sorry for the continuing trouble.

The behavior you describe does not match what the latest release does, so to pinpoint the cause we need to verify the exact version and connection details on your side. Could you please send us the following:

  1. The complete Test Connection report, including the version information.
    Run "Test Connection" from the Connection Editor or the Connections dialog.In the Test Connection window, click "Copy Report to Clipboard".Paste the full report in your reply unchanged. It includes the product version, OS, license and a detailed connection log, all of which are important for us.
  2. A screenshot of the Test Connection window with the "Unsupported mechanism SCRAM-SHA-256" error visible.
  3. A screenshot of Help > About, so we can confirm the exact product version and build you are running.

If possible, please also create a brand-new connection with the plain URI (no authMechanism) and include that Test Connection report as well - this helps us rule out anything left over from a previously saved connection.

Once we receive these details, we will analyze them and follow up with a concrete answer.

This comment is in trash! Restore
photo
1
Yaroslav V. ● 16 hours ago

Please find the requested information below.

1. Complete Test Connection report
 

Version: 11.1.6

OS: {"platform":"darwin","type":"Darwin","release":"27.0.0","mem":"36G"}

Brief:
Connect to 30.200.40.100 Status:Failed Duration:

Error:
MongoServerError: Unsupported mechanism SCRAM-SHA-256	 code: 2

Details:
15:03:52.018  *** Starting MongoClient.connect ***
{"uri":"mongodb://user:******@30.200.40.100:27017/admin?authSource=admin","options":{"maxPoolSize":2,"minPoolSize":1,"appName":"NoSQLBooster11_144415.91","directConnection":true}} 

15:03:52.019  Topology Opening
{"name":"topologyOpening","topologyId":5} 

15:03:52.019  Topology Description Changed
{"name":"topologyDescriptionChanged","topologyId":5,"previousDescription":{"type":"Unknown","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":0,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":0,"logicalSessionTimeoutMinutes":null},"newDescription":{"type":"Single","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":10000,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":0,"logicalSessionTimeoutMinutes":null}} 

15:03:52.019  Server Opening
{"name":"serverOpening","topologyId":5,"address":"30.200.40.100:27017"} 

15:03:52.116  Server Description Changed
{"name":"serverDescriptionChanged","topologyId":5,"address":"30.200.40.100:27017","previousDescription":{"address":"30.200.40.100:27017","type":"Unknown","hosts":[],"passives":[],"arbiters":[],"tags":{},"minWireVersion":0,"maxWireVersion":0,"roundTripTime":-1,"minRoundTripTime":0,"lastUpdateTime":1178250,"lastWriteDate":0,"error":null,"topologyVersion":null,"setName":null,"setVersion":null,"electionId":null,"logicalSessionTimeoutMinutes":null,"maxMessageSizeBytes":null,"maxWriteBatchSize":null,"maxBsonObjectSize":null,"primary":null,"me":null,"$clusterTime":null,"iscryptd":false},"newDescription":{"address":"30.200.40.100:27017","type":"RSSecondary","hosts":["mongo-rs0-mongodb-replicaset-0.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","mongo-rs0-mongodb-replicaset-1.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","mongo-rs0-mongodb-replicaset-2.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017"],"passives":[],"arbiters":[],"tags":{},"minWireVersion":0,"maxWireVersion":6,"roundTripTime":48,"minRoundTripTime":0,"lastUpdateTime":1178347,"lastWriteDate":"Wed Sep 23 2026 15:03:50 GMT+0300 (Eastern European Summer Time)","error":null,"topologyVersion":null,"setName":"rs0","setVersion":666359,"electionId":null,"logicalSessionTimeoutMinutes":30,"maxMessageSizeBytes":48000000,"maxWriteBatchSize":100000,"maxBsonObjectSize":16777216,"primary":"mongo-rs0-mongodb-replicaset-0.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","me":"mongo-rs0-mongodb-replicaset-2.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","$clusterTime":{"clusterTime":{"high":1790165030,"low":8,"unsigned":true},"signature":{"hash":"[Buffer]","keyId":{"high":1782021331,"low":2,"unsigned":false}}},"iscryptd":false}} 

15:03:52.116  Topology Description Changed
{"name":"topologyDescriptionChanged","topologyId":5,"previousDescription":{"type":"Single","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":10000,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":0,"logicalSessionTimeoutMinutes":null},"newDescription":{"type":"Single","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":10000,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":6,"logicalSessionTimeoutMinutes":30}} 

15:03:52.280  Server Description Changed
{"name":"serverDescriptionChanged","topologyId":5,"address":"30.200.40.100:27017","previousDescription":{"address":"30.200.40.100:27017","type":"RSSecondary","hosts":["mongo-rs0-mongodb-replicaset-0.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","mongo-rs0-mongodb-replicaset-1.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","mongo-rs0-mongodb-replicaset-2.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017"],"passives":[],"arbiters":[],"tags":{},"minWireVersion":0,"maxWireVersion":6,"roundTripTime":48,"minRoundTripTime":0,"lastUpdateTime":1178347,"lastWriteDate":"Wed Sep 23 2026 15:03:50 GMT+0300 (Eastern European Summer Time)","error":null,"topologyVersion":null,"setName":"rs0","setVersion":666359,"electionId":null,"logicalSessionTimeoutMinutes":30,"maxMessageSizeBytes":48000000,"maxWriteBatchSize":100000,"maxBsonObjectSize":16777216,"primary":"mongo-rs0-mongodb-replicaset-0.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","me":"mongo-rs0-mongodb-replicaset-2.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","$clusterTime":{"clusterTime":{"high":1790165030,"low":8,"unsigned":true},"signature":{"hash":"[Buffer]","keyId":{"high":1782021331,"low":2,"unsigned":false}}},"iscryptd":false},"newDescription":{"address":"30.200.40.100:27017","type":"Unknown","hosts":[],"passives":[],"arbiters":[],"tags":{},"minWireVersion":0,"maxWireVersion":0,"roundTripTime":-1,"minRoundTripTime":0,"lastUpdateTime":1178511,"lastWriteDate":0,"error":{"name":"MongoServerError","message":"Unsupported mechanism SCRAM-SHA-256","stack":"MongoServerError: Unsupported mechanism SCRAM-SHA-256\n    at Connection.sendCommand (/Applications/NoSQLBooster for MongoDB.app/Contents/Resources/app.asar/node_modules/mongodb/lib/cmap/connection.js:320:27)\n    at process.processTicksAndRejections (node:internal/process/task_queues:104:5)\n    at async Connection.command (/Applications/NoSQLBooster for MongoDB.app/Contents/Resources/app.asar/node_modules/mongodb/lib/cmap/connection.js:347:26)\n    at async executeScram (/Applications/NoSQLBooster for MongoDB.app/Contents/Resources/app.asar/node_modules/mongodb/lib/cmap/auth/scram.js:78:22)\n    at async ScramSHA256.auth (/Applications/NoSQLBooster for MongoDB.app/Contents/Resources/app.asar/node_modules/mongodb/lib/cmap/auth/scram.js:38:16)\n    at async performInitialHandshake (/Applications/NoSQLBooster for MongoDB.app/Contents/Resources/app.asar/node_modules/mongodb/lib/cmap/connect.js:110:13)\n    at async connect (/Applications/NoSQLBooster for MongoDB.app/Contents/Resources/app.asar/node_modules/mongodb/lib/cmap/connect.js:28:9)"},"topologyVersion":null,"setName":null,"setVersion":null,"electionId":null,"logicalSessionTimeoutMinutes":null,"maxMessageSizeBytes":null,"maxWriteBatchSize":null,"maxBsonObjectSize":null,"primary":null,"me":null,"$clusterTime":null,"iscryptd":false}} 

15:03:52.281  Topology Description Changed
{"name":"topologyDescriptionChanged","topologyId":5,"previousDescription":{"type":"Single","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":10000,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":6,"logicalSessionTimeoutMinutes":30},"newDescription":{"type":"Single","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":10000,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":6,"logicalSessionTimeoutMinutes":null}} 

15:03:52.282  Server Closed
{"name":"serverClosed","topologyId":5,"address":"30.200.40.100:27017"} 

15:03:52.283  Topology Closed
{"name":"topologyClosed","topologyId":5} 

15:03:52.283  *** Connect Error ***
{"errorLabelSet":{},"errorResponse":{"supportedMechanisms":["MONGODB-CR","MONGODB-X509","SCRAM-SHA-1"],"ok":0,"errmsg":"Unsupported mechanism SCRAM-SHA-256","code":2,"codeName":"BadValue","operationTime":{"$timestamp":"7688700258292858888"},"$clusterTime":{"clusterTime":{"$timestamp":"7688700258292858888"},"signature":{"hash":"zms+nSB5PMn9JyNOs95T+nKegnE=","keyId":{"high":1782021331,"low":2,"unsigned":false}}}},"supportedMechanisms":["MONGODB-CR","MONGODB-X509","SCRAM-SHA-1"],"ok":0,"code":2,"codeName":"BadValue","operationTime":{"$timestamp":"7688700258292858888"},"$clusterTime":{"clusterTime":{"$timestamp":"7688700258292858888"},"signature":{"hash":"zms+nSB5PMn9JyNOs95T+nKegnE=","keyId":{"high":1782021331,"low":2,"unsigned":false}}},"connectionGeneration":0,"name":"MongoServerError","message":"Unsupported mechanism SCRAM-SHA-256"}
2. Screenshot with the Unsupported mechanism SCRAM-SHA-256 error

de8a7ce428acb7222e811b29d97b7d1fcf86b425a44de5bcbd32950e0f494c70

3. Help > About screenshot

89546856a934381abb999e92f601e09c7a7b97a1c785c811370eecb2f3c96616


Additional Context

I also created a brand-new connection using a plain URI without explicitly specifying authMechanism.

URI format used: 

mongodb://<user>:<password>@<host>:<port>/<database>?authSource=<authDatabase>
The Test Connection report for this new connection is: 

15:22:26.646  *** Starting MongoClient.connect ***
{"uri":"mongodb://user:******@30.200.40.100:27017/admin?authSource=admin","options":{"maxPoolSize":2,"minPoolSize":1,"appName":"NoSQLBooster11_144415.91","directConnection":true}} 

15:22:26.647  Topology Opening
{"name":"topologyOpening","topologyId":7} 

15:22:26.647  Topology Description Changed
{"name":"topologyDescriptionChanged","topologyId":7,"previousDescription":{"type":"Unknown","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":0,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":0,"logicalSessionTimeoutMinutes":null},"newDescription":{"type":"Single","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":10000,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":0,"logicalSessionTimeoutMinutes":null}} 

15:22:26.647  Server Opening
{"name":"serverOpening","topologyId":7,"address":"30.200.40.100:27017"} 

15:22:26.766  Server Description Changed
{"name":"serverDescriptionChanged","topologyId":7,"address":"30.200.40.100:27017","previousDescription":{"address":"30.200.40.100:27017","type":"Unknown","hosts":[],"passives":[],"arbiters":[],"tags":{},"minWireVersion":0,"maxWireVersion":0,"roundTripTime":-1,"minRoundTripTime":0,"lastUpdateTime":2292878,"lastWriteDate":0,"error":null,"topologyVersion":null,"setName":null,"setVersion":null,"electionId":null,"logicalSessionTimeoutMinutes":null,"maxMessageSizeBytes":null,"maxWriteBatchSize":null,"maxBsonObjectSize":null,"primary":null,"me":null,"$clusterTime":null,"iscryptd":false},"newDescription":{"address":"30.200.40.100:27017","type":"RSSecondary","hosts":["mongo-rs0-mongodb-replicaset-0.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","mongo-rs0-mongodb-replicaset-1.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","mongo-rs0-mongodb-replicaset-2.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017"],"passives":[],"arbiters":[],"tags":{},"minWireVersion":0,"maxWireVersion":6,"roundTripTime":48,"minRoundTripTime":0,"lastUpdateTime":2292997,"lastWriteDate":"Wed Sep 23 2026 15:22:25 GMT+0300 (Eastern European Summer Time)","error":null,"topologyVersion":null,"setName":"rs0","setVersion":666359,"electionId":null,"logicalSessionTimeoutMinutes":30,"maxMessageSizeBytes":48000000,"maxWriteBatchSize":100000,"maxBsonObjectSize":16777216,"primary":"mongo-rs0-mongodb-replicaset-0.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","me":"mongo-rs0-mongodb-replicaset-1.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","$clusterTime":{"clusterTime":{"high":1790166145,"low":13,"unsigned":true},"signature":{"hash":"[Buffer]","keyId":{"high":1782021331,"low":2,"unsigned":false}}},"iscryptd":false}} 

15:22:26.766  Topology Description Changed
{"name":"topologyDescriptionChanged","topologyId":7,"previousDescription":{"type":"Single","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":10000,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":0,"logicalSessionTimeoutMinutes":null},"newDescription":{"type":"Single","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":10000,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":6,"logicalSessionTimeoutMinutes":30}} 

15:22:26.910  Server Description Changed
{"name":"serverDescriptionChanged","topologyId":7,"address":"30.200.40.100:27017","previousDescription":{"address":"30.200.40.100:27017","type":"RSSecondary","hosts":["mongo-rs0-mongodb-replicaset-0.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","mongo-rs0-mongodb-replicaset-1.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","mongo-rs0-mongodb-replicaset-2.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017"],"passives":[],"arbiters":[],"tags":{},"minWireVersion":0,"maxWireVersion":6,"roundTripTime":48,"minRoundTripTime":0,"lastUpdateTime":2292997,"lastWriteDate":"Wed Sep 23 2026 15:22:25 GMT+0300 (Eastern European Summer Time)","error":null,"topologyVersion":null,"setName":"rs0","setVersion":666359,"electionId":null,"logicalSessionTimeoutMinutes":30,"maxMessageSizeBytes":48000000,"maxWriteBatchSize":100000,"maxBsonObjectSize":16777216,"primary":"mongo-rs0-mongodb-replicaset-0.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","me":"mongo-rs0-mongodb-replicaset-1.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","$clusterTime":{"clusterTime":{"high":1790166145,"low":13,"unsigned":true},"signature":{"hash":"[Buffer]","keyId":{"high":1782021331,"low":2,"unsigned":false}}},"iscryptd":false},"newDescription":{"address":"30.200.40.100:27017","type":"Unknown","hosts":[],"passives":[],"arbiters":[],"tags":{},"minWireVersion":0,"maxWireVersion":0,"roundTripTime":-1,"minRoundTripTime":0,"lastUpdateTime":2293141,"lastWriteDate":0,"error":{"name":"MongoServerError","message":"Unsupported mechanism SCRAM-SHA-256","stack":"MongoServerError: Unsupported mechanism SCRAM-SHA-256\n    at Connection.sendCommand (/Applications/NoSQLBooster for MongoDB.app/Contents/Resources/app.asar/node_modules/mongodb/lib/cmap/connection.js:320:27)\n    at process.processTicksAndRejections (node:internal/process/task_queues:104:5)\n    at async Connection.command (/Applications/NoSQLBooster for MongoDB.app/Contents/Resources/app.asar/node_modules/mongodb/lib/cmap/connection.js:347:26)\n    at async executeScram (/Applications/NoSQLBooster for MongoDB.app/Contents/Resources/app.asar/node_modules/mongodb/lib/cmap/auth/scram.js:78:22)\n    at async ScramSHA256.auth (/Applications/NoSQLBooster for MongoDB.app/Contents/Resources/app.asar/node_modules/mongodb/lib/cmap/auth/scram.js:38:16)\n    at async performInitialHandshake (/Applications/NoSQLBooster for MongoDB.app/Contents/Resources/app.asar/node_modules/mongodb/lib/cmap/connect.js:110:13)\n    at async connect (/Applications/NoSQLBooster for MongoDB.app/Contents/Resources/app.asar/node_modules/mongodb/lib/cmap/connect.js:28:9)"},"topologyVersion":null,"setName":null,"setVersion":null,"electionId":null,"logicalSessionTimeoutMinutes":null,"maxMessageSizeBytes":null,"maxWriteBatchSize":null,"maxBsonObjectSize":null,"primary":null,"me":null,"$clusterTime":null,"iscryptd":false}} 

15:22:26.910  Topology Description Changed
{"name":"topologyDescriptionChanged","topologyId":7,"previousDescription":{"type":"Single","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":10000,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":6,"logicalSessionTimeoutMinutes":30},"newDescription":{"type":"Single","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":10000,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":6,"logicalSessionTimeoutMinutes":null}} 

15:22:26.913  Server Closed
{"name":"serverClosed","topologyId":7,"address":"30.200.40.100:27017"} 

15:22:26.913  Topology Closed
{"name":"topologyClosed","topologyId":7} 

15:22:26.913  *** Connect Error ***
{"errorLabelSet":{},"errorResponse":{"supportedMechanisms":["MONGODB-CR","MONGODB-X509","SCRAM-SHA-1"],"ok":0,"errmsg":"Unsupported mechanism SCRAM-SHA-256","code":2,"codeName":"BadValue","operationTime":{"$timestamp":"7688705047181393937"},"$clusterTime":{"clusterTime":{"$timestamp":"7688705047181393937"},"signature":{"hash":"Dr+OgMxSDUo+YrScVnb3+NmTqUw=","keyId":{"high":1782021331,"low":2,"unsigned":false}}}},"supportedMechanisms":["MONGODB-CR","MONGODB-X509","SCRAM-SHA-1"],"ok":0,"code":2,"codeName":"BadValue","operationTime":{"$timestamp":"7688705047181393937"},"$clusterTime":{"clusterTime":{"$timestamp":"7688705047181393937"},"signature":{"hash":"Dr+OgMxSDUo+YrScVnb3+NmTqUw=","keyId":{"high":1782021331,"low":2,"unsigned":false}}},"connectionGeneration":0,"name":"MongoServerError","message":"Unsupported mechanism SCRAM-SHA-256"}
For additional context, I also tested the following URI with the authentication mechanism explicitly specified: 

mongodb://<user>:<password>@<host>:<port>/<database>?authSource=<authDatabase>&authMechanism=SCRAM-SHA-1
When testing this URI directly during connection import, the connection succeeds.
The Test Connection report: 

Version: 11.1.6

OS: {"platform":"darwin","type":"Darwin","release":"27.0.0","mem":"36G"}

Brief:
Connect to 30.200.40.100 V3.6.23 Status:OK Duration:885ms

Details:
15:26:00.068  *** Starting MongoClient.connect ***
{"uri":"mongodb://user:******@30.200.40.100:27017/admin?authSource=admin&authMechanism=SCRAM-SHA-1","options":{"maxPoolSize":2,"minPoolSize":1,"appName":"NoSQLBooster11_144415.91","directConnection":true}} 

15:26:00.069  Topology Opening
{"name":"topologyOpening","topologyId":8} 

15:26:00.069  Topology Description Changed
{"name":"topologyDescriptionChanged","topologyId":8,"previousDescription":{"type":"Unknown","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":0,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":0,"logicalSessionTimeoutMinutes":null},"newDescription":{"type":"Single","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":10000,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":0,"logicalSessionTimeoutMinutes":null}} 

15:26:00.069  Server Opening
{"name":"serverOpening","topologyId":8,"address":"30.200.40.100:27017"} 

15:26:00.195  Server Description Changed
{"name":"serverDescriptionChanged","topologyId":8,"address":"30.200.40.100:27017","previousDescription":{"address":"30.200.40.100:27017","type":"Unknown","hosts":[],"passives":[],"arbiters":[],"tags":{},"minWireVersion":0,"maxWireVersion":0,"roundTripTime":-1,"minRoundTripTime":0,"lastUpdateTime":2506300,"lastWriteDate":0,"error":null,"topologyVersion":null,"setName":null,"setVersion":null,"electionId":null,"logicalSessionTimeoutMinutes":null,"maxMessageSizeBytes":null,"maxWriteBatchSize":null,"maxBsonObjectSize":null,"primary":null,"me":null,"$clusterTime":null,"iscryptd":false},"newDescription":{"address":"30.200.40.100:27017","type":"RSSecondary","hosts":["mongo-rs0-mongodb-replicaset-0.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","mongo-rs0-mongodb-replicaset-1.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","mongo-rs0-mongodb-replicaset-2.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017"],"passives":[],"arbiters":[],"tags":{},"minWireVersion":0,"maxWireVersion":6,"roundTripTime":65,"minRoundTripTime":0,"lastUpdateTime":2506426,"lastWriteDate":"Wed Sep 23 2026 15:25:58 GMT+0300 (Eastern European Summer Time)","error":null,"topologyVersion":null,"setName":"rs0","setVersion":666359,"electionId":null,"logicalSessionTimeoutMinutes":30,"maxMessageSizeBytes":48000000,"maxWriteBatchSize":100000,"maxBsonObjectSize":16777216,"primary":"mongo-rs0-mongodb-replicaset-0.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","me":"mongo-rs0-mongodb-replicaset-1.mongo-rs0-mongodb-replicaset.default.svc.cluster.local:27017","$clusterTime":{"clusterTime":{"high":1790166358,"low":5,"unsigned":true},"signature":{"hash":"[Buffer]","keyId":{"high":1782021331,"low":2,"unsigned":false}}},"iscryptd":false}} 

15:26:00.196  Topology Description Changed
{"name":"topologyDescriptionChanged","topologyId":8,"previousDescription":{"type":"Single","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":10000,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":0,"logicalSessionTimeoutMinutes":null},"newDescription":{"type":"Single","servers":"[Map]","stale":false,"compatible":true,"heartbeatFrequencyMS":10000,"localThresholdMS":15,"setName":null,"maxElectionId":null,"maxSetVersion":null,"commonWireVersion":6,"logicalSessionTimeoutMinutes":30}} 

15:26:00.953  *** Finished MongoClient.connect 885 ms ***
{"uri":"mongodb://user:******@30.200.40.100:27017/admin?authSource=admin&authMechanism=SCRAM-SHA-1","options":{"maxPoolSize":2,"minPoolSize":1,"appName":"NoSQLBooster11_144415.91","directConnection":true}} 

15:26:00.954  *** Starting Detecting MongoDB Server BuildInfo ***
 

15:26:01.004  *** Finished Detecting MongoDB Server BuildInfo  50 ms***
{"dbVersion":"3.6.23","isEnterprise":false} 

15:26:01.004  Server Closed
{"name":"serverClosed","topologyId":8,"address":"30.200.40.100:27017"} 

15:26:01.004  Topology Closed
{"name":"topologyClosed","topologyId":8}
However, after saving the connection and connecting through the saved connection profile, NoSQLBooster attempts to use SCRAM-SHA-256, and MongoDB 3.6 returns: 

Unsupported mechanism SCRAM-SHA-256
This is the main behavior I am trying to understand: the explicitly specified SCRAM-SHA-1 works during the initial URI test, but the saved connection appears to behave differently.

Please let me know if you need any additional diagnostic information.

This comment is in trash! Restore
photo
1
qinghai (support@nosqlbooster.com) ● 3 hours ago

Thank you for the detailed Test Connection reports - they were exactly what we needed, and we have now verified the case end to end against a MongoDB 3.6.23 server here.

Root cause: MongoDB 3.6 does not return saslSupportedMechs in its hello response (that field was added in 4.0), and the MongoDB driver bundled with 11.1.6 had no fallback for that case, so it defaulted to SCRAM-SHA-256. Your authMechanism=SCRAM-SHA-1 test succeeds because the option is still present at that moment; when the connection is saved, NoSQLBooster drops the redundant SCRAM mechanism and relies on driver negotiation - and it was that negotiation which 3.6 was mishandled. So your analysis was right: the saved profile really was not negotiable against a 3.6 server, and our earlier suggestion to simply drop authMechanism could not work until the underlying defect was fixed.

Fix: the driver now falls back to SCRAM-SHA-1 whenever the server reports maxWireVersion <= 6 (MongoDB 3.6 and older). MongoDB 4.0 and newer keep using SCRAM-SHA-256, and we checked that separately against a modern server so the change does not affect them.

The fix is available in the 11.1.7-beta.1 build, ready for you to try:

https://s3.nosqlbooster.com/download/releasesv11/nosqlbooster4mongo-11.1.7-beta.1-arm64.dmg
https://s3.nosqlbooster.com/download/releasesv11/nosqlbooster4mongo-11.1.7-beta.1-x64.dmg
https://s3.nosqlbooster.com/download/releasesv11/nosqlbooster4mongo-11.1.7-beta.1-x64.exe
https://s3.nosqlbooster.com/download/releasesv11/nosqlbooster4mongo-11.1.7-beta.1-x64-portable.zip

Could you please install it and retry both cases on your 3.6.23 replica set:

1. the connection you saved earlier with authMechanism=SCRAM-SHA-1 - just connect with the saved profile, no need to re-import it;
2. a plain URI without authMechanism (Basic username/password), saved first and then connected the same way.

Both should connect now. Please note this is a beta build and it is not offered by the automatic update check, so use the links above.

If either case still fails, please send us the Test Connection report from 11.1.7-beta.1 (Help > About shows the exact build) and we will investigate straight away.

This comment is in trash! Restore
photo
Leave a Comment
 
Attach a file
Powered by: UseResponse - Ideas Management Software
You can't vote. Please authorize!