Hello,
Suddenly (from one day to another!) my Excel files containing web queries stopped with a message that Can’t reach Internet, Page not available and other sort of messages indicating a network problem.
After going in Control Panel, Internet Options, LAN Settings and removed the Automatically detect settings, everything works file, (transparent proxy is still on but because destinations are HTTPS, these don’t get caught)
Here are my DHCP settings and my wpad.dat file - very straight forward to send my Blue clients through proxy
function FindProxyForURL(url, host)
{
if (
(isPlainHostName(host)) ||
(isInNet(host, "127.0.0.1", "255.0.0.0")) ||
(isInNet(host, "192.168.GREEN.0", "255.255.255.0")) ||
(isInNet(host, "192.168.BLUE.0", "255.255.255.0")) ||
(isInNet(host, "192.168.GREEN.0", "255.255.255.0")) ||
(isInNet(host, "169.254.0.0", "255.255.0.0"))
)
return "DIRECT";
else
if (
(isInNet(myIpAddress(), "192.168.GREEN.0", "255.255.255.0")) ||
(isInNet(myIpAddress(), "192.168.VLAN1.0", "255.255.255.0")) ||
(isInNet(myIpAddress(), "192.168.VLAN2.0", "255.255.255.0"))
)
return "PROXY 192.168.GREEN.x:800";
else
if (
(isInNet(myIpAddress(), "192.168.BLUE.0", "255.255.255.0"))
)
return "PROXY 192.168.BLUE.y:800";
}
While Internet Explorer LAN Settings use Automatic Detect settings I get such messages for ANY page I try to access. Example for Xe Currency Converter - Live Exchange Rates Today
There is not a singe error message in /var/log/messages
. And all blocks from /var/log/squidGuard/urlfilter.log
are NOT for the forex pages I tried
And, to make thing more confusing, SQUID logs shows me ONLY 200 answers I got when opening the page in Browser - or at least this is what I think (that only Browser access got logged while Excel Web Query did not)!!!
cat /var/log/squid/access.log | grep onlinetrading-fx.com
1659254757.499 518 192.168.11.15 TCP_MISS/200 5953 GET http://www.onlinetrading-fx.com/en/saxobank.htm - HIER_DIRECT/50.87.253.35 text/html
1659254757.742 190 192.168.11.15 TCP_MISS/200 6734 GET http://www.onlinetrading-fx.com/Template1_files/logo2.jpg - HIER_DIRECT/50.87.253.35 image/jpeg
1659254758.050 447 192.168.11.15 TCP_MISS/200 7707 GET http://www.onlinetrading-fx.com/en/bg1.gif - HIER_DIRECT/50.87.253.35 text/html
1659254758.266 189 192.168.11.15 TCP_MISS/200 1240 GET http://www.onlinetrading-fx.com/favicon.ico - HIER_DIRECT/50.87.253.35 image/x-icon
1659254767.583 376 192.168.11.15 TCP_MISS/200 1230 GET http://www.onlinetrading-fx.com/currencyrates.html - HIER_DIRECT/50.87.253.35 text/html
1659254767.827 194 192.168.11.15 TCP_MISS/200 1485 GET http://www.onlinetrading-fx.com/1140161191_1526_easy_forex_site/ef_files/forex.css - HIER_DIRECT/50.87.253.35 text/css
1659254768.008 372 192.168.11.15 TCP_MISS/200 2210 GET http://www.onlinetrading-fx.com/1140161191_1526_easy_forex_site/ef_files/rates_02.gif - HIER_DIRECT/50.87.253.35 image/gif
Where should I look to find what is wrong with proxy? Again, transparent proxy is ON but since this is and HTTPS destination this does not get caught.
URL filter Settings: