diff --git a/README.md b/README.md index 022ea39..cf1373e 100644 --- a/README.md +++ b/README.md @@ -95,22 +95,22 @@ #### 1. Prestashop ``` CREATE DATABASE prestashop; -GRANT ALL PRIVILEGES ON prestashop.* TO 'prestashopuser'@'localhost' IDENTIFIED BY 'prestashoppass'; +GRANT ALL PRIVILEGES ON prestashop.* TO 'prestashopuser'@'10.148.0.9' IDENTIFIED BY 'prestashoppass'; ``` #### 2. Nextcloud ``` CREATE DATABASE nextcloud; -GRANT ALL PRIVILEGES ON nextcloud.* TO 'nextclouduser'@'localhost' IDENTIFIED BY 'nextcloudpass' WITH GRANT OPTION; +GRANT ALL PRIVILEGES ON nextcloud.* TO 'nextclouduser'@'10.148.0.9' IDENTIFIED BY 'nextcloudpass' WITH GRANT OPTION; ``` #### 3. Wordpress ``` CREATE DATABASE wordpress; -GRANT ALL PRIVILEGES ON wordpress.* TO 'wordpressuser'@'localhost' IDENTIFIED BY 'wordpresspass' WITH GRANT OPTION; +GRANT ALL PRIVILEGES ON wordpress.* TO 'wordpressuser'@'10.148.0.9' IDENTIFIED BY 'wordpresspass' WITH GRANT OPTION; ``` #### 4. Phpmyadmin ``` -CREATE USER 'admin'@'%' IDENTIFIED BY 'password_here'; -GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION; +CREATE USER 'admin'@'10.148.0.9' IDENTIFIED BY 'password_here'; +GRANT ALL PRIVILEGES ON *.* TO 'admin'@'10.148.0.9' WITH GRANT OPTION; FLUSH PRIVILEGES; EXIT; ``` @@ -487,17 +487,7 @@ Installasi prestashop, wordpress, nextcloud dan phpmyadmin ============== ### 1. Prestashop -#### Step 1: Tambahkan database dan user untuk prestashop -``` -# mysql -u root -p -``` -``` -CREATE DATABASE prestashop; -GRANT ALL PRIVILEGES ON prestashop.* TO 'prestashopuser'@'localhost' IDENTIFIED BY 'prestashoppass'; -FLUSH PRIVILEGES; -EXIT; -``` -#### Step 2: Konfigurasi php untuk prestashop +#### Step 1: Konfigurasi php untuk prestashop Buka konfigurasi php.ini ``` # vim /etc/opt/remi/php71/php.ini @@ -506,17 +496,18 @@ ``` file_uploads = On allow_url_fopen = On -memory_limit = 256M -upload_max_filesize = 64M +memory_limit = 1024M +max_execution_time = 18000 +upload_max_filesize = 256M ``` -#### Step 3: Download dan konfigurasi prestashop +#### Step 2: Download dan konfigurasi prestashop Masuk ke dir root prestashop ``` # cd /home/prestashop ``` Kemudian hapus file index.html dan test.php yang sudah kita buat ``` -# rm -f index.html test.php +# rm -f test.php ``` Download prestashop ``` @@ -547,17 +538,7 @@ Selamat prestashop berhasil diinstall ### 2.Wordpress -#### Step 1: Tambahkan database dan user untuk wordpress -``` -# mysql -u root -p -``` -``` -CREATE DATABASE wordpress; -GRANT ALL PRIVILEGES ON wordpress.* TO 'wordpressuser'@'localhost' IDENTIFIED BY 'wordpresspass' WITH GRANT OPTION; -FLUSH PRIVILEGES; -EXIT; -``` -#### Step 2: Konfigurasi php untuk wordpress +#### Step 1: Konfigurasi php untuk wordpress Buka konfigurasi php.ini ``` # vim /etc/opt/remi/php72/php.ini @@ -574,7 +555,7 @@ # systemctl restart php72-php-fpm # systemctl restart httpd ``` -#### Step 3: Download dan konfigurasi wordpress +#### Step 2: Download dan konfigurasi wordpress Masuk ke dir root wordpress ``` # cd /home/wordpress @@ -597,11 +578,6 @@ # mv wordpress/* . # rm -rf wordpress ``` -Ubah permission dan kepilikan directory -``` -# chown -R wordpress:wordpress /home/wordpress -# chmod -R 755 /home/wordpress -``` Copy config sample wordpress ``` # cp /home/wordpress/wp-config-sample.php /home/wordpress/wp-config.php @@ -623,7 +599,7 @@ define('DB_PASSWORD', 'wordpresspass'); /** MySQL hostname */ -define('DB_HOST', 'localhost'); +define('DB_HOST', '10.148.0.9'); /** Database Charset to use in creating database tables. */ define('DB_CHARSET', 'utf8'); @@ -631,7 +607,12 @@ /** The Database Collate type. Don't change this if in doubt. */ define('DB_COLLATE', ''); ``` -Simpan dan keluar, kemudian akses wordpress.task.my.id +Ubah permission dan kepilikan directory +``` +# chown -R wordpress:wordpress /home/wordpress +# chmod -R 755 /home/wordpress +``` +Kemudian akses wordpress.task.my.id Setup seperti biasa @@ -639,24 +620,14 @@ Selamat wordpress berhasil diinstall ### 3. nextcloud -#### Step 1: Tambahkan database dan user untuk nextcloud -``` -# mysql -u root -p -``` -``` -CREATE DATABASE nextcloud; -GRANT ALL PRIVILEGES ON nextcloud.* TO 'nextclouduser'@'localhost' IDENTIFIED BY 'nextcloudpass' WITH GRANT OPTION; -FLUSH PRIVILEGES; -EXIT; -``` -#### Step 2: Download dan konfigurasi nextcloud +#### Step 1: Download dan konfigurasi nextcloud Masuk ke dir root nextcloud ``` # cd /home/nextcloud ``` Kemudian hapus file index.html dan test.php yang sudah kita buat ``` -# rm -f index.html test.php +# rm -f test.php ``` Download nextcloud ``` @@ -692,7 +663,7 @@ ln -s /usr/share/phpMyAdmin ``` #### Step 2: Konfigurasi virtualhost dan serverblock untuk phpmyadmin -*** 1.Konfigurasi virtualhost*** +*** 1.Konfigurasi virtualhost pana node2*** ``` # vim /etc/httpd/conf.d/phpmyadmin.conf ``` @@ -716,7 +687,7 @@ ``` -*** 2.Konfigurasi server block*** +*** 2.Konfigurasi server block pada node1*** ``` # vim /etc/nginx/conf.d/ ```