Skip to main content
Esteemed Contributor III
March 7, 2021

Troubleshooting Tip: 'Duplicated IP address' error after deleting and adding a unit to the topology

Description

 

This article describes how to fix the error message 'Duplicated IP address' when a unit is deleted from topology view and try to add it again.

 

Scope

 

FortiNAC.

Solution

 

When adding a new device inside the FortiNAC Network-Inventory container, the following error may appear:

 

Untitled1.png

To confirm this issue, run the following command on the FortiNAC CLI:

 

mysql bsc -e "select name,id,type,description from ELEMENTS where request='192.168.1.1'"

 

The output may show a lot of information from the database that is not relevant.

 

To fix this issue, it may be necessary to remove this device:

 

  1. Back up the DB or take a snapshot of the VM.
  2. Run the following command in the CLI:

mysql bsc -e "delete from ELEMENTS where request='192.168.1.1'"

 

After the device is deleted, add it again in the inventory.

Thought Leadership. Security Summit. Thursday, November 12th, PGA National Resort, Palm Beach Gardens, FL.
Thought Leadership. Security Summit. Thursday, October 8th. Disney's Grand Californian Hotel & SPA, Anaheim, CA.
Security Operations Summit: Modernize SecOps. Operate AI-Native.AMER: November 4 | 9:00 AM PST. India and SAARC: November 5 | 10:00 AM IST. EMEA: November 5 | 10:30 AM CET. APAC: November 5 | 11:00 AM SGT