Navigation

Install the C Authentication Plugin

New in version 2.2.

The MongoDB Connector for BI provides a MySQL authentication plugin which implements the client side of MongoDB-supported authentication mechanisms. The mongosql_auth plugin allows you to use MongoDB Connector for BI with a MongoDB instance running with authentication enabled without needing to generate your own SSL certificates for authentication.

This plugin supports the following authentication mechanisms:

  • SCRAM-SHA-1
  • PLAIN

Supported Platforms

The plugin is built and tested on the following platforms (all x86_64):

  • Windows 2008 R2
  • OSX 10.12
  • Ubuntu 14.04
  • RHEL 7.0

The plugin is built against MySQL 5.7.18 Community Edition (64-bit), and tested with MySQL 5.7.18 Community Edition and the MongoDB Connector for BI 2.2.

Install mongosql_auth on Windows

  1. Download the MySQL 5.7.18 installer and install the products needed.
  2. Download the mongosql_auth plugin component .msi installer and install the mongosql_auth plugin component.

Install mongosql_auth on MacOS or Linux

  1. Download mongosql_auth plugin library from the releases page.

  2. After downloading, move the file mongosql_auth.so to either:

    • <mysql-home>/lib/plugin/ directory.

      The default location of <mysql-home> varies by platform.

      To discover the location of the plugin directory, run the following at the command line:

      mysql_config --plugindir
      

    - OR -

    • A directory of your choice if you provide the plugin-dir=<your-install-dir> option to your MySQL client. See the mysql client command example.

For more information on usage and examples, see C Authentication Plugin.