agile dba,data privacy,data protection, management of information systems, relational, non-relational, structured, non-structured, semi-structured, on-premises, in the cloud
dba-ninja.com:Everything
Search dba-ninja.com
Follow dba-ninja.com
For any Database issues send email to: jackvamvas@gmail.com
dba-ninja.com Links
Recent Posts
- How to fix Table doesn't exist in engine error for MariaDB Error 1932
- How to use auto-increment with PostgreSQL sequence
- Announcing Powerful Rules for Disruptors with MongoDB
- How to fix - Cannot connect to the Docker daemon
- How to master KSQL with cheat-sheet
- How to find Default Access Privileges on PostgreSQL with pg_default_acl
- MongoDB 4.2.7 Bug - Off-by-one overflow in block-modification bitmaps for incremental backup
- Failed: error dumping users and roles: error writing data for collection with mongodump
- Easy fix for ERROR 1010 (HY000): Error dropping database
- Overcome the MongoDB Backup is down alert
24 January,2020 by Jack Vamvas
Question: How can I list client ip , port and connection ID of connections to MongoDB? I want to connect through the MongoDB command line and extract this information as I'm testing some HA failover scenarios.
Answer: There's a few different ways to extract the MongoDB connection details - for example you can use netstat. But from the command line - this syntax will report the details required
db.currentOp(true).inprog.forEach(function(d){if(d.client)print(d.client, d.connectionId)})
Example output - clientip:port clientid:
127.0.0.1:55552 4668364
10.120.xxx.xxx:60942 4668363
10.120.xxx.xxx:60924 4668357
Read More on MongoDB
How to read MongoDB system log file
Author: Jack Vamvas (http://www.dba-ninja.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |