455 lines
19 KiB
PHP
Executable File
455 lines
19 KiB
PHP
Executable File
<?php
|
|
if (!defined('sugarEntry') || !sugarEntry) {
|
|
die('Not A Valid Entry Point');
|
|
}
|
|
/**
|
|
*
|
|
* SugarCRM Community Edition is a customer relationship management program developed by
|
|
* SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
|
|
*
|
|
* SuiteCRM is an extension to SugarCRM Community Edition developed by SalesAgility Ltd.
|
|
* Copyright (C) 2011 - 2018 SalesAgility Ltd.
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify it under
|
|
* the terms of the GNU Affero 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 Affero General Public License for more
|
|
* details.
|
|
*
|
|
* You should have received a copy of the GNU Affero 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 Affero General Public License version 3.
|
|
*
|
|
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
|
|
* these Appropriate Legal Notices must retain the display of the "Powered by
|
|
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
|
|
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
|
|
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
|
|
*/
|
|
|
|
|
|
|
|
global $sugar_version, $js_custom_version;
|
|
|
|
|
|
if (empty($_SESSION['setup_db_host_name'])) {
|
|
$_SESSION['setup_db_host_name'] = (isset($sugar_config['db_host_name'])) ? $sugar_config['db_host_name'] : $_SERVER['SERVER_NAME'];
|
|
}
|
|
|
|
if (!isset($install_script) || !$install_script) {
|
|
die($mod_strings['ERR_NO_DIRECT_SCRIPT']);
|
|
}
|
|
|
|
|
|
// DB split
|
|
$createDbCheckbox = '';
|
|
$createDb = (!empty($_SESSION['setup_db_create_database'])) ? 'checked="checked"' : '';
|
|
$dropCreate = (!empty($_SESSION['setup_db_drop_tables'])) ? 'checked="checked"' : '';
|
|
$instanceName = '';
|
|
if (isset($_SESSION['setup_db_host_instance']) && !empty($_SESSION['setup_db_host_instance'])) {
|
|
$instanceName = $_SESSION['setup_db_host_instance'];
|
|
}
|
|
|
|
$setupDbPortNum ='';
|
|
if (isset($_SESSION['setup_db_port_num']) && !empty($_SESSION['setup_db_port_num'])) {
|
|
$setupDbPortNum = $_SESSION['setup_db_port_num'];
|
|
}
|
|
|
|
$db = getInstallDbInstance();
|
|
|
|
///////////////////////////////////////////////////////////////////////////////
|
|
//// BEGIN PAGE OUTPUT
|
|
|
|
$langHeader = get_language_header();
|
|
|
|
$out =<<<EOQ
|
|
<!DOCTYPE HTML>
|
|
<html {$langHeader}>
|
|
<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_DBCONF_TITLE']}</title>
|
|
<link rel="stylesheet" href="install/install.css" type="text/css" />
|
|
<link rel='stylesheet' type='text/css' href='include/javascript/yui/build/container/assets/container.css' />
|
|
<link rel="stylesheet" href="themes/SuiteP/css/fontello.css">
|
|
<link rel="stylesheet" href="themes/SuiteP/css/animation.css"><!--[if IE 7]><link rel="stylesheet" href="css/fontello-ie7.css"><![endif]-->
|
|
<link REL="SHORTCUT ICON" HREF="include/images/sugar_icon.ico">
|
|
<script type="text/javascript" src="install/installCommon.js"></script>
|
|
<script type="text/javascript" src="install/dbConfig.js"></script>
|
|
<script src="cache/include/javascript/sugar_grp1_yui.js?s={$sugar_version}&c={$js_custom_version}"></script>
|
|
<script src="cache/include/javascript/sugar_grp1_jquery.js?s={$sugar_version}&c={$js_custom_version}"></script>
|
|
</head>
|
|
|
|
EOQ;
|
|
$out .= '<body onload="document.getElementById(\'button_next2\').focus();">';
|
|
|
|
$out2 =<<<EOQ2
|
|
<!--SuiteCRM installer-->
|
|
<div id="install_container">
|
|
<div id="install_box">
|
|
<form action="install.php" method="post" name="setConfig" id="form">
|
|
<div id="install_content">
|
|
<header id="install_header">
|
|
<div id="steps"><p>{$mod_strings['LBL_STEP5']}</p><i class="icon-progress-0" id="complete"></i><i class="icon-progress-1" id="complete"></i><i class="icon-progress-2" id="complete"></i><i class="icon-progress-3" id="complete"></i><i class="icon-progress-4" id="complete"></i><i class="icon-progress-5"></i><i class="icon-progress-6"></i><i class="icon-progress-7"></i></div>
|
|
<div class="install_img"><a href="https://suitecrm.com" target="_blank"><img src="{$sugar_md}" alt="SuiteCRM"></a></div>
|
|
</header>
|
|
<input type='hidden' name='setup_db_drop_tables' id='setup_db_drop_tables' value=''>
|
|
<input type="hidden" id="hidden_goto" name="goto" value="{$mod_strings['LBL_BACK']}" />
|
|
<h2>{$mod_strings['LBL_DBCONF_TITLE']}</h2>
|
|
<div id="errorMsgs" style="display:none"></div>
|
|
<div class="required">{$mod_strings['LBL_REQUIRED']}</div>
|
|
<hr>
|
|
<h3>{$mod_strings['LBL_DBCONF_TITLE_NAME']}</h3>
|
|
|
|
EOQ2;
|
|
|
|
$config_params = $db->installConfig();
|
|
$form = '';
|
|
foreach ($config_params as $group => $gdata) {
|
|
$form.= "<div class='install_block'>";
|
|
$form .= "<label>{$mod_strings[$group]}</label><br>\n";
|
|
foreach ($gdata as $name => $value) {
|
|
if (!empty($value)) {
|
|
if (!empty($value['required'])) {
|
|
$form .= "<span class=\"required\">*</span>";
|
|
} else {
|
|
}
|
|
if (!empty($_SESSION[$name])) {
|
|
$sessval = $_SESSION[$name];
|
|
} else {
|
|
$sessval = '';
|
|
}
|
|
if (!empty($value["type"])) {
|
|
$type = $value["type"];
|
|
} else {
|
|
$type = '';
|
|
}
|
|
|
|
$form .= <<<FORM
|
|
|
|
FORM;
|
|
//if the type is password, set a hidden field to capture the value. This is so that we can properly encode special characters, which is a limitation with password fields
|
|
if ($type=='password') {
|
|
$form .= "<input type='$type' name='{$name}_entry' id='{$name}_entry' value='".urldecode($sessval)."'><input type='hidden' name='$name' id='$name' value='".urldecode($sessval)."'>";
|
|
} else {
|
|
$form .= "<input type='$type' name='$name' id='$name' value='$sessval'>";
|
|
}
|
|
|
|
|
|
|
|
$form .= <<<FORM
|
|
FORM;
|
|
} else {
|
|
$form .= "<input name=\"$name\" id=\"$name\" value=\"\" type=\"hidden\">\n";
|
|
}
|
|
}
|
|
$form .= "</div>";
|
|
}
|
|
|
|
$out2 .= $form;
|
|
|
|
//if we are installing in custom mode, include the following html
|
|
if ($db->supports("create_user")) {
|
|
// create / set db user dropdown
|
|
$auto_select = '';
|
|
$provide_select ='';
|
|
$create_select = '';
|
|
$same_select = '';
|
|
if (isset($_SESSION['dbUSRData'])) {
|
|
// if($_SESSION['dbUSRData']=='auto') {$auto_select ='selected';}
|
|
if ($_SESSION['dbUSRData']=='provide') {
|
|
$provide_select ='selected';
|
|
}
|
|
if (isset($_SESSION['install_type']) && !empty($_SESSION['install_type']) && strtolower($_SESSION['install_type'])=='custom') {
|
|
if ($_SESSION['dbUSRData']=='create') {
|
|
$create_select ='selected';
|
|
}
|
|
}
|
|
if ($_SESSION['dbUSRData']=='same') {
|
|
$same_select ='selected';
|
|
}
|
|
} else {
|
|
$same_select ='selected';
|
|
}
|
|
$dbUSRDD = "<select name='dbUSRData' id='dbUSRData' onchange='toggleDBUser();'>";
|
|
$dbUSRDD .= "<option value='provide' $provide_select>".$mod_strings['LBL_DBCONFIG_PROVIDE_DD']."</option>";
|
|
$dbUSRDD .= "<option value='create' $create_select>".$mod_strings['LBL_DBCONFIG_CREATE_DD']."</option>";
|
|
$dbUSRDD .= "<option value='same' $same_select>".$mod_strings['LBL_DBCONFIG_SAME_DD']."</option>";
|
|
$dbUSRDD .= "</select><br> ";
|
|
|
|
|
|
|
|
$setup_db_sugarsales_password = urldecode($_SESSION['setup_db_sugarsales_password']);
|
|
$setup_db_sugarsales_user = urldecode($_SESSION['setup_db_sugarsales_user']);
|
|
$setup_db_sugarsales_password_retype = urldecode($_SESSION['setup_db_sugarsales_password_retype']);
|
|
|
|
$out2 .=<<<EOQ2
|
|
<br>
|
|
<hr>
|
|
<br>
|
|
{$mod_strings['LBL_DBCONFIG_SECURITY']}
|
|
<div class='install_block'><label><b>{$mod_strings['LBL_DBCONF_SUITE_DB_USER']}</b></label>$dbUSRDD
|
|
<span id='connection_user_div' style="display:none">
|
|
<span class="required">*</span>
|
|
<label><b>{$mod_strings['LBL_DBCONF_SUITE_DB_USER']}</b></label>
|
|
<input type="text" name="setup_db_sugarsales_user" value="{$_SESSION['setup_db_sugarsales_user']}" />
|
|
<label><b>{$mod_strings['LBL_DBCONF_DB_PASSWORD']}</b></label>
|
|
<input type="password" name="setup_db_sugarsales_password_entry" value="{$setup_db_sugarsales_password}" />
|
|
<input type="hidden" name="setup_db_sugarsales_password" value="{$setup_db_sugarsales_password}" />
|
|
<label><b>{$mod_strings['LBL_DBCONF_DB_PASSWORD2']}</b></label>
|
|
<input type="password" name="setup_db_sugarsales_password_retype_entry" value="{$setup_db_sugarsales_password_retype}" /><input type="hidden" name="setup_db_sugarsales_password_retype" value="{$setup_db_sugarsales_password_retype}" />
|
|
</span>
|
|
</div>
|
|
|
|
EOQ2;
|
|
}
|
|
|
|
$demoDD = "<select name='demoData' id='demoData' class='select'><option value='no' >".$mod_strings['LBL_NO']."</option><option value='yes'>".$mod_strings['LBL_YES']."</option>";
|
|
$demoDD .= "</select>";
|
|
|
|
|
|
$out3 =<<<EOQ3
|
|
<hr>
|
|
<div class="install_block">
|
|
<h2>{$mod_strings['LBL_DBCONF_DEMO_DATA_TITLE']}</h2>
|
|
<label>{$mod_strings['LBL_DBCONF_DEMO_DATA']}</label>
|
|
{$demoDD}
|
|
</div>
|
|
<br>
|
|
<br>
|
|
EOQ3;
|
|
|
|
|
|
|
|
$out4 =<<<EOQ4
|
|
</div>
|
|
<hr>
|
|
<div id="installcontrols">
|
|
<input type="hidden" name="current_step" value="{$next_step}">
|
|
<input class="button" type="button" name="goto" value="{$mod_strings['LBL_BACK']}" id="button_back_dbConfig" onclick="document.getElementById('form').submit();" />
|
|
<input class="button" type="button" name="goto" id="button_next2" value="{$mod_strings['LBL_NEXT']}" onClick="callDBCheck();"/>
|
|
</div>
|
|
</form>
|
|
<br>
|
|
|
|
<script>
|
|
|
|
$('#fts_type').change(function(){
|
|
if($(this).val() == '')
|
|
hideFTSSettings();
|
|
else
|
|
showFTSSettings();
|
|
});
|
|
|
|
function showFTSSettings()
|
|
{
|
|
$('#fts_port_row').show();
|
|
$('#fts_host_row').show();
|
|
}
|
|
|
|
function hideFTSSettings()
|
|
{
|
|
$('#fts_port_row').hide();
|
|
$('#fts_host_row').hide();
|
|
}
|
|
|
|
function toggleDBUser(){
|
|
if(typeof(document.getElementById('dbUSRData')) !='undefined'
|
|
&& document.getElementById('dbUSRData') != null){
|
|
|
|
ouv = document.getElementById('dbUSRData').value;
|
|
if(ouv == 'provide' || ouv == 'create'){
|
|
document.getElementById('connection_user_div').style.display = '';
|
|
document.getElementById('sugarDBUs<br>er').style.display = 'none';
|
|
}else{
|
|
document.getElementById('connection_user_div').style.display = 'none';
|
|
document.getElementById('sugarDBUser').style.display = '';
|
|
}
|
|
}
|
|
}
|
|
toggleDBUser();
|
|
|
|
var msgPanel;
|
|
function callDBCheck(){
|
|
|
|
//begin main function that will be called
|
|
ajaxCall = function(msg_panel){
|
|
//create success function for callback
|
|
|
|
getPanel = function() {
|
|
var args = { width:"300px",
|
|
modal:true,
|
|
fixedcenter: true,
|
|
constraintoviewport: false,
|
|
underlay:"shadow",
|
|
close:false,
|
|
draggable:true,
|
|
|
|
effect:{effect:YAHOO.widget.ContainerEffect.FADE, duration:.5}
|
|
} ;
|
|
msg_panel = new YAHOO.widget.Panel('p_msg', args);
|
|
|
|
msg_panel.setHeader("{$mod_strings['LBL_LICENSE_CHKDB_HEADER']}");
|
|
msg_panel.setBody(document.getElementById("checkingDiv").innerHTML);
|
|
msg_panel.render(document.body);
|
|
msgPanel = msg_panel;
|
|
}
|
|
|
|
|
|
passed = function(url){
|
|
document.setConfig.goto.value="{$mod_strings['LBL_NEXT']}";
|
|
document.getElementById('hidden_goto').value="{$mod_strings['LBL_NEXT']}";
|
|
document.setConfig.current_step.value="{$next_step}";
|
|
document.setConfig.submit();
|
|
}
|
|
success = function(o) {
|
|
|
|
//condition for just the preexisting database
|
|
if (o.responseText.indexOf('preexeest')>=0){
|
|
|
|
// throw confirmation message
|
|
msg_panel.setBody(document.getElementById("sysCheckMsg").innerHTML);
|
|
msg_panel.render(document.body);
|
|
msgPanel = msg_panel;
|
|
document.getElementById('accept_btn').focus();
|
|
//condition for no errors
|
|
}else if (o.responseText.indexOf('dbCheckPassed')>=0){
|
|
//make navigation
|
|
passed("install.php?goto={$mod_strings['LBL_NEXT']}");
|
|
|
|
//condition for other errors
|
|
}else{
|
|
//turn off loading message
|
|
msgPanel.hide();
|
|
document.getElementById("errorMsgs").innerHTML = o.responseText;
|
|
document.getElementById("errorMsgs").style.display = '';
|
|
return false;
|
|
}
|
|
|
|
|
|
}//end success
|
|
|
|
|
|
//copy the db values over to the hidden field counterparts
|
|
document.setConfig.setup_db_admin_password.value = document.setConfig.setup_db_admin_password_entry.value;
|
|
|
|
|
|
|
|
//set loading message and create url
|
|
postData = "checkDBSettings=true&to_pdf=1&sugar_body_only=1";
|
|
postData += "&setup_db_database_name="+document.setConfig.setup_db_database_name.value;
|
|
if(typeof(document.setConfig.setup_db_host_instance) != 'undefined'){
|
|
postData += "&setup_db_host_instance="+document.setConfig.setup_db_host_instance.value;
|
|
}
|
|
if(typeof(document.setConfig.setup_db_port_num) != 'undefined'){
|
|
postData += "&setup_db_port_num="+document.setConfig.setup_db_port_num.value;
|
|
}
|
|
postData += "&setup_db_host_name="+document.setConfig.setup_db_host_name.value;
|
|
postData += "&setup_db_admin_user_name="+document.setConfig.setup_db_admin_user_name.value;
|
|
postData += "&setup_db_admin_password="+encodeURIComponent(document.setConfig.setup_db_admin_password.value);
|
|
if(typeof(document.setConfig.setup_db_sugarsales_user) != 'undefined'){
|
|
postData += "&setup_db_sugarsales_user="+document.setConfig.setup_db_sugarsales_user.value;
|
|
}
|
|
if(typeof(document.setConfig.setup_db_sugarsales_password) != 'undefined'){
|
|
document.setConfig.setup_db_sugarsales_password.value = document.setConfig.setup_db_sugarsales_password_entry.value;
|
|
postData += "&setup_db_sugarsales_password="+encodeURIComponent(document.setConfig.setup_db_sugarsales_password.value);
|
|
}
|
|
if(typeof(document.setConfig.setup_db_sugarsales_password_retype) != 'undefined'){
|
|
document.setConfig.setup_db_sugarsales_password_retype.value = document.setConfig.setup_db_sugarsales_password_retype_entry.value;
|
|
postData += "&setup_db_sugarsales_password_retype="+encodeURIComponent(document.setConfig.setup_db_sugarsales_password_retype.value);
|
|
}
|
|
if(typeof(document.setConfig.dbUSRData) != 'undefined'){
|
|
postData += "&dbUSRData="+document.getElementById('dbUSRData').value;
|
|
}
|
|
|
|
EOQ4;
|
|
|
|
|
|
$out_dd = 'postData += "&demoData="+document.setConfig.demoData.value;';
|
|
$out5 =<<<EOQ5
|
|
postData += "&to_pdf=1&sugar_body_only=1";
|
|
|
|
//if this is a call already in progress, then just return
|
|
if(typeof ajxProgress != 'undefined'){
|
|
return;
|
|
}
|
|
|
|
getPanel();
|
|
msgPanel.show;
|
|
var ajxProgress = YAHOO.util.Connect.asyncRequest('POST','install.php', {success: success, failure: success}, postData);
|
|
|
|
|
|
};//end ajaxCall method
|
|
ajaxCall();
|
|
return;
|
|
}
|
|
|
|
function confirm_drop_tables(yes_no){
|
|
|
|
if(yes_no == true){
|
|
document.getElementById('setup_db_drop_tables').value = true;
|
|
//make navigation
|
|
document.setConfig.goto.value="{$mod_strings['LBL_NEXT']}";
|
|
document.getElementById('hidden_goto').value="{$mod_strings['LBL_NEXT']}";
|
|
document.setConfig.current_step.value="{$next_step}";
|
|
document.setConfig.submit();
|
|
}else{
|
|
//set drop tables to false
|
|
document.getElementById('setup_db_drop_tables').value = false;
|
|
msgPanel.hide();
|
|
}
|
|
}
|
|
|
|
</script>
|
|
|
|
<div id="checkingDiv" style="display:none">
|
|
<p><img alt="{$mod_strings['LBL_LICENSE_CHKDB_HEADER']}" src='install/processing.gif'> <br>{$mod_strings['LBL_LICENSE_CHKDB_HEADER']}</p>
|
|
</div>
|
|
|
|
<div id='sysCheckMsg' style="display:none">
|
|
<p>{$mod_strings['LBL_DROP_DB_CONFIRM']}</p>
|
|
<input id='accept_btn' type='button' class='button' onclick='confirm_drop_tables(true)' value="{$mod_strings['LBL_ACCEPT']}">
|
|
<input type='button' class='button' onclick='confirm_drop_tables(false)' id="button_cancel_dbConfig" value="{$mod_strings['LBL_CANCEL']}">
|
|
</div>
|
|
|
|
</div>
|
|
<footer id="install_footer">
|
|
<p id="footer_links"><a href="https://suitecrm.com" target="_blank">Visit suitecrm.com</a> | <a href="https://suitecrm.com/suitecrm/forum" target="_blank">Support Forums</a> | <a href="https://docs.suitecrm.com/admin/installation-guide/" target="_blank">Installation Guide</a> | <a href="LICENSE.txt" target="_blank">License</a>
|
|
</footer>
|
|
</div>
|
|
<script type="text/javascript">
|
|
<!--
|
|
if ( YAHOO.env.ua )
|
|
UA = YAHOO.env.ua;
|
|
-->
|
|
</script>
|
|
</body>
|
|
</html>
|
|
|
|
EOQ5;
|
|
|
|
//// END PAGE OUTPUT
|
|
///////////////////////////////////////////////////////////////////////////////
|
|
|
|
echo $out;
|
|
echo $out2;
|
|
echo $out3;
|
|
echo $out4;
|
|
echo $out_dd;
|
|
echo $out5;
|