Guest User!

You are not Sophos Staff.

This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

XG125 : impossible to delete or disable default rune name "null"

Hi guys

I'm turning mad with this case

i can't disable this rule nor delete it - please see attached

maybe because its default name given by the system during the first assistant was "null" ?

how can i delete it via CLI ?



This thread was automatically locked due to age.
Parents
  • I have the same issue but on virtualized appliance. There is one firewall rule with name “NULL” and ID 1 that is not possible to rename, to modify, to disable or to delete.

    I cannot remember exactly what firmware version it was when the rule was getting created. But as it is ID 1 it must be one that was getting auto generated at the beginning during set-up. It is a LAN to WAN rule and so far, it was fine for me. All firmware updates I installed did not change the fact that the rule is not possible to edit. This still is the case in SFOS 16.05.7 MR-7.

    When I export the settings, I can see in chapter <SecurityPolicy> that this one rule has no name. Instead of <Name>xxxx</Name> there only is </Name> in the line.
    I also tried to edit manually the exported xml file and import again. But this only is adding a new rule and does not change the broken rule.

    What can I do?

    Any way to rename the rule via CLI or by editing any config file directly OS level?
    Or any way to edit the backup file?

  • Meanwhile I figured out by myself how to fix it.

    I changed the name in SQL database directly via command line interface.

     

    Sophos XG console
    --> 5 device managmeent
    --> 3 Advanced shell

    psql -U nobody -d corporate

    UPDATE tblfirewallrule
    SET name = 'new_name'
    WHERE
    name IS NULL;

    \q

    This might be not the most elegant way how to use SQL command but it worked as there only was one rule with empty name (NULL).

     

     

Reply
  • Meanwhile I figured out by myself how to fix it.

    I changed the name in SQL database directly via command line interface.

     

    Sophos XG console
    --> 5 device managmeent
    --> 3 Advanced shell

    psql -U nobody -d corporate

    UPDATE tblfirewallrule
    SET name = 'new_name'
    WHERE
    name IS NULL;

    \q

    This might be not the most elegant way how to use SQL command but it worked as there only was one rule with empty name (NULL).

     

     

Children
No Data