Roundcube Installation in ISPCONFIG linux

## Go to phpmyadmin or mysql root login by command prompt

##
Database name: dbroundcube
Database user: roundcubeuser
Database user password: xxxxxx

## Dump SQL or import the SQL file from
(download this sql file from server location after untar roundcube)
/usr/share/roundcube/SQL/mysql.initial.sql

## mkdir /usr/share/roundcube
cd /usr/share/roundcube

## Download the latest version from the web of roundcube and
   uncompress in the current directory

wget http://jaist.dl.sourceforge.net/project/roundcubemail/roundcubemail/1.1.3/roundcubemail-1.1.3.tar.gz
tar -zxvf roundcubemail-1.1.3.tar.gz
mv roundcubemail-1.1.3 roundcube


wget http://jaist.dl.sourceforge.net/project/roundcubemail/roundcubemail/1.1.3/roundcube-framework-1.1.3.tar.gz
tar -zxvf roundcube-framework-1.1.3.tar.gz

mv roundcube/* .

mkdir /usr/share/roundcube/installer/Roundcube
cp /usr/share/roundcube/roundcube-framework-1.1.3/bootstrap.php /usr/share/roundcube/installer/Roundcube


chown root:root -R /usr/share/roundcube
chmod 777 -R /usr/share/roundcube/temp/
chmod 777 -R /usr/share/roundcube/logs/



## vi  /etc/httpd/conf/sites-enabled/000-ispconfig.conf

<Directory /usr/share/roundcube>
  Order allow,deny
  Allow from all
</Directory>



##  vi  /etc/httpd/conf.d/roundcube.conf

##########################################
# Roundcube is a webmail package written in PHP.

Alias /roundcube /usr/share/roundcube

<Directory /usr/share/roundcube/config>
  Order Deny,Allow
  Deny from All
</Directory>

<Directory /usr/share/roundcube/temp>
  Order Deny,Allow
  Deny from All
</Directory>

<Directory /usr/share/roundcube/logs>
  Order Deny,Allow
  Deny from All
</Directory>

# this section makes Roundcube use https connections only, for this you
# need to have mod_ssl installed. If you want to use unsecure http
# connections, just remove this section:
<Directory /usr/share/roundcube>
  RewriteEngine  on
  RewriteCond    %{HTTPS} !=on
  RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI}
</Directory>

###############################

#  vi /usr/share/roundcube/installer/index.php

Change
require_once 'bc.php';
 to
require_once '/usr/share/roundcube/program/include/bc.php';



yum -y install libicu-devel
yum -y install php-intl

## service httpd restart

### https://server-ip/roundcube/installer

## /usr/share/roundcube/config/config.inc.php.

 mv config.inc.php.sample config.inc.php
 vi config.inc.php
 $config['enable_installer'] = true;

$config['db_dsnw'] = 'mysql://roundcubeuser:Password@localhost/dbroundcube';

## vi /etc/httpd/conf/httpd.conf
**Uncomment this line
TypesConfig /etc/mime.types


### https://server-ip/roundcube/installer


## rm -rf /usr/share/roundcube/installer

#########################

modification
######################

vi /usr/share/roundcube/config/config.inc.php

$config['product_name'] = 'Corporate Webmail';

############ Change logo #########

# find /usr/share/roundcube/ | grep roundcube_logo

/usr/share/roundcube/skins/classic/images/roundcube_logo.png
/usr/share/roundcube/skins/larry/images/roundcube_logo.png


=============================
Roundcube Password Change Plugin Installation
====================================

 # cd /usr/share/roundcube/
# vi config/config.inc.php

// Add 'password' plugin here

// List of active plugins (in plugins/ directory)

$config['plugins'] = array(

    'archive',

    'zipdownload',

    'password',

);

# cd plugins/password/

#   vi config.inc.php

$config['password_driver'] = 'sql';

// Determine whether current password is required to change password.

// Default: false.

$config['password_confirm_current'] = true;

// set to blank to allow passwords of any length

$config['password_minimum_length'] = 8;

// Require the new password to contain a letter and punctuation character

// Change to false to remove this check.

$config['password_require_nonalpha'] = true;

// BLOCK THIS     $config['password_db_dsn'] = '';

$config['password_db_dsn'] = 'mysql://ispconfig:passwordofispconfigdbase@localhost/dbispconfig';

// BLOCK THIS $config['password_query'] = 'SELECT update_passwd(%c, %u)';

$config['password_query'] = 'UPDATE mail_user SET password=%c WHERE email=%u LIMIT 1';

#### see ispconfig db password::  cat  /usr/local/ispconfig/server/lib/config.inc.php

### Login RoundCube Webmail and Click Settings  and Click Password tab 

and then reset  your password.

=========================================

Use HTML Signature or company logo with Email.

At first, put your logo in a web directory that can be accessible and then ....

Goto-- Settings -> Identities -> Html Signature -> Click HTML button (Edit HTML source)
->

<pre>--
Thanking you,

Tayab khan,
MSC,MCP,CCNA,CCNP,CCNSP,JNCIA,JNCIS-SEC,
Manager(System &amp; Network)
Daffodil Online Ltd.
Cell: +8801914035805
</pre>
<p><img src="http://mail.daffodilnet.com/roundcube/skins/classic/images/roundcube_logo.png" alt="" /></p>

----------------------------------------