- MongoDB Connector for BI Components >
- C Authentication Plugin
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
Note
- The
SCRAM-SHA-1
mechanism hashes the passwords in the client plugin; however, all other data is in cleartext. If possible, use with encrypted connections. - The
PLAIN
mechanism sends the password in cleartext. Use encrypted connections with thePLAIN
mechanism .
Supported Platforms¶
The plugin is built and tested on the following platforms:
- Windows 2008 R2 (32- and 64-bit)
- macOS 10.12 (64-bit)
- Ubuntu 14.04 (64-bit)
- RHEL 7.0 (64-bit)
Testing Environment
The C Authentication plugin was developed against MySQL 5.7.18 Community Edition (64-bit), and tested with MySQL 5.7.18 Community Edition and the latest version of MongoDB Connector for BI. The plugin is not compatible with MySQL Server or Connector/ODBC driver version 8 and later.
Installing the Plugin¶
To install the plugin, see Install the C Authentication Plugin.
Using the Plugin for Authentication¶
Before you use the authentication plugin, you must set up authenticated users for MongoDB. For more information on creating authenticated users, see Enable Authentication. If you are using the Atlas-hosted BI Connector, see Configure Database Users.
The procedure for using the C Authentication plugin library varies depending on your SQL client. The C Authentication plugin can be used via one of the following methods:
- DSN (Data Source Name) using the MySQL Connector/ODBC driver. For more information, see Create a System DSN.
- The
--default-auth
option for the MySQL Shell. For more information, see Connect from the MySQL Client.
This plugin can is compatible with both the 32-bit or 64-bit versions of the MySQL shell and MySQL Connector/ODBC driver. The installation directory differs depending on the version you install.