Managing NATs from command ilne

Goldy_01,

officially there is no way to delete NAT from cli. You can delete NAT from UI.

Regards

Are you using V18 or V17.5? 

You could easily deactivate the NAT rule via CLI (Postgres Command). 

Are you using V18 or V17.5? 

You could easily deactivate the NAT rule via CLI (Postgres Command). 

Ver 18.

What would be the command?

Thanks...

Goldy_01:

to print the current NAT rules:

psql -U nobody -d corporate -c "select * from tblnatrule" from advanced shell

Write-down the ID of the rule you want to delete and then:

psql -U nobody -d corporate -c "DELETE FROM tblnatrule WHERE ID = 2"

You should receive DELETED=1.

In my case I deleted ID = 2.

Run the first command to confirm the entry have been deleted correctly.

Regards

You can also use the API to delete a NATRule, in this example the rule "Test":

<Request>
<Login>
<Username>admin</Username>
<Password passwordform='encrypt'>#encr_password#</Password>
</Login>
<Remove>
<NATRule>
<name>Test</name>
</NATRule>
</Remove>
</Request>

Cheers,

Ben

Thanks To everybody.

Back in Astaro days, i opened a thread call "Astro useful commands" (Called later Sophos usefull commands) which was very popular.

It would be great if someone would do the same with the XG.

I'm sure it will be very useful for all of us...

It was/is a User managed Thread, feel free to continue / start such a thread for XG as well. 

There is a small section in community: https://community.sophos.com/products/xg-firewall/f/recommended-reads

Well, isn't it all what this about?

A one community helping each other?
I'm sure that by this we are all gaining something - users and XG developers alike.

[:)]

Lucar's answer is not very helpful.

Since during these years I collected several XG commands, I will create a thread with all commands.

Regards

would be great for all of us.

If you could call it "XG usefull commands" (So it will easy to find) it would be great [:D].

I'm sure by the time it will grow.

Thank Uuuuuuuuuuuuuu