RackTables git mirrors - racktables/blob - install.php

   1 <?php
   2
   3 // This draft doesn't do anything useful at the moment. When it is finished,
   4 // the README will be updated accordingly.
   5
   6 $stepfunc[1] = 'not_already_installed';
   7 $stepfunc[2] = 'platform_is_ok';
   8 $stepfunc[3] = 'init_config';
   9 $stepfunc[4] = 'init_database_static';
  10 $stepfunc[5] = 'init_database_dynamic';
  11 $stepfunc[6] = 'congrats';
  12 $dbxlink = NULL;
  13
  14 if (isset ($_REQUEST['step']))
  15         $step = $_REQUEST['step'];
  16 else
  17         $step = 1;
  18
  19 if ($step > count ($stepfunc))
  20 {
  21         require 'inc/init.php';
  22         global $root;
  23         header ("Location: " . $root);
  24         exit;
  25 }
  26 $title = "RackTables installation: step ${step} of " . count ($stepfunc);
  27 ?>
  28 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  29 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
  30 <head><title><?php echo $title; ?></title>
  31 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
  32 <link rel=stylesheet type='text/css' href=pi.css />
  33 </head>
  34 <body>
  35 <center>
  36 <?php
  37 echo "<h1>${title}</h1><p>";
  38
  39 echo "</p><form method=post>\n";
  40 $testres = $stepfunc[$step] ();
  41 if ($testres)
  42 {
  43         $next_step = $step + 1;
  44         echo "<input type=submit value='proceed'>";
  45 }
  46 else
  47 {
  48         $next_step = $step;
  49         echo "<input type=submit value='retry'>";
  50 }
  51 echo "<input type=hidden name=step value='${next_step}'>\n";
  52
  53 ?>
  54 </form>
  55 </center>
  56 </body>
  57 </html>
  58
  59 <?php
  60 // Check if the software is already installed.
  61 function not_already_installed()
  62 {
  63         @include ('inc/secret.php');
  64         if (isset ($pdo_dsn))
  65         {
  66                 echo 'Your configuration file exists and seems to hold necessary data already.<br>';
  67                 return FALSE;
  68         }
  69         else
  70         {
  71                 echo 'There seem to be no existing installation here, I am going to setup one now.<br>';
  72                 return TRUE;
  73         }
  74 }
  75
  76 // Check for PHP extensions.
  77 function platform_is_ok ()
  78 {
  79         $nerrs = 0;
  80         echo "<table border=1><tr><th>check item</th><th>result</th></tr>\n";
  81
  82         echo '<tr><td>PDO extension</td>';
  83         if (class_exists ('PDO'))
  84                 echo '<td class=msg_success>Ok';
  85         else
  86         {
  87                 echo '<td class=msg_error>not found';
  88                 $nerrs++;
  89         }
  90         echo '</td></tr>';
  91
  92         echo '<tr><td>PDO-MySQL</td>';
  93         if (defined ('PDO::MYSQL_ATTR_READ_DEFAULT_FILE'))
  94                 echo '<td class=msg_success>Ok';
  95         else
  96         {
  97                 echo '<td class=msg_error>not found';
  98                 $nerrs++;
  99         }
 100         echo '</td></tr>';
 101
 102         echo '<tr><td>hash functions</td>';
 103         if (function_exists ('hash_algos'))
 104                 echo '<td class=msg_success>Ok';
 105         else
 106         {
 107                 echo '<td class=msg_error>not found';
 108                 $nerrs++;
 109         }
 110         echo '</td></tr>';
 111
 112         echo '<tr><td>SNMP extension</td>';
 113         if (defined ('SNMP_NULL'))
 114                 echo '<td class=msg_success>Ok';
 115         else
 116                 echo '<td class=msg_warning>Not found. Live SNMP tab will not function properly until the extension is installed.';
 117         echo '</td></tr>';
 118
 119         echo '<tr><td>GD functions</td>';
 120         if (defined ('IMG_PNG'))
 121                 echo '<td class=msg_success>Ok';
 122         else
 123         {
 124                 echo '<td class=msg_error>not found';
 125                 $nerrs++;
 126         }
 127         echo '</td></tr>';
 128
 129         echo '<tr><td>HTTP scheme</td>';
 130         if (!empty($_SERVER['HTTPS']))
 131                 echo '<td class=msg_success>HTTPs';
 132         else
 133                 echo '<td class=msg_warning>HTTP (all your passwords will be transmitted in cleartext)';
 134         echo '</td></tr>';
 135
 136         echo '<tr><td>Multibyte string extension</td>';
 137         if (defined ('MB_CASE_LOWER'))
 138                 echo '<td class=msg_success>Ok';
 139         else
 140         {
 141                 echo '<td class=msg_error>not found';
 142                 $nerrs++;
 143         }
 144         echo '</td></tr>';
 145
 146         echo '<tr><td>LDAP extension</td>';
 147         if (defined ('LDAP_OPT_DEREF'))
 148                 echo '<td class=msg_success>Ok';
 149         else
 150         {
 151                 echo '<td class=msg_warning>not found, LDAP authentication will not work';
 152         }
 153         echo '</td></tr>';
 154
 155         echo "</table>\n";
 156         return !$nerrs;
 157 }
 158
 159 // Check that we can write to configuration file.
 160 // If so, ask for DB connection paramaters and test
 161 // the connection. Neither save the parameters nor allow
 162 // going further until we succeed with the given
 163 // credentials.
 164 function init_config ()
 165 {
 166         if (!is_writable ('inc/secret.php'))
 167         {
 168                 echo "The inc/secret.php file is not writable by web-server. Make sure it is.";
 169                 echo "The following commands should suffice:<pre>touch inc/secret.php\nchmod 666 inc/secret.php</pre>";
 170                 echo 'Fedora Linux with SELinux may require this file to be owned by specific user (apache) and/or executing "setenforce 0" for the time of installation. ';
 171                 echo 'SELinux may be turned back on with "setenforce 1" command.';
 172                 return FALSE;
 173         }
 174         if
 175         (
 176                 !isset ($_REQUEST['save_config']) or
 177                 empty ($_REQUEST['mysql_host']) or
 178                 empty ($_REQUEST['mysql_db']) or
 179                 empty ($_REQUEST['mysql_username']) or
 180                 empty ($_REQUEST['mysql_password'])
 181         )
 182         {
 183                 echo "<input type=hidden name=save_config value=1>\n";
 184                 echo '<table>';
 185                 echo "<tr><td><label for=mysql_host>MySQL host:</label></td>";
 186                 echo "<td><input type=text name=mysql_host id=mysql_host value=localhost></td></tr>\n";
 187                 echo "<tr><td><label for=mysql_host>database:</label></td>";
 188                 echo "<td><input type=text name=mysql_db id=mysql_db value=racktables></td></tr>\n";
 189                 echo "<tr><td><label for=mysql_username>username:</label></td>";
 190                 echo "<td><input type=text name=mysql_username></td></tr>\n";
 191                 echo "<tr><td><label for=mysql_password>password:</label></td>";
 192                 echo "<td><input type=password name=mysql_password></td></tr>\n";
 193                 echo '</table>';
 194                 return FALSE;
 195         }
 196         $pdo_dsn = 'mysql:host=' . $_REQUEST['mysql_host'] . ';dbname=' . $_REQUEST['mysql_db'];
 197         try
 198         {
 199                 $dbxlink = new PDO ($pdo_dsn, $_REQUEST['mysql_username'], $_REQUEST['mysql_password']);
 200         }
 201         catch (PDOException $e)
 202         {
 203                 echo "<input type=hidden name=save_config value=1>\n";
 204                 echo '<table>';
 205                 echo "<tr><td><label for=mysql_host>MySQL host:</label></td>";
 206                 echo "<td><input type=text name=mysql_host id=mysql_host value='" . $_REQUEST['mysql_host'] . "'></td></tr>\n";
 207                 echo "<tr><td><label for=mysql_host>database:</label></td>";
 208                 echo "<td><input type=text name=mysql_db id=mysql_db value='" . $_REQUEST['mysql_db'] . "'></td></tr>\n";
 209                 echo "<tr><td><label for=mysql_username>username:</label></td>";
 210                 echo "<td><input type=text name=mysql_username value='" . $_REQUEST['mysql_username'] . "'></td></tr>\n";
 211                 echo "<tr><td><label for=mysql_password>password:</label></td>";
 212                 echo "<td><input type=password name=mysql_password value='" . $_REQUEST['mysql_password'] . "'></td></tr>\n";
 213                 echo "<tr><td colspan=2>The above parameters did not work. Check and try again.</td></tr>\n";
 214                 echo '</table>';
 215                 return FALSE;
 216         }
 217         $conf = fopen ('inc/secret.php', 'w+');
 218         if ($conf === FALSE)
 219         {
 220                 echo "Error: failed to open inc/secret.php for writing";
 221                 return FALSE;
 222         }
 223         fwrite ($conf, "<?php\n/* This file has been generated automatically by RackTables installer.\n");
 224         fwrite ($conf, " * you shouldn't normally edit it unless your database setup has changed.\n");
 225         fwrite ($conf, " */\n");
 226         fwrite ($conf, "\$pdo_dsn = '${pdo_dsn}';\n");
 227         fwrite ($conf, "\$db_username = '" . $_REQUEST['mysql_username'] . "';\n");
 228         fwrite ($conf, "\$db_password = '" . $_REQUEST['mysql_password'] . "';\n\n");
 229         fwrite ($conf, "// This is only necessary for 'ldap' USER_AUTH_SRC\n");
 230         fwrite ($conf, "\$ldap_server = 'some.server';\n");
 231         fwrite ($conf, "\$ldap_domain = 'some.domain';\n");
 232         fwrite ($conf, "?>\n");
 233         fclose ($conf);
 234         echo "The configuration file has been written successfully.<br>";
 235         return TRUE;
 236 }
 237
 238 function connect_to_db ()
 239 {
 240         require ('inc/secret.php');
 241         global $dbxlink;
 242         try
 243         {
 244                 $dbxlink = new PDO ($pdo_dsn, $db_username, $db_password);
 245         }
 246         catch (PDOException $e)
 247         {
 248                 die ('Error connecting to the database');
 249         }
 250 }
 251
 252 function init_database_static ()
 253 {
 254         connect_to_db ();
 255         global $dbxlink;
 256         $result = $dbxlink->query ('show tables');
 257         $tables = $result->fetchAll (PDO::FETCH_NUM);
 258         $result->closeCursor();
 259         unset ($result);
 260         if (count ($tables))
 261         {
 262                 echo 'Your database is already holding ' . count ($tables);
 263                 echo ' tables, so I will stop here and let you check it yourself.<br>';
 264                 echo 'There is some important data there probably.<br>';
 265                 return FALSE;
 266         }
 267         echo 'Initializing the database...<br>';
 268         echo '<table border=1>';
 269         echo "<tr><th>file</th><th>queries</th><th>errors</th></tr>";
 270         $errlist = array();
 271         foreach (array ('structure', 'dictbase', 'dictvendors') as $part)
 272         {
 273                 $filename = "install/init-${part}.sql";
 274                 echo "<tr><td>${filename}</td>";
 275                 $f = fopen ("install/init-${part}.sql", 'r');
 276                 if ($f === FALSE)
 277                 {
 278                         echo "Failed to open install/init-${part}.sql for reading";
 279                         return FALSE;
 280                 }
 281                 $longq = '';
 282                 while (!feof ($f))
 283                 {
 284                         $line = fgets ($f);
 285                         if (ereg ('^--', $line))
 286                                 continue;
 287                         $longq .= $line;
 288                 }
 289                 fclose ($f);
 290                 $nq = $nerrs = 0;
 291                 foreach (explode (";\n", $longq) as $query)
 292                 {
 293                         if (empty ($query))
 294                                 continue;
 295                         $nq++;
 296                         if ($dbxlink->exec ($query) === FALSE)
 297                         {
 298                                 $nerrs++;
 299                                 $errlist[] = $query;
 300                         }
 301                 }
 302                 echo "<td>${nq}</td><td>${nerrs}</td></tr>\n";
 303         }
 304         echo '</table>';
 305         if (count ($errlist))
 306         {
 307                 echo '<pre>The following queries failed:\n';
 308                 foreach ($errlist as $q)
 309                         echo "${q}\n\n";
 310                 echo '</pre>';
 311                 return FALSE;
 312         }
 313         return TRUE;
 314 }
 315
 316 function init_database_dynamic ()
 317 {
 318         connect_to_db();
 319         global $dbxlink;
 320         if (!isset ($_REQUEST['password']) or empty ($_REQUEST['password']))
 321         {
 322                 $result = $dbxlink->query ('select count(user_id) from UserAccount where user_id = 1');
 323                 $row = $result->fetch (PDO::FETCH_NUM);
 324                 $nrecs = $row[0];
 325                 $result->closeCursor();
 326                 if (!$nrecs)
 327                 {
 328                         echo '<table border=1>';
 329                         echo '<caption>Administrator password not set</caption>';
 330                         echo '<tr><td><input type=password name=password></td></tr>';
 331                         echo '</table>';
 332                 }
 333                 return FALSE;
 334         }
 335         else
 336         {
 337                 $query = "INSERT INTO `UserAccount` (`user_id`, `user_name`, `user_enabled`, `user_password_hash`, `user_realname`) " .
 338                         "VALUES (1,'admin','yes',sha1('${_REQUEST['password']}'),'RackTables Administrator')";
 339                 $result = $dbxlink->exec ($query);
 340                 echo "Administrator password has been set successfully.<br>";
 341                 return TRUE;
 342         }
 343 }
 344
 345 function congrats ()
 346 {
 347         echo 'Congratulations! RackTables installation is complete. After pressing Proceed you will ';
 348         echo 'enter the system. Authenticate with <strong>admin</strong> username.<br>';
 349         echo "RackTables web-site runs some <a href='http://racktables.org/trac/wiki'>wiki</a> pages ";
 350         echo "and <a href='http://racktables.org/trac/report/1'>a bug tracker</a>.<br>We have also got ";
 351         echo "a <a href='http://www.freelists.org/list/racktables-users'>mailing list</a> for users. Have fun.<br>";
 352         return TRUE;
 353 }
 354
 355 ?>