That the case, I have a fresh Ubuntu 10.10 Server install and I have follow the Proxylizer Installation Method 1 as indicated in the WIKI.
Step by step I have all the components working but Proxylizer is not processing data, after some debug I can see the /home/proxylizer/mysql.pipe is working OK
Code: Select all
cat /home/proxylizer/mysql.pipe
203.0.113.3 2010-11-18 10:02:57 192.168.133.160 GET http://m.facebook.com/ action=allow cache=MISS
203.0.113.3 2010-11-18 10:03:34 192.168.133.160 GET http://www.yahoo.com/ action=allow cache=MISS
203.0.113.3 2010-11-18 10:03:43 192.168.133.160 GET http://www.wikipedia.org/ action=allow cache=MISS
Code: Select all
tail webproxytodb_debug.log
2010-11-18 09:44 | Not valid web proxy log!!!
2010-11-18 09:44 | Not valid web proxy log!!!
2010-11-18 09:44 | Not valid web proxy log!!!
2010-11-18 09:44 | Not valid web proxy log!!!
Code: Select all
if ($rawlog['3'] == 'web-proxy,account') {
$host = ip2long($rawlog['0']);
list(, $host) = unpack('l', pack('l', $host));
if ($host === false) echo date("Y-m-d H:i | ") . "Invalid Host IP address";
$IP = eregIP($rawlog['4']);
if ($IP !== false) {
$IP = ip2long($rawlog['4']);
if ($IP !== false) {
list(, $IP) = unpack('l', pack('l', $IP));
parseURL($rawlog['6']);
parseDomain($fulldomain);
parseAction($rawlog['7']);
parseCache($line);
//echo "Action = {$action}\n";
//echo "Cache = {$cache}\n";
if(insertLine($db));
} else {
echo date("Y-m-d H:i | ") . "Invalid IP address!!!\n";
}
} else {
echo date("Y-m-d H:i | ") . "Invalid IP address!!!\n";
}
} else {
echo date("Y-m-d H:i | ") . "Not valid web proxy log!!!\n";
}
I can send you the VM image file and make the test you need.
Best regards
