You can download Shiftracker from here
When installing Shiftracker using the RPM, it's possible that the RPM dependency check mechanism might complain about missing dependencies.
Example...
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 installing the RPM there are two files that need editing.
o /etc/shiftracker/shiftracker_httpd.conf
-> 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
Include directive.
Ex. Include /etc/shiftracker/shiftracker_httpd.conf
o /etc/shiftracker/shiftracker.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
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:
# mysql-shiftracker
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
# upgrade-shiftracker-database
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
start.
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.
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
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.