Monitoring with a CA Standard Monitor › Support for XFF Translation › Enable XFF Translation

Enable XFF Translation

Enabling XFF translation requires you to run a MySQL command on the management console database. To run the required MySQL command, follow these steps:

1. Log into the management console server with a Windows administrator account.
2. Access the management console database using the correct database name and port:

   Database name

   The default management console database name is super.

   Database port

   The default port for the management console database is TCP-3308.

For more information about using MySQL commands, see the MySQL documentation available at www.mysql.com.

Follow these steps:

1. Log into the management console computer using a Windows administrator account.
2. Open a Command Prompt.
3. Login into MySQL by running the following command:

   mysql -P3308
   

4. MySQL displays the following prompt.

   mysql>
   

5. At the MySQL prompt, run the following command to switch to the management console database:

   use super;
   

   MySQL displays the following response:

   Database changed
   

6. At the MySQL prompt, run the following command to enable XFF translation:

   INSERT IGNORE INTO parameter_descriptions (Parameter, Level, Type, DefaultValue, Description) VALUES ('XFFEnabled', 'System', 'boolean', '1', 'Non-zero to enable XFF endpoint extraction in URL monitoring.');
   

   MySQL displays the following response:

   Query OK, 1 row affected (0.00 sec)
   

7. (Optional) To disable XFF translation after you enable it, run the following command:

   UPDATE parameter_descriptions SET DefaultValue='0' WHERE parameter='XFFEnabled';
   

   MySQL displays the following response:

   Query OK, 1 row affected (0.02 sec)
   Rows matched: 1  Changed: 1  Warnings: 0
   

8. Close the Command Prompt.
9. To apply your changes, synchronize the monitoring devices.

More information:

Windows Administrator Credentials