Read Me

mysql
	user: knop
	password: fccs
	host: localhost

web
	password: knoplab



HOW TO INSTALL THE DATABASE AND THE APPLICATION ON A NEW LINUX SERVER


The script sql/create_db_user.sql must be used in mysql as root


Requirements:
 - PDO extension for PHP
 - stats module for PHP
 - Pylab library for Python must be installed and accessible for php. That means a ".matplotlib" directory must me created and writable in /var/www/
 - Spreadsheet::ParseExcel module for Perl
 - Statistics::Descriptive module for Perl
 - Data::Dumper module for Perl
 - DBI module for Perl
 - File::Glob module for Perl


Commands (as root, assuming a LAMP solution is already installed and works properly):

UBUNTU:
apt-get install php-mysql
apt-get install php5-dev
apt-get install python-numeric
apt-get install php-pear
cpan -i Spreadsheet::ParseExcel
pecl install stats (then add "extension=<path>/stats.so" in the php.ini file)
apt-get install python-matplotlib
mkdir /var/www/.matplotlib
chmod -R 777 /var/www/.matplotlib

REDHAT:
yum install php-mysql
yum install python-numeric
yum install php-pear
cpan -i Spreadsheet::ParseExcel
pecl install stats (then add "extension=<path>/stats.so" in the php.ini file)
rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-3.noarch.rpm
yum install python-matplotlib
mkdir /var/www/.matplotlib
chmod -R 777 /var/www/.matplotlib