Date: Wed, 08 Aug 2012 04:42:25 +0000 From: tzabal@FreeBSD.org To: svn-soc-all@FreeBSD.org Subject: socsvn commit: r240184 - soc2012/tzabal/server-side/akcrs-setup Message-ID: <20120808044225.0F2F0106564A@hub.freebsd.org>
next in thread | raw e-mail | index | archive | help
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 ###########################################################
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20120808044225.0F2F0106564A>