Crashfix WebApp

This is a service that runs the Crashfix server and provides a webapp tha interacts with the Crashfix Daemon.

Installing Apache HTTP Server and PHP 5 (Debian/Ubuntu)

From a command shell, you will run the following commands:

sudo apt-get install apache2
sudo apt-get install php
sudo apt-get install libapache2-mod-php php-gd
sudo apt-get install php-sqlite3
sudo service apache2 restart

Note that if apache is already installed you can omit the first line. Your web files will now be found in /var/www/http

Installing sendmail:

sudo apt-get install sendmail

Installing Pear:

sudo apt-get install php-pear

Installing PHPUnit:

sudo apt-get install phpunit

Installing Composer:

php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
# optional php -r "if (hash_file('sha384', 'composer-setup.php') === '55ce33d7678c5a611085589f1f3ddf8b3c52d662cd01d4ba75c0ee0459970c2200a51f492d557530c71c15d8dba01eae') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"
php composer-setup.php
php -r "unlink('composer-setup.php');"

Installing Selenium extension:

sudo apt-get install php-curl
php composer.phar require --dev phpunit/phpunit
php composer.phar require --dev phpunit/phpunit-selenium=1.2.9

Installing Phing:

php composer.phar require --dev phing/phing

Running Unit Tests

Goto protected/tests directory and type in command line:

cd protected/tests
phpunit --stderr unit

This will run all unit tests in unit subfolder. The --stderr key should be used to avoid sending headers befor session is created.

To avoid Code Coverage low memory PHP error, increase memory limit in php.ini from 128M to 256M and restart Apache.

Troubleshooting:

Error CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crashfix.b.status' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
- Run in database SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',));
- Making GROUP_BY setting permanent: Above setting will not survive a MySQL restart or a system reboot. Need to edit MySQL /etc/mysql/my.cnf adding this line to the end... sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION then restart MySQL... $ sudo systemctl start mysql.service

jsonzilla/crashfix_webapp