$unix=new unix();

$free=$unix->find_program("free");

exec("$free -m 2>&1",$results);

while (list ($num, $ligne) = each ($results) ){

if(preg_match("#Mem:\s+([0-9]+)#", $ligne,$re)){

return $re[1];

}

}

return 0;

$unix=new unix();

$free=$unix->find_program("free");

exec("$free -m 2>&1",$results);

while (list ($num, $ligne) = each ($results) ){

if(preg_match("#Swap:\s+([0-9]+)#", $ligne,$re)){

return $re[1];

}

}

return 0;

$q=new mysql_squid_builder();

print_r($q->MEMORY_TABLES_LIST());

$GLOBALS["NOPID"]=true;

$GLOBALS["OUTPUT"]=true;

stop();

@unlink("/opt/squidsql/share/mysql/english/errmsg.sys");

start(true);

$unix=new unix();

$mysql_upgrade=$unix->find_program("mysql_upgrade");

echo "Starting......: ".date("H:i:s")." **************************\n";

echo "Starting......: ".date("H:i:s")." [INIT]: Running upgrade $mysql_upgrade....\n";

echo "Starting......: ".date("H:i:s")." **************************\n";

shell_exec("$mysql_upgrade -u root -S /var/run/mysqld/squid-db.sock --verbose");

stop();

start(false);

$f[]="/usr/share/mysql/english/errmsg.sys";

while (list ($num, $ligne) = each ($f) ){

if(is_file($ligne)){return $ligne;}

}

$q=new mysql_squid_builder();

$q->CheckTables();

$q->CheckTablesICAP();

$unix=new unix();

$mysqld=$unix->find_program("mysqld");

exec("$mysqld --help --verbose 2>&1",$results);

while (list ($key, $valueN) = each ($results) ){

if(preg_match("#--([a-z\-\_\=]+)\s+(.+)#", $valueN,$re)){

$key=trim($re[1]);

$value=trim($re[2]);

$array["--$key"]=true;

}

}

return $array;

$WORKDIR="/opt/squidsql";

$f[]="host.frm";

$f[]="host.MYD";

$f[]="host.MYI";

$f[]="servers.frm";

$f[]="servers.MYD";

$f[]="servers.MYI";

while (list ($key, $filename) = each ($results) ){

if(!is_file("$WORKDIR/mysql/$filename")){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: copy /var/lib/mysql/mysql/$filename $WORKDIR/mysql/$filename\n";}

@copy("/var/lib/mysql/mysql/$filename $WORKDIR/mysql/$filename");

}

}

$pidfile="/etc/artica-postfix/pids/squiddbstats.pid";

$unix=new unix();

$pid=$unix->get_pid_from_file($pidfile);

$sock=new sockets();

if($unix->process_exists($pid,basename(__FILE__))){

$time=$unix->PROCCESS_TIME_MIN($pid);

return;

}

$Socket="/var/run/mysqld/squid-db.sock";

$mysqladmin=$unix->find_program("mysqladmin");

$cmdline="$mysqladmin -S $Socket -u root status 2>&1";

if($GLOBALS["VERBOSE"]){echo "$cmdline\n";}

exec($cmdline,$results);

$date=date("Y-m-d H:i:s");

if(!preg_match("#Uptime:\s+([0-9]+)\s+Threads:\s+([0-9]+)\s+Questions:\s+([0-9]+)\s+Slow queries:\s+([0-9]+)\s+Opens:\s+([0-9]+)\s+Flush tables:\s+([0-9]+)\s+Open tables:\s+([0-9]+)\s+ Queries per second avg:\s+([0-9]+)#",@implode("", $results),$re)){

if($GLOBALS["VERBOSE"]){echo @implode("", $results)." no match..\n";}

return;

}

$sql="CREATE TABLE IF NOT EXISTS `MySQLStats` (

`zDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

`uptime` BIGINT UNSIGNED NOT NULL,

`threads` BIGINT(10) NOT NULL,

`questions` BIGINT UNSIGNED NOT NULL,

`squeries` BIGINT(10) NOT NULL,

`opens` BIGINT UNSIGNED NOT NULL,

`ftables` BIGINT(20) NOT NULL,

`open` BIGINT(10) NOT NULL,

`queriesavg` BIGINT UNSIGNED NOT NULL,

UNIQUE KEY `zDate` (`zDate`),

KEY `uptime` (`uptime`),

KEY `threads` (`threads`),

KEY `questions` (`questions`),

KEY `squeries` (`squeries`),

KEY `opens` (`opens`),

KEY `ftables` (`ftables`),

KEY `open` (`open`),

KEY `queriesavg` (`queriesavg`)

)";

$q=new mysql_squid_builder();

$q->QUERY_SQL($sql);

if(!$q->ok){

if($GLOBALS["VERBOSE"]){echo $sql."\n$q->mysql_error\n";}

return;}

$sql="INSERT IGNORE INTO MySQLStats (zDate,uptime,threads,questions,squeries,opens,ftables,open,queriesavg)

VALUES('$date','{$re[1]}','{$re[2]}','{$re[3]}','{$re[4]}','{$re[5]}','{$re[6]}','{$re[7]}','{$re[8]}')";

$q->QUERY_SQL($sql);

if(!$q->ok){

if($GLOBALS["VERBOSE"]){

echo $sql."\n$q->mysql_error\n";}

}

if($GLOBALS["VERBOSE"]){echo $sql."\nOK\n";}

if(function_exists("debug_backtrace")){$trace=debug_backtrace();if(isset($trace[1])){$sourcefile=basename($trace[1]["file"]);$sourcefunction=$trace[1]["function"];$sourceline=$trace[1]["line"];}}

$unix=new unix();

$unix->events($text,"/var/log/squid.watchdog.log",false,$sourcefunction,$sourceline);

if(is_file("/etc/artica-postfix/FROM_ISO")){

if(!is_file("/etc/artica-postfix/artica-iso-setup-launched")){return;}}

$unix=new unix();

$pidfile="/etc/artica-postfix/pids/squiddbstart.pid";

$sock=new sockets();

$WORKDIR=$sock->GET_INFO("SquidStatsDatabasePath");

if($WORKDIR==null){$WORKDIR="/opt/squidsql";}

$SERV_NAME="squid-db";

$pid=$unix->get_pid_from_file($pidfile);

$sock=new sockets();

$nohup=$unix->find_program("nohup");

$php5=$unix->LOCATE_PHP5_BIN();

$lnbin=$unix->find_program("ln");

if(!$GLOBALS["FORCE"]){

if(!$GLOBALS["NOPID"]){

if($unix->process_exists($pid,basename(__FILE__))){

$time=$unix->PROCCESS_TIME_MIN($pid);

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: Starting Task Already running PID $pid since {$time}mn\n";}

return;

}

}

}

@file_put_contents($pidfile, getmypid());

$GetStartedValues=GetStartedValues();

$sock=new sockets();

$ProxyUseArticaDB=$sock->GET_INFO("ProxyUseArticaDB");

$DisableArticaProxyStatistics=$sock->GET_INFO("DisableArticaProxyStatistics");

if(!is_numeric($ProxyUseArticaDB)){$ProxyUseArticaDB=0;}

if(!is_numeric($DisableArticaProxyStatistics)){$DisableArticaProxyStatistics=0;}

if(!is_dir($WORKDIR)){@mkdir($WORKDIR,0755,true);}

if($ProxyUseArticaDB==0){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]:$SERV_NAME is disabled...\n";}

stop();

return;

}

$mysqld=$unix->find_program("mysqld");

if(!is_file($mysqld)){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]:$SERV_NAME is not installed...\n";}

return;

}

$pid=SQUIDDB_PID();

if($unix->process_exists($pid)){

$time=$unix->PROCCESS_TIME_MIN($pid);

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: $SERV_NAME MySQL Database Engine already running pid $pid since {$time}mn\n";}

return;

}

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: $SERV_NAME writing init.d\n";}

initd();

$memory=get_memory();

$swap=get_swap();

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: $SERV_NAME Server available memory `{$memory}MB`\n";}

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: $SERV_NAME Server available swap `{$swap}MB`\n";}

$SquidDBTuningParameters=unserialize(base64_decode($sock->GET_INFO("SquidDBTuningParameters")));

$ListenPort=$SquidDBTuningParameters["ListenPort"];

if(!is_numeric($ListenPort)){$ListenPort=0;}

if($ListenPort==0){

$ListenPort=rand(8900, 45890);

$SquidDBTuningParameters["ListenPort"]=$ListenPort;

$sock->SET_INFO("SquidDBTuningParameters", base64_encode(serialize($SquidDBTuningParameters)));

}

@mkdir($WORKDIR,0755,true);

$mysqlserv=new mysql_services();

$mysqlserv->WORKDIR=$WORKDIR;

$mysqlserv->MYSQL_PID_FILE="/var/run/squid-db.pid";

$mysqlserv->MYSQL_SOCKET="/var/run/mysqld/squid-db.sock";

$mysqlserv->SERV_NAME=$SERV_NAME;

$mysqlserv->TokenParams="SquidDBTuningParameters";

$mysqlserv->INSTALL_DATABASE=true;

$mysqlserv->MYSQL_BIN_DAEMON_PATH=$unix->find_program("mysqld");

//$mysqlserv->MYSQL_ERRMSG=$GLOBALS["MYSQL_ERRMSG"];

$mysqlserv->InnoDB=false;

$cmdline=$mysqlserv->BuildParams();

$CREATEDB=false;

if(!is_file("$WORKDIR/my.cnf")){

@file_put_contents("$WORKDIR/my.cnf", "\n");

}

if(!is_file("$WORKDIR/bin/my_print_defaults")){

$my_print_defaults=$unix->find_program("my_print_defaults");

shell_exec("$lnbin -s $my_print_defaults $WORKDIR/bin/my_print_defaults");

}

if(!is_file("$WORKDIR/data/mysql/user.MYD")){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: $SERV_NAME Installing defaults databases, Please Wait...\n";}

install_db($WORKDIR);

$CREATEDB=true;

}

$topCopyMysql["host.frm"]=true;

$topCopyMysql["host.MYD"]=true;

$topCopyMysql["host.MYI"]=true;

$topCopyMysql["servers.frm"]=true;

$topCopyMysql["servers.MYD"]=true;

$topCopyMysql["servers.MYI"]=true;

$MYSQL_DATA_DIR=$unix->MYSQL_DATA_DIR();

$topCopyMysqlForce["tables_priv.frm"]=true;

$topCopyMysqlForce["tables_priv.MYD"]=true;

$topCopyMysqlForce["tables_priv.MYI"]=true;

$topCopyMysqlForce["columns_priv.frm"]=true;

$topCopyMysqlForce["columns_priv.MYD"]=true;

$topCopyMysqlForce["columns_priv.MYI"]=true;

$topCopyMysqlForce["procs_priv.frm"]=true;

$topCopyMysqlForce["procs_priv.MYD"]=true;

$topCopyMysqlForce["procs_priv.MYI"]=true;

$topCopyMysqlForce["plugin.frm"]=true;

$topCopyMysqlForce["plugin.MYD"]=true;

$topCopyMysqlForce["plugin.MYI"]=true;

$topCopyMysqlForce["user.frm"]=true;

$topCopyMysqlForce["user.MYD"]=true;

$topCopyMysqlForce["user.MYI"]=true;

$topCopyMysqlForce["db.frm"]=true;

$topCopyMysqlForce["db.MYD"]=true;

$topCopyMysqlForce["db.MYI"]=true;

$ToCopyForce=false;

while (list ($filename, $ligne) = each ($topCopyMysql) ){

if(!is_file("$WORKDIR/data/mysql/$filename")){

$ToCopyForce=true;

if(is_file("$MYSQL_DATA_DIR/mysql/$filename")){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: Installing $filename\n";}

@copy("$MYSQL_DATA_DIR/mysql/$filename", "$WORKDIR/data/mysql/$filename");

$CREATEDB=true;

}

}

}

while (list ($filename, $ligne) = each ($topCopyMysqlForce) ){

if(!is_file("$WORKDIR/data/mysql/$filename")){

if(is_file("$MYSQL_DATA_DIR/mysql/$filename")){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: Installing $filename\n";}

@copy("$MYSQL_DATA_DIR/mysql/$filename", "$WORKDIR/data/mysql/$filename");

}

}

}

@mkdir("$WORKDIR/share/mysql/english",0755,true);

$Get_errmsgsys=Get_errmsgsys();

if(!is_file("$WORKDIR/share/mysql/english/errmsg.sys")){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: Creating errmsg.sys\n";}

ini_set('error_reporting', E_ALL);ini_set('error_prepend_string',null);ini_set('error_append_string',null);

if(is_file($Get_errmsgsys)){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: copy $Get_errmsgsys -> $WORKDIR/share/mysql/english/errmsg.sys\n";}

copy(Get_errmsgsys(), "$WORKDIR/share/mysql/english/errmsg.sys");

}else{

file_put_contents("$WORKDIR/share/mysql/english/errmsg.sys", "\n");

}

}else{

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: errmsg.sys OK\n";}

}

$TMP=$unix->FILE_TEMP();

$nohup=$unix->find_program("nohup");

if($GLOBALS["VERBOSE"]){echo $cmdline."\n";}

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: Starting MySQL daemon ($SERV_NAME)\n";}

@unlink("$WORKDIR/error.log");

shell_exec("$nohup $cmdline >$TMP 2>&1 &");

sleep(1);

for($i=0;$i<5;$i++){

$pid=SQUIDDB_PID();

if($unix->process_exists($pid)){if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: MySQL daemon ($SERV_NAME) started pid .$pid..\n";}break;}

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: MySQL daemon wait $i/5\n";}

sleep(1);

}

sleep(1);

$pid=SQUIDDB_PID();

if(!$unix->process_exists($pid)){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: MySQL daemon ($SERV_NAME) failed to start\n";}

if(is_file($TMP)){

$f=explode("\n",@file_get_contents($TMP));

while (list ($num, $ligne) = each ($f) ){if(trim($ligne)==null){continue;}if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: $ligne\n";}}

}

$f=explode("\n", @file_get_contents("$WORKDIR/error.log"));

while (list ($num, $ligne) = each ($f) ){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: MySQL Results \"$ligne\"\n";}

if(preg_match("#Incorrect information in file: './mysql/proxies_priv.frm'#", $ligne)){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: remove MySQL tables and install again...\n";}

shell_exec("/bin/rm -rf $WORKDIR/data/mysql/*");

shell_exec("$nohup $php5 ".__FILE__." --start --recall >/dev/ null 2>&1 &");

return;

}

}

}else{

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: MySQL daemon ($SERV_NAME) success\n";}

if($CREATEDB){$q=new mysql_squid_builder();$q->CheckTables();}

$q=new mysql_squid_builder();

$q->MEMORY_TABLES_RESTORE();

}

if(!$unix->process_exists($pid)){if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: $cmdline\n";}}

$unix->THREAD_COMMAND_SET($unix->LOCATE_PHP5_BIN()." ".__FILE__." --databasesize");

$SERV_NAME="squid-db";

$unix=new unix();

if(!$GLOBALS["NOPID"]){

$pidfile="/etc/artica-postfix/pids/".basename(__FILE__).".".__FUNCTION__.".pid";

$pid=$unix->get_pid_from_file($pidfile);

if($unix->process_exists($pid,basename(__FILE__))){

$time=$unix->PROCCESS_TIME_MIN($pid);

if($GLOBALS["OUTPUT"]){echo "Stopping......: ".date("H:i:s")." [INIT]: Already task running PID $pid since {$time}mn\n";}

return;

}

}

$pid=SQUIDDB_PID();

if(!$unix->process_exists($pid)){

if($GLOBALS["OUTPUT"]){echo "Stopping......: ".date("H:i:s")." [INIT]: MySQL daemon ($SERV_NAME) already stopped...\n";}

return;

}

$q=new mysql_squid_builder();

$nohup=$unix->find_program("nohup");

$q->MEMORY_TABLES_DUMP();

$time=$unix->PROCCESS_TIME_MIN($pid);

if($GLOBALS["OUTPUT"]){echo "Stopping......: ".date("H:i:s")." [INIT]: Stopping MySQL Daemon ($SERV_NAME) with a ttl of {$time}mn\n";}

$mysqladmin=$unix->find_program("mysqladmin");

if($GLOBALS["OUTPUT"]){echo "Stopping......: ".date("H:i:s")." [INIT]: Stopping MySQL Daemon ($SERV_NAME) smoothly...\n";}

$cmd="$nohup $mysqladmin --socket=/var/run/mysqld/squid-db.sock --protocol=socket --user=root shutdown >/dev/null 2>&1 &";

shell_exec($cmd);

for($i=0;$i<5;$i++){

$pid=SQUIDDB_PID();

if($unix->process_exists($pid)){

if($GLOBALS["OUTPUT"]){echo "Stopping......: ".date("H:i:s")." [INIT]: MySQL daemon ($SERV_NAME) waiting $pid..\n";}

}else{

break;

}

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: MySQL daemon ($SERV_NAME) wait $i/5\n";}

sleep(1);

}

$pid=SQUIDDB_PID();

if(!$unix->process_exists($pid)){

if($GLOBALS["OUTPUT"]){echo "Stopping......: ".date("H:i:s")." [INIT]: MySQL daemon ($SERV_NAME) success...\n";}

return;

}

$kill=$unix->find_program("kill");

for($i=0;$i<10;$i++){

$pid=SQUIDDB_PID();

if($unix->process_exists($pid)){

if($GLOBALS["OUTPUT"]){echo "Stopping......: ".date("H:i:s")." [INIT]: MySQL daemon ($SERV_NAME) kill pid $pid..\n";}

unix_system_kill_force($pid);

}else{

break;

}

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: MySQL daemon ($SERV_NAME) wait $i/10\n";}

sleep(1);

}

$pid=SQUIDDB_PID();

if(!$unix->process_exists($pid)){

if($GLOBALS["OUTPUT"]){echo "Stopping......: ".date("H:i:s")." [INIT]: MySQL daemon ($SERV_NAME) success...\n";}

return;

}

if($GLOBALS["OUTPUT"]){echo "Stopping......: ".date("H:i:s")." [INIT]: MySQL daemon ($SERV_NAME) Failed...\n";}

$unix=new unix();

$sock=new sockets();

$Socket="/var/run/mysqld/squid-db.sock";

$pid=$unix->get_pid_from_file("/var/run/squid-db.pid");

if($unix->process_exists($pid)){return $pid;}

$SquidStatsDatabasePath=$sock->GET_INFO("SquidStatsDatabasePath");

if($SquidStatsDatabasePath==null){$SquidStatsDatabasePath="/opt/squidsql";}

$mysqld=$unix->find_program("mysqld");

$WORKDIR=$sock->GET_INFO("SquidStatsDatabasePath");

if($WORKDIR==null){$WORKDIR="/opt/squidsql";}

return $unix->PIDOF_PATTERN("$mysqld.*?$Socket");

if($dir=="--verbose"){$dir=null;}

$sock=new sockets();

$unix=new unix();

$pidfile="/etc/artica-postfix/pids/squiddbstart.pid";

$pid=$unix->get_pid_from_file($pidfile);

if($unix->process_exists($pid,basename(__FILE__))){

$time=$unix->PROCCESS_TIME_MIN($pid);

build_progress_changedir("Moving......: [INIT]: Already task running PID $pid since {$time}mn",100);

if($GLOBALS["OUTPUT"]){echo "Moving......: [INIT]: Already task running PID $pid since {$time}mn\n";}

return;

}

@file_put_contents($pidfile, getmypid());

if($dir==null){$dir=$sock->GET_INFO("SquidStatsDatabasePath_change");}

$cp=$unix->find_program("cp");

$rm=$unix->find_program("rm");

$ln=$unix->find_program("ln");

$php=$unix->find_program("php");

echo "Moving......: [INIT]: Change to directory `$dir`\n";

if($dir==null){build_progress_changedir("No directory specified",100);return;}

$SourceDataPath=$sock->GET_INFO("SquidStatsDatabasePath");

if($SourceDataPath==null){$SourceDataPath="/opt/squidsql";}

$LinkSourceDB=$SourceDataPath."/data";

$SourceDataPath="$SourceDataPath/data";

if(is_link($SourceDataPath)){

$LinkedSource=@readlink($SourceDataPath);

if($GLOBALS["VERBOSE"]){echo "LINKED SourceDataPath = $LinkedSource\n";}

if(!is_dir("$LinkedSource")){

if($GLOBALS["VERBOSE"]){echo "$LinkedSource No such directory...\n";}

shell_exec("$rm -f $SourceDataPath");

}else{

$SourceDataPath=$LinkedSource;

}

}

build_progress_changedir("Moving to $dir",100);

initd();

$dirCMD=$unix->shellEscapeChars($dir);

if($dir=="$SourceDataPath/data"){

build_progress_changedir("Moving to $dir - Not permited",100);

return;}

if($dir==$SourceDataPath){

build_progress_changedir("Moving to $dir - Not permited",100);

return;

}

@mkdir($dir,0755,true);

build_progress_changedir("Calculate disk size",20);

echo "Moving......: [INIT]: Calculate disk size\n";

$Size=$unix->DIRSIZE_BYTES("$SourceDataPath");

build_progress_changedir("Squid-db Size: $Size",25);

echo "Moving......: [INIT]: Stopping Squid-db Size: $Size\n";

build_progress_changedir("Stopping service",30);

system("/etc/init.d/squid-db stop");

build_progress_changedir("Copy data service",50);

echo "Moving......: [INIT]: Copy $SourceDataPath content to next dir size=$Size\n";

if($GLOBALS["VERBOSE"]){echo "EXECUTE: $cp -rfv $SourceDataPath/* $dirCMD/\n";}

system("$cp -rfv $SourceDataPath/* $dirCMD/");

$Size2=$unix->DIRSIZE_BYTES($dir);

build_progress_changedir("Next size: $Size2",55);

if($Size2<$Size){

build_progress_changedir("Copy error $Size2 is less than original size ($Size)",110);

echo "Moving......: [INIT]: Copy error $Size2 is less than original size ($Size)\n";

return;

}

build_progress_changedir("Removing old data...",60);

echo "Moving......: [INIT]: Removing old data\n";

if($GLOBALS["VERBOSE"]){echo "EXECUTE:$rm -rf $SourceDataPath\n";}

system("$rm -rf $SourceDataPath");

if(is_link($LinkSourceDB)){

if($GLOBALS["VERBOSE"]){echo "EXECUTE:$rm -f $LinkSourceDB\n";}

system("$rm -f $LinkSourceDB");}

build_progress_changedir("Create a new symbolic link",70);

echo "Moving......: [INIT]: Create a new symbolic link...\n";

if($GLOBALS["VERBOSE"]){echo "EXECUTE:$ln -s $dirCMD $LinkSourceDB\n";}

system("$ln -s $dirCMD $LinkSourceDB");

build_progress_changedir("Starting MySQL database engine",80);

echo "Moving......: [INIT]: Starting MySQL database engine...\n";

system("/etc/init.d/squid-db start --force");

build_progress_changedir("Calculating size...",80);

$unix->THREAD_COMMAND_SET("$php ".__FILE__." --databasesize --force");

build_progress_changedir("{done}",100);

$unix=new unix();

$php5=$unix->LOCATE_PHP5_BIN();

shell_exec("$php5 ".__FILE__." --stop");

shell_exec("$php5 ".__FILE__." --start");

$unix=new unix();

$php=$unix->LOCATE_PHP5_BIN();

$f[]="#!/bin/sh";

$f[]="### BEGIN INIT INFO";

$f[]="# Provides: squid-db";

$f[]="# Required-Start: \$local_fs \$remote_fs \$syslog \$named \$network \$time";

$f[]="# Required-Stop: \$local_fs \$remote_fs \$syslog \$named \$network";

$f[]="# Should-Start:";

$f[]="# Should-Stop:";

$f[]="# Default-Start: 2 3 4 5";

$f[]="# Default-Stop: 0 1 6";

$f[]="# Short-Description: Squid MySQL Statistics database";

$f[]="# chkconfig: 2345 11 89";

$f[]="# description: Squid MySQL Statistics database";

$f[]="### END INIT INFO";

$f[]="case \"\$1\" in";

$f[]=" start)";

$f[]=" $php ". __FILE__." --start --byinitd \$2 \$3";

$f[]=" ;;";

$f[]="";

$f[]=" stop)";

$f[]=" $php ". __FILE__." --stop --byinitd --force \$2 \$3";

$f[]=" ;;";

$f[]="";

$f[]=" restart)";

$f[]=" $php ". __FILE__." --stop --byinitd --force \$2 \$3";

$f[]=" $php ". __FILE__." --start --byinitd \$2 \$3";

$f[]=" ;;";

$f[]="";

$f[]=" *)";

$f[]=" echo \"Usage: \$0 {start|stop|restart} {ldap|} (+ 'debug' for more infos)\"";

$f[]=" exit 1";

$f[]=" ;;";

$f[]="esac";

$f[]="exit 0\n";

@file_put_contents("/etc/init.d/squid-db", @implode("\n", $f));

@chmod("/etc/init.d/squid-db",0755);

if(is_file('/usr/sbin/update-rc.d')){

shell_exec('/usr/sbin/update-rc.d -f squid-db defaults >/dev/null 2>&1');

}

if(is_file('/sbin/chkconfig')){

shell_exec('/sbin/chkconfig --add squid-db >/dev/null 2>&1');

shell_exec('/sbin/chkconfig --level 2345 squid-db on >/dev/null 2>&1');

}

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: MySQL daemon (squid-db) success...\n";}

$unix=new unix();

$arrayfile="/usr/share/artica-postfix/ressources/logs/web/squiddb.size.db";

if(!$force){

$pidfile="/etc/artica-postfix/pids/squid-databasesize.pid";

$pid=$unix->get_pid_from_file($pidfile);

if($unix->process_exists($pid,basename(__FILE__))){

$time=$unix->PROCCESS_TIME_MIN($pid);

return;

}

@file_put_contents($pidfile, getmypid());

$time=$unix->file_time_min($arrayfile);

if($time<20){return;}

}

$sock=new sockets();

$WORKDIR=$sock->GET_INFO("SquidStatsDatabasePath");

if($WORKDIR==null){$WORKDIR="/opt/squidsql";}

if(!is_dir($WORKDIR)){@mkdir($WORKDIR,0755,true);}

$dir=$WORKDIR;

if(is_link($dir)){$dir=readlink($dir);}

$unix=new unix();

$sizbytes=$unix->DIRSIZE_BYTES($dir);

$dir=$unix->shellEscapeChars($dir);

$df=$unix->find_program("df");

$array["DBSIZE"]=$sizbytes/1024;

exec("$df -B K $dir 2>&1",$results);

while (list ($num, $ligne) = each ($results) ){

if(preg_match("#^.*?\s+([0-9A-Z\.]+)K\s+([0-9A-Z\.]+)K\s+([0-9A-Z\.]+)K\s+([0-9\.]+)%\s+(.+)#", $ligne,$re)){

$array["SIZE"]=$re[1];

$array["USED"]=$re[2];

$array["AIVA"]=$re[3];

$array["POURC"]=$re[4];

$array["MOUNTED"]=$re[5];

break;

}

}

$results=array();

exec("$df -i $dir 2>&1",$results);

while (list ($num, $ligne) = each ($results) ){

if(preg_match("#^.*?\s+([0-9A-Z\.]+)\s+([0-9A-Z\.]+)\s+([0-9A-Z\.]+)\s+([0-9\.]+)%\s+(.+)#", $ligne,$re)){

$array["ISIZE"]=$re[1];

$array["IUSED"]=$re[2];

$array["IAIVA"]=$re[3];

$array["IPOURC"]=$re[4];

break;

}

}

if($GLOBALS["VERBOSE"]) {print_r($array);}

@unlink($arrayfile);

$q=new mysql_squid_builder();

$TABLES_NUMBER=$q->COUNT_ALL_TABLES();

$array["TABLES_NUMBER"]=$TABLES_NUMBER;

@file_put_contents($arrayfile, serialize($array));

if($GLOBALS["VERBOSE"]) {echo "Saving $arrayfile...\n";}

@chmod($arrayfile, 0755);

$unix=new unix();

$mysqld_safe=$unix->find_program("mysqld_safe");

$mysql_install_db=$unix->find_program("mysql_install_db");

$cp=$unix->find_program("cp");

//shell_exec("cp -f /var/lib/mysql/mysql/plugin.* /opt/squidsql/data/mysql/");

if(is_file("$WORKDIR/data/ibdata1")){

@unlink("$WORKDIR/data/ibdata1");

@unlink("$WORKDIR/data/ib_logfile0");

@unlink("$WORKDIR/data/ib_logfile1");

}else{

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: $WORKDIR/ibdata1 no such file\n";}

}

if(is_file("/usr/share/mysql/mysql_system_tables.sql")){

if(is_file($mysqld_safe)){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: $mysqld_safe with mysql_system_tables.sql\n";}

$cmd="$mysqld_safe --defaults-file=/opt/squidsql/my.cnf --log-error=/opt/squidsql/error.log --user=root --socket=/var/run/mysqld/squid-db.sock2 --basedir=/opt/squidsql --datadir=/opt/squidsql/data --skip-networking --plugin_dir=/opt/squidsql/lib/plugin --init-file=/usr/share/mysql/mysql_system_tables.sql --verbose";

shell_exec($cmd);

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: `$cmd`\n";}

if(is_file("/usr/share/mysql/mysql_system_tables_data.sql")){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: $mysqld_safe with mysql_system_tables_data.sql\n";}

shell_exec("$mysqld_safe --defaults-file=/opt/squidsql/my.cnf --log-error=/opt/squidsql/error.log --socket=/var/run/mysqld/squid-db.sock2 --user=root --basedir=/opt/squidsql --datadir=/opt/squidsql/data --skip-networking --plugin_dir=/opt/squidsql/lib/plugin --init-file=/usr/share/mysql/mysql_system_tables_data.sql --verbose");

}

}

}

if(!is_file("$WORKDIR/data/mysql/user.MYD")){

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: checks with `$mysql_install_db`\n";}

if(is_file("$mysql_install_db")){

$cmd="$mysql_install_db --basedir=$WORKDIR --plugin_dir=$WORKDIR/lib/plugin --datadir=$WORKDIR/data --skip-name-resolve --user=root --force --no-defaults --log-error=/opt/squidsql/error.log >/dev/null 2>&1";

if($GLOBALS["OUTPUT"]){echo "Starting......: ".date("H:i:s")." [INIT]: `$cmd`\n";}

shell_exec($cmd);

}

}

$array["POURC"]=$pourc;

$array["TEXT"]=$text;

if(is_numeric($text)){

$array["POURC"]=$text;

$array["TEXT"]=$pourc;

}

if($GLOBALS["VERBOSE"]){echo "******************** {$pourc}% $text ********************\n";}

$cachefile="/usr/share/artica-postfix/ressources/logs/squiddb.restart.progress";

@file_put_contents($cachefile, serialize($array));

@chmod($cachefile,0755);

$unix=new unix();

$sock=new sockets();

$TMP=$unix->FILE_TEMP();

$ArticaProxyStatisticsBackupFolder=$sock->GET_INFO("ArticaProxyStatisticsBackupFolder");

if($ArticaProxyStatisticsBackupFolder==null){$ArticaProxyStatisticsBackupFolder="/home/artica/squid/backup-statistics"; }

@mkdir($ArticaProxyStatisticsBackupFolder,0755,true);

$nice=$unix->EXEC_NICE();

$mysqldump=$unix->find_program("mysqldump");

$gzip=$unix->find_program("gzip");

$nohup=$unix->find_program("nohup");

$filename=date("Ymdhi")."-squidlogs.gz";

$echo=$unix->find_program("echo");

$sh[]="#!/bin/sh";

$sh[]="$echo \"$mysqldump -> $filename\"";

$sh[]="$nice $mysqldump --add-drop-table --single-transaction --force --insert-ignore -S /var/run/mysqld/squid-db.sock -u root squidlogs | $gzip > $ArticaProxyStatisticsBackupFolder/$filename";

$sh[]="$echo \"$mysqldump -> $filename DONE\"";

$sh[]="\n";

@file_put_contents("$TMP.sh", @implode("\n", $sh));

@chmod("$TMP.sh",0755);

build_progress_changedir(10,"Starting backup $filename - ". basename("$TMP.sh")." ");

system("$nohup $TMP.sh >$TMP.txt 2>&1 &");

sleep(1);

$PID=$unix->PIDOF_PATTERN("$TMP.sh");

echo "Running PID $PID\n";

while ($unix->process_exists($PID)) {

$size=@filesize("$ArticaProxyStatisticsBackupFolder/$filename");

build_progress_changedir(50,"Starting backup $filename (".FormatBytes($size/1024).")");

sleep(3);

$PID=$unix->PIDOF_PATTERN("$TMP.sh");

echo "Running PID $PID\n";

}

echo @file_get_contents("$TMP.txt")."\n";

@unlink("$TMP.sh");

@unlink("$TMP.txt");

$size=@filesize("$ArticaProxyStatisticsBackupFolder/$filename");

echo "$ArticaProxyStatisticsBackupFolder/$filename -> SIZE:$size\n";

build_progress_changedir(100,"{done} $filename (".FormatBytes($size/1024).")");