lib_install.php 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150
  1. <?php
  2. define('BCRYPT_COST', 9);
  3. Minz_Configuration::register('default_system', join_path(FRESHRSS_PATH, 'config.default.php'));
  4. Minz_Configuration::register('default_user', join_path(FRESHRSS_PATH, 'config-user.default.php'));
  5. function checkRequirements($dbType = '') {
  6. $php = version_compare(PHP_VERSION, '5.5.0') >= 0;
  7. $minz = file_exists(join_path(LIB_PATH, 'Minz'));
  8. $curl = extension_loaded('curl');
  9. $pdo_mysql = extension_loaded('pdo_mysql');
  10. $pdo_sqlite = extension_loaded('pdo_sqlite');
  11. $pdo_pgsql = extension_loaded('pdo_pgsql');
  12. $message = '';
  13. switch ($dbType) {
  14. case 'mysql':
  15. $pdo_sqlite = $pdo_pgsql = true;
  16. $pdo = $pdo_mysql;
  17. break;
  18. case 'sqlite':
  19. $pdo_mysql = $pdo_pgsql = true;
  20. $pdo = $pdo_sqlite;
  21. break;
  22. case 'pgsql':
  23. $pdo_mysql = $pdo_sqlite = true;
  24. $pdo = $pdo_pgsql;
  25. break;
  26. case '':
  27. $pdo = $pdo_mysql || $pdo_sqlite || $pdo_pgsql;
  28. break;
  29. default:
  30. $pdo_mysql = $pdo_sqlite = $pdo_pgsql = true;
  31. $pdo = false;
  32. $message = 'Invalid database type!';
  33. break;
  34. }
  35. $pcre = extension_loaded('pcre');
  36. $ctype = extension_loaded('ctype');
  37. $fileinfo = extension_loaded('fileinfo');
  38. $dom = class_exists('DOMDocument');
  39. $xml = function_exists('xml_parser_create');
  40. $json = function_exists('json_encode');
  41. $mbstring = extension_loaded('mbstring');
  42. $data = DATA_PATH && is_writable(DATA_PATH);
  43. $cache = CACHE_PATH && is_writable(CACHE_PATH);
  44. $users = USERS_PATH && is_writable(USERS_PATH);
  45. $favicons = is_writable(join_path(DATA_PATH, 'favicons'));
  46. $http_referer = is_referer_from_same_domain();
  47. return array(
  48. 'php' => $php ? 'ok' : 'ko',
  49. 'minz' => $minz ? 'ok' : 'ko',
  50. 'curl' => $curl ? 'ok' : 'ko',
  51. 'pdo-mysql' => $pdo_mysql ? 'ok' : 'ko',
  52. 'pdo-sqlite' => $pdo_sqlite ? 'ok' : 'ko',
  53. 'pdo-pgsql' => $pdo_pgsql ? 'ok' : 'ko',
  54. 'pdo' => $pdo ? 'ok' : 'ko',
  55. 'pcre' => $pcre ? 'ok' : 'ko',
  56. 'ctype' => $ctype ? 'ok' : 'ko',
  57. 'fileinfo' => $fileinfo ? 'ok' : 'ko',
  58. 'dom' => $dom ? 'ok' : 'ko',
  59. 'xml' => $xml ? 'ok' : 'ko',
  60. 'json' => $json ? 'ok' : 'ko',
  61. 'mbstring' => $mbstring ? 'ok' : 'ko',
  62. 'data' => $data ? 'ok' : 'ko',
  63. 'cache' => $cache ? 'ok' : 'ko',
  64. 'users' => $users ? 'ok' : 'ko',
  65. 'favicons' => $favicons ? 'ok' : 'ko',
  66. 'http_referer' => $http_referer ? 'ok' : 'ko',
  67. 'message' => $message ?: 'ok',
  68. 'all' => $php && $minz && $curl && $pdo && $pcre && $ctype && $dom && $xml &&
  69. $data && $cache && $users && $favicons && $http_referer && $message == '' ? 'ok' : 'ko'
  70. );
  71. }
  72. function generateSalt() {
  73. return sha1(uniqid(mt_rand(), true).implode('', stat(__FILE__)));
  74. }
  75. function checkDb(&$dbOptions) {
  76. $dsn = '';
  77. $driver_options = null;
  78. prepareSyslog();
  79. try {
  80. switch ($dbOptions['type']) {
  81. case 'mysql':
  82. include_once(APP_PATH . '/SQL/install.sql.mysql.php');
  83. $driver_options = array(
  84. PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8mb4'
  85. );
  86. try { // on ouvre une connexion juste pour créer la base si elle n'existe pas
  87. $dsn = 'mysql:host=' . $dbOptions['host'] . ';';
  88. $c = new PDO($dsn, $dbOptions['user'], $dbOptions['password'], $driver_options);
  89. $sql = sprintf(SQL_CREATE_DB, $dbOptions['base']);
  90. $res = $c->query($sql);
  91. } catch (PDOException $e) {
  92. syslog(LOG_DEBUG, 'FreshRSS MySQL warning: ' . $e->getMessage());
  93. }
  94. // on écrase la précédente connexion en sélectionnant la nouvelle BDD
  95. $dsn = 'mysql:host=' . $dbOptions['host'] . ';dbname=' . $dbOptions['base'];
  96. break;
  97. case 'sqlite':
  98. include_once(APP_PATH . '/SQL/install.sql.sqlite.php');
  99. $path = join_path(USERS_PATH, $dbOptions['default_user']);
  100. if (!is_dir($path)) {
  101. mkdir($path);
  102. }
  103. $dsn = 'sqlite:' . join_path($path, 'db.sqlite');
  104. $driver_options = array(
  105. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  106. );
  107. break;
  108. case 'pgsql':
  109. include_once(APP_PATH . '/SQL/install.sql.pgsql.php');
  110. $driver_options = array(
  111. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  112. );
  113. try { // on ouvre une connexion juste pour créer la base si elle n'existe pas
  114. $dsn = 'pgsql:host=' . $dbOptions['host'] . ';dbname=postgres';
  115. $c = new PDO($dsn, $dbOptions['user'], $dbOptions['password'], $driver_options);
  116. $sql = sprintf(SQL_CREATE_DB, $dbOptions['base']);
  117. $res = $c->query($sql);
  118. } catch (PDOException $e) {
  119. syslog(LOG_DEBUG, 'FreshRSS PostgreSQL warning: ' . $e->getMessage());
  120. }
  121. // on écrase la précédente connexion en sélectionnant la nouvelle BDD
  122. $dsn = 'pgsql:host=' . $dbOptions['host'] . ';dbname=' . $dbOptions['base'];
  123. break;
  124. default:
  125. return false;
  126. }
  127. $c = new PDO($dsn, $dbOptions['user'], $dbOptions['password'], $driver_options);
  128. $res = $c->query('SELECT 1');
  129. } catch (PDOException $e) {
  130. $dsn = '';
  131. syslog(LOG_DEBUG, 'FreshRSS SQL warning: ' . $e->getMessage());
  132. $dbOptions['error'] = $e->getMessage();
  133. }
  134. $dbOptions['dsn'] = $dsn;
  135. $dbOptions['options'] = $driver_options;
  136. return $dsn != '';
  137. }
  138. function deleteInstall() {
  139. $path = join_path(DATA_PATH, 'do-install.txt');
  140. @unlink($path);
  141. return !file_exists($path);
  142. }