Helpful Tips
June 2005
Using External Reporting Programs With A Unix Installation Of Timesheet
This answer explains how to connect an external reporting program to the PostgreSQL Timesheet Database (which powers both Unix/Linux Timesheet installations, unless you have chosen a different database). All you will need to do is tell your external reporting program some characteristics about the database to which it is connecting. The following information is for a default Unix/Linux Timesheet setup:
Database Server Type: PostgreSQL
Database Server Address: http://www.your_timesheet_name_here.com
Database Server Name: template1
Username: timesheet
Password: timesheet
You will also need to know which port the database is using. Please Note: The database port number equals whatever base timesheet port you have plus 1. For example the default installation of Timesheet rests on port 8080; your PostgreSQL port would be at 8081. The Journyx PostgreSQL installation is configured to listen on all interfaces, but this can be changed by editing this file:
/jtime/pi/db/data/pg_hba.conf
Once the preceding in entered into your external reporting application, it should be able to communicate with the Timesheet Database. Since all external reporting programs are a bit different, we cannot say with confidence exactly what your program will ask of you but the information on this page closely resembles what you would need to know to make things work correctly.
Adding An Admin Via The Command Line
There are a handful of reasons that one might want to add a new Administrator account to Timesheet via the command line, but the most likely reason to need to do this is if you have forgotten your Admin account password. To perform this action you will need to get to the Timesheet Command Line prompt. In Windows, it will be listed in the same folder as your Timesheet installation - along with a shortcut in the start menu. In Unix, you can use the default command line.
Windows steps:
- Login to the Timesheet server as the user that installed Timesheet.
- Get to a DOS prompt and navigate to the
bindirectory - Then while in the
bindirectory give this command:addfull u jxadmin admin - This should create for you a new admin user on the Timesheet system with the username and password of jxadmin.
- If that does not work or you get an error that says there are no groups or the user is hidden then you will need to run this as well:
addfull a jxadmin 1 All_grp
This will add the jxadmin user to the All Group.
Unix/Linux steps:
- Login to the Timesheet server as the user that installed Timesheet
- Navigate to the Timesheet install directory and then to the
bindirectory - Source the setup file by entering:
. ./setup
(that is dot space dot slash setup) - Then you can run this command:
addfull u jxadmin admin - This should create for you a new admin user on the Timesheet system with the username and password of jxadmin.
- If that does not work or you get an error that says there are no groups or the user is hidden then you will need to run this as well:
addfull a jxadmin 1 All_grp
This will add the jxadmin user to the All Group.
