WebGUI FAQ

wg-fomATgwyDOTorg

 2) There *is* no index.pl in 6.8.x+

    a. wget (or another tool you like to download WebGUI)

    b. mysql41-server

    c. mysql41-client

    d. ImageMagick

    e. transfig

    f. apache2

    g. perl

    h. pine (optional, I don�t like the way vi works on FreeBSD so I like to 
       use pico)

    a. Run "/usr/local/sbin/mysql_install_db"

    i. The binary installation does not create the system databases for you. 
       It gives you a config to dump the database under /var/db/mysql.

    b. Run "chown �R mysql /var/db/mysql"

    i. This sets the correct permissions on all the files that 
       mysql_install_db just crated. This allows the mysql user to actually 
       access the database that you as root just installed.

    c. Try to run the mysql server and see if it works.

    i. Run "/usr/local/bin/mysqld_safe &"

    ii. Run "mysql"

    a. You really should set a password at this point for the root user on 
       mysql. You can do this at the mysql prompt by issuing the command �set 
       password = password("<newpassword>");� Ignore the single quotes and 
       replace <newpassword> with the password of your choice.

    is based on 6.7.3, keep that in mind.

    a. Extract the file�

        i. gzip �d <thefileyoudownloaded>

        ii. tar �xf <thefileyoudownloaded>

    b. Now if you look inside WebGUI/sbin/ you will find the 
       testEnvironment.pl perl script. If you open it you will find all of the 
       non-WebGUI Perl modules that are required.

    c. As of 6.7.3, the following list shows the required modules. 

       If an arrow appears beside them, then that is the equivalent package 
       that needs to be installed either by the sysinstall utility or the 
       pkg_add �r <packagename> command. Some of the listed packages might be 
       dependent on another one on the list. I�m not going to worry about my 
       list being redundant, better redundant than missing a package and not 
       knowing what happened.

       Modules that do not show a FreeBSD package name beside them are taken 
       care of from CPAN. The instructions for those follow this step.

            i. LWP -->p5-libwww

            ii. HTTP::Request -->p5-libwww

            iii. HTTP::Headers

            iv. Digest::MD5 -->p5-Digest-MD5

            v. DBI -->p5-DBI

            vi. DBD::mysql -->p5-DBD-mysql41 (assuming you use server 4.1)

            vii. HTML::Parser -->p5-HTML-Parser

            viii. Archive::Tar -->p5-Archive-Tar

            ix. IO::Zlib -->p5-IO-Zlib

            x. Compress::Zlib -->p5-Compress-Zlib

            xi. Net::SMTP -->p5-Net-SMTP-Server

            xii. Tie::IxHash -->p5-Tie-IxHash

            xiii. Tie::CPHash

            xiv. XML::Simple -->p5-XML-Simple

            xv. SOAP::Lite -->p5-SOAP-Lite

            xvi. Time::HiRes -->p5-Time-HiRes

            xvii. Log::Log4perl -->p5-Log-Log4perl

            xviii. Net::LDAP -->p5-ResourcePool-Resource-Net-LDAP

            xix. Date::Manip -->p5-Date-Manip

            xx. HTML::Highlight

            xxi. HTML::TagFilter

            xxii. HTML::Template -->p5-HTML-Template

            xxiii. Parse::PlainConfig

            xxiv. XML::RSSLite

            xxv. DBIx::FullTextSearch
                1. If you installed mysql41-server from the binary and already 
                   set up your system tables as described above, then this 
                   dependency will be 
                   met. It may rely on some of the packages listed above as 
                   well, but either way, after installing your server properly 
                   this test will pass.

        d. After you install all of the above modules you will need to do the 
           following�

            i. IMPORTANT --- Please not that at any time if you are asked if 
               you want to install a prerequisite module, do it. Otherwise you 
               will run into problems because the modules won�t install.

            ii. Run "perl �MCPAN �e shell"
                1. If this is your first time running the shell read the 
                   following, otherwise move on to ii.

                    a. Accept the defaults, the only one I changed is the line 
                       where they make the suggestion that some people 
                       add "UNINST=1". I followed that recommendation as it is 
                       supposed to remove conflicting files. Continue on with 
                       the defaults and you should be fine until it gets you 
                       to the prompt. Now you�re ready for step ii.

           iii. You now need to install some modules at this shell. Assuming 
                all is going well, you can just install them without problem 
                by running the command, "install <ModuleName>" without the 
                quotes and replacing �<ModuleName>� with the perl module�s 
                name. Install the following modules by this method using the 
                following names�

               1. Tie::CPHash

               2. HTML::Highlight

               3. HTML::TagFilter

               4. Parse::PlainConfig

               5. XML::RSSLite

            iv. Exit the shell by typing, "exit." (no period after exit)

        e. Special Cases

            i. ModPerl v. 2
               1. I tried using the mod-perl2 package that FreeBSD supplies as 
                  a binary, but it didn�t work, even after changing some of 
                  the referenced names in WebGUI�s preload.perl script. I 
                  instead installed this from source. This is why I did not 
                  list it above as one of the FreeBSD packages to install.

               2. It needs to be noted that if you want to run the tests on 
                  your mod_perl to ensure that it everything works correctly, 
                  you need to compile it as a non-root user to run the tests. 
                  If you are daring and want to quickly install it follow 
                  instructions under �b� below, otherwise follow the 
                  instructions under �a.�

                  a. You can easily get the source by going into a cpan shell 
                     as described above by running, "perl �MCPAN �e shell" and 
                     at that shell type, "get mod-perl2" to retrieve the 
                     source. Exit the shell.

                      i. cd to /root/.cpan/build/ directory.

                      ii. Issue an �ls� to find the source directory for 
                          ModPerl.

                      iii. cd to that directory.

                      iv. Run "perl Makefile.pl MP_APXS=/usr/local/sbin/apxs"
                          1. The path in the command above is where FreeBSD�s 
                             binary install of Apache 2 puts this file. It 
                             might be different for you if you didn�t use the 
                             binary install, quite possibly 
                             at /usr/local/apache2/bin/apxs.

                      v. Run "make"

                      vi. Run "make test"

                      vii. If all tests pass run "make install"

                      viii. Exit the shell.

                b. Enter a cpan shell by "perl �MCPAN �e shell"

                    i. Run "install mod_perl2"

                    ii. When it asks you if you want to skip the tests, type 
                        yes. It will prompt twice.

                    iii. Exit the shell after you have finished.

              ii. Image::Magick (aka PerlMagick)

                   1. The binary install of ImageMagick from FreeBSD is fine, 
                      however it seems to be a source of grief. Every time I 
                      start apache, it bombs out with a core dump when 
                      Image::Magick is preloaded. The Image::Magick module is 
                      installed as part of the binary installation of the 
                      ImageMagick package from FreeBSD. Using their package, 
                      Apache core dumps and dies completely. I kept my binary 
                      install, but went ahead and did a manual install of 
                      the Image::Magick module from CPAN. The instructions 
                      follow�

                           a. Enter a cpan shell (see 4.e.i.2.b. for 
                              instructions).

                           b. Run "get Image::Magick"

                           c. Go to the cpan build directory (see 4.e.i.2.a.i.)

                           d. Run "perl Makefile.pl"

                           e. Run "make"

                           f. Run "make test"

                           g. For me it seems to fail on one of the X tests, 
                              but considering I�m not worried about this 
                              functionality, I�m ignoring it and am going to 
                              install it anyway.

                           h. Run "make install"

                            i. You�re done with the install of ImageMagick.

                            j. For reference, it is interesting to note that I 
                               have been able to compile every piece of 
                               software for WebGUI on FreeBSD and install it 
                               and the only thing that causes Apache not to 
                               work is the Image::Magick perl module. If I 
                               remove all references to Image::Magick in 
                               WebGUI, the server starts fine, although you 
                               miss out on the images in WebGUI.

           iii. Bundle::Apache2

               1. Perhaps some of these packages are in the FreeBSD packages 
                  distribution, but I didn�t know which ones they would be and 
                  I needed to be sure that I had the ones for Apache 2.

              2. Install these using the cpan shell. I didn�t have any 
                 problems with them so a standard, "install Bundle::Apache2" 
                 should work.

                  f. You should now have the basic requirements installed for 
                     WebGUI.

                  i. Enter the WebGUI folder you extracted earlier and go to 
                     the sbin subdirectory.

                  ii. Run "perl testEnvironment.pl" If everything passes and 
                      it doesn�t ask you to install anything more, great. 
                      You�re ready to move on. Else, review the instructions 
                      above and check where things went wrong.

   to follow Plain Black�s instructions to continue your install. Using WebGUI 
   6.7.3 you should not have to worry about the perl modules that they tell 
   you to install at the beginning. They will already have been installed by 
   these instructions, either explicitly or they were installed as a 
   dependency of another module. At the time of this writing, the instructions 
   were located at http://www.plainblack.com/installing_webgui . I�m not going 
   to include those instructions here because they are part of the WebGUI site 
   and I don�t want to steal the instructions from there to include them here.

   important to Apache if you are using an internal machine with a dummy name. 
   Apache will die if you don�t have it�s name in the host file.

   start your server with a core dump. Hopefully if nothing changes, Apache 
   will still be running and this won�t be anything more than a minor 
   irritation. However, if you installed Apache with the FreeBSD binary, you 
   need to check your httpd.conf file under /usr/local/etc/apache2/httpd.conf. 
   You need to do this because you will notice that you cannot view your 
   WebGUI site because of security restrictions.

    a. If this is your production system, ignore the following. You need to 
       know Apache and how to use its security system. DO NOT follow the 
       instructions below because it is a security risk and I�m not 
       responsible for stupid actions that other people do on their own 
       servers. You have been warned.
    b. Re-read �a.� above, then you may read �c.� below.

    c. For a simple system that you want to do some testing and playing around 
       with WebGUI on, you can find the main section for the <Directory /> 
       directive for Apache. You need to specifically find the one that opens 
       with "<Directory />" and closes with "</Directory>" because it�s an 
       easy way to quickly remove the security and be able to use your WebGUI 
       installation.

    d. Change the line that says "Order Deny,Allow" to "Order Allow,Deny"

    e. Change the line after that that says "Deny from all" to "Allow from all"

    f. Remember that section �a.� is important. This is not a safe way to 
       setup your web server.

    g. You can now restart apache.

   startup. You will need to edit /etc/rc.conf to do this. At the end of the 
   file append one line for each server, for Apache, enter
   � "apache2_enable="YES" � to enable it on startup. For MySQL, enter 
   � mysql_enable="YES" � to enable it. Ignore the single-quotes, but the 
   double quotes are needed.

 Alias /extras /path/to/extras
 <Directory /path/to/extras>
    Options ExecCGI FollowSymLinks
    AllowOverride None
    Order Allow,Deny
    Allow from all
 </Directory>
From Alafondo:
Full setup of Ubuntu 6.06 LTS "Dapper Drake" for WebGUI 7.0.6

At first - excuse my bad english 

Download the ubuntu 6.06 LTS Dapper Drake

http://ubuntu.intergenia.de/releases/6.06/ubuntu-6.06.1-server-i386.iso

burn the cd and install it with all defaults.

Here and everywhere we will use the next logins and passwords(replace them with Yours for security reasons):

------------------- Prologue -----------------
first ubuntu user:
login: firstuser
password: userone

root user:
password: userroot

apache homedir = /apachehome

mysql homedir = /usr/local/mysql

if You will see ">" at the begining of the line - then it is a command
-----------------end of prologue --------------

/* after installation login */
login: firstuser
password: userone

/* now we will create root user */
> sudo passwd root

/* You will be asked for enter password: userone to become root, and create root account */
password: userone

/* then enter password for root */
root user password: userroot
confirm: userroot

/*login as root */
exit
login: root
password: userrrot

/*create directory for downloads (u can create it with another name) */
> cd /
> mkdir distribs
> cd /distribs

/* now lets download all distribs we need */
> wget http://www.cpan.org/modules/by-module/Crypt/Crypt-SSLeay-0.51.tar.gz
> wget http://www.cpan.org/modules/by-module/DBD/DBD-mysql-3.0006.tar.gz
> wget http://mysql.directnet.ru/Downloads/MySQL-5.0/mysql-5.0.24.tar.gz
> wget ftp://ftp.chg.ru/packages/ImageMagick/ImageMagick-6.2.9-3.tar.gz
> wget http://www.openssl.org/source/openssl-0.9.7k.tar.gz
> wget http://www.cpan.org/src/stable.tar.gz
> wget http://archive.apache.org/dist/httpd/httpd-2.0.52.tar.gz
> wget http://apache.rediska.ru/httpd/libapreq/libapreq2-2.08.tar.gz
> wget http://perl.apache.org/dist/mod_perl-2.0-current.tar.gz

/* now we will install all compilers and packages for compiling */
> aptitude update
> aptitude upgrade
> aptitude install make autoconf
> aptitude install automake1.9
> aptitude remove automake1.4

/*just check that u have only one automake or select the 1.9 for default */
> update-alternatives --config automake

> aptitude install gcc libtool g++ expat libexpat1 libexpat1-dev libpng3 libpng3-dev libtiff4 libtiff4-dev libtiffxx0c2 libxml-dev libxml1 libjpeg62 libjpeg62-dev libfreetype6 libfreetype6-dev libncurses5 libncurses5-dev zlib1g zlib1g-dev

/* now we will install perl */
/* check that u are in the distribs directory */
> cd /distribs
> tar -zxvf stable.tar.gz
> cd ./perl*
> rm -f config.sh Policy.sh
> sh Configure
/*everywhere type enter and config Your e-mails. We don't need threads enabled */
> make
> make test
> make install
/* now we will remove old perl package with all its subpackages */
> aptitude remove perl

/* reinstall make autoconf and automake there will be perl also don't worry choose YES */
> aptitude install make autoconf
> aptitude install automake1.9
> aptitude remove automake1.4

/*just check that u have only one automake or select the 1.9 for default */
> update-alternatives --config automake

/* here I prefer to reboot */
> shutdown -r now

/* login as root */
login: root
password: userrrot
/* check the perl version. it should be 5.8.8 */
> perl -v

/* now we will reinstall packages due to new perl */
> aptitude install gcc libtool g++ expat libexpat1 libexpat1-dev libpng3 libpng3-dev libtiff4 libtiff4-dev libtiffxx0c2 libxml-dev libxml1 libjpeg62 libjpeg62-dev libfreetype6 libfreetype6-dev libncurses5 libncurses5-dev zlib1g zlib1g-dev

/* reboot */
> shutdown -r now

/* login as root*/

/* now we will install openssl, Image magick, apache and mysql then reboot the system */

/* openssl */
> cd /distribs
> tar -zxvf openssl*.tar.gz
> cd ./openssl*
> ./configure
* then run make and install /
> make
/* the next install it into /usr/local/ssl */
> make install

/* ImageMagick */
> cd /distribs
> tar -zxvf ImageM*.tar.gz
> cd ./Image*
> ./configure \
> --with-modules=yes \
> --with-jpeg=yes \
> --with-png=yes \
> --with-tiff=yes \
> --with-quantum-depth=32
/* then run meke and install /
> make
> make install

/* check the ImageMagick version */
> convert -Version

/* MySQL */
> cd /distribs
> tar -zxvf mysql*.tar.gz
> cd ./mysql*

/* before compiling we will create user and group for it */
> groupadd mysql
> useradd -g mysql mysql

/* configure and compile */
> ./configure --prefix=/usr/local/mysql
> make
/* the next will install mysql in - /usr/local/mysql , data in /usr/local/mysql/data */
> make install

/* create *.cnf file */
cp support-files/my-medium.cnf /etc/my.cnf

/*create necessary tables */
> /usr/local/mysql/mysql_install_db --user=mysql

/* change owners */
> chown -R root /usr/local/mysql
> chown -R mysql /usr/local/mysql/var
> chgrp -R mysql /usr/local/mysql

/* autostart mysql on boot */
> cp support-files/mysql.server /etc/init.d/mysql
> chmod +x /etc/init.d/mysql
> update-rc.d mysql defaults

/* check mysql */
> /etc/init.d/mysql start
> netstat -tap

/* add mysql dir to path */ 

> vi /etc/environment

> i 

 add /usr/local/mysql/bin

> Esc 

> ZZ

/* apache */
/* we will install it into the apachehome direcoty (change it for Your needs) */

> cd /distribs
> tar -zxvf httpd*.tar.gz
> cd ./httpd*
> ./configure \
> --prefix=/apachehome \
> --enable-rewrite=shared \
> --enable-deflate=shared \
> --enable-proxy=shared \
> --enable-proxy-ftp=shared \
> --enable-proxy-http=shared \
> --enable-proxy-connect=shared \
> make
> make install

/* autostart apache on boot */
> cp /apachehome/bin/apachectl /etc/
> chmod +x /etc/init.d/apachectl
> update-rc.d apachectl defaults

/* check it*/
/* check apache */
> /etc/init.d/apachectl start
> netstat -tap

/* now reboot the system */
> shutdown -r now

/* login as root */

> perl -MCPAN -e shell

/* here will go perl modules install by CPAN */
> install Bundle::CPAN
/* configure it */
> q

> perl -MCPAN -e shell
/* reconfig it again */
> q

> perl -MCPAN -e shell
/* lets go */
> install Cwd
> install Data::Dumper
> install ExtUtils::CBuilder
> install ExtUtils::MakeMaker
> install ExtUtils::XSBuilder
> install ExtUtils::Install
> install ExtUtils::ParseXS
> install ExtUtils::Install
> install ExtUtils::Manifest
> install ExtUtils::Mkbootstrap
> install File::Basename
> install File::Compare
> install File::Copy
> install File::Find
> install File::Path
> install File::Spec
> install Getopt::Long
> install IO::File
> install Test::Harness
> install Text::Abbrev
> install Text::ParseWords
> install Archive::Tar
> install Archive::Zip
> install Module::Signature
> install Pod::Readme
> install Apache::Test
/* you apache path is /apachehome , executable /apachehome/bin/apachectl , apxs = /apachehome/bin/apxs */
> install Test::More

/* in this place I prefer to run force install*/

> force install Module::Build  **this command is optional

> q

/* reboot system */
> shutdown -r now

/* login as root */

> perl -MCPAN -e shell
/* now we will prepare environment for mod_perl */
> install Bundle::Apache2
/* everything should be ok, beside of Crypt::SSLeay (if there would be problems with it then u should install it manually)*/

/* manual install Crypt::SSLeay */
> cd /distribs
> tar -zxvf Crypt-SSLeay-0.51.tar.gz
> cd ./Crypt*
/* in config u would enter the ssl's path = /usr/local/ssl */

> perl Makefile.PL
> make
> make test
> make install

/* again */

> perl -MCPAN -e shell
> install Bundle::Apache2
/* everything should be ok */
> q
> cd /distribs
> tar -zxvf mod_perl*.tar.gz
> cd ./mod_perl*
> perl Makefile.pl MP_APXS=/apachehome/bin/apxs
> make
> make test
> make install
> vi  /apachehome/conf/httpd.conf
/* find LoadModule dirs and add *\
/* to edit press on "i" and edit then press "esc", then to exit hold poop and press ZZ */
> i **edit file**

/* add next line */
LoadModule perl_module modules/mod_perl.so

> Esc
> ZZ **exit file**
> /etc/init.d/apachectl stop
> /etc/init.d/apachectl start
/* open in brouser and enter wrong path to see it indicated */

/* installing libapreq */
> perl -MCPAN -e shell
> install Apache2::Request

/* everything should be OK, if not the unstall it manually */

> cd /dustribs
> tar -zxvf libapreq*.tar.gz
> cd ./libapreq*
> perl Makefile.PL --with-apache2-apxs=/apachehome/bin/apxs
> make
> make test
> make install
> vi  /apachehome/conf/httpd.conf
/* find LoadModule dirs and add *\
/* to edit press on "i" and edit then press "esc", then to exit hold poop and press ZZ */
> i **edit file**

/* add net line */ 

LoadModule apreq_module modules/mod_apreq2.so

> Esc
> ZZ ** exit file**
> /etc/init.d/apachectl stop
> /etc/init.d/apachectl start
/* open in brouser and enter wrong path to see it indicated */

> shutdown -r now
/*login as root */
> perl -MCPAN -e shell
> install LWP
> install Cache::Cache
> install HTML::Parser
> install HTML::Request
> install HTML::Headers
> install Test::More
> install Pod::Coverage
> install Text::Balanced
> install Digest::MD5
> install DBI
> q
> cd /distribs
> tar -zxvf DBD-mysql*.tar.gz
> cd ./DBD-m*
>perl Makefile.PL \
> --libs="-L/usr/local/mysql/lib/mysql -lmysqlclient -lz" \
> --cflags=-I/usr/local/mysql/include/mysql \
> --testhost=127.0.0.1
> make
> make test  /* Some minor error messages can be ignored here */
> make install
> perl -MCPAN -e shell
> install Archive::Tar
> install Archive::Zip
> install IO::Zlib
> install Compress::Zlib
> install Net::SMTP
> install Tie::IxHash
> install Tie::CPHash
> install XML::Sax
> install XML::Parser
> install XML::SAX::Expat
> install XML::NamespaceSupport
> install XML::Simple
> install SOAP::Lite
> install DateTime
> install Time::HiRes
> install DateTime::Format::Strptime
> install DateTime::Cron::Simple
> install Image::Magick
> install Log::Log4perl
> install Net::LDAP
> install HTML::TagFilter
> install HTML::Highlight
> install HTML::Template
> install HTML::Template::Expr
> install Template
> install Parse::PlainConfig
> install XML::RSSLite
> install JSON
> install Finance::Qoute
> install Data::Structure::Util
> install Test::Deep
> install Test::MockObject
> install MIME::Tools
> install POE
> install POE::Component::IKC::Server
> install POE::Component::Client::UserAgent
> install Net::Subnets
> install DateTime::Format::Mail
> install Net::POP3
> install List::Util
> install Color::Calc
> install POE::Component::Client::HTTP
> install Cache::Memcached
> q

/* download and install WebGUI */

> cd /
> pwd /* u should see "/" */
> mkdir data
> cd /distribs
> wget http://update.webgui.org/7.x.x/webgui-7.0.6-stable.tar.gz
> tar -zxvf webgui*.tar.gz
> cp ./WebGUI /data/WebGUI
/* run "testEnvironment.pl" to detect and install missed perl modules (I'm a human and could mess some modules) */

/* now we will setup network for SPECTRE */
> vi /etc/hosts
/* just add youir hosts */
<!--- begin hosts file before -->
127.0.0.1    localhost
127.0.1.1    yuordomain.somewords    yuordomain

# The following lines are desirable for IPv6 capable hosts
::1     ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
**add here Your hosts***
<!-- hosts file end ------>

/* u shouldn't remove or modify any words, just add next */
/* u should add  your domains */

<!-- begin  hosts file after ---->
127.0.0.1    localhost
127.0.1.1    yuordomain.somewords    yuordomain

# The following lines are desirable for IPv6 capable hosts
::1     ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
127.0.0.1    www.mysite1.com
127.0.0.1    mysite1.com
127.0.0.1    www.mysite2.com
127.0.0.1    mysite2.com
127.0.0.1    www.mysite3.com
127.0.0.1    mysite3.com
127.0.0.1    www.mysite4.com
127.0.0.1    mysite4.com

<!-- end hosts file -->

> shutdown -r now

CONGRATULATIONS
See the PlainBlack's tutorial for installing WebGUI

Now You should setup Your mysql and firewall to make it secure
if You want to remove the root acount (I recommnend to this after WebGUI installation )
/* login as first user */
> login: firstuser
> password: userone
> sudo passwd -l root
> exit

To setup mail-server use this link (the postfix setup - page5)

<!----- here the full list of perl modules by testEnvironment.pl ------------>

/* run "testEnvironment.pl" to detect and install missed perl modules (I'm a human and could mess some modules) */

Checking for module LWP:                     OK
Checking for module HTTP::Request:           OK
Checking for module HTTP::Headers:           OK
Checking for module Test::More:              OK
Checking for module Test::MockObject:        OK
Checking for module Test::Deep:              OK
Checking for module Pod::Coverage:           OK
Checking for module Text::Balanced:          OK
Checking for module Digest::MD5:             OK
Checking for module DBI:                     OK
Checking for module DBD::mysql:              OK
Checking for module HTML::Parser:            OK
Checking for module Archive::Tar:            OK
Checking for module Archive::Zip:            OK
Checking for module IO::Zlib:                OK
Checking for module Compress::Zlib:          OK
Checking for module Net::SMTP:               OK
Checking for module MIME::Tools:             OK
Checking for module Net::POP3:               OK
Checking for module Tie::IxHash:             OK
Checking for module Tie::CPHash:             OK
Checking for module XML::Simple:             OK
Checking for module SOAP::Lite:              OK
Checking for module DateTime:                OK
Checking for module Time::HiRes:             OK
Checking for module DateTime::Format::Strptime: OK
Checking for module DateTime::Cron::Simple:  OK
Checking for module DateTime::Format::Mail:  OK
Checking for module Image::Magick:           OK
Checking for module Log::Log4perl:           OK
Checking for module Net::LDAP:               OK
Checking for module HTML::Highlight:         OK
Checking for module HTML::TagFilter:         OK
Checking for module HTML::Template:          OK
Checking for module HTML::Template::Expr:    OK
Checking for module Template:                OK
Checking for module Parse::PlainConfig:      OK
Checking for module XML::RSSLite:            OK
Checking for module JSON:                    OK
Checking for module Net::Subnets:            OK
Checking for module Finance::Quote:          OK
Checking for module POE:                     OK
Checking for module POE::Component::IKC::Server: OK
Checking for module POE::Component::Client::HTTP: OK
Checking for module Data::Structure::Util:   OK
Checking for module Apache2::Request:        OK
Checking for module Cache::Memcached:        OK
Checking for module URI::Escape:             OK
Checking for module POSIX:                   OK
Checking for module List::Util:              OK
Checking for module Color::Calc:             OK

 perl preload.perl

 Starting WebGUI (version)
   webgui.conf
   anothersite.conf (optional)
 WebGUI started Successfully!
  http://perl.apache.org/dist/mod_perl-2.0-current/Changes
          http:\\\index.pl\mylink.

 sub makeCompliant
 {
   my ($value);
   $value = $_[0];
         $value =~ s/\s+$//;        #removes trailing whitespace
         $value =~ s/       #removes leading hitespace
         $value =~ s/         #removes leading slash
         $value =~ s/ /_/g;  #replaces whitespace with underscores
         $value =~ s/\.$//;          #removes trailing period
         $value =~ s/[  #removes all funky characters
         $value =~ s/   #removes a preceeding /
         $value =~ s/\/\//\//g;    #removes double /
         return $value;
 }

 1 - don't leave spaces behind lines in the config file
 2 - improve the stripping out of whitespaces. I presume the sub responsible is makeCompliant in url.pm. I am not sure how to change it as it seems that the sub is already doing this.
 'where pageId='.quote(pageId) 
 "FATAL: Authentication module failed to compile: WebGUI::Auth::WebGUI.Can't locate WebGUI/Auth/WebGUI.pm in @INC"

 "WARNING: Wobject failed to compile: WebGUI::Wobject::USS.Can't locate WebGUI/Wobject/USS.pm in @INC"

 PerlSwitches -I/data/WebGUI/lib

 use Storable;

 use Storable qw(nstore retrieve);

 store $hashref, $self->getPath;

 bless $hashref;
 nstore $hashref, $self->getPath;

 perl -e "use Image::Magick;"
 FATAL - WebGUI.conf - WebGUI::Operation::Auth::getInstance[47] - Couldn't instantiate authentication module: WebGUI. Root cause: Can't locate object method "new" via package "WebGUI::Auth::WebGUI" at /data/WebGUI/lib/WebGUI/Operation/Auth.pm line 46.
 ERROR - WebGUI.ErrorHandler - WebGUI::Operation::execute[63] - Couldn't execute operation : WebGUI::Operation::Auth::www_auth. Root cause: ModPerl::Util::exit: (120000) exit was called at /data/WebGUI/lib/WebGUI/ErrorHandler.pm line 197
 Couldn't call method view on asset for url:  Root cause: Can't locate object method "get" via package "WebGUI::Storage::Image" at /data/WebGUI/lib/WebGUI/Asset/Wobject/Article.pm line 178.
 my $ua = LWP::UserAgent->new(timeout => 5);
 $ua->proxy(['http', 'ftp'], 'http://proxy:port');
 $ua->env_proxy;

 $useragent->env_proxy;
 http_proxy="http://proxy:port"
 ftp_proxy="ftp://proxy:port"
 no_proxy="localhost,my.domain"

 ^GroupText("mygroup","<a href="/some/path">Hello, ^@;. This Link if I'm in mygroup. </a>");

 ^GroupText("mygroup","<a href='/some/path'>Hello, ^@;. This Link if I'm in mygroup. </a>");
 <Location /mailman>
    SetHandler None
 </Location>

 <Location /ServAdmin>
    SetHandler None
 </Location> 

 A style template
 A page template
 Content.

 <head>
 <title><tmpl_var session.page.title> - <tmpl_var session.setting.companyName></title>
 <tmpl_var head.tags>
 </head>

 ^PageTitle;
 ^AdminBar(2);
 ^Navigation(type or name);
 ^L(17,"User:<a href=^/;?op=displayAccount>^@;</a>. %Logout%");
 <tmpl_var body.content>

 coolmenu.menuPlacement="center" 
 select page.title, page.urlizedTitle, USS_submission.dateSubmitted,
 USS_submission.title, USS_submission.username, USS_submission.userId,
 USS_submission.USS_submissionId, USS_submission.status, 
 left(USS_submission.content,100), USS_submission.image from USS_submission 
 left join USS on USS_submission.USS_Id=USS.USS_Id left join wobject on
 USS.wobjectId=wobject.wobjectId left join page on page.pageId=USS_submission.pageId 
 where USS_submission.status='approved' order by USS_submission.dateSubmitted desc limit 7
 select page.title, page.urlizedTitle, USS_submission.dateSubmitted, 
 USS_submission.title, USS_submission.username, USS_submission.userId, 
 USS_submission.USS_submissionId, USS_submission.status, 
 left(USS_submission.content,100), USS_submission.image from USS_submission
 left join USS on USS_submission.USS_Id=USS.USS_Id left join wobject on
 USS.wobjectId=wobject.wobjectId left join page on wobject.pageId=page.pageId
 where USS_submission.status='approved' order by USS_submission.dateSubmitted
 desc limit 7

 <tmpl_if displayTitle>
   <h1><tmpl_var title></h1>
 </tmpl_if>

 <tmpl_if description>
    <tmpl_var description><p />
 </tmpl_if>

 <tmpl_if debugMode>
        <ul>
        <tmpl_loop debug_loop>
                <li><tmpl_var debug.output></li>
        </tmpl_loop>
        </ul>
 </tmpl_if>

 <table width="100%">
 <tmpl_loop rows_loop>
        <tr><td>
                <a href="^/;<tmpl_var row.field.urlizedTitle.value>"><tmpl_var row.field.title.value></a> ^D(%M/%D/%Y,<tmpl_var row.field.dateSubmitted.value>);<br />
 <tmpl_var row.field.left(USS_submission.content,100).value><br />
        </td></tr>
 </tmpl_loop>
 </table>

 <tmpl_if pagination.pageCount.isMultiple>
  <div class="pagination">
    <tmpl_var pagination.previousPage>   <tmpl_var pagination.pageList.upTo20>  <tmpl_var pagination.nextPage>
  </div>
 </tmpl_if>
 ^L(17,"User:^a(^@;);. %Logout%");
             ^^^^^^^^ doesn't work when %% tags exist
 ^L(17,"User:<a href=^\;?op=displayAccount>^@;</a>. %Logout%");
   1. the variable must exist (=> is there a key in the hash-reference of 
      variables with this name?) and be defined (so it may not be assigned undef);
   2. the value of the variable must not be empty (e.g. may not be a string 
      with no content);
   3. the value of the variable may not be zero (as in the integer 0);
 <script type="text/javascript" language="JavaScript">
        <!-- 
        function GoThere(fe){
                var opt_key = fe.selectedIndex;
                var url_val = fe.options[opt_key].value;
                window.open(url_val,'_top');
                return true;
        }
        //-->
 </script>

 <form name="form" method="post" action="">

 <select onChange="GoThere(this);">

 <option value="0">-- Choose One --</option>

 ^SQL("select

 page.title,

 page.urlizedTitle,

 USS_submission.title,

 USS_submission.userId,

 USS_submission.USS_submissionId,

 USS_submission.status,

 USS_submission.image, 

 USS.wobjectId
 from USS_submission
 left join USS on USS_submission.USS_Id=USS.USS_Id

 left join wobject on USS.wobjectId=wobject.wobjectId

 left join page on page.pageId=USS_submission.pageId 
 where USS_submission.userId='^FormParam(uid);' and USS.wobjectId=273  and USS_submission.status='approved'

 order by USS_submission.dateSubmitted", <option value='^/1;'>^0;</option> );

 </select>

 </form>
 <tmpl_var form.start> 
 <form action="/path/to/form-url" enctype="multipart/form-data" method="post" >
 <div class="formContents">
 <input type="hidden" name="func" value="process"  />

 FormParam => FormParam, \
 If => If, \
 <script type="text/javascript">
 <!--
 var x= "^User("gender");"

 if ( x =="male") {
 document.write("he ")
 } else {
 document.write("she ")
 }
 -->
 </script>
 <a href="^UrlMacro("assetId");">Click me</a>
 <a href='^UrlMacro("assetId");'>Click me</a>

 SELECT CONCAT(SUBSTRING_INDEX(content, ' ',5) , 
 if(CHAR_LENGTH(content)-CHAR_LENGTH(SUBSTRING_INDEX(content, ' ',5))> 0, 
 '...',' ') COLLATE utf8_general_ci) as str from Post

 SELECT CONCAT(SUBSTRING_INDEX(content, ' ',5) , 
 if(CHAR_LENGTH(content)-CHAR_LENGTH(SUBSTRING_INDEX(content, ' ',5))> 0, 
 '...',' ') COLLATE utf8_general_ci, '</b></u></i></p>' COLLATE utf8_general_ci)
 as str from Post
 <tmpl_if session.var.adminOn><tmpl_var controls><br /></tmpl_if><?xml version="1.0"?>
 <rss version="2.0">
 <channel>
   <title>INSERT TITLE HERE</title>
 <description>GIVE A GOOD DESCRIPTION</description>
 <link>http://YOURDOMAINHERE/^H(linkonly);</link>
  <tmpl_loop page_loop>
    <item>
     <title><tmpl_var page.menuTitle></title>
     <link>http://YOURDOMAINHERE/<tmpl_var page.url></link>
    </item>
  </tmpl_loop>
 </channel>
 </rss>

 <link rel="alternate" type="application/rss+xml"
    title="RSS FEED TITLE GOES HERE" href="/path/to/snippet/url" >
 <SCRIPT type="text/javascript" LANGUAGE="JavaScript"><!--
 function outputMoney(number) {
      number=checkval(number);
     return "$"+outputDollars(Math.floor(number-0) + '') + outputCents(number - 0);
 }

 function checkval(mycheckval) {
    mycheckval=mycheckval.replace(/,/g,"");
        mycheckval=mycheckval.replace(/\$/g,"");
        return (mycheckval);
 }

 function outputDollars(number) {
    if (number.length <= 3)
        return (number == '' ? '0' : number);
    else {
        var mod = number.length%3;
        var output = (mod == 0 ? '' : (number.substring(0,mod)));
        for (i=0 ; i < Math.floor(number.length/3) ; i++) {
            if ((mod ==0) && (i ==0))
                output+= number.substring(mod+3*i,mod+3*i+3);
            else
                output+= ',' + number.substring(mod+3*i,mod+3*i+3);
        }
        return (output);
    }
 } 

 function outputCents(amount) {
    amount = Math.round( ( (amount) - Math.floor(amount) ) *100);
    return (amount < 10 ? '.0' + amount : '.' + amount);
 }

 //--></SCRIPT>

 <input type="text" name="salary" onclick="this.value=checkval(this.value);this.select();" onBlur="this.value=outputMoney(this.value)"> 

 <form onsubmit="salary.value=checkval(salary.value)">
 <a name="<tmpl_var assetId>"></a><tmpl_if session.var.adminOn>
 <p><tmpl_var controls></p>
 </tmpl_if>

 <tmpl_if displayTitle>
      <h1><tmpl_var title></h1>
 </tmpl_if>

 <tmpl_if description>
     <tmpl_var description>
 </tmpl_if>
 <style>
 #thumbContainer{
        text-align: center;
        margin: 10px auto;
 }
 .thumbnail{
        float: left;
        margin: 5px;
        padding: 3px;
        border: 1px solid #e3e3e3;
 }
 </style>

 <tmpl_loop file_loop>
        <div class="thumbnail"><a href="<tmpl_var file.url>"><img src="<tmpl_var thumbnail.url>" border="0" alt="<tmpl_var title>"></a></div>

 </tmpl_loop>
 <div style="clear:both;"></div>
 <stuff snipped by wg-fom@gwy.org> 
 NameVirtualHost 192.168.2.19:100
 <VirtualHost 192.168.2.19:100>
 ServerName rengucha.loc
 ServerAlias www*.rengucha.loc
 Documentroot "C:/www/WebGui/www"
  <Directory "C:/www/WebGUi/www">
  AddHandler perl-script .pl
    PerlHandler Apache::Registry
    PerlSendHeader On
    Options Indexes FollowSymLinks MultiViews ExecCGI 
    AllowOverride None 
    Order allow,deny 
   Allow from all 
  </Directory> 
 </VirtualHost>
 <tmpl_loop page_loop>
 <tmpl_var page.indent>
 <span class="<tmpl_if page.depthis4>CSS_RED_CLASS</tmpl_if>
 <tmpl_if page.depthis5>CSS_GREEN_CLASS</TMPL_IF>
 <tmpl_if page.depthis6>CSS_WHITE_CLASS</tmpl_If>"> 

 <tmpl_if page.isCurrent><img src="an arrow"></tmpl_if><a  
 <tmpl_if page.newWindow>onclick="window.open('<tmpl_var page.url>')" href="#"
 <tmpl_else>href="<tmpl_var page.url>"</tmpl_if>><tmpl_var page.menuTitle></a>
    <br />
    </span>
 </tmpl_loop>
 user_pref("capability.policy.policynames", "allowclipboard");
 user_pref("capability.policy.allowclipboard.sites", "http://demo.plainblack.com http://www.plainblack.com");
 user_pref("capability.policy.allowclipboard.Clipboard.cutcopy", "allAccess");
 user_pref("capability.policy.allowclipboard.Clipboard.paste", "allAccess");
 * http://search.cpan.org/~cwinters/Workflow-0.15/lib/Workflow.pm
 * http://search.cpan.org/~gmccar/VCS-0.14/VCS.pm
 * http://search.cpan.org/~jpeacock/version-0.42/lib/version.pm
 * http://www.mwforum.org/ http://www.mwforum.org/forum/topic_show.pl?tid=2122
 * http://www.selectorweb.com/community_systems.html
 GATEWAY_INTERFACE not Perl error in sbin/preload.perl: 
 $ENV{MOD_PERL} =~ /mod_perl/ or die "MOD_PERL not used!"; 
 - Added a workflow system.
 - Added a workflow scheduler system.
 - Converted the runHourly.pl scripts to run as scheduled workflows.
 - Added version tags menu to admin bar.
 - Added versioning commit comments.
 - Removed autocommit mode in favor of workflow controlled commits.
 - Added a revisions list to the edit screen of assets, so that you can
   quickly edit/view an old revision.
 - Addded a lock menu item to explicitly lock an asset from editing.
 - Run on registration and alert on new user have been converted to a single
   workflow.
 - Added a Photogallery prototype to the default installation.
 - Changed the Group property dbCacheTimeout to be groupCacheTimeout and made
   it cache all the users in a group during that time.
 - Added an option for hosters to limit the number of assets that may be
   created on a WebGUI site.
 - Added a change url function that will allow an editor to change the URL of
   an asset permanently (circumventing normal versioning).
 - Added a wiki-like feature that will automatically bring a user to the
   create a page form if they are in admin mode, and click on a link to
   a page that doesn't exist yet.
 - Help is now capable of using inheritance.
 - Template help can/should now be broken out as seperate fields going
   forward.
 - Many changes for better XHTML compliance.
 - Refactored admin bar to be more dynamic.
 - Removed start/end dates from assets in favor of the workflow system.
 - Readded the purge option to the trash manager.
 - Added an advertising management system.
 - Added a field set grouping mechanism to HTMLForm and TabForm.
 - Added save buttons at the top of all the HTML forms for easier access.
 - Added archive/unarchive options to CS threads.
 - Added a mechanism to send emails to a CS which will accept them as posts.
 - Increased the performance of CS Thread viewing by 500%.
 - Changed the CS post rating mechinism to thumbs up/down to be less
   confusing.
 - Added CS templates to run a request tracker (trouble ticket) style system.
 - Updated TinyMCE rich text editor to version 2.0.5.1.
 - Disabled the rich editor for Safari because it doesn't work correctly.
 - Added install/uninstall functions to the asset and wobject skeletons to
   make custom assets easier to distribute.
 - Added a mechanism for importing and exporting packages. This is useful for
   trading styles and other content between sites.
 - Added a database cache option as an alternative to memcached.
 - Removed page caching system and added individual asset caches, because not
   everything should cache in the same way.
 - Converted WebGUI to use a new object oriented session system. More details
   in migation.txt.
 - Added a sort alphabetically option to the folder asset.
 - Added a User form field type.
 - Added a symbol next to items in the asset manager to indicate if they have children or not.
 - Added more templating options to the Paginator. (thanks to Jukka Raimovaara
   / Axxion Oy)
 - Added the currentPage.rank and currentPage.rankIsN variable to the nav
   template. (thanks to Jukka Raimovaara / Axxion Oy)
 - Added a screenshot feature to the matrix.
 - Added an option to delete Matrix fields.
 - Added a captcha challenge to the contact the maintainer form in the matrix.
 - Added an API for retrieving email from POP3 servers.
 - The rebuildLineage.pl script now finds and fixes orphans, and tries to
   locate circular relationships as well.
 - Added a lot more tests to the test suite.
 - Added a new pluggable templating system. (Thanks to Misja Op de Coul /
   E-Wise)
 - Added "201" http status to various entity creation responses.
 - Replaced the old search engine system with a brand new one, that is more
   powerful, easier to use, and more flexible.
 - Added output chunking as an option for asset www_ methods. The net effect
   of this provides a fairly significant performance increase to what would
   otherwise be slow or complex pages. More details in migration.txt. The
   amount of the increase depends upon the complexity of the page, but now
   complex pages should render almost as fast as simple pages.
 - Removed the JavaScript, RawHeadTags, and StyleSheet macros in favor of
   adding a Head Block parameter to templates. This was needed in order to
   implement content chunking.
 - The SMTP mail backend has been replaced with a new API that's capable of
   sending attachments, HTML messages, and more. This will introduce many new
   options for developers.
 - Replaced the old Message Log system with a new Inbox system that's more
   reliable, and scalable.
 - Added a mail queue system.
 - The group mail screen now allows sending of HTML messages.
 - Added prequery statements to the SQLReport and configurable allowed statements
   to the database link properties. (Martin Kamerbeek / Procolix)
 - Converted config file format from PlainConfig to JSON. The new format is
   more powerful and will use slightly less memory.
 - Strengthened security of Captcha validation.
 - Added Captcha form control type.
 - All IPs used by WebGUI (Settings: debugIp and Group: ipFilter) now accept
   IP addresses in CIDR format.  They also will accept multiple IP addresses
   if they are separated by commas.  Whitespace is ignored.  The upgrade
   script will migrate the data automatically, and hoverHelp documentation
   has been updated to reflect the changes as well.
 - The Rich Editor now has a master reset that allows disabling any individual
   Rich Editor across the entire site without querying the user.
 - Commit options have been removed from the Asset Manager "More" and Wobject
   type icon context menus.
 - The Navigation Asset now allows setting the MIME type of its output so that
   you can generate non-HTML navigations or take advantate of the Google
   SiteMap feature.
 - Add tests that verify the integrity of the WebGUI Database.
 - Added a karma ranking system to CS threads for conducting popularitycontests.
 - The main page for the Help system is now a "Table of Contents" with a
   tabbed view to make scanning for content easier.
 - Help for forms now shows the fields that you should see with your UI level.
   There is a link to show all fields.
 - Added SQL Form and error feedback for asset addition (Martin Kamerbeek/Procolix)
 - Added file upload ability to the rich text editor (Wouter van Oijen/ProcoliX)
 - added [ 732011 ] http header cache setting
 - added [ 810556 ] larger value field in userSessionScratch table
 - added [ 881817 ] allowed characters in username
 - added [ 1231386 ] Insert WebGUI Image
 - added [ 1205807 ] ability to report file size in File template
 - added [ 1201811 ] resizable textAreas
 - added [ 1376374 ] WebGUI should return a Last-Modified http/1.x header
 - added [ 1216059 ] Admin Bar Made Sticky
 - fix [ 1471218 ] 6.8.8: Unable to change Default Home Page
 - fix [ 1481787 ] autocomplete in user editing screens
 - fix [ 1445002 ] Field(s) fail to delete
 - fix [ 1344318 ] utf8 support for uri_escape/URL::Escape
 - fix [ 1466255 ] 6.8.8 Typo in package WebGUI::Operation::FormHelpers
 - fix [ 1463411 ] Denied content not getting expired or trashed
 - fix [ 1461522 ] 6.8.7 Linking items in the page tree (PDF and other files)
 - fix [ 1465280 ] BR Tag in Outlook
 - fix [ 1178981 ] IE is in "quirks mode" - multi-column layout templates
   break
 - fix [ 999590 ] Rating
 - fix [ 1410577 ] WebGUI::Session not included
 - fix a bug where a link was provided to become or delete non-existant users.
 - fix bugs with the in-memory session caching of user and group memberships
 - fix [ 1465362 ] RichEditor doesn't work on Safari
 - fix [ 1344665 ] Cache does not remember mimetype
 - fix [ 1172613 ] Header Tag Not Accessibility Friendly
 - fix [ 1340839 ] If can't use item in adminConsole don't display it
 - fix [ 1473937 ] scratch->set not taking.
 - fix [ 1471909 ] createAccountSave not called - no validate email (Martin
   Kamerbeek / Procolix)
 - fix [ 1479779 ] enable select box in dataform (Martin Kamerbeek / Procolix)
 - fix [ 1478585 ] purgeRevision without warning or confirmation (Martin
   Kamerbeek / Procolix)
 - fix [ 1480536 ] "Add Files" link in Folder template doesn't work (Martin
   Kamerbeek / Procolix)
 - fix [ 1443373 ] 6.8.7 Events Calendar Dates Incorrect (Wouter van Oijen /
   ProcoliX)
 - fix [ 1444918 ] 6.8.7 Events Calendar - Year old events show in list view
   (Wouter van Oijen / ProcoliX)
 - fix [ 1452552 ] Events Calendar starting from the wrong day with Now!
   (Wouter van Oijen / ProcoliX)
 - fix [ 1452719 ] Event calendar, wrong day of week for date (Wouter van Oijen
   / ProcoliX)
 - fix [ 1470410 ] Problems with Calendar (Wouter van Oijen / ProcoliX)
 - fixed a caching bug for Events Calendar (Wouter van Oijen / ProcoliX)
 - Added a graphing engine and tied it into the Poll asset (Martin Kamerbeek / Procolix)
 - Added Slider form controls (IntSlider, HexSlider and SelectSlider) (Martin
   Kamerbeek / Procolix)
 - Fixed a number of bugs in DateTime.pm
  switch(ss.type)
  {
    case "radio": { return CheckRequired(ss); break; }
    case "select-one": { return SelectionRequired(ss); break; }
    case "text":
    case "textarea": { return ContentRequired(ss); break; }
    default:
    {
      if (ss[0].type == "radio")
        return CheckRequired(ss);
      break;
    }
  }
  return true;
  if(ss[i].checked) { return false; }
  }
  if(ss[i].selected) {
    if(ss[i].value.length) { return false; }
    }
  }
  <tmpl_loop field_loop>
      <tmpl_if field.isRequired>if(FieldRequired(document.bformmail.<tmpl_var field.name>)){ errormessage += "\n * <tmpl_var field.label> is a required field."; }</tmpl_if>
  </tmpl_loop>

    alert('You still have required fields remaining:\n' + errormessage);
    return false;
    }
  <tmpl_loop tab_loop>
    <tmpl_loop tab.field_loop>
      <tmpl_if tab.field.isRequired>if(FieldRequired(document.bformmail.<tmpl_var tab.field.name>)){ errormessage += "\n * <tmpl_var tab.field.label> is a required field."; }</tmpl_if>
    </tmpl_loop>
  </tmpl_loop>

    alert('You still have required fields remaining:\n' + errormessage);
    return false;
    }
 mysql -uroot -ppass -B -e "show databases;" | grep -v "Database" > dbs
 #!/usr/local/bin/bash
 for i in `cat dbs`; do ./backitup $i; done
 tar -zcf servername_sql-backups_`date +%Y_%m_%d`.tar.gz *.sql
 rm *.sql

 #!/bin/sh
 echo Backing up $1 ...
 mysqldump -uuser -ppass -Q $1 > $1.sql

#!/bin/sh
#
# Define these variables in either /etc/periodic.conf or
# /etc/periodic.conf.local to override the default values.
#
# daily_mysql_backup_enable="YES" # do backup
# daily_mysql_maintenance_enable="YES" # perform maintenance

daily_mysql_backup_enable="NO"
daily_mysql_maintenance_enable="NO"

daily_mysql_mysqldump_args="--opt"
daily_mysql_backupdir="/data/mysql_backups"
daily_mysql_savedays="7"
daily_mysql_maintenance_args="-c -a --auto-repair -o -e -A -v"

mysql_user="user"
mysql_password="password"

# If there is a global system configuration file, suck it in.
#
if [ -r /etc/defaults/periodic.conf ]
then
    . /etc/defaults/periodic.conf
    source_periodic_confs
fi

# allow '~� in dir name
eval backupdir=${daily_mysql_backupdir}

rc=0

case "$daily_mysql_backup_enable" in
    [Yy][Ee][Ss])

        # daily_mysql_backupdir must be writeable by user mysql
        if [ ! -d ${backupdir} ] ; then
            echo Creating ${backupdir}
            mkdir ${backupdir}; chmod 700 ${backupdir}; chown mysql ${backupdir}
        fi

        echo
        echo "MySQL maintenance"

        # Protect the data
        umask 077
        dbnames=`su -l mysql -c "mysql -u ${mysql_user} -p'${mysql_password}' -B -e \"SHOW DATABASES;\" | \
                grep -v Database | grep -v information | grep -v schema | grep -v test"`
        rc=$?
        now=`date "+%Y-%m-%dT%H:%M:%S"`
        file=${daily_mysql_backupdir}/myglobals_${now}
        su -l mysql -c "mysqldump -A ${daily_mysql_mysqldump_args} -u ${mysql_user} -p'${mysql_password}' | gzip -9 > ${file}.gz" 
        for db in ${dbnames}; do   
            echo -n " $db"
            file=${backupdir}/mysqldump_${db}_${now}
            su -l mysql -c "mysqldump ${daily_mysql_mysqldump_args} -u ${mysql_user} -p'${mysql_password}' ${db} | gzip -9 > ${file}.gz" 
            [ $? -gt 0 ] && rc=3
        done

        if [ $rc -gt 0 ]; then
            echo
            echo "Errors were reported during backup."
        fi

        # cleaning up old data
        find ${backupdir} \( -name 'mysqldump_*' -o -name 'myglobals_*' \) \
                -a -mtime +${daily_mysql_savedays} -delete
        ;;
esac

echo ""

case "$daily_mysql_maintenance_enable" in     
    [Yy][Ee][Ss])

        echo
        echo "Performing Maintenance..."
        su -l mysql -c "mysqlcheck ${daily_mysql_maintenance_args} -u ${mysql_user} -p'${mysql_password}'"
        if [ $? -gt 0 ]   
        then
            echo
            echo "Errors were reported during the maintenance."
            rc=3
        fi
        ;;
esac

echo ""

exit $rc
 * You must upgrade to Config::JSON 1.1.0 or higher prior to upgrading.
    Due to a bug in CPAN you should type "force install Config::JSON" in
    order to upgrade to this version.
 * You must upgrade to the latest 7.3.x release before upgrading to
    7.4.0 or you will encounter fatal errors during the upgrade
    process.
 * WebGUI now requires the following additional perl modules to operate,
   and you should install them prior to upgrading:

    Config::JSON
    Text::CSV_XS
    Class::InsideOut
    HTML::TagCloud

    Cannot open config file:  at ../../lib/WebGUI/Config.pm line 348.
    Can't locate object method "http" via package "../.." at ../../lib/WebGUI/Session.pm line 370.
            Processing upgrade executable failed!

    The upgrade process failed and has stopped so you can either restore
    from backup, or attempt to fix the problem and continue.

    select webguiVersion from webguiVersion order by dateApplied desc, webguiVersion desc limit 1

    select webguiVersion from webguiVersion order by dateApplied desc, length(webguiVersion) desc, webguiVersion desc limit 1