TNS session helper and SQL*Net V1/V2

[Sylvia]

Hi, Has anybody of you set up a Fortigate configuration where SQL*Net V1 and/or V2 traffic is going through the Fortigate? A session helper named TNS (which should take care about dynamic ports of SQL*Net session) does exist in FortiOS v2.80, but has anybody make sure that this is really working? Which version is supported with the TNS session helper? Many thanks for feedbacks, Sylvia

[abelio]

Hi Sylvia, session-helper TNS could take care about SQL*Net v2 (1521/TCP); I understand that SQL*Net v1 uses 1525 as default destination port In any case, you could try adding this later one with the CLI and test if the whole thing is working. config system session-helper edit 15 <-- there are 14 pre-defined set name tns set port 1525 set protocol 6 end regards,