socsvn commit: r240184 - soc2012/tzabal/server-side/akcrs-setup

[tzabal at FreeBSD.org]

Author: tzabal
Date: Wed Aug  8 04:42:24 2012
New Revision: 240184
URL: http://svnweb.FreeBSD.org/socsvn/?view=rev&rev=240184

Log:
  Modification on the database schema and on the installation guide.

Modified:
  soc2012/tzabal/server-side/akcrs-setup/database.sql
  soc2012/tzabal/server-side/akcrs-setup/setup

Modified: soc2012/tzabal/server-side/akcrs-setup/database.sql
==============================================================================
--- soc2012/tzabal/server-side/akcrs-setup/database.sql	Wed Aug  8 00:20:30 2012	(r240183)
+++ soc2012/tzabal/server-side/akcrs-setup/database.sql	Wed Aug  8 04:42:24 2012	(r240184)
@@ -3,22 +3,22 @@
  * for the PostgreSQL DBMS
  */
 
-DROP TABLE Reports;
-DROP TABLE Bugs;
-DROP TABLE Submitters;
+DROP TABLE reports;
+DROP TABLE bugs;
+DROP TABLE submitters;
 
 
-CREATE TABLE Submitters
+CREATE TABLE submitters
 (
     id serial NOT NULL,
     email varchar(254) NOT NULL,
-    password varchar(64) NOT NULL,
+    password char(64) NOT NULL,
     
     CONSTRAINT submitters_pkey PRIMARY KEY (id)
 );
 
 
-CREATE TABLE Bugs
+CREATE TABLE bugs
 (
     id serial NOT NULL,
     state varchar(10) NOT NULL,
@@ -28,12 +28,13 @@
 );
 
 
-CREATE TABLE Reports
+CREATE TABLE reports
 (
     id serial NOT NULL,
     bug_id integer NOT NULL,
     submitter_id integer NOT NULL,
     received_date date DEFAULT CURRENT_DATE,
+    confirmation_code char(16) NOT NULL,
     confirmed boolean DEFAULT false,
     crashtype text,
     crashdate text,
@@ -44,6 +45,8 @@
     machine text,
     panic text,
     backtrace text,
+    top_significant_func text,
+    rem_significant_funcs text[],
     ps_axl text,
     vmstat_s text,
     vmstat_m text,
@@ -71,4 +74,4 @@
     CONSTRAINT reports_submitter_id_fkey FOREIGN KEY (submitter_id) REFERENCES Submitters (id)
 );
 
-INSERT INTO Bugs (id, state, reported) VALUES (-1, 'Unknown', 0);
+INSERT INTO bugs (id, state, reported) VALUES (-1, 'Unknown', -1);
\ No newline at end of file

Modified: soc2012/tzabal/server-side/akcrs-setup/setup
==============================================================================
--- soc2012/tzabal/server-side/akcrs-setup/setup	Wed Aug  8 00:20:30 2012	(r240183)
+++ soc2012/tzabal/server-side/akcrs-setup/setup	Wed Aug  8 04:42:24 2012	(r240184)
@@ -29,6 +29,9 @@
 # Create an auxiliary directory used for various actions
 mkdir /tmp/crashreports
 
+# Create a directory where the invalid crash reports will be keeped for debugging purposes
+mkdir /tmp/crashreports/invalidreports
+
 # Make sure that the OpenSSH daemon is enabled
 cat /etc/rc.conf | grep 'sshd_enable="YES"'
 
@@ -66,7 +69,43 @@
 ###########################################################
 # Part 2. Apache
 ###########################################################
+# Install the default and the most widely used version of the Apache HTTP Server in FreeBSD (Apache HTTP Server 2.2.22)
+cd /usr/ports/www/apache22
+
+# Make any necessary configuration (THREADS selected)
+make config
+
+# Build, install and clean
+make install clean
+
+# Launch Apache at system startup
+echo 'apache22_enable="YES"' >> /etc/rc.conf
+
+# Create a copy of the original configuration file
+cp -v /usr/local/etc/apache22/httpd.conf /usr/local/etc/apache22/httpd.conf.original
+
+# Check the Apache configuration for errors. Do this the first time or after every change of the configuration file.
+/usr/local/etc/rc.d/apache22 configtest
+
+# Install the Apache module for WSGI
+cd /usr/ports/www/mod_wsgi3
+make install clean
+
+# Create a directory for the WSGI scripts
+mkdir /usr/local/www/apache22/wsgi-scripts
+
+# Place the WSGI script inside the WSGI directory
+cp -v /home/tzabal/confirm_report.wsgi /usr/local/www/apache22/wsgi-scripts
+
+# Set proper permissions (others need to have execute permissions)
+chmod 755 /usr/local/www/apache22/wsgi-scripts/confirm_report.wsgi
 
+# Make the WSGI script accessible
+echo "WSGIScriptAlias /confirm_report /usr/local/www/apache22/wsgi-scripts/confirm_report.wsgi" >> /usr/local/etc/apache22/httpd.conf
+echo "<Directory /usr/local/www/apache22/wsgi-scripts>" >> /usr/local/etc/apache22/httpd.conf
+echo "    Order allow,deny" >> /usr/local/etc/apache22/httpd.conf
+echo "    Allow from all" >> /usr/local/etc/apache22/httpd.conf
+echo "</Directory>" >> /usr/local/etc/apache22/httpd.conf
 
 
 ###########################################################