Install dependencies

apt-get install apache2-mpm-prefork
apt-get install libapache2-mod-perl2
apt-get install perlmagick imagemagick

Don't bother with installation of perl modules from packages. Debian has modules which are sometimes a bit too old for cutting-edge WebGUI, so just let CPAN install it for you.

Basic configuration

All operations on both hosts (mjesec, zemlja) are done as root user. This is not strictly necessery (especially for WebGUI tasks), but it's easier in combination with MySQL setup. We want to get running quickly, YMMV.

Cleanup target machine

If this is not first installation attempt, you might want to cleanup target machine first.

# root@mjesec
cd /data/WebGUI
grep dsn etc/*.conf | cut -d: -f4- \
  | xargs -i echo 'drop database {};' \
  | ssh zemlja 'cat > /data/drop_all_dbs.sql'

Now switch to target machine and finish cleanup:

# root@zemlja
cd /data
xargs -i mysql -e '{}' < /data/drop_all_dbs.sql
rm -Rf WebGUI

Copy existing installation

In this step, we will copy existing WebGUI 6.2.11 installation to new (virtual) host (zemlja) to test upgrade.

Copy MySQL databases

# root@mjesec
cd /data/WebGUI 
grep dsn etc/*.conf | cut -d: -f4- \
  | xargs mysqldump --databases \
  | ssh zemlja mysql mysql

Copy existing WebGUI installation

# root@mjesec
cd /data
tar cfp - WebGUI/ | ssh zemlja 'cd /data && tar xvfp -'

This is much faster than scp in my expirience...

Finish database setup

Now, on zemlja, let's grant webgui user access to those databases:

# root@zemlja
cd /data/WebGUI
mysql -e 'create user webgui'
grep dsn etc/*.conf | cut -d: -f4- \
  | xargs -i mysql -e "grant all privileges on {}.* to webgui@localhost identified by 'password';" 
mysql -e "flush privileges"

Upgrade steps

First, test current enviroment for any mis-configuration:

# root@zemlja
cd /data/WebGUI/sbin
perl testEnvironment.pl

If there are missing perl libraries, install them. Some will have to be forced, but all-in-all it goes well.

And run upgrade...

# root@zemlja
cd /data/WebGUI/sbin
perl upgrade.pl --doit

Now, extract new version of webgui on which you want to upgrade (I'm assume that you downloaded required versions in /data):

cd /data/
ls
tar xvfz webgui-6.6.0-beta.tar.gz 
cd /data/WebGUI/sbin/
perl testEnvironment.pl 
perl upgrade.pl --doit

This will take a while.

After that you might want to remove backup of databases:

rm /tmp/backups/*

Tweaks

Here are some commands to help you with various changes which break WebGUI:

# root@zemlja
cd /data/WebGUI
rm lib/HTML/Template.pm
cp etc/log.conf.original etc/log.conf

JSON config format (6.99.0 and above)

You might have problems upgrading to version 6.99.0 or later because scripts expect configuration in JSON format, and upgrade won't convert files for you (because it created config files from tar). So, change your upgrade.pl beginning to something like this:

## Find site configs.

print "\nTesting site config versions...\n" unless ($quiet);
opendir(DIR,"../etc");
my @files = readdir(DIR);
closedir(DIR);
foreach my $file (@files) {
        next unless ($file =~ m/\.conf$/);
#       next if ($file eq "spectre.conf" || $file eq "log.conf");
        my $configFile = "../etc/".$file;
        open(FILE,"<".$configFile);
        my $line = <FILE>;
        close(FILE);
        unless ($line =~ m/JSON 1/) {
                print "\tConverting ".$file." from PlainConfig to JSON\n" unless ($quiet);
                convertPlainconfigToJson($configFile);
        }
}

exit;

Note commented out line and added exit.

Now you can run upgrade.pl once to convert configuration files to JSON, then run testEnvironment.pl and finally run upgrade.pl once more to do actual update.

log4perl problem this will also convert log.conf so restore it:

# root@zemlja
cd /data/WebGUI/etc/
cp log.conf.original log.conf

Hint

For testing, I created *.zemlja.example.com DNS entry, so that all sites become old.site.name.zemlja.example.com.