Download from SourceForge
You can download Shiftracker from here
::: Notes about RPM installation
When installing Shiftracker using the RPM, it's possible that the RPM dependency check mechanism might complain about missing dependencies.
error: Failed dependencies:
perl(Date::Calc) is needed by shiftracker-2.0-1.i386
perl(GD::Graph::Data) is needed by shiftracker-2.0-1.i386
perl(GD::Graph::bars) is needed by shiftracker-2.0-1.i386
perl(GD::Graph::hbars) is needed by shiftracker-2.0-1.i386
perl(GD::Graph::pie) is needed by shiftracker-2.0-1.i386
perl(Locale::Maketext::Lexicon) is needed by shiftracker-2.0-1.i386
It's possible that some of the Perl modules that Shiftracker requires are already installed in your system.
For Perl modules it's common sometimes to install them by using the tar.gz package instead of using the RPM.
For some of them there isn't even an RPM.
Use this command to verify that for the Date::Calc dependency listed:
perl -MDate::Calc -e 1
If it fails with something similar to:
BEGIN failed--compilation aborted.
You can install it with
perl -MCPAN -e 'install GD::Graph' replying yes to the dependency questions.
If it doesn't return any error for all the dependencies listed in the error you can safely install the RPM by using:
# rpm -ivh --nodeps shiftracker.rpm
::: After RPM installation
After installing the RPM there are two files that need editing.
-> Edit the ServerAdmin, ServerName and ServerAlias to fit your definitions.
-> Edit you main Apache config file usually located in /etc/httpd/conf/httpd.conf and add this file to the end of your main configuration as an
Ex. Include /etc/shiftracker/shiftracker_httpd.conf
-> Uncoment and edit the server name variable accordingly.
-> Uncoment and edit the General Database settings
-> Uncoment and edit the General Email settings
-> Change the group ownership of the file so that the user that runs Apache can read it.
Ex. chgrp apache /etc/shiftracker/shiftracker.conf
::: Notes for first time installation
If you are installing Shiftracker for the first time, you'll need to create a database and a user.
Log in into your mysql database as root and issue the database creation commands:
mysql> CREATE DATABASE shiftracker DEFAULT CHARSET UTF8;
mysql> GRANT ALL ON shiftracker.* TO shiftracker@localhost IDENTIFIED BY 'password';
Logout and verify that your DB settings are correct by executing the command:
You should see a mysql> prompt.
Hit CTRL+C and return to the root prompt.
Create the database structure and apply the latest patches by issuing the commands as root:
# upgrade-shiftracker-database --createdb
::: Notes for upgrading from a previous version
If you are upgrading Shiftracker from a previous version 1.x then you will need to upgrade the database to the new v2.x structure.
You do that by running upgrade_shiftracker_2_v2 as root. Just type upgrade_shiftracker_2_v2 anywhere in your shell and the upgrade process should
This takes care of upgrading the database structure and applying all the needed patches.
We strongly advise on making a backup of the database prior to running the upgrade_shiftracker_2_v2 script.
::: Shiftracker test user
Amongst the system user and admin user ( not used for login ), Shiftracker has defined in it's USER table a general purpose, administrator and special rights user called test.
It's password is already defined and unknown unless you can crack the 41 Bytes hash generated by the MySQL password function.
You should define yourself a password for this test user before you go on and test the application.... Otherwise you won't be able to login. :ppp
Use this and substitute the word 'pass_word' accordingly..
o echo "UPDATE USER SET password=password('pass_word') WHERE login='test'"|./bin/mysql-shiftracker
::: Checking that everything is running and ready to GO...
Restart you Apache server to pick up the Include definitions.
Point your browser to localhost or the name of the virtual host you defined an login with user test and password test.