Roundcobe: Instalasi di Ubuntu 22.04 database SQLite3

Sumber: https://tecadmin.net/how-to-install-roundcube-webmail-on-ubuntu-20-04/

Install IMAP, POP3 & SMTP Server

Install

sudo apt update
sudo apt -y install postfix dovecot-core dovecot-imapd dovecot-pop3d

Set servername misalnya student.itts.ac.id

Install MariaDB

sudo apt update
sudo apt install mariadb-server 

sudo systemctl start mariadb 
sudo systemctl enable mariadb 
sudo systemctl status mariadb

Pastikan mariadb "active (running)" dan berwarna hijau di systemctl status.

Setup database

Untuk testing ..

sudo mysql -u root -p123456

CREATE DATABASE roundcube DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 
CREATE USER roundcube@localhost IDENTIFIED BY 'roundcube'; 
GRANT ALL PRIVILEGES ON roundcube.* TO roundcube@localhost; 
FLUSH PRIVILEGES; 
exit

Untuk operasi yang lebih serius

sudo mysql -u root 

CREATE DATABASE roundcubedb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 
CREATE USER dbuser@localhost IDENTIFIED BY 'testpassword'; 
GRANT ALL PRIVILEGES ON roundcubedb.* TO dbuser@localhost; 
FLUSH PRIVILEGES; 
exit

Install PHP

sudo apt -y install php php-gd php-common php-json php-imagick \
php-imap php-xml php-opcache php-mbstring php-curl php-zip \
php-bz2 php-intl 

Cek timezone https://www.php.net/manual/en/timezones.asia.php

sed -i -e “s/^;date\.timezone =.*$/date\.timezone = ‘Asia/Jakarta’/” /etc/php/8.1/apache2/php.ini

Atau yang lebih gampang:)

vi /etc/php/8.1/apache2/php.ini

[Date]
; Defines the default timezone used by the date functions
; https://php.net/date.timezone
;date.timezone =
date.timezone = Asia/Jakarta

Install Apache

sudo apt install apache2 -y 

sudo systemctl start apache2 
sudo systemctl enable apache2 
sudo systemctl status apache2 

Pastikan status "active (running)" berwarna hijau.

Edit konfigurasi

sudo vi /etc/apache2/sites-available/student.itts.ac.id.conf 

<VirtualHost *:80>
  ServerName student.itts.ac.id
  DocumentRoot /var/www/roundcube/
  ErrorLog ${APACHE_LOG_DIR}/roundcube_error.log
  CustomLog ${APACHE_LOG_DIR}/roundcube_access.log combined
 
  <Directory />
    Options FollowSymLinks
    AllowOverride All
  </Directory>
 
  <Directory /var/www/roundcube/>
    Options FollowSymLinks MultiViews
    AllowOverride All
    Order allow,deny
    allow from all
  </Directory>
</VirtualHost>

sudo a2ensite student.itts.ac.id 
sudo systemctl reload apache2

Install Roundcube

cd /usr/local/src/
wget https://github.com/roundcube/roundcubemail/releases/download/1.6.6/roundcubemail-1.6.6-complete.tar.gz
tar xvf roundcubemail-1.6.6-complete.tar.gz 
sudo mv roundcubemail-1.6.6 /var/www/roundcube
sudo chown www-data:www-data -R /var/www/roundcube

Isi database roundcube, untuk untuk belajar ..

mysql -u roundcube -proundcube roundcube < /var/www/roundcube/SQL/mysql.initial.sql

Isi database roundcube, untuk kerjaan serius :)

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

atau,

mysql -u dbuser -ptestpassword roundcubedb < /var/www/roundcube/SQL/mysql.initial.sql

Akses Web

Edit /etc/hosts

sudo su
vi /etc/hosts

tambahkan,

192.168.0.187   student.itts.ac.id

Browse ke

http://student.itts.ac.id/installer

Referensi

• https://tecadmin.net/how-to-install-roundcube-webmail-on-ubuntu-20-04/