Difference between revisions of "Roundcobe: Instalasi di Ubuntu 22.04 database SQLite3"

From OnnoWiki
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 14: Line 14:
  
 
  vi /etc/postfix/master.cf
 
  vi /etc/postfix/master.cf
 +
 +
Buka # dari line berikut,
  
 
  submission inet n      -      y      -      -      smtpd
 
  submission inet n      -      y      -      -      smtpd
Line 85: Line 87:
 
  sudo mv roundcubemail-1.6.6 /var/www/roundcube
 
  sudo mv roundcubemail-1.6.6 /var/www/roundcube
 
  sudo chown www-data:www-data -R /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==
 
==Akses Web==

Latest revision as of 14:53, 23 January 2024

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