function CICAPEnableSquidGuardSave()
{
$q = new mysql_squid_builder();
$sock = new sockets();
$q->CheckTablesICAP();
$sock->SET_INFO("CICAPEnableSquidGuard", $_POST["CICAPEnableSquidGuard"]);
if ($_POST["CICAPEnableSquidGuard"] == 1) {
$q->QUERY_SQL("UPDATE c_icap_services SET enabled=1,zOrder=3 WHERE ID=12");
} else {
$q->QUERY_SQL("UPDATE c_icap_services SET enabled=0 WHERE ID=12");
}
}
function CicapEnabled()
{
$sock = new sockets();
$q = new mysql_squid_builder();
$q->CheckTablesICAP();
$EnableClamavInCiCap = $sock->GET_INFO("EnableClamavInCiCap");
if (!is_numeric($EnableClamavInCiCap)) {
$EnableClamavInCiCap = 1;
}
if ($_POST["CicapEnabled"] == 1) {
if ($EnableClamavInCiCap == 1) {
$q->QUERY_SQL("UPDATE c_icap_services SET enabled=1,zOrder=1 WHERE ID=1");
$q->QUERY_SQL("UPDATE c_icap_services SET enabled=1,zOrder=2 WHERE ID=2");
}
} else {
$q->QUERY_SQL("UPDATE c_icap_services SET enabled=0 WHERE ID=1");
$q->QUERY_SQL("UPDATE c_icap_services SET enabled=0 WHERE ID=2");
}
$sock->SET_INFO("CicapEnabled", $_POST["CicapEnabled"]);
}
function enable_icap()
{
$unix = new unix();
$pidfile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".pid";
$pid = $unix->get_pid_from_file($pidfile);
if ($unix->process_exists($pid, basename(__FILE__))) {
echo basename(__FILE__) . ":Already executed pid {$pid}.. aborting the process\n";
progress("{failed}", 110);
return;
}
$sock = new sockets();
$sock->SET_INFO("kavicapserverEnabled", 1);
$MEM = $unix->MEM_TOTAL_INSTALLEE();
if ($unix->MEM_TOTAL_INSTALLEE() < 624288) {
$sock->SET_INFO("kavicapserverEnabled", 0);
if ($GLOBALS["OUTPUT"]) {
echo "Not enough memory - {$MEM}\n";
}
progress("{failed}", 110);
return;
}
$q = new mysql_squid_builder();
progress("{verify_icap_center}", 10);
$q->CheckTablesICAP();
if ($q->COUNT_ROWS("c_icap_services") == 0) {
progress("{verify_icap_center} {failed}", 110);
}
progress("{hooking_local_service}", 10);
$q->QUERY_SQL("UPDATE c_icap_services SET `enabled`=1 WHERE ID=6");
if (!$q->ok) {
echo $q->mysql_error . "\n";
progress("{hooking_local_service} {failed}", 110);
}
$q->QUERY_SQL("UPDATE c_icap_services SET `enabled`=1 WHERE ID=5");
if (!$q->ok) {
echo $q->mysql_error . "\n";
progress("{hooking_local_service} {failed}", 110);
}
progress("{reloading} {APP_KAV4PROXY}", 20);
build();
system("/etc/init.d/kav4proxy reload");
progress("{configuring} {APP_SQUID}", 50);
$php = $unix->LOCATE_PHP5_BIN();
system("{$php} /usr/share/artica-postfix/exec.squid.php --build --force --noverifcaches");
progress("{restarting} {APP_SQUID}", 70);
system("/etc/init.d/squid restart --force {$GLOBALS["SCRIPT_SUFFIX"]}");
progress("{restarting} Artica-status", 80);
system("/etc/init.d/artica-status restart --force");
progress("{refresh} License", 90);
$GLOBALS["FORCE"] = true;
license_infos(true);
progress("{success} {hooking_local_service}", 100);
}
function search()
{
$tpl = new templates();
$MyPage = CurrentPageName();
$q = new mysql_squid_builder();
$STATUS_ARRAY[0] = "32-green-grey.png";
$STATUS_ARRAY[1] = "32-green.png";
$STATUS_ARRAY[2] = "32-red.png";
$STATUS_ARRAY[3] = "warning32.png";
$t = $_GET["t"];
$search = '%';
$table = "c_icap_services";
$page = 1;
$FORCE_FILTER = 1;
$total = 0;
if (isset($_GET["OnlyActive"])) {
if ($_GET["OnlyActive"] == 1) {
$FORCE_FILTER = "`enabled`=1";
}
}
$q->CheckTablesICAP();
if (isset($_POST["sortname"])) {
if ($_POST["sortname"] != null) {
$ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";
}
}
if (isset($_POST['page'])) {
$page = $_POST['page'];
}
$searchstring = string_to_flexquery();
if ($searchstring != null) {
$search = $_POST["query"];
$sql = "SELECT COUNT(*) as TCOUNT FROM `{$table}` WHERE {$FORCE_FILTER} {$searchstring}";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql));
$total = $ligne["TCOUNT"];
} else {
$sql = "SELECT COUNT(*) as TCOUNT FROM `{$table}` WHERE {$FORCE_FILTER}";
$ligne = mysql_fetch_array($q->QUERY_SQL($sql));
$total = $ligne["TCOUNT"];
}
if (isset($_POST['rp'])) {
$rp = $_POST['rp'];
}
$pageStart = ($page - 1) * $rp;
if (!is_numeric($rp)) {
$rp = 50;
}
$limitSql = "LIMIT {$pageStart}, {$rp}";
$sql = "SELECT * FROM `{$table}` WHERE {$FORCE_FILTER} {$searchstring} {$ORDER} {$limitSql}";
$results = $q->QUERY_SQL($sql);
writelogs($sql . " ==> " . mysql_num_rows($results) . " items", __FUNCTION__, __FILE__, __LINE__);
$data = array();
$data['page'] = $page;
$data['total'] = $total + 1;
$data['rows'] = array();
if (!$q->ok) {
json_error_show($q->mysql_error, 1);
}
$fontsize = 22;
while ($ligne = mysql_fetch_assoc($results)) {
$CountDeMembers = 0;
$color = "black";
if ($ligne["enabled"] == 0) {
$color = "#8a8a8a";
}
$style = "style='font-size:{$fontsize}px;color:{$color};'";
$delete = imgsimple("delete-32.png", null, "Loadjs('{$MyPage}?service-delete-js=yes&ID={$ligne["ID"]}&t={$t}');");
$bypass = "******";
$js = "<a href=\"javascript:blur();\" OnClick=\"javascript:Loadjs('{$MyPage}?service-js=yes&ID={$ligne["ID"]}&t={$t}');\"\n\t\tstyle='font-size:{$fontsize}px;color:{$color};text-decoration:underline'>";
if ($ligne["ID"] < 20) {
$delete = " ";
}
$up = imgsimple("arrow-up-32.png", null, "Loadjs('{$MyPage}?move-item-js=yes&ID={$ligne["ID"]}&dir=0&t={$_GET["t"]}')");
$down = imgsimple("arrow-down-32.png", null, "Loadjs('{$MyPage}?move-item-js=yes&ID={$ligne["ID"]}&dir=1&t={$_GET["t"]}')");
if (intval($ligne["bypass"]) > 0) {
$ligne["bypass"] = 1;
}
if ($ligne["bypass"] == 1) {
$bypass = "******";
}
$data['rows'][] = array('id' => $ligne['ID'], 'cell' => array("<span {$style}>{$js}{$ligne["zOrder"]}</a></span>", "<span {$style}>{$js}{$ligne["service_name"]}</a></span>", "<span {$style}>{$js}{$ligne["ipaddr"]}:{$ligne["listenport"]}</span>", "<span {$style}>{$js}{$ligne["respmod"]}</span>", "<center {$style}>{$js}{$bypass}</center>", "<center {$style}>{$up}</center>", "<center {$style}>{$down}</center>", "<center {$style}>{$delete}</center>", "<center {$style}>" . imgsimple($STATUS_ARRAY[$ligne["status"]]) . "</center>"));
}
echo json_encode($data);
}
function C_ICAP_CLIENTS($aspid = false)
{
$unix = new unix();
$PidFile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".pid";
if (!$aspid) {
$pid = $unix->get_pid_from_file($PidFile);
if ($unix->process_exists($pid, basename(__FILE__))) {
$TimeMin = $unix->PROCCESS_TIME_MIN($pid);
return;
}
}
@file_put_contents($PidFile, getmypid());
$cicap_client = $unix->find_program("c-icap-client");
if (!is_file($cicap_client)) {
return;
}
$q = new mysql_squid_builder();
$q->QUERY_SQL("UPDATE c_icap_services SET `status`=0 WHERE `enabled`=0");
$q->CheckTablesICAP();
$sql = "SELECT * FROM c_icap_services WHERE enabled=1";
$results = $q->QUERY_SQL($sql);
if (mysql_num_rows($results) == 0) {
return;
}
$METHODS["reqmod_precache"] = "REQMOD";
$METHODS["respmod_precache"] = "RESPMOD";
while ($ligne = mysql_fetch_assoc($results)) {
$service_name_text = $ligne["service_name"];
$ID = $ligne["ID"];
$addr = $ligne["ipaddr"];
$port = $ligne["listenport"];
$service = $ligne["icap_server"];
$cmdline = "{$cicap_client} -i {$addr} -p {$port} -s {$service} -method {$METHODS[$ligne["respmod"]]} 2>&1";
if ($GLOBALS["VERBOSE"]) {
echo $cmdline . "\n";
}
$Mresults = array();
$FINAL = true;
exec($cmdline, $Mresults);
echo @implode("\n", $Mresults);
$HEADER_LOG = "{$addr}:{$port}/{$service} ({$METHODS[$ligne["respmod"]]})";
$FOUND = false;
while (list($index, $line) = each($Mresults)) {
if (preg_match("#200 OK#i", $line)) {
$FINAL = true;
$FOUND = true;
break;
}
if (preg_match("#404 Service not found#i", $line)) {
$FINAL = false;
$FOUND = true;
break;
}
if (preg_match("#Failed to connect#i", $line)) {
$FINAL = false;
$FOUND = true;
break;
}
}
if (!$FOUND) {
squid_admin_mysql(1, "Unknown ICAP {$service} for {$HEADER_LOG}", @implode("\n", $Mresults), __FILE__, __LINE__);
$q->QUERY_SQL("UPDATE c_icap_services SET `status`=3 WHERE ID={$ID}");
continue;
}
if (!$FINAL) {
squid_admin_mysql(0, "ICAP {$service} FAILED for {$HEADER_LOG}", @implode("\n", $Mresults), __FILE__, __LINE__);
$q->QUERY_SQL("UPDATE c_icap_services SET `status`=2 WHERE ID={$ID}");
continue;
}
$q->QUERY_SQL("UPDATE c_icap_services SET `status`=1 WHERE ID={$ID}");
}
}
function checkdatabase()
{
$f["webfilter_aclsdynamic"] = true;
$f["webfilter_aclsdynlogs"] = true;
$f["webfilter_assoc_groups"] = true;
$f["webfilter_avwhitedoms"] = true;
$f["webfilter_bannedexts"] = true;
$f["webfilter_bannedextsdoms"] = true;
$f["webfilter_blkcnt"] = true;
$f["webfilter_blkgp"] = true;
$f["webfilter_blklnk"] = true;
$f["webfilter_blks"] = true;
$f["webfilter_certs"] = true;
$f["webfilter_dnsbl"] = true;
$f["webfilter_group"] = true;
$f["webfilter_members"] = true;
$f["webfilter_rules"] = true;
$f["webfilter_terms"] = true;
$f["webfilter_termsassoc"] = true;
$f["webfilter_termsg"] = true;
$f["webfilter_ufdbexpr"] = true;
$f["webfilter_ufdbexprassoc"] = true;
$f["webfilter_updateev"] = true;
$f["webfilters_backupeddbs"] = true;
$f["webfilters_bigcatzlogs"] = true;
$f["webfilters_blkwhlts"] = true;
$f["webfilters_categories_caches"] = true;
$f["webfilters_databases_disk"] = true;
$f["webfilters_dbstats"] = true;
$f["webfilters_dtimes_blks"] = true;
$f["webfilters_dtimes_rules"] = true;
$f["webfilters_ipaddr"] = true;
$f["webfilters_nodes"] = true;
$f["webfilters_quotas"] = true;
$f["webfilters_rewriteitems"] = true;
$f["webfilters_rewriterules"] = true;
$f["webfilters_schedules"] = true;
$f["webfilters_sqaclaccess"] = true;
$f["webfilters_sqacllinks"] = true;
$f["webfilters_sqacls"] = true;
$f["webfilters_sqaclsports"] = true;
$f["webfilters_sqgroups"] = true;
$f["webfilters_sqitems"] = true;
$f["webfilters_sqtimes_assoc"] = true;
$f["webfilters_sqtimes_rules"] = true;
$f["webfilters_thumbnails"] = true;
$f["webfilters_updates"] = true;
$f["webfilters_usersasks"] = true;
$f["websites_caches_params"] = true;
$q = new mysql_squid_builder();
if (!$q->TestingConnection()) {
echo "Starting......: " . date("H:i:s") . " [MYSQL]: Connection failed...\n";
return;
}
$build = false;
while (list($tablename, $DGRULE) = each($f)) {
if (!$q->TABLE_EXISTS($tablename)) {
echo "Starting......: " . date("H:i:s") . " [MYSQL]: Missing table `{$tablename}`\n";
$build = true;
}
}
if ($build) {
echo "Starting......: " . date("H:i:s") . " [MYSQL]: Construct database\n";
$q->CheckTables(null, true);
$q->CheckTablesICAP();
}
}
function checktables()
{
$q = new mysql_squid_builder();
$q->CheckTables();
$q->CheckTablesICAP();
}