function changeSuperAdminPass()
{
if ($this->nname === 'superadmin') {
$oldpass = getAdminDbPass();
$newp = client::createDbPass($this->realpass);
$return = lfile_put_contents("__path_super_pass", $newp);
if (!$return) {
log_log("admin_error", "Admin pass change failed {$last_error}");
throw new lxException("could_not_change_superadmin_pass", '');
}
$return = $sql->setPassword($newp);
if ($return) {
$return = lfile_put_contents("__path_super_pass", $oldpass);
log_log("admin_error", "mysqladmin Failed . {$out}");
throw new lxException("could_not_change_superadmin_pass", '');
}
}
}
function create_mysql_db($type, $opt, $admin_pass)
{
global $gbl, $sgbl, $login, $ghtml;
$progname = $sgbl->__var_program_name;
$db = $sgbl->__var_dbf;
if (!isset($opt['db-rootuser']) || !isset($opt['db-rootpassword'])) {
print "Need db Root User and password --db-rootuser, --db-rootpassword \n";
exit;
}
if ($sgbl->__var_database_type === 'mysql') {
// TODO: REPLACE MYSQL_CONNECT
// TUT TUT naughty programmer... We are creating the db now XD
$req = mysqli_connect('localhost', $opt['db-rootuser'], $opt['db-rootpassword']);
} else {
if ($sgbl->__var_database_type === 'mssql') {
$req = mssql_connect("localhost,{$sgbl->__var_mssqlport}");
} else {
$req = new PDO("sqlite:{$db}");
}
}
if (!$req) {
print "Could not Connect to Database on localhost using root user: "******"\n";
}
//$sqlcm = lfile_get_contents("__path_program_root/httpdocs/sql/init/$type.sql");
$dp = randomString(9);
$dbadminpass = client::createDbPass($dp);
$dbname = $sgbl->__var_dbf;
$pguser = $sgbl->__var_admin_user;
if ($sgbl->__var_database_type === 'mysql') {
@mysqli_query($req, "CREATE DATABASE {$dbname}");
mysqli_query($req, "GRANT ALL ON {$dbname}.* TO '{$pguser}'@'localhost' IDENTIFIED BY '{$dbadminpass}';");
} else {
if ($sgbl->__var_database_type === 'mssql') {
mssql_query("create database {$dbname};");
mssql_query("use master ");
mssql_query("sp_addlogin '{$pguser}', '{$dbadminpass}', '{$dbname}';");
mssql_query("use {$dbname} ");
mssql_query("grant all to {$pguser}");
} else {
}
}
lfile_put_contents("__path_admin_pass", $dbadminpass);
lxfile_generic_chown("__path_admin_pass", "lxlabs");
}
function create_mysql_db($type, $opt, $admin_pass)
{
global $gbl, $sgbl, $login, $ghtml;
$progname = $sgbl->__var_program_name;
if (!isset($opt['db-rootuser']) || !isset($opt['db-rootpassword'])) {
print "Need db Root User and password --db-rootuser, --db-rootpassword \n";
exit;
}
if ($sgbl->__var_database_type === 'mysql') {
$req = mysql_connect('localhost', $opt['db-rootuser'], $opt['db-rootpassword']);
} else {
if ($sgbl->__var_database_type === 'mssql') {
$req = mssql_connect("localhost,{$sgbl->__var_mssqlport}");
} else {
$req = new PDO("sqlite:{$sgbl->__var_dbf}");
}
}
if (!$req) {
print "Could not Connect to Database on localhost using root user\n";
}
//$sqlcm = lfile_get_contents("__path_program_root/httpdocs/sql/init/$type.sql");
$dp = randomString(9);
$dbadminpass = client::createDbPass($dp);
$dbname = $sgbl->__var_dbf;
$pguser = $sgbl->__var_admin_user;
if ($sgbl->__var_database_type === 'mysql') {
@mysql_query("create database {$dbname}");
mysql_query("grant all on {$dbname}.* to '{$pguser}'@'localhost' identified by '{$dbadminpass}';");
} else {
if ($sgbl->__var_database_type === 'mssql') {
mssql_query("create database {$dbname};");
mssql_query("use master ");
mssql_query("sp_addlogin '{$pguser}', '{$dbadminpass}', '{$dbname}';");
mssql_query("use {$dbname} ");
mssql_query("grant all to {$pguser}");
} else {
}
}
lfile_put_contents("__path_admin_pass", $dbadminpass);
lxfile_generic_chown("__path_admin_pass", "lxlabs");
}
function change_db_pass()
{
global $gbl, $sgbl, $login, $ghtml;
$pass = randomString(10);
$newp = client::createDbPass($pass);
$oldpass = lfile_get_contents("__path_admin_pass");
$username = $sgbl->__var_program_name;
$sql = new Sqlite(null, "client");
//$sql->rawQuery("grant all on kloxo.* to kloxo@'localhost' identified by $newp");
//$sql->rawQuery("grant all on kloxo.* to kloxo@'%' identified by $newp");
//$return = $sql->setPassword($newp);
//exec("mysqladmin -u $username -p$oldpass password $newp 2>&1", $out, $return);
exec("echo 'set Password=Password(\"{$newp}\")' | mysql -u {$username} -p{$oldpass} 2>&1", $out, $return);
if ($return) {
$out = implode(" ", $out);
log_log("admin_error", "mysql change password Failed {$out}");
throw new lxException("could_not_change_admin_pass", '', $out);
}
$return = lfile_put_contents("__path_admin_pass", $newp);
if (!$return) {
log_log("admin_error", "Admin pass change failed {$last_error}");
throw new lxException("could_not_change_admin_pass", '', $last_error);
}
}
<?php
include_once "htmllib/lib/include.php";
if ($argv[1]) {
$mysqlpass = $argv[1];
} else {
$mysqlpass = slave_get_db_pass();
}
$db = $sgbl->__var_dbf;
$username = $sgbl->__var_program_name;
$program = $username;
$newpass = randomString(9);
$newpass = client::createDbPass($newpass);
mysql_connect("localhost", "root", $mysqlpass);
$cmd = "grant all on {$db}.* to {$username}@localhost identified by '{$newpass}'";
print "{$cmd}\n";
mysql_query($cmd);
lfile_put_contents("../etc/conf/{$program}.pass", $newpass);
