SSL Certificate Validation & Handling Security Improved

As of MongoChef 4.5, we added support for MongoDB 3.4. The introduction of the 3.4 MongoDB driver has brought about quite a few bugfixes and changes one of which is an upgrade on the security of SSL certificate handling.

MongoChef will make sure that the certificate presented by the server indeed belongs to the server. The SSL/TLS protocol is now more strictly adhered to.

In order to download the latest MongoChef, choose the appropriate link below:

However…

… some SSL connections may now fail to work if not properly configured.

Each certificate protects a specific entity stated in the Subject Name field (CN) in the certificate – see https://support.dnsimple.com/articles/what-is-common-name/. Such a common name represents the entity protected by the SSL certificate. The certificate is valid only if the requested hostname matches the certificate’s common name.

If this is not the case, MongoChef will now by default not allow the connection.

SSL Connection Issues

If you are having problems connecting, it may be that you are connecting to a MongoDB server by IP (and not by CN) which is different than the CN. The protocol looks for alternative names that may match that IP address xx.xx.xx.xx but none is found. As a result, an error like “CertificateException: No subject alternative names present” is given.

A way to test this is to connect by name rather than IP: e.g. “my-ssl-mongod.server.com” instead of the IP “xx.xx.xxx.xx”. You have to make sure that this name resolves to the correct IP. If the local DNS does not do this it will have to be entered in the local OS’ hosts file – e.g. /etc/hosts in unix systems.

Another reason the connection may not be working anymore is that the server’s certificate (and/or the PEM client key file you are using – if any) is invalid. This is usually due to the use of a certificate which was not generated with a proper CN. Note that this may also mean that you are the target of a MITM (man-in-the-middle) attack.

How to Override

For our users’ convenience, we have added a new SSL option in the latest MongoChef 4.5.2 release. It will set your connection to also allow invalid hostnames which will emulate the connection behavior of MongoChef 4.4.x.

SSL Allow Invalid Hostnames

What is new in MongoChef 4.5

We are immensely excited to announce the release of MongoChef 4.5!

This is one of our largest releases ever. We would like to explicitly thank you, our users, for your plentiful feedback and feature suggestions that continue to make MongoChef so much better.

MongoChef 4.5 is chock-full of new features and improvements:

  • Full MongoDB 3.4 Compatibility
  • MongoDB Export to SQL
  • Improved Connections Tree
  • Integration of mongodump and mongorestore for Easy Backups

to name but the most high-level ones.

Full MongoDB 3.4 Compatibility

MongoDB 3.4 has brought many new high-level features such as read-only views, collation documents, and new aggregation operators. MongoChef 4.5 adds full support for these features.

Read-Only Views

MongoChef makes it super-easy to create MongoDB read-only views with its industry-leading aggregation builder. Build and debug your view with ease and then store it as a read-only view with just a click of your mouse.

mongodb create view

Collation Support

With MongoDB 3.4, you can now provide a collation document to specify language-specific rules for string comparison, such as rules for letter case and accent marks. MongoChef 4.5 allows you to specify a collation when you’re creating a collection, view, or an index and also when building an aggregation pipeline – and, naturally, wherever applicable in IntelliShell.

mongodb collation support

New Aggregation Operators

MongoDB 3.4 has also brought a number of new aggregation operators ($bucket, $bucketAuto, $facet, $graphLookup, $sortByCount). Of course, both MongoChef’s aggregation builder and IntelliShell have you covered here.

Export Your MongoDB Data to SQL

MongoChef Pro and Enterprise now let you export your MongoDB data directly to SQL and support the major SQL dialects: Oracle, MS SQL Server, MySQL, and PostgreSQL. Select your MongoDB data source and export to a SQL file that can then be safely imported into your SQL deployment.

1) Choose your SQL format options:

mongodb sql export options

2) MongoChef runs schema discovery on your MongoDB data to auto-select the most appropriate SQL target data types. You can of course also manually overwrite the mapping.

mongodb sql export mapping

3) View the resulting SQL file and safely import your MongoDB data into your SQL deployment.

mongodb sql file

Improved Connection Tree

We have introduced new meta-levels below the database level to make it even more comfortable to manage your various collections, views, system collections, and GridFS buckets.

connection tree metalevels

 

Integration of mongodump and mongorestore for Easy Backups

MongoChef now integrates with the mongodump and mongorestore backup and restore tools. You can now directly export (and of course import) your databases, collections or your query results to BSON folders or BSON archive files directly from within MongoChef. Backing up your data with MongoChef has never been easier.

1) Choose mongodump as export format:

export format mongodump

2) Configure your mongodump options:

mongodump configuration

Wait, there’s more!

See our full change log http://downloads.3t.io/mongochef-pro/changelog.txt for all the details.

 

What is new in MongoChef 4.4

MongoChef has just gotten even better! We are very pleased to announce that MongoChef 4.4 has been released!

For this release, we have particularly focussed on improving the overall user experience of MongoChef even further. Thanks a lot for all those suggestions!

Undocking tabs

Loads of you have requested this. And yes, this is a great productivity booster! You can now easily undock (and re-dock) any tab by just dragging the tab and dropping it off in a new location. Undocking tabs is especially useful in situations where you e.g. want to compare results or move a certain tab to a second monitor.

Filter connections

Over time, your connection list will likely grow to a substantial size. In order to quickly find a certain connection, we have added a filter box to the connection manager. As you type, it will show only those connections that match your input. MongoChef will search all relevant connection fields (name, database, connection type, etc):

mongochef connection filter

Read-only JSON document viewer

This is a seemingly minor addition to MongoChef – after all MongoChef has always had a full-blown JSON document editor. Nonetheless, this a very useful new feature, and an oft-requested one, as it will prevent you from inadvertently making changes to a document when just viewing it.

mongodb-json-document-viewer

Dark editor theme

We have implemented another very popular feature request: make the background of the editors in MongoChef dark. And, so, here it is (you can set it in the Preferences):

mongochef dark editor theme

We will be further fine-tuning this over the next iterations. So, please send us your feedback :-)

Import empty CSV fields as empty strings

We have added an option to our CSV import. You can now specify to import empty CSV fields as empty strings.

mongodb csv import empty strings

 

Wait, there’s more!

See our full change log http://downloads.3t.io/mongochef-pro/changelog.txt for all the details.

 

What is new in MongoChef 4.3.0

We have just released MongoChef 4.3.0!

This release brings many improvements and new features you have asked for, for example:

Schema Documentation

You can now generate beautiful schema documentation for MS Word:

mobgodb schema documentation

 

mongodb schema documentation word overview

 

mongodb schema documentation word

 

Explore documents missing a certain field

When you spot a field in the schema explorer that does not occur in all documents, you can now easily explore the documents that do not have that field.

mongodb schema discovery explore missing field

 

Wait, there’s more!

See our full change log http://downloads.3t.io/mongochef-pro/changelog.txt for all the details.

 

What is new in MongoChef 4.2.0

Today we are very excited to announce that we have just released MongoChef 4.2.0!

This release brings many improvements and new features you have asked for, for example:

Improved SSH/SSL support

We have significantly expanded our SSH/SSL support. We now support most ciphers, key exchange protocols, message authentication codes (MACs) as well as DER-encoded private keys.

Option to remove a field from matching documents

When you select a field in document and you choose to remove the field, you can now also specify in the ensuing dialog to remove the field only from those fields matching the current query.
remove field from matching documents

Parse “connect-to” database from connection URI

When connecting to the mongo shell, one can pass the shell a connection URI in the following form

mongodb://user:pwd@host:port/my_db?authSource=admin

which will connect the user (who is defined in database “admin”) directly to the database “my_db”. This concept of course doesn’t directly translate to MongoChef where you see all available databases at once. MongoChef will now parse that connect-to database directly from the URI and add it to the list of manually defined visible databases for the user:

mongodb connection uri

mongodb manual database list

Save binary blob field to file

We have added an option directly to a binary field’s pop-up menu to save the binary blob to file (and to load from a file into the field).

save mongodb binary field to file

Scan entire collection for all fields for CSV export

When exporting documents to CSV, MongoChef by default scans only a subset of documents (usually the documents currently showing in the query result) for field names to suggest as CSV column names. Due to the schema-less nature of MongoDB, this could miss desired fields that in the past had to then be added manually. Now, MongoChef offers a new option to force a scan of the entire collection – which will continuously update the field name list as they are discovered.

Discover all fields for CSV export

Quick feedback when two compared collections are identical

We have added quick and obvious visual feedback to show the user in case the source and target collection during a comparison analysis were found to be identical.

Compare MongoDB collections - identical

Wait, there’s more!

See our full change log http://downloads.3t.io/mongochef-pro/changelog.txt for all the details.

 

What’s new in MongoChef 4.1.1

Today we are very excited to announce that we have just released MongoChef 4.1.1!

This release brings many improvements and new features you have asked for, for example:

Disabling of aggregation pipeline stages

In the aggregation tab, it is now super-easy to disable certain stages temporarily from your aggregation pipeline. This is a very convenient feature when debugging complex aggregations.

MongoDB disable aggregation stage

Paging through collection statistics

We have added paging to the “Collection Statistics” tab of a database – in case you have many, many collections in your database.

mongodb collection statistics

Wait, there is more!

See our full change log http://downloads.3t.io/mongochef-pro/changelog.txt for all the details.

 

What’s new in MongoChef 4.1.0

Great news everyone! Today, we just released MongoChef 4.1.0!

This release brings many improvements and new features you have asked for, for example:

Refresh GridFS view automatically after sort-by option selection has changed

Previously, when you changed the sort-by option in your GridFS view, seemingly nothing would happen – because MongoChef waited for an explicit, user-triggered refresh of the view for the new sort-by option to take effect. This was of course a bit silly – as many of you rightly pointed out to us. So, with this new release, that’s all gone and the GridFS view is automatically refreshed after you change your sort-by option.
GridFS auto refresh sort

Improved UTF-8 handling

IntelliShell now uses UTF-8 consistently through-out and we fixed an issue around loading persisted aggregation queries.

Wait, there is more!

See our full change log http://downloads.3t.io/mongochef-pro/changelog.txt for all the details.