File: /home/nexper/www/67.225.167.226/public_html/crm/install/performSetup.php
<?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
/*********************************************************************************
* SugarCRM is a customer relationship management program developed by
* SugarCRM, Inc. Copyright (C) 2004 - 2009 SugarCRM Inc.
*
* This program is free software; you can redistribute it and/or modify it under
* the terms of the GNU General Public License version 3 as published by the
* Free Software Foundation with the addition of the following permission added
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
* details.
*
* You should have received a copy of the GNU General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU General Public License version 3.
*
* In accordance with Section 7(b) of the GNU General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
// This file will load the configuration settings from session data,
// write to the config file, and execute any necessary database steps.
$GLOBALS['installing'] = true;
if( !isset( $install_script ) || !$install_script ){
die($mod_strings['ERR_NO_DIRECT_SCRIPT']);
}
ini_set("output_buffering","0");
set_time_limit(3600);
// flush after each output so the user can see the progress in real-time
ob_implicit_flush();
require_once('include/utils.php');
require_once('include/database/DBManagerFactory.php');
require_once('include/modules.php');
require_once('include/utils/file_utils.php');
require_once('install/install_utils.php');
require_once('modules/Schedulers/Scheduler.php');
require_once('modules/TableDictionary.php');
require_once('include/SugarObjects/VardefManager.php');
require_once('modules/Trackers/TrackerManager.php');
$trackerManager = TrackerManager::getInstance();
$trackerManager->pause();
$cache_dir = 'cache/';
$line_entry_format = "     <b>";
$line_exit_format = "...   </b>";
$rel_dictionary = $dictionary; // sourced by modules/TableDictionary.php
$render_table_close = "";
$render_table_open = "";
$setup_db_admin_password = $_SESSION['setup_db_admin_password'];
$setup_db_admin_user_name = $_SESSION['setup_db_admin_user_name'];
$setup_db_create_database = $_SESSION['setup_db_create_database'];
$setup_db_create_sugarsales_user = $_SESSION['setup_db_create_sugarsales_user'];
$setup_db_database_name = $_SESSION['setup_db_database_name'];
$setup_db_drop_tables = $_SESSION['setup_db_drop_tables'];
$setup_db_host_instance = $_SESSION['setup_db_host_instance'];
$setup_db_host_name = $_SESSION['setup_db_host_name'];
$demoData = $_SESSION['demoData'];
$setup_db_sugarsales_password = $_SESSION['setup_db_sugarsales_password'];
$setup_db_sugarsales_user = $_SESSION['setup_db_sugarsales_user'];
$setup_site_admin_password = $_SESSION['setup_site_admin_password'];
$setup_site_guid = (isset($_SESSION['setup_site_specify_guid']) && $_SESSION['setup_site_specify_guid'] != '') ? $_SESSION['setup_site_guid'] : '';
$setup_site_url = $_SESSION['setup_site_url'];
$parsed_url = parse_url($setup_site_url);
$setup_site_host_name = $parsed_url['host'];
$setup_site_log_dir = isset($_SESSION['setup_site_custom_log_dir']) ? $_SESSION['setup_site_log_dir'] : '.';
$setup_site_log_file = 'sugarcrm.log'; // may be an option later
$setup_site_session_path = isset($_SESSION['setup_site_custom_session_path']) ? $_SESSION['setup_site_session_path'] : '';
$setup_site_log_level ='fatal';
$out =<<<EOQ
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta http-equiv="Content-Script-Type" content="text/javascript">
<meta http-equiv="Content-Style-Type" content="text/css">
<title>{$mod_strings['LBL_WIZARD_TITLE']} {$mod_strings['LBL_PERFORM_TITLE']}</title>
<link REL="SHORTCUT ICON" HREF="$icon">
<link rel="stylesheet" href="$css" type="text/css" />
<script type="text/javascript" src="$common"></script>
</head>
<body onload="javascript:document.getElementById('defaultFocus').focus();">
<table cellspacing="0" cellpadding="0" border="0" align="center" class="shell">
<tr><td colspan="2" id="help"><a href="{$help_url}" target='_blank'>{$mod_strings['LBL_HELP']} </a></td></tr>
<tr>
<th width="500">
<p><img src="$sugar_md" alt="SugarCRM" border="0"></p>
{$mod_strings['LBL_PERFORM_TITLE']}</th>
<th width="200" style="text-align: right;"><a href="http://www.sugarcrm.com" target="_blank">
<IMG src="$loginImage" width="145" height="30" alt="SugarCRM" border="0"></a></th>
</tr>
<tr>
<td colspan="2">
EOQ;
echo $out;
installLog("calling handleSugarConfig()");
$bottle = handleSugarConfig();
installLog("calling handleLog4Php()");
handleLog4Php();
installLog("calling handleHtaccess()");
handleHtaccess();
///////////////////////////////////////////////////////////////////////////////
//// START TABLE STUFF
echo "<br>";
echo "<b>{$mod_strings['LBL_PERFORM_TABLES']}</b>";
echo "<br>";
// create the SugarCRM database
if($setup_db_create_database) {
installLog("calling handleDbCreateDatabase()");
handleDbCreateDatabase();
} else {
// ensure the charset and collation are utf8
installLog("calling handleDbCharsetCollation()");
handleDbCharsetCollation();
}
// create the SugarCRM database user
if($setup_db_create_sugarsales_user)
handleDbCreateSugarUser();
foreach( $beanFiles as $bean => $file ){
require_once( $file );
}
// load up the config_override.php file.
// This is used to provide default user settings
if( is_file("config_override.php") ){
require_once("config_override.php");
}
$db = &DBManagerFactory::getInstance();
$startTime = microtime(true);
$focus = 0;
$processed_tables = array(); // for keeping track of the tables we have worked on
$empty = '';
$new_tables = 1; // is there ever a scenario where we DON'T create the admin user?
$new_config = 1;
$new_report = 1;
// add non-module Beans to this array to keep the installer from erroring.
$nonStandardModules = array (
//'Tracker',
);
//if working with sql-server create a catalog for full-text indexes.
if ($GLOBALS['db']->dbType=='mssql') {
$GLOBALS['db']->helper->create_default_full_text_catalog();
}
/**
* loop through all the Beans and create their tables
*/
installLog("looping through all the Beans and create their tables");
//start by clearing out the vardefs
VardefManager::clearVardef();
foreach( $beanFiles as $bean => $file ) {
$doNotInit = array('Scheduler', 'SchedulersJob');
if(in_array($bean, $doNotInit)) {
$focus = new $bean(false);
} else {
$focus = new $bean();
}
$table_name = $focus->table_name;
installLog("processing table ".$focus->table_name);
// check to see if we have already setup this table
if(!in_array($table_name, $processed_tables)) {
if(!file_exists("modules/".$focus->module_dir."/vardefs.php")){
continue;
}
if(!in_array($bean, $nonStandardModules)) {
require_once("modules/".$focus->module_dir."/vardefs.php"); // load up $dictionary
if($dictionary[$focus->object_name]['table'] == 'does_not_exist') {
continue; // support new vardef definitions
}
} else {
continue; //no further processing needed for ignored beans.
}
// table has not been setup...we will do it now and remember that
$processed_tables[] = $table_name;
$focus->db->database = $db->database; // set db connection so we do not need to reconnect
if($setup_db_drop_tables) {
drop_table_install($focus);
installLog("dropping table ".$focus->table_name);
}
if(create_table_if_not_exist($focus)) {
installLog("creating table ".$focus->table_name);
if( $bean == "User" ){
$new_tables = 1;
}
if($bean == "Administration")
$new_config = 1;
}
installLog("creating Relationship Meta for ".$focus->getObjectName());
SugarBean::createRelationshipMeta($focus->getObjectName(), $db, $table_name, $empty, $focus->module_dir);
echo ".";
} // end if()
}
echo "<br>";
//// END TABLE STUFF
///////////////////////////////////////////////////////////////////////////////
//// START RELATIONSHIP CREATION
ksort($rel_dictionary);
foreach( $rel_dictionary as $rel_name => $rel_data ){
$table = $rel_data['table'];
if( $setup_db_drop_tables ){
if( $db->tableExists($table) ){
$db->dropTableName($table);
}
}
if( !$db->tableExists($table) ){
$db->createTableParams($table, $rel_data['fields'], $rel_data['indices']);
}
SugarBean::createRelationshipMeta($rel_name,$db,$table,$rel_dictionary,'');
}
///////////////////////////////////////////////////////////////////////////////
//// START CREATE DEFAULTS
echo "<br>";
echo "<b>{$mod_strings['LBL_PERFORM_CREATE_DEFAULT']}</b><br>";
echo "<br>";
installLog("Begin creating Defaults");
if ($new_config) {
installLog("insert defaults into config table");
insert_default_settings();
}
if ($new_tables) {
echo $line_entry_format.$mod_strings['LBL_PERFORM_DEFAULT_USERS'].$line_exit_format;
installLog($mod_strings['LBL_PERFORM_DEFAULT_USERS']);
create_default_users();
echo $mod_strings['LBL_PERFORM_DONE'];
} else {
echo $line_entry_format.$mod_strings['LBL_PERFORM_ADMIN_PASSWORD'].$line_exit_format;
installLog($mod_strings['LBL_PERFORM_ADMIN_PASSWORD']);
$db->setUserName($setup_db_sugarsales_user);
$db->setUserPassword($setup_db_sugarsales_password);
set_admin_password($setup_site_admin_password);
echo $mod_strings['LBL_PERFORM_DONE'];
}
// default OOB schedulers
echo $line_entry_format.$mod_strings['LBL_PERFORM_DEFAULT_SCHEDULER'].$line_exit_format;
installLog($mod_strings['LBL_PERFORM_DEFAULT_SCHEDULER']);
$scheduler = new Scheduler();
if(isset($sugar_config['demoData']) && $sugar_config['demoData'] != 'no' && $_SESSION['setup_db_type'] == 'mssql') {
$db->query('DELETE FROM schedulers');
$db->query('DELETE FROM schedulers_times');
$sched3 = new Scheduler();
$sched3->name = 'Prune the User History Table';
$sched3->job = 'function::trimTracker';
$sched3->date_time_start = create_date(2005,1,1) . ' ' . create_time(0,0,1);
$sched3->date_time_end = create_date(2020,12,31) . ' ' . create_time(23,59,59);
$sched3->job_interval = '*::*::*::*::*';
$sched3->status = 'Active';
$sched3->created_by = '1';
$sched3->modified_user_id = '1';
$sched3->catch_up = '1';
$sched3->save();
$sched4 = new Scheduler();
$sched4->name = 'Check Inbound Mailboxes';
$sched4->job = 'function::pollMonitoredInboxes';
$sched4->date_time_start = create_date(2005,1,1) . ' ' . create_time(0,0,1);
$sched4->date_time_end = create_date(2020,12,31) . ' ' . create_time(23,59,59);
$sched4->job_interval = '*::*::*::*::*';
$sched4->status = 'Active';
$sched4->created_by = '1';
$sched4->modified_user_id = '1';
$sched4->catch_up = '0';
$sched4->save();
$sched5 = new Scheduler();
$sched5->name = 'Run Nightly Process Bounced Campaign Emails';
$sched5->job = 'function::pollMonitoredInboxesForBouncedCampaignEmails';
$sched5->date_time_start = create_date(2005,1,1) . ' ' . create_time(0,0,1);
$sched5->date_time_end = create_date(2020,12,31) . ' ' . create_time(23,59,59);
$sched5->job_interval = '0::2-6::*::*::*';
$sched5->status = 'Active';
$sched5->created_by = '1';
$sched5->modified_user_id = '1';
$sched5->catch_up = '1';
$sched5->save();
$sched6 = new Scheduler();
$sched6->name = 'Run Nightly Mass Email Campaigns';
$sched6->job = 'function::runMassEmailCampaign';
$sched6->date_time_start = create_date(2005,1,1) . ' ' . create_time(0,0,1);
$sched6->date_time_end = create_date(2020,12,31) . ' ' . create_time(23,59,59);
$sched6->job_interval = '0::2-6::*::*::*';
$sched6->status = 'Active';
$sched6->created_by = '1';
$sched6->modified_user_id = '1';
$sched6->catch_up = '1';
$sched6->save();
$sched7 = new Scheduler();
$sched7->name = 'Prune Database on 1st of Month';
$sched7->job = 'function::pruneDatabase';
$sched7->date_time_start = create_date(2005,1,1) . ' ' . create_time(0,0,1);
$sched7->date_time_end = create_date(2020,12,31) . ' ' . create_time(23,59,59);
$sched7->job_interval = '0::4::1::*::*';
$sched7->status = 'Inactive';
$sched7->created_by = '1';
$sched7->modified_user_id = '1';
$sched7->catch_up = '0';
$sched7->save();
} else {
$scheduler->rebuildDefaultSchedulers();
}
echo $mod_strings['LBL_PERFORM_DONE'];
///////////////////////////////////////////////////////////////////////////////
//// START DEMO DATA
// populating the db with seed data
installLog("populating the db with seed data");
if( $_SESSION['demoData'] != 'no' ){
set_time_limit( 301 );
echo "<br>";
echo "<b>{$mod_strings['LBL_PERFORM_DEMO_DATA']}</b>";
echo "<br><br>";
print( $render_table_close );
print( $render_table_open );
$current_user = new User();
$current_user->retrieve(1);
include("install/populateSeedData.php");
}
$endTime = microtime(true);
$deltaTime = $endTime - $startTime;
///////////////////////////////////////////////////////////////////////////
//// FINALIZE LANG PACK INSTALL
if(isset($_SESSION['INSTALLED_LANG_PACKS']) && is_array($_SESSION['INSTALLED_LANG_PACKS']) && !empty($_SESSION['INSTALLED_LANG_PACKS'])) {
updateUpgradeHistory();
}
///////////////////////////////////////////////////////////////////////////
//// HANDLE SUGAR VERSIONS
require_once('modules/Versions/InstallDefaultVersions.php');
///////////////////////////////////////////////////////////////////////////////
//// SETUP DONE
installLog("Installation has completed *********");
$memoryUsed = '';
if(function_exists('memory_get_usage')) {
$memoryUsed = $mod_strings['LBL_PERFORM_OUTRO_5'].memory_get_usage().$mod_strings['LBL_PERFORM_OUTRO_6'];
}
$errTcpip = '';
$fp = @fsockopen("www.sugarcrm.com", 80, $errno, $errstr, 3);
if (!$fp) {
$errTcpip = "<p>{$mod_strings['ERR_PERFORM_NO_TCPIP']}</p>";
}
if ($fp && (!isset( $_SESSION['oc_install']) || $_SESSION['oc_install'] == false)) {
@fclose($fp);
$fpResult =<<<FP
<form action="install.php" method="post" name="form" id="form">
<input type="hidden" name="current_step" value="{$next_step}">
<table cellspacing="0" cellpadding="0" border="0" class="stdTable">
<tr>
<td>
</td>
<td><input class="button" type="submit" name="goto" value="{$mod_strings['LBL_NEXT']}" id="defaultFocus"/></td>
</tr>
</table>
</form>
FP;
} else {
$fpResult =<<<FP
<table cellspacing="0" cellpadding="0" border="0" class="stdTable">
<tr>
<td> </td>
<td>
<form action="index.php" method="post" name="formFinish" id="formFinish">
<input type="hidden" name="default_user_name" value="admin" />
<input class="button" type="submit" name="next" value="{$mod_strings['LBL_PERFORM_FINISH']}" id="defaultFocus"/>
</form>
</td>
</tr>
</table>
FP;
}
require_once('modules/Administration/updater_utils.php');
if( isset($_SESSION['setup_site_sugarbeet_automatic_checks']) && $_SESSION['setup_site_sugarbeet_automatic_checks'] == true){
set_CheckUpdates_config_setting('automatic');
}else{
set_CheckUpdates_config_setting('manual');
}
if(!empty($_SESSION['setup_system_name'])){
$admin=new Administration();
$admin->saveSetting('system','name',$_SESSION['setup_system_name']);
}
post_install_modules();
if( count( $bottle ) > 0 ){
foreach( $bottle as $bottle_message ){
$bottleMsg .= "{$bottle_message}\n";
}
} else {
$bottleMsg = $mod_strings['LBL_PERFORM_SUCCESS'];
}
$out =<<<EOQ
<br><p><b>{$mod_strings['LBL_PERFORM_OUTRO_1']} {$setup_sugar_version} {$mod_strings['LBL_PERFORM_OUTRO_2']}</b></p>
{$mod_strings['LBL_PERFORM_OUTRO_3']} {$deltaTime} {$mod_strings['LBL_PERFORM_OUTRO_4']}<br />
{$memoryUsed}
{$errTcpip}
</td>
</tr>
<tr>
<td align="right" colspan="2">
<hr>
<table cellspacing="0" cellpadding="0" border="0" class="stdTable">
<tr>
<td>
{$fpResult}
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<!--
<bottle>{$bottleMsg}</bottle>
-->
EOQ;
echo $out;
?>