Difference between revisions of "Roundcube: Instalasi di Ubuntu"

From OnnoWiki
Jump to navigation Jump to search
Line 66: Line 66:
 
  CREATE USER 'roundcube'@'localhost' IDENTIFIED BY 'password';
 
  CREATE USER 'roundcube'@'localhost' IDENTIFIED BY 'password';
 
  GRANT ALL PRIVILEGES ON roundcubedb.* to 'roundcube'@'localhost';
 
  GRANT ALL PRIVILEGES ON roundcubedb.* to 'roundcube'@'localhost';
 +
GRANT ALL PRIVILEGES ON roundcubedb.* to 'root'@'localhost';
 
  FLUSH PRIVILEGES;
 
  FLUSH PRIVILEGES;
 
  exit;
 
  exit;

Revision as of 13:33, 26 October 2018

sumber: https://www.howtoforge.com/tutorial/ubuntu-roundcube-latest/


Instalasi Apps Pendukung

sudo su
apt update
apt -y install apache2 mariadb-server php7.2 php7.2-gd \
php-mysql php7.2-curl php7.2-zip php7.2-ldap php7.2-mbstring \
php-imagick php7.2-intl php7.2-xml unzip wget curl \
php-pear php-net-imap php-net-smtp php-net-idna2 php-mail-mime php-net-ldap3 \
dovecot-core dovecot-imapd postfix
chown -Rf www-data: /var/www/

Waktu instalasi postfix set

hostname
Internet Relay Host


Set Timezone

sudo vi /etc/php/7.2/apache2/php.ini
date.timezone = Asia/Jakarta

Start

sudo systemctl start apache2
sudo systemctl enable apache2
sudo systemctl start mysqld
sudo systemctl enable mysqld

Download Roundcube

Download

cd /usr/local/src
wget https://github.com/roundcube/roundcubemail/releases/download/1.3.7/roundcubemail-1.3.7.tar.gz

Buka & Copy

tar -xvzf roundcubemail-1.3.7.tar.gz
mv roundcubemail-1.3.7 /var/www/html/roundcube
sudo chown -R www-data:www-data /var/www/html/roundcube
sudo chmod -R 775 /var/www/html/roundcube


Database

Jika di perlukan buat menjadi secure (bisa di skip jika untuk belajar saja)

mysql_secure_installation
Change the password for root ? N
Remove anonymous users? Y
Disallow root login remotely? Y
Remove test database and access to it? Y
Reload privilege tables now? Y

Konfigurasi database

mysql -u root -p123456
CREATE DATABASE roundcubedb;
CREATE USER 'roundcube'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON roundcubedb.* to 'roundcube'@'localhost';
GRANT ALL PRIVILEGES ON roundcubedb.* to 'root'@'localhost';
FLUSH PRIVILEGES;
exit;

Inisialisasi database

cd /var/www/html/roundcube
mysql -u roundcube -p roundcubedb < SQL/mysql.initial.sql

Masukan password "password"

Konfigurasi Apache

Edit file

sudo vi /etc/apache2/sites-available/roundcube.conf

Tambahkan

<VirtualHost *:80>
        ServerName 192.168.0.102                          
        ServerAdmin admin@example.com
        DocumentRoot /var/www/html/roundcube 

        ErrorLog ${APACHE_LOG_DIR}/roundcube_error.log
        CustomLog ${APACHE_LOG_DIR}/roundcube_access.log combined 

        <Directory /var/www/html/roundcube>
                Options -Indexes
                AllowOverride All
                Order allow,deny
                allow from all
        </Directory>
</VirtualHost>

Save & close file

Aktifkan

sudo a2ensite roundcube
sudo a2enmod rewrite
sudo systemctl restart apache2

Akses Web

Akses ke

http://ip-address-server/installer
http://192.168.0.102/installer

Pastikan

  • Checking PHP version - OK
  • Checking PHP extensions - OK
  • Checking available databases - paling tidak ada 1 database OK
  • Check for required 3rd party libs - OK
  • Checking php.ini/.htaccess settings - OK

NEXT PAGE

  • MySQL - Database type
  • roundcube - Database server (omit for sqlite)
  • roundcube - Database name (use absolute path and filename for sqlite)
  • roundcube - Database user name (needs write permissions)(omit for sqlite)
  • password - Database password (omit for sqlite)

NEXT PAGE

  • Test kirim email dari username@domain ke username@domain
  • Test imap username password

Referensi