How-To Install WebGUI CMS on SMEServer 6.01-01

Author: ergin@ergin.net
Release supported: SME 6.x
License: GPL
Last updated:Saturday, July 24, 2004


Problem:  How to install popular WebGUI on you SMEServer?
Solution:  Follow this HowTo



2005-09-24 09_42 CET Update2 : Added some more perl links, updated link for PHPMyAdmin. I've also added information about log.conf and testEnvironment.pl.
2004-07-24 10:50 CET Update1 : Reformat into a standard SMEServer into and create links for perl-modules
2004-07-09 08:57 CET This HowTo is done with fresh installation of SME Server 6.01-01 ISO.

I like to manage my server over SSH with putty so I activate Remote Access



Run putty and ...




1. mod_perl is installed BUT not activated. Activate them by modifiying templates
[root@smeserver601 httpd.conf]# cd /etc/e-smith/templates/etc/httpd/conf/httpd.conf/
[root@smeserver601 httpd.conf]# vi 30AddModule60
# Extra Modules
#AddModule mod_php.c
#AddModule mod_php3.c
AddModule mod_perl.c

[root@smeserver601 httpd.conf]# vi 20LoadModule80
# Extra Modules
#LoadModule php_module modules/mod_php.so
#LoadModule php3_module modules/libphp3.so
LoadModule perl_module modules/libperl.so
LoadModule external_auth_module modules/mod_auth_external.so

2. Generate new httpd.conf and restart httpd
[root@smeserver601 httpd.conf]# /sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
[root@smeserver601 httpd.conf]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]

3. Download latest WebGUI (v6.1.1) from plainblack.com and untar
[root@smeserver601 root]# wget http://www.plainblack.com/downloads/6.x.x/webgui-6.1.1.tar.gz
[root@smeserver601 root]# tar xvzf webgui-6.1.1.tar.gz

4. Move files to Apache DocumentRoot, chown and chmod...
[root@smeserver601 root]# mv WebGUI /home/e-smith/files/primary/html/
[root@smeserver601 root]# cd /home/e-smith/files/primary/html/
[root@smeserver601 html]# chown -R www.www WebGUI/
5. Install necessary perl-modules
If you do not have them try
http://ergin.dyndns.org/download/RPMS/perl/ OR http://rpmpan.sourceforge.net
Installing perl modules can be tricky, depending on your system and which modules you already have installed you might have dependency issues. The only way is checking you logs
# /var/log/message
# /var/log/httpd/error_log


perl-LWP-attic
perl-DBI - OBS!!! included in SMEServer
perl-Apache-DBI
perl-DBD-mysql
perl-Date-Calc
perl-Archive-Tar
perl-IO-Zlib
perl-Digest-MD5
perl-Cache-Cache
perl-Data-Serializer
perl-libnet
perl-Log-Agent
perl-Log-Log4perl
perl-SOAP-Lite
perl-Compress-Zlib
6. Modify your httpd server for WebGUI
If you have not created the catalogue structure for templates-custom

[root@smeserver601 root]# cd /etc/e-smith/templates-custom/
[root@smeserver601 templates-custom]# mkdir etc
[root@smeserver601 templates-custom]# cd etc
[root@smeserver601 etc]# mkdir httpd
[root@smeserver601 etc]# cd httpd/
[root@smeserver601 httpd]# mkdir conf
[root@smeserver601 httpd]# cd conf
[root@smeserver601 conf]# mkdir httpd.conf
[root@smeserver601 conf]# cd httpd.conf/
[root@smeserver601 httpd.conf]# Copy file filen 87webgui from http://www.ergin.dyndns.org/howtos/webgui/87webgui



7. We also have to modify Directory / settings
If you already activated your webmail I think it is already modified



8. Generate /etc/httpd/conf/httpd.conf
[root@smeserver601 httpd.conf]# /sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
[root@smeserver601 httpd.conf]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]

9. Time for MySQL (I like phpmyadmin so I install contrib)
[root@smeserver601 root]# wget http://www.contribs.org/contribs/nightspirit/e-smith-phpmyadmin/e-smith-phpmyadmin-2.6.0-12.noarch.rpm
http://www.contribs.org/contribs/nightspirit/e-smith-phpmyadmin/e-smith-phpmyadmin-2.6.0-12.noarch.rpm
=> `e-smith-phpmyadmin-2.6.0-12.noarch.rpm'
Resolving www.contribs.org... done.
Connecting to www.contribs.org[69.9.12.50]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1,883,521 [application/octet-stream]
26% [========> ] 501,996 106.41K/s ETA 00:12

[root@smeserver601 root]# rpm -ivh e-smith-phpmyadmin-2.6.0-12.noarch.rpm
Preparing... ########################################### [100%]
1:e-smith-phpmyadmin ########################################### [100%]

To access the MySQL function via a web interface
you will have to access it via SSL in your web browser.

For example: https://192.168.1.1/phpmyadmin

Now go back to your WebGUI catalogue and
[root@smeserver601 httpd.conf]# cd /home/e-smith/files/ibays/Primary/html/WebGUI/docs/
[root@smeserver601 docs]# mysql -uroot mysql < create.sql


It is safer to create a database user for WebGUI. You can do it easily via PHPMYADMIN and grant all necessary priviledges
Choose your own password !!!



10. Time for config files...
Make changes needed in ./etc/WebGUI.conf and ./etc/log.conf You can check my WebGUI.conf file and log.conf files...


You also will have to create a log file for webgui
# touch /var/log/webgui.log
# chmod 777 /var/log/webgui.log
# chown www.www /var/log/webgui.log
11. and finally last modification...
modify your ./www/index.pl


IF EVERTHING WENT WELL, GIVE IT A TRY AND FIND OUT
http://your-ip-adress/webgui/


You can also test your environment with testEnvironment.pl

Good luck

Ergin Ozdemir
./webgui