How To Set Up A Feng Office Suite Web Server On Ubuntu Server 10.10

This howto describes how to set up a local intranet web based office suite server (on Ubuntu 10.10 server) based on Feng Office which used to be OpenGoo. Feng Office has a range of groupware type products such as word processing, email, calendar, and presentations.

It doesnt yet have a spreadsheet nor does its calendar integrate with a calendar server. If these are features you would like to see then go to http://www.fengoffice.com/web/community/collaborate.php and tell them so.

Download and install Ubuntu server. Give the server a useful netbios name, e.g. fengserver. Using the space bar select LAMP server.

Write down the password you use for the MySQL root user - you'll need it later.

Create a user with password, e.g. fengadmin from the command line.

Go to the Internet directory:

cd /var/www

Download the latest version of FENG:

sudo wget http://downloads.sourceforge.net/project/opengoo/fengoffice/fengoffice_1.7.4/fengoffice_1.7.4.zip

Install the unzip package:

sudo apt-get install unzip

Unzip Feng:

sudo find . -name "feng*.zip" -exec unzip {} \;

Install PHP:

sudo apt-get install php5-gd mysql-server apache2 php5 php5-mysql

Give ownership of the unzipped folders to Apache:

sudo chown www-data:www-data /var/www/feng/feng_community/config
sudo chown www-data:www-data /var/www/feng/feng_community/cache
sudo chown www-data:www-data /var/www/feng/feng_community/upload
sudo chown www-data:www-data /var/www/feng/feng_community/tmp

Create the feng database in MySQL:

echo "create database fengdb" | mysql -u root -p

Enter your MySQL root password.

echo "create user 'fenguser'@'localhost' identified by 'fengsqlpassword'" | mysql -u root -p

Again, enter your MySQL root password.

echo "grant all on fengdb.* to 'fenguser'@'localhost'" | mysql -u root -p

Enter your MySQL root password again. Or in each case you can enter the password at the end of the line immediately after-p with no space. This then allows the process to be scripted if you like. Slightly less secure though given that your password will be visible in the script

Restart the webserver:

sudo  /etc/init.d/apache2 restart

Go to the web site from another machine:

    http://fengserver/feng_community/

For the MySQL database/host/username/password enter fengdb/localhost/fenguser/fengsqlpassword. Obviously enter a more secure password in place of each instance of fengsqlpassword here and above.

Create a feng admin username and password.

Go finish, add a new user with details and you're done.