Location: PHPKode > projects > Druid Defect Control > defectcontrol_0.9.4/doc/installation.html
<html>
<head>
<title>Defect Control System</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="style.css">
</head>
<?include 'header.php' ?>
<body bgcolor="#FFFFFF">

<p>&nbsp;</p>
<h1 align="center">Installation</h1>
<p align="center">&nbsp;</p>
<p>&nbsp;</p>
<table width="80%" border="0" cellspacing="2" cellpadding="0" align="center">
  <tr> 
    <td> 
      <h2><font size="2">Release 0.9</font></h2>
      <p><font size="2">This software is still under development. </font></p>
      <p><font size="2">This document will be updated also. </font></p>
      <h3><font size="2"> Requirements</font></h3>
      <ul>
        <li><font size="2"> Apache web server v1.2 or higher. The system has been 
          tested with apache, but it should be able to run on any platform with 
          php and php-postgres support. </font></li>
        <li><font size="2">PostgreSQL 7.0.0 or higher. </font></li>
        <li><font size="2">php 4.0.6 module installed into apache. </font></li>
        <li><font size="2">php_pgsql postgres php module 4.0.6 or higher. </font></li>
      </ul>
      <p><font size="2">The software has been developed and tested in redhat 7.2. 
        </font></p>
      <p><font size="2">PostgreSQL can be run using unix sockets, or tcp/ip, depending 
        on your config, but for this release, it has to be in the local machine. 
        Future releases will support remote servers, and limited support for MySQL 
        is also planned. </font></p>
      <h3><font size="2">Instalation steps </font></h3>
      <p><font size="2">Untar the package. Apache should have reading permissions 
        on this dir. In this document, we will assume you install under /cm/ for 
        shortness. </font></p>
      <p><font size="2">You will find the following directories: </font></p>
      <ul>
        <li><font size="2"> attachments: where the binary attachments will be 
          stored </font></li>
        <li><font size="2"> setup: scripts used for initial installation </font></li>
        <li><font size="2"> tts: web application </font></li>
        <li><font size="2"> INSTALL: this document </font></li>
      </ul>
      <p><font size="2"> Add directory alias to apache config. Normally, this 
        will be done in the file httpd.conf. </font><font size="2">Assuming you 
        want to make the tracking system available as /tts/ in your apache server, 
        and that it is installed under /cm/, add the following: </font></p>
      <p><font size="2"> <font face="Courier New, Courier, mono">Alias /tts/ "/cm/tts/"</font> 
        </font></p>
      <p><font size="2"> It is important that 'attachments' directory is not published 
        by the web server, as it will store user uploaded files, and there is 
        a security issue if a user can execute an uploaded file (p.e. a php script). 
        Just keep '/cm/' out of the web server publication area. </font></p>
      <p><font size="2"> Restart your apache server for the config to be effective. 
        </font></p>
      <h2><font size="2">Database setup</font></h2>
      <p><font size="2">These steps describe how to setup the application to work 
        with postgres as the database backend. If you plan to use the support 
        for mysql, you may want to read also the <a href="installation-mysql.php">mysql 
        support page</a>. </font></p>
      <p><font size="2">The following commands may need to be issued as user 'postgres', 
        depending on your postgres setup. Go to the 'setup' directory and type: 
        </font></p>
      <p><font size="2">'<font face="Courier New, Courier, mono">createdb tts</font>' 
        You should see CREATE DATABASE as output. </font></p>
      <p><font size="2"> '<font face="Courier New, Courier, mono">psql -d tts 
        -U postgres < createtables.sql.postgres</font>' You should see no errors 
        in the output. </font></p>
      <p><font size="2">Edit <font face="Courier New, Courier, mono">./tts/config.php</font> 
        so it reflects your configuration. </font><font size="2"> Edit <font face="Courier New, Courier, mono">ATTACHMENTS_BASE_DIR</font> 
        so it points to the 'attachments' directory in the place where you installed 
        the package. In our sample, /cm/attachments. </font><font size="2">It 
        should look something like: </font> </p>
      <p><font size="2" face="Courier New, Courier, mono">&lt;?php </font> 
      <p><font size="2" face="Courier New, Courier, mono">define('ATTACHMENTS_BASE_DIR', 
        "/cm/attachments/"); <br>
        define('TRIGGERS_DIRECTORY',"/cm/triggers/");<br>
        </font>
      <p><font size="2" face="Courier New, Courier, mono"><br>
        //define('DATABASE_IMPLEMENTATION', 'database-mysql.php')</font><font size="2"></font><font size="2" face="Courier New, Courier, mono">; 
        <br>
        define('DATABASE_IMPLEMENTATION', 'database-postgres.php');</font>
      <p><font size="2" face="Courier New, Courier, mono"> define("DB_SERVER", 
        ""); <br>
        define("DB_DATABASE", "tts"); <br>
        define("DB_USER", "tts"); <br>
        define("DB_PASS", ""); </font> 
      <p><font size="2" face="Courier New, Courier, mono">?&gt;</font> 
      <p><font size="2">It is important that the database implementation points 
        to the postgres file (database-postgres.php) by commenting out any other 
        implementation with // (in this case, database-mysql.php is commented 
        out). </font></p>
      <p><font size="2">Try to login to the Defect Tracking System. Open <font face="Courier New, Courier, mono">http://<i>ttshost</i>/tts/</font> 
        in your browser. </font> </p>
      <p><font size="2">Login as "ttsadmin", password "admin". You should see 
        the welcome screen. </font> 
      <p><font size="2">Your installation is complete. You may want to continue 
        reading the <a href="administration_tut.php">administration tutorial.</a></font> 
      <p>&nbsp; 
      <p>&nbsp; 
      <p>&nbsp; 
    </td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
</html>
Return current item: Druid Defect Control