topic Hi in Network Security

ASA TCP connection timeout for database

Mokhalil82 — Tue, 12 Mar 2019 07:12:24 GMT

I have a new database which is access via the firewall. After 5 minutes of inactivity it times outs. I am wondering whether this is due to the TCP connection timing out although I have not configured anything on the firewall to timeout the connections. I do have other databases accessed via the firewall and this does not affect any others.

Has anyone else experienced anything similar

What's in the ASA-Log when

Karsten Iwen — Thu, 28 Jan 2016 12:46:34 GMT

What's in the ASA-Log when the session dies?

Hi

ispatel — Thu, 28 Jan 2016 14:11:24 GMT

I think it might be database application, which might be causing connection after 5 minutes of inactivity.

You can use wireshak captures on client or server to check if client or server is sending TCP-FIN or TCP-RST packet.

You can use “show run all timeout” command to check timeout settings on your ASA.

Default timeout for TCP connection is 60 minutes.

Thanks for the help guys

Mokhalil82 — Thu, 04 Feb 2016 07:58:25 GMT

Thanks for the help guys

It turned out it was a local database setting causing the connection to timeout. After doing packet traces I found the traffic did not even hit the firewall. Its a funny network setup. Everyone likes to blame the network in the first instance 🙂

"Oh there's a water leak, it must be the network"

> Everyone likes to blame the

Karsten Iwen — Thu, 04 Feb 2016 15:47:34 GMT

> Everyone likes to blame the network in the first instance 🙂
> "Oh there's a water leak, it must be the network"

That's something that will never change ... 😉