How to cleanup bogus interfaces in NFA without losing data.
Article ID: 8513
Updated On:
Products
Issue/Introduction
If you had dual netflow configurations set (Flexible and Traditional), you may have a mess of bogus interfaces to clean up. The bogus interfaces look like below:
Environment
NFA 9.1+
Cause
This is an issue that needs to be resolved on the router configuration.
Resolution
Assuming the router configuration issue was already resolved, we can use this clean procedure. This procedure will cleanup bogus interfaces that came about for devices with SNMP connectivity only. If a device does not have an SNMP profile assigned, this procedure will not affect the device:
Starting in NFA 21.2.8, accessing the 'root' user in mysql now requires a password. By default, the root password is set to 'root@123'.
1. RDP to NFA harvester and open a CMD prompt and type in this exact order:
a. mysqldump -uroot -proot@123 harvester > C:/harvesterbackup4cleanup.sql
b. mysql -uroot -proot@123 harvester
c. delete p.* from persistent_map p inner join routers r on p.routerid=r.routerid where r.profileid!=0 and p.valid=0 and p.ifindex>1;
d. delete from interfaces;
2. Restart the CA NFA Harvester Service
3. RDP to NFA Console server and open a CMD prompt and type:
a. mysqldump -uroot -proot@123 reporter > C:/reporterbackup4cleanup.sql
b. mysql -uroot -proot@123 reporter
c. CREATE TABLE temprouters ( ID int(10) unsigned );
d. ALTER TABLE temprouters ADD PRIMARY KEY (ID);
e. Insert into temprouters (ID) select id from routers where profileid!=0;
f. DELETE FROM interfaces WHERE name like 'Interface %' and EXISTS (select id from temprouters where interfaces.routerid=temprouters.id);
g. Drop table temprouters;
h. DELETE FROM agent_definitions WHERE interfaceid NOT IN (SELECT id FROM interfaces);
Additional Information
Please contact CA Support if you have a device without SNMP connectivity that you need to clean up bogus interfaces.
Feedback
