Install TimeTrex on ClarkConnect
Based on ClarkConnect Home 4.1 SP1

  • ClarkConnect
    • Install ClarkConnect with "SMTP Server"
    • Register
    • Install MySQL5, PHP5, Apache and Components
      • echo "rpm [pcn] ftp://rhel-4:hiptop@rh.apt.clarkconnect.com System extras" > /etc/apt/sources.list.d/extras.list
      • apt-get update
      • apt-get -y install cc-php cc-mysql php-pear php-bcmath php-soap
      • apt-get -y upgrade
      • apt-get -y dist-upgrade
      • chkconfig mysqld on
      • chkconfig httpd on
      • reboot
    • Set MySQL password
  • Extract
    • cd /usr/src
    • unzip TimeTrex_Standard_Edition_v2.0.3.zip
    • cp -fR TimeTrex_Standard_Edition_v2.0.3 /var/www/html/timetrex
    • cd /var/www/html/timetrex
    • cp -vf timetrex.ini.php-example_linux timetrex.ini.php
    • sed -i "s/password = ENTER_PASSWORD_HERE/password = timetrex/" timetrex.ini.php
    • sed -i "s/memory_limit = 8M/memory_limit = 128M/" /etc/php.ini
    • chown -fR apache.apache /var/www/html/timetrex
    • mkdir -v /tmp/timetrex
    • mkdir -v /var/log/timetrex
    • mkdir -vp /var/timetrex/storage
    • chown -fR apache.apache /tmp/timetrex
    • chown -fR apache.apache /var/log/timetrex
    • chown -fR apache.apache /var/timetrex/storage
    • service httpd restart
  • MySQL Setup
    • Create Database Table:
      • mysqladmin -uroot -ptimetrex create timetrex
      • mysql -uroot -ptimetrex -vv -e "GRANT ALL PRIVILEGES ON timetrex.* TO timetrex@localhost IDENTIFIED BY 'timetrex'"
      • mysql -uroot -ptimetrex -vv -e "flush privileges"
    • Set Time Zone
      • mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot -ptimetrex mysql
      • service mysqld restart
  • Modify crontab:
    • echo '* * * * * su apache -c "php /var/www/html/timetrex/classes/modules/core/../../../maint/cron.php" > /dev/null 2>&1' >> /etc/crontab
  • Browse to:
    • http://<IP ADDRESS>/timetrex/interface/install/install.php
  • Setup
    • Step 3
      • Privileged Database User Name:
      • Privileged Database User Password: