Persistent Connections from database on Cisco Firewall

I've posted before about how our Cisco firewall tears down inactive connections and modifying the tcp_keepalive_time on the Linux kernel so as to not loose the connection. Similar options exist on the database side.

If you're running MySQL then update /etc/my.cnf to have:

wait_timeout=900

If you're running an Oracle then update sqlnet.ora to have:

SQLNET.EXPIRE_TIME=10

This option is in $ORACLE_HOME/network/admin/sqlnet.ora.

Cisco EOL List

I have found a handy list of End-of-Sale and End-of-Life Products from Cisco.

Published with Blogger-droid v1.7.4

persistent connections within cisco firewall

Our cisco firewall tears down old connections so I sometimes modify the kernel to send keep alives on tcp connections:

[root@server ~]# tail -2 /etc/sysctl.conf
# keep persistent connection (so firewall doesn't tear down)
net.ipv4.tcp_keepalive_time = 900
[root@server ~]#