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.
- Navigate to the command line on your FortiNAC Server or FortiNAC Control Server.
- Log in as a root user.
- Navigate to the
/bsc/campusMgr/bin
directory. This directory contains theCreateDBAccount
script. By default the privileges are set to SELECT which provides Read-Only access. -
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 accountpassword
is the password for the remote accountserverip
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 %
- The new database user name and password are now available for reports.
To remove a MySQL account use the DeleteDBAccount script. |