<?php | |
require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php"); | |
require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/nav.class.php"); | |
require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/menu.class.php"); | |
$App = new App(); | |
$Nav = new Nav(); | |
$Menu = new Menu(); | |
include($App->getProjectCommon()); | |
# All on the same line to unclutter the user's desktop' | |
#***************************************************************************** | |
# | |
# install.php | |
# | |
#**************************************************************************** | |
# | |
# Begin: page-specific settings. Change these. | |
$pageTitle = "OSEE - PostgreSQL Installation"; | |
$pageKeywords = "OSEE, Open, System, Engineering, Environment, Eclipse, Define, ATS, OTE, Application Framework, Install"; | |
$pageAuthor = "Roberto E. Escobar"; | |
# Paste your HTML content between the EOHTML markers! | |
$html = <<<EOHTML | |
<div id="midcolumn"> | |
<h3>$pageTitle</h3> | |
<h4>Pre-Requisites</h4> | |
<ul> | |
<li>Ensure you have selected the best database for your needs</li> | |
</ul> | |
<h4>Instructions</h4> | |
<ol> | |
<li>Download PostgreSQL from <a href="http://www.postgresql.org">http://www.postgresql.org/download</a></li> | |
<li>Follow PostgreSQL installation instructions</li> | |
<li><p>By default, the PostgreSQL database server is configured to allow only local connections. | |
If remote connections are to be allow, edit postgresql.conf and pg_hba.conf to set the necessary permissions. | |
(To setup an unsecured database instance set listen_address to * in the postgresql.conf file and add the following line | |
to the pg_hba.conf file: <b>host all all 0.0.0.0/0 trust</b>) | |
</p> | |
</li> | |
<li>Configure PostgreSQL for OSEE | |
<ol> | |
<li>Launch pgAdmin (in windows Start->All Programs->PostgreSQL*->pgAdmin III) </li> | |
<li>Double Click on PostgreSQL Database Server (listed under Servers on the left hand side) | |
If you are prompted for a password type the password selected during installation (user should be postgres by default)<br/> | |
</li> | |
<li>Create an "osee" user | |
<ol> | |
<li>Right-click on Login Roles (at the bottom of the tree on the left hand side) and select "New Login Role..." | |
<li>Enter the following in the dialog: | |
<p> | |
Role Name: osee<br/> | |
Can login should be checked<br/> | |
Password: osee<br/> | |
Password (again): osee<br/> | |
For Role Priviledges - select the following:<br/> | |
Inherits rights from parent roles<br/> | |
Superuser<br/> | |
Can create database objects<br/> | |
Can modify catalog directly<br/> | |
</p> | |
</li> | |
<li>Click 'OK'</li> | |
<li>You should now have an "osee" user under Login Roles</li> | |
</ol> | |
</li> | |
<li>Expand the Databases item in the tree</li> | |
<ol> | |
<li>Create the OSEE database right-clicking on Databases and selecting "New Database..."</li> | |
<li>Enter the following in the dialog:<br/> | |
Name: osee<br/> | |
Owner: osee<br/> | |
Encoding: UTF-8 | |
</li> | |
<li>Click 'OK'</li> | |
<li>Ensure there is now an "osee" Database under Databases</li> | |
</ol> | |
</ol> | |
<li>The relational database is now configured. Proceed to <a href="db_init.php">OSEE Database Initialization</a></li> | |
</ol> | |
<br/> | |
</div> | |
EOHTML; | |
# Generate the web page | |
$App->generatePage($theme, $Menu, $Nav, $pageAuthor, $pageKeywords, $pageTitle, $html); | |
?> |