DMZ (Webserver) To Database Sever (Inside)

[GrantThomas]

Okay, as someone mentioned before I was going to have a problem with my ACL that allowed DMZ to access the Database server through port 1433. Right now everything is in place and working but the craziest thing happens in about 4hours of uptime the DMZ stops talking to the database server that is on the inside. Basically just want a proper config for the webserver on the DMZ to talk to the database server on the inside. Here is my final config, thanks!

web-pix# show config
: Saved
: Written by enable_15 at 23:31:07.705 UTC Fri Jan 1 1993
PIX Version 6.3(5)
interface ethernet0 auto
interface ethernet1 auto
interface ethernet2 auto
nameif ethernet0 outside security0
nameif ethernet1 inside security100
nameif ethernet2 DMZ security30
enable password XXXXX encrypted
passwd XXXXXXX encrypted
hostname web-pix
domain-name XXXXXX
fixup protocol dns maximum-length 512
no fixup protocol ftp 21
no fixup protocol h323 h225 1720
fixup protocol h323 ras 1718-1719
fixup protocol http 80
fixup protocol http 81
fixup protocol ils 389
fixup protocol pptp 1723
no fixup protocol rsh 514
no fixup protocol rtsp 554
no fixup protocol sip 5060
fixup protocol sip udp 5060
no fixup protocol skinny 2000
no fixup protocol smtp 25
no fixup protocol sqlnet 1521
fixup protocol tftp 69
names
access-list inbound permit tcp any host 24.x.x.211 eq www
access-list inbound permit tcp any host 24.x.x.211 eq https
access-list inbound permit udp any host 24.x.x.211 eq 443
access-list inbound permit tcp any host 24.x.x.212 eq www
access-list inbound permit tcp any host 24.x.x.212 eq https
access-list inbound permit udp any host 24.x.x.212 eq 443
access-list inbound permit tcp any host 24.x.x.213 eq www
access-list inbound permit tcp any host 24.x.x.213 eq https
access-list inbound permit udp any host 24.x.x.213 eq 443
access-list inbound permit tcp any host 24.x.x.222 eq pptp
access-list inbound permit tcp any host 24.x.x.214 eq 81
access-list dmz permit icmp any any
access-list dmz permit tcp any host 10.0.0.10 eq 1433
access-list dmz permit tcp 10.0.0.0 255.255.255.0 any eq www
access-list dmz permit tcp 10.0.0.0 255.255.255.0 any eq https
access-list dmz permit tcp 10.0.0.0 255.255.255.0 any eq smtp
access-list acl_grp permit tcp any any
access-list acl_grp permit udp any any
access-list acl_grp permit ip any any
pager lines 24
logging on
logging trap informational
mtu outside 1500
mtu inside 1500
mtu DMZ 1500
ip address outside 24.x.x.210 255.255.255.240
ip address inside 192.168.1.191 255.255.255.0
ip address DMZ 10.0.0.1 255.255.255.0
ip audit info action alarm
ip audit attack action alarm
pdm location 192.168.1.171 255.255.255.255 inside
pdm location 192.168.1.173 255.255.255.255 inside
pdm location 192.168.1.179 255.255.255.255 inside
pdm location 192.168.1.182 255.255.255.255 inside
pdm location 192.168.1.183 255.255.255.255 inside
pdm location 192.168.1.185 255.255.255.255 inside
pdm location 192.168.1.0 255.255.255.0 DMZ
pdm location 24.x.x.222 255.255.255.255 outside
pdm location 192.168.1.184 255.255.255.255 inside
pdm location 10.0.0.11 255.255.255.255 DMZ
pdm location 10.0.0.11 255.255.255.255 inside
pdm location 192.168.1.174 255.255.255.255 inside
pdm location 10.0.0.12 255.255.255.255 DMZ
pdm location 10.0.0.13 255.255.255.255 DMZ
pdm logging informational 100
pdm history enable
arp timeout 14400
global (outside) 1 interface
global (DMZ) 1 10.0.0.20-10.0.0.50 netmask 255.255.255.0
nat (inside) 1 0.0.0.0 0.0.0.0 0 0
nat (DMZ) 1 0.0.0.0 0.0.0.0 0 0
static (inside,outside) 24.x.x.222 192.168.1.182 netmask 255.255.255.255 0 0
static (inside,DMZ) 10.0.0.10 192.168.1.184 netmask 255.255.255.255 0 0
static (DMZ,outside) 24.x.x.211 10.0.0.11 netmask 255.255.255.255 0 0
static (DMZ,outside) 24.x.x.212 10.0.0.12 netmask 255.255.255.255 0 0
static (DMZ,outside) 24.x.x.213 10.0.0.13 netmask 255.255.255.255 0 0
static (DMZ,outside) 24.x.x.214 10.0.0.14 netmask 255.255.255.255 0 0
static (inside,DMZ) 10.0.0.9 192.168.1.174 netmask 255.255.255.255 0 0
static (inside,DMZ) 10.0.0.8 192.168.1.182 netmask 255.255.255.255 0 0
access-group inbound in interface outside
access-group dmz in interface DMZ
route outside 0.0.0.0 0.0.0.0 24.x.x.209 1
timeout xlate 3:00:00
timeout conn 1:00:00 half-closed 0:10:00 udp 0:02:00 rpc 0:10:00 h225 1:00:00
timeout h323 0:05:00 mgcp 0:05:00 sip 0:30:00 sip_media 0:02:00
timeout sip-disconnect 0:02:00 sip-invite 0:03:00
timeout uauth 0:05:00 absolute
aaa-server TACACS+ protocol tacacs+
aaa-server TACACS+ max-failed-attempts 3
aaa-server TACACS+ deadtime 10
aaa-server RADIUS protocol radius
aaa-server RADIUS max-failed-attempts 3
aaa-server RADIUS deadtime 10
aaa-server LOCAL protocol local
aaa-server authinbound protocol radius
aaa-server authinbound max-failed-attempts 3
aaa-server authinbound deadtime 10
aaa-server authinbound (outside) host 24.x.x.222 cisco timeout 5
http server enable
http 192.168.1.0 255.255.255.0 inside
http 192.168.1.173 255.255.255.255 inside
no snmp-server location
no snmp-server contact
snmp-server community public
no snmp-server enable traps
floodguard enable
sysopt connection permit-ipsec
sysopt connection permit-pptp
telnet 192.168.1.0 255.255.255.0 inside
telnet 192.168.1.0 255.255.255.0 DMZ
telnet timeout 5
ssh timeout 5
console timeout 0
vpdn group 1 accept dialin pptp
vpdn group 1 ppp authentication pap
vpdn group 1 ppp authentication chap
vpdn group 1 ppp authentication mschap
vpdn group 1 ppp encryption mppe 40
vpdn group 1 client configuration dns 192.168.1.173 192.168.1.177
vpdn group 1 client configuration wins 192.168.1.173
vpdn group 1 client authentication aaa authinbound
vpdn group 1 pptp echo 60
vpdn enable outside
terminal width 80

 

[BuckWeet]

It most likely has something to do with your NAT session timing out.. I see you have static entries for dmz to inside..

With newer code this is not needed and you should use Nat 0..
Using NAT 0 disables the nat functions and translations states are no longer worried about.


BuckWeet

 

[GrantThomas]

Give me an example im willing to try anything really. are you wanting me to use NAT 0 on the DMZ?
I tried clear xlate and local and local-host but still a no go.

 

[GrantThomas]

After some tweaking around, when it was down, I went to our database server and took out our other PIX firewall gateway since we have two, and it fixed the issue right away, but not 100% sure that was the main problem I guess Ill know by tomorrow sometime. If there is any other ideas please feel free to let me know. Thanks