RE: [squid-users] Tiered Squid proxy issue (Microsoft JET Database Engine error '80040e57'

Thanks for the response. According to Websense, they only suppor 2.5x. :(

Also, I will contact the site owner now and ask about this issue.

Here are the headers using the Firefox Live Headers plugin. I'm not sure what it means, but I have the POST setting set to ACCURATE.

This is when it doesn't work (going through a POP proxy v2.5 then up through our top level proxy v2.7):

---
http://site463.mysite4now.net/mrengmal/gm/forum/login.asp
POST http://site463.mysite4now.net/mrengmal/gm/forum/login.asp HTTP/1.1
Host: site463.mysite4now.net
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.11) Gecko/2009060200 SUSE/3.0.11-0.1.1 Firefox/3.0.11
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en-us,en;q=0.5
Accept-Encoding: gzip,deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive: 300
Proxy-Connection: keep-alive
Referer: http://site463.mysite4now.net/mrengmal/gm/forum/login.asp?target=default.asp
Cookie: Snitz00User=; ASPSESSIONIDQCASABDC=KHNDCKLCEEENIEDJCADGOLAD; ASPSESSIONIDQCBTBBCC=FDFFFLLCCDKFBDLJOOPELEMD; ASPSESSIONIDSABQCACC=GKKNJOLCAMCFDIELLEDGIHLB; ASPSESSIONIDQABSCCAC=PMAPIPLCFECHCPDDNEBCPDAH; ASPSESSIONIDSCBSCDBC=JKIDMAMCKODFGGNAMIOKAHDK
Content-Type: application/x-www-form-urlencoded
Content-Length: 101
target=default.asp&Name=student&submit1.x=33&submit1.y=5&submit1=Login&Password=ssw&SavePassWord=true
HTTP/1.0 500 Internal Server Error
Date: Thu, 18 Feb 2010 18:08:15 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 5339
Content-Type: text/html
Set-Cookie: Snitz00User=Pword=80fef94b3945d30bd0adf30fa9915276881765b719c14f7ffa29f1128f11c1f9&Name=student; expires=Sat, 20-Mar-2010 20:08:14 GMT; path=/
Cache-Control: private
X-Cache: MISS from dss-cs99lv03-a, MISS from proxy-mon.dss.la.gov
Via: 1.1 dss-cs99lv03-a:8080 (squid/2.7.STABLE6)
X-Cache-Lookup: MISS from proxy-mon.dss.la.gov:8080
Proxy-Connection: close
----------------------------------------------------------
-----
This is when it does work going directly through a top level proxy (v2.7)
---
http://site463.mysite4now.net/mrengmal/gm/forum/login.asp
POST http://site463.mysite4now.net/mrengmal/gm/forum/login.asp HTTP/1.1
Host: site463.mysite4now.net
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.11) Gecko/2009060200 SUSE/3.0.11-0.1.1 Firefox/3.0.11
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en-us,en;q=0.5
Accept-Encoding: gzip,deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive: 300
Proxy-Connection: keep-alive
Referer:
http://site463.mysite4now.net/mrengmal/gm/forum/login.asp?target=default.asp
Cookie: Snitz00User=; ASPSESSIONIDQCASABDC=KHNDCKLCEEENIEDJCADGOLAD;
ASPSESSIONIDQCBTBBCC=FDFFFLLCCDKFBDLJOOPELEMD;
ASPSESSIONIDSABQCACC=GKKNJOLCAMCFDIELLEDGIHLB;
ASPSESSIONIDQABSCCAC=PMAPIPLCFECHCPDDNEBCPDAH;
ASPSESSIONIDSCBSCDBC=JKIDMAMCKODFGGNAMIOKAHDK
Content-Type: application/x-www-form-urlencoded
Content-Length: 101
target=default.asp&Name=student&submit1.x=20&submit1.y=8&submit1=Login&Password=ssw&SavePassWord=true
HTTP/1.0 200 OK
Date: Thu, 18 Feb 2010 18:10:48 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 6646
Content-Type: text/html
Set-Cookie:
Snitz00User=Pword=80fef94b3945d30bd0adf30fa9915276881765b719c14f7ffa29f1128f11c1f9&Name=student;
expires=Sat, 20-Mar-2010 20:10:46 GMT; path=/
Cache-Control: private
X-Cache: MISS from dss-cs99lv02-a
Via: 1.1 dss-cs99lv02-a:8080 (squid/2.7.STABLE6)
Connection: keep-alive
Proxy-Connection: keep-alive
----------------------------------------------------------
http://site463.mysite4now.net/mrengmal/gm/forum/default.asp
GET http://site463.mysite4now.net/mrengmal/gm/forum/default.asp HTTP/1.1
Host: site463.mysite4now.net
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.11) Gecko/2009060200 SUSE/3.0.11-0.1.1 Firefox/3.0.11
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en-us,en;q=0.5
Accept-Encoding: gzip,deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive: 300
Proxy-Connection: keep-alive
Cookie:
Snitz00User=Pword=80fef94b3945d30bd0adf30fa9915276881765b719c14f7ffa29f1128f11c1f9&Name=student;
ASPSESSIONIDQCASABDC=KHNDCKLCEEENIEDJCADGOLAD;
ASPSESSIONIDQCBTBBCC=FDFFFLLCCDKFBDLJOOPELEMD;
ASPSESSIONIDSABQCACC=GKKNJOLCAMCFDIELLEDGIHLB;
ASPSESSIONIDQABSCCAC=PMAPIPLCFECHCPDDNEBCPDAH;
ASPSESSIONIDSCBSCDBC=JKIDMAMCKODFGGNAMIOKAHDK
HTTP/1.0 200 OK
Date: Thu, 18 Feb 2010 18:10:50 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 17878
Content-Type: text/html
Cache-Control: private
X-Cache: MISS from dss-cs99lv02-a
Via: 1.1 dss-cs99lv02-a:8080 (squid/2.7.STABLE6)
Connection: keep-alive
Proxy-Connection: keep-alive
----------------------------------------------------------
Does anything stick out?
Ryan McCain
Northrop Grumman Corporation
Email: ryan.mccain_at_la.gov
Phone: 225.505.3832
Registered Linux User #364609
-----Original Message-----
From: Henrik Nordstr�m [mailto:henrik_at_henriknordstrom.net] 
Sent: Thursday, February 18, 2010 4:37 AM
To: Ryan McCain
Cc: 'squid-users_at_squid-cache.org'
Subject: Re: [squid-users] Tiered Squid proxy issue (Microsoft JET Database Engine error '80040e57'
tor 2010-02-11 klockan 11:22 -0600 skrev Ryan McCain:
> We are using Squid 2.5 on SLES for compatibility reasons with a redirector we use at the POP level , Websense.  Websebse doesn't support 2.7 or 3.x.
Any external helpers (url rewriters, auth etc) which works with 2.5 also works in later releases.
> Anyways, if you go to http://www.garymallon.com --> COURSES --> DISCUSSION BOARD then login with:
> User: student
> Pw: ssw
> 
> I get the following error:
> 
> Microsoft JET Database Engine error '80040e57' 
> 
> The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. 
> 
> /mrengmal/gm/forum/inc_func_common.asp, line 585
This is difficult to answer without knowing the web server application.
Have you tried talking to the maintainers of that forum?
A guess is that they are storing the X-Forwarded-For header in their database for tracking purposes and have assigned to small field with for storing that..
Regards
Henrik