CREATE TABLE serievalue (
IDSerieHost bigint(20) NOT NULL,
IDSerieName bigint(20) NOT NULL,
IDSerieType bigint(20) NOT NULL,
IDSerieInstance bigint(20) NOT NULL,
SerieTime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
Value double DEFAULT NULL,
PRIMARY KEY (IDSerieHost,IDSerieName,IDSerieType,IDSerieInstance,SerieTime),
KEY SerieTime (SerieTime)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
EOD;
Console::stdout(PHP_EOL);
Console::stdout(PHP_EOL);
if (Console::confirm('%YDo you want to install the database?%n')) {
if (Console::confirm('%RAre you sure? ( all data in ' . $DB_NAME . ' WILL BE LOST! )%n')) {
$query = str_replace(array_keys($vars), array_values($vars), $SQLDB);
$query = str_replace(PHP_EOL, '', $query);
if (!$mysqli->multi_query($query)) {
Console::stdout('There was an error installing the database' . PHP_EOL);
Console::stdout('ERR.(' . $mysqli->errno . ") " . $mysqli->error . PHP_EOL);
exit(0);
}
}
}
Console::stdout('%Y## WRITE CONFIG GLOBAL ##%n' . PHP_EOL . PHP_EOL);
$configfile = $f3->get('CONFIG_DIR') . '/config.globals.ini';
touch($configfile);
file_put_contents($configfile, str_replace(array_keys($vars), array_values($vars), $config_global));
Console::stdout('%Y## WRITE CONFIG MASTER ##%n' . PHP_EOL . PHP_EOL);
$configfile = $f3->get('CONFIG_DIR') . '/config.master.ini';
}
$vars['[APACHE_REFRESH]'] = Console::prompt('Plugin Apache ', ['default' => '5']);
if ($vars['[APACHE_REFRESH]'] != 0) {
$vars['[APACHE_STATUS_HOST]'] = Console::prompt('Enter the apache ip/host with mod server-status enabled ', ['default' => 'localhost']);
$vars['[APACHE_STATUS_URL]'] = Console::prompt('Enter the uri to access mod server-status page', ['default' => 'server-status']);
$vars['[APACHE_UPTIME]'] = (int) Console::confirm('Plugin APACHE::Enable collect Uptime');
$vars['[APACHE_RQSTSEC]'] = (int) Console::confirm('Plugin APACHE::Enable collect Rqst/Sec');
$vars['[APACHE_BYTESEC]'] = (int) Console::confirm('Plugin APACHE::Enable collect Bytes/Sec');
$vars['[APACHE_BYTERQST]'] = (int) Console::confirm('Plugin APACHE::Enable collect Bytes/Rqst');
$vars['[APACHE_BUSYWORKER]'] = (int) Console::confirm('Plugin APACHE::Enable collect Busy Worker');
$vars['[APACHE_IDLEWORKER]'] = (int) Console::confirm('Plugin APACHE::Enable collect Idle Worker');
$vars['[APACHE_CPULOAD]'] = (int) Console::confirm('Plugin APACHE::Enable collect CPU Load');
$vars['[APACHE_CPUUSER]'] = (int) Console::confirm('Plugin APACHE::Enable collect CPU User');
$vars['[APACHE_CPUSYSTEM]'] = (int) Console::confirm('Plugin APACHE::Enable collect CPU System');
$vars['[APACHE_CPUCHILDUSER]'] = (int) Console::confirm('Plugin APACHE::Enable collect CPU Children User');
$vars['[APACHE_CPUCHILDSYS]'] = (int) Console::confirm('Plugin APACHE::Enable collect CPU Children System');
$config_plugins .= <<<EOD
apache.server['apache'].conf['host'] = [APACHE_STATUS_HOST]
apache.server['apache'].conf['status_url'] = [APACHE_STATUS_URL]
apache.server['apache'].vars['ServerUptimeSeconds'] = [APACHE_UPTIME]
apache.server['apache'].vars['ReqPerSec'] = [APACHE_RQSTSEC]
apache.server['apache'].vars['BytesPerSec'] = [APACHE_BYTESEC]
apache.server['apache'].vars['BytesPerReq'] = [APACHE_BYTERQST]
apache.server['apache'].vars['BusyWorkers'] = [APACHE_BUSYWORKER]
apache.server['apache'].vars['IdleWorkers'] = [APACHE_IDLEWORKER]
apache.server['apache'].vars['CPULoad'] = [APACHE_CPULOAD]
