PageRenderTime 53ms CodeModel.GetById 16ms RepoModel.GetById 1ms app.codeStats 0ms

/htdocs/install/etape1.php

http://github.com/Dolibarr/dolibarr
PHP | 904 lines | 677 code | 125 blank | 102 comment | 141 complexity | 990e476e15d5a6077aa1e1a6ab35c1b1 MD5 | raw file
Possible License(s): GPL-2.0, AGPL-3.0, LGPL-2.0, CC-BY-SA-4.0, BSD-3-Clause, MPL-2.0-no-copyleft-exception, LGPL-3.0, GPL-3.0, LGPL-2.1, MIT
  1. <?php
  2. /* Copyright (C) 2004-2007 Rodolphe Quiedeville <rodolphe@quiedeville.org>
  3. * Copyright (C) 2004-2011 Laurent Destailleur <eldy@users.sourceforge.net>
  4. * Copyright (C) 2004 Benoit Mortier <benoit.mortier@opensides.be>
  5. * Copyright (C) 2004 Sebastien Di Cintio <sdicintio@ressource-toi.org>
  6. * Copyright (C) 2005-2011 Regis Houssin <regis@dolibarr.fr>
  7. *
  8. * This program is free software; you can redistribute it and/or modify
  9. * it under the terms of the GNU General Public License as published by
  10. * the Free Software Foundation; either version 2 of the License, or
  11. * (at your option) any later version.
  12. *
  13. * This program is distributed in the hope that it will be useful,
  14. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  15. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  16. * GNU General Public License for more details.
  17. *
  18. * You should have received a copy of the GNU General Public License
  19. * along with this program. If not, see <http://www.gnu.org/licenses/>.
  20. */
  21. /**
  22. * \file htdocs/install/etape1.php
  23. * \ingroup install
  24. * \brief Build conf file on disk
  25. */
  26. define('DONOTLOADCONF',1); // To avoid loading conf by file inc.php
  27. include("./inc.php");
  28. $action=GETPOST('action');
  29. $setuplang=isset($_POST["selectlang"])?$_POST["selectlang"]:(isset($_GET["selectlang"])?$_GET["selectlang"]:'auto');
  30. $langs->setDefaultLang($setuplang);
  31. $langs->load("admin");
  32. $langs->load("install");
  33. $langs->load("errors");
  34. // Recuparation des information de connexion
  35. $userroot=isset($_POST["db_user_root"])?$_POST["db_user_root"]:"";
  36. $passroot=isset($_POST["db_pass_root"])?$_POST["db_pass_root"]:"";
  37. // Repertoire des pages dolibarr
  38. $main_dir=isset($_POST["main_dir"])?trim($_POST["main_dir"]):'';
  39. // Now we load forced value from install.forced.php file.
  40. $useforcedwizard=false;
  41. $forcedfile="./install.forced.php";
  42. if ($conffile == "/etc/dolibarr/conf.php") $forcedfile="/etc/dolibarr/install.forced.php";
  43. if (@file_exists($forcedfile)) { $useforcedwizard=true; include_once($forcedfile); }
  44. dolibarr_install_syslog("--- etape1: Entering etape1.php page");
  45. $error = 0;
  46. /*
  47. * View
  48. */
  49. pHeader($langs->trans("ConfigurationFile"),"etape2");
  50. // Test if we can run a first install process
  51. if (! is_writable($conffile))
  52. {
  53. print $langs->trans("ConfFileIsNotWritable",$conffiletoshow);
  54. pFooter(1,$setuplang,'jscheckparam');
  55. exit;
  56. }
  57. // Check parameters
  58. if (empty($_POST["db_type"]))
  59. {
  60. print '<div class="error">'.$langs->trans("ErrorFieldRequired",$langs->transnoentities("DatabaseType")).'</div>';
  61. $error++;
  62. }
  63. if (empty($_POST["db_host"]))
  64. {
  65. print '<div class="error">'.$langs->trans("ErrorFieldRequired",$langs->transnoentities("Server")).'</div>';
  66. $error++;
  67. }
  68. if (empty($_POST["db_name"]))
  69. {
  70. print '<div class="error">'.$langs->trans("ErrorFieldRequired",$langs->transnoentities("DatabaseName")).'</div>';
  71. $error++;
  72. }
  73. if (empty($_POST["db_user"]))
  74. {
  75. print '<div class="error">'.$langs->trans("ErrorFieldRequired",$langs->transnoentities("Login")).'</div>';
  76. $error++;
  77. }
  78. if (! empty($_POST["db_port"]) && ! is_numeric($_POST["db_port"]))
  79. {
  80. print '<div class="error">'.$langs->trans("ErrorBadValueForParameter",$_POST["db_port"],$langs->transnoentities("Port")).'</div>';
  81. $error++;
  82. }
  83. if (! empty($_POST["db_prefix"]) && ! preg_match('/^[a-z0-9]+_$/i', $_POST["db_prefix"]))
  84. {
  85. print '<div class="error">'.$langs->trans("ErrorBadValueForParameter",$_POST["db_prefix"],$langs->transnoentities("DatabasePrefix")).'</div>';
  86. $error++;
  87. }
  88. // Remove last / into dans main_dir
  89. if (substr($main_dir, dol_strlen($main_dir) -1) == "/")
  90. {
  91. $main_dir = substr($main_dir, 0, dol_strlen($main_dir)-1);
  92. }
  93. // Remove last / into dans main_url
  94. if (! empty($_POST["main_url"]) && substr($_POST["main_url"], dol_strlen($_POST["main_url"]) -1) == "/")
  95. {
  96. $_POST["main_url"] = substr($_POST["main_url"], 0, dol_strlen($_POST["main_url"])-1);
  97. }
  98. // Directory for generated documents (invoices, orders, ecm, etc...)
  99. $main_data_dir=isset($_POST["main_data_dir"])?$_POST["main_data_dir"]:'';
  100. if (! $main_data_dir) { $main_data_dir="$main_dir/documents"; }
  101. // Test database connexion
  102. if (! $error)
  103. {
  104. $result=@include_once($main_dir."/core/db/".$_POST["db_type"].".class.php");
  105. if ($result)
  106. {
  107. // If we ask database or user creation we need to connect as root, so we need root login
  108. if (! empty($_POST["db_create_database"]) && ! $userroot)
  109. {
  110. print '<div class="error">'.$langs->trans("YouAskDatabaseCreationSoDolibarrNeedToConnect",$_POST["db_name"]).'</div>';
  111. print '<br>';
  112. print $langs->trans("BecauseConnectionFailedParametersMayBeWrong").'<br><br>';
  113. print $langs->trans("ErrorGoBackAndCorrectParameters");
  114. $error++;
  115. }
  116. if (! empty($_POST["db_create_user"]) && ! $userroot)
  117. {
  118. print '<div class="error">'.$langs->trans("YouAskLoginCreationSoDolibarrNeedToConnect",$_POST["db_user"]).'</div>';
  119. print '<br>';
  120. print $langs->trans("BecauseConnectionFailedParametersMayBeWrong").'<br><br>';
  121. print $langs->trans("ErrorGoBackAndCorrectParameters");
  122. $error++;
  123. }
  124. // If we need root access
  125. if (! $error && (! empty($_POST["db_create_database"]) || ! empty($_POST["db_create_user"])))
  126. {
  127. $databasefortest=$_POST["db_name"];
  128. if (! empty($_POST["db_create_database"]))
  129. {
  130. if ($_POST["db_type"] == 'mysql' || $_POST["db_type"] == 'mysqli')
  131. {
  132. $databasefortest='mysql';
  133. }
  134. elseif ($_POST["db_type"] == 'pgsql')
  135. {
  136. $databasefortest='postgres';
  137. }
  138. else
  139. {
  140. $databasefortest='mssql';
  141. }
  142. }
  143. //print $_POST["db_type"].",".$_POST["db_host"].",$userroot,$passroot,$databasefortest,".$_POST["db_port"];
  144. $db=getDoliDBInstance($_POST["db_type"],$_POST["db_host"],$userroot,$passroot,$databasefortest,$_POST["db_port"]);
  145. dol_syslog("databasefortest=".$databasefortest." connected=".$db->connected." database_selected=".$db->database_selected, LOG_DEBUG);
  146. //print "databasefortest=".$databasefortest." connected=".$db->connected." database_selected=".$db->database_selected;
  147. if (empty($_POST["db_create_database"]) && $db->connected && ! $db->database_selected)
  148. {
  149. print '<div class="error">'.$langs->trans("ErrorConnectedButDatabaseNotFound",$_POST["db_name"]).'</div>';
  150. print '<br>';
  151. if (! $db->connected) print $langs->trans("IfDatabaseNotExistsGoBackAndUncheckCreate").'<br><br>';
  152. print $langs->trans("ErrorGoBackAndCorrectParameters");
  153. $error++;
  154. }
  155. elseif ($db->error && ! (! empty($_POST["db_create_database"]) && $db->connected))
  156. {
  157. print '<div class="error">'.$db->error.'</div>';
  158. if (! $db->connected) print $langs->trans("BecauseConnectionFailedParametersMayBeWrong").'<br><br>';
  159. print $langs->trans("ErrorGoBackAndCorrectParameters");
  160. $error++;
  161. }
  162. }
  163. // If we need simple access
  164. if (! $error && (empty($_POST["db_create_database"]) && empty($_POST["db_create_user"])))
  165. {
  166. $db=getDoliDBInstance($_POST["db_type"],$_POST["db_host"],$_POST["db_user"],$_POST["db_pass"],$_POST["db_name"],$_POST["db_port"]);
  167. if ($db->error)
  168. {
  169. print '<div class="error">'.$db->error.'</div>';
  170. if (! $db->connected) print $langs->trans("BecauseConnectionFailedParametersMayBeWrong").'<br><br>';
  171. print $langs->trans("ErrorGoBackAndCorrectParameters");
  172. $error++;
  173. }
  174. }
  175. }
  176. else
  177. {
  178. print "<br>\nFailed to include_once(\"".$main_dir."/core/db/".$_POST["db_type"].".class.php\")<br>\n";
  179. print '<div class="error">'.$langs->trans("ErrorWrongValueForParameter",$langs->transnoentities("WebPagesDirectory")).'</div>';
  180. print $langs->trans("ErrorGoBackAndCorrectParameters");
  181. $error++;
  182. }
  183. }
  184. else
  185. {
  186. if (isset($db)) print $db->lasterror();
  187. if (isset($db) && ! $db->connected) print '<br>'.$langs->trans("BecauseConnectionFailedParametersMayBeWrong").'<br><br>';
  188. print $langs->trans("ErrorGoBackAndCorrectParameters");
  189. $error++;
  190. }
  191. if (! $error && $db->connected)
  192. {
  193. if (! empty($_POST["db_create_database"]))
  194. {
  195. $result=$db->select_db($_POST["db_name"]);
  196. if ($result)
  197. {
  198. print '<div class="error">'.$langs->trans("ErrorDatabaseAlreadyExists",$_POST["db_name"]).'</div>';
  199. print $langs->trans("IfDatabaseExistsGoBackAndCheckCreate").'<br><br>';
  200. print $langs->trans("ErrorGoBackAndCorrectParameters");
  201. $error++;
  202. }
  203. }
  204. }
  205. // Define $defaultCharacterSet and $defaultCollationConnection
  206. if (! $error && $db->connected)
  207. {
  208. if (! empty($_POST["db_create_database"])) // If we create database, we force default value
  209. {
  210. $defaultCharacterSet=getStaticMember(get_class($db),'forcecharset');
  211. $defaultCollationConnection=getStaticMember(get_class($db),'forcecollate');
  212. }
  213. else // If already created, we take current value
  214. {
  215. $defaultCharacterSet=$db->getDefaultCharacterSetDatabase();
  216. $defaultCollationConnection=$db->getDefaultCollationDatabase();
  217. }
  218. print '<input type="hidden" name="dolibarr_main_db_character_set" value="'.$defaultCharacterSet.'">';
  219. print '<input type="hidden" name="dolibarr_main_db_collation" value="'.$defaultCollationConnection.'">';
  220. $_POST['dolibarr_main_db_character_set']=$defaultCharacterSet;
  221. $_POST['dolibarr_main_db_collation']=$defaultCollationConnection;
  222. }
  223. // Create config file
  224. if (! $error && $db->connected && $action == "set")
  225. {
  226. umask(0);
  227. foreach($_POST as $cle=>$valeur)
  228. {
  229. if (! preg_match('/^db_pass/i',$cle)) dolibarr_install_syslog("Choice for ".$cle." = ".$valeur);
  230. }
  231. // Show title of step
  232. print '<h3>'.$langs->trans("ConfigurationFile").'</h3>';
  233. print '<table cellspacing="0" width="100%" cellpadding="1" border="0">';
  234. // Check parameter main_dir
  235. if (! $error)
  236. {
  237. if (! is_dir($main_dir))
  238. {
  239. dolibarr_install_syslog("etape1: Repertoire '".$main_dir."' inexistant ou non accessible");
  240. print "<tr><td>";
  241. print $langs->trans("ErrorDirDoesNotExists",$main_dir).'<br>';
  242. print $langs->trans("ErrorWrongValueForParameter",$langs->trans("WebPagesDirectory")).'<br>';
  243. print $langs->trans("ErrorGoBackAndCorrectParameters").'<br><br>';
  244. print '</td><td>';
  245. print $langs->trans("Error");
  246. print "</td></tr>";
  247. $error++;
  248. }
  249. }
  250. if (! $error)
  251. {
  252. dolibarr_install_syslog("etape1: Directory '".$main_dir."' exists");
  253. }
  254. // Create subdirectory main_data_dir
  255. if (! $error)
  256. {
  257. // Create directory for documents
  258. if (! is_dir($main_data_dir))
  259. {
  260. dol_mkdir($main_data_dir);
  261. }
  262. if (! is_dir($main_data_dir))
  263. {
  264. print "<tr><td>".$langs->trans("ErrorDirDoesNotExists",$main_data_dir);
  265. print ' '.$langs->trans("YouMustCreateItAndAllowServerToWrite");
  266. print '</td><td>';
  267. print '<font class="error">'.$langs->trans("Error").'</font>';
  268. print "</td></tr>";
  269. print '<tr><td colspan="2"><br>'.$langs->trans("CorrectProblemAndReloadPage",$_SERVER['PHP_SELF'].'?testget=ok').'</td></tr>';
  270. $error++;
  271. }
  272. else
  273. {
  274. // Create .htaccess file in document directory
  275. $pathhtaccess=$main_data_dir.'/.htaccess';
  276. if (! file_exists($pathhtaccess))
  277. {
  278. dolibarr_install_syslog("etape1: .htaccess file does not exists, we create it in '".$main_data_dir."'");
  279. $handlehtaccess=@fopen($pathhtaccess,'w');
  280. if ($handlehtaccess)
  281. {
  282. fwrite($handlehtaccess,'Order allow,deny'."\n");
  283. fwrite($handlehtaccess,'Deny from all'."\n");
  284. fclose($handlehtaccess);
  285. dolibarr_install_syslog("etape1: .htaccess file created");
  286. }
  287. }
  288. // Les documents sont en dehors de htdocs car ne doivent pas pouvoir etre telecharges en passant outre l'authentification
  289. $dir[0] = $main_data_dir."/mycompany";
  290. $dir[1] = $main_data_dir."/users";
  291. $dir[2] = $main_data_dir."/custom";
  292. $dir[3] = $main_data_dir."/facture";
  293. $dir[4] = $main_data_dir."/propale";
  294. $dir[5] = $main_data_dir."/ficheinter";
  295. $dir[6] = $main_data_dir."/produit";
  296. // Boucle sur chaque repertoire de dir[] pour les creer s'ils nexistent pas
  297. $num=count($dir);
  298. for ($i = 0; $i < $num; $i++)
  299. {
  300. if (is_dir($dir[$i]))
  301. {
  302. dolibarr_install_syslog("etape1: Directory '".$dir[$i]."' exists");
  303. }
  304. else
  305. {
  306. if (dol_mkdir($dir[$i]) < 0)
  307. {
  308. print "<tr><td>";
  309. print "Failed to create directory: ".$dir[$i];
  310. print '</td><td>';
  311. print $langs->trans("Error");
  312. print "</td></tr>";
  313. $error++;
  314. }
  315. else
  316. {
  317. dolibarr_install_syslog("etape1: Directory '".$dir[$i]."' created");
  318. }
  319. }
  320. }
  321. if ($error)
  322. {
  323. print "<tr><td>".$langs->trans("ErrorDirDoesNotExists",$main_data_dir);
  324. print ' '.$langs->trans("YouMustCreateItAndAllowServerToWrite");
  325. print '</td><td>';
  326. print '<font class="error">'.$langs->trans("Error").'</font>';
  327. print "</td></tr>";
  328. print '<tr><td colspan="2"><br>'.$langs->trans("CorrectProblemAndReloadPage",$_SERVER['PHP_SELF'].'?testget=ok').'</td></tr>';
  329. }
  330. }
  331. }
  332. // Table prefix
  333. $main_db_prefix = ((GETPOST("db_prefix") && GETPOST("db_prefix") != '') ? GETPOST("db_prefix") : 'llx_');
  334. // Force https
  335. $main_force_https = ((GETPOST("main_force_https") && (GETPOST("main_force_https") == "on" || GETPOST("main_force_https") == 1)) ? '1' : '0');
  336. // Use alternative directory
  337. $main_use_alt_dir = ((GETPOST("main_use_alt_dir") && (GETPOST("main_use_alt_dir") == "on" || GETPOST("main_use_alt_dir") == 1)) ? '' : '//');
  338. // Alternative root directory name
  339. $main_alt_dir_name = ((GETPOST("main_alt_dir_name") && GETPOST("main_alt_dir_name") != '') ? GETPOST("main_alt_dir_name") : 'custom');
  340. // Write conf file on disk
  341. if (! $error)
  342. {
  343. // Save old conf file on disk
  344. if (file_exists("$conffile"))
  345. {
  346. // We must ignore errors as an existing old file may already exists and not be replacable or
  347. // the installer (like for ubuntu) may not have permission to create another file than conf.php.
  348. // Also no other process must be able to read file or we expose the new file, so content with password.
  349. @dol_copy($conffile, $conffile.'.old', '0400');
  350. }
  351. $error+=write_conf_file($conffile);
  352. }
  353. // Write main.inc.php and master.inc.php into documents/custom dir
  354. $error+=write_main_file($main_data_dir.'/custom/main.inc.php',$main_dir);
  355. $error+=write_master_file($main_data_dir.'/custom/master.inc.php',$main_dir);
  356. // Create database and admin user database
  357. if (! $error)
  358. {
  359. // We reload configuration file
  360. conf($dolibarr_main_document_root);
  361. print '<tr><td>';
  362. print $langs->trans("ConfFileReload");
  363. print '</td>';
  364. print '<td>'.$langs->trans("OK").'</td></tr>';
  365. $userroot=isset($_POST["db_user_root"])?$_POST["db_user_root"]:"";
  366. $passroot=isset($_POST["db_pass_root"])?$_POST["db_pass_root"]:"";
  367. // Si creation utilisateur admin demandee, on le cree
  368. if (isset($_POST["db_create_user"]) && $_POST["db_create_user"] == "on")
  369. {
  370. dolibarr_install_syslog("etape1: Create database user: ".$dolibarr_main_db_user);
  371. //print $conf->db->host." , ".$conf->db->name." , ".$conf->db->user." , ".$conf->db->port;
  372. $databasefortest=$conf->db->name;
  373. if ($conf->db->type == 'mysql' || $conf->db->type == 'mysqli')
  374. {
  375. $databasefortest='mysql';
  376. }
  377. else if ($conf->db->type == 'pgsql')
  378. {
  379. $databasefortest='postgres';
  380. }
  381. else if ($conf->db->type == 'mssql')
  382. {
  383. $databasefortest='mssql';
  384. }
  385. // Creation handler de base, verification du support et connexion
  386. $db=getDoliDBInstance($conf->db->type,$conf->db->host,$userroot,$passroot,$databasefortest,$conf->db->port);
  387. if ($db->error)
  388. {
  389. print '<div class="error">'.$db->error.'</div>';
  390. $error++;
  391. }
  392. if (! $error)
  393. {
  394. if ($db->connected)
  395. {
  396. $result=$db->DDLCreateUser($dolibarr_main_db_host,$dolibarr_main_db_user,$dolibarr_main_db_pass,$dolibarr_main_db_name);
  397. if ($result > 0)
  398. {
  399. print '<tr><td>';
  400. print $langs->trans("UserCreation").' : ';
  401. print $dolibarr_main_db_user;
  402. print '</td>';
  403. print '<td>'.$langs->trans("OK").'</td></tr>';
  404. }
  405. else
  406. {
  407. if ($db->errno() == 'DB_ERROR_RECORD_ALREADY_EXISTS'
  408. || $db->errno() == 'DB_ERROR_KEY_NAME_ALREADY_EXISTS'
  409. || $db->errno() == 'DB_ERROR_USER_ALREADY_EXISTS')
  410. {
  411. dolibarr_install_syslog("etape1: User already exists");
  412. print '<tr><td>';
  413. print $langs->trans("UserCreation").' : ';
  414. print $dolibarr_main_db_user;
  415. print '</td>';
  416. print '<td>'.$langs->trans("LoginAlreadyExists").'</td></tr>';
  417. }
  418. else
  419. {
  420. dolibarr_install_syslog("etape1: Failed to create user");
  421. print '<tr><td>';
  422. print $langs->trans("UserCreation").' : ';
  423. print $dolibarr_main_db_user;
  424. print '</td>';
  425. print '<td>'.$langs->trans("Error").': '.$db->errno().' '.$db->error()."</td></tr>";
  426. }
  427. }
  428. $db->close();
  429. }
  430. else
  431. {
  432. print '<tr><td>';
  433. print $langs->trans("UserCreation").' : ';
  434. print $dolibarr_main_db_user;
  435. print '</td>';
  436. print '<td>'.$langs->trans("Error").'</td>';
  437. print '</tr>';
  438. // Affiche aide diagnostique
  439. print '<tr><td colspan="2"><br>';
  440. print $langs->trans("YouAskDatabaseCreationSoDolibarrNeedToConnect",$dolibarr_main_db_user,$dolibarr_main_db_host,$userroot);
  441. print '<br>';
  442. print $langs->trans("BecauseConnectionFailedParametersMayBeWrong").'<br><br>';
  443. print $langs->trans("ErrorGoBackAndCorrectParameters").'<br><br>';
  444. print '</td></tr>';
  445. $error++;
  446. }
  447. }
  448. } // Fin si "creation utilisateur"
  449. // If database creation is asked, we create it
  450. if (! $error && (isset($_POST["db_create_database"]) && $_POST["db_create_database"] == "on"))
  451. {
  452. dolibarr_install_syslog("etape1: Create database : ".$dolibarr_main_db_name, LOG_DEBUG);
  453. $newdb=getDoliDBInstance($conf->db->type,$conf->db->host,$userroot,$passroot,'',$conf->db->port);
  454. //print 'eee'.$conf->db->type." ".$conf->db->host." ".$userroot." ".$passroot." ".$conf->db->port." ".$newdb->connected." ".$newdb->forcecharset;exit;
  455. if ($newdb->connected)
  456. {
  457. $result=$newdb->DDLCreateDb($dolibarr_main_db_name, $dolibarr_main_db_character_set, $dolibarr_main_db_collation, $dolibarr_main_db_user);
  458. if ($result)
  459. {
  460. print '<tr><td>';
  461. print $langs->trans("DatabaseCreation")." (".$langs->trans("User")." ".$userroot.") : ";
  462. print $dolibarr_main_db_name;
  463. print '</td>';
  464. print "<td>".$langs->trans("OK")."</td></tr>";
  465. $check1=$newdb->getDefaultCharacterSetDatabase();
  466. $check2=$newdb->getDefaultCollationDatabase();
  467. dolibarr_install_syslog('etape1: Note that default server was charset='.$check1.' collation='.$check2, LOG_DEBUG);
  468. // If values differs, we save conf file again
  469. //if ($check1 != $dolibarr_main_db_character_set) dolibarr_install_syslog('etape1: Value for character_set is not the one asked for database creation', LOG_WARNING);
  470. //if ($check2 != $dolibarr_main_db_collation) dolibarr_install_syslog('etape1: Value for collation is not the one asked for database creation', LOG_WARNING);
  471. }
  472. else
  473. {
  474. // Affiche aide diagnostique
  475. print '<tr><td colspan="2"><br>';
  476. print $langs->trans("ErrorFailedToCreateDatabase",$dolibarr_main_db_name).'<br>';
  477. print $newdb->lasterror().'<br>';
  478. print $langs->trans("IfDatabaseExistsGoBackAndCheckCreate");
  479. print '<br>';
  480. print '</td></tr>';
  481. dolibarr_install_syslog('etape1: Failed to create database '.$dolibarr_main_db_name.' '.$newdb->lasterrno().' '.$newdb->lasterror(), LOG_ERR);
  482. $error++;
  483. }
  484. $newdb->close();
  485. }
  486. else {
  487. print '<tr><td>';
  488. print $langs->trans("DatabaseCreation")." (".$langs->trans("User")." ".$userroot.") : ";
  489. print $dolibarr_main_db_name;
  490. print '</td>';
  491. print '<td>'.$langs->trans("Error").'</td>';
  492. print '</tr>';
  493. // Affiche aide diagnostique
  494. print '<tr><td colspan="2"><br>';
  495. print $langs->trans("YouAskDatabaseCreationSoDolibarrNeedToConnect",$dolibarr_main_db_user,$dolibarr_main_db_host,$userroot);
  496. print '<br>';
  497. print $langs->trans("BecauseConnectionFailedParametersMayBeWrong").'<br><br>';
  498. print $langs->trans("ErrorGoBackAndCorrectParameters").'<br><br>';
  499. print '</td></tr>';
  500. $error++;
  501. }
  502. } // Fin si "creation database"
  503. // We test access with dolibarr database user (not admin)
  504. if (! $error)
  505. {
  506. dolibarr_install_syslog("etape1: connexion de type=".$conf->db->type." sur host=".$conf->db->host." port=".$conf->db->port." user=".$conf->db->user." name=".$conf->db->name, LOG_DEBUG);
  507. //print "connexion de type=".$conf->db->type." sur host=".$conf->db->host." port=".$conf->db->port." user=".$conf->db->user." name=".$conf->db->name;
  508. $db=getDoliDBInstance($conf->db->type,$conf->db->host,$conf->db->user,$conf->db->pass,$conf->db->name,$conf->db->port);
  509. if ($db->connected == 1)
  510. {
  511. // si acces serveur ok et acces base ok, tout est ok, on ne va pas plus loin, on a meme pas utilise le compte root.
  512. if ($db->database_selected == 1)
  513. {
  514. dolibarr_install_syslog("etape1: connexion to server by user ".$conf->db->user." is ok", LOG_DEBUG);
  515. print "<tr><td>";
  516. print $langs->trans("ServerConnection")." (".$langs->trans("User")." ".$conf->db->user.") : ";
  517. print $dolibarr_main_db_host;
  518. print "</td><td>";
  519. print $langs->trans("OK");
  520. print "</td></tr>";
  521. dolibarr_install_syslog("etape1: connexion to database : ".$conf->db->name.", by user : ".$conf->db->user." is ok", LOG_DEBUG);
  522. print "<tr><td>";
  523. print $langs->trans("DatabaseConnection")." (".$langs->trans("User")." ".$conf->db->user.") : ";
  524. print $dolibarr_main_db_name;
  525. print "</td><td>";
  526. print $langs->trans("OK");
  527. print "</td></tr>";
  528. $error = 0;
  529. }
  530. else
  531. {
  532. dolibarr_install_syslog("etape1: connexion to server by user ".$conf->db->user." is ok", LOG_DEBUG);
  533. print "<tr><td>";
  534. print $langs->trans("ServerConnection")." (".$langs->trans("User")." ".$conf->db->user.") : ";
  535. print $dolibarr_main_db_host;
  536. print "</td><td>";
  537. print $langs->trans("OK");
  538. print "</td></tr>";
  539. dolibarr_install_syslog("etape1: connexion to database ".$conf->db->name.", by user : ".$conf->db->user." has failed", LOG_ERR);
  540. print "<tr><td>";
  541. print $langs->trans("DatabaseConnection")." (".$langs->trans("User")." ".$conf->db->user.") : ";
  542. print $dolibarr_main_db_name;
  543. print '</td><td>';
  544. print $langs->trans("Error");
  545. print "</td></tr>";
  546. // Affiche aide diagnostique
  547. print '<tr><td colspan="2"><br>';
  548. print $langs->trans('CheckThatDatabasenameIsCorrect',$dolibarr_main_db_name).'<br>';
  549. print $langs->trans('IfAlreadyExistsCheckOption').'<br>';
  550. print $langs->trans("ErrorGoBackAndCorrectParameters").'<br><br>';
  551. print '</td></tr>';
  552. $error++;
  553. }
  554. }
  555. else
  556. {
  557. dolibarr_install_syslog("etape1: la connexion au serveur par le user ".$conf->db->user." est rate");
  558. print "<tr><td>";
  559. print $langs->trans("ServerConnection")." (".$langs->trans("User")." ".$conf->db->user.") : ";
  560. print $dolibarr_main_db_host;
  561. print '</td><td>';
  562. print '<font class="error">'.$db->error.'</div>';
  563. print "</td></tr>";
  564. // Affiche aide diagnostique
  565. print '<tr><td colspan="2"><br>';
  566. print $langs->trans("ErrorConnection",$conf->db->host,$conf->db->name,$conf->db->user);
  567. print $langs->trans('IfLoginDoesNotExistsCheckCreateUser').'<br>';
  568. print $langs->trans("ErrorGoBackAndCorrectParameters").'<br><br>';
  569. print '</td></tr>';
  570. $error++;
  571. }
  572. }
  573. }
  574. print '</table>';
  575. }
  576. ?>
  577. <script type="text/javascript">
  578. function jsinfo()
  579. {
  580. ok=true;
  581. //alert('<?php echo dol_escape_js($langs->transnoentities("NextStepMightLastALongTime")); ?>');
  582. document.getElementById('nextbutton').style.visibility="hidden";
  583. document.getElementById('pleasewait').style.visibility="visible";
  584. return ok;
  585. }
  586. </script>
  587. <?php
  588. dolibarr_install_syslog("--- install/etape1.php end", LOG_INFO);
  589. pFooter($error,$setuplang,'jsinfo');
  590. /**
  591. * Create main file. No particular permissions are set by installer.
  592. *
  593. * @param string $mainfile Full path name of main file to generate/update
  594. * @param string $main_dir Full path name to main.inc.php file
  595. * @return void
  596. */
  597. function write_main_file($mainfile,$main_dir)
  598. {
  599. $fp = @fopen("$mainfile", "w");
  600. if($fp)
  601. {
  602. clearstatcache();
  603. fputs($fp, '<?php'."\n");
  604. fputs($fp, "# Wrapper to include main into htdocs\n");
  605. fputs($fp, "include_once('".$main_dir."/main.inc.php');\n");
  606. fputs($fp, '?>');
  607. fclose($fp);
  608. }
  609. }
  610. /**
  611. * Create master file. No particular permissions are set by installer.
  612. *
  613. * @param string $masterfile Full path name of master file to generate/update
  614. * @param string $main_dir Full path name to master.inc.php file
  615. * @return void
  616. */
  617. function write_master_file($masterfile,$main_dir)
  618. {
  619. $fp = @fopen("$masterfile", "w");
  620. if($fp)
  621. {
  622. clearstatcache();
  623. fputs($fp, '<?php'."\n");
  624. fputs($fp, "# Wrapper to include master into htdocs\n");
  625. fputs($fp, "include_once('".$main_dir."/master.inc.php');\n");
  626. fputs($fp, '?>');
  627. fclose($fp);
  628. }
  629. }
  630. /**
  631. * Save configuration file. No particular permissions are set by installer.
  632. *
  633. * @param string $conffile Path to conf file to generate/update
  634. * @return void
  635. */
  636. function write_conf_file($conffile)
  637. {
  638. global $conf,$langs;
  639. global $_POST,$main_dir,$main_data_dir,$main_force_https,$main_use_alt_dir,$main_alt_dir_name,$main_db_prefix;
  640. global $dolibarr_main_url_root,$dolibarr_main_document_root,$dolibarr_main_data_root,$dolibarr_main_db_host;
  641. global $dolibarr_main_db_port,$dolibarr_main_db_name,$dolibarr_main_db_user,$dolibarr_main_db_pass;
  642. global $dolibarr_main_db_type,$dolibarr_main_db_character_set,$dolibarr_main_db_collation,$dolibarr_main_authentication;
  643. global $conffile,$conffiletoshow,$conffiletoshowshort;
  644. global $force_dolibarr_lib_ADODB_PATH, $force_dolibarr_lib_NUSOAP_PATH;
  645. global $force_dolibarr_lib_TCPDF_PATH, $force_dolibarr_lib_FPDI_PATH;
  646. global $force_dolibarr_lib_PHPEXCEL_PATH, $force_dolibarr_lib_GEOIP_PATH;
  647. global $force_dolibarr_lib_ODTPHP_PATH, $force_dolibarr_lib_ODTPHP_PATHTOPCLZIP;
  648. global $force_dolibarr_js_CKEDITOR, $force_dolibarr_js_JQUERY, $force_dolibarr_js_JQUERY_UI, $force_dolibarr_js_JQUERY_FLOT;
  649. global $force_dolibarr_font_DOL_DEFAULT_TTF, $force_dolibarr_font_DOL_DEFAULT_TTF_BOLD;
  650. $error=0;
  651. $key = md5(uniqid(mt_rand(),TRUE)); // Genere un hash d'un nombre aleatoire
  652. $fp = fopen("$conffile", "w");
  653. if($fp)
  654. {
  655. clearstatcache();
  656. fputs($fp,'<?php'."\n");
  657. fputs($fp,'//'."\n");
  658. fputs($fp,'// File generated by Dolibarr installer '.DOL_VERSION.' on '.dol_print_date(dol_now(),'')."\n");
  659. fputs($fp,'//'."\n");
  660. fputs($fp,'// Take a look at conf.php.example file for an example of '.$conffiletoshowshort.' file'."\n");
  661. fputs($fp,'// and explanations for all possibles parameters.'."\n");
  662. fputs($fp,'//'."\n");
  663. fputs($fp, '$dolibarr_main_url_root=\''.str_replace("'","\'",($_POST["main_url"])).'\';');
  664. fputs($fp,"\n");
  665. fputs($fp, '$dolibarr_main_document_root=\''.str_replace("'","\'",($main_dir)).'\';');
  666. fputs($fp,"\n");
  667. fputs($fp, $main_use_alt_dir.'$dolibarr_main_url_root_alt=\''.str_replace("'","\'",($_POST["main_url"]."/".$main_alt_dir_name)).'\';');
  668. fputs($fp,"\n");
  669. fputs($fp, $main_use_alt_dir.'$dolibarr_main_document_root_alt=\''.str_replace("'","\'",($main_dir."/".$main_alt_dir_name)).'\';');
  670. fputs($fp,"\n");
  671. fputs($fp, '$dolibarr_main_data_root=\''.str_replace("'","\'",($main_data_dir)).'\';');
  672. fputs($fp,"\n");
  673. fputs($fp, '$dolibarr_main_db_host=\''.str_replace("'","\'",($_POST["db_host"])).'\';');
  674. fputs($fp,"\n");
  675. fputs($fp, '$dolibarr_main_db_port=\''.str_replace("'","\'",($_POST["db_port"])).'\';');
  676. fputs($fp,"\n");
  677. fputs($fp, '$dolibarr_main_db_name=\''.str_replace("'","\'",($_POST["db_name"])).'\';');
  678. fputs($fp,"\n");
  679. fputs($fp, '$dolibarr_main_db_prefix=\''.str_replace("'","\'",($main_db_prefix)).'\';');
  680. fputs($fp,"\n");
  681. fputs($fp, '$dolibarr_main_db_user=\''.str_replace("'","\'",($_POST["db_user"])).'\';');
  682. fputs($fp,"\n");
  683. fputs($fp, '$dolibarr_main_db_pass=\''.str_replace("'","\'",($_POST["db_pass"])).'\';');
  684. fputs($fp,"\n");
  685. fputs($fp, '$dolibarr_main_db_type=\''.str_replace("'","\'",($_POST["db_type"])).'\';');
  686. fputs($fp,"\n");
  687. fputs($fp, '$dolibarr_main_db_character_set=\''.str_replace("'","\'",($_POST["dolibarr_main_db_character_set"])).'\';');
  688. fputs($fp,"\n");
  689. fputs($fp, '$dolibarr_main_db_collation=\''.str_replace("'","\'",($_POST["dolibarr_main_db_collation"])).'\';');
  690. fputs($fp,"\n");
  691. /* Authentication */
  692. fputs($fp, '$dolibarr_main_authentication=\'dolibarr\';');
  693. fputs($fp,"\n\n");
  694. fputs($fp, '// Specific settings');
  695. fputs($fp,"\n");
  696. fputs($fp, '$dolibarr_main_prod=\'0\';');
  697. fputs($fp,"\n");
  698. fputs($fp, '$dolibarr_nocsrfcheck=\'0\';');
  699. fputs($fp,"\n");
  700. fputs($fp, '$dolibarr_main_force_https=\''.$main_force_https.'\';');
  701. fputs($fp,"\n");
  702. fputs($fp, '$dolibarr_main_cookie_cryptkey=\''.$key.'\';');
  703. fputs($fp,"\n");
  704. fputs($fp, '$dolibarr_mailing_limit_sendbyweb=\'0\';');
  705. fputs($fp,"\n");
  706. // Write params to overwrites default lib path
  707. fputs($fp,"\n");
  708. if (empty($force_dolibarr_lib_ADODB_PATH)) { fputs($fp, '//'); $force_dolibarr_lib_ADODB_PATH=''; }
  709. fputs($fp, '$dolibarr_lib_ADODB_PATH=\''.$force_dolibarr_lib_ADODB_PATH.'\';');
  710. fputs($fp,"\n");
  711. if (empty($force_dolibarr_lib_GEOIP_PATH)) { fputs($fp, '//'); $force_dolibarr_lib_GEOIP_PATH=''; }
  712. fputs($fp, '$dolibarr_lib_GEOIP_PATH=\''.$force_dolibarr_lib_GEOIP_PATH.'\';');
  713. fputs($fp,"\n");
  714. if (empty($force_dolibarr_lib_NUSOAP_PATH)) { fputs($fp, '//'); $force_dolibarr_lib_NUSOAP_PATH=''; }
  715. fputs($fp, '$dolibarr_lib_NUSOAP_PATH=\''.$force_dolibarr_lib_NUSOAP_PATH.'\';');
  716. fputs($fp,"\n");
  717. if (empty($force_dolibarr_lib_FPDI_PATH)) { fputs($fp, '//'); $force_dolibarr_lib_FPDI_PATH=''; }
  718. fputs($fp, '$dolibarr_lib_FPDI_PATH=\''.$force_dolibarr_lib_FPDI_PATH.'\';');
  719. fputs($fp,"\n");
  720. if (empty($force_dolibarr_lib_PHPEXCEL_PATH)) { fputs($fp, '//'); $force_dolibarr_lib_PHPEXCEL_PATH=''; }
  721. fputs($fp, '$dolibarr_lib_PHPEXCEL_PATH=\''.$force_dolibarr_lib_PHPEXCEL_PATH.'\';');
  722. fputs($fp,"\n");
  723. if (empty($force_dolibarr_lib_ODTPHP_PATH)) { fputs($fp, '//'); $force_dolibarr_lib_ODTPHP_PATH=''; }
  724. fputs($fp, '$dolibarr_lib_ODTPHP_PATH=\''.$force_dolibarr_lib_ODTPHP_PATH.'\';');
  725. fputs($fp,"\n");
  726. if (empty($force_dolibarr_lib_ODTPHP_PATHTOPCLZIP)) { fputs($fp, '//'); $force_dolibarr_lib_ODTPHP_PATHTOPCLZIP=''; }
  727. fputs($fp, '$dolibarr_lib_ODTPHP_PATHTOPCLZIP=\''.$force_dolibarr_lib_ODTPHP_PATHTOPCLZIP.'\';');
  728. fputs($fp,"\n");
  729. if (empty($force_dolibarr_lib_TCPDF_PATH)) { fputs($fp, '//'); $force_dolibarr_lib_TCPDF_PATH=''; }
  730. fputs($fp, '$dolibarr_lib_TCPDF_PATH=\''.$force_dolibarr_lib_TCPDF_PATH.'\';');
  731. fputs($fp,"\n");
  732. if (empty($force_dolibarr_js_CKEDITOR)) { fputs($fp, '//'); $force_dolibarr_js_CKEDITOR=''; }
  733. fputs($fp, '$dolibarr_js_CKEDITOR=\''.$force_dolibarr_js_CKEDITOR.'\';');
  734. fputs($fp,"\n");
  735. if (empty($force_dolibarr_js_JQUERY)) { fputs($fp, '//'); $force_dolibarr_js_JQUERY=''; }
  736. fputs($fp, '$dolibarr_js_JQUERY=\''.$force_dolibarr_js_JQUERY.'\';');
  737. fputs($fp,"\n");
  738. if (empty($force_dolibarr_js_JQUERY_UI)) { fputs($fp, '//'); $force_dolibarr_js_JQUERY_UI=''; }
  739. fputs($fp, '$dolibarr_js_JQUERY_UI=\''.$force_dolibarr_js_JQUERY_UI.'\';');
  740. fputs($fp,"\n");
  741. if (empty($force_dolibarr_js_JQUERY_FLOT)) { fputs($fp, '//'); $force_dolibarr_js_JQUERY_FLOT=''; }
  742. fputs($fp, '$dolibarr_js_JQUERY_FLOT=\''.$force_dolibarr_js_JQUERY_FLOT.'\';');
  743. fputs($fp,"\n");
  744. // Write params to overwrites default font path
  745. fputs($fp,"\n");
  746. if (empty($force_dolibarr_font_DOL_DEFAULT_TTF)) { fputs($fp, '//'); $force_dolibarr_font_DOL_DEFAULT_TTF=''; }
  747. fputs($fp, '$dolibarr_font_DOL_DEFAULT_TTF=\''.$force_dolibarr_font_DOL_DEFAULT_TTF.'\';');
  748. fputs($fp,"\n");
  749. if (empty($force_dolibarr_font_DOL_DEFAULT_TTF_BOLD)) { fputs($fp, '//'); $force_dolibarr_font_DOL_DEFAULT_TTF_BOLD=''; }
  750. fputs($fp, '$dolibarr_font_DOL_DEFAULT_TTF_BOLD=\''.$force_dolibarr_font_DOL_DEFAULT_TTF_BOLD.'\';');
  751. fputs($fp,"\n");
  752. fputs($fp, '?>');
  753. fclose($fp);
  754. if (file_exists("$conffile"))
  755. {
  756. include("$conffile"); // On force rechargement. Ne pas mettre include_once !
  757. conf($dolibarr_main_document_root);
  758. print "<tr><td>";
  759. print $langs->trans("SaveConfigurationFile");
  760. print ' <strong>'.$conffile.'</strong>';
  761. print "</td><td>";
  762. print $langs->trans("OK");
  763. print "</td></tr>";
  764. }
  765. else
  766. {
  767. $error++;
  768. }
  769. }
  770. return $error;
  771. }
  772. ?>