Monitoring Users Activity Using psacct or acct Tools in Linux

If you have lot of developers or programmers who access your servers frequently in your company and if you wanna to keep an eye on what data they are accessing, what commands they are issuing, how long they have been accessing servers and how much system resources are consumed by them, then psacct or acct are the tools that you should have. Already we have covered a topic about Nagios Monitoring Tool.

Monitoring-user-activity

Both psacct and acct are similar tools whereas psacct is available for RPM based systems and acct is available for DEB based systems.

Read my full article here…

Run Your Own Social Network Using elgg on RHEL 6.4 / CentOS 6.4 / Scientific Linux 6.4

Elgg is an open-source and powerful social networking engine used to create your own social networking web site. In this How To, I am gonna show you how to build your own social network website, just like Facebook and Linkedin.

images

Prerequisites

Elgg needs Apache, MySQL and PHP modules in order to build the social networking websites. So let us install the following necessary prerequisites first:

[root@server ~]# yum install mysql mysql-server httpd php php-mysql php-gd php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc wget unzip -y

Read my full tutorial here…

Install Tripwire Intrusion detection system on CentOS 6.4 / RHEL 6.4 / Scientific Linux 6.4

Tripwire is an open source security and data integrity tool used to monitor and alert  any changes in files and directories. It monitors and detects the changes in files/directories, which file/directory is added, who changed them, what was changed and time of changed. Once the changes are valid and reasonable, then you can accept the changes by updating the tripwire database.

images

Refer my other articles about monitoring tools such as Nagios and Cacti.

Installing Tripwire

Install the Tripwire software from EPEL repository. To install EPEL repository, enter the following commands.

root@server ~]# wget http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
[root@server ~]# rpm -ivh epel-release-6-8.noarch.rpm

Now install Tripwire.

[root@server ~]# yum install tripwire -y

Creating site and local keyfile pass-phrases

[root@server ~]# tripwire-setup-keyfiles 

----------------------------------------------
The Tripwire site and local passphrases are used to sign a  variety  of
files, such as the configuration, policy, and database files.

Passphrases should be at least 8 characters in length and contain  both
letters and numbers.

See the Tripwire manual for more information.

----------------------------------------------
Creating key files...

(When selecting a passphrase, keep in mind that good passphrases typically
have upper and lower case letters, digits and punctuation marks, and are
at least 8 characters in length.)

Enter the site keyfile passphrase:     ## Enter site pass-phrase ##
Verify the site keyfile passphrase:     ## Re-enter pass-phrase ##
Generating key (this may take several minutes)...Key generation complete.

(When selecting a passphrase, keep in mind that good passphrases typically
have upper and lower case letters, digits and punctuation marks, and are
at least 8 characters in length.)

Enter the local keyfile passphrase:     ## Enter local pass-phrase ##
Verify the local keyfile passphrase:     ## Re-enter pass-phrase ##
Generating key (this may take several minutes)...Key generation complete.

----------------------------------------------
Signing configuration file...
Please enter your site passphrase:      ## Enter site pass-phrase ##
Wrote configuration file: /etc/tripwire/tw.cfg

A clear-text version of the Tripwire configuration file:
/etc/tripwire/twcfg.txt
has been preserved for your inspection.  It  is  recommended  that  you
move this file to a secure location and/or encrypt it in place (using a
tool such as GPG, for example) after you have examined it.

----------------------------------------------
Signing policy file...
Please enter your site passphrase:     ## Enter site pass-phrase ##  
Wrote policy file: /etc/tripwire/tw.pol

A clear-text version of the Tripwire policy file:
/etc/tripwire/twpol.txt
has been preserved for  your  inspection.  This  implements  a  minimal
policy, intended only to test  essential  Tripwire  functionality.  You
should edit the policy file to  describe  your  system,  and  then  use
twadmin to generate a new signed copy of the Tripwire policy.

Once you have a satisfactory Tripwire policy file, you should move  the
clear-text version to a secure location  and/or  encrypt  it  in  place
(using a tool such as GPG, for example).

Now run "tripwire --init" to enter Database Initialization  Mode.  This
reads the policy file, generates a database based on its contents,  and
then cryptographically signs the resulting  database.  Options  can  be
entered on the command line to specify which policy, configuration, and
key files are used  to  create  the  database.  The  filename  for  the
database can be specified as well. If no  options  are  specified,  the
default values from the current configuration file are used.

Initializing Tripwire Database

[root@server ~]# tripwire --init
Please enter your local passphrase: 
Parsing policy file: /etc/tripwire/tw.pol
Generating the database...
*** Processing Unix File System ***
### Warning: File system error.
### Filename: /dev/kmem
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /proc/ksyms
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /proc/pci
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /usr/sbin/fixrmtab
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /usr/bin/vimtutor
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /usr/local/lib64
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /usr/lib64
### No such file or directory
### Warning: File system error.
### Filename: /sbin/fsck.reiserfs
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /bin/tcsh
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /root/.Xresources
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /root/.esd_auth
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /root/.gnome
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /root/.ICEauthority
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /root/.Xauthority
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /dev/cua0
### No such file or directory
### Continuing...
### Warning: File system error.
### Filename: /dev/initctl
### No such file or directory
### Continuing...
Wrote database file: /var/lib/tripwire/server.ostechnix.com.twd
The database was successfully generated.

Modifying Tripwire policy file

As per the above result, you may get an error like No such file or directory or File system error.  This means that your tripwire scans every files which are mentioned in the tripwire config file. Comment out the files which are doesn’t exist in your system in the tripwire config file.

[root@server ~]# vi /etc/tripwire/twpol.txt 
{
#     /dev/kmem                         -> $(Device) ;
     /dev/mem                          -> $(Device) ;
     /dev/null                         -> $(Device) ;
     /dev/zero                         -> $(Device) ;
     /proc/devices                     -> $(Device) ;
     /proc/net                         -> $(Device) ;
     /proc/sys                         -> $(Device) ;
     /proc/cpuinfo                     -> $(Device) ;
     /proc/modules                     -> $(Device) ;
     /proc/mounts                      -> $(Device) ;
     /proc/dma                         -> $(Device) ;
     /proc/filesystems                 -> $(Device) ;
#     /proc/pci                         -> $(Device) ;
     /proc/interrupts                  -> $(Device) ;
     /proc/driver/rtc                  -> $(Device) ;
     /proc/ioports                     -> $(Device) ;
     /proc/scsi                        -> $(Device) ;
     /proc/kcore                       -> $(Device) ;
     /proc/self                        -> $(Device) ;
     /proc/kmsg                        -> $(Device) ;
     /proc/stat                        -> $(Device) ;

Once modifying all the files, update the tripwire policy file.

[root@server ~]# tripwire --update-policy --secure-mode low /etc/tripwire/twpol.txt 
Parsing policy file: /etc/tripwire/twpol.txt
Please enter your local passphrase: 
Please enter your site passphrase: 
======== Policy Update: Processing section Unix File System.
======== Step 1: Gathering information for the new policy.
### Continuing...
### Warning: Policy Update Added Object.
### An object has been added since the database was last updated.
### Object name: /var/lib/tripwire/server.ostechnix.com.twd
### Continuing...
### Warning: Policy Update Changed Object.
### An object has been changed since the database was last updated.
### Object name: Conflicting properties for object /root
### > Modify Time
### > Change Time
### Continuing...
======== Step 2: Updating the database with new objects.
======== Step 3: Pruning unneeded objects from the database.
Wrote policy file: /etc/tripwire/tw.pol
Wrote database file: /var/lib/tripwire/server.ostechnix.com.twd

Checking for any changes in files/directories

[root@server ~]# tripwire --check --interactive

Once you entered this command tripwire will collect all the details and open the result automatically in your vi editor. The report might be too long. Scroll down to view any changes in files or folders. As per the below result the newly Added and Modified files will have check mark(The Added and Modified sections are highlighted in bold). Finally save and quit the report by typing :wq. The Added and Modified files will be automatically updated to Tripwire policy file.

Open Source Tripwire(R) 2.4.1 Integrity Check Report

Report generated by:          root
Report created on:            Fri 10 May 2013 12:26:58 PM IST
Database last updated on:     Fri 10 May 2013 12:23:43 PM IST

===============================================================================
Report Summary:
===============================================================================

Host name:                    server.ostechnix.com
Host IP address:              Unknown IP
Host ID:                      None
Policy file used:             /etc/tripwire/tw.pol
Configuration file used:      /etc/tripwire/tw.cfg
Database file used:           /var/lib/tripwire/server.ostechnix.com.twd
Command line used:            tripwire --check --interactive

===============================================================================
Rule Summary:
===============================================================================

-------------------------------------------------------------------------------
Section: Unix File System
-------------------------------------------------------------------------------

  Rule Name                       Severity Level    Added    Removed  Modified
  ---------                       --------------    -----    -------  --------
  Invariant Directories           66                0        0        0
  Temporary directories           33                0        0        0
* Tripwire Data Files             100               1        0        1
  Critical devices                100               0        0        0
  User binaries                   66                0        0        0
  Tripwire Binaries               100               0        0        0
  Critical configuration files    100               0        0        0
  Libraries                       66                0        0        0
  Operating System Utilities      100               0        0        0
  Critical system boot files      100               0        0        0
  File System and Disk Administraton Programs
                                  100               0        0        0
  Kernel Administration Programs  100               0        0        0
  Networking Programs             100               0        0        0
  System Administration Programs  100               0        0        0
  Hardware and Device Control Programs
                                  100               0        0        0
System Information Programs     100               0        0        0
  Application Information Programs
                                  100               0        0        0
  Shell Related Programs          100               0        0        0
  Critical Utility Sym-Links      100               0        0        0
  Shell Binaries                  100               0        0        0
  System boot changes             100               0        0        0
  OS executables and libraries    100               0        0        0
  Security Control                100               0        0        0
  Login Scripts                   100               0        0        0
* Root config files               100               0        0        1

Total objects scanned:  10071
Total violations found:  3
===============================================================================
Object Summary:
===============================================================================

-------------------------------------------------------------------------------
# Section: Unix File System
-------------------------------------------------------------------------------

-------------------------------------------------------------------------------
Rule Name: Tripwire Data Files (/var/lib/tripwire)
Severity Level: 100
-------------------------------------------------------------------------------

Remove the "x" from the adjacent box to prevent updating the database
with the new values for this object.

Added:
[x] "/var/lib/tripwire/server.ostechnix.com.twd.bak"

-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
Rule Name: Tripwire Data Files (/etc/tripwire/tw.pol)
Severity Level: 100
-------------------------------------------------------------------------------

Remove the "x" from the adjacent box to prevent updating the database
with the new values for this object.

Modified:
[x] "/etc/tripwire/tw.pol"

-------------------------------------------------------------------------------
Rule Name: Root config files (/root)
Severity Level: 100
-------------------------------------------------------------------------------

Remove the "x" from the adjacent box to prevent updating the database
with the new values for this object.

Modified:
[x] "/root"

===============================================================================
.
.
.
.
.
Open Source Tripwire 2.4 Portions copyright 2000 Tripwire, Inc. Tripwire is a registered
trademark of Tripwire, Inc. This software comes with ABSOLUTELY NO WARRANTY;
for details use --version. This is free software which may be redistributed
or modified only under certain conditions; see COPYING for details.
All rights reserved.
Integrity check complete.
Please enter your local passphrase: 
Wrote database file: /var/lib/tripwire/server.ostechnix.com.twd

Now let us add a new file called sk.

[root@server ~]# touch sk

Now check this file with tripwire –check –interactive command. You may find the file sk under the Added section in the result.

[root@server ~]# tripwire --check --interactive
.
.
.
-------------------------------------------------------------------------------
Rule Name: Root config files (/root)
Severity Level: 100
-------------------------------------------------------------------------------

Remove the "x" from the adjacent box to prevent updating the database
with the new values for this object.

Added:
[x] "/root/sk"
.
.
.

Now the new file sk is updated automatically in the tripwire policy file.

Viewing the tripwire report file

All tripwire report files having extension .twr are stored in /var/lib/tripwire/report/ directory. These are not text files, so you can’t view them using any editor. First convert them using the following command to human readable format.

[root@server ~]# twprint --print-report --twrfile /var/lib/tripwire/report/server.ostechnix.com-20130510-124159.twr > /tmp/twrreport.txt

Now open the file using any editor.

[root@server ~]# vi /tmp/twrreport.txt 
Note: Report is not encrypted.
Open Source Tripwire(R) 2.4.1 Integrity Check Report

Report generated by:          root
Report created on:            Fri 10 May 2013 12:41:59 PM IST
Database last updated on:     Fri 10 May 2013 12:37:53 PM IST

===============================================================================
Report Summary:
===============================================================================

Host name:                    server.ostechnix.com
Host IP address:              Unknown IP
Host ID:                      None
Policy file used:             /etc/tripwire/tw.pol
Configuration file used:      /etc/tripwire/tw.cfg
Database file used:           /var/lib/tripwire/server.ostechnix.com.twd
Command line used:            tripwire --check --interactive
.
.
.
.

Viewing tripwire configuration and policy file locations

To view the policy file locations enter the following command.

[root@server ~]# twadmin --print-polfile
# policy:

# Global Variable Definitions

@@section GLOBAL
TWROOT=/usr/sbin;
TWBIN=/usr/sbin;
TWPOL="/etc/tripwire";
TWDB="/var/lib/tripwire";
TWSKEY="/etc/tripwire";
TWLKEY="/etc/tripwire";
TWREPORT="/var/lib/tripwire/report";
HOSTNAME=server.ostechnix.com;
.
.
.
.

To view the configuration files enter the following command.

[root@server ~]# twadmin --print-cfgfile
ROOT                   =/usr/sbin
POLFILE                =/etc/tripwire/tw.pol
DBFILE                 =/var/lib/tripwire/$(HOSTNAME).twd
REPORTFILE             =/var/lib/tripwire/report/$(HOSTNAME)-$(DATE).twr
SITEKEYFILE            =/etc/tripwire/site.key
LOCALKEYFILE           =/etc/tripwire/$(HOSTNAME)-local.key
EDITOR                 =/bin/vi
LATEPROMPTING          =false
LOOSEDIRECTORYCHECKING =false
MAILNOVIOLATIONS       =true
EMAILREPORTLEVEL       =3
REPORTLEVEL            =3
MAILMETHOD             =SENDMAIL
SYSLOGREPORTING        =false
MAILPROGRAM            =/usr/sbin/sendmail -oi -t

Scheduling Tripwire Check

You may find a cron file tripwire-check might be created automatically in the /etc/cron.daily/ directory. If it isn’t created, open your crontab file and add lines as shown below. The following example will execute the tripwire daily at 5 am.

[root@server ~]# vi /etc/crontab 
# Tripwire Monitor process
00 5 * * * /usr/sbin/tripwire  --check

Thats it.

Install Cacti Network Monitoring Tool on CentOS 6.4 / RHEL 6.4 / Scientific Linux 6.4

Cacti is an open source, front-end for the data logging tool called RRDtool. It is a web based network monitoring and graphing tool. For more information about Cacti refer the official link.

 

cacti

Install required packages

Install the following required packages for Cacti.

Install Apache

Apache is used to display the the network graphs created by PHP and RRDtool.

[root@server ~]# yum install httpd httpd-devel -y

Install MySQL

MySQL is used to store the Cacti Database details.

[root@server ~]# yum install mysql mysql-server -y

Install PHP

PHP script is used to create graphs using RRDtool.

[root@server ~]# yum install php-mysql php-pear php-common php-gd php-devel php php-mbstring php-cli php-mysql -y

Install PHP-SNMP

It is an extension for SNMP to access data.

[root@server ~]# yum install php-snmp -y

Install NET-SNMP

It is used to manage network.

[root@server ~]# yum install net-snmp-utils net-snmp-libs php-pear-Net-SMTP -y

Install RRDtool

It is a database tool to manage and retrieve data’s like Network Bandwidth and CPU Load etc.

[root@server ~]# yum install rrdtool -y

After installing all the above softwares, start them.

[root@server ~]# /etc/init.d/httpd start
[root@server ~]# /etc/init.d/mysqld start
[root@server ~]# /etc/init.d/snmpd start

Let the above services to start automatically on every reboot.

[root@server ~]# chkconfig httpd on
[root@server ~]# chkconfig mysqld on
[root@server ~]# chkconfig snmpd on

Read my full article here…

Install SugarCRM on CentOS 6.4 / RHEL / 6.4 / Scientific Linux 6.4

SugarCRM is a web based CRM(Customer Relationship Management) Solution written in PHP. It comes with different editions such as Enterprise, Ultimate, Corporate, Professional and Community(free) editions. For more details about the editions refer the official link.

images

In this how-to, i am gonna to show you how to install SugarCRM Community edition in CentOS 6.4.

Prerequisites

Install the necessary softwares such as MySQL, Apache and PHP modules first as shown below.

[root@server ~]# yum install mysql mysql-server httpd php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc php-magickwand php-mapserver php-mbstring php-mcrypt php-mssql php-shout php-snmp php-soap php-tidy curl curl-devel perl-libwww-perl ImageMagick libxml2 libxml2-devel unzip wget -y

After installing the above prerequisites, we need to tune the PHP settings. To do that open file /etc/php.ini and adjust the following settings. Make sure that memory_limit is set as 128M, post_max_size and upload_max_size as 20M.

[root@server ~]# vi /etc/php.ini
 memory_limit = 128M
 post_max_size = 20M
 upload_max_filesize = 20M

Once done this reboot the server to save the changes.

Now start Apache and MySQL services and make them to start automatically on every reboot.

[root@server ~]# /etc/init.d/httpd start
[root@server ~]# /etc/init.d/mysqld start
[root@server ~]# chkconfig httpd on
[root@server ~]# chkconfig mysqld on

Setup MySQL Root password

To setup the MySQL root password, run the following command.

[root@server ~]# /usr/bin/mysql_secure_installation 

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):     ## Press Enter ## 
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.

Set root password? [Y/n]     ## Press Enter ##
New password:                ## Enter new password ##
Re-enter new password:       ## Re-enter new password ##
Password updated successfully!
Reloading privilege tables..
 ... Success!

By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n]     ## Press Enter ##
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n]     ## Press Enter ## 
... Success!
By default, MySQL comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n]     ## Press Enter ##
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n]     ## Press Enter ##
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MySQL
installation should now be secure.Thanks for using MySQL!

Installing SugarCRM

Download the latest version of SugarCRM.

[root@server ~]# wget http://sourceforge.net/projects/sugarcrm/files/latest/download?source=files

Extract the downloaded file.

[root@server ~]# unzip SugarCE-6.5.12.zip

Create a new directory for SugarCRM in the apache root document folder. In this case let us create a directory sugarcrm.

[root@server ~]# mkdir /var/www/html/sugarcrm

Move the extracted SugarCRM installtion folder to /var/www/html/sugarcrm directory.

[root@server ~]# cd SugarCE-Full-6.5.12/
[root@server SugarCE-Full-6.5.12]# mv * /var/www/html/sugarcrm/
[root@server SugarCE-Full-6.5.12]# chown -R apache:apache /var/www/html/sugarcrm/

Open the apache default port 80 through your firewall/router.

[root@server ~]# vi /etc/sysconfig/iptables
 # Firewall configuration written by system-config-firewall
 # Manual customization of this file is not recommended.
 *filter
 :INPUT ACCEPT [0:0]
 :FORWARD ACCEPT [0:0]
 :OUTPUT ACCEPT [0:0]
 -A INPUT -p udp -m state --state NEW --dport 80 -j ACCEPT
 -A INPUT -p tcp -m state --state NEW --dport 80 -j ACCEPT
 -A INPUT -p udp -m state --state NEW --dport 53 -j ACCEPT
 -A INPUT -p tcp -m state --state NEW --dport 53 -j ACCEPT
 -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
 -A INPUT -p icmp -j ACCEPT
 -A INPUT -i lo -j ACCEPT
 -A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
 -A INPUT -j REJECT --reject-with icmp-host-prohibited
 -A FORWARD -j REJECT --reject-with icmp-host-prohibited
 COMMIT

Restart the iptables to save the changes.

[root@server ~]# /etc/init.d/iptables restart

Now navigate to the web browser using the URL http://ip-address/sugarcrm or http://domain-name/sugarcrm. Follow the on screen instructions.

Click Next.

Sugar Setup Wizard: Welcome to the SugarCRM 6.5.12 Setup Wizard - Mozilla Firefox_001

Scroll down on the next screen and click Next.

Sugar Setup Wizard: Are you ready to install? - Mozilla Firefox_002

Accept the License agreement and click Next.

Sugar Setup Wizard: License Acceptance - Mozilla Firefox_003

Select the installation type and click Next.

Sugar Setup Wizard: Installation Options - Mozilla Firefox_004

Select the Database and click Next.

Sugar Setup Wizard: Database Type - Mozilla Firefox_013

Enter the Database name(Database is automatically created in this step, if it isn’t created earlier), Hostname, Database administrative user(root), database password(mysql root user password) and select Define user to create from the drop-down box, enter the sugarcrm database username(e.g sugarcrm), password and finally click Next.

Sugar Setup Wizard: Database Configuration - Mozilla Firefox_011

Next enter the sugarcrm admin name (default username is admin) and password created in the earlier step.

Sugar Setup Wizard: Site Configuration - Mozilla Firefox_012

Now the summary of your selections will be displayed, if everything is Ok click Install.

Sugar Setup Wizard: Confirm Settings - Mozilla Firefox_014

The sugarcrm installation is starting now. Click Next to begin installation.

Sugar Setup Wizard: Perform Setup - Mozilla Firefox_015

Enter your mail-id , name and company name etc if you want to receive newsletters. This is optional. Then the login screen will appear. Enter the username as admin and password you have created earlier.

SugarCRM - Mozilla Firefox_016

After login, you will see the following screen, click Next to configure SugarCRM.

Admin Wizard - Mozilla Firefox_017

You can upload your company logo here. Click Next.

Admin Wizard - Mozilla Firefox_019

Set the system locale settings such as date and time and currency etc. Click Next.

Admin Wizard - Mozilla Firefox_020

Now you have to tell SugarCRM how it send emails. It will send emails using Gmail, Yahoo and Microsoft Exchange servers. If you have other email servers such as Senmail or Postfix, enter the details in other tab.

Admin Wizard - Mozilla Firefox_022

Enter the Administrator details of SugarCRM and Click Next.

User Wizard - Mozilla Firefox_023

Enter your System Locale settings such as Currency, date and time and Click Next.

User Wizard - Mozilla Firefox_024

Now SugarCRM installation is completed. Here you can create New users, Import existing data’s, configure the CRM and so on. If you done everything click Finish to start using CRM.

User Wizard - Mozilla Firefox_025

This is how your SugarCRM home page will appear.

SugarCRM - Mozilla Firefox_026

Thats it. I recommend you to read the User Guide/Administrator Guide to know more about using SugarCRM.

Miscellaneous

Suppose if you did something wrong or your installer stopped suddenly, you can start the installer again from the beginning. To do that open the ‘config.php’ in the /var/www/html/sugarcrm directory. Change the line installer_locked=false to installer_locked=true.

[root@server ~]# vi /var/www/html/sugarcrm/config.php 
## Change from false to true ##
'installer_locked' => true,

Now you will able to start the installer from the beginning. After completing your installation, don’t forget to change it as false back.

Run your own e-Commerce shopping online store using Prestashop

If you are planning to sell products through online and wonder how to create a online shopping cart solution like e-Bay, Flipkart and Snapdeal or where to find the right e-Commerce shopping solution for your needs, well then you should try a free open source tool called Prestashop.

logo

Prestashop is an open source, free e-Commerce shopping cart solution used by more than 30,000 online stores around the world and with having a big community members. It is because used by most people for its simplicity to install and configure, modern structure and very light weight e-Commerce software.

Read my full article here…

Monitor MySQL Databases using Mytop Tool

Mytop is a free and open source Monitoring software for MySQL databases. Its similar in look to TOP command in Linux/Unix. It is a command line tool to monitor MySQL threads and MySQL databases and helps the database administrators to optimize the database server for better performance and to handle heavy load.

social-media-monitoring.jpg

Install Mytop in CentOS 6.4 / RHEL 6.4 / Scientific Linux 6.4

Mytop package is not found in official CentOS repositories, So that install it from external repositories like EPEL. To install EPEl repository, run the following commands in terminal.

[root@server ~]# wget http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
[root@server ~]# rpm -ivh epel-release-6-8.noarch.rpm

Now install the Mytop package.

[root@server ~]# yum install mytop -y

Monitor Databases

Now run the following command to open the Mytop tool. It will ask the mysql root password to monitor the databases.

[root@server ~]# mytop --prompt
Password:

Probably you will get an error like “Couldn’t find Test database” or “Test database is not found”.

To resolve this issue open the “/usr/bin/mytop” file and change “db=>test” to “db=>mysql” or leave it as blank or create a new mysql database called “test”.

root@server_014.png

Now again open the mytop tool.

[root@server ~]# mytop --prompt
 Password:

root@server_015.png

If you want to monitor a particular database, use the parameter -d. For example, to monitor the database called “ostechnix” enter the following command.

[root@server ~]# mytop --prompt -d ostechnix
 Password:

root@server_016.png

Thats it. Refer the official documentation page for more information about Mytop.