[LON-CAPA-cvs] cvs: doc /install/linux install.pl

raeburn raeburn@source.lon-capa.org
Fri, 18 Mar 2011 16:42:12 -0000


This is a MIME encoded message

--raeburn1300466532
Content-Type: text/plain

raeburn		Fri Mar 18 16:42:12 2011 EDT

  Added files:                 
    /doc/install/linux	install.pl 
  Log:
  - Bugs 4400, 4550, 6348.
  - install.pl script used to prepare server for LON-CAPA installation.
     - Combine separate scripts for each supported distro into a single script
       (for: CentOS, Fedora, RHEL, Scientific Linux, SuSE, SLES, Debian, Ubuntu). 
     - Localization added.
     - Checks if LONCAPA prerequisites package is installed.
     - Checks status of www account, runlevels, firewall, MySQL, Apache,
       tarball download, extra services (cups).
     - Suggests appropriate recommended actions. 
     - Handles case where a MySQL root password has already been set. 
  - Requires Term::ReadKey from CPAN. 
    (perl-Term-ReadKey dependency in LONCAPA-preqrequisites 1-20.) 
  
  
--raeburn1300466532
Content-Type: text/plain
Content-Disposition: attachment; filename="raeburn-20110318164212.txt"


Index: doc/install/linux/install.pl
+++ doc/install/linux/install.pl
#!/usr/bin/perl
# The LearningOnline Network 
# Pre-installation script for LON-CAPA
#
# Copyright Michigan State University Board of Trustees
#
# This file is part of the LearningOnline Network with CAPA (LON-CAPA).
#
# LON-CAPA is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# LON-CAPA is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with LON-CAPA; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
#
# http://www.lon-capa.org/
#

use strict;
use File::Copy;
use Term::ReadKey;
use DBI;
use LCLocalization::localize;

# ========================================================= The language handle

my %languages = (
                  ar => 'Arabic', 
                  de => 'German',
                  en => 'English',
                  es => 'Spanish (Castellan)',
                  fa => 'Persian',
                  fr => 'French', 
                  he => 'Hebrew', 
                  ja => 'Japanese',
                  pt => 'Portuguese',
                  ru => 'Russian',
                  tr => 'Turkish',
                  zh => 'Chinese Simplified'
               ); 

use vars qw($lh $lang);
$lang = 'en';
if (@ARGV > 0) {
    foreach my $poss (keys(%languages)) {
        if ($ARGV[0] eq $poss) {
            $lang = $ARGV[0]; 
        }
    }
}

&get_language_handle($lang);

# Check user has root privs
if (0 != $<) {
    print &mt('This script must be run as root.')."\n".
          &mt('Stopping execution.')."\n";
    exit;
}


# Globals: filehandle LOG is global.
if (!open(LOG,">>loncapa_install.log")) {
    print &mt('Unable to open log file.')."\n".
          &mt('Stopping execution.')."\n";
    exit;
} else {
    print LOG '$Id: install.pl,v 1.1 2011/03/18 16:42:12 raeburn Exp $'."\n";
}

#
# Helper routines and routines to establist recommended actions
#

sub get_language_handle {
    my @languages = @_;
    $lh=LCLocalization::localize->get_handle(@languages);
}

sub mt (@) {
    if ($lh) {
        if ($_[0] eq '') {
            if (wantarray) {
                return @_;
            } else {
                return $_[0];
            }
        } else {
            return $lh->maketext(@_);
        }
    } else {
        if (wantarray) {
            return @_;
        } else {
            return $_[0];
        }
    }
}

sub texthash {
    my (%hash) = @_;
    foreach (keys(%hash)) {
        $hash{$_}=&mt($hash{$_});
    }
    return %hash;
}


sub skip_if_nonempty {
    my ($string,$error)=@_;
    return if (! defined($error));
    chomp($string);chomp($error);
    if ($string ne '') {
        print_and_log("$error\n".&mt('Stopping execution.')."\n");
        return 1;
    }
    return;
}

sub writelog {
    while ($_ = shift) {
        chomp();
        print LOG "$_\n";
    }
}

sub print_and_log {
    while ($_=shift) {
        chomp();
        print "$_\n";
        print LOG "$_\n";
    }
}

sub get_user_selection {
    my ($defaultrun) = @_;
    my $do_action = 0;
    my $choice = <STDIN>;
    chomp($choice);
    $choice =~ s/(^\s+|\s+$)//g;
    my $yes = &mt('y');
    if ($defaultrun) {
        if (($choice eq '') || ($choice =~ /^\Q$yes\E/i)) {
            $do_action = 1;
        }
    } else {
        if ($choice =~ /^\Q$yes\E/i) {
            $do_action = 1;
        }
    }
    return $do_action;
}

sub get_distro {
    my ($distro,$gotprereqs,$updatecmd,$packagecmd,$installnow);
    $packagecmd = '/bin/rpm -q LONCAPA-prerequisites ';
    if (-e '/etc/redhat-release') {
        open(IN,'</etc/redhat-release');
        my $versionstring=<IN>;
        chomp($versionstring);
        close(IN);
        if ($versionstring =~ /^Red Hat Linux release ([\d\.]+) /) {
            my $version = $1;
            if ($version=~/^7\./) {
                $distro='redhat7';
            } elsif ($version=~/^8\./) {
                $distro='redhat8';
            } elsif ($version=~/^9/) {
                $distro='redhat9';
            }
        } elsif ($versionstring =~ /Fedora( Core)? release ([\d\.]+) /) {
            my $version=$2;
            if ($version - int($version) > .9) {
                $distro = 'fedora'.(int($version)+1);
            } else {
                $distro = 'fedora'.int($version);
            }
            $updatecmd = 'yum install LONCAPA-prerequisites';
            $installnow = 'yum -y install LONCAPA-prerequisites';
        } elsif ($versionstring =~ /Red Hat Enterprise Linux [AE]S release ([\d\.]+) /) {
            $distro = 'rhes'.$1;
            $updatecmd = 'up2date -i LONCAPA-prerequisites';
        } elsif ($versionstring =~ /Red Hat Enterprise Linux Server release (\d+)/) {
            $distro = 'rhes'.$1;
            $updatecmd = 'yum install LONCAPA-prerequisites';
            $installnow = 'yum -y install LONCAPA-prerequisites';
        } elsif ($versionstring =~ /CentOS release (\d+)/) {
            $distro = 'centos'.$1;
            $updatecmd = 'yum install LONCAPA-prerequisites';
            $installnow = 'yum -y install LONCAPA-prerequisites';
        } elsif ($versionstring =~ /Scientific Linux SL release ([\d.]+) /) {
            my $ver = $1;
            $ver =~ s/\.\d+$//;
            $distro = 'scientific'.$ver;
            $updatecmd = 'yum install LONCAPA-prerequisites';
            $installnow = 'yum -y install LONCAPA-prerequisites';
        } else {
            print &mt('Unable to interpret [_1] to determine system type.',
                      '/etc/redhat-release')."\n";
        }
    } elsif (-e '/etc/SuSE-release') {
        open(IN,'</etc/SuSE-release');
        my $versionstring=<IN>;
        chomp($versionstring);
        close(IN);
        if ($versionstring =~ /^SUSE LINUX Enterprise Server ([\d\.]+) /i) {
            $distro='sles'.$1;
            if ($1 >= 10) {
                $updatecmd = 'zypper install LONCAPA-prerequisites';
            } else {
                $updatecmd = 'yast -i LONCAPA-prerequisites';
            }
        } elsif ($versionstring =~ /^SuSE Linux ([\d\.]+) /i) {
            $distro = 'suse'.$1;
            $updatecmd = 'yast -i LONCAPA-preprequisites';
        } elsif ($versionstring =~ /^openSUSE ([\d\.]+) /i) {
            $distro = 'suse'.$1;
            if ($1 >= 10.3 ) {
                $updatecmd = 'zypper install LONCAPA-prerequisites';
            } else {
                $updatecmd = 'yast -i LONCAPA-prerequisites';
            }
        } else {
            print &mt('Unable to interpret [_1] to determine system type.',
                      '/etc/SuSE-release')."\n";
        }
    } elsif (-e '/etc/issue') {
        open(IN,'</etc/issue');
        my $versionstring=<IN>;
        chomp($versionstring);
        close(IN);
        $packagecmd = '/usr/bin/dpkg -l loncapa-prerequisites ';
        $updatecmd = 'apt-get install loncapa-prerequisites';
        if ($versionstring =~ /^Ubuntu (\d+)\.\d+/i) {
            $distro = 'ubuntu'.$1;
            $updatecmd = 'sudo apt-get install loncapa-prerequisites';
        } elsif ($versionstring =~ /^Debian\s+GNU\/Linux\s+(\d+)\.\d+/i) {
            $distro = 'debian'.$1;
        } elsif (-e '/etc/debian_version') {
            open(IN,'</etc/debian_version');
            my $version=<IN>;
            chomp($version);
            close(IN);
            if ($version =~ /^(\d+)\.\d+\.?\d*/) {
                $distro='debian'.$1;
            } else {
                print &mt('Unable to interpret [_1] to determine system type.',
                          '/etc/debian_version')."\n";
            }
        } else {
            print &mt('Unable to interpret [_1] to determine system type.',
                      '/etc/issue')."\n";
        }
    } elsif (-e '/etc/debian_version') {
        open(IN,'</etc/debian_version');
        my $version=<IN>;
        chomp($version);
        close(IN);
        if ($version =~  /^(\d+)\.\d+\.?\d*/) {
            $distro='debian'.$1;
            $packagecmd = '/usr/bin/dpkg -l loncapa-prerequisites ';
            $updatecmd = 'apt-get install loncapa-prerequisites';
        } else {
            print &mt('Unable to interpret [_1] to determine system type.',
                      '/etc/debian_version')."\n";
        }
    } else {
        print &mt('Unknown installation: expecting a debian, ubuntu, suse, sles, redhat, fedora or scientific linux system.')."\n";
    }
    return ($distro,$packagecmd,$updatecmd,$installnow);
}

sub check_prerequisites {
    my ($packagecmd,$distro) = @_;
    my $gotprereqs;
    if ($packagecmd ne '') {
        if (open(PIPE,"$packagecmd|")) {
            if ($distro =~ /^(debian|ubuntu)/) {
                my @lines = <PIPE>;
                chomp(@lines);
                foreach my $line (@lines) {
                    if ($line =~ /^ii\s+loncapa-prerequisites\s+([\w\.]+)/) {
                        $gotprereqs = $1;
                    }
                }
            } else {
                my $line = <PIPE>;
                chomp($line);
                if ($line =~ /^LONCAPA-prerequisites\-([\d\-]+)\.(\w+)$/) {
                    $gotprereqs = $1;
                }
            }
            close(PIPE);
        } else {
            print &mt('Error: could not determine if LONCAPA-prerequisites package is installed')."\n";
        }
    }
    return $gotprereqs;
}

sub check_required {
    my ($instdir,$dsn) = @_;
    my ($distro,$packagecmd,$updatecmd,$installnow) = &get_distro();
    if ($distro eq '') {
        return;
    }
    my $gotprereqs = &check_prerequisites($packagecmd,$distro); 
    if ($gotprereqs eq '') {
        return ($distro,$gotprereqs,$packagecmd,$updatecmd,$installnow);
    }
    my ($mysqlon,$mysqlsetup,$dbh,$has_pass,$has_lcdb,%recommended,$downloadstatus,
        $filetouse,$production,$testing);
    my $wwwuid = &uid_of_www();
    my $wwwgid = getgrnam('www');
    if (($wwwuid eq '') || ($wwwgid eq '')) {
        $recommended{'wwwuser'} = 1;
    }
    unless( -e "/usr/local/sbin/pwauth") {
        $recommended{'pwauth'} = 1;
    }
    $mysqlon = &check_mysql_running($distro);
    if ($mysqlon) {
        my $mysql_has_wwwuser = &check_mysql_wwwuser();
        ($mysqlsetup,$has_pass,$dbh) = 
            &check_mysql_setup($instdir,$dsn);
        if ($mysqlsetup eq 'noroot') {
            $recommended{'mysqlperms'} = 1;
        } else {
            unless ($mysql_has_wwwuser) {
                $recommended{'mysqlperms'} = 1;
            }
        }
        if ($dbh) {
            $has_lcdb = &check_loncapa_mysqldb($dbh);
        }
        unless ($has_lcdb) {
            $recommended{'mysql'} = 1;
        }
    }
    my $tostop;
    $recommended{'firewall'} = &chkfirewall($distro); 
    ($recommended{'runlevels'},$tostop) = &chkconfig($distro);
    $recommended{'apache'} = &chkapache($distro,$instdir);
    $recommended{'stopsrvcs'} = &chksrvcs($distro,$tostop);
    ($recommended{'download'},$downloadstatus,$filetouse,$production,$testing) 
        = &need_download();
    return ($distro,$gotprereqs,$packagecmd,$updatecmd,$installnow,
            \%recommended,$dbh,$has_pass,$has_lcdb,$downloadstatus,
            $filetouse,$production,$testing);
}

sub check_mysql_running {
    my ($distro) = @_;
    my $mysqldaemon ='mysqld';
    if ($distro =~ /^(suse|sles|debian|ubuntu)/) {
        $mysqldaemon = 'mysql';
    }
    if (open(PIPE,"/etc/init.d/$mysqldaemon status 2>&1 |")) {
        my $status = <PIPE>;
        close(PIPE);
        chomp($status);
        if ($status =~ /\(pid\s+\d+\)/) {
            print_and_log(&mt('MySQL is running.')."\n");
            return 1;
        } else {
            system("/etc/rc.d/init.d/$mysqldaemon start"); 
            print_and_log(&mt('Waiting for MySQL to start.')."\n");
            sleep 5;
            if (open (PIPE, "/etc/init.d/$mysqldaemon 2>&1 |")) {
                my $status = <PIPE>;
                close(PIPE);
                chomp($status);
                if ($status =~ /\(pid\s+\d\)/) {
                    print_and_log(&mt('MySQL is running.')."\n");
                    return 1;
                } else {
                    print_and_log(&mt('Unable to start MySQL.')."\n"); 
                }
            } else {
                print_and_log(&mt('Unable to start MySQL.')."\n");
            }
        }
    } else {
        print &mt('Could not determine if MySQL is running.')."\n";
    }
    return;
}

sub chkconfig {
    my ($distro) = @_;
    my (%needfix,%tostop);
    my $checker_bin = '/sbin/chkconfig';
    my $mysqldaemon ='mysqld';
    my $webserver = 'httpd';
    my $cupsdaemon = 'cups';
    my @runlevels = qw/3 4 5/;
    my @norunlevels = qw/0 1 6/;
    if ($distro =~ /^(suse|sles)/) {
        @runlevels = qw/3 5/;
        @norunlevels = qw/0 2 1 6/;
        $mysqldaemon = 'mysql';
        $webserver = 'apache2';
        if ($distro =~ /^(suse|sles)9/) {
            $webserver = 'apache';
        }
    } elsif ($distro =~ /^(debian|ubuntu)/) {
        @runlevels = qw/2 3 4 5/;
        @norunlevels = qw/0 1 6/;
        $checker_bin = '/usr/sbin/sysv-rc-conf';
        $mysqldaemon = 'mysql';
        $webserver = 'apache2';
    }
    if (! -x $checker_bin) {
        print &mt('Could not check runlevel status for MySQL or Apache.')."\n";
        return;
    }
    my $rlstr = join('',@runlevels);
    my $nrlstr = join('',@norunlevels);
    foreach my $type ('apache','mysql','cups') {
        my $service;
        if ($type eq 'apache') {
            $service = $webserver;
        } elsif ($type eq 'mysql') {
            $service = $mysqldaemon; 
        } elsif ($type eq 'cups') {
            $service = $cupsdaemon;
        }
        my $command = $checker_bin.' --list '.$service;
        my $results = `$command`;
        my $tofix;
        if ($results eq '') {
            if (($type eq 'apache') || ($type eq 'mysql')) {
                if ($distro  =~ /^(debian|ubuntu)/) {
                    $tofix = "$checker_bin --level $nrlstr $service off\n";
                } else {
                    $tofix = "$checker_bin --add $service\n";
                }
            }
        } else {
            my %curr_runlevels;
            for (my $rl=0; $rl<=6; $rl++) {
                if ($results =~ /$rl:on/) { $curr_runlevels{$rl}++; }
            }
            if (($type eq 'apache') || ($type eq 'mysql')) {
                my $warning;
                foreach my $rl (@runlevels) {
                    if (!exists($curr_runlevels{$rl})) {
                        $warning = 1;
                    }
                }
                if ($warning) {
                    $tofix = "$checker_bin --level $rlstr $service on\n";
                }
            } elsif (keys(%curr_runlevels) > 0) {
                $tostop{$type} = 1;
            }
        }
        if ($tofix) {
            $needfix{$type} = $tofix;
        }    
    }
    if ($distro =~ /^(suse|sles)([\d\.]+)$/) {
        my $name = $1;
        my $version = $2;
        my ($major,$minor);
        if ($name eq 'suse') {
            ($major,$minor) = split(/\./,$version);
        } else {
            $major = $version;
        }
        if ($major > 10) {
            $needfix{'insserv'} = &check_SuSEfirewall2_setup();
        }
    }
    return (\%needfix,\%tostop);
}

sub chkfirewall {
    my $configfirewall = 1;
    my %ports = (
                    http  =>  80,
                    https => 443,
                );
    if (&firewall_is_active()) {
        my $iptables = &get_pathto_iptables();
        if ($iptables eq '') {
            print &mt('Firewall not checked as path to iptables not determined.')."\n";
        } else {
            my @fwchains = &get_fw_chains($iptables);
            if (@fwchains) {
                my %activefw;
                foreach my $service ('http','https') {
                    foreach my $fwchain (@fwchains) {
                        if (&firewall_is_port_open($iptables,$fwchain,$ports{$service})) {
                            $activefw{$service} = 1;
                            last;
                        }
                    }
                }
                if ($activefw{'http'}) {
                    $configfirewall = 0;
                }
            } else {
                print &mt('Firewall not checked as iptables Chains not identified.')."\n";
            }
        }
    } else {
        print &mt('Firewall not enabled.')."\n";
    }
    return $configfirewall;
}

sub chkapache {
    my ($distro,$instdir) = @_;
    my $fixapache = 1;
    if ($distro =~ /^(debian|ubuntu)/) {
        if (!-e "$instdir/apache2.conf") {
            $fixapache = 0;
            print &mt('Warning: No LON-CAPA Apache configuration file found for installation check.')."\n"; 
        } elsif ((-e "/etc/apache2/sites-available/loncapa") && (-e "$instdir/apache2.conf")) {
            if (open(PIPE, "diff --brief $instdir/apache2.conf /etc/apache2/sites-available/loncapa |")) {
                my $diffres = <PIPE>;
                close(PIPE);
                chomp($diffres);
                unless ($diffres) {
                    $fixapache = 0;
                }
            }
        }
    } elsif ($distro =~ /^(?:suse|sles)([\d\.]+)$/) {
        my $apache = 'apache';
        if ($1 >= 10) {
            my $apache = 'apache2';
        }
        if (!-e "$instdir/default-server.conf") {
            $fixapache = 0;
            print &mt('Warning: No LON-CAPA Apache configuration file found for installation check.')."\n";
        } elsif ((-e "/etc/$apache/default-server.conf") && (-e "$instdir/default-server.conf")) {
            if (open(PIPE, "diff --brief $instdir/default-server.conf /etc/$apache/default-server.conf |")) {
                my $diffres = <PIPE>;
                close(PIPE);
                chomp($diffres);
                unless ($diffres) {
                    $fixapache = 0;
                }
            }
        }
    } else {
        if (!-e "$instdir/httpd.conf") {
            $fixapache = 0;
            print &mt('Warning: No LON-CAPA Apache configuration file found for installation check.')."\n";
        } elsif ((-e "/etc/httpd/conf/httpd.conf") && (-e "$instdir/httpd.conf")) {
            if (open(PIPE, "diff --brief $instdir/httpd.conf /etc/httpd/conf/httpd.conf |")) {
                my $diffres = <PIPE>;
                close(PIPE);
                chomp($diffres);
                print "Diff is ||$diffres||\n";
                unless ($diffres) {
                    $fixapache = 0;
                }
            }
        }
    }
    return $fixapache;
}

sub chksrvcs {
    my ($distro,$tostop) = @_;
    my %stopsrvcs;
    if (ref($tostop) eq 'HASH') {
        %stopsrvcs = %{$tostop};
    }
    foreach my $service ('cups') {
        next if (exists($stopsrvcs{$service}));
        my $daemon = $service;
        if ($service eq 'cups') {
            $daemon = 'cupsd';
        }
        my $cmd = "ps -ef |grep '$daemon' |grep -v grep";
        if (open(PIPE,'-|',$cmd)) {
            my $daemonrunning = <PIPE>;
            chomp($daemonrunning);
            close(PIPE);
            if ($daemonrunning) {
                $stopsrvcs{$service} = 1;
            }
        }
    } 
    return \%stopsrvcs;
}

sub need_download {
    my $needs_download = 1;
    my ($production,$testing,$stdsizes) = &download_versionslist();
    my ($rootdir,$localcurrent,$localtesting,%tarball,%localsize,%bymodtime,
        %bysize,$filetouse,$downloadstatus);
    $rootdir = '/root';
    if (opendir(my $dir,"$rootdir")) {
        my (@lcdownloads,$version);
        foreach my $file (readdir($dir)) {
            if ($file =~ /^loncapa\-([\w\-.]+)\.tar\.gz$/) {
                $version = $1;
            } else {
                next;
            }
            if (ref($stdsizes) eq 'HASH') {
                if ($version eq 'current') {
                    my @stats = stat("$rootdir/$file");
                    $localcurrent = $stats[7];
                    if ($localcurrent eq $stdsizes->{$production}) {
                        $needs_download = 0;
                        $filetouse = $file;
                    }
                } elsif ($version eq 'testing') {
                    my @stats = stat("$rootdir/$file");
                    $localtesting = $stats[7];
                    if ($localtesting eq $stdsizes->{$testing}) {
                        $needs_download = 0;
                        $filetouse = $file;
                    }
                }
            }
            $tarball{$version} = $file;
            push(@lcdownloads,$version);
        }
        if ($needs_download) {
            if (@lcdownloads > 0) {
                foreach my $version (@lcdownloads) {
                    my @stats = stat("$rootdir/$tarball{$version}");
                    my $mtime = $stats[9];
                    $localsize{$version} = $stats[7];
                    if ($mtime) {
                        push(@{$bymodtime{$mtime}},$version);
                    }
                    if ($localsize{$version}) {
                        push(@{$bysize{$localsize{$version}}},$version);
                    }
                }
                if ($testing) {
                    if (exists($localsize{$testing})) {
                        if ($stdsizes->{$testing} == $localsize{$testing}) {
                            $needs_download = 0;
                            $filetouse = 'loncapa-'.$testing.'.tar.gz';
                        }
                    }
                }
                if ($needs_download) { 
                    if ($production) {
                        if (exists($localsize{$production})) {
                            if ($stdsizes->{$production} == $localsize{$production}) {
                                $needs_download = 0;
                                $filetouse = 'loncapa-'.$production.'.tar.gz';
                            }
                        }
                    }
                }
                if ($needs_download) {
                    my @sorted = sort { $b <=> $a } keys(%bymodtime);
                    my $newest = $sorted[0];
                    if (ref($bymodtime{$newest}) eq 'ARRAY') {
                        $downloadstatus = 
                              "Latest LON-CAPA source download in $rootdir is: ".
                              join(',',@{$bymodtime{$newest}})." (downloaded ".
                              localtime($newest).")\n";
                    }
                } else {
                    $downloadstatus = 
                        "The $rootdir directory already contains the latest LON-CAPA version:".
                        "\n".$filetouse."\n"."which can be used for installation.\n";
                }
            } else {
                $downloadstatus = "The $rootdir directory does not appear to contain any downloaded LON-CAPA source code files which can be used for installation.\n";
            }
        }
    } else {
        $downloadstatus = "Could not open $rootdir directory to look for existing downloads of LON-CAPA source code.\n";
    }
    return ($needs_download,$downloadstatus,$filetouse,$production,$testing);
}

sub check_mysql_setup {
    my ($instdir,$dsn) = @_;
    my ($mysqlsetup,$has_pass);
    my $dbh = DBI->connect($dsn,'root','',{'PrintError'=>0});
    if ($dbh) {
        $mysqlsetup = 'noroot'; 
    } elsif ($DBI::err =~ /1045/) {
        $has_pass = 1;
    }
    if ($has_pass) {
        print &mt('You have already set a root password for the MySQL database.')."\n";
        my $currpass = &get_mysql_password(&mt('Please enter the password now'));
        $dbh = DBI->connect($dsn,'root',$currpass,{'PrintError'=>0});
        if ($dbh) {
            $mysqlsetup = 'rootok';
            print_and_log(&mt('Password accepted.')."\n");
        } else {
            $mysqlsetup = 'rootfail';
            print_and_log(&mt('Problem accessing MySQL.')."\n");
            if ($DBI::err =~ /1045/) {
                print_and_log(&mt('Perhaps the password was incorrect?')."\n");
                print &mt('Try again?').' ';
                $currpass = &get_mysql_password(&mt('Re-enter password now')); 
                $dbh = DBI->connect($dsn,'root',$currpass,{'PrintError'=>0});
                if ($dbh) {
                    $mysqlsetup = 'rootok';
                    print_and_log(&mt('Password accepted.')."\n");
                } else {
                    if ($DBI::err =~ /1045/) {
                        print_and_log(&mt('Incorrect password.')."\n");
                    }
                }
            }
        }
     } elsif ($mysqlsetup ne 'noroot') {
        print_and_log(&mt('Problem accessing MySQL.')."\n");
        $mysqlsetup = 'rootfail';
    }
    return ($mysqlsetup,$has_pass,$dbh);
}

sub check_mysql_wwwuser {
    my $mysql_wwwuser;
    my $dbhn = DBI->connect("DBI:mysql:database=information_schema",'www','localhostkey');
    if ($dbhn) {
        $mysql_wwwuser = 1;
        $dbhn->disconnect;
    }
    return $mysql_wwwuser;
}

sub check_loncapa_mysqldb {
    my ($dbh) = @_;
    my $has_lcdb;
    if (ref($dbh)) {
        my $sth = $dbh->prepare("SHOW DATABASES");
        $sth->execute();
        while (my $dbname = $sth->fetchrow_array) {
            if ($dbname eq 'loncapa') {
                $has_lcdb = 1;
                last;
            }
        }
        $sth->finish();
    }
    return $has_lcdb;
}

sub get_pathto_iptables {
    my $iptables;
    if (-e '/sbin/iptables') {
        $iptables = '/sbin/iptables';
    } elsif (-e '/usr/sbin/iptables') {
        $iptables = '/usr/sbin/iptables';
    } else {
        print &mt('Unable to find iptables command.')."\n";
    }
    return $iptables;
}

sub firewall_is_active {
    if (-e '/proc/net/ip_tables_names') {
        return 1;
    } else {
        return 0;
    }
}

sub get_fw_chains {
    my ($iptables) = @_;
    my @fw_chains;
    my $suse_config = "/etc/sysconfig/SuSEfirewall2";
    my $ubuntu_config = "/etc/ufw/ufw.conf";
    if (-e $suse_config) {
        push(@fw_chains,'input_ext');
    } else {
        my @posschains;
        if (-e $ubuntu_config) {
            @posschains = ('ufw-user-input','INPUT');
        } else {
            @posschains = ('RH-Firewall-1-INPUT','INPUT');
            if (!-e '/etc/sysconfig/iptables') {
                if (!-e '/var/lib/iptables') {
                    print &mt('Unable to find iptables file containing static definitions.')."\n";
                }
                push(@fw_chains,'RH-Firewall-1-INPUT');
            }
        }
        if ($iptables eq '') {
            $iptables = &get_pathto_iptables();
        }
        my %counts;
        if (open(PIPE,"$iptables -L -n |")) {
            while(<PIPE>) {
                foreach my $chain (@posschains) {
                    if (/(\Q$chain\E)/) {
                        $counts{$1} ++;
                    }
                }
            }
            close(PIPE);
        }
        foreach my $fw_chain (@posschains) {
            if ($counts{$fw_chain}) {
                unless(grep(/^\Q$fw_chain\E$/,@fw_chains)) {
                    push(@fw_chains,$fw_chain);
                }
            }
        }
    }
    return @fw_chains;
}

sub firewall_is_port_open {
    my ($iptables,$fw_chain,$port) = @_;
    # returns 1 if the firewall port is open, 0 if not.
    #
    # check if firewall is active or installed
    return if (! &firewall_is_active());
    my $count = 0;
    if (open(PIPE,"$iptables -L $fw_chain -n |")) {
        while(<PIPE>) {
            if (/tcp dpt\:\Q$port\E/) {
                $count ++;
                last;
            }
        }
        close(PIPE);
    } else {
        print &mt('Firewall status not checked: unable to run [_1].','iptables -L')."\n";
    }
    return $count;
}

sub get_mysql_password {
    my ($prompt) = @_;
    local $| = 1;
    print $prompt.': ';
    my $newpasswd = '';
    ReadMode 'raw';
    my $key;
    while(ord($key = ReadKey(0)) != 10) {
        if(ord($key) == 127 || ord($key) == 8) {
            chop($newpasswd);
            print "\b \b";
        } elsif(!ord($key) < 32) {
            $newpasswd .= $key;
            print '*';
        }
    }
    ReadMode 'normal';
    print "\n";
    return $newpasswd;
}

sub check_SuSEfirewall2_setup {
    my ($instdir) = @_;
    my $need_override = 1;
    if ((-e "/etc/insserv/overrides/SuSEfirewall2_setup") && (-e "$instdir/SuSEfirewall2_setup")) {
        if (open(PIPE, "diff --brief $instdir/SuSEfirewall2_setup /etc/insserv/overrides/SuSEfirewall2_setup  |")) {
            my $diffres = <PIPE>;
            close(PIPE);
            chomp($diffres);
            unless ($diffres) {
                $need_override = 0;
            }
        }
    }
    return $need_override;
}

sub download_versionslist {
    my ($production,$testing,%sizes);
    if (-e "latest.txt") {
         unlink("latest.txt");
    }
    my $rtncode = system("wget http://install.loncapa.org/versions/latest.txt ".
                         "> /dev/null 2>&1");
    if (!$rtncode) {
        if (open(my $fh,"<latest.txt")) {
            my @info = <$fh>;
            close($fh);
            foreach my $line (@info) {
                chomp();
                if ($line =~ /^\QLATEST-IS: \E([\w\-.]+):(\d+)$/) {
                     $production = $1;
                     $sizes{$1} = $2;
                } elsif ($line =~ /^LATEST-TESTING-IS: \E([\w\-.]+):(\d+)$/) {
                     $testing = $1;
                     $sizes{$1} = $2;
                }
            }
        }
    }
    return ($production,$testing,\%sizes);
}

#
# End helper routines.
# Main script starts here
#

print "
********************************************************************

                    ".&mt('Welcome to LON-CAPA')."

".&mt('This script will configure your system for installation of LON-CAPA.')."

********************************************************************

".&mt('The following actions are available:')."

1. ".&mt('Create the www user/group.')."
   ".&mt('This is the user/group ownership under which Apache child processes run.')."
   ".&mt('It also owns most directories within the /home/httpd directory.')." 
   ".&mt('This directory is where most LON-CAPA files and directories are stored.')."
2. ".&mt('Install the package LON-CAPA uses to authenticate users.')."
3. ".&mt('Set-up the MySQL database.')."
4. ".&mt('Set-up MySQL permissions.')."
5. ".&mt('Configure Apache web server.')."
6. ".&mt('Configure start-up of services.')."
7. ".&mt('Check firewall settings.')."
8. ".&mt('Stop services not used by LON-CAPA,')."
   ".&mt('i.e., services for a print server: [_1] daemon.',"'cups'")."
9. ".&mt('Download LON-CAPA source code in readiness for installation.')."

".&mt('Typically, you will run this script only once, when you first install LON-CAPA.')." 

".&mt('The script will analyze your system to determine which actions are recommended.')."
".&mt('The script will then prompt you to choose the actions you would like taken.')."

".&mt('For each the recommended action will be selected if you hit Enter/Return.')."
".&mt('To override the default, type the lower case option from the two options listed.')."
".&mt('So, if the default is "yes", ~[Y/n~] will be shown -- type n to override.')."
".&mt('Whereas if the default is "no", ~[y/N~] will be shown -- type y to override.')." 

".&mt('To accept the default, simply hit Enter/Return on your keyboard.')."
".&mt('Otherwise type: y or n then hit the Enter/Return key.')."

".&mt('Once a choice has been entered for all nine actions, required changes will be made.')."
".&mt('Feedback will be displayed on screen, and also stored in: [_1].','loncapa_install.log')."

".&mt('Continue? ~[Y/n~] ');

my $go_on = &get_user_selection(1);
if (!$go_on) {
    exit;
}

my $instdir = `pwd`;
chomp($instdir);

my %callsub;
my @actions = ('wwwuser','pwauth','mysql','mysqlperms','apache',
               'runlevels','firewall','stopsrvcs','download');
my %prompts = &texthash( 
    wwwuser    => "Create the 'www' user?",
    pwauth     => 'Install the package LON-CAPA uses to authenticate users?',
    mysql      => 'Set-up the MySQL database?',
    mysqlperms => 'Set-up MySQL permissions?',
    apache     => 'Configure Apache web server?',
    runlevels  => 'Set overrides for start-up order of services?',
    firewall   => 'Configure firewall settings for Apache',
    stopsrvcs  => 'Stop extra services not required on a LON-CAPA server?',
    download   => 'Download LON-CAPA source code in readiness for installation?',
);

print "\n".&mt('Checking system status ...')."\n";

my $dsn = "DBI:mysql:database=mysql";
my ($distro,$gotprereqs,$packagecmd,$updatecmd,$installnow,$recommended,
    $dbh,$has_pass,$has_lcdb,$downloadstatus,$filetouse,$production,
    $testing) = &check_required($instdir,$dsn); 
if ($distro eq '') {
    print "\n".&mt('Linux distribution could not be verified as a supported distribution.')."\n".
          &mt('The following are supported: [_1].',
              'CentOS, RedHat Enterprise, Fedora, Scientific Linux, '.
              'openSuSE, SLES, Ubuntu LTS, Debian')."\n\n".
          &mt('Stopping execution.')."\n";
    exit;
}
if (!$gotprereqs) {
    print "\n".&mt('The LONCAPA-prequisites package is not installed.')."\n".
          &mt('The following command can be used to install the package (and dependencies):')."\n\n".
          $updatecmd."\n\n";
    if ($installnow eq '') {
        print &mt('Stopping execution.')."\n";
        exit;
    } else {
        print &mt('Run command? ~[Y/n~]');
        my $install_prereq = &get_user_selection(1);
        if ($install_prereq) {
            if (open(PIPE,'|-',$installnow)) {
                close(PIPE);
                $gotprereqs = &check_prerequisites($packagecmd,$distro);
                if (!$gotprereqs) {
                    print &mt('The LONCAPA-prequisites package is not installed.')."\n".
                          &mt('Stopping execution.')."\n";
                    exit;
                } else {
                    ($distro,$gotprereqs,$packagecmd,$updatecmd,$installnow,
                     $recommended,$dbh,$has_pass,$has_lcdb,$downloadstatus,
                     $filetouse) = &check_required($instdir,$dsn);
                }
            } else {
                print &mt('Failed to run command to install LONCAPA-prequisites')."\n";
                exit;
            }
        } else {
            print &mt('Stopping execution.')."\n";
            exit;
        }
    }
}
unless (ref($recommended) eq 'HASH') {
    print "\n".&mt('An error occurred determining which actions are recommended.')."\n\n".
          &mt('Stopping execution.')."\n";
    exit;
}

print "\n";
my $num = 0;
foreach my $action (@actions) {
    $num ++;
    my ($yesno,$defaultrun);
    if (ref($recommended) eq 'HASH') {
        if (($action eq 'runlevels') || ($action eq 'services')) {
            $yesno = '[y/N]';
            if (ref($recommended->{$action}) eq 'HASH') {
                if (keys(%{$recommended->{$action}}) > 0) {
                    $yesno = &mt('~[Y/n~]');
                    $defaultrun = 1;
                }
            }
        } else {
            if ($action eq 'download') {
                if ($downloadstatus) {
                    print "\n$downloadstatus\n";
                }
            }
            if ($recommended->{$action}) {
                $yesno = mt('~[Y/n~]');
                $defaultrun = 1;
            } else {
                $yesno = &mt('~[y/N~]');
            }
        }
        print $num.'. '.$prompts{$action}." $yesno ";
        $callsub{$action} = &get_user_selection($defaultrun);
    }
}

my $lctarball = 'loncapa-current.tar.gz';
my $sourcetarball = $lctarball;
if ($callsub{'download'}) {
    my ($production,$testing,$sizes) = &download_versionslist();
    if ($production && $testing) {
        if ($production ne $testing) {
            print &mt('Two recent LON-CAPA releases are available: ')."\n".
                  &mt('1. A production release - version: [_1].',$production)."\n".
                  &mt('2. A testing release - version: [_1].',$testing)."\n\n".
                  &mt('Download the production release? ~[Y/n~]');
            if (&get_user_selection(1)) {
                $sourcetarball = $production.'tar.gz';
            } else {
                print "\n".&mt('Download the testing release? ~[Y/n~]');
                if (&get_user_selection(1)) {
                    $sourcetarball = $testing.'.tar.gz';
                }
            }
        }
    } elsif ($production) {
        print &mt('The most recent LON-CAPA release is version: [_1].',$production)."\n".
              &mt('Download the production release? ~[Y/n~]');
        if (&get_user_selection(1)) {
            $sourcetarball = $production.'tar.gz';
        }
    }
} elsif ($filetouse ne '') {
    $sourcetarball = $filetouse;
}

print_and_log("\n");

# Each action: report if skipping, or perform action and provide feedback. 
if ($callsub{'wwwuser'}) {
    &setup_www();
} else {
    &print_and_log(&mt('Skipping creation of user [_1].',"'www'")."\n");
}

if ($callsub{'pwauth'}) {
    &build_and_install_mod_auth_external();
} else {
    &print_and_log(&mt('Skipping [_1] installation.',"'pwauth'")."\n");
}

if ($callsub{'mysql'}) {
    if ($dbh) {
        &setup_mysql($callsub{'mysqlperms'},$distro,$dbh,$has_pass,$has_lcdb);
    } else {
        print &mt('Unable to configure MySQL because access is denied.')."\n";
    }
} else {
    &print_and_log(&mt('Skipping configuration of MySQL.')."\n");
    if ($callsub{'mysqlperms'}) {
        if ($dbh) {
            &setup_mysql_permissions($dbh,$has_pass);
        } else {
            print &mt('Unable to configure MySQL because access is denied.')."\n";  
        }
    } else {
        &print_and_log(&mt('Skipping MySQL permissions setup.')."\n");
    }
}

if ($dbh) {
    if (!$dbh->disconnect) {
        &print_and_log(&mt('Failed to disconnect from MySQL:')."\n".
                       $dbh->errstr);
    }
}

if ($callsub{'apache'}) {
    if ($distro =~ /^(suse|sles)/) {
        &copy_apache2_suseconf($instdir);
    } elsif ($distro =~ /^(debian|ubuntu)/) {
        &copy_apache2_debconf($instdir);
    } else {
        &copy_httpd_conf($instdir);
    }
} else {
    print_and_log(&mt('Skipping configuration of Apache web server.')."\n");
}

if ($callsub{'runlevels'}) {
    my $count = 0;
    if (ref($recommended) eq 'HASH') {
        if (ref($recommended->{'runlevels'}) eq 'HASH') {
            foreach my $type (keys(%{$recommended->{'runlevels'}})) {
                next if ($type eq 'insserv');
                $count ++;
                my $command = $recommended->{'runlevels'}{$type};
                if ($command ne '') {
                    print_and_log(&mt('Runlevel update command run: [_1].',$command)."\n");
                    system($command);
                }
            }
            if (!$count) {
                print_and_log(&mt('No runlevel updates required.')."\n");
            }  
        }
    }
    &update_SuSEfirewall2_setup($instdir);
} else {
    &print_and_log(&mt('Skipping setting override for start-up order of services.')."\n");
}

if ($callsub{'firewall'}) {
    if ($distro =~ /^(suse|sles)/) {
        print &mt('Use [_1].','yast')."\n";
    } elsif ($distro = /^(debian|ubuntu)/) {
        print &mt('Use [_1].','ufw')."\n";
    } else {
        print &mt('Use [_1].','setup')."\n";
    }
} else {
    if ($distro =~ /^(suse|sles)/) {
        &print_and_log(&mt('Skipping Firewall configuration.')."\n");
    }
}

if ($callsub{'stopsrvcs'}) {
    &kill_extra_services($distro,$recommended->{'stopsrvcs'});
} else {
    &print_and_log(&mt('Skipping stopping unnecessary services ([_1] and [_2] daemons).',"'cups'","'sendmail'")."\n");
}

my ($have_tarball,$updateshown);
if ($callsub{'download'}) {
    ($have_tarball,$updateshown) = &download_loncapa($instdir,$sourcetarball);
} else {
    print_and_log(&mt('Skipping download of LON-CAPA tar file.')."\n\n");
    print &mt('LON-CAPA is available for download from: [_1]',
              'http://install.loncapa.org/')."\n";
    if (!-e '/etc/loncapa-release') {
        &print_and_log(&mt('LON-CAPA is not yet installed on your system.'). 
                       "\n\n". 
                       &mt('You may retrieve the source for LON-CAPA by executing:')."\n".
                       "wget http://install.loncapa.org/versions/$lctarball\n");
    } else {
        my $currentversion;
        if (open(my $fh,"</etc/loncapa-release")) {
            my $version = <$fh>;
            chomp($version);
            if ($version =~ /^\QLON-CAPA release \E([\w\-.]+)$/) {
                $currentversion = $1;
            }
        }
        if ($currentversion ne '') {
            print &mt('Version of LON-CAPA currently installed on this server is: [_1].',
                      $currentversion),"\n";
            if ($production) {
                print &mt('The latest production release of LON-CAPA is [_1].',$production)."\n";
            }
            if ($testing) {
                print &mt('The latest testing release of LON-CAPA is [_1].',$testing)."\n";
            }
        }
    }
    if ($filetouse ne '') {
        $have_tarball = 1;
    }
}

print "\n".&mt('Requested configuration complete.')."\n\n";
my $apachename;
if ($have_tarball && !$updateshown) {
    my ($lcdir) = ($sourcetarball =~ /^([\w.\-]+)\.tar.gz$/);
    if (!-e '/etc/loncapa-release') {
        print &mt('If you are now ready to install LON-CAPA, enter the following commands:')."\n\n";
    } else {
        print &mt('If you are now ready to update LON-CAPA, enter the following commands:')."\n\n".
                  "/etc/init.d/loncontrol stop\n";
        if ($distro =~ /^(suse|sles|debian|ubuntu)([\d.]+)/) {
            if (($1 eq 'suse') && ($2 < 10)) {
                $apachename = 'apache';
            } else {
                $apachename = 'apache2';
            }
        } else {
            $apachename = 'httpd';
        }
        print "/etc/init.d/$apachename stop\n";
    }
    print "cd /root\n".
          "tar zxf $sourcetarball\n".
          "cd $lcdir\n".
          "./UPDATE\n";
    if (-e '/etc/loncapa-release') {
        print "/etc/init.d/loncontrol start\n";
        print "/etc/init.d/$apachename start\n";
    }
}
exit;

#
# End main script
#

#
# Routines for the actions
#
 
sub setup_www {
    ##
    ## Set up www
    ##
    print_and_log(&mt('Creating user [_1]',"'www'")."\n");
    # -- Add group

    my $status = `/usr/sbin/groupadd www`;
    if ($status =~ /\QGroup `www' already exists.\E/) {
        print &mt('Group [_1] already exists.',"'www'")."\n";
    } elsif ($status ne '') {
        print &mt('Unable to add group [_1].',"'www'")."\n";
    }
   
    my $gid = getgrnam('www');

    if (open (PIPE, "/usr/sbin/useradd -c LONCAPA -g $gid www 2>&1 |")) {
        $status = <PIPE>;
        close(PIPE);
        chomp($status);
        if ($status =~ /\QAccount `www' already exists.\E/) {
            print &mt('Account [_1] already exists.',"'www'")."\n";
        } elsif ($status ne '') {
            print &mt('Unable to add user [_1].',"'www'")."\n";
        }
    }  else {
        print &mt('Unable to run command to add user [_1].',"'www'")."\n";
    }

    my $uid = &uid_of_www();
    if (($gid ne '') && ($uid ne '')) {
        if (!-e '/home/www') {
            mkdir('/home/www',0755);
            system('chown www:www /home/www');
        }
    }
    writelog ($status);
}

sub uid_of_www {
    my ($num) = (getpwnam('www'))[2];
    return $num;
}

sub build_and_install_mod_auth_external {
    my ($instdir) = @_;
    my $num = &uid_of_www();
    # Patch pwauth
    print_and_log(&mt('Building authentication system for LON-CAPA users.')."\n");
    my $patch = <<"ENDPATCH";
148c148
< #define SERVER_UIDS 99		/* user "nobody" */
---
> #define SERVER_UIDS $num		/* user "www" */
ENDPATCH

    if (! -e "/usr/bin/patch") {
	print_and_log(&mt('You must install the software development tools package: [_1], when installing Linux.',"'patch'")."\n");
        print_and_log(&mt('Authentication installation not completed.')."\n");
        return;
    }
    if (&skip_if_nonempty(`cd /tmp; tar zxf $instdir/pwauth-2.2.8.tar.gz`,
		     &mt('Unable to extract pwauth')."\n")) {
        return;
    }
    my $dir = "/tmp/pwauth-2.2.8";
    if (open(PATCH,"| patch $dir/config.h")) {
        print PATCH $patch;
        close(PATCH);
        print_and_log("\n");
        ##
        ## Compile patched pwauth
        ##
        print_and_log(&mt('Compiling pwauth')."\n");
        my $result = `cd $dir/; make`;
        my $expected = <<"END";
gcc -g    -c -o pwauth.o pwauth.c
gcc -o pwauth -g  pwauth.o -lcrypt
END
        if ($result eq $expected) {
            print_and_log(&mt('Apparent success compiling pwauth:').
                          "\n".$result );
            # Install patched pwauth
            print_and_log(&mt('Copying pwauth to [_1]',' /usr/local/sbin')."\n");
            if (copy "$dir/pwauth","/usr/local/sbin/pwauth") {
                if (chmod (06755, "/usr/local/sbin/pwauth")) {
                    print_and_log(&mt('[_1] copied successfully',"'pwauth'").
                                  "\n");
                } else {
                    print &mt('Unable to set permissions on [_1].'.
                              "/usr/local/sbin/pwauth")."\n";
                }
            } else {
                print &mt('Unable to copy [_1] to [_2]',
                          "'$dir/pwauth'","/usr/local/sbin/pwauth")."\n$!\n";
            }
        } else {
            print &mt('Unable to compile patched [_1].'."'pwauth'")."\n";
        }
    } else {
        print &mt('Unable to start patch for [_1]',"'pwauth'")."\n";
    }
    print_and_log("\n");
}

sub kill_extra_services {
    my ($distro,$stopsrvcs) = @_;
    if (ref($stopsrvcs) eq 'HASH') {
        my @stopping = sort(keys(%{$stopsrvcs}));
        if (@stopping) {
            my $kill_list = join("',' ",@stopping);
            if ($kill_list) {
                $kill_list = "'".$kill_list."'";
                &print_and_log("\n".&mt('Killing unneccessary services ([_1] daemon(s)).',$kill_list)."\n");
                foreach my $daemon (@stopping) {
                    my $service = $daemon;
	            &print_and_log(`/etc/init.d/$service stop`);
	            &print_and_log(&mt('Removing [_1] from startup.',$service)."\n");
                    if ($daemon eq 'cupsd') {
                        $service = 'cups';
                    }
                    if ($distro =~ /^(debian|ubuntu)$/) {
                        &print_and_log(`/usr/sbin/sysv-rc-conf $service off`);
                    } else {
	                &print_and_log(`chkconfig --del $service`);
                    }
                }
            }
        }
    }
    return;
}

sub setup_mysql {
    my ($setup_mysql_permissions,$distro,$dbh,$has_pass,$has_lcdb) = @_;
    my $mysql_lc_command = "\n";
    unless ($has_lcdb) {
        $mysql_lc_command .= "CREATE DATABASE loncapa;\n";
    }
    $mysql_lc_command .= <<"ENDMYSQL";
USE loncapa;
CREATE TABLE IF NOT EXISTS metadata (title TEXT, author TEXT, subject TEXT, url TEXT, keywords TEXT, version TEXT, notes TEXT, abstract TEXT, mime TEXT, language TEXT, creationdate DATETIME, lastrevisiondate DATETIME, owner TEXT, copyright TEXT, FULLTEXT idx_title (title), FULLTEXT idx_author (author), FULLTEXT idx_subject (subject), FULLTEXT idx_url (url), FULLTEXT idx_keywords (keywords), FULLTEXT idx_version (version), FULLTEXT idx_notes (notes), FULLTEXT idx_abstract (abstract), FULLTEXT idx_mime (mime), FULLTEXT idx_language (language), FULLTEXT idx_owner (owner), FULLTEXT idx_copyright (copyright)) TYPE=MYISAM;
EXIT
ENDMYSQL
    if ($setup_mysql_permissions) {
        &setup_mysql_permissions($dbh,$has_pass,$mysql_lc_command);
    } else {
        print_and_log(&mt('Skipping MySQL permissions setup.')."\n");
        if ($dbh) {
            $dbh->do($mysql_lc_command);
            print_and_log(&mt('MySQL database set up complete.')."\n");
        } else {
            print_and_log(&mt('Problem accessing MySQL.')."\n");
        }
    }
}

sub setup_mysql_permissions {
    my ($dbh,$has_pass,$mysql_lc_command) = @_;
    my $mysqlversion = &get_mysql_version();
    my $mysql_commands = <<"BLOCKONE";
INSERT INTO user (Host, User, Password)
VALUES ('localhost','www',password('localhostkey'));
BLOCKONE
    if ($mysqlversion < 4) {
        $mysql_commands .= <<"BLOCKTWO";
INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Grant_priv,References_priv,Index_priv,Alter_priv) VALUES ('localhost','loncapa','www','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
BLOCKTWO
    } else {
        $mysql_commands .= <<"BLOCKTHREE";
INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Grant_priv,References_priv,Index_priv,Alter_priv,Create_tmp_table_priv,Lock_tables_priv) VALUES ('localhost','loncapa','www','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y');
BLOCKTHREE
    }
    $mysql_commands .= <<"END";
DELETE FROM user WHERE host<>'localhost';
END
    if ($has_pass) {
        if ($dbh) {
            $mysql_commands .= <<"END";
FLUSH PRIVILEGES;
END
            $dbh->do($mysql_commands.$mysql_lc_command);
            print_and_log(&mt('Permissions set for LON-CAPA MySQL user: [_1]',"'www'")."\n");
        } else {
            print_and_log(&mt('Problem accessing MySQL.')."\n".
                          &mt('Permissions not set.')."\n");
        }
    } else {
        my ($firstpass,$secondpass,$got_passwd,$newmysqlpass);
        print &mt('Please enter a root password for the mysql database.')."\n".
              &mt('It does not have to match your root account password, but you will need to remember it.')."\n";
        my $maxtries = 10;
        my $trial = 0;
        while ((!$got_passwd) && ($trial < $maxtries)) {
            $firstpass = &get_mysql_password(&mt('Enter password'));
            if (length($firstpass) > 5) { 
                $secondpass = &get_mysql_password(&mt('Enter password a second time'));
                if ($firstpass eq $secondpass) {
                    $got_passwd = 1;
                    $newmysqlpass = $firstpass;
                } else {
                    print(&mt('Passwords did not match. Please try again.')."\n");
                }
                $trial ++;
            } else {
                print(&mt('Password too short.')."\n".
                      &mt('Please choose a password with at least six characters.')."\n");
            }
        }
        if ($got_passwd) {
            $mysql_commands .= &new_mysqlrootpasswd($newmysqlpass);
        } else {
            print_and_log(&mt('Failed to get MySQL root password from user input.')."\n");
        }
        if ($dbh) {
            $dbh->do($mysql_commands.$mysql_lc_command);
            if ($got_passwd) {
                print_and_log(&mt('MySQL root password stored.')."\n".
                              &mt('Permissions set for LON-CAPA MySQL user: [_1].',"'www'")."\n");
            } else {
                print_and_log(&mt('Permissions set for LON-CAPA MySQL user: [_1].',"'www'")."\n");
            }
        } else {
            print_and_log(&mt('Problem accessing MySQL.')."\n".
                          &mt('Permissions not set.')."\n");
        }
    }
}

sub new_mysql_rootpasswd {
    my ($currmysqlpass) = @_;
    return <<"END";
SET PASSWORD FOR 'root'\@'localhost'=PASSWORD('$currmysqlpass');
FLUSH PRIVILEGES;
END
}

sub get_mysql_version {
    my $version;
    if (open(PIPE," mysql -V |")) {
        my $info = <PIPE>;
        chomp($info);
        close(PIPE);
        ($version) = ($info =~ /(\d+\.\d+)\.\d+,/);  
    } else {
        print &mt('Could not determine which version of MySQL is installed.').
              "\n";
    }
    return $version;
}

###########################################################
##
## RHEL/CentOS/Fedora/Scientific Linux
## Copy LON-CAPA httpd.conf to /etc/httpd/conf
##
###########################################################

sub copy_httpd_conf {
    my ($instdir) = @_;
    print_and_log(&mt('Copying the LON-CAPA [_1] to [_2].',"'httpd.conf'",
                  "'/etc/httpd/conf/httpd.conf'")."\n");
    copy "/etc/httpd/conf/httpd.conf","/etc/httpd/conf/httpd.conf.original";
    copy "$instdir/httpd.conf","/etc/httpd/conf/httpd.conf";
    chmod 0444,"/etc/httpd/conf/httpd.conf";
    print_and_log("\n");
}

#########################################################
##
## Ubuntu/Debian -- copy our apache2 configuration file to
## sites-available and set the symlink from sites-enabled.
##
#########################################################

sub copy_apache2_debconf {
    my ($instdir) = @_;
    print_and_log(&mt('Copying loncapa [_1] config file to [_2] and pointing [_3] to it from sites-enabled.',"'apache2'","'/etc/apache2/sites-available'","']000-default symlink'")."\n");
    my $apache2_enabled_dir = '/etc/apache2/sites-enabled';
    my $apache2_available_dir = '/etc/apache2/sites-available';
    if (-l "$apache2_enabled_dir/000-default") {
        unlink("$apache2_enabled_dir/000-default");
    }
    if (-e "$apache2_available_dir/loncapa") {
        copy("$apache2_available_dir/loncapa","$apache2_available_dir/loncapa.original");
    }
    copy("$instdir/apache2.conf","$apache2_available_dir/loncapa");
    chmod(0444,"$apache2_available_dir/loncapa");
    symlink("$apache2_available_dir/loncapa","$apache2_enabled_dir/000-default");
    print_and_log("\n");
}

###########################################################
##
## openSuSE/SLES Copy apache2 config files:
##   default-server.conf, uid.conf, /etc/sysconfig/apache2 
##   and create symlink from /srv/www/conf to /etc/apache2 
##
###########################################################

sub copy_apache2_suseconf {
    my ($instdir) = @_;
    print_and_log(&mt('Copying the LON-CAPA [_1] to [_2].',
                  "'default-server.conf'",
                  "'/etc/apache2/default-server.conf'")."\n");
    if (!-e "/etc/apache2/default-server.conf.original") {
        copy "/etc/apache2/default-server.conf","/etc/apache2/default-server.conf.original";
    }
    copy "$instdir/default-server.conf","/etc/apache2/default-server.conf";
    chmod 0444,"/etc/apache2/default-server.conf";
    # Make symlink for conf directory (included in loncapa_apache.conf)
    my $can_symlink = (eval { symlink('/etc/apache2','/srv/www/conf'); }, $@ eq '');
    if ($can_symlink) {
        &print_and_log(&mt('Symlink created for [_1] to [_2].',
                       "'/srv/www/conf'","'/etc/apache2'")."\n");
    } else {
        &print_and_log(&mt('Symlink creation failed for [_1] to [_2]. You will need to perform this action from the command line.',"'/srv/www/conf'","'/etc/apache2'")."\n");
    }
    &copy_apache2_conf_files($instdir);
    &copy_sysconfig_apache2_file($instdir); 
    print_and_log("\n");
}

###############################################
##
## Modify uid.conf
##
###############################################
sub copy_apache2_conf_files {
    my ($instdir) = @_;
    print_and_log(&mt('Copying the LON-CAPA [_1] to [_2].',
                  "'uid.conf'","'/etc/apache2/uid.conf'")."\n");
    if (!-e "/etc/apache2/uid.conf.original") {
        copy "/etc/apache2/uid.conf","/etc/apache2/uid.conf.original";
    }
    copy "$instdir/uid.conf","/etc/apache2/uid.conf";
    chmod 0444,"/etc/apache2/uid.conf";
}

###############################################
##
## Modify /etc/sysconfig/apache2  
##
###############################################
sub copy_sysconfig_apache2_file {
    my ($instdir) = @_;
    print_and_log(&mt('Copying the LON-CAPA [_1] to [_2].',"'sysconfig/apache2'","'/etc/sysconfig/apache2'")."\n");
    if (!-e "/etc/sysconfig/apache2.original") {
        copy "/etc/sysconfig/apache2","/etc/sysconfig/apache2.original";
    }
    copy "$instdir/sysconfig_apache2","/etc/sysconfig/apache2";
    chmod 0444,"/etc/sysconfig/apache2";
}

###############################################
##
## Add/Modify /etc/insserv/overrides
##
###############################################

sub update_SuSEfirewall2_setup {
    my ($instdir) = @_;
    print_and_log(&mt('Copying the LON-CAPA [_1] to [_2].',"'SuSEfirewall2_setup'","'/etc/insserv/overrides/SuSEfirewall2_setup'")."\n");
    if (!-e "/etc/insserv/overrides/SuSEfirewall2_setup") {
        if (!-d "/etc/insserv") {
            mkdir("/etc/insserv",0755); 
        }
        if (!-d "/etc/insserv/overrides") {
            mkdir("/etc/insserv/overrides",0755);
        }
    } elsif (!-e  "/etc/insserv/overrides/SuSEfirewall2_setup.original") {
        copy "/etc/insserv/overrides/SuSEfirewall2_setup","/etc/insserv/overrides/SuSEfirewall2_setup.original"
    }
    copy "$instdir/SuSEfirewall2_setup","/etc/insserv/overrides/SuSEfirewall2_setup";
    chmod 0444,"/etc/insserv/overrides/SuSEfirewall2_setup";
}

sub download_loncapa {
    my ($instdir,$lctarball) = @_;
    my ($have_tarball,$updateshown);
    if (! -e "$instdir/$lctarball") {
	print_and_log(&mt('Retrieving LON-CAPA source files from: [_1]',
		      'http://install.loncapa.org')."\n");
	system("wget http://install.loncapa.org/versions/$lctarball ".
	       "2>/dev/null 1>/dev/null");
	if (! -e "./$lctarball") {
	    print &mt('Unable to retrieve LON-CAPA source files from: [_1].', 
		     "http://install.loncapa.org/versions/$lctarball")."\n";
	} else {
            $have_tarball = 1;
        }
	print_and_log("\n");
    } else {
        $have_tarball = 1;
	print_and_log("
------------------------------------------------------------------------

".&mt('You seem to have a version of loncapa-current.tar.gz in [_1]',$instdir)."\n".
&mt('This copy will be used and a new version will NOT be downloaded.')."\n".
&mt('If you wish, you may download a new version by executing:')."

wget http://install.loncapa.org/versions/loncapa-fedora-current.tar.gz

------------------------------------------------------------------------
");
    }

    ##
    ## untar loncapa.tar.gz
    ##
    if ($have_tarball) {
        print_and_log(&mt('Extracting LON-CAPA source files')."\n");
        writelog(`cd ~root; tar zxf $instdir/$lctarball`);
        print_and_log("\n");
        print &mt('LON-CAPA source files extracted.')."\n".
              &mt('It remains for you to execute the following commands:')."

cd /root/loncapa-N.N     (N.N should correspond to a version number like '0.4')
/UPDATE

".&mt('If you have any trouble, please see [_1] and [_2]',
      'http://install.loncapa.org/','http://help.loncapa.org/')."\n";
        $updateshown = 1;
    }
    return ($have_tarball,$updateshown);
}

close LOG;

--raeburn1300466532--