1
Kloxo-MR Technical Helps / Re: How to Install and Active SSL for my clients?
« on: 2019-11-14, 11:18:53 »
Go to 'admin > all > all domains > (select one) > ssl certificates > add let's encrypt (tab)'.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
<?php
include_once "lib/html/include.php";
$tpath = "/usr/local/lxlabs/kloxo/serverfile";
if (isset($argv[1])) {
$pass = $argv[1];
} else {
$pass = randomString(9);
}
$text = <<<EOF
UPDATE mysql.user SET Password=PASSWORD('PASSWORD') WHERE User='USER';
FLUSH PRIVILEGES;
EOF;
$text = str_replace("'USER'", "'root'", $text);
$text = str_replace("'PASSWORD'", "'{$pass}'", $text);
file_put_contents("{$tpath}/reset-mysql-password.sql", $text);
print("Stop MySQL service...\n");
if (isServiceExists('mysqld')) {
exec("service mysqld stop");
} else {
exec("service mysql stop");
}
print("MySQL ROOT password reset...\n");
sleep(10);
system("mysqld_safe --skip-grant-tables --init-file={$tpath}/reset-mysql-password.sql >/dev/null 2>&1 &");
sleep(15);
// MR -- need restart because need stop mysqld_safe before
print("Restart MySQL service...\n");
if (isServiceExists('mysqld')) {
exec("service mysqld restart");
} else {
exec("service mysql restart");
}
exec("'rm' -f {$tpath}/reset-mysql-password.sql");
print("- Test Connecting:\n");
if ($conn->connect_errno) {
print(" * Failed to connect to MySQL: " . $conn->connect_error . "\n");
log_error($conn->connect_error);
} else {
print(" * Success\n");
}
print("- Save to 'dbadmin' in slavedb\n");
$a['mysql']['dbpassword'] = $pass;
slave_save_db("dbadmin", $a);
/*
$text2 = <<<EOF
REPLACE INTO dbadmin (nname, parent_clname, parent_cmlist, dbtype, dbadmin_name, dbpassword, syncserver, oldsyncserver, olddeleteflag) VALUES
('mysql___localhost', 'pserver-localhost', '', 'mysql', 'root', 'PASSWORD', 'localhost', '', '');
COMMIT;
EOF;
*/
if (!empty(mysql_fetch_array(mysql_query("SHOW DATABASES LIKE '$dbname' ")))) {
$text2 = <<<EOF
UPDATE dbadmin SET dbpassword='PASSWORD' WHERE nname='mysql___localhost' AND dbtype='mysql' AND dbadmin_name='root';
COMMIT;
EOF;
$text2 = str_replace("'PASSWORD'", "'{$pass}'", $text2);
print("- Update to 'dbadmin' in 'kloxo' database\n");
exec("mysql -u root -p'{$pass}' kloxo -e \"{$text2}\"");
}
$conn->close();
..:: Monetize your Website or Blog with BidVertiser ::..
..:: Sell your ad space with BidVertiser ::.. |
Page created in 0.226 seconds with 18 queries.