fileconf.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2004       Rodolphe Quiedeville    <rodolphe@quiedeville.org>
 * Copyright (C) 2004       Eric Seigne             <eric.seigne@ryxeo.com>
 * Copyright (C) 2004-2012  Laurent Destailleur     <eldy@users.sourceforge.net>
 * Copyright (C) 2004       Benoit Mortier          <benoit.mortier@opensides.be>
 * Copyright (C) 2004       Sebastien DiCintio      <sdicintio@ressource-toi.org>
 * Copyright (C) 2005-2011  Regis Houssin           <regis.houssin@inodbox.com>
 * Copyright (C) 2016       Raphaël Doursenaud      <rdoursenaud@gpcsolutions.fr>
 * Copyright (C) 2024-2025  MDW           <mdeweerd@users.noreply.github.com>
 * Copyright (C) 2024-2025  Frédéric France         <frederic.france@free.fr>
 * Copyright (C) 2025     Charlene Benke          <charlene@patas-monkey.com>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * 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 <https://www.gnu.org/licenses/>.
 */
 
include_once 'inc.php';
'
@phan-var-force string $dolibarr_main_db_host
@phan-var-force string $dolibarr_main_db_port
@phan-var-force string $dolibarr_main_db_name
@phan-var-force string $dolibarr_main_db_user
@phan-var-force string $dolibarr_main_db_pass
@phan-var-force string $dolibarr_main_db_encrypted_pass
@phan-var-force string $conffile
@phan-var-force string $conffiletoshow
@phan-var-force ?bool $force_install_
@phan-var-force ?string $force_install_packager
@phan-var-force ?string $force_install_message
@phan-var-force ?string $force_install_main_data_root
@phan-var-force ?int<0,2> $force_install_noedit
@phan-var-force ?string $force_install_type
@phan-var-force ?string $force_install_dbserver
@phan-var-force ?string $force_install_port
@phan-var-force ?string $force_install_database
@phan-var-force ?string $force_install_prefix
@phan-var-force ?string $force_install_createdatabase
@phan-var-force ?string $force_install_databaselogin
@phan-var-force ?string $force_install_databasepass
@phan-var-force ?string $force_install_databaserootlogin
@phan-var-force ?string $force_install_databaserootpass
@phan-var-force ?string $force_install_dolibarrlogin
@phan-var-force ?string $force_install_nophpinfo
@phan-var-force ?string $force_install_lockinstall
@phan-var-force ?string $force_install_distrib
@phan-var-force ?string $db_user_root
@phan-var-force ?string $db_pass_root
';
 
$err = 0;
 
$setuplang = GETPOST("selectlang", 'alpha', 3) ? GETPOST("selectlang", 'alpha', 3) : (GETPOST('lang', 'alpha', 1) ? GETPOST('lang', 'alpha', 1) : 'auto');
$langs->setDefaultLang($setuplang);
 
$langs->loadLangs(array("install", "errors", "admin"));
 
dolibarr_install_syslog("- fileconf: entering fileconf.php page");
 
// You can force preselected values of the config step of Dolibarr by adding a file
// install.forced.php into directory htdocs/install (This is the case with some wizard
// installer like DoliWamp, DoliMamp or DoliBuntu).
// We first init "forced values" to nothing.
if (!isset($force_install_distrib)) {
  $force_install_distrib = 'undefined';
}
if (!isset($force_install_noedit)) {
  $force_install_noedit = ''; // 1=To block vars specific to distrib, 2 to block all technical parameters, 3 to block all technical parameters excepted main_url
}
if (!isset($force_install_type)) {
  $force_install_type = '';
}
if (!isset($force_install_dbserver)) {
  $force_install_dbserver = '';
}
if (!isset($force_install_port)) {
  $force_install_port = '';
}
if (!isset($force_install_database)) {
  $force_install_database = '';
}
if (!isset($force_install_prefix)) {
  $force_install_prefix = '';
}
if (!isset($force_install_createdatabase)) {
  $force_install_createdatabase = '';
}
if (!isset($force_install_databaselogin)) {
  $force_install_databaselogin = '';
}
if (!isset($force_install_databasepass)) {
  $force_install_databasepass = '';
}
if (!isset($force_install_databaserootlogin)) {
  $force_install_databaserootlogin = '';
}
if (!isset($force_install_databaserootpass)) {
  $force_install_databaserootpass = '';
}
// Now we load forced values from install.forced.php file.
$useforcedwizard = false;
$forcedfile = "./install.forced.php";
if ($conffile == "/etc/dolibarr/conf.php") {
  $forcedfile = "/etc/dolibarr/install.forced.php"; // Must be after inc.php
}
if (@file_exists($forcedfile)) {
  $useforcedwizard = true;
  include_once $forcedfile;
}
 
 
 
/*
 *  View
 */
 
session_start(); // To be able to keep info into session (used for not losing pass during navigation. pass must not transit through parameters)
 
pHeader($langs->trans("DolibarrSetup").' - '.$langs->trans("ConfigurationFile"), "step1", "set", "", (empty($force_dolibarr_js_JQUERY) ? '' : $force_dolibarr_js_JQUERY.'/'), 'main-inside-bis');
 
// Test if we can run a first install process
if (!is_writable($conffile)) {
  print $langs->trans("ConfFileIsNotWritable", $conffiletoshow);
  dolibarr_install_syslog("fileconf: config file is not writable", LOG_WARNING);
  dolibarr_install_syslog("- fileconf: end");
  pFooter(1, $setuplang, 'jscheckparam');
  exit;
}
 
if (!empty($force_install_distrib)) {
  print '<!-- $force_install_distrib = '.dol_escape_htmltag($force_install_distrib).' -->';
}
 
if (!empty($force_install_message)) {
  print '<div><br>'.$langs->trans($force_install_message).'</div>';
 
  /*print '<script type="text/javascript">';
  print ' jQuery(document).ready(function() {
        jQuery("#linktoshowtechnicalparam").click(function() {
          jQuery(".hidewhenedit").hide();
          jQuery(".hidewhennoedit").show();
        });';
        if ($force_install_noedit) print 'jQuery(".hidewhennoedit").hide();';
  print '});';
  print '</script>';
 
  print '<br><a href="#" id="linktoshowtechnicalparam" class="hidewhenedit">'.$langs->trans("ShowEditTechnicalParameters").'</a><br>';
  */
}
 
?>
<div>
 
 
<table class="nobordernopadding<?php if ($force_install_noedit) {
  print ' hidewhennoedit';
                 } ?>">
 
  <tr>
    <td colspan="3" class="label">
    <h3><img class="valignmiddle inline-block paddingright" src="../public/theme/common/globe.svg" width="20" alt="webserver"> <?php echo $langs->trans("WebServer"); ?></h3>
    </td>
  </tr>
 
  <!-- Documents root $dolibarr_main_document_root -->
  <tr>
    <td class="label"><label for="main_dir"><b><?php print $langs->trans("WebPagesDirectory"); ?></b></label></td>
<?php
if (empty($dolibarr_main_document_root)) {
  $dolibarr_main_document_root = GETPOSTISSET('main_dir') ? GETPOST('main_dir') : detect_dolibarr_main_document_root();
}
?>
    <td class="label">
      <input type="text" class="minwidth300" id="main_dir"
           name="main_dir"
           value="<?php print $dolibarr_main_document_root ?>"
<?php
if (!empty($force_install_noedit)) {
  print ' disabled';
}
?>
      >
    </td>
    <td class="comment"><?php
    print '<span class="opacitymedium">'.$langs->trans("WithNoSlashAtTheEnd")."</span><br>";
    print $langs->trans("Examples").":<br>";
    ?>
    <ul>
      <li>/var/www/dolibarr/htdocs</li>
      <li>C:/wwwroot/dolibarr/htdocs</li>
    </ul>
    </td>
  </tr>
 
  <!-- Documents URL $dolibarr_main_data_root -->
  <tr>
    <td class="label"><label for="main_data_dir"><b><?php print $langs->trans("DocumentsDirectory"); ?></b></label></td>
    <?php
    if (!empty($force_install_main_data_root)) {
      $dolibarr_main_data_root = @$force_install_main_data_root;
    }
    if (empty($dolibarr_main_data_root)) {
      $dolibarr_main_data_root = GETPOSTISSET('main_data_dir') ? GETPOST('main_data_dir') : detect_dolibarr_main_data_root($dolibarr_main_document_root);
    }
    ?>
    <td class="label">
      <input type="text"
           class="minwidth300"
           id="main_data_dir"
           name="main_data_dir"
           value="<?php print $dolibarr_main_data_root ?>"
<?php if (!empty($force_install_noedit)) {
  print ' disabled';
} ?>
      >
    </td>
    <td class="comment"><?php
    print '<span class="opacitymedium">'.$langs->trans("WithNoSlashAtTheEnd")."</span><br>";
    print $langs->trans("DirectoryRecommendation")."<br>";
    print $langs->trans("Examples").":<br>";
    ?>
    <ul>
      <li>/var/lib/dolibarr/documents</li>
      <li>C:/My Documents/dolibarr/documents</li>
    </ul>
    </td>
  </tr>
 
  <!-- Root URL $dolibarr_main_url_root -->
  <?php
  if (empty($dolibarr_main_url_root)) {
    $dolibarr_main_url_root = GETPOSTISSET('main_url') ? GETPOST('main_url') : detect_dolibarr_main_url_root();
    $dolibarr_main_url_root = trim($dolibarr_main_url_root);
  }
  ?>
  <tr>
    <td class="label"><label for="main_url"><b><?php echo $langs->trans("URLRoot"); ?></b></label>
    </td>
    <td class="label">
      <input type="text"
           class="minwidth300"
           id="main_url"
           name="main_url"
           value="<?php print $dolibarr_main_url_root; ?>"
<?php if (!empty($force_install_noedit) && $force_install_noedit != 3) {
  print ' disabled';
}
?>
      >
    </td>
    <td class="comment"><?php print $langs->trans("Examples").":<br>"; ?>
    <ul>
      <li>http://localhost/</li>
      <li>http://www.myserver.com:8180/dolibarr</li>
      <li>https://www.myvirtualfordolibarr.com/</li>
    </ul>
    </td>
  </tr>
 
  <?php
  if (!empty($_SERVER["HTTPS"]) && $_SERVER["HTTPS"] == 'on') {   // Enabled if the installation process is "https://"
    ?>
  <tr>
          <td class="label"><label for="main_force_https"><?php echo $langs->trans("ForceHttps"); ?></label></td>
          <td class="label">
            <input type="checkbox"
                 id="main_force_https"
                 name="main_force_https"
        <?php if (!empty($force_install_mainforcehttps)) {
          print ' checked';
        } ?>
        <?php if (($force_install_noedit == 2 || $force_install_noedit == 3) && $force_install_mainforcehttps !== null) {
          print ' disabled';
        } ?>
      >
    </td>
    <td class="comment"><?php echo $langs->trans("CheckToForceHttps"); ?>
    </td>
 
  </tr>
    <?php
  }
  ?>
 
  <!-- Dolibarr database -->
 
  <tr>
    <td colspan="3" class="label"><br>
    <h3><img class="valignmiddle inline-block paddingright" src="../public/theme/common/database.svg" width="20" alt="webserver"> <?php echo $langs->trans("DolibarrDatabase"); ?></h3>
    </td>
  </tr>
 
  <tr>
    <td class="label"><label for="db_name"><b><?php echo $langs->trans("DatabaseName"); ?></b></label></td>
    <td class="label">
      <input type="text"
           id="db_name"
           name="db_name"
           value="<?php echo (!empty($dolibarr_main_db_name)) ? $dolibarr_main_db_name : ($force_install_database ? $force_install_database : 'dolibarr'); ?>"
        <?php if (($force_install_noedit == 2 || $force_install_noedit == 3) && $force_install_database !== null) {
          print ' disabled';
        } ?>
      >
    </td>
    <td class="comment"><?php echo $langs->trans("DatabaseName"); ?></td>
  </tr>
 
 
  <?php
  if (!isset($dolibarr_main_db_host)) {
    $dolibarr_main_db_host = "localhost";
  }
  if (!isset($dolibarr_main_db_port)) {
    $dolibarr_main_db_port = "";
  }
  if (!isset($dolibarr_main_db_user)) {
    $dolibarr_main_db_user = "";
  }
 
  ?>
  <tr>
    <!-- Driver type -->
    <td class="label"><label for="db_type"><b><?php echo $langs->trans("DriverType"); ?></b></label></td>
 
    <td class="label">
    <?php
 
    $defaultype = !empty($dolibarr_main_db_type) ? $dolibarr_main_db_type : (empty($force_install_type) ? 'mysqli' : $force_install_type);
 
    $modules = array();
    $nbok = $nbko = 0;
    $option = '';
 
    // Scan les drivers
    $dir = DOL_DOCUMENT_ROOT.'/core/db';
    $handle = opendir($dir);
    if (is_resource($handle)) {
      while (($file = readdir($handle)) !== false) {
        if (is_readable($dir."/".$file) && preg_match('/^(.*)\.class\.php$/i', $file, $reg)) {
          $type = $reg[1];
          if ($type === 'DoliDB') {
            continue; // Skip abstract class
          }
          $class = 'DoliDB'.ucfirst($type);
          include_once $dir."/".$file;
 
          if ($type == 'sqlite') {
            continue; // We hide sqlite because support can't be complete until sqlite does not manage foreign key creation after table creation (ALTER TABLE child ADD CONSTRAINT not supported)
          }
          if ($type == 'sqlite3') {
            continue; // We hide sqlite3 because support can't be complete until sqlite does not manage foreign key creation after table creation (ALTER TABLE child ADD CONSTRAINT not supported)
          }
 
          // Version min of database
          $note = '('.$class::LABEL.' >= '.$class::VERSIONMIN.')';
 
          // Switch to mysql if mysqli is not present
          if ($defaultype == 'mysqli' && !function_exists('mysqli_connect')) {
            $defaultype = 'mysql';
          }
 
          $testclass = '';
          $testfunction = null;
          // Show line into list
          if ($type == 'mysql') {
            $testfunction = 'mysql_connect';
            $testclass = '';
          }
          if ($type == 'mysqli') {
            $testfunction = 'mysqli_connect';
            $testclass = '';
          }
          if ($type == 'pgsql') {
            $testfunction = 'pg_connect';
            $testclass = '';
          }
          if ($type == 'mssql') {
            $testfunction = 'mssql_connect';
            $testclass = '';
          }
          if ($type == 'sqlite') {
            $testfunction = '';
            $testclass = 'PDO';
          }
          if ($type == 'sqlite3') {
            $testfunction = '';
            $testclass = 'SQLite3';
          }
          $option .= '<option value="'.$type.'"'.($defaultype == $type ? ' selected' : '');
          if ($testfunction && !function_exists($testfunction)) {
            $option .= ' disabled';
          }
          if ($testclass && !class_exists($testclass)) {
            $option .= ' disabled';
          }
          $option .= '>';
          $option .= $type.'&nbsp; &nbsp;';
          if ($note) {
            $option .= ' '.$note;
          }
          // Deprecated and experimental
          if ($type == 'mysql') {
            $option .= ' '.$langs->trans("Deprecated");
          } elseif ($type == 'mssql') {
            $option .= ' '.$langs->trans("VersionExperimental");
          } elseif ($type == 'sqlite') {
            $option .= ' '.$langs->trans("VersionExperimental");
          } elseif ($type == 'sqlite3') {
            $option .= ' '.$langs->trans("VersionExperimental");
          } elseif ($testfunction === null || !function_exists($testfunction)) {
            // None available
            $option .= ' - '.$langs->trans("FunctionNotAvailableInThisPHP");
          }
          $option .= '</option>';
        }
      }
    }
    ?>
      <select id="db_type"
          name="db_type"
        <?php if (($force_install_noedit == 2 || $force_install_noedit == 3) && $force_install_type !== null) {
          print ' disabled';
        } ?>
      >
        <?php print $option; ?>
      </select>
 
    </td>
    <td class="comment"><?php echo $langs->trans("DatabaseType"); ?></td>
 
  </tr>
 
  <tr class="hidesqlite">
    <td class="label"><label for="db_host"><b><?php echo $langs->trans("DatabaseServer"); ?></b></label></td>
    <td class="label">
      <input type="text"
           id="db_host"
           name="db_host"
           value="<?php print(!empty($force_install_dbserver) ? $force_install_dbserver : (!empty($dolibarr_main_db_host) ? $dolibarr_main_db_host : 'localhost')); ?>"
        <?php if (($force_install_noedit == 2 || $force_install_noedit == 3) && $force_install_dbserver !== null) {
          print ' disabled';
        } ?>
      >
    </td>
    <td class="comment"><?php echo $langs->trans("ServerAddressDescription"); ?>
    </td>
 
  </tr>
 
  <tr class="hidesqlite">
    <td class="label"><label for="db_port"><?php echo $langs->trans("Port"); ?></label></td>
    <td class="label">
      <input type="text" class="width75"
           name="db_port"
           id="db_port"
           value="<?php print (!empty($force_install_port)) ? $force_install_port : $dolibarr_main_db_port; ?>"
        <?php if (($force_install_noedit == 2 || $force_install_noedit == 3) && $force_install_port !== null) {
          print ' disabled';
        } ?>
      >
    </td>
    <td class="comment"><?php echo $langs->trans("ServerPortDescription"); ?>
    </td>
 
  </tr>
 
  <tr class="hidesqlite">
    <td class="label"><label for="db_prefix"><?php echo $langs->trans("DatabasePrefix"); ?></label></td>
    <td class="label">
      <input type="text"
           id="db_prefix"
           name="db_prefix"
           value="<?php echo(!empty($force_install_prefix) ? $force_install_prefix : (!empty($dolibarr_main_db_prefix) ? $dolibarr_main_db_prefix : 'llx_')); ?>"
        <?php if (($force_install_noedit == 2 || $force_install_noedit == 3) && $force_install_prefix !== null) {
          print ' disabled';
        } ?>
      >
    </td>
    <td class="comment"><?php echo $langs->trans("DatabasePrefixDescription"); ?></td>
  </tr>
 
  <tr class="hidesqlite">
    <td class="label"><label for="db_create_database"><?php echo $langs->trans("CreateDatabase"); ?></label></td>
    <td class="label">
      <input type="checkbox"
           id="db_create_database"
           name="db_create_database"
           value="on"
        <?php
        $checked = 0;
        if ($force_install_createdatabase) {
          $checked = 1;
          print ' checked';
        } ?>
        <?php if (($force_install_noedit == 2 || $force_install_noedit == 3) && $force_install_createdatabase !== null) {
          print ' disabled';
        } ?>
      >
    </td>
    <td class="comment">
    <?php echo $langs->trans("CheckToCreateDatabase"); ?>
    </td>
  </tr>
 
  <tr class="hidesqlite">
    <td class="label"><label for="db_user"><b><?php echo $langs->trans("Login"); ?></b></label></td>
    <td class="label">
      <input type="text"
           id="db_user"
           name="db_user"
           value="<?php print (!empty($force_install_databaselogin)) ? $force_install_databaselogin : $dolibarr_main_db_user; ?>"
        <?php if (($force_install_noedit == 2 || $force_install_noedit == 3) && $force_install_databaselogin !== null) {
          print ' disabled';
        } ?>
      >
    </td>
    <td class="comment"><?php echo $langs->trans("AdminLogin"); ?></td>
  </tr>
 
  <tr class="hidesqlite">
    <td class="label"><label for="db_pass"><b><?php echo $langs->trans("Password"); ?></b></label></td>
    <td class="label">
      <input type="password" class="text-security"
           id="db_pass" autocomplete="off"
           name="db_pass"
           value="<?php
          // If $force_install_databasepass is on, we don't want to set password, we just show '***'. Real value will be extracted from the forced install file at step1.
          // @phan-suppress-next-line PhanParamSuspiciousOrder
          $autofill = ((!empty($_SESSION['dol_save_pass'])) ? $_SESSION['dol_save_pass'] : str_pad('', strlen($force_install_databasepass), '*'));
          if (!empty($dolibarr_main_prod) && empty($_SESSION['dol_save_pass'])) {    // So value can't be found if install page still accessible
            $autofill = '';
          }
          print dol_escape_htmltag($autofill);
          ?>"
        <?php if (($force_install_noedit == 2 || $force_install_noedit == 3) && $force_install_databasepass !== null) {
          print ' disabled';
        } ?>
      >
    </td>
    <td class="comment"><?php echo $langs->trans("AdminPassword"); ?></td>
  </tr>
 
  <tr class="hidesqlite">
    <td class="label"><label for="db_create_user"><?php echo $langs->trans("CreateUser"); ?></label></td>
    <td class="label">
      <input type="checkbox"
           id="db_create_user"
           name="db_create_user"
           value="on"
        <?php
        $checked = 0;
        if (!empty($force_install_createuser)) {
          $checked = 1;
          print ' checked';
        } ?>
        <?php if (($force_install_noedit == 2 || $force_install_noedit == 3) && $force_install_createuser !== null) {
          print ' disabled';
        } ?>
      >
    </td>
    <td class="comment">
    <?php echo $langs->trans("CheckToCreateUser"); ?>
    </td>
  </tr>
 
 
  <!-- Super access -->
  <?php
  $force_install_databaserootlogin = parse_database_login($force_install_databaserootlogin);
  $force_install_databaserootpass = parse_database_pass($force_install_databaserootpass);
  ?>
  <tr class="hidesqlite hideroot">
    <td colspan="3" class="label"><br>
    <h3><img class="valignmiddle inline-block paddingright" src="../public/theme/common/shield.svg" width="20" alt="webserver"> <?php echo $langs->trans("DatabaseSuperUserAccess"); ?></h3>
    </td>
  </tr>
 
  <tr class="hidesqlite hideroot">
    <td class="label"><label for="db_user_root"><b><?php echo $langs->trans("Login"); ?></b></label></td>
    <td class="label">
      <input type="text"
           id="db_user_root"
           name="db_user_root"
           class="needroot"
           value="<?php print (!empty($force_install_databaserootlogin)) ? $force_install_databaserootlogin : (GETPOSTISSET('db_user_root') ? GETPOST('db_user_root') : (isset($db_user_root) ? $db_user_root : '')); ?>"
        <?php if ($force_install_noedit > 0 && !empty($force_install_databaserootlogin)) {
          print ' disabled';
        } ?>
      >
    </td>
    <td class="comment"><?php echo $langs->trans("DatabaseRootLoginDescription"); ?>
    <!--
    <?php echo '<br>'.$langs->trans("Examples").':<br>' ?>
    <ul>
      <li>root (Mysql)</li>
      <li>postgres (PostgreSql)</li>
    </ul>
    </td>
     -->
 
  </tr>
  <tr class="hidesqlite hideroot">
    <td class="label"><label for="db_pass_root"><b><?php echo $langs->trans("Password"); ?></b></label></td>
    <td class="label">
      <input type="password"
           autocomplete="off"
           id="db_pass_root"
           name="db_pass_root"
           class="needroot text-security"
           value="<?php
          // If $force_install_databaserootpass is on, we don't want to set password here, we just show '***'. Real value will be extracted from the forced install file at step1.
          // @phan-suppress-next-line PhanParamSuspiciousOrder
          $autofill = ((!empty($force_install_databaserootpass)) ? str_pad('', strlen($force_install_databaserootpass), '*') : (isset($db_pass_root) ? $db_pass_root : ''));
          if (!empty($dolibarr_main_prod)) {
            $autofill = '';
          }
          // Do not autofill password if instance is a production instance
          if (!empty($_SERVER["SERVER_NAME"]) && !in_array(
          $_SERVER["SERVER_NAME"],
          array('127.0.0.1', 'localhost', 'localhostgit')
          )
          ) {
            $autofill = '';
          }    // Do not autofill password for remote access
          print dol_escape_htmltag($autofill);
          ?>"
        <?php if ($force_install_noedit > 0 && !empty($force_install_databaserootpass)) {
          print ' disabled'; /* May be removed by javascript*/
        } ?>
      >
    </td>
    <td class="comment"><?php echo $langs->trans("KeepEmptyIfNoPassword"); ?>
    </td>
  </tr>
 
</table>
</div>
 
 
<script type="text/javascript">
function init_needroot()
{
  console.log("init_needroot force_install_noedit=<?php echo $force_install_noedit?>");
  console.log(jQuery("#db_create_database").is(":checked"));
  console.log(jQuery("#db_create_user").is(":checked"));
 
  if (jQuery("#db_create_database").is(":checked") || jQuery("#db_create_user").is(":checked"))
  {
    console.log("init_needroot show root section");
    jQuery(".hideroot").show();
    <?php
    if (empty($force_install_noedit)) { ?>
      jQuery(".needroot").removeAttr('disabled');
    <?php } ?>
  }
  else
  {
    console.log("init_needroot hide root section");
    jQuery(".hideroot").hide();
    jQuery(".needroot").prop('disabled', true);
  }
}
 
function checkDatabaseName(databasename) {
  if (databasename.match(/[;\.]/)) { return false; }
  return true;
}
 
function jscheckparam()
{
  console.log("Click on jscheckparam");
 
  var ok = true;
 
  if (document.forminstall.main_dir.value == '')
  {
    ok=false;
    alert('<?php echo dol_escape_js($langs->transnoentities("ErrorFieldRequired", $langs->transnoentitiesnoconv("WebPagesDirectory"))); ?>');
  }
  else if (document.forminstall.main_data_dir.value == '')
  {
    ok=false;
    alert('<?php echo dol_escape_js($langs->transnoentities("ErrorFieldRequired", $langs->transnoentitiesnoconv("DocumentsDirectory"))); ?>');
  }
  else if (document.forminstall.main_url.value == '')
  {
    ok=false;
    alert('<?php echo dol_escape_js($langs->transnoentities("ErrorFieldRequired", $langs->transnoentitiesnoconv("URLRoot"))); ?>');
  }
  else if (document.forminstall.db_host.value == '')
  {
    ok=false;
    alert('<?php echo dol_escape_js($langs->transnoentities("ErrorFieldRequired", $langs->transnoentitiesnoconv("Server"))); ?>');
  }
  else if (document.forminstall.db_name.value == '')
  {
    ok=false;
    alert('<?php echo dol_escape_js($langs->transnoentities("ErrorFieldRequired", $langs->transnoentitiesnoconv("DatabaseName"))); ?>');
  }
  else if (! checkDatabaseName(document.forminstall.db_name.value))
  {
    ok=false;
    alert('<?php echo dol_escape_js($langs->transnoentities("ErrorFieldCanNotContainSpecialCharacters", $langs->transnoentitiesnoconv("DatabaseName"))); ?>');
  }
  // If create database asked
  else if (document.forminstall.db_create_database.checked == true && (document.forminstall.db_user_root.value == ''))
  {
    ok=false;
    alert('<?php echo dol_escape_js($langs->transnoentities("YouAskToCreateDatabaseSoRootRequired")); ?>');
    init_needroot();
  }
  // If create user asked
  else if (document.forminstall.db_create_user.checked == true && (document.forminstall.db_user_root.value == ''))
  {
    ok=false;
    alert('<?php echo dol_escape_js($langs->transnoentities("YouAskToCreateDatabaseUserSoRootRequired")); ?>');
    init_needroot();
  }
 
  return ok;
}
 
 
jQuery(document).ready(function() { // TODO Test $( window ).load(function() to see if the init_needroot work better after a back
 
  var dbtype = jQuery("#db_type");
 
  dbtype.change(function () {
    if (dbtype.val() == 'sqlite' || dbtype.val() == 'sqlite3') {
      jQuery(".hidesqlite").hide();
    } else {
      jQuery(".hidesqlite").show();
    }
 
    // Automatically set default database ports and admin user
    if (dbtype.val() == 'mysql' || dbtype.val() == 'mysqli') {
      jQuery("#db_port").val(3306);
      jQuery("#db_user_root").val('root');
    } else if (dbtype.val() == 'pgsql') {
      jQuery("#db_port").val(5432);
      jQuery("#db_user_root").val('postgres');
    } else if (dbtype.val() == 'mssql') {
      jQuery("#db_port").val(1433);
      jQuery("#db_user_root").val('sa');
    }
 
  });
 
  jQuery("#db_create_database").click(function() {
    console.log("click on db_create_database");
    init_needroot();
  });
  jQuery("#db_create_user").click(function() {
    console.log("click on db_create_user");
    init_needroot();
  });
  <?php if (($force_install_noedit == 2 || $force_install_noedit == 3) && empty($force_install_databasepass)) { ?>
  jQuery("#db_pass").focus();
  <?php } ?>
 
  init_needroot();
});
</script>
 
 
<?php
 
// $db->close();  Not database connection yet
 
dolibarr_install_syslog("- fileconf: end");
 
pFooter($err, $setuplang, 'jscheckparam');