Installing Time Tracker on SME ServerThis manual describes the steps involved in installing Anuko Time Tracker on SME Server.
Software VersionsSME Server - version 8.0 (smeserver-8.0-i386.iso, md5sum 5ddf60589b91bf8596f3b7cf5394fe2c).
Anuko Time Tracker - version 22.214.171.12467.
Installing SME ServerGo to http://contribs.org and download the ISO for SME Server. Burn the ISO image to disk. Then, insert the CD into a test system and start the installation process.
That's it. After the setup is complete, you can check whether Apache is running there by accessing it from another computer in browser to see something like this:
Accessing SME Server from another system in browser after install
As you can see, there is nothing there. To install a web application, we need to create an information bay.
Create an Information Bay for Time TrackerYou can do it from SME Server via its text based browser but it's easier from a full browser from an external system.
If you need to do it on SME Server: login to it as admin (not root) with root password and select option 6 - Access server manager in Server console. Login to it as admin with root password as well.
If configuring from an external browser point it to its server-manager sub-directory.
SME Server - Information Bays screen in Server Manager
Click the Add i-bay button to add a new information bay and provide the following parameters:
Adding an information bay for Time Tracker
Now we can access the timetracker sub-directory, which is empty:
Empty timetracker directory for Time Tracker application
Download Time Tracker CodeAt this step we download Time Tracker code and deploy it in the time tracker sub-directory. Here is how I did it:
find / -name timetracker
rm -rf html
wget -c https://www.anuko.com/download/time_tracker/time_tracker.zip
mv timetracker html
By this point we have unpacked Time Tracker files in the required location.
Configuring Time Tracker
cd html/WEB-INF chmod 777 template_c
cp config.php.dist config.php
define('DSN', 'mysql://ttuser:ttpass@localhost/timetracker'); define('APP_NAME', 'timetracker');Here, the parameters are:
Time Tracker login screen after completing the installation steps above
Create a Database for Time TrackerIn SME Server console, enter MySQL console:
mysqlAnd then, in MySQL console, create timetracker database:
create database timetracker character set = 'utf8';Grant permissions to ttuser:
grant all on timetracker.* to ttuser@localhost identified by 'ttpass';
Populate Time Tracker databaseBy this point the database and user credentials to access it are created, and we can initialize the database as per Time Tracker install guide. To do that, we open dbinstall.php in browser and execute the Create step.
Populating Time Tracker database with dbinstall.php
That's it! You can now use Time Tracker.
Time Tracker installed and working on SME Server
Define a Temporary DirectoryWith the configuration achieved above you can start using Time Tracker. However, one problem still remains. If you try to import a team to this server as described here you may see a File upload error when trying to import the data from an XML file.
It happens because the file cannot be saved after uploading to SME server because a temporary directory is not set. To resolve this problem, you can use the technique described here by creating a file /etc/e-smith/templates-custom/etc/php.ini/12phptmpfolder with the following one line in it:
upload_tmp_dir = /tmpand then executing in server console