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]