install/performSetup.php

   1 <?php
   2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
   3 /*********************************************************************************
   4  * SugarCRM Community Edition is a customer relationship management program developed by
   5  * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
   6  *
   7  * This program is free software; you can redistribute it and/or modify it under
   8  * the terms of the GNU Affero General Public License version 3 as published by the
   9  * Free Software Foundation with the addition of the following permission added
  10  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
  11  * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
  12  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
  13  *
  14  * This program is distributed in the hope that it will be useful, but WITHOUT
  15  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  16  * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
  17  * details.
  18  *
  19  * You should have received a copy of the GNU Affero General Public License along with
  20  * this program; if not, see http://www.gnu.org/licenses or write to the Free
  21  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
  22  * 02110-1301 USA.
  23  *
  24  * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
  25  * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
  26  *
  27  * The interactive user interfaces in modified source and object code versions
  28  * of this program must display Appropriate Legal Notices, as required under
  29  * Section 5 of the GNU Affero General Public License version 3.
  30  *
  31  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
  32  * these Appropriate Legal Notices must retain the display of the "Powered by
  33  * SugarCRM" logo. If the display of the logo is not reasonably feasible for
  34  * technical reasons, the Appropriate Legal Notices must display the words
  35  * "Powered by SugarCRM".
  36  ********************************************************************************/
  37
  38
  39
  40 // This file will load the configuration settings from session data,
  41 // write to the config file, and execute any necessary database steps.
  42 $GLOBALS['installing'] = true;
  43 if( !isset( $install_script ) || !$install_script ){
  44     die($mod_strings['ERR_NO_DIRECT_SCRIPT']);
  45 }
  46 ini_set("output_buffering","0");
  47 set_time_limit(3600);
  48 // flush after each output so the user can see the progress in real-time
  49 ob_implicit_flush();
  50
  51
  52
  53
  54
  55 require_once('install/install_utils.php');
  56
  57 require_once('modules/TableDictionary.php');
  58
  59
  60 $trackerManager = TrackerManager::getInstance();
  61 $trackerManager->pause();
  62
  63
  64 $cache_dir                          = sugar_cached("");
  65 $line_entry_format                  = "&nbsp&nbsp&nbsp&nbsp&nbsp<b>";
  66 $line_exit_format                   = "... &nbsp&nbsp</b>";
  67 $rel_dictionary                 = $dictionary; // sourced by modules/TableDictionary.php
  68 $render_table_close             = "";
  69 $render_table_open                  = "";
  70 $setup_db_admin_password            = $_SESSION['setup_db_admin_password'];
  71 $setup_db_admin_user_name           = $_SESSION['setup_db_admin_user_name'];
  72 $setup_db_create_database           = $_SESSION['setup_db_create_database'];
  73 $setup_db_create_sugarsales_user    = $_SESSION['setup_db_create_sugarsales_user'];
  74 $setup_db_database_name             = $_SESSION['setup_db_database_name'];
  75 $setup_db_drop_tables               = $_SESSION['setup_db_drop_tables'];
  76 $setup_db_host_instance             = $_SESSION['setup_db_host_instance'];
  77 $setup_db_port_num                  = $_SESSION['setup_db_port_num'];
  78 $setup_db_host_name                 = $_SESSION['setup_db_host_name'];
  79 $demoData                           = $_SESSION['demoData'];
  80 $setup_db_sugarsales_password       = $_SESSION['setup_db_sugarsales_password'];
  81 $setup_db_sugarsales_user           = $_SESSION['setup_db_sugarsales_user'];
  82 $setup_site_admin_user_name         = $_SESSION['setup_site_admin_user_name'];
  83 $setup_site_admin_password          = $_SESSION['setup_site_admin_password'];
  84 $setup_site_guid                    = (isset($_SESSION['setup_site_specify_guid']) && $_SESSION['setup_site_specify_guid'] != '') ? $_SESSION['setup_site_guid'] : '';
  85 $setup_site_url                     = $_SESSION['setup_site_url'];
  86 $parsed_url                         = parse_url($setup_site_url);
  87 $setup_site_host_name               = $parsed_url['host'];
  88 $setup_site_log_dir                 = isset($_SESSION['setup_site_custom_log_dir']) ? $_SESSION['setup_site_log_dir'] : '.';
  89 $setup_site_log_file                = 'sugarcrm.log';  // may be an option later
  90 $setup_site_session_path            = isset($_SESSION['setup_site_custom_session_path']) ? $_SESSION['setup_site_session_path'] : '';
  91 $setup_site_log_level                           ='fatal';
  92
  93 sugar_cache_clear('TeamSetsCache');
  94 if ( file_exists($cache_dir .'modules/Teams/TeamSetCache.php') ) {
  95         unlink($cache_dir.'modules/Teams/TeamSetCache.php');
  96 }
  97
  98 sugar_cache_clear('TeamSetsMD5Cache');
  99 if ( file_exists($cache_dir.'modules/Teams/TeamSetMD5Cache.php') ) {
 100         unlink($cache_dir.'modules/Teams/TeamSetMD5Cache.php');
 101 }
 102 $langHeader = get_language_header();
 103 $out =<<<EOQ
 104 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 105 <html {$langHeader}>
 106 <head>
 107    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
 108    <meta http-equiv="Content-Script-Type" content="text/javascript">
 109    <meta http-equiv="Content-Style-Type" content="text/css">
 110     <title>{$mod_strings['LBL_WIZARD_TITLE']} {$mod_strings['LBL_PERFORM_TITLE']}</title>
 111    <link REL="SHORTCUT ICON" HREF="$icon">
 112    <link rel="stylesheet" href="$css" type="text/css" />
 113    <script type="text/javascript" src="$common"></script>
 114 </head>
 115 <body onload="javascript:document.getElementById('button_next2').focus();">
 116 <table cellspacing="0" cellpadding="0" border="0" align="center" class="shell">
 117       <tr><td colspan="2" id="help"><a href="{$help_url}" target='_blank'>{$mod_strings['LBL_HELP']} </a></td></tr>
 118     <tr>
 119       <th width="500">
 120                 <p>
 121                 <img src="{$sugar_md}" alt="SugarCRM" border="0">
 122                 </p>
 123                 {$mod_strings['LBL_PERFORM_TITLE']}</th>
 124     <th width="200" style="text-align: right;"><a href="http://www.sugarcrm.com" target="_blank">
 125     <IMG src="$loginImage" width="145" height="30" alt="SugarCRM" border="0"></a></th>
 126 </tr>
 127 <tr>
 128    <td colspan="2">
 129 EOQ;
 130 echo $out;
 131 installLog("calling handleSugarConfig()");
 132 $bottle = handleSugarConfig();
 133 installLog("calling handleLog4Php()");
 134 handleLog4Php();
 135
 136 $server_software = $_SERVER["SERVER_SOFTWARE"];
 137 if(strpos($server_software,'Microsoft-IIS') !== false)
 138 {
 139     installLog("calling handleWebConfig()");
 140         handleWebConfig();
 141 } else {
 142         installLog("calling handleHtaccess()");
 143     handleHtaccess();
 144 }
 145
 146 ///////////////////////////////////////////////////////////////////////////////
 147 ////    START TABLE STUFF
 148 echo "<br>";
 149 echo "<b>{$mod_strings['LBL_PERFORM_TABLES']}</b>";
 150 echo "<br>";
 151
 152 // create the SugarCRM database
 153 if($setup_db_create_database) {
 154     installLog("calling handleDbCreateDatabase()");
 155     handleDbCreateDatabase();
 156 } else {
 157
 158 // ensure the charset and collation are utf8
 159     installLog("calling handleDbCharsetCollation()");
 160     handleDbCharsetCollation();
 161 }
 162
 163 // create the SugarCRM database user
 164 if($setup_db_create_sugarsales_user)
 165     handleDbCreateSugarUser();
 166
 167 foreach( $beanFiles as $bean => $file ){
 168     require_once( $file );
 169 }
 170
 171 // load up the config_override.php file.
 172 // This is used to provide default user settings
 173 if( is_file("config_override.php") ){
 174     require_once("config_override.php");
 175 }
 176
 177 $db                 = DBManagerFactory::getInstance();
 178 $startTime          = microtime(true);
 179 $focus              = 0;
 180 $processed_tables   = array(); // for keeping track of the tables we have worked on
 181 $empty              = '';
 182 $new_tables     = 1; // is there ever a scenario where we DON'T create the admin user?
 183 $new_config         = 1;
 184 $new_report     = 1;
 185
 186 // add non-module Beans to this array to keep the installer from erroring.
 187 $nonStandardModules = array (
 188     //'Tracker',
 189 );
 190
 191
 192 /**
 193  * loop through all the Beans and create their tables
 194  */
 195  installLog("looping through all the Beans and create their tables");
 196  //start by clearing out the vardefs
 197  VardefManager::clearVardef();
 198 foreach( $beanFiles as $bean => $file ) {
 199         $doNotInit = array('Scheduler', 'SchedulersJob', 'ProjectTask');
 200
 201         if(in_array($bean, $doNotInit)) {
 202                 $focus = new $bean(false);
 203         } else {
 204             $focus = new $bean();
 205         }
 206
 207         if ( $bean == 'Configurator' )
 208             continue;
 209
 210     $table_name = $focus->table_name;
 211      installLog("processing table ".$focus->table_name);
 212     // check to see if we have already setup this table
 213     if(!in_array($table_name, $processed_tables)) {
 214         if(!file_exists("modules/".$focus->module_dir."/vardefs.php")){
 215             continue;
 216         }
 217         if(!in_array($bean, $nonStandardModules)) {
 218             require_once("modules/".$focus->module_dir."/vardefs.php"); // load up $dictionary
 219             if($dictionary[$focus->object_name]['table'] == 'does_not_exist') {
 220                 continue; // support new vardef definitions
 221             }
 222         } else {
 223                 continue; //no further processing needed for ignored beans.
 224         }
 225
 226         // table has not been setup...we will do it now and remember that
 227         $processed_tables[] = $table_name;
 228
 229         $focus->db->database = $db->database; // set db connection so we do not need to reconnect
 230
 231         if($setup_db_drop_tables) {
 232             drop_table_install($focus);
 233             installLog("dropping table ".$focus->table_name);
 234         }
 235
 236         if(create_table_if_not_exist($focus)) {
 237             installLog("creating table ".$focus->table_name);
 238             if( $bean == "User" ){
 239                 $new_tables = 1;
 240             }
 241             if($bean == "Administration")
 242                 $new_config = 1;
 243
 244
 245         }
 246
 247         installLog("creating Relationship Meta for ".$focus->getObjectName());
 248         SugarBean::createRelationshipMeta($focus->getObjectName(), $db, $table_name, $empty, $focus->module_dir);
 249                 echo ".";
 250
 251     } // end if()
 252 }
 253
 254 echo "<br>";
 255 ////    END TABLE STUFF
 256
 257 ///////////////////////////////////////////////////////////////////////////////
 258 ////    START RELATIONSHIP CREATION
 259
 260     ksort($rel_dictionary);
 261     foreach( $rel_dictionary as $rel_name => $rel_data ){
 262         $table = $rel_data['table'];
 263
 264         if( $setup_db_drop_tables ){
 265             if( $db->tableExists($table) ){
 266                 $db->dropTableName($table);
 267             }
 268         }
 269
 270         if( !$db->tableExists($table) ){
 271             $db->createTableParams($table, $rel_data['fields'], $rel_data['indices']);
 272         }
 273
 274         SugarBean::createRelationshipMeta($rel_name,$db,$table,$rel_dictionary,'');
 275     }
 276
 277 ///////////////////////////////////////////////////////////////////////////////
 278 ////    START CREATE DEFAULTS
 279     echo "<br>";
 280     echo "<b>{$mod_strings['LBL_PERFORM_CREATE_DEFAULT']}</b><br>";
 281     echo "<br>";
 282     installLog("Begin creating Defaults");
 283     if ($new_config) {
 284         installLog("insert defaults into config table");
 285         insert_default_settings();
 286     }
 287
 288
 289
 290
 291
 292     if ($new_tables) {
 293         echo $line_entry_format.$mod_strings['LBL_PERFORM_DEFAULT_USERS'].$line_exit_format;
 294         installLog($mod_strings['LBL_PERFORM_DEFAULT_USERS']);
 295         create_default_users();
 296         echo $mod_strings['LBL_PERFORM_DONE'];
 297     } else {
 298         echo $line_entry_format.$mod_strings['LBL_PERFORM_ADMIN_PASSWORD'].$line_exit_format;
 299         installLog($mod_strings['LBL_PERFORM_ADMIN_PASSWORD']);
 300         $db->setUserName($setup_db_sugarsales_user);
 301         $db->setUserPassword($setup_db_sugarsales_password);
 302         set_admin_password($setup_site_admin_password);
 303         echo $mod_strings['LBL_PERFORM_DONE'];
 304     }
 305
 306
 307
 308
 309     // default OOB schedulers
 310
 311     echo $line_entry_format.$mod_strings['LBL_PERFORM_DEFAULT_SCHEDULER'].$line_exit_format;
 312     installLog($mod_strings['LBL_PERFORM_DEFAULT_SCHEDULER']);
 313     $scheduler = new Scheduler();
 314     $scheduler->rebuildDefaultSchedulers();
 315
 316
 317     echo $mod_strings['LBL_PERFORM_DONE'];
 318
 319
 320
 321 // Enable Sugar Feeds and add all feeds by default
 322 installLog("Enable SugarFeeds");
 323 enableSugarFeeds();
 324
 325
 326 // Enable the InsideView connector and add all modules
 327 installLog("Enable InsideView Connector");
 328 enableInsideViewConnector();
 329
 330 ///////////////////////////////////////////////////////////////////////////////
 331 ////    START DEMO DATA
 332
 333     // populating the db with seed data
 334     installLog("populating the db with seed data");
 335     if( $_SESSION['demoData'] != 'no' ){
 336         set_time_limit( 301 );
 337
 338       echo "<br>";
 339         echo "<b>{$mod_strings['LBL_PERFORM_DEMO_DATA']}</b>";
 340         echo "<br><br>";
 341
 342         print( $render_table_close );
 343         print( $render_table_open );
 344
 345         global $current_user;
 346         $current_user = new User();
 347         $current_user->retrieve(1);
 348         include("install/populateSeedData.php");
 349     }
 350
 351     $endTime = microtime(true);
 352     $deltaTime = $endTime - $startTime;
 353
 354
 355
 356 ///////////////////////////////////////////////////////////////////////////
 357 ////    FINALIZE LANG PACK INSTALL
 358     if(isset($_SESSION['INSTALLED_LANG_PACKS']) && is_array($_SESSION['INSTALLED_LANG_PACKS']) && !empty($_SESSION['INSTALLED_LANG_PACKS'])) {
 359         updateUpgradeHistory();
 360     }
 361
 362     ///////////////////////////////////////////////////////////////////////////
 363     ////    HANDLE SUGAR VERSIONS
 364     require_once('modules/Versions/InstallDefaultVersions.php');
 365
 366
 367
 368     require_once('modules/Connectors/InstallDefaultConnectors.php');
 369
 370         ///////////////////////////////////////////////////////////////////////////////
 371         ////    INSTALL PASSWORD TEMPLATES
 372     include('install/seed_data/Advanced_Password_SeedData.php');
 373
 374 ///////////////////////////////////////////////////////////////////////////////
 375 ////    SETUP DONE
 376 installLog("Installation has completed *********");
 377 $memoryUsed = '';
 378     if(function_exists('memory_get_usage')) {
 379     $memoryUsed = $mod_strings['LBL_PERFORM_OUTRO_5'].memory_get_usage().$mod_strings['LBL_PERFORM_OUTRO_6'];
 380     }
 381
 382
 383 $errTcpip = '';
 384     $fp = @fsockopen("www.sugarcrm.com", 80, $errno, $errstr, 3);
 385     if (!$fp) {
 386     $errTcpip = "<p>{$mod_strings['ERR_PERFORM_NO_TCPIP']}</p>";
 387     }
 388    if ($fp && (!isset( $_SESSION['oc_install']) ||  $_SESSION['oc_install'] == false)) {
 389       @fclose($fp);
 390       if ( $next_step == 9999 )
 391           $next_step = 8;
 392     $fpResult =<<<FP
 393      <form action="install.php" method="post" name="form" id="form">
 394      <input type="hidden" name="current_step" value="{$next_step}">
 395      <table cellspacing="0" cellpadding="0" border="0" class="stdTable">
 396        <tr>
 397          <td>
 398             &nbsp;
 399          </td>
 400          <td><input class="button" type="submit" name="goto" value="{$mod_strings['LBL_NEXT']}" id="button_next2"/></td>
 401        </tr>
 402      </table>
 403      </form>
 404 FP;
 405    } else {
 406         $fpResult =<<<FP
 407      <table cellspacing="0" cellpadding="0" border="0" class="stdTable">
 408        <tr>
 409          <td>&nbsp;</td>
 410          <td>
 411             <form action="index.php" method="post" name="formFinish" id="formFinish">
 412                 <input type="hidden" name="default_user_name" value="admin" />
 413                 <input class="button" type="submit" name="next" value="{$mod_strings['LBL_PERFORM_FINISH']}" id="button_next2"/>
 414             </form>
 415          </td>
 416        </tr>
 417      </table>
 418 FP;
 419    }
 420
 421     if( isset($_SESSION['setup_site_sugarbeet_automatic_checks']) && $_SESSION['setup_site_sugarbeet_automatic_checks'] == true){
 422         set_CheckUpdates_config_setting('automatic');
 423     }else{
 424         set_CheckUpdates_config_setting('manual');
 425     }
 426     if(!empty($_SESSION['setup_system_name'])){
 427         $admin=new Administration();
 428         $admin->saveSetting('system','name',$_SESSION['setup_system_name']);
 429     }
 430
 431
 432     // Bug 28601 - Set the default list of tabs to show
 433     $enabled_tabs = array();
 434     $enabled_tabs[] = 'Home';
 435
 436     $enabled_tabs[] = 'Accounts';
 437     $enabled_tabs[] = 'Contacts';
 438     $enabled_tabs[] = 'Opportunities';
 439     $enabled_tabs[] = 'Leads';
 440     $enabled_tabs[] = 'Calendar';
 441     $enabled_tabs[] = 'Documents';
 442     $enabled_tabs[] = 'Emails';
 443     $enabled_tabs[] = 'Campaigns';
 444     $enabled_tabs[] = 'Calls';
 445     $enabled_tabs[] = 'Meetings';
 446     $enabled_tabs[] = 'Tasks';
 447     $enabled_tabs[] = 'Notes';
 448     $enabled_tabs[] = 'Cases';
 449     $enabled_tabs[] = 'Prospects';
 450     $enabled_tabs[] = 'ProspectLists';
 451
 452
 453     require_once('modules/MySettings/TabController.php');
 454     $tabs = new TabController();
 455     $tabs->set_system_tabs($enabled_tabs);
 456
 457 post_install_modules();
 458
 459 //Call rebuildSprites
 460 if(function_exists('imagecreatetruecolor'))
 461 {
 462     require_once('modules/UpgradeWizard/uw_utils.php');
 463     rebuildSprites(true);
 464 }
 465
 466 if( count( $bottle ) > 0 ){
 467     foreach( $bottle as $bottle_message ){
 468         $bottleMsg .= "{$bottle_message}\n";
 469     }
 470 } else {
 471     $bottleMsg = $mod_strings['LBL_PERFORM_SUCCESS'];
 472 }
 473
 474
 475
 476 $out =<<<EOQ
 477 <br><p><b>{$mod_strings['LBL_PERFORM_OUTRO_1']} {$setup_sugar_version} {$mod_strings['LBL_PERFORM_OUTRO_2']}</b></p>
 478
 479 {$mod_strings['LBL_PERFORM_OUTRO_3']} {$deltaTime} {$mod_strings['LBL_PERFORM_OUTRO_4']}<br />
 480 {$memoryUsed}
 481 {$errTcpip}
 482     </td>
 483 </tr>
 484 <tr>
 485 <td align="right" colspan="2">
 486 <hr>
 487 <table cellspacing="0" cellpadding="0" border="0" class="stdTable">
 488 <tr>
 489 <td>
 490 {$fpResult}
 491 </td>
 492 </tr>
 493 </table>
 494 </td>
 495 </tr>
 496 </table>
 497 </body>
 498 </html>
 499 <!--
 500 <bottle>{$bottleMsg}</bottle>
 501 -->
 502 EOQ;
 503
 504 echo $out;
 505
 506
 507 ?>