示例#1
0
function SUGAR_INSTALL($servername, $root, $hash = array())
{
    $GLOBALS["ADDLOG"] = "{$GLOBALS["ARTICALOGDIR"]}/{$servername}.log";
    if ($root == null) {
        events("Starting install Sugar Unable to stat root dir");
        return false;
    }
    $user = $hash["wwwmysqluser"][0];
    $mysql_password = $hash[strtolower("WWWMysqlPassword")][0];
    $appli_user = $hash["wwwappliuser"][0];
    $appli_password = $hash["wwwapplipassword"][0];
    $wwwsslmode = $hash["wwwsslmode"][0];
    if ($wwwsslmode == "TRUE") {
        $SSL = true;
    } else {
        $SSL = false;
    }
    if ($user == null) {
        events("Starting install SugarCRM Unable to stat Mysql username");
        return false;
    }
    if ($mysql_password == null) {
        events("Starting install SugarCRM Unable to stat Mysql password");
        return false;
    }
    @mkdir($root, 0755, true);
    $server_database = str_replace(".", "_", $servername);
    $server_database = str_replace("-", "_", $server_database);
    $q = new mysql();
    if (!$q->DATABASE_EXISTS($server_database)) {
        events("Install SugarCRM sub-system mysql database {$server_database}...");
        $q->CREATE_DATABASE($server_database);
    }
    if (!$q->DATABASE_EXISTS($server_database)) {
        events("Install SugarCRM unable to create MYSQL Database");
        return false;
    }
    if (!is_file("{$root}/index.php")) {
        events("Install SugarCRM installing source code");
        shell_exec("/bin/cp -rf /usr/local/share/artica/sugarcrm_src/* {$root}/");
    }
    if (!is_file("{$root}/install/siteConfig_a.php")) {
        events("Install SugarCRM installing install directory");
        shell_exec("/bin/cp -rf /usr/local/share/artica/sugarcrm_src/install {$root}/");
    }
    $sugar = new SugarCRM();
    $sugar->sql_host = $q->mysql_server;
    $sugar->sql_db = $server_database;
    $sugar->sql_admin = $user;
    $sugar->sql_password = $mysql_password;
    if ($appli_user == null) {
        $appli_user = "******";
    }
    $sugar->manager_name = $appli_user;
    $sugar->manager_password = $appli_password;
    $sugar->sugar_supposed_version = SUGAR_CRMVERSION($root);
    events("{$servername} v.{$sugar->sugar_supposed_version}");
    $sugar->servername = $servername;
    $q->PRIVILEGES($user, $mysql_password, $server_database);
    $conf = $sugar->BuildSugarConf($SSL);
    events("Creating configuration file config.php");
    @file_put_contents("{$root}/config.php", $conf);
    $conf_silent = $sugar->BuildSilentInstallConf($SSL);
    events("Creating silent configuration file config_si.php");
    @file_put_contents("{$root}/config_si.php", $conf_silent);
    shell_exec("chmod -R 755 {$root}/include/javascript");
}
示例#2
0
function SUGAR_INSTALL($servername, $root, $hash = array())
{
    $GLOBALS["ADDLOG"] = "/var/log/artica-postfix/{$servername}.log";
    if ($root == null) {
        events("Starting install Sugar Unable to stat root dir");
        return false;
    }
    $sql_file = "/usr/share/artica-postfix/bin/install/SugarCRM/sugarcrm.sql";
    $user = $hash["wwwmysqluser"][0];
    $mysql_password = $hash[strtolower("WWWMysqlPassword")][0];
    $appli_user = $hash["wwwappliuser"][0];
    $appli_password = $hash["wwwapplipassword"][0];
    $wwwsslmode = $hash["wwwsslmode"][0];
    if ($wwwsslmode == "TRUE") {
        $SSL = true;
    } else {
        $SSL = false;
    }
    if ($user == null) {
        events("Starting install SugarCRM Unable to stat Mysql username");
        return false;
    }
    if ($mysql_password == null) {
        events("Starting install SugarCRM Unable to stat Mysql password");
        return false;
    }
    @mkdir($root, 0755, true);
    $server_database = str_replace(".", "_", $servername);
    $server_database = str_replace("-", "_", $server_database);
    $q = new mysql();
    if (!$q->DATABASE_EXISTS($server_database)) {
        events("Install SugarCRM sub-system mysql database {$server_database}...");
        $q->CREATE_DATABASE($server_database);
    }
    if (!$q->DATABASE_EXISTS($server_database)) {
        events("Install SugarCRM unable to create MYSQL Database");
        return false;
    }
    if (!is_file("{$root}/index.php")) {
        events("Install SugarCRM installing source code");
        shell_exec("/bin/cp -rf /usr/local/share/artica/sugarcrm_src/* {$root}/");
    }
    $sugar = new SugarCRM();
    $manquesfichiers = $sugar->checkRootFiles($root);
    if (count($manquesfichiers) > 0) {
        events("Install SugarCRM installing source code missing " . count($manquesfichiers) . " files");
        shell_exec("/bin/cp -rf /usr/local/share/artica/sugarcrm_src/* {$root}/");
    }
    $sugar->sql_db = $server_database;
    $sugar->sql_admin = $user;
    $sugar->sql_password = $mysql_password;
    $sugar->sugar_supposed_version = SUGAR_CRMVERSION($root);
    events("{$servername} v.{$sugar->sugar_supposed_version}");
    $sugar->servername = $servername;
    AddPrivileges($user, $mysql_password, $server_database);
    if (!$sugar->TestTables()) {
        if ($q->mysql_password != null) {
            $password = "******";
        } else {
            events("Install SugarCRM installing tables datas with null password");
        }
        $cmd = "mysql --port={$q->mysql_port} --skip-column-names --database={$server_database} --silent --xml ";
        $cmd = $cmd . " --user={$q->mysql_admin}{$password} <{$sql_file}";
        shell_exec($cmd);
    }
    if ($appli_user == null) {
        $appli_user = "******";
    }
    $sugar->CreateAdminPassword($appli_user, $appli_password);
    $conf = $sugar->BuildSugarConf($SSL);
    events("Creating configuration file config.php");
    @file_put_contents("{$root}/config.php", $conf);
    events("sugar version is {$sugar->sugar_supposed_version}");
    $sql = "UPDATE `{$server_database}`.`config` SET `value` = '{$sugar->sugar_supposed_version}' \n\tWHERE `config`.`category` =  'info' \n\tAND `config`.`name` = 'sugar_version'  LIMIT 1 ;";
    $q = new mysql();
    $q->QUERY_SQL($sql, $server_database);
    if (!$q->ok) {
        events("{$q->mysql_error}");
        events("{$sql}");
    }
    shell_exec("chmod -R 755 {$root}/include/javascript");
}