Saturday 7 December 2013

OTRS Open Source Helpdesk Software

OTRS is the leading open-source Help Desk and IT Service Management (ITSM) solution used by thousands of organizations worldwide.
This guide explains the steps involved in installing the latest OTRS release on a minimal CentOS 6 installation.






 OTRS Open Source Helpdesk Software


  Install Following Packges:-

yum install system-config-firewall-tui
yum install mlocate
yum install wget
yum install vixie-cron
yum install logwatch
yum install make
yum install gcc
yum install gd
yum install gd-devel
yum install perl*
yum install procmail
yum install mysql
yum install mysql-server

yum -y install http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

yum -y install "perl(Text::CSV_XS)"


Download otrs-3.3.2-01.noarch.rpm :-
wget http://ftp.otrs.org/pub/otrs/RPMS/rhel/6/otrs-3.3.2-01.noarch.rpm

Install RPM
rpm -ivh otrs-3.3.2-01.noarch.rpm

Restart Webserver (Apache)
service httpd start
chkconfig httpd on

Allow 80 Port (HTTP Port) in Firewall IPTable
vi /etc/sysconfig/iptables

-A INPUT -p tcp -m state --state NEW -m tcp --dport 80 -j ACCEPT

Restart Iptables
/etc/init.d/iptables restart


----------------------------------------------------------------------------------------
        Configure mysql database and user
----------------------------------------------------------------------------------------
Restart Database Server (Mysql)

/etc/init.d/mysqld start

chkconfig mysqld on

Set Root Password
mysqladmin -u root password Admin@123

Login On Database with Root User
#mysql -u root -p

mysql> CREATE DATABASE mail;
mysql> GRANT ALL PRIVILEGES ON otrs.* TO 'otrs'@'localhost' IDENTIFIED BY 'otrs';
mysql> GRANT ALL PRIVILEGES ON otrs.* TO 'otrs'@'%' IDENTIFIED BY 'otrs';
mysql> quit

/etc/init.d/mysqld restart
/etc/init.d/httpd restart



Note : Make Sure that SELinux is Disable

Goto Browser & Put Following URL, Then Continue the installation.
 http://172.16.16.247/otrs/installer.pl


Put Following URL to Access the Admin Panel.
http://172.16.16.247/otrs/index.pl
http://IP ADDRESS-OF-SERVER/otrs/customer.pl

Login User:    root@localhost
Login  Password: ********




Put Following URL to Access the Client / Staff  Panel.

http://IP ADDRESS-OF-SERVER/otrs/customer.pl
OT
http://172.16.16.247/otrs/customer.pl

Login User:   User
Login  Password: ********

Friday 6 December 2013

Roundcubemail Webmail Installation



Roundcube webmail





 Roundcube is a browser-based multilingual IMAP client with an application-like user interface. It provides full functionality you expect from an email client, including MIME support, address book, folder manipulation, message searching and spell checking

 


Features

  •     Multilingual capabilities
  •     Find-as-you-type address book
  •     Richtext/HTML message composing
  •     Searching messages and contacts
  •     Canned response templatesNew!
  •     Int. domain names (IDNA)
  •     Shared folders and ACL
  •     Full featured address book
  •     Extensible using the Plug-in API


 





Roundcubemail Webmail Installation

 Install Following Packges:-

yum install httpd
yum install php
yum install php-common
yum install php-json
yum install php-xml
yum install php-mbstring
yum install php-imap
yum install php-pear-DB
yum install php-mysql
yum install mysql
yum install mysql-server
yum install php-mcrypt --enablerepo=centosplus




Set Time Zone in  php :-
#vi /etc.php.ini
(Time Zone Should be     date.timezone = Asia/Kolkata )



 Download roundcubemail-0.8.6.tar.gz :-
#wget http://sourceforge.net/projects/roundcubemail/files/roundcubemail/0.8.6/roundcubemail-0.8.6.tar.gz/download

Extrace Tar File:-
#tar zxvf roundcubemail-0.8.6.tar.gz

Move Extracted Directory to Your Mail Setup Directory or Anywhere you want. :-
#mv roundcubemail-0.8.6 /opt/mail_setup/roundcubemail

Change Owner & Group of directory  :-
#chown -R apache.apache /opt/mail_setup/roundcubemail/


 Following is the Webserver (Apache) Configuration) :-

#vi /etc/httpd/conf/httpd.conf

### WEBMAIL ###
Alias /roundcubemail /opt/mail_setup/roundcubemail/
<Directory /opt/mail_setup/roundcubemail/>
Options Indexes
AllowOverride none
DirectoryIndex index.php
Order allow,deny
allow from all
</Directory>



 Databse Server (Mysql) Configuration :-

#mysql -uroot -p
#CREATE DATABASE roundcubemail /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
#GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost IDENTIFIED BY 'roundcube';


Open the link in the web browser :-
http://SERVER-IP/roundcubemail/installer
http://172.16.16.246/roundcubemail/installer




Follow the installation steps & Continue the installation



Create Following Both the file as per intructions on Webpage 
#cd /opt/mail_setup/roundcubemail/config

#vi main.inc.php
#vi db.inc.php


#Remove the installer directory :-
#rm -rf /var/www/html/roundcubemail/installer



Njoy Roundcubemail   :) 




Ref:http://roundcube.net/