Not possible to reload from MongoDB with a non admin user with the Qlik MongoDB connector Qlik Sense version November 2020

[Andreas_Giesbrecht]

Some customers reported the following error with the Qlik MongoDB connector (within the ODBC connector package) after upgrade to Qlik Sense version November 2020: 

Error: Connector reply error: Unable to connect to database:
20201216T110846.906+0100 Error message:
20201216T110846.906+0100 Please check the values for Username‚ Password‚ Host and other properties.

The issue could be seen and also could be reproduced when you use a non admin MongoDB user in order to reload the data from the MongoDB database (version 3.6).

For more information please check the screenshot:

 When you replaced the user for the MongoDB connection with an admin user the reload was working again:

 

Environment

• Qlik Sense Enterprise on Windows  November 2020

 

Cause 

As a result of the investigation:

1) On the reproduction environment we had two users with the same name (here for example "tester") specified in two DB: "admin" and "test_db1" (they had different passwords).

2) Driver from June 2020 release(v. 2.3.7) tried check credentials first for a "tester" from admin DB (as a default) and next from "test_db1" and as credentials fit ok connect by this  user.

3) After fix: Driver from November 2020 release(v. 2.3.12) tried check credentials for "tester" from admin DB (as a default) then connection failed due to credentials does not fit for "tester" from "admin" db.

 

Resolution

 To specify a user from which particular DB we are trying to use we need to use the additional parameter "AuthSource", like on screenshot: