FortiSwitch
FortiSwitch: secure, simple and scalable Ethernet solutions
sachitdas_FTNT
Article Id 369088
Description

This article describes the Managed FortiSwitch configuration sync E flag due to an error reason: unable to find 'admin' in table 'system.admin'.

Scope FortiGate, Managed FortiSwitches.
Solution

FortiGate# exec switch-controller get-conn-status

S424EITF21xxxxxx v7.2.2 (419) Authorized/Up E 11.10.10.8 Mon Feb 20 19:47:08 2023

 

FortiGate# exec switch-controller get-sync-status all SWITCH (NAME) STATUS CONFIG MAC-SYNC HTTP-UPGRADE S424EITF21xxxxxx Up Error - - "error_reason":"unable to find 'admin' in table 'system.admin'"

 

The error occurs when the administrator deletes the admin account from the FortiSwitch. For example:

 

Login to FortiSwitch -> Create a new admin account and delete the original admin account.

 

FortiSwitch# config system admin
    edit "admin"
        set accprofile "super_admin"
        set password xxxxx
    next
    edit "superadmin"
        set accprofile "super_admin"
        set password yyyyy
    next
end

 

FortiSwitch#(admin) # delete admin

FortiSwitch#(admin) # end

 

Solution:

On the FortiGate, disable login password override:

 

FortiGate# config switch-controller switch-profile
    edit "default"
        set login-passwd-override disable
end