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.
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.
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
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
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.
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.
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 ********************************************************************************/
42 function checkDBSettings($silent=false) {
43 installLog("Begin DB Check Process *************");
44 if(function_exists('mysqli_connect')){
45 $_SESSION['mysql_type'] = 'mysqli';
47 if(function_exists('sqlsrv_connect')){
48 $_SESSION['mssql_type'] = 'sqlsrv';
54 copyInputsIntoSession();
56 installLog("Checking DB Name is valid.");
58 $_SESSION['setup_db_database_name'] = trim($_SESSION['setup_db_database_name']);
60 if($_SESSION['setup_db_database_name'] == '' ){
61 $errors['ERR_DB_NAME'] = $mod_strings['ERR_DB_NAME'];
62 installLog("ERROR:: {$errors['ERR_DB_NAME']}");
65 if (!isValidDBName($_SESSION['setup_db_database_name'], $_SESSION['setup_db_type'])) {
66 $errIdx = 'ERR_DB_' . strtoupper($_SESSION['setup_db_type']) . '_DB_NAME_INVALID';
67 $errors[$errIdx] = $mod_strings[$errIdx];
68 installLog("ERROR:: {$errors[$errIdx]}");
71 if($_SESSION['setup_db_type'] != 'oci8') {
73 if( trim($_SESSION['setup_db_host_name']) == '' ){
74 $errors['ERR_DB_HOSTNAME'] = $mod_strings['ERR_DB_HOSTNAME'];
75 installLog("ERROR:: {$errors['ERR_DB_HOSTNAME']}");
79 //check to see that password and retype are same, if needed
80 if((isset($_SESSION['dbUSRData']) && !empty($_SESSION['dbUSRData'])) &&
81 ($_SESSION['dbUSRData']=='create' || $_SESSION['dbUSRData']=='provide'))
83 if( $_SESSION['setup_db_sugarsales_password'] != $_SESSION['setup_db_sugarsales_password_retype'] ){
84 $errors['ERR_DBCONF_PASSWORD_MISMATCH'] = $mod_strings['ERR_DBCONF_PASSWORD_MISMATCH'];
85 installLog("ERROR:: {$errors['ERR_DBCONF_PASSWORD_MISMATCH']}");
89 // bail if the basic info isn't valid
90 if( count($errors) > 0 ){
91 installLog("Basic form info is INVALID, exit Process.");
92 return printErrors($errors);
94 installLog("Basic form info is valid, continuing Process.");
97 // test the account that will talk to the db if we're not creating it
98 if( $_SESSION['setup_db_sugarsales_user'] != '' && !$_SESSION['setup_db_create_sugarsales_user'] ){
99 if( $_SESSION['setup_db_type'] == 'mysql' ){
100 installLog("testing with mysql");
101 if(isset($_SESSION['mysql_type']) && $_SESSION['mysql_type'] == 'mysqli'){
102 installLog("MySQLI library detected");
105 if(isset($_SESSION['mysql_type'])){
106 $host_name = getHostPortFromString($_SESSION['setup_db_host_name']);
107 if(empty($host_name)){
108 $link = @mysqli_connect( $_SESSION['setup_db_host_name'], $_SESSION['setup_db_sugarsales_user'], $_SESSION['setup_db_sugarsales_password']);
110 $link = @mysqli_connect( $host_name[0], $_SESSION['setup_db_sugarsales_user'], $_SESSION['setup_db_sugarsales_password'], null, $host_name[1]);
113 $link = @mysql_connect( $_SESSION['setup_db_host_name'],
114 $_SESSION['setup_db_sugarsales_user'],
115 $_SESSION['setup_db_sugarsales_password'] );
119 installLog("Could not make Connection using host: {$_SESSION['setup_db_host_name']}, usr: {$_SESSION['setup_db_sugarsales_user']}");
120 if(isset($_SESSION['mysql_type'])){
121 $errno = mysqli_connect_errno();
122 $error = mysqli_connect_error();
124 $errno = mysql_errno();
125 $error = mysql_error();
128 $errors['ERR_DB_LOGIN_FAILURE'] = $mod_strings['ERR_DB_LOGIN_FAILURE_MYSQL'];
129 installLog("ERROR:: {$errors['ERR_DB_LOGIN_FAILURE']}");
132 installLog("Connection made using host: {$_SESSION['setup_db_host_name']}, usr: {$_SESSION['setup_db_sugarsales_user']}");
133 if(isset($_SESSION['mysql_type'])){
134 mysqli_close($link );
139 } elseif( $_SESSION['setup_db_type'] == 'mssql' ) {
140 installLog("testing with mssql");
142 $_SESSION['setup_db_host_instance'] = trim($_SESSION['setup_db_host_instance']);
144 if (empty($_SESSION['setup_db_host_instance'])){
145 $connect_host = $_SESSION['setup_db_host_name'];
147 $connect_host = $_SESSION['setup_db_host_name']. "\\" . $_SESSION['setup_db_host_instance'];
149 if(isset($_SESSION['mssql_type'])){
150 $connect_params = array(
151 "UID"=>$_SESSION['setup_db_sugarsales_user'],
152 "PWD"=>$_SESSION['setup_db_sugarsales_password'],
153 "MultipleActiveResultSets"=>false,
155 $link = sqlsrv_connect( $connect_host , $connect_params);
158 $link = @mssql_connect( $connect_host ,
159 $_SESSION['setup_db_sugarsales_user'],
160 $_SESSION['setup_db_sugarsales_password'] );
163 $errors['ERR_DB_LOGIN_FAILURE'] = $mod_strings['ERR_DB_LOGIN_FAILURE_MSSQL'];
164 installLog("ERROR:: {$errors['ERR_DB_LOGIN_FAILURE']}");
166 installLog("Connection made using host: {$_SESSION['setup_db_host_name']}, usr: {$_SESSION['setup_db_sugarsales_user']}");
167 if(isset($_SESSION['mssql_type'])){
168 sqlsrv_close($link );
174 // Bug 29855 - Check to see if given db name is valid
175 // if (preg_match("/^[0-9#@]+|[\"\'\*\/\\?\:\\<\>\-\ \&\!\(\)\[\]\{\}\;\,\.\`\~\|\\\\]+/i", $_SESSION['setup_db_database_name']) ) {
176 // $errors['ERR_DB_MSSQL_DB_NAME'] = $mod_strings['ERR_DB_MSSQL_DB_NAME_INVALID'];
177 // installLog("ERROR:: {$errors['ERR_DB_MSSQL_DB_NAME']}");
179 // Moved to isValidDBName function in db_utils.php
181 } elseif( $_SESSION['setup_db_type'] == 'oci8' ){
185 // privileged account tests
186 if( $_SESSION['setup_db_admin_user_name'] == '' ){
187 $errors['ERR_DB_PRIV_USER'] = $mod_strings['ERR_DB_PRIV_USER'];
188 installLog("ERROR:: {$errors['ERR_DB_PRIV_USER']}");
191 installLog("Testing priviliged account...");
192 if( $_SESSION['setup_db_type'] == 'mysql' ){
193 if(isset($_SESSION['mysql_type'])){
194 $host_name = getHostPortFromString($_SESSION['setup_db_host_name']);
195 if(empty($host_name)){
196 $link = @mysqli_connect( $_SESSION['setup_db_host_name'], $_SESSION['setup_db_admin_user_name'], $_SESSION['setup_db_admin_password']);
198 $link = @mysqli_connect( $host_name[0], $_SESSION['setup_db_admin_user_name'], $_SESSION['setup_db_admin_password'], null, $host_name[1]);
201 $link = @mysql_connect( $_SESSION['setup_db_host_name'],
202 $_SESSION['setup_db_admin_user_name'],
203 $_SESSION['setup_db_admin_password'] );
207 installLog("Connection made for Privileged admin account using host: {$_SESSION['setup_db_host_name']}, usr: {$_SESSION['setup_db_admin_user_name']}");
208 // database admin credentials are valid--can continue check on stuff
209 if(isset($_SESSION['mysql_type'])){
210 $db_selected = @mysqli_select_db($link, $_SESSION['setup_db_database_name']);
212 $db_selected = @mysql_select_db($_SESSION['setup_db_database_name'], $link);
214 if($silent==false && $db_selected && $_SESSION['setup_db_create_database'] && (!isset($_SESSION['setup_db_drop_tables']) || !$_SESSION['setup_db_drop_tables'])){
215 $errStr = $mod_strings['ERR_DB_EXISTS_PROCEED'];
216 $errors['ERR_DB_EXISTS_PROCEED'] = $errStr;
217 installLog("ERROR:: {$errors['ERR_DB_EXISTS_PROCEED']}");
219 else if( !$db_selected && !$_SESSION['setup_db_create_database'] ){
220 $errors['ERR_DB_EXISTS_NOT'] = $mod_strings['ERR_DB_EXISTS_NOT'];
221 installLog("ERROR:: {$errors['ERR_DB_EXISTS_NOT']}");
224 // test for upgrade and inform user about the upgrade wizard
226 installLog("DB Selected, will reuse {$_SESSION['setup_db_database_name']}");
227 if(isset($_SESSION['mysql_type'])){
228 $config_query = "SHOW TABLES LIKE 'config'";
229 $config_result = mysqli_query($link , $config_query);
230 $config_table_exists = (mysqli_num_rows( $config_result ) == 1);
231 mysqli_free_result( $config_result );
232 include('sugar_version.php');
233 if( !$_SESSION['setup_db_drop_tables'] && $config_table_exists ){
234 $query = "SELECT COUNT(*) FROM config WHERE category='info' AND name='sugar_version' AND VALUE LIKE '$sugar_db_version'";
235 $result = mysqli_query( $link , $query );
236 $row = mysqli_fetch_row( $result );
237 if($row[0] != 1 && $silent==false) {
238 $errors['ERR_DB_EXISTS_WITH_CONFIG'] = $mod_strings['ERR_DB_EXISTS_WITH_CONFIG'];
239 installLog("ERROR:: {$errors['ERR_DB_EXISTS_WITH_CONFIG']}");
241 mysqli_free_result($result);
244 $config_query = "SHOW TABLES LIKE 'config'";
245 $config_result = mysql_query( $config_query, $link );
246 $config_table_exists = (mysql_num_rows( $config_result ) == 1);
247 mysql_free_result( $config_result );
248 include('sugar_version.php');
249 if( !$_SESSION['setup_db_drop_tables'] && $config_table_exists ){
250 $query = "SELECT COUNT(*) FROM config WHERE category='info' AND name='sugar_version' AND VALUE LIKE '$sugar_db_version'";
251 $result = mysql_query( $query, $link );
252 $row = mysql_fetch_row( $result );
253 if($row[0] != 1 && $silent==false) {
254 $errors['ERR_DB_EXISTS_WITH_CONFIG'] = $mod_strings['ERR_DB_EXISTS_WITH_CONFIG'];
255 installLog("ERROR:: {$errors['ERR_DB_EXISTS_WITH_CONFIG']}");
257 mysql_free_result($result);
262 installLog("DB not selected, will create {$_SESSION['setup_db_database_name']}");
266 // check for existing SugarCRM database user if create flag is set,
267 //user name has been given, and database has been selected (reusing db, not creating new one)
268 if($_SESSION['setup_db_create_sugarsales_user'] && $_SESSION['setup_db_sugarsales_user'] != '' && $db_selected){
269 if(isset($_SESSION['mysql_type'])){
270 $mysqli_db_selected = mysqli_select_db($link, 'mysql');
271 $user = $_SESSION['setup_db_sugarsales_user'];
272 $query = "select count(*) from user where User ='$user'";
273 $result = mysqli_query($link, $query);
275 $errno = mysqli_connect_errno();
276 $error = mysqli_connect_error();
277 $errors['ERR_DB_ADMIN'] = $mod_strings['ERR_DB_ADMIN'].$errno. ": {$error}).";
278 installLog("ERROR:: {$errors['ERR_DB_ADMIN']}");
280 $row = mysqli_fetch_row($result);
282 $errors['ERR_DB_USER_EXISTS'] = $mod_strings['ERR_DB_USER_EXISTS'];
283 installLog("ERROR:: {$errors['ERR_DB_USER_EXISTS']}");
285 mysqli_free_result($result);
288 $mysql_db_selected = mysql_select_db('mysql', $link);
289 $user = $_SESSION['setup_db_sugarsales_user'];
290 $query = "select count(*) from user where User ='$user'";
291 $result = mysql_query($query, $link);
293 $errno = mysql_errno();
294 $error = mysql_error();
295 $errors['ERR_DB_ADMIN'] = $mod_strings['ERR_DB_ADMIN'].$errno. ": {$error}).";
296 installLog("ERROR:: {$errors['ERR_DB_ADMIN']}");
298 $row = mysql_fetch_row($result);
300 $errors['ERR_DB_USER_EXISTS'] = $mod_strings['ERR_DB_USER_EXISTS'];
301 installLog("ERROR:: {$errors['ERR_DB_USER_EXISTS']}");
302 //do not throw errors, reuse existing user
303 //$_SESSION['setup_db_create_sugarsales_user'] = 0;
305 mysql_free_result($result);
311 // check mysql minimum version requirement
312 $db_version = getMysqlVersion($link);
313 if(version_compare($db_version, '4.1.2') < 0) {
314 $errors['ERR_DB_MYSQL_VERSION1'] = $mod_strings['ERR_DB_MYSQL_VERSION1'].$db_version.$mod_strings['ERR_DB_MYSQL_VERSION2'];
315 installLog("ERROR:: {$errors['ERR_DB_MYSQL_VERSION1']}");
317 installLog("Passed DB Version check, version is {$db_version}");
320 if(isset($_SESSION['mysql_type'])){
326 else { // dblink was bad
327 if(isset($_SESSION['mysql_type'])){
328 $errno = mysqli_connect_errno();
329 $error = mysqli_connect_error();
331 $errno = mysql_errno();
332 $error = mysql_error();
334 $errors['ERR_DB_ADMIN'] = $mod_strings['ERR_DB_ADMIN'].$errno. ": {$error}).";
335 installLog("ERROR:: {$errors['ERR_DB_ADMIN']}");
338 }else if( $_SESSION['setup_db_type'] == 'mssql' ){
339 installLog("Testing priviliged account...");
341 $_SESSION['setup_db_host_instance'] = trim($_SESSION['setup_db_host_instance']);
343 if (empty($_SESSION['setup_db_host_instance'])){
344 $connect_host = $_SESSION['setup_db_host_name'];
346 $connect_host = $_SESSION['setup_db_host_name']. "\\" . $_SESSION['setup_db_host_instance'];
348 if(isset($_SESSION['mssql_type'])){
349 $connect_params = array(
350 "UID"=>$_SESSION['setup_db_sugarsales_user'],
351 "PWD"=>$_SESSION['setup_db_sugarsales_password'],
352 "MultipleActiveResultSets"=>false,
354 $link = sqlsrv_connect( $connect_host , $connect_params);
357 $link = @mssql_connect( $connect_host ,
358 $_SESSION['setup_db_admin_user_name'],
359 $_SESSION['setup_db_admin_password'] );
362 installLog("Connection made for Privileged admin account using host: {$_SESSION['setup_db_host_name']}, usr: {$_SESSION['setup_db_admin_user_name']}");
363 // database admin credentials are valid--can continue check on stuff
364 $tbl_exists_qry = "SELECT name FROM master..sysdatabases WHERE name = N'{$_SESSION['setup_db_database_name']}'";
365 if(isset($_SESSION['mssql_type']))
366 $res = sqlsrv_query($link,$tbl_exists_qry);
368 $res = mssql_query($tbl_exists_qry);
370 if ( isset($_SESSION['mssql_type']) && sqlsrv_fetch( $res) == 1){$db_exists = true;
371 installLog("DB Exists and selected, will reuse {$_SESSION['setup_db_database_name']}");
372 }elseif ( !isset($_SESSION['mssql_type']) && mssql_num_rows( $res) == 1){$db_exists = true;
373 installLog("DB Exists and selected, will reuse {$_SESSION['setup_db_database_name']}");
375 installLog("No DB Selected, will create {$_SESSION['setup_db_database_name']}");
377 if($silent==false && $db_exists && $_SESSION['setup_db_create_database'] && (!isset($_SESSION['setup_db_drop_tables']) || !$_SESSION['setup_db_drop_tables'])){
378 $errStr = $mod_strings['ERR_DB_EXISTS_PROCEED'];
379 $errors['ERR_DB_EXISTS_PROCEED'] = $errStr;
380 installLog("ERROR:: {$errors['ERR_DB_EXISTS_PROCEED']}");
382 else if( !$db_exists && !$_SESSION['setup_db_create_database'] ){
383 $errors['ERR_DB_EXISTS_NOT'] = $mod_strings['ERR_DB_EXISTS_NOT'];
384 installLog("ERROR:: {$errors['ERR_DB_EXISTS_NOT']}");
387 // check for existing SugarCRM database user if create flag is set,
388 //user name has been given, and database has been selected (reusing db, not creating new one)
389 if($_SESSION['setup_db_create_sugarsales_user'] && $_SESSION['setup_db_sugarsales_user'] != ''){
390 if(isset($_SESSION['mssql_type'])) {
391 $mssql_db_selected = (bool) sqlsrv_query($link,'USE master');
392 $user = $_SESSION['setup_db_sugarsales_user'];
393 $query = "select count(*) from sys.sql_logins where name ='$user'";
394 $result = sqlsrv_query($link, $query);
396 $errors['ERR_DB_ADMIN'] = $mod_strings['ERR_DB_ADMIN'];
397 installLog("ERROR:: {$errors['ERR_DB_ADMIN']}");
399 $row = sqlsrv_fetch_array($result);
401 $errors['ERR_DB_USER_EXISTS'] = $mod_strings['ERR_DB_USER_EXISTS'];
402 installLog("ERROR:: {$errors['ERR_DB_USER_EXISTS']}");
404 sqlsrv_free_stmt($result);
408 $mssql_db_selected = mssql_select_db('master', $link);
409 $user = $_SESSION['setup_db_sugarsales_user'];
410 $query = "select count(*) from sys.sql_logins where name ='$user'";
411 $result = mssql_query($query, $link);
413 $errors['ERR_DB_ADMIN'] = $mod_strings['ERR_DB_ADMIN'];
414 installLog("ERROR:: {$errors['ERR_DB_ADMIN']}");
416 $row = mssql_fetch_row($result);
418 $errors['ERR_DB_USER_EXISTS'] = $mod_strings['ERR_DB_USER_EXISTS'];
419 installLog("ERROR:: {$errors['ERR_DB_USER_EXISTS']}");
421 mssql_free_result($result);
426 if(isset($_SESSION['mssql_type']))
432 else { // dblink was bad
433 $errors['ERR_DB_ADMIN_MSSQL'] = $mod_strings['ERR_DB_ADMIN_MSSQL'].$connect_host;
434 installLog("ERROR:: {$errors['ERR_DB_ADMIN_MSSQL']}");
437 }else if( $_SESSION['setup_db_type'] == 'oci8' ){
439 } // end of privileged user tests
443 printErrors($errors);
445 installLog("End DB Check Process *************");
448 function printErrors($errors ){
451 if(count($errors) == 0){
452 echo 'dbCheckPassed';
453 installLog("SUCCESS:: no errors detected!");
454 }else if((count($errors) == 1 && isset($errors["ERR_DB_EXISTS_PROCEED"])) ||
455 (count($errors) == 2 && isset($errors["ERR_DB_EXISTS_PROCEED"]) && isset($errors["ERR_DB_EXISTS_WITH_CONFIG"])) ){
456 ///throw alert asking to overwwrite db
458 installLog("WARNING:: no errors detected, but DB tables will be dropped!, issuing warning to user");
460 installLog("FATAL:: errors have been detected! User will not be allowed to continue. Errors are as follow:");
462 $validationErr = "<p><b>{$mod_strings['ERR_DBCONF_VALIDATION']}</b></p>";
463 $validationErr .= '<ul>';
465 foreach($errors as $key =>$erMsg){
466 if($key != "ERR_DB_EXISTS_PROCEED" && $key != "ERR_DB_EXISTS_WITH_CONFIG"){
467 if($_SESSION['dbUSRData'] == 'same' && $key == 'ERR_DB_ADMIN'){
468 installLog(".. {$erMsg}");
471 $validationErr .= '<li class="error">' . $erMsg . '</li>';
472 installLog(".. {$erMsg}");
475 $validationErr .= '</ul>';
476 $validationErr .= '</div>';
484 function copyInputsIntoSession(){
485 if(isset($_REQUEST['setup_db_type'])){$_SESSION['setup_db_type'] = $_REQUEST['setup_db_type'];}
486 if(isset($_REQUEST['setup_db_admin_user_name'])){$_SESSION['setup_db_admin_user_name'] = $_REQUEST['setup_db_admin_user_name'];}
487 if(isset($_REQUEST['setup_db_admin_password'])){$_SESSION['setup_db_admin_password'] = $_REQUEST['setup_db_admin_password'];}
488 if(isset($_REQUEST['setup_db_database_name'])){$_SESSION['setup_db_database_name'] = $_REQUEST['setup_db_database_name'];}
489 if(isset($_REQUEST['setup_db_host_name'])){$_SESSION['setup_db_host_name'] = $_REQUEST['setup_db_host_name'];}
491 if(isset($_REQUEST['setup_db_host_instance'])){
492 $_SESSION['setup_db_host_instance'] = $_REQUEST['setup_db_host_instance'];
496 // on a silent install, copy values from $_SESSION into $_REQUEST
497 if (isset($_REQUEST['goto']) && $_REQUEST['goto'] == 'SilentInstall') {
498 if (isset($_SESSION['dbUSRData']) && !empty($_SESSION['dbUSRData']))
499 $_REQUEST['dbUSRData'] = $_SESSION['dbUSRData'];
500 else $_REQUEST['dbUSRData'] = 'same';
502 if (isset($_SESSION['setup_db_sugarsales_user']) && !empty($_SESSION['setup_db_sugarsales_user']))
503 $_REQUEST['setup_db_sugarsales_user'] = $_SESSION['setup_db_sugarsales_user'];
504 else $_REQUEST['dbUSRData'] = 'same';
506 $_REQUEST['setup_db_sugarsales_password'] = $_SESSION['setup_db_sugarsales_password'];
507 $_REQUEST['setup_db_sugarsales_password_retype'] = $_SESSION['setup_db_sugarsales_password'];
510 //make sure we are creating or using provided user for app db connections
511 $_SESSION['setup_db_create_sugarsales_user'] = true;//get_boolean_from_request('setup_db_create_sugarsales_user');
512 if( $_SESSION['setup_db_type'] == 'oci8' ){
513 //if we are in Oracle Mode, make the admin user/password same as connecting user/password
514 $_SESSION['setup_db_sugarsales_user'] = $_SESSION['setup_db_admin_user_name'];
515 $_SESSION['setup_db_sugarsales_password'] = $_SESSION['setup_db_admin_password'];
516 $_SESSION['setup_db_sugarsales_password_retype'] = $_SESSION['setup_db_sugarsales_password'];
517 $_SESSION['setup_db_create_sugarsales_user'] = false;
518 $_SESSION['setup_db_create_database'] = false;
520 }//elseif(isset($_SESSION['install_type']) && !empty($_SESSION['install_type']) && strtolower($_SESSION['install_type'])=='typical'){
524 //retrieve the value from dropdown in order to know what settings the user
525 //wants to use for the sugar db user.
527 //use provided db admin by default
528 $_SESSION['dbUSRData'] = 'same';
530 if(isset($_REQUEST['dbUSRData']) && !empty($_REQUEST['dbUSRData'])){
531 $_SESSION['dbUSRData'] = $_REQUEST['dbUSRData'];
535 if($_SESSION['dbUSRData'] == 'auto'){
536 //create user automatically
537 $_SESSION['setup_db_create_sugarsales_user'] = true;
538 $_SESSION['setup_db_sugarsales_user'] = "sugar".create_db_user_creds(5);
539 $_SESSION['setup_db_sugarsales_password'] = create_db_user_creds(10);
540 $_SESSION['setup_db_sugarsales_password_retype'] = $_SESSION['setup_db_sugarsales_password'];
541 }elseif($_SESSION['dbUSRData'] == 'provide'){
542 //use provided user info
543 $_SESSION['setup_db_create_sugarsales_user'] = false;
544 $_SESSION['setup_db_sugarsales_user'] = $_REQUEST['setup_db_sugarsales_user'];
545 $_SESSION['setup_db_sugarsales_password'] = $_REQUEST['setup_db_sugarsales_password'];
546 $_SESSION['setup_db_sugarsales_password_retype'] = $_REQUEST['setup_db_sugarsales_password_retype'];
547 }elseif($_SESSION['dbUSRData'] == 'create'){
548 // create user with provided info
549 $_SESSION['setup_db_create_sugarsales_user'] = true;
550 $_SESSION['setup_db_sugarsales_user'] = $_REQUEST['setup_db_sugarsales_user'];
551 $_SESSION['setup_db_sugarsales_password'] = $_REQUEST['setup_db_sugarsales_password'];
552 $_SESSION['setup_db_sugarsales_password_retype'] = $_REQUEST['setup_db_sugarsales_password_retype'];
554 //Use the same login as provided admin user
555 $_SESSION['setup_db_create_sugarsales_user'] = false;
556 $_SESSION['setup_db_sugarsales_user'] = $_SESSION['setup_db_admin_user_name'];
557 $_SESSION['setup_db_sugarsales_password'] = $_SESSION['setup_db_admin_password'];
558 $_SESSION['setup_db_sugarsales_retype'] = $_SESSION['setup_db_admin_password'];
562 if(!isset($_SESSION['demoData']) || empty($_SESSION['demoData'])){
563 $_SESSION['demoData'] = 'no';
565 if(isset($_REQUEST['demoData'])){$_SESSION['demoData'] = $_REQUEST['demoData'] ;}
566 if (isset($_REQUEST['goto']) && $_REQUEST['goto'] == 'SilentInstall' && isset($SESSION['setup_db_drop_tables'])) {
567 //set up for Oracle Silent Installer
568 $_REQUEST['setup_db_drop_tables'] = $_SESSION['setup_db_drop_tables'] ;
570 if (isset($_REQUEST['setup_db_drop_tables'])
571 || ((isset($_REQUEST['goto']) && $_REQUEST['goto'] == 'SilentInstall' && isset($SESSION['setup_db_drop_tables'])))
573 $_SESSION['setup_db_drop_tables'] = true;
574 $_SESSION['setup_db_create_database'] = false;
577 $_SESSION['setup_db_drop_tables'] = false;
578 $_SESSION['setup_db_create_database'] = true;
583 ///////////////////////////////////////////////////////////////////////////////