Fortinet black logo

Administration Guide

Install and configure MySQL ODBC connector

Copy Link
Copy Doc ID 825689eb-200d-11e9-b6f6-f8bc1258b856:326964
Download PDF

Install and configure MySQL ODBC connector

The MySQL ODBC connector is required only if you plan to create or edit Crystal Report templates and upload them to the FortiNAC server.

Installation

  1. Use a browser to go to the MySQL web site at www.mysql.com.
  2. Go to the Downloads section.
  3. Select or search for Connectors.
  4. Download the appropriate Connector-ODBC for your operating system.
  5. Download or display the Connector-ODBC installation instructions.
  6. Follow the installation instructions and install the connector.

Configuration

Before configuring the ODBC Data Source, you must determine who should have access to this Data Source for reports.

  • To provide access for only the current logged in user, create the data source using the User DSN tab.
  • To provide access to all users connecting through this computer, create the data source using the System DSN tab.
  • To provide access to any user on any computer that has the MySQL Connector-ODBC installed, use the File DNS tab and save the Data Source to a network or shared drive.

The instructions below describe configuring the Data Source for the current logged in user. Options for System DSN and File DSN are similar, use the Help for additional instructions.

  1. From your Windows Desktop select Start > Run.
  2. In the Run window type odbcad32 and click OK. This logs you into the Microsoft ODBC Administrator.
  3. Make sure you are on the User DSN tab and click Add to create a new ODBC data source. The Create New Data Source window displays.
  4. Click Finish. The ODBC Data Source Configuration window displays. Use this window to configure the connection to your FortiNAC appliance and its database. The database is on the FortiNAC Server or Control Server.

    Note

    If you have more than one FortiNAC Server or Control Server, you must configure a separate connection for each one.

  5. In the Data Source Name field type the name of your FortiNAC Server or Control Server. This is a user defined name and is not used to connect to the database.
  6. In the Description field enter a description of the FortiNAC Server or Control Server.
  7. In the Server field enter either the IP address or the DNS name of the FortiNAC Server or Control Server.
  8. In the User field enter the user name you created to access the MySQL database on your FortiNAC Server.
  9. In the Password field enter the password you created to access your MySQL database.
  10. Click the Test button to test the connection and populate the Database field with available databases on the selected server.
  11. In the Database field, select bsc as the database and click OK.
  12. You are returned to the ODBC Data Source Administrator window and your new data source is displayed. Click OK to save.

Install and configure MySQL ODBC connector

The MySQL ODBC connector is required only if you plan to create or edit Crystal Report templates and upload them to the FortiNAC server.

Installation

  1. Use a browser to go to the MySQL web site at www.mysql.com.
  2. Go to the Downloads section.
  3. Select or search for Connectors.
  4. Download the appropriate Connector-ODBC for your operating system.
  5. Download or display the Connector-ODBC installation instructions.
  6. Follow the installation instructions and install the connector.

Configuration

Before configuring the ODBC Data Source, you must determine who should have access to this Data Source for reports.

  • To provide access for only the current logged in user, create the data source using the User DSN tab.
  • To provide access to all users connecting through this computer, create the data source using the System DSN tab.
  • To provide access to any user on any computer that has the MySQL Connector-ODBC installed, use the File DNS tab and save the Data Source to a network or shared drive.

The instructions below describe configuring the Data Source for the current logged in user. Options for System DSN and File DSN are similar, use the Help for additional instructions.

  1. From your Windows Desktop select Start > Run.
  2. In the Run window type odbcad32 and click OK. This logs you into the Microsoft ODBC Administrator.
  3. Make sure you are on the User DSN tab and click Add to create a new ODBC data source. The Create New Data Source window displays.
  4. Click Finish. The ODBC Data Source Configuration window displays. Use this window to configure the connection to your FortiNAC appliance and its database. The database is on the FortiNAC Server or Control Server.

    Note

    If you have more than one FortiNAC Server or Control Server, you must configure a separate connection for each one.

  5. In the Data Source Name field type the name of your FortiNAC Server or Control Server. This is a user defined name and is not used to connect to the database.
  6. In the Description field enter a description of the FortiNAC Server or Control Server.
  7. In the Server field enter either the IP address or the DNS name of the FortiNAC Server or Control Server.
  8. In the User field enter the user name you created to access the MySQL database on your FortiNAC Server.
  9. In the Password field enter the password you created to access your MySQL database.
  10. Click the Test button to test the connection and populate the Database field with available databases on the selected server.
  11. In the Database field, select bsc as the database and click OK.
  12. You are returned to the ODBC Data Source Administrator window and your new data source is displayed. Click OK to save.