blob: f81ce22bec503a85476803a0ecb9062fa87c2882 [file] [log] [blame]
require_once($_SERVER['DOCUMENT_ROOT'] . "/");
require_once($_SERVER['DOCUMENT_ROOT'] . "/");
require_once($_SERVER['DOCUMENT_ROOT'] . "/");
$App = new App();
$Nav = new Nav();
$Menu = new Menu();
# 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">
<li>Ensure you have selected the best database for your needs</li>
<li>Download PostgreSQL from <a href=""></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&nbsp;&nbsp;all&nbsp;&nbsp;all&nbsp;&nbsp;;&nbsp;trust</b>)
<li>Configure PostgreSQL for OSEE
<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>Create an "osee" user
<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:
Role Name: osee<br/>
Can login should be checked<br/>
Password: osee<br/>
Password (again): osee<br/>
For Role Priviledges - select the following:<br/>
&nbsp;&nbsp;&nbsp;&nbsp;Inherits rights from parent roles<br/>
&nbsp;&nbsp;&nbsp;&nbsp;Can create database objects<br/>
&nbsp;&nbsp;&nbsp;&nbsp;Can modify catalog directly<br/>
<li>Click 'OK'</li>
<li>You should now have an "osee" user under Login Roles</li>
<li>Expand the Databases item in the tree</li>
<li>Create the OSEE database right-clicking on Databases and selecting "New Database..."</li>
<li>Enter the following in the dialog:<br/>
&nbsp;&nbsp;&nbsp;&nbsp;Name: osee<br/>
&nbsp;&nbsp;&nbsp;&nbsp;Owner: osee<br/>
&nbsp;&nbsp;&nbsp;&nbsp;Encoding: UTF-8
<li>Click 'OK'</li>
<li> You should now have an "osee" Database under Databases</li>
<li>The relational database is now configured. Proceed to <a href="db_init.php">OSEE Database Initialization</a></li>
# Generate the web page
$App->generatePage($theme, $Menu, $Nav, $pageAuthor, $pageKeywords, $pageTitle, $html);