Change IP Addresses of all ReporterAnalyzer components

Document ID : KB000023259
Last Modified Date : 14/02/2018
Show Technical Document Details
ISSUE:
How to change the IP addresses of all ReporterAnalyzer components. (RA 9.0.x and below only)

DETAILS:
This article describes the necessary steps to change the IP addresses of all ReporterAnalyzer components that are in a production environment. This article does NOT apply to all-in-one ReporterAnalyzer units. These instructions should only be followed if ReporterAnalyzer already exists in production and the administrator has to assign new IP addresses to the entire ReporterAnalyzer solution.

RESOLUTION:
To edit the IP addresses of all ReporterAnalyzer components in a production environment, follow these steps: 
1. Change the IP address of the Harvester(s). 
2. Change the IP address of the NetFlow Manager(s). 
3. Log into the NetFlow Manager's web interface. 
4. Click the Administration link under 'NetFlow Harvesters'. 
5. Select a Harvester and click the Edit button. 
6. Change the IP address to the new IP address of this Harvester. 
7. Repeat for all Harvesters. 
8. Restart the NetQoS NetFlow Interpreter service. 
 
1. Change the IP address of the ReporterAnalyzer server. 
2. Open the ReporterAnalyzer AdminTool. 
3. Click the DSA tab. 
4. Select one of the DSA's by highlighing the row for the DSA, then click on the 'IP Address' button. 
5. Enter the new IP address for the DSA. 
6. Repeat this step for all DSA's. 
 
1. Open the ReporterAdmin Tool. 
2. In the 'Reporter' tab click 'IP Address' and enter the ReporterAnalyzer Master Console's new ip address. 
3. On the ReporterAnalyzer server, click Start -> Programs -> Administrative Tools -> Data Sources (ODBC). 
4. Click the System DSN tab. 
5. Double click the name of the NetFlow Manager. 
6. Enter the new IP address of the Manager in the 'Host/Server Name (or IP)' text box. 
7. Click OK, then click OK again. 
8. Restart all NetQoS Services on the ReporterAnalyzer server. 
 
1. Verify that IP addresses have been changed in the ReporterAnalyzer Database. 
    a. Open a command prompt and type in the following commands:
           mysql -D reporter select inet_ntoa(address) from database_servers; 
    b. The IP address should be the new IP addresses of the DSA's.
           select * from system_settings where parameter='reporterIP' or parameter='reporterDSAIP'; 
    c. Both of the values should be the new IP address assigned to the Reporter server. 
           If not, run this query:
              update system_settings set value='' where parameter='reporterIP' or parameter='reporterDSAIP';
              select * from system_settings where parameter='reporterIP' or parameter='reporterDSAIP'; 
    d. The correct IP address should now be visible. 
2. Close the command prompt. 
 
If the IP of the Harvester or NFM has changed and the system status page is still showing the old IPs, please implement the following change (note that the new IPs will be placed into this page automatically). 
1. Enter the following 3 lines at a command line prompt
   (where the old.ip.of.nfm is the old IP address of the NFM and the old.ip.of.harvester is the old IP address of the harvester): 
    a. mysql reporter delete from nfm_status where address=inet_aton('old.ip.of.nfm'); 
    b. delete from harvester_status where address=inet_aton('old.ip.of.harvester'); 
2. You should wait 45 minutes before you start to see real time data from routers that enter the system via the Harvester. 
3. If you cannot view real time data, you'll need the following information handy for a query: 
    a. IP Address of the Router that is not showing Real Time data
    b. IP Address of the Harvester this Router is exporting Netflow
4. To Open a command prompt on the ReporterAnalyzer server and type in the following commands: 
    a. Mysql -D reporter
    b. Update agent_definitions set receiveraddress = inet_aton('') where routeraddress= inet_aton('')
    c. Exit Exit
5. Now when viewing Real Time data for this Router, you should see correct results.
6. Repeat this step for all Routers that do not show Real Time data. 
 
Tell ReporterAnalyzer the new IP address of the DSA to load data into. 
1. Open a command prompt on the ReporterAnalyzer server and type in the following commands: 
    a. Mysql -D reporter
    b. Update agent_definitions set dataserver=inet_aton('x.x.x.x') where dataserver=inet_aton('y.y.y.y'); 
        (where x.x.x.x = the new IP address for the DSA and y.y.y.y = the old IP address for the DSA)
    c. Exit Exit 
2. Follow the appropriate steps for your version of the DSA. 
    a. Linux DSA's Use putty to SSH to a DSA. 
    b. Use the following account to login: Username: changeip Password: changeip
    c. Select the option to change the IP address of the DSA. 
 
3. Follow the on screen instructions to change the IP address. 
    a. Select the option to restart the DSA when you are finished. 
    b. After the DSA has been restarted, use putty to SSH to the DSA again. 
    c. Login to the DSA using the root account. 
    d. Enter the following commands: mysql -D nqrptr select * from parameters; 
    e. The pumpIP value should be the new IP address of the ReporterAnalyzer server. 
        If not, run this query: 
           update parameters set value='' where parameter='pumpIP';
           select * from parameters; 
    f. The correct IP address should now be visible. 
    g. Type exit to quit mysql and exit again to quit putty. 
    h. Repeat this for all DSA's. 
    i. Restart all NetQoS services on the Reporter server when this is complete. 
 
Windows DSA's Terminal Service to your DSA. Change the IP address of the server. 
1. Open a command prompt and enter the following commands: 
        mysql -D nqrptr select * from parameters; 
2. The pumpIP and reporterIP values should be the new IP address of the ReporterAnalyzer server. 
    If not, run this query: 
       update parameters set value='' where parameter='pumpIP';
       update parameters set value='' where parameter='reporterIP';
       select * from parameters; 
3. The correct IP address should now be visible. 
4. Type exit to quit mysql. 
5. Repeat this for all DSA's. 
6. Restart all NetQoS services on the Reporter server when this is complete. 
 
This step only applies to Linux DSA's. 
1. On the DSA, make sure that you can mount to the ReporterAnalyzer datashare directory to ensure proper connectivity. 
2. To check the current mounts on the DSA, type in mount. 
3. If the datashare mount does not exist, type in the following commands: 
       cd ../netqos/system ./starter.pl Mount 
4. The mount to the datashare should now exist.