Configuring Your Web Server and Database Server

After you have installed the onShore TimeSheet application, you must now configure your HTTP Server properly.

Be sure to have cgi execution enabled for the onShore TimeSheet installation directory. If you are running apache, you can do so by adding the following stanza to your access.conf (under RedHat Linux, /etc/httpd/conf/access.conf). Replace /timesheet with the path to the timesheet application.

<directory /timesheet>
Options +ExecCGI
AddHandler cgi-script .cgi
</directory>
      

PostgreSQL needs to be configured to listen on a TCP/IP socket in order for onShore TimeSheet to function properly. By default, Debian and RedHat do not have PostgreSQL configured to listen on a socket so you will need to enable it explicitly. In Debian, edit /etc/postgresql/postmaster.init, uncomment the PGALLOWTCPIP line and change the 'no' to 'yes' so it looks like this:

PGALLOWTCPIP=yes
      

To enable for RedHat the important line is in /etc/rc.d/init.d/postgresqlreads as follows:

su postgres -c '/usr/bin/postmaster -S -D/var/lib/pgsql'
      

Postmaster needs to be started with the "-i" switch to have it listen for IP connections, so modify accordingly:

su postgres -c '/usr/bin/postmaster -i -S -D/var/lib/pgsql'
      

For more details, see postmaster (1)