Roundcube: Instalasi di Ubuntu: Difference between revisions

From OnnoCenterWiki
Jump to navigationJump to search
← Older editNewer edit →
Onnowpurbo (talk | contribs)
69,477 edits
Onnowpurbo (talk | contribs)
69,477 edits
No edit summary
Onnowpurbo (talk | contribs)
69,477 edits
No edit summary
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 21:53, 22 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://lms.onnocenter.or.id/wiki/index.php?title=Roundcube:_Instalasi_di_Ubuntu&oldid=52197"