Version:

Version:

Version:


Table of Contents

Administration Guide

Download PDF
Copy Link

Configure a database password

To create your own report templates using FortiNAC data, Crystal Reports must be able to access your MySQL database. Due to security concerns, a default reports password is not provided. You must create a database password before configuring your ODBC connection. If you have multiple FortiNAC appliances, create a password for each database that will be used for reports.

  1. Navigate to the command line on your FortiNAC Server or FortiNAC Control Server.
  2. Log in as a root user.
  3. Navigate to the /bsc/campusMgr/bin directory. This directory contains the CreateDBAccount script. By default the privileges are set to SELECT which provides Read-Only access.
  4. Run the CreateDBAccount script and supply the required parameters. To run the script type the following:

    CreateDBAccount <username> <password> <serverip or %>

    Where:

    username is the username for the remote account

    password is the password for the remote account

    serverip is the IP address of the host used to connect to the database. Using this parameter ensures that the user can connect with this username and password only from that host. If you wish to allow the user to connect from any host use % instead of the IP address.

    % is a wild card for the IP address of the host used to connect to the database. This allows the user to connect with the created username and password from any host.

    Example:

    CreateDBAccount reports abc123 %

  5. The new database user name and password are now available for reports.
Note

To remove a MySQL account use the DeleteDBAccount script.

Configure a database password

To create your own report templates using FortiNAC data, Crystal Reports must be able to access your MySQL database. Due to security concerns, a default reports password is not provided. You must create a database password before configuring your ODBC connection. If you have multiple FortiNAC appliances, create a password for each database that will be used for reports.

  1. Navigate to the command line on your FortiNAC Server or FortiNAC Control Server.
  2. Log in as a root user.
  3. Navigate to the /bsc/campusMgr/bin directory. This directory contains the CreateDBAccount script. By default the privileges are set to SELECT which provides Read-Only access.
  4. Run the CreateDBAccount script and supply the required parameters. To run the script type the following:

    CreateDBAccount <username> <password> <serverip or %>

    Where:

    username is the username for the remote account

    password is the password for the remote account

    serverip is the IP address of the host used to connect to the database. Using this parameter ensures that the user can connect with this username and password only from that host. If you wish to allow the user to connect from any host use % instead of the IP address.

    % is a wild card for the IP address of the host used to connect to the database. This allows the user to connect with the created username and password from any host.

    Example:

    CreateDBAccount reports abc123 %

  5. The new database user name and password are now available for reports.
Note

To remove a MySQL account use the DeleteDBAccount script.