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

From OnnoWiki
Jump to navigation Jump to search
 
(8 intermediate revisions by the same user not shown)
Line 11: Line 11:
 
Set servername misalnya student.itts.ac.id
 
Set servername misalnya student.itts.ac.id
  
==Setup database==
+
Aktifkan port 587
  
Untuk testing ..
+
vi /etc/postfix/master.cf
  
sudo mysql -u root -p123456
+
Buka # dari line berikut,
  
  CREATE DATABASE roundcube DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
+
  submission inet n      -      y      -      -      smtpd
CREATE USER roundcube@localhost IDENTIFIED BY 'roundcube';
 
GRANT ALL PRIVILEGES ON roundcube.* TO roundcube@localhost;
 
FLUSH PRIVILEGES;
 
exit
 
  
Untuk operasi yang lebih serius
+
Restart,
  
  sudo mysql -u root
+
  systemctl restart postfix
 
 
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==
 
==Install PHP==
Line 37: Line 27:
 
  sudo apt -y install php php-gd php-common php-json php-imagick \
 
  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-imap php-xml php-opcache php-mbstring php-curl php-zip \
  php-bz2 php-intl  
+
  php-bz2 php-intl
 
+
  sudo apt -y install roundcube-core roundcube-sqlite3
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:)
+
Cek timezone
  
 
  vi /etc/php/8.1/apache2/php.ini
 
  vi /etc/php/8.1/apache2/php.ini
Line 92: Line 79:
  
 
==Install Roundcube==
 
==Install Roundcube==
 +
 +
Install CMS RoundCube
  
 
  cd /usr/local/src/
 
  cd /usr/local/src/
Line 99: Line 88:
 
  sudo chown www-data:www-data -R /var/www/roundcube
 
  sudo chown www-data:www-data -R /var/www/roundcube
  
Isi database roundcube, untuk untuk belajar ..
+
Init SQLite
  
  mysql -u roundcube -proundcube roundcube < /var/www/roundcube/SQL/mysql.initial.sql
+
  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
  
Isi database roundcube, untuk kerjaan serius :)
+
vi /var/www/roundcube/config/config.inc.php
  
  mysql -u dbuser -p roundcubedb < /var/www/roundcube/SQL/mysql.initial.sql
+
  $config['db_dsnw'] = 'sqlite:////var/www/roundcube/db/roundcube.sqlite?mode=0646';
  
atau,
+
Kalau semua sudah berjalan baik, pastikan
  
  mysql -u dbuser -ptestpassword roundcubedb < /var/www/roundcube/SQL/mysql.initial.sql
+
  // $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