[Summary view] [Print] [Text view]

   1  Focus/SIS Student Information System - INSTALLATION DIRECTIONS
   2  
   3  -----------
   4  Version 1.0
   5  -----------
   6  
   7  NOTE: Before Installing Focus/SIS, you must read and agree to the included 
   8  license.
   9  
  10  Upgrades
  11  --------
  12  
  13  If you're upgrading from any version of Centre, you should disregard these 
  14  installation directions, and follow instead the directions in the file called 
  15  UPGRADE.txt
  16  
  17  Base Requirements
  18  -----------------
  19  
  20  In order to setup Focus/SIS the following is necessary.
  21  
  22  - A Mac OS X, Linux, or Windows Box installed and working properly.
  23  - Apache Web Server (http://www.apache.org)
  24  - PHP version 4.3.x or better (mod_php) Apache module (http://www.php.net)
  25  - PostgreSQL database server 8.x (http://www.postgresql.org)
  26  - HTMLdoc HTML parsing / PDF generation engine (http://www.htmldoc.org/software.php)
  27  
  28  All of the prerequisite software is open-source, as is Focus/SIS, and available for 
  29  free by download. 
  30  
  31  NOTE: Focus/SIS also supports the Oracle database, but is tested and 
  32  developed only on PostgreSQL, and not guaranteed to work with any other database 
  33  platform. Focus/SIS does not support mySQL since mySQL lacks sequence support and has
  34  untested subquery abilities.
  35  
  36  Setup of these required packages is beyond the scope of this document
  37  and if you are unsure you should check with each of the appropriate web
  38  sites for further details.  Affordable hosting is also available from 
  39  http://www.focus-sis.org.  All hosted installations come with Focus/SIS and all
  40  required packages pre-installed.
  41  
  42  If you are installing Focus/SIS on a Mac OS X environment, refer to www.entropy.ch,
  43  where Marc Liyanage has kindly provided Bianary Mac OS X installers for msot of 
  44  the required software.
  45  
  46  Configuring PHP
  47  ---------------
  48  
  49  For the most part, the default configuation of PHP version 4.3.x, 4.4.x, or 5.x
  50  is acceptable, however, for Focus/SIS to run perfectly, you must make a couple 
  51  changes to the php.ini configuration file.
  52      * MAX_EXECUTION_TIME = '0'
  53      * MAGIC_QUOTES_GPC = ON
  54  
  55  Installing the Package
  56  ----------------------
  57  
  58  1. Unzip the package into the directory you want to use on you web
  59  server.
  60  
  61  2. Now go to the directory where you uncompressed all files and edit the
  62  file "config.inc.php". 
  63      * Line 10 is the database type, with 'postgres' as the default.
  64      * Line 12 is the location of the database server and can be an IP
  65          address or DNS address.  Do not include 'http://'
  66      * Line 13 is the database username
  67      * Line 14 is the database password.
  68      * Line 15 is Focus/SIS's database name, with 'focus' as the default.
  69      * Line 16 is the port which the database can be accessed from.  This 
  70          has a default of '5432'.
  71      * Line 18 is the default school year in which users are logged in.  
  72          2005-2006 is abbreviated as 2005.
  73      * Line 21 is the location of the Focus/SIS install on your server.  This is a 
  74          relative address -- not a URL.
  75      * Line 22 is the location of the htmldoc on your server.
  76      * Line 23 is the location of the student images install. Again, this should 
  77          be a relative address. In this 
  78          directory, there should be another directory with the school year as the 
  79          title (example: /2005/), and inside this, there should be student 
  80          pictures with the student's ID as the title (example: 1031806.jpg)
  81      * Line 24 is the Title displayed on the title bar of the web browser as well 
  82          as many Focus/SIS print outs such as report cards.
  83  Pay special attention to lines 12, 13, 14, 18, and 21.
  84  
  85  3. Now, you're ready to setup the Focus/SIS database.  If you have access to the 
  86  command prompt for your server, follow these instructions.  If you're using 
  87  phpPGAdmin or a similar tool, import the install.sql file included in this
  88  package.
  89  
  90      1) Open a command prompt window.
  91      2) Login as the postgres user
  92          ex) server$ su - postgres
  93      3) Login to the postgres database server using the template1 database
  94          ex) server$ psql template1
  95      4) Create the focus database
  96          ex) template1=# CREATE DATABASE focus;
  97      5) Skip to line 6 if used in an American / English-speaking environment.
  98              If your data will include non-standard English characters (like 
  99              characters with accent marks), you'll have to create your database
 100              with a different character encoding (the default is unicode).
 101              ex) createdb focus -E LATIN9
 102              LATIN9 is ISO 8859-15 -- useful for Spanish installations.
 103              See http://www.postgresql.org/docs/7.4/interactive/multibyte.html for 
 104              more information.
 105      6) Logout of the database server
 106          ex) template1=# \q
 107      7) Run the Focus/SIS sql file
 108          ex) server$ psql focus < YOUR_FOCUS_INSTALL_DIRECTORY/install.sql > focus.log
 109  
 110  Notice, you will see several lines beginning "NOTICE:  ALTER TABLE / ADD PRIMARY 
 111  KEY will create implicit index " after completing direction 6.  Disregard these 
 112  messages.
 113  
 114  If you run into permissions problems involving focus.log, simply remove the " > focus.log"
 115  from the command
 116  
 117  4. You will will have to start postmaster with the -i option, telling postmaster to accept
 118  TCP/IP connections.  Also, the pg_hba.conf file may have to be altered to specify the 
 119  server's TCP/IP address.
 120  
 121  That's it!... now, point your browser to:
 122  
 123      http://yourdomain.com/INSTALL_LOCATION/index.php
 124      
 125  and login as 'admin' password 'admin'.  With this login, you can create new 
 126  users, and change and delete the three template users.