How to change the NFA drive and path in the database after a server migration

Document ID : KB000029438
Last Modified Date : 14/02/2018
Show Technical Document Details
Summary:
How to change the installation path or drive for an NFA environment that has been migrated to a new server or installation path.
 
 
 
Instructions:
1)Backup the necessary databases following the backup procedures in the NFA 9.3.3 Guide.

 

2) Uninstall NFA software via Control Panel->Add/Remove Programs.

 

3) Delete the hidden folder/file below(Console only):

 

C:\Program Files\Zero G Registry\.com.zerog.registry.xml

 

4) Delete any left over folders in the old Path like "C:\NFA"

 

5) Delete the Registry Key 'HKLM/Software/Wow6432Node/NetQos'

 

6) Open IIS and expand Sites->Default site and delete the RA, ProxyServices, ReporterDataSource, and ReporterWebService sites. (Console only)

 
7)Reinstall the NFA software to the new drive path and restore your database.
 
 
8)There will be several database changes needed to update the correct path as documented below.
 
The example queries below for each server assume you were moving the installation directory from "C:\NFA" to "D:\NFA":
 
 
On the NFA Console Server:
 
1. Open a command prompt and login to the 'reporter' database:
mysql -P3308 reporter
2. The run the queries below for each table.
 
      a. For the 'parameter_descriptions' table:
  update parameter_descriptions set defaultvalue='D:/CA/NFA/Reporter/datashare' where parameter='datasharepath';
 
 
  update parameter_descriptions set defaultvalue='D:/CA/NFA/tzinfo' where parameter='tzinfodir';
 
 
  update parameter_descriptions set defaultvalue='D:/CA/NFA/reporter/web' where parameter='webroot';
 

       b. For the 'system_settings' table:
   update system_settings set value='D:/CA/NFA/' where parameter='nqhome';
 
 
   update system_settings set value='D:/CA/NFA/tzinfo' where parameter='tzinfodir';
 
 
    update system_settings set value='D:/CA/NFA/reporter/web' where parameter='webroot';
 
       c. For the 'general' table:
    update general set value='D:/CA/NFA/Reporter/xsl/email' where attribute='emailtemplatepath';
 
On the NFA Harvester:
1. Login to the Harvester database with the command:
mysql -P3308 harvester
 
2. The run the queries below for each table.
 
 
      a. For the 'parameter_descriptions' table:
  update parameter_descriptions set defaultvalue='D:/CA/NFA/Netflow' where parameter='harvesterInstallRoot';
 
  update parameter_descriptions set defaultvalue='D:/CA/NFA/tzinfo' where parameter='tzInfoDir';
 
  update parameter_descriptions set defaultvalue='D:/CA/NFA/tzinfo' where parameter='RealtimeReaper_ErrorLogFile';

      b. For the 'extended_parameter_values' table:

  update extended_parameters_values set value='D:/CA/NFA//Netflow//Logs//RealtimeReaperErrors%04d-%02d-%02d.log' where id='97';

  update extended_parameters_values set value='D:/CA/NFA//Netflow//Logs//RealtimeReaperExceptions%04d-%02d-%02d.log' where id='114';

 

On the DSA(3 Tier System Only)

    1. Login to the 'nqrptr' database with the command below:

  mysql -P3308 nqrptr

    2. Then update the 'settings' table with the queires below: 

 update settings set value='D:/CA/NFA' where name='installRoot';

 update settings set value='D:/CA/NFA/netflow/logs/dsaLoaderErrors-%04d-%02d-%02d.log' where name'logFile';

 

Validate you can access the NFA pages and that are you collecting data after these steps.