Difference between revisions of "Roundcube: Instalasi di Ubuntu"

From OnnoWiki
Jump to navigation Jump to search
Line 59: Line 59:
  
 
  mysql -u root -p123456
 
  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;
 
 
  
 
  CREATE DATABASE roundcube;
 
  CREATE DATABASE roundcube;

Revision as of 15:09, 26 October 2018

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


Instalasi Apps Pendukung

sudo su
locale-gen id_ID.UTF-8
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, buka, copy & install

cd /usr/local/src
wget https://github.com/roundcube/roundcubemail/releases/download/1.3.7/roundcubemail-1.3.7.tar.gz
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 roundcube;
CREATE USER 'roundcube'@'localhost' IDENTIFIED BY 'roundcube';
GRANT ALL on root.* to roundcube@localhost;
GRANT ALL on roundcube.* to roundcube@localhost identified by 'roundcube';
GRANT ALL on roundcube.* to roundcube identified by 'roundcube';
FLUSH PRIVILEGES;
exit;

Inisialisasi database

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

atau

 mysql -u roundcube -p roundcube < SQL/mysql.initial.sql

Masukan password "roundcube"

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/ 
        ErrorLog ${APACHE_LOG_DIR}/roundcube_error.log
        CustomLog ${APACHE_LOG_DIR}/roundcube_access.log combined 

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

Save & close file


Aktifkan

chown -Rf www-data: /var/www/
chmod -Rf 777 /var/www/
sudo a2ensite roundcube
sudo a2enmod rewrite
sudo systemctl restart apache2
/etc/init.d/dovecot restart
/etc/init.d/postfix restart

Akses Web

Akses ke

http://ip-address-server/roundcube/installer
http://192.168.0.102/roundcube/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)
  • username_domain - korban.com

NEXT PAGE

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

Referensi