function mysqlSSLSave()
{
$instance_id = $_POST["instance-id"];
if (!is_numeric($instance_id)) {
$instance_id = 0;
}
if ($instance_id > 0) {
$q = new mysqlserver_multi($instance_id);
$q->mysqlSSL = $_POST["mysqlSSL"];
$q->save();
return;
}
$sock = new sockets();
$sock->SET_INFO("mysqlSSL", $_POST["mysqlSSL"]);
}
function save()
{
$instance_id = $_POST["instance-id"];
if (!is_numeric($instance_id)) {
$instance_id = 0;
}
if ($instance_id > 0) {
$q = new mysqlserver_multi($instance_id);
$q->PersoConfText = $_POST["mysqld-perso"];
$q->save();
return;
}
$datas = base64_encode($_POST["mysqld-perso"]);
$sock = new sockets();
$sock->getFrameWork("services.php?mysqld-perso-save=" . urlencode($datas));
}
function save_settings()
{
$instance_id = $_POST["instance-id"];
if ($instance_id == 0) {
$mysql = new mysqlserver();
} else {
$mysql = new mysqlserver_multi($instance_id);
}
while (list($index, $line) = each($_POST)) {
$mysql->main_array[trim($index)] = trim($line);
}
$mysql->save();
$sock = new sockets();
$sock->SET_INFO("MySqlMemoryCheck", 1);
}
function save()
{
$instance_id = $_GET["instance-id"];
if ($instance_id == 0) {
if (isset($_GET["MysqlBinAllAdresses"])) {
$sock = new sockets();
$sock->SET_INFO("MysqlBinAllAdresses", $_GET["MysqlBinAllAdresses"]);
unset($_GET["MysqlBinAllAdresses"]);
}
$mysql = new mysqlserver();
} else {
$mysql = new mysqlserver_multi($instance_id);
}
while (list($index, $line) = each($_GET)) {
$mysql->main_array[trim($index)] = trim($line);
}
$mysql->save();
}
function root_account_save()
{
$q = new mysqlserver_multi($_POST["instance-id"]);
$q->mysql_admin = $_POST["mysql_admin"];
$q->mysql_password = $_POST["mysql_password"];
$q->save(true);
$sock = new sockets();
$datas = unserialize(base64_decode($sock->getFrameWork("mysql.php?multi-root=yes&instance-id={$_POST["instance-id"]}")));
echo "<div style='width:100%;height:250px;overflow:auto'>";
while (list($index, $ligne) = each($datas)) {
if (trim($ligne) == null) {
continue;
}
echo "<div><code style='font-size:11px'>" . htmlentities($ligne) . "</code></div>";
}
echo "</div>";
}
function multi_start($ID)
{
$q = new mysqlserver();
$GLOBALS["MULTI"] = true;
$GLOBALS["SHOWLOGONLYFOR"] = $ID;
multi_monit($ID);
multi_create_cache();
$q->mysql_multi();
echo "Starting......: " . date("H:i:s") . " Mysql instance id:{$ID}..\n";
$pidfile = "/var/run/mysqld/mysqld{$ID}.pid";
echo "Starting......: " . date("H:i:s") . " Mysql instance id:{$ID} PID:{$pidfile}..\n";
$unix = new unix();
if ($unix->process_exists($unix->get_pid_from_file($pidfile))) {
echo "Starting......: " . date("H:i:s") . " Mysql instance id:{$ID} already running...\n";
return;
}
$chmod = $unix->find_program("chmod");
$ini = new iniFrameWork("/etc/mysql-multi.cnf");
$database_path = $ini->get("mysqld{$ID}", "datadir");
if (is_file("{$database_path}/error.log")) {
@unlink("{$database_path}/error.log");
}
echo "Starting......: " . date("H:i:s") . " Mysql instance id:{$ID} database={$database_path}\n";
$cmd = "{$chmod} 755 {$database_path}";
exec($cmd, $results);
$mysqld_multi = $unix->find_program("mysqld_multi");
$cmd = "{$mysqld_multi} --defaults-file=/etc/mysql-multi.cnf start {$ID} --verbose --no-log 2>&1";
if (is_file("{$database_path}/maria_log_control")) {
@unlink("{$database_path}/maria_log_control");
}
if ($GLOBALS["VERBOSE"]) {
echo "{$cmd}\n";
}
exec($cmd, $results);
while (list($index, $ligne) = each($results)) {
echo "Starting......: " . date("H:i:s") . " Mysql instance id:{$ID} {$ligne}\n";
}
for ($i = 0; $i < 4; $i++) {
sleep(1);
if ($unix->process_exists(multi_get_pid($ID))) {
sleep(1);
break;
}
}
if (!$unix->process_exists(multi_get_pid($ID))) {
echo "Starting......: " . date("H:i:s") . " Mysql instance id:{$ID} failed..\n";
} else {
$q = new mysql_multi($ID);
$q->QUERY_SQL_NO_BASE("create user 'mysqld_multi'@'127.0.0.1' identified by 'mysqld_multi'");
$q->QUERY_SQL_NO_BASE("create user 'mysqld_multi'@'localhost' identified by 'mysqld_multi'");
$q->QUERY_SQL_NO_BASE("create user 'grant shutdown on *.* to mysqld_multi'");
$q = new mysqlserver_multi($ID);
$q->setssl();
}
if (is_file("{$database_path}/error.log")) {
echo "Starting......: " . date("H:i:s") . " Mysql instance id:{$ID} {$database_path}/error.log\n";
$f = explode("\n", @file_get_contents("{$database_path}/error.log"));
while (list($index, $ligne) = each($f)) {
if (trim($ligne) == null) {
continue;
}
if (preg_match("#^[0-9]+\\s+[0-9\\:]+\\s+(.+)#", $ligne, $re)) {
$ligne = $re[1];
}
echo "Starting......: " . date("H:i:s") . " {$ligne}\n";
}
} else {
echo "Starting......: " . date("H:i:s") . " Mysql instance id:{$ID} {$database_path}/error.log no such file\n";
}
}
