Difference between revisions of "Roundcube: Instalasi di Ubuntu"

From OnnoWiki
Jump to navigation Jump to search
Line 2: Line 2:
  
  
−
Install LAMP Server
+
==Instalasi Apps Pendukung==
  
−
Before starting, you will need to install Apache, MariaDB, and PHP to your system. First, install Apache and MariaDB with the following command:
+
sudo apt-get install apache 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 -y
  
−
sudo apt-get install apache 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 -y
+
Ubah Timezone jika di perlukan
  
−
Once all the packages are installed, you will need to change Timezone setting in php.ini file. You can do this with the following command:
+
sudo vi /etc/php/7.2/apache2/php.ini
  
−
  sudo nano /etc/php/7.2/apache2/php.ini
+
  date.timezone = Asia/Jakarta
  
−
Make the following changes:
+
Start
−
 
 
−
date.timezone = Asia/Kolkata
 
−
 
 
−
Save and close the file, then start Apache and MariaDB service and enable them to start on boot time using the following command:
 
  
 
  sudo systemctl start apache2
 
  sudo systemctl start apache2
Line 23: Line 20:
 
  sudo systemctl enable mysql
 
  sudo systemctl enable mysql
  
−
Download Roundcube
+
==Download Roundcube==
−
 
 
−
First, you will need to download the latest version of Roundcube to your system. You can download it with the following command:
 
−
 
 
−
wget https://github.com/roundcube/roundcubemail/releases/download/1.3.6/roundcubemail-1.3.6-complete.tar.gz
 
  
−
Once the download is completed, extract the downloaded file with the following command:
+
Download
  
−
  tar -xvzf roundcubemail-1.3.6-complete.tar.gz
+
  wget https://github.com/roundcube/roundcubemail/releases/download/1.3.7/roundcubemail-1.3.7.tar.gz
  
−
Next, move the extracted directory to the Apache web root directory:
+
Buka & Copy
−
 
 
−
mv roundcubemail-1.3.6 /var/www/html/roundcube
 
−
 
 
−
Next, give proper permissions to the roundcube directory:
 
  
 +
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 chown -R www-data:www-data /var/www/html/roundcube
 
  sudo chmod -R 775 /var/www/html/roundcube
 
  sudo chmod -R 775 /var/www/html/roundcube
  
−
Configure the Database
 
  
−
By default, MariaDB installation is not secured. So you will need to secure it first. You can secure it by running the following script:
+
==Database==
 +
 
 +
Jika di perlukan buat menjadi secure
  
 
  mysql_secure_installation
 
  mysql_secure_installation
−
 
−
Answer all the questions as shown below:
 
  
 
  Change the password for root ? N
 
  Change the password for root ? N
Line 56: Line 46:
 
  Reload privilege tables now? Y
 
  Reload privilege tables now? Y
  
−
Once the MariaDB is secured, login to MariaDB shell using the following command:
+
Konfigurasi database
  
 
  mysql -u root -p
 
  mysql -u root -p
−
 
−
Enter your root passw**ord, then create a database and user for Roundcube:
 
  
 
  MariaDB [(none)]> CREATE DATABASE roundcubedb;
 
  MariaDB [(none)]> CREATE DATABASE roundcubedb;
 
  MariaDB [(none)]> CREATE USER 'roundcube'@'localhost' IDENTIFIED BY 'password';
 
  MariaDB [(none)]> CREATE USER 'roundcube'@'localhost' IDENTIFIED BY 'password';
 
  MariaDB [(none)]> GRANT ALL PRIVILEGES ON roundcubedb.* to 'roundcube'@'localhost';
 
  MariaDB [(none)]> GRANT ALL PRIVILEGES ON roundcubedb.* to 'roundcube'@'localhost';
−
 
−
Next, flush the privileges and exit from the MariaDB shell using the following command:
 
−
 
 
  MariaDB [(none)]> FLUSH PRIVILEGES;
 
  MariaDB [(none)]> FLUSH PRIVILEGES;
 
  MariaDB [(none)]> exit;
 
  MariaDB [(none)]> exit;
  
−
Next, you need to import initial tables to roundcubedb database. You can do this using the following command:
+
Inisialisasi database
  
 
  cd /var/www/html/roundcube
 
  cd /var/www/html/roundcube

Revision as of 04:53, 23 October 2018

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


Instalasi Apps Pendukung

sudo apt-get install apache 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 -y

Ubah Timezone jika di perlukan 

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 mysql
sudo systemctl enable mysql

Download Roundcube

Download 

wget https://github.com/roundcube/roundcubemail/releases/download/1.3.7/roundcubemail-1.3.7.tar.gz

Buka & Copy 

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 

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 -p

MariaDB [(none)]> CREATE DATABASE roundcubedb;
MariaDB [(none)]> CREATE USER 'roundcube'@'localhost' IDENTIFIED BY 'password';
MariaDB [(none)]> GRANT ALL PRIVILEGES ON roundcubedb.* to 'roundcube'@'localhost';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> exit;

Inisialisasi database 

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

Configure Apache for Roundcube

Next, you will need to create an Apache virtual host file for Roundcube. You can do this with the following command: 

sudo nano /etc/apache2/sites-available/roundcube.conf

Add the following lines: 

<VirtualHost *:80>
        ServerName 192.168.0.102                          
        ServerAdmin admin@example.com
        DocumentRoot /var/www/html/roundcube 

        ErrorLog ${APACHE_LOG_DIR}/roundcube_error.log
        CustomLog ${APACHE_LOG_DIR}/roundcube_access.log combined 

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

Save and close the file, then enable virtual host file using the following command: 

sudo a2ensite roundcube

Next, enable Apache rewrite module and restart Apache server with the following command: 

sudo a2enmod rewrite
sudo systemctl restart apache2



Referensi

Retrieved from "https://onnocenter.or.id/wiki/index.php?title=Roundcube:_Instalasi_di_Ubuntu&oldid=52197"