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

Aktifkan port 587

vi /etc/postfix/master.cf

Buka # dari line berikut,

submission inet n       -       y       -       -       smtpd

Restart,

systemctl restart postfix

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
sudo apt -y install roundcube-core roundcube-sqlite3

Cek timezone

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

Install CMS 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

Init SQLite

cd /var/www/roundcube
sudo mkdir db
sudo sqlite3 -init SQL/sqlite.initial.sql db/roundcube.sqlite

sqlite> .quit

sudo chown www-data:www-data -R /var/www/roundcube

Edit config

vi /var/www/roundcube/config/config.inc.php

$config['db_dsnw'] = 'sqlite:////var/www/roundcube/db/roundcube.sqlite?mode=0646';

Kalau semua sudah berjalan baik, pastikan

// $config['enable_installer'] = true;

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/