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 (32- and 64-bit)
  • macOS 10.12 (64-bit)
  • Ubuntu 14.04 (64-bit)
  • RHEL 7.0 (all 64-bit)

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.x installer and install the MySQL Community Server, which includes the MySQL shell (mysql.exe).

  2. Download the mongosql_auth plugin component .msi installer and install the mongosql_auth plugin component.

    The plugin is installed into one of the following directories depending on platform:

    Platform Default Location
    32-bit Windows C:\Program Files (x86)\MySQL\MySQL Server 5.7\lib\plugin
    64-bit Windows C:\Program Files\MySQL\MySQL Server 5.7\lib\plugin

Install mongosql_auth on MacOS or Linux

  1. Download the MySQL 5.7.x installer and install the MySQL Community Server, which includes the MySQL shell.

  2. Download mongosql_auth plugin library from the releases page.

  3. 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.