install/index.php

   1 <?php
   2 $errors = array();
   3 $successes = array();
   4 if ($_POST['download']) {
   5     if (!file_put_contents("cache/vendor.zip", fopen("http://static.wallabag.org/files/vendor.zip", 'r'))) {
   6         $errors[] = 'Impossible to download vendor.zip. Please <a href="http://wllbg.org/vendor">download it manually<∕a> and unzip it in your wallabag folder.';
   7     }
   8     else {
   9         if (extension_loaded('zip')) {
  10             $zip = new ZipArchive();
  11             if ($zip->open("cache/vendor.zip") !== TRUE){
  12                 $errors[] = 'Impossible to open cache/vendor.zip. Please unzip it manually in your wallabag folder.';
  13             }
  14             if ($zip->extractTo(realpath(''))) {
  15                 @unlink("cache/vendor.zip");
  16                 $successes[] = 'twig is now installed, you can install wallabag.';
  17             }
  18             else {
  19                 $errors[] = 'Impossible to extract cache/vendor.zip. Please unzip it manually in your wallabag folder.';
  20             }
  21             $zip->close();
  22         }
  23         else {
  24             $errors[] = 'zip extension is not enabled in your PHP configuration. Please unzip cache/vendor.zip in your wallabag folder.';
  25         }
  26     }
  27 }
  28 else if ($_POST['install']) {
  29     if (!is_dir('vendor')) {
  30         $errors[] = 'You must install twig before.';
  31     }
  32     else {
  33         $continue = true;
  34         // Create config.inc.php
  35         if (!copy('inc/poche/config.inc.php.new', 'inc/poche/config.inc.php')) {
  36             $errors[] = 'Installation aborted, impossible to create inc/poche/config.inc.php file. Maybe you don\'t have write access to create it.';
  37             $continue = false;
  38         }
  39         else {
  40             function generate_salt() {
  41                 mt_srand(microtime(true)*100000 + memory_get_usage(true));
  42                 return md5(uniqid(mt_rand(), true));
  43             }
  44
  45             $content = file_get_contents('inc/poche/config.inc.php');
  46             $salt = generate_salt();
  47             $content = str_replace("define ('SALT', '');", "define ('SALT', '".$salt."');", $content);
  48             file_put_contents('inc/poche/config.inc.php', $content);
  49         }
  50
  51         if ($continue) {
  52
  53             // User informations
  54             $username = trim($_POST['username']);
  55             $password = trim($_POST['password']);
  56             $salted_password = sha1($password . $username . $salt);
  57
  58             // Database informations
  59             if ($_POST['db_engine'] == 'sqlite') {
  60                 if (!copy('install/poche.sqlite', 'db/poche.sqlite')) {
  61                     $errors[] = 'Impossible to create inc/poche/config.inc.php file.';
  62                     $continue = false;
  63                 }
  64                 else {
  65                     $db_path = 'sqlite:' . realpath('') . '/db/poche.sqlite';
  66                     $handle = new PDO($db_path);
  67                 }
  68             }
  69             else {
  70                 $content = file_get_contents('inc/poche/config.inc.php');
  71
  72                 if ($_POST['db_engine'] == 'mysql') {
  73                     $db_path = 'mysql:host=' . $_POST['mysql_server'] . ';dbname=' . $_POST['mysql_database'];
  74                     $content = str_replace("define ('STORAGE_SERVER', 'localhost');", "define ('STORAGE_SERVER', '".$_POST['mysql_server']."');", $content);
  75                     $content = str_replace("define ('STORAGE_DB', 'poche');", "define ('STORAGE_DB', '".$_POST['mysql_database']."');", $content);
  76                     $content = str_replace("define ('STORAGE_USER', 'poche');", "define ('STORAGE_USER', '".$_POST['mysql_user']."');", $content);
  77                     $content = str_replace("define ('STORAGE_PASSWORD', 'poche');", "define ('STORAGE_PASSWORD', '".$_POST['mysql_password']."');", $content);
  78                     $handle = new PDO($db_path, $_POST['mysql_user'], $_POST['mysql_password']);
  79
  80                     $sql_structure = file_get_contents('install/mysql.sql');
  81                 }
  82                 else if ($_POST['db_engine'] == 'postgresql') {
  83                     $db_path = 'pgsql:host=' . $_POST['pg_server'] . ';dbname=' . $_POST['pg_database'];
  84                     $content = str_replace("define ('STORAGE_SERVER', 'localhost');", "define ('STORAGE_SERVER', '".$_POST['pg_server']."');", $content);
  85                     $content = str_replace("define ('STORAGE_DB', 'poche');", "define ('STORAGE_DB', '".$_POST['pg_database']."');", $content);
  86                     $content = str_replace("define ('STORAGE_USER', 'poche');", "define ('STORAGE_USER', '".$_POST['pg_user']."');", $content);
  87                     $content = str_replace("define ('STORAGE_PASSWORD', 'poche');", "define ('STORAGE_PASSWORD', '".$_POST['pg_password']."');", $content);
  88                     $handle = new PDO($db_path, $_POST['pg_user'], $_POST['pg_password']);
  89
  90                     $sql_structure = file_get_contents('install/postgres.sql');
  91                 }
  92
  93                 $content = str_replace("define ('STORAGE', 'sqlite');", "define ('STORAGE', '".$_POST['db_engine']."');", $content);
  94                 file_put_contents('inc/poche/config.inc.php', $content);
  95             }
  96
  97             if ($continue) {
  98
  99                 function executeQuery($handle, $sql, $params) {
 100                     try
 101                     {
 102                         $query = $handle->prepare($sql);
 103                         $query->execute($params);
 104                         return $query->fetchAll();
 105                     }
 106                     catch (Exception $e)
 107                     {
 108                         return FALSE;
 109                     }
 110                 }
 111
 112                 // create database structure
 113                 $query = executeQuery($handle, $sql_structure, array());
 114
 115                 // Create user
 116                 $handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 117
 118                 $sql = 'INSERT INTO users (username, password, name) VALUES (?, ?, ?)';
 119                 $params = array($username, $salted_password, $username);
 120                 $query = executeQuery($handle, $sql, $params);
 121
 122                 $id_user = $handle->lastInsertId();
 123
 124                 $sql = 'INSERT INTO users_config ( user_id, name, value ) VALUES (?, ?, ?)';
 125                 $params = array($id_user, 'pager', '10');
 126                 $query = executeQuery($handle, $sql, $params);
 127
 128                 $sql = 'INSERT INTO users_config ( user_id, name, value ) VALUES (?, ?, ?)';
 129                 $params = array($id_user, 'language', 'en_EN.UTF8');
 130                 $query = executeQuery($handle, $sql, $params);
 131
 132                 $successes[] = 'wallabag is now installed. Don\'t forget to delete install folder. Then, <a href="index.php">reload this page</a>.';
 133             }
 134         }
 135     }
 136 }
 137 ?>
 138 <!DOCTYPE html>
 139 <html>
 140     <head>
 141         <meta name="viewport" content="initial-scale=1.0">
 142         <meta charset="utf-8">
 143         <!--[if IE]>
 144         <meta http-equiv="X-UA-Compatible" content="IE=10">
 145         <![endif]-->
 146         <title>wallabag — installation</title>
 147         <link rel="shortcut icon" type="image/x-icon" href="themes/baggy/img/favicon.ico" />
 148         <link rel="apple-touch-icon-precomposed" sizes="144x144" href="themes/baggy/img/apple-touch-icon-144x144-precomposed.png">
 149         <link rel="apple-touch-icon-precomposed" sizes="72x72" href="themes/baggy/img/apple-touch-icon-72x72-precomposed.png">
 150         <link rel="apple-touch-icon-precomposed" href="themes/baggy/img/apple-touch-icon-precomposed.png">
 151         <link href='//fonts.googleapis.com/css?family=PT+Sans:700' rel='stylesheet' type='text/css'>
 152         <link rel="stylesheet" href="themes/baggy/css/ratatouille.css" media="all">
 153         <link rel="stylesheet" href="themes/baggy/css/font.css" media="all">
 154         <link rel="stylesheet" href="themes/baggy/css/main.css" media="all">
 155         <link rel="stylesheet" href="themes/baggy/css/messages.css" media="all">
 156         <link rel="stylesheet" href="themes/baggy/css/print.css" media="print">
 157         <script src="themes/baggy/js/jquery-2.0.3.min.js"></script>
 158         <script src="themes/baggy/js/init.js"></script>
 159     </head>
 160     <body>
 161         <header class="w600p center mbm">
 162             <h1 class="logo">
 163                 <img width="100" height="100" src="themes/baggy/img/logo-w.png" alt="logo poche" />
 164             </h1>
 165         </header>
 166         <div id="main">
 167             <button id="menu" class="icon icon-menu desktopHide"><span>Menu</span></button>
 168             <ul id="links" class="links">
 169                 <li><a href="http://www.wallabag.org/frequently-asked-questions/">FAQ</a></li>
 170                 <li><a href="http://doc.wallabag.org/">doc</a></li>
 171                 <li><a href="http://www.wallabag.org/help/">help</a></li>
 172                 <li><a href="http://www.wallabag.org/">wallabag.org</a></li>
 173             </ul>
 174             <?php if (!empty($errors)) : ?>
 175                 <div class='messages error install'>
 176                     <p>Errors during installation:</p>
 177                     <p>
 178                         <ul>
 179                         <?php foreach($errors as $error) :?>
 180                             <li><?php echo $error; ?></li>
 181                         <?php endforeach; ?>
 182                         </ul>
 183                     </p>
 184                     <p><a href="index.php">Please reload</a> this page when you think you resolved these problems.</p>
 185                 </div>
 186             <?php endif; ?>
 187             <?php if (!empty($successes)) : ?>
 188                 <div class='messages success install'>
 189                     <p>
 190                         <ul>
 191                         <?php foreach($successes as $success) :?>
 192                             <li><?php echo $success; ?></li>
 193                         <?php endforeach; ?>
 194                         </ul>
 195                     </p>
 196                 </div>
 197             <?php else : ?>
 198                 <?php if (file_exists('inc/poche/config.inc.php') && is_dir('vendor')) : ?>
 199                 <div class='messages success install'>
 200                     <p>
 201                         wallabag seems already installed. If you want to update it, you only have to delete install folder.
 202                     </p>
 203                 </div>
 204                 <?php endif; ?>
 205             <?php endif; ?>
 206             <p>To install wallabag, you just have to fill the following fields. That's all.</p>
 207             <p>Don't forget to check your server compatibility <a href="wallabag_compatibility_test.php">here</a>.</p>
 208             <form method="post">
 209                 <fieldset>
 210                     <legend><strong>Technical settings</strong></legend>
 211                     <?php if (!is_dir('vendor')) : ?>
 212                         <div class='messages notice install'>wallabag needs twig, a template engine (<a href="http://twig.sensiolabs.org/">?</a>). Two ways to install it:
 213                         <ul>
 214                             <li>automatically download and extract vendor.zip into your wallabag folder.
 215                             <p><input type="submit" name="download" value="Download vendor.zip" /></p>
 216                             <?php if (!extension_loaded('zip')) : ?>
 217                                 <b>Be careful, zip extension is not enabled in your PHP configuration. You'll have to unzip vendor.zip manually.</b>
 218                             <?php endif; ?>
 219                                 <em>This method is mainly recommended if you don't have a dedicated server.</em></li>
 220                             <li>use <a href="http://getcomposer.org/">Composer</a> :<pre><code>curl -s http://getcomposer.org/installer | php
 221 php composer.phar install</code></pre></li>
 222                         </ul>
 223                         </div>
 224                     <?php endif; ?>
 225                     <p>
 226                         Database engine:
 227                         <ul>
 228                             <li><label for="sqlite">SQLite</label> <input name="db_engine" type="radio" checked="" id="sqlite" value="sqlite" />
 229                             <div id="pdo_sqlite" class='messages error install'>
 230                                 <p>You have to enable <a href="http://php.net/manual/ref.pdo-sqlite.php">pdo_sqlite extension</a>.</p>
 231                             </div>
 232                             </li>
 233                             <li>
 234                                 <label for="mysql">MySQL</label> <input name="db_engine" type="radio" id="mysql" value="mysql" />
 235                                 <ul id="mysql_infos">
 236                                     <li><label for="mysql_server">Server</label> <input type="text" placeholder="localhost" id="mysql_server" name="mysql_server" /></li>
 237                                     <li><label for="mysql_database">Database</label> <input type="text" placeholder="wallabag" id="mysql_database" name="mysql_database" /></li>
 238                                     <li><label for="mysql_user">User</label> <input type="text" placeholder="user" id="mysql_user" name="mysql_user" /></li>
 239                                     <li><label for="mysql_password">Password</label> <input type="text" placeholder="p4ssw0rd" id="mysql_password" name="mysql_password" /></li>
 240                                 </ul>
 241                             </li>
 242                             <li>
 243                                 <label for="postgresql">PostgreSQL</label> <input name="db_engine" type="radio" id="postgresql" value="postgresql" />
 244                                 <ul id="pg_infos">
 245                                     <li><label for="pg_server">Server</label> <input type="text" placeholder="localhost" id="pg_server" name="pg_server" /></li>
 246                                     <li><label for="pg_database">Database</label> <input type="text" placeholder="wallabag" id="pg_database" name="pg_database" /></li>
 247                                     <li><label for="pg_user">User</label> <input type="text" placeholder="user" id="pg_user" name="pg_user" /></li>
 248                                   id  <li><label for="pg_password">Password</label> <input type="text" placeholder="p4ssw0rd" id="pg_password" name="pg_password" /></li>
 249                                 </ul>
 250                             </li>
 251                         </ul>
 252                     </p>
 253                 </fieldset>
 254
 255                 <fieldset>
 256                     <legend><strong>User settings</strong></legend>
 257                     <p>
 258                         <label for="username">Username</label>
 259                         <input type="text" required id="username" name="username" value="wallabag" />
 260                     </p>
 261                     <p>
 262                         <label for="password">Password</label>
 263                         <input type="password" required id="password" name="password" value="wallabag" />
 264                     </p>
 265                     <p>
 266                         <label for="show">Show password:</label> <input name="show" id="show" type="checkbox" onchange="document.getElementById('password').type = this.checked ? 'text' : 'password'">
 267                     </p>
 268                 </fieldset>
 269
 270                 <input type="submit" id="install_button" value="Install wallabag" name="install" />
 271             </form>
 272         </div>
 273         <script>
 274             $("#mysql_infos").hide();
 275             $("#pg_infos").hide();
 276
 277             <?php
 278             if (!extension_loaded('pdo_sqlite')) : ?>
 279             $("#install_button").hide();
 280             <?php
 281             else :
 282             ?>
 283             $("#pdo_sqlite").hide();
 284             <?php
 285             endif;
 286             ?>
 287
 288             $("input[name=db_engine]").click(function()
 289                 {
 290                     if ( $("#mysql").prop('checked')) {
 291                         $("#mysql_infos").show();
 292                         $("#pg_infos").hide();
 293                         $("#pdo_sqlite").hide();
 294                         $("#install_button").show();
 295                     }
 296                     else {
 297                         if ( $("#postgresql").prop('checked')) {
 298                             $("#mysql_infos").hide();
 299                             $("#pg_infos").show();
 300                             $("#pdo_sqlite").hide();
 301                             $("#install_button").show();
 302                         }
 303                         else {
 304                             $("#mysql_infos").hide();
 305                             $("#pg_infos").hide();
 306                             <?php
 307                             if (!extension_loaded('pdo_sqlite')) : ?>
 308                             $("#pdo_sqlite").show();
 309                             $("#install_button").hide();
 310                             <?php
 311                             endif;
 312                             ?>
 313                         }
 314                     }
 315                 });
 316         </script>
 317     </body>
 318 </html>