lib_install.php 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148
  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.3.3') >= 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. $data = DATA_PATH && is_writable(DATA_PATH);
  42. $cache = CACHE_PATH && is_writable(CACHE_PATH);
  43. $users = USERS_PATH && is_writable(USERS_PATH);
  44. $favicons = is_writable(join_path(DATA_PATH, 'favicons'));
  45. $http_referer = is_referer_from_same_domain();
  46. return array(
  47. 'php' => $php ? 'ok' : 'ko',
  48. 'minz' => $minz ? 'ok' : 'ko',
  49. 'curl' => $curl ? 'ok' : 'ko',
  50. 'pdo-mysql' => $pdo_mysql ? 'ok' : 'ko',
  51. 'pdo-sqlite' => $pdo_sqlite ? 'ok' : 'ko',
  52. 'pdo-pgsql' => $pdo_pgsql ? 'ok' : 'ko',
  53. 'pdo' => $pdo ? 'ok' : 'ko',
  54. 'pcre' => $pcre ? 'ok' : 'ko',
  55. 'ctype' => $ctype ? 'ok' : 'ko',
  56. 'fileinfo' => $fileinfo ? 'ok' : 'ko',
  57. 'dom' => $dom ? 'ok' : 'ko',
  58. 'xml' => $xml ? 'ok' : 'ko',
  59. 'json' => $json ? 'ok' : 'ko',
  60. 'data' => $data ? 'ok' : 'ko',
  61. 'cache' => $cache ? 'ok' : 'ko',
  62. 'users' => $users ? 'ok' : 'ko',
  63. 'favicons' => $favicons ? 'ok' : 'ko',
  64. 'http_referer' => $http_referer ? 'ok' : 'ko',
  65. 'message' => $message ?: 'ok',
  66. 'all' => $php && $minz && $curl && $pdo && $pcre && $ctype && $dom && $xml &&
  67. $data && $cache && $users && $favicons && $http_referer && $message == '' ?
  68. 'ok' : 'ko'
  69. );
  70. }
  71. function generateSalt() {
  72. return sha1(uniqid(mt_rand(), true).implode('', stat(__FILE__)));
  73. }
  74. function checkDb(&$dbOptions) {
  75. $dsn = '';
  76. $driver_options = null;
  77. try {
  78. switch ($dbOptions['type']) {
  79. case 'mysql':
  80. include_once(APP_PATH . '/SQL/install.sql.mysql.php');
  81. $driver_options = array(
  82. PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8mb4'
  83. );
  84. try { // on ouvre une connexion juste pour créer la base si elle n'existe pas
  85. $dsn = 'mysql:host=' . $dbOptions['host'] . ';';
  86. $c = new PDO($dsn, $dbOptions['user'], $dbOptions['password'], $driver_options);
  87. $sql = sprintf(SQL_CREATE_DB, $dbOptions['base']);
  88. $res = $c->query($sql);
  89. } catch (PDOException $e) {
  90. syslog(LOG_DEBUG, 'FreshRSS MySQL warning: ' . $e->getMessage());
  91. }
  92. // on écrase la précédente connexion en sélectionnant la nouvelle BDD
  93. $dsn = 'mysql:host=' . $dbOptions['host'] . ';dbname=' . $dbOptions['base'];
  94. break;
  95. case 'sqlite':
  96. include_once(APP_PATH . '/SQL/install.sql.sqlite.php');
  97. $path = join_path(USERS_PATH, $dbOptions['default_user']);
  98. if (!is_dir($path)) {
  99. mkdir($path);
  100. }
  101. $dsn = 'sqlite:' . join_path($path, 'db.sqlite');
  102. $driver_options = array(
  103. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  104. );
  105. break;
  106. case 'pgsql':
  107. include_once(APP_PATH . '/SQL/install.sql.pgsql.php');
  108. $driver_options = array(
  109. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  110. );
  111. try { // on ouvre une connexion juste pour créer la base si elle n'existe pas
  112. $dsn = 'pgsql:host=' . $dbOptions['host'] . ';dbname=postgres';
  113. $c = new PDO($dsn, $dbOptions['user'], $dbOptions['password'], $driver_options);
  114. $sql = sprintf(SQL_CREATE_DB, $dbOptions['base']);
  115. $res = $c->query($sql);
  116. } catch (PDOException $e) {
  117. syslog(LOG_DEBUG, 'FreshRSS PostgreSQL warning: ' . $e->getMessage());
  118. }
  119. // on écrase la précédente connexion en sélectionnant la nouvelle BDD
  120. $dsn = 'pgsql:host=' . $dbOptions['host'] . ';dbname=' . $dbOptions['base'];
  121. break;
  122. default:
  123. return false;
  124. }
  125. $c = new PDO($dsn, $dbOptions['user'], $dbOptions['password'], $driver_options);
  126. $res = $c->query('SELECT 1');
  127. } catch (PDOException $e) {
  128. $dsn = '';
  129. syslog(LOG_DEBUG, 'FreshRSS SQL warning: ' . $e->getMessage());
  130. $dbOptions['error'] = $e->getMessage();
  131. }
  132. $dbOptions['dsn'] = $dsn;
  133. $dbOptions['options'] = $driver_options;
  134. return $dsn != '';
  135. }
  136. function deleteInstall() {
  137. $path = join_path(DATA_PATH, 'do-install.txt');
  138. @unlink($path);
  139. return !file_exists($path);
  140. }