Example for Router IP Address: 100.200.300.400
1 - Stop all NFA services on Harvester and NFA Console machines:
2 - Run the mysql backup on Command Prompt:
NFA Console machine:
mysqldump -P 3308 reporter > C:\CA\NFA\backup\reporter_backup.sql
Harvester machine:
mysqldump -P 3308 harvester > C:\CA\NFA\backup\harvester_backup.sql
3 - Queries do Delete from Harvester machine:
mysql
use harvester
select * from routers where inet6_ntoa(router)='100.200.300.400'; (Note the routerID)
select * from interfaces where inet6_ntoa(router)='100.200.300.400';
delete from routers where inet6_ntoa(router)='100.200.300.400';
delete from interfaces where inet6_ntoa(router)='100.200.300.400';
select * from persistent_map where routerid='x'; (Inform the routerID from first select)
delete from persistent_map where routerid='x';
update routers set PollState='InitialPoll', stateretry=0, reboottime=0 where PollState ='RebootRefresh';
NFA Console machine:
use reporter
select ID from routers where deviceName = '100.200.300.400'; (Note the routerID)
select * from interfaces where routerId = 'nnnnnnn'; (Inform the routerID from select above)
delete from routers where deviceName = '100.200.300.400';
delete from interfaces where routerId = 'nnnnnnn'; (Inform the routerID from select above)
4 - Start all NFA services on Harvester and NFA Console machines
5 - Wait 15 minutes to Validate