I have just tried my hand on this Groupware called NullGroupware, which was mentioned in PCquest. I must say its got all that you need for a small scale office of around 25/30 people and who do not even have a Systems Administrator.
A web based login interface that provide :
Email ----- Can fetch mails from Mail Servers and Send Mails
File Sharing through web based.
A very nice search form that can scan all the above modules
Now lets see what you need to implement this :
A Linux Box
You do not need to think about web server as it has got its own.
Step 1 - Download NullGroupware
I had downloaded :
Step 2 - Untar it --- (you don not need to untar it under webserver).
I had untarred it under /home/sriram
Step 3 - Run the set up
It will first show u the Readme thing One point to note there is your Admin User/Password
By Default it is
User --- Administrator
Password --- visual
You will get things to fill like :
See what Information I gave below :
NullLogic Groupware Configuration
Will you be using SQLITE, MYSQL or PGSQL [SQLITE]: MYSQL
What is the host name of the MYSQL server? [localhost]: localhost
What TCP/IP port is the MYSQL server listening on? : 3306
What is the name of the database NullLogic Groupware should use? [nullgroupware]: nullgroupware
What username should NullLogic Groupware use to access the database? [nullgw]: nullgw
What is the password for the 'nullgw' account? [password]: password
Points to note after the end of the setup :
In order to complete the install, you will need to manually create the
SQL database nullgroupware as follows.
mysqladmin create nullgroupware
After creating the database, please run /usr/local/nullgroupware/bin/dbutil to
initialise the database.
To reconfigure the server, run 'cd /usr/local/nullgroupware/bin;./configure'.
To start the server, run 'cd /usr/local/nullgroupware/bin;./rc.groupware start'.
Step 4 - Now I created the database and user with the required Permissions
[root@mybox sriram]# mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.15
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database nullgroupware;
Query OK, 1 row affected (0.10 sec)
mysql> grant all on nullgroupware.* to nullgw@localhost identified by "password";
Query OK, 0 rows affected (0.58 sec)
Step 5 - Check the configuration file (groupware.cfg )
Edit groupware.cfg and make changes according to your hostname,
MySQL port etc...
Step 6 - Now Initialise Database
Just go to /home/sriram/nullgroupware-1.2.7-x86-linux/bin
The above will Initialise the file
There are two more options you can use with ./dbutil
DUMP Dumps the data from the current database to a file
RESTORE Restores the current database from a file
DUMP - will allow you to take back up of your configuration in a file.
Whereas RESTORE will allow you to restore the configuration from
your previous file, so that you have all settings intact and dont have to bother about the configuration again.
Step 7 --- Start the Null Groupware Service
Step 8 --- Open your Browser and Start using its features
By default it runs on 4110 you can change it if you want, just edit
groupware.cfg in /home/sriram/nullgroupware-1.2.7-x86-linux/etc
Thats all ...................................................