Can not see Collection even after successfully connected
Hi there,
I am having issues when trying to see collections in my database. I can firmly say:
1) Connecting to right server/ correct replicaset.
2) Read access on the database.
3) NO issues in connecting and seeing collections with Compass.
We are using $external authentication. I can see, I got connected in the mongod.log when using nosql booster, and able to switch to my database as well. But, not able to see collections.
It is throwing an errors:
__________________________________________________________________________________________________
2018-08-06T10:50:18.122-0500 I ACCESS [conn216212] Unauthorized: not authorized on admin to execute command { listCollections: true, filter: {}, cursor: {}, nameOnly: false, $clusterTime: { clusterTime: Timestamp(1533570614, 1), signature: { hash: BinData(0, 94CCE9E638E306C6B99919393E71FD24F73B808A), keyId: 6546252671387435010 } }, $readPreference: { mode: "secondaryPreferred" }, $db: "admin" }
2018-08-06T10:50:18.122-0500 I ACCESS [conn216213] Unauthorized: not authorized on admin to execute command { listCollections: true, filter: {}, cursor: {}, nameOnly: false, $clusterTime: { clusterTime: Timestamp(1533570614, 1), signature: { hash: BinData(0, 94CCE9E638E306C6B99919393E71FD24F73B808A), keyId: 6546252671387435010 } }, $readPreference: { mode: "secondaryPreferred" }, $db: "admin" }
2018-08-06T10:50:18.720-0500 I ACCESS [conn216212] Unauthorized: not authorized on admin to execute command { listCollections: true, filter: {}, cursor: {}, nameOnly: false, $clusterTime: { clusterTime: Timestamp(1533570614, 1), signature: { hash: BinData(0, 94CCE9E638E306C6B99919393E71FD24F73B808A), keyId: 6546252671387435010 } }, $readPreference: { mode: "secondaryPreferred" }, $db: "admin" }
2018-08-06T10:50:18.720-0500 I ACCESS [conn216213] Unauthorized: not authorized on admin to execute command { listCollections: true, filter: {}, cursor: {}, nameOnly: false, $clusterTime: { clusterTime: Timestamp(1533570614, 1), signature: { hash: BinData(0, 94CCE9E638E306C6B99919393E71FD24F73B808A), keyId: 6546252671387435010 } }, $readPreference: { mode: "secondaryPreferred" }, $db: "admin" }
2018-08-06T10:50:18.720-0500 I ACCESS [conn216212] Unauthorized: not authorized on admin to execute command { listCollections: true, filter: {}, cursor: {}, nameOnly: false, $clusterTime: { clusterTime: Timestamp(1533570614, 1), signature: { hash: BinData(0, 94CCE9E638E306C6B99919393E71FD24F73B808A), keyId: 6546252671387435010 } }, $readPreference: { mode: "secondaryPreferred" }, $db: "admin" }
2018-08-06T10:50:18.725-0500 I ACCESS [conn216211] Unauthorized: not authorized on admin to execute command { listCollections: true, filter: {}, cursor: {}, nameOnly: false, $clusterTime: { clusterTime: Timestamp(1533570614, 1), signature: { hash: BinData(0, 94CCE9E638E306C6B99919393E71FD24F73B808A), keyId: 6546252671387435010 } }, $readPreference: { mode: "secondaryPreferred" }, $db: "admin" }
2018-08-06T10:50:18.725-0500 I ACCESS [conn216211] Unauthorized: not authorized on admin to execute command { listCollections: true, filter: {}, cursor: {}, nameOnly: false, $clusterTime: { clusterTime: Timestamp(1533570614, 1), signature: { hash: BinData(0, 94CCE9E638E306C6B99919393E71FD24F73B808A), keyId: 6546252671387435010 } }, $readPreference: { mode: "secondaryPreferred" }, $db: "admin" }
2018-08-06T10:50:18.739-0500 I ACCESS [conn216212] Unauthorized: not authorized on admin to execute command { listCollections: true, filter: {}, cursor: {}, nameOnly: false, $clusterTime: { clusterTime: Timestamp(1533570614, 1), signature: { hash: BinData(0, 94CCE9E638E306C6B99919393E71FD24F73B808A), keyId: 6546252671387435010 } }, $readPreference: { mode: "secondaryPreferred" }, $db: "admin" }
2018-08-06T10:50:18.740-0500 I ACCESS [conn216211] Unauthorized: not authorized on admin to execute command { listCollections: true, filter: {}, cursor: {}, nameOnly: false, $clusterTime: { clusterTime: Timestamp(1533570614, 1), signature: { hash: BinData(0, 94CCE9E638E306C6B99919393E71FD24F73B808A), keyId: 6546252671387435010 } }, $readPreference: { mode: "secondaryPreferred" }, $db: "admin" }
2018-08-06T10:50:18.740-0500 I ACCESS [conn216213] Unauthorized: not authorized on admin to execute command { replSetGetStatus: 1.0
____________________________________________________________________________________________________
Why it is automatically trying to run all these commands?? How can stop it??
Pls., help
The same problem 
From the log it looks like a permissions related issue. NoSQLBooster will run "db.getCollectionInfos()" to get collection list and show the list in the database object explorere (left pane). Each connection tries to execute the command once or twice. The MONGODB_DRIVER_POOLSIZE is 3. This operation is used to display the UI, there is no way to manually stop
Could you please open a shell tab and enter "db.getCollectionInfos()"? And, please take a look the "default database" value of the connection options.
From the log it looks like a permissions related issue. NoSQLBooster will run "db.getCollectionInfos()" to get collection list and show the list in the database object explorere (left pane). Each connection tries to execute the command once or twice. The MONGODB_DRIVER_POOLSIZE is 3. This operation is used to display the UI, there is no way to manually stop
Could you please open a shell tab and enter "db.getCollectionInfos()"? And, please take a look the "default database" value of the connection options.
Replies have been locked on this page!