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'>
 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'>
 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 endif; ?>
 198             <p>To install wallabag, you just have to fill the following fields. That's all.</p>
 199             <p>Don't forget to check your server compatibility <a href="wallabag_compatibility_test.php">here</a>.</p>
 200             <form method="post">
 201                 <fieldset>
 202                     <legend><strong>Technical settings</strong></legend>
 203                     <?php if (!is_dir('vendor')) : ?>
 204                         <div class='messages notice'>wallabag needs twig, a template engine (<a href="http://twig.sensiolabs.org/">?</a>). Two ways to install it:
 205                         <ul>
 206                             <li>automatically download and extract vendor.zip into your wallabag folder.
 207                             <p><input type="submit" name="download" value="Download vendor.zip" /></p>
 208                             <?php if (!extension_loaded('zip')) : ?>
 209                                 <b>Be careful, zip extension is not enabled in your PHP configuration. You'll have to unzip vendor.zip manually.</b>
 210                             <?php endif; ?>
 211                                 <em>This method is mainly recommended if you don't have a dedicated server.</em></li>
 212                             <li>use <a href="http://getcomposer.org/">Composer</a> :<pre><code>curl -s http://getcomposer.org/installer | php
 213 php composer.phar install</code></pre></li>
 214                         </ul>
 215                         </div>
 216                     <?php endif; ?>
 217                     <p>
 218                         Database engine:
 219                         <ul>
 220                             <li><label for="sqlite">SQLite</label> <input name="db_engine" type="radio" checked="" id="sqlite" value="sqlite" /></li>
 221                             <li>
 222                                 <label for="mysql">MySQL</label> <input name="db_engine" type="radio" id="mysql" value="mysql" />
 223                                 <ul id="mysql_infos">
 224                                     <li><label for="mysql_server">Server</label> <input type="text" placeholder="localhost" id="mysql_server" name="mysql_server" /></li>
 225                                     <li><label for="mysql_database">Database</label> <input type="text" placeholder="wallabag" id="mysql_database" name="mysql_database" /></li>
 226                                     <li><label for="mysql_user">User</label> <input type="text" placeholder="user" id="mysql_user" name="mysql_user" /></li>
 227                                     <li><label for="mysql_password">Password</label> <input type="text" placeholder="p4ssw0rd" id="mysql_password" name="mysql_password" /></li>
 228                                 </ul>
 229                             </li>
 230                             <li>
 231                                 <label for="postgresql">PostgreSQL</label> <input name="db_engine" type="radio" id="postgresql" value="postgresql" />
 232                                 <ul id="pg_infos">
 233                                     <li><label for="pg_server">Server</label> <input type="text" placeholder="localhost" id="pg_server" name="pg_server" /></li>
 234                                     <li><label for="pg_database">Database</label> <input type="text" placeholder="wallabag" id="pg_database" name="pg_database" /></li>
 235                                     <li><label for="pg_user">User</label> <input type="text" placeholder="user" id="pg_user" name="pg_user" /></li>
 236                                   id  <li><label for="pg_password">Password</label> <input type="text" placeholder="p4ssw0rd" id="pg_password" name="pg_password" /></li>
 237                                 </ul>
 238                             </li>
 239                         </ul>
 240                     </p>
 241                 </fieldset>
 242
 243                 <fieldset>
 244                     <legend><strong>User settings</strong></legend>
 245                     <p>
 246                         <label for="username">Username</label>
 247                         <input type="text" required id="username" name="username" value="wallabag" />
 248                     </p>
 249                     <p>
 250                         <label for="password">Password</label>
 251                         <input type="password" required id="password" name="password" value="wallabag" />
 252                     </p>
 253                     <p>
 254                         <label for="show">Show password:</label> <input name="show" id="show" type="checkbox" onchange="document.getElementById('password').type = this.checked ? 'text' : 'password'">
 255                     </p>
 256                 </fieldset>
 257
 258                 <input type="submit" value="Install wallabag" name="install" />
 259             </form>
 260         </div>
 261         <script>
 262             $("#mysql_infos").hide();
 263             $("#pg_infos").hide();
 264             $("input[name=db_engine]").click(function()
 265                 {
 266                     if ( $("#mysql").prop('checked')) {
 267                         $("#mysql_infos").show();
 268                         $("#pg_infos").hide();
 269                     }
 270                     else {
 271                         if ( $("#postgresql").prop('checked')) {
 272                             $("#mysql_infos").hide();
 273                             $("#pg_infos").show();
 274                         }
 275                         else {
 276                             $("#mysql_infos").hide();
 277                             $("#pg_infos").hide();
 278                         }
 279                     }
 280                 });
 281         </script>
 282     </body>
 283 </html>