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);