Thursday, January 05, 2006

Nullgroupware - Groupware for Small and Medium Business

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 :

Bookmarks
Calendar
Calls
Contacts
Email ----- Can fetch mails from Mail Servers and Send Mails
File Sharing through web based.
Forums
Messenger
Notes
A very nice search form that can scan all the above modules


Now lets see what you need to implement this :

A Linux Box
Mysql
You do not need to think about web server as it has got its own.


Step 1 - Download NullGroupware

http://nullgroupware.sourceforge.net/downloads.php

I had downloaded :

nullgroupware-1.2.7-x86-linux.tar.gz

Step 2 - Untar it --- (you don not need to untar it under webserver).

I had untarred it under /home/sriram

cd /home/sriram/nullgroupware-1.2.7-x86-linux

Step 3 - Run the set up

#./setup

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]: 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
Enter password:
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 )

cd /home/sriram/nullgroupware-1.2.7-x86-linux/etc

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

./dbutil INIT

The above will Initialise the file


There are two more options you can use with ./dbutil

that is
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

#cd /home/sriram/nullgroupware-1.2.7-x86-linux/bin

#./rc.groupware start

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

http://localhost:4110/

Thats all ...................................................




Linux Utilities

Systat

The sysstat package contains the sar, mpstat, and iostat commands for Linux. The sar command collects and reports system activity information. This information can also be saved in a system activity file for future inspection. The iostat command reports CPU statistics and I/O statistics for tty devices and disks. The statistics reported by sar concern I/O transfer rates, paging activity, process-related activites, interrupts, network activity, memory and swap space utilization, CPU utilization, kernel activities, and TTY statistics, among others. Both UP and SMP machines are fully supported.

Re-Tail

Re-Tail is a command line program which is intended as an intelligent incremental logfile reader. It will read a file or group of files given on the command line, and output any changes since last time it read the file(s).
http://xjack.org/retail/

Checkservice

Checkservice is a Perl script that monitors services on remote hosts
http://www.linvision.com/checkservice/

Easy Shape

"Easy Shape" is a Web-based frontend for managing and graphing traffic and bandwidth flows under Linux.
http://www.linuxbox.co.za/software/easyshape/

autopackage:

Got yourself a .package file and don't know what to do? Build packages that will install on many different distros Multiple front ends: best is automatically chosen so GUI users get a graphical front end, and command line users get a text based interface Multiple language support (both in tools and for your own packages) Automatically verifies and resolves dependencies no matter how the software was installed. This means you don't have to use Autopackage for all your software, or even any of it, for packages to successfully install.
http://autopackage.org/

Openstats

OpenStats is an advanced open source platform for providing web traffic analysis.
http://www.openstats.net/

Mtop

(MySQL top) monitors a MySQL database showing the queries which are taking the most amount of time to
complete.
http://mtop.sourceforge.net/

Zabbix

Zabbix is software that monitors servers and applications. It has Web interface that allows quick and easy administration.Somewhat similar to Nagios
http://www.zabbix.com/

Maia Mailguard

Maia provides a Web-based front end to configure an anti-spam and anti-virus mail system.
http://www.renaissoft.com/projects/maia/

Qmail-Scanner

Qmail-Scanner Statistics uses the Qmail-Scanner Logfile to generate daily, monthly, and yearly statistics. It also shows a complete list of viruses stopped by Qmail-Scanner, the top five domains from which the viruses came, as well as the countries
http://sourceforge.net/projects/qss


Ghost for Linux:

Ghost for Linux is a hard disk and partition imaging and cloning tool similar to Norton Ghost(c). The created images are optionally compressed and transferred to an FTP server. The included kernel supports almost every common network interface, ATA and serial-ATA drives. The extended kernel on CD supports SCSI and several 1000 MBit network cards. It comes as 2 boot/root disks or a bootable CD image with an ncurses GUI.

http://g4l.networks-ltd.de/

Thunk

A password checker, cracker, and generator.
http://freshmeat.net/projects/thunk/