Journyx Timesheet

	Incomplete:
	This article or section needs to be expanded. Please help to fill the gaps or discuss the issue on the talk page

Journyx Timesheet

Introduction

Journyx is a Timesheet and Expenses application for tracking time, allocating resources and executing projects. It is free to use for up to 10 users. More info on the Journyx website.

The application is designed to run within a users account, and has its own apache web server and postgres database. It cannot be installed as root, and the user name of the account under which it is installed becomes the installing administrative account. It is recommended to create a new specific standard user account specifically for Timesheet. Multiple instances of Timesheet can be run by creating multiple standard users and installing. The apache web server runs on a specific port configured during installation. This can be changed later.

Installation

User Account

Create a standard user account in SME Server Manager panel, with a meaningful user name. Don't forget this user name becomes the administrative user for the application.

SME Server - Collaboration - Users - Add User Account
Account Name - jtime
Fill in the rest of the information as applicable
Add
Reset Password

For ease of administration the newly created user needs to be able to login remotely, using putty or similar and get a command prompt. This is probably easiest achieved by installing the Remote User Access contrib from Dungog. Then

SME Server - Security - Remote User Access
Modify the jtime user
Shell Access - /bin/bash
Sudo Access - yes
RSSH+VPN Access - yes
Save

Download and Unpack

Download the application package from Download page. You will have to register, but no hard sell. Save the package to the home directory of the new jtime user. Choose the package for the latest version of Redhat available. Login as the newly created jtime user.

gunzip < JournyxTimesheet_78_Linux_i386_glibc_2.3_REDHAT9_to_RHAS4.tar.gz | tar xvf -

This should create a directory called jtime and unpack all of the files.

Installation

See the install page for further info

Run the installer

cd jtime
./jtinstall

During the install process you will be prompted for a port number on which the apache web server will run. This will default to 8784

	Note:
	Whatever port is selected the next two port numbers are also required, so make sure that all three consecutive ports are not in use

The application will be installed in another jtime sub-directory.

Environment Setup

In order to use the command line administrative tools, it is necessary to prime the user environment at login time

Login as the jtime user

cd /home/e-smith/files/users/jtime

Create and edit .profile

cd home/jtime/jtime/pi/bin
. ./setup

Close and exit

Now when ever the jtime user logs in they will be placed in the directory of the binary admin tools, with the correct environment variables set.

SME Server Specifics

Create a template fragment to ProxyPass the web server

Login as root

mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/VirtualHosts
cd /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/VirtualHosts

Create and edit a new file 28journyxProxyPass with the following content

{
    # vim: ft=perl: 

    $haveSSL = (exists ${modSSL}{status} and ${modSSL}{status} eq "enabled") ?  'yes' : 'no';  

    $OUT = ;
    if ((${'journyx'}{'status'} || 'disabled') eq 'enabled'){

        if (($port eq "80") && ($haveSSL eq 'yes')){
            $OUT .= "    RewriteRule ^/journyx(/.*|\$)    https://%{HTTP_HOST}/journyx\$1 [L,R]\n";
        }
        else{
            $OUT .= "    ProxyPass /journyx http://127.0.0.1:${'journyx'}{TCPPort}/journyx\n";
            $OUT .= "    ProxyPassReverse /journyx http://127.0.0.1:${'journyx'}{TCPPort}/phpki\n";
        }
    }
}

Running

The newly installed Timesheet application will be available at

http://yourdom.ain:8784

Replace the port number with whatever you selected at installation The initial login name and password will be

jtime
jtime

or whatever Account User Name you created above.

Note:

The application installs a cron job for the installing user that checks the service and restarts it if it is not running every ten minutes. This means that following a reboot there may be a delay of up to ten minutes before the application is available If you want the application to start immediately at boot time then add the following line to /etc/rc.d/rc.local su -c "cd /home/e-smith/files/users/jtime/home/jtime/jtime/pi/bin ;. ./setup;wstop;wstart" jtime where the jtime (bold) entries are the installing user name The cron job can be found at /var/spool/cron/jtime where jtime is the installing user name

Uninstall

Login as the jtime user

cd jtime/jtime
pi/bin/uninstall