Can not see Collection even after successfully connected

AN K shared this problem 6 years ago
Cannot Reproduce

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

Replies (1)

photo
1

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.

/2ea6c8fbe5ca96d28b8c1d1c14169f07

Leave a Comment
 
Attach a file