echo "/opt/psa/bin/domain_pref -u " . $extradomain . " -no_usr reject\n"; } } foreach ($backup->getDatabaseList() as $db) { echo "/opt/psa/bin/database -c {$db} -domain {$domain} -type mysql\n"; echo "/bin/sed -i \"s@/home/" . $username . "/domains/" . $domain . "/public_html@/var/www/vhosts/" . $domain . "/httpdocs@g\" " . $backup->getPath() . "/backup/" . $db . ".sql\n"; foreach ($backup->getAdditionalDomains(TRUE) as $extradomain) { echo "/bin/sed -i \"s@/home/" . $username . "/domains/" . $extradomain . "/public_html@/var/www/vhosts/" . $domain . "/domains/" . $extradomain . "@g\" " . $backup->getPath() . "/backup/" . $db . ".sql\n"; } echo "/usr/bin/mysql -uadmin -p`cat /etc/psa/.psa.shadow` {$db} < " . $backup->getPath() . "/backup/" . $db . ".sql\n"; foreach ($backup->getDatabaseLogin($db) as $user) { # Plesk 11.5 supports 1 user for multiple DBs. Use that feature :) # echo "/opt/psa/bin/database -u $db -add_user " . $user['user'] . " -passwd $password\n"; echo "/opt/psa/bin/database --create-dbuser " . $user['user'] . " -domain " . $domain . " -passwd \"{$password}\" -type mysql\n"; echo "/usr/bin/mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql -e \"UPDATE mysql.user SET Password = '******'pass'] . "' WHERE User = '******'user'] . "'\"\n"; echo "/usr/bin/mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql -e \"FLUSH PRIVILEGES\"\n"; } } /* EXTRA PRIMARY DOMAIN UPDATE * adjust the zone for the primary domain _after_ all aliases have been created */ foreach ($dns->getDNSChanges($backup->getPath() . "/backup/" . $domain . "/" . $domain . ".db", $ip) as $dnschange) { echo $dnschange . "\n"; } /* END PRIMARY DOMAIN UPDATE */ $backup->getCron(); echo "/opt/psa/bin/server_pref -u -min_password_strength " . PW_POLICY . "\n"; // Send mail to customer //$other->sendMail($domain, $username, $password, $backup->getEmail()); $other->sendMail($domain, $username, $password, "*****@*****.**"); // DO NOT FORGET TO DO SOME DNS MAGIC!