Friday 8 October 2021

DOWNLOAD ACTIVATOR OFFICE 2016 AGAR OFFICE BISA DIPAKAI EDIT

Hoi hoi hai...., Assalamu'alaikum  semuanya,... ketemu lagi dengan kasus yang berbeda, dan ini masih kasus mengenai aplikasi, saya lagi install microsoft 2016 dan perlu aktivasi donk,...


yap ya yap...., kata kunci yang saya ketik adalah "cara mengaktifkan microsoft office 2016 dengan product key", "download activator office 2016"

dan bertemulah dengan cara ini yang direferensikan oleh "https://www.kompiwin.com/cara-aktivasi-office-2016/"

1. jadi yang pertama kita klik DOWNLOAD


@echo off

title Activate Microsoft Office 2016 ALL versions for FREE!&cls&echo ============================================================================&echo #Project: Activating Microsoft software products for FREE without software&echo ============================================================================&echo.&echo #Supported products:&echo - Microsoft Office Standard 2016&echo - Microsoft Office Professional Plus 2016&echo.&echo.&(if exist "%ProgramFiles%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles%\Microsoft Office\Office16")&(if exist "%ProgramFiles(x86)%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles(x86)%\Microsoft Office\Office16")&(for /f %%x in ('dir /b ..\root\Licenses16\proplusvl_kms*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%%x" >nul)&(for /f %%x in ('dir /b ..\root\Licenses16\proplusvl_mak*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%%x" >nul)&echo.&echo ============================================================================&echo Activating your Office...&cscript //nologo ospp.vbs /setprt:1688 >nul&cscript //nologo ospp.vbs /unpkey:WFG99 >nul&cscript //nologo ospp.vbs /unpkey:DRTFM >nul&cscript //nologo ospp.vbs /unpkey:BTDRB >nul&cscript //nologo ospp.vbs /unpkey:CPQVG >nul&cscript //nologo ospp.vbs /inpkey:XQNVK-8JYDB-WJ9W3-YJ8YR-WFG99 >nul&set i=1
:server
if %i%==1 set KMS=kms7.MSGuides.com
if %i%==2 set KMS=kms8.MSGuides.com
if %i%==3 set KMS=kms9.MSGuides.com
if %i%==4 goto notsupported
cscript //nologo ospp.vbs /sethst:%KMS% >nul&echo ============================================================================&echo.&echo.
cscript //nologo ospp.vbs /act | find /i "successful" && (echo.&echo ============================================================================&echo.&echo #My official blog: MSGuides.com&echo.&echo #How it works: bit.ly/kms-server&echo.&echo #Please feel free to contact me at msguides.com@gmail.com if you have any questions or concerns.&echo.&echo #Please consider supporting this project: donate.msguides.com&echo #Your support is helping me keep my servers running everyday!&echo.&echo ============================================================================&choice /n /c YN /m "Would you like to visit my blog [Y,N]?" & if errorlevel 2 exit) || (echo The connection to my KMS server failed! Trying to connect to another one... & echo Please wait... & echo. & echo. & set /a i+=1 & goto server)
explorer "http://MSGuides.com"&goto halt
:notsupported
echo.&echo ============================================================================&echo Sorry! Your version is not supported.&echo Please try installing the latest version here: bit.ly/downloadmsp
:halt
pause >nul

2. KLIK BLOCK SCRIPT DIATAS ATAU YANG ADA DI LINK DOWNLOAD
3. KLIK KANAN DAN COPY, 
4. BUAT FILE NOTEPAD BARU DI DEKSTOP, KEMUDIAN PASTE KE NOTEPAD TERSEBUT
5. SAVE AS FILE NOTEPAD TERSEBUT DENGAN NAMA FILE --> active.cmd di dekstop
6. kemudian pilih jenis file --> All file dan Encoding: ANSI.
7. Kemudian klik --> SAVE AS
8. Jalankan file yang telah di save as tadi dengan cara klik kanan pilih Run Administrator,
9. Kemudian Tunggu sampai selesai

Setelah tampil tulisan success seperti gambar diatas, tutup kemudian jalankan microsoft kalian.

NOTE: Pastikan Windows defender dan antivirus kalian di off kan dan di exit (dinonaktifkan)

Semoga bermanfaat, Wassalamu'alaikum.

Continue reading DOWNLOAD ACTIVATOR OFFICE 2016 AGAR OFFICE BISA DIPAKAI EDIT

Wednesday 7 April 2021

Monday 22 February 2021

INSERT MULTI KOLOM KE MYSQL MENGGUNAKAN ARRAY MULTI DIMENSI


Assalamu'alaikum warah matullahi wabarakaatuh.

Hari ini, melalui blog ini saya mau share hasil analisis saya nih teman-teman, buat kalian yang masih cari tutorial menyimpan array multi dimensi menggunakan PHP ini nih, saya shar buat kalian source codenya ya, untuk  tampilannya bisa kalian lihat gambar dibawah ini kuy.... let's get it! :)


Array Multidiminesi  memang ya, agak perlu banyak pemahaman buat saya , :D




ini ada contoh dari cuplikan projek untuk kuisionare yang bisa kalian adopsi ya, 





<?php
include 'config.php'//require_once

//Periksa Jika formulir dikirim, masukkan data formulir ke tabel pengguna.
if(isset($_POST['kirim'])) {
  $L = $_POST['layanan'];
  //$s1 = $_POST['s1'];
  $k1 = $_POST['kenyataan1'];
  $h1 = $_POST['harapan1'];
  
  //$s2 = $_POST['s2'];
  $k2 = $_POST['kenyataan2'];
  $h2 = $_POST['harapan2'];

  //$s3 = $_POST['s3'];
  $k3 = $_POST['kenyataan3'];
  $h3 = $_POST['harapan3'];

  //$s4 = $_POST['s4'];
  $k4 = $_POST['kenyataan4'];
  $h4 = $_POST['harapan4']; 

  //$s5 = $_POST['soal'];
  $k5 = $_POST['kenyataan5'];
  $h5 = $_POST['harapan5'];
  
  //$s6 = $_POST['s6'];
  $k6 = $_POST['kenyataan6'];
  $h6 = $_POST['harapan6'];

  //$s7 = $_POST['s7'];
  $k7 = $_POST['kenyataan7'];
  $h7 = $_POST['harapan7'];

  //$s8 = $_POST['s8'];
  $k8 = $_POST['kenyataan8'];
  $h8 = $_POST['harapan8'];
  
  $soal = $_POST['soal'];
  $jumlah_dipilih = count($soal);

//untuk konversi array
$aLimplode('\'\''$L);//alpha

$ak1implode('\'\''$k1);//alpha
$ak2implode('\'\''$k2);//y
$ak3implode('\'\''$k3);//kernel
$ak4implode('\'\''$k4);//bias
$ak5implode('\'\''$k5);//alpha
$ak6implode('\'\''$k6);//y
$ak7implode('\'\''$k7);//kernel
$ak8implode('\'\''$k8);//bias

//untuk konversi array
$ah1implode('\'\''$h1);//alpha
$ah2implode('\'\''$h2);//y
$ah3implode('\'\''$h3);//kernel
$ah4implode('\'\''$h4);//bias
$ah5implode('\'\''$h5);//alpha
$ah6implode('\'\''$h6);//y
$ah7implode('\'\''$h7);//kernel
$ah8implode('\'\''$h8);//bias


    $data = [
      "soal1"=>["layanan" => $aL,"kenyataan" => $ak1"harapan" => $ah1],
      "soal2"=>["layanan" => $aL,"kenyataan" => $ak2"harapan" => $ah2],
      "soal3"=>["layanan" => $aL,"kenyataan" => $ak3"harapan" => $ah3],
      "soal4"=>["layanan" => $aL,"kenyataan" => $ak4"harapan" => $ah4],
      "soal5"=>["layanan" => $aL,"kenyataan" => $ak5"harapan" => $ah5],
      "soal6"=>["layanan" => $aL,"kenyataan" => $ak6"harapan" => $ah6],
      "soal7"=>["layanan" => $aL,"kenyataan" => $ak7"harapan" => $ah7],
      "soal8"=>["layanan" => $aL,"kenyataan" => $ak8"harapan" => $ah8]
    ];

$index = 0;
$sql = "INSERT INTO nilai_survei (layanan, soal, kenyataan, harapan) VALUES ";
    foreach($data as $index => $dataInfo) { 
     
      $sql .= "('".$dataInfo['layanan']."','".$index."','".$dataInfo['kenyataan']."','".$dataInfo['harapan']."'),";
      $index++;
  } 
  
  $sql = substr($sql0strlen($sql) - 1).";";

  echo "Data telah masuk""$sql";

  // Eksekusi $query
  mysqli_query($link$sql);

}

?>


ini penting untuk membuat looping insert dengan tiga kolom pada sebuah tabel:
foreach($data as $index => $dataInfo) { 
     
      $sql .= "('".$dataInfo['layanan']."','".$index."','".$dataInfo['kenyataan']."','".$dataInfo['harapan']."'),";
      $index++;
  } 


Continue reading INSERT MULTI KOLOM KE MYSQL MENGGUNAKAN ARRAY MULTI DIMENSI

Tuesday 27 October 2020

Install ambari di centos 7 dan membuka web ambari

Rssfeed: https://basicvisualnet.blogspot.com///feeds/posts/default?alt=rss

Assalamu'alaikum teman - temaaannn...

tadi di kelas, gue merasa iya gitu deeeh karena error muluuu

jangan lupa rubah security grup: menjadi dari SSH menjadi "all traffic" dan kolom sebelahnya lagi rubah menjadi "anywhere"



disini gue highlight yang bikin sukses.

login as: ec2-user
Authenticating with public key "imported-openssh-key"
[ec2-user@ip-172-31-31-196 ~]$ sudo chconfig ntpd on
sudo: chconfig: command not found
[ec2-user@ip-172-31-31-196 ~]$ sudo su -
[root@ip-172-31-31-196 ~]# sudo chkconfig ntpd on
error reading information on service ntpd: No such file or directory
[root@ip-172-31-31-196 ~]# yum install wget
Loaded plugins: amazon-id, rhui-lb, search-disabled-repos
rhui-REGION-client-config-server-7                       | 2.9 kB     00:00
rhui-REGION-rhel-server-releases                         | 3.5 kB     00:00
rhui-REGION-rhel-server-rh-common                        | 3.8 kB     00:00
(1/7): rhui-REGION-client-config-server-7/x86_64/primary_d | 3.3 kB   00:00
(2/7): rhui-REGION-rhel-server-releases/7Server/x86_64/gro | 774 kB   00:00
(3/7): rhui-REGION-rhel-server-rh-common/7Server/x86_64/gr |  124 B   00:00
(4/7): rhui-REGION-rhel-server-rh-common/7Server/x86_64/up |  33 kB   00:00
(5/7): rhui-REGION-rhel-server-releases/7Server/x86_64/upd | 3.2 MB   00:00
(6/7): rhui-REGION-rhel-server-rh-common/7Server/x86_64/pr | 117 kB   00:00
(7/7): rhui-REGION-rhel-server-releases/7Server/x86_64/pri |  57 MB   00:00
Resolving Dependencies
--> Running transaction check
---> Package wget.x86_64 0:1.14-18.el7_6.1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package Arch      Version            Repository                           Size
================================================================================
Installing:
 wget    x86_64    1.14-18.el7_6.1    rhui-REGION-rhel-server-releases    547 k

Transaction Summary
================================================================================
Install  1 Package

Total download size: 547 k
Installed size: 2.0 M
Is this ok [y/d/N]: y
Downloading packages:
wget-1.14-18.el7_6.1.x86_64.rpm                            | 547 kB   00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : wget-1.14-18.el7_6.1.x86_64                                  1/1
  Verifying  : wget-1.14-18.el7_6.1.x86_64                                  1/1

Installed:
  wget.x86_64 0:1.14-18.el7_6.1

Complete!
[root@ip-172-31-31-196 ~]# yum install nano
Loaded plugins: amazon-id, rhui-lb, search-disabled-repos
Resolving Dependencies
--> Running transaction check
---> Package nano.x86_64 0:2.3.1-10.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package Arch      Version            Repository                           Size
================================================================================
Installing:
 nano    x86_64    2.3.1-10.el7       rhui-REGION-rhel-server-releases    440 k

Transaction Summary
================================================================================
Install  1 Package

Total download size: 440 k
Installed size: 1.6 M
Is this ok [y/d/N]: y
Downloading packages:
nano-2.3.1-10.el7.x86_64.rpm                               | 440 kB   00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : nano-2.3.1-10.el7.x86_64                                     1/1
  Verifying  : nano-2.3.1-10.el7.x86_64                                     1/1

Installed:
  nano.x86_64 0:2.3.1-10.el7

Complete!
[root@ip-172-31-31-196 ~]# wget -nv http://public-repo-1.hortonworks.com/ambari/centos7/2.x/updates/2.7.0.0/ambari.repo -O /etc/yum.repos.d/ambari.repo
2019-07-29 09:28:02 URL:http://public-repo-1.hortonworks.com/ambari/centos7/2.x/updates/2.7.0.0/ambari.repo [376/376] -> "/etc/yum.repos.d/ambari.repo" [1]
[root@ip-172-31-31-196 ~]# yum install ambari-server
Loaded plugins: amazon-id, rhui-lb, search-disabled-repos
ambari-2.7.0.0                                           | 2.9 kB     00:00
ambari-2.7.0.0/primary_db                                  |  25 kB   00:00
Resolving Dependencies
--> Running transaction check
---> Package ambari-server.x86_64 0:2.7.0.0-897 will be installed
--> Processing Dependency: postgresql-server >= 8.1 for package: ambari-server-2.7.0.0-897.x86_64
--> Running transaction check
---> Package postgresql-server.x86_64 0:9.2.24-1.el7_5 will be installed
--> Processing Dependency: postgresql(x86-64) = 9.2.24-1.el7_5 for package: postgresql-server-9.2.24-1.el7_5.x86_64
--> Processing Dependency: postgresql-libs(x86-64) = 9.2.24-1.el7_5 for package: postgresql-server-9.2.24-1.el7_5.x86_64
--> Processing Dependency: libpq.so.5()(64bit) for package: postgresql-server-9.2.24-1.el7_5.x86_64
--> Running transaction check
---> Package postgresql.x86_64 0:9.2.24-1.el7_5 will be installed
---> Package postgresql-libs.x86_64 0:9.2.24-1.el7_5 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package           Arch   Version        Repository                        Size
================================================================================
Installing:
 ambari-server     x86_64 2.7.0.0-897    ambari-2.7.0.0                   367 M
Installing for dependencies:
 postgresql        x86_64 9.2.24-1.el7_5 rhui-REGION-rhel-server-releases 3.0 M
 postgresql-libs   x86_64 9.2.24-1.el7_5 rhui-REGION-rhel-server-releases 234 k
 postgresql-server x86_64 9.2.24-1.el7_5 rhui-REGION-rhel-server-releases 3.8 M

Transaction Summary
================================================================================
Install  1 Package (+3 Dependent packages)

Total download size: 374 M
Installed size: 468 M
Is this ok [y/d/N]: y
Downloading packages:
(1/4): postgresql-libs-9.2.24-1.el7_5.x86_64.rpm           | 234 kB   00:00
(2/4): postgresql-server-9.2.24-1.el7_5.x86_64.rpm         | 3.8 MB   00:00
(3/4): postgresql-9.2.24-1.el7_5.x86_64.rpm                | 3.0 MB   00:00
warning: /var/cache/yum/x86_64/7Server/ambari-2.7.0.0/packages/ambari-server-2.7.0.0-897.x86_64.rpm: Header V4 RSA/SHA1 Signature, key ID 07513cad: NOKEY
Public key for ambari-server-2.7.0.0-897.x86_64.rpm is not installed
(4/4): ambari-server-2.7.0.0-897.x86_64.rpm                | 367 MB   00:05
--------------------------------------------------------------------------------
Total                                               67 MB/s | 374 MB  00:05
Retrieving key from http://public-repo-1.hortonworks.com/ambari/centos7/2.x/updates/2.7.0.0/RPM-GPG-KEY/RPM-GPG-KEY-Jenkins
Importing GPG key 0x07513CAD:
 Userid     : "Jenkins (HDP Builds) <jenkin@hortonworks.com>"
 Fingerprint: df52 ed4f 7a3a 5882 c099 4c66 b973 3a7a 0751 3cad
 From       : http://public-repo-1.hortonworks.com/ambari/centos7/2.x/updates/2.7.0.0/RPM-GPG-KEY/RPM-GPG-KEY-Jenkins
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : postgresql-libs-9.2.24-1.el7_5.x86_64                        1/4
  Installing : postgresql-9.2.24-1.el7_5.x86_64                             2/4
  Installing : postgresql-server-9.2.24-1.el7_5.x86_64                      3/4
  Installing : ambari-server-2.7.0.0-897.x86_64                             4/4
  Verifying  : postgresql-server-9.2.24-1.el7_5.x86_64                      1/4
  Verifying  : postgresql-libs-9.2.24-1.el7_5.x86_64                        2/4
  Verifying  : ambari-server-2.7.0.0-897.x86_64                             3/4
  Verifying  : postgresql-9.2.24-1.el7_5.x86_64                             4/4

Installed:
  ambari-server.x86_64 0:2.7.0.0-897

Dependency Installed:
  postgresql.x86_64 0:9.2.24-1.el7_5
  postgresql-libs.x86_64 0:9.2.24-1.el7_5
  postgresql-server.x86_64 0:9.2.24-1.el7_5

Complete!
[root@ip-172-31-31-196 ~]# ambari-server setup
Using python  /usr/bin/python
Setup ambari-server
Checking SELinux...
SELinux status is 'enabled'
SELinux mode is 'enforcing'
Temporarily disabling SELinux
WARNING: SELinux is set to 'permissive' mode and temporarily disabled.
OK to continue [y/n] (y)? y
Customize user account for ambari-server daemon [y/n] (n)? n
Adjusting ambari-server permissions and ownership...
Checking firewall status...
Checking JDK...
[1] Oracle JDK 1.8 + Java Cryptography Extension (JCE) Policy Files 8
[2] Custom JDK
==============================================================================
Enter choice (1): 1
To download the Oracle JDK and the Java Cryptography Extension (JCE) Policy Files you must accept the license terms found at http://www.oracle.com/technetwork/java/javase/terms/license/index.html and not accepting will cancel the Ambari Server setup and you must install the JDK and JCE files manually.
Do you accept the Oracle Binary Code License Agreement [y/n] (y)? y
Downloading JDK from http://public-repo-1.hortonworks.com/ARTIFACTS/jdk-8u112-linux-x64.tar.gz to /var/lib/ambari-server/resources/jdk-8u112-linux-x64.tar.gz
jdk-8u112-linux-x64.tar.gz... 100% (174.7 MB of 174.7 MB)
Successfully downloaded JDK distribution to /var/lib/ambari-server/resources/jdk-8u112-linux-x64.tar.gz
Installing JDK to /usr/jdk64/
Successfully installed JDK to /usr/jdk64/
Downloading JCE Policy archive from http://public-repo-1.hortonworks.com/ARTIFACTS/jce_policy-8.zip to /var/lib/ambari-server/resources/jce_policy-8.zip

Successfully downloaded JCE Policy archive to /var/lib/ambari-server/resources/jce_policy-8.zip
Installing JCE policy...
Check JDK version for Ambari Server...
JDK version found: 8
Minimum JDK version is 8 for Ambari. Skipping to setup different JDK for Ambari Server.
Checking GPL software agreement...
GPL License for LZO: https://www.gnu.org/licenses/old-licenses/gpl-2.0.en.html
Enable Ambari Server to download and install GPL Licensed LZO packages [y/n] (n)? n
Completing setup...
Configuring database...
Enter advanced database configuration [y/n] (n)? y
Configuring database...
==============================================================================
Choose one of the following options:
[1] - PostgreSQL (Embedded)
[2] - Oracle
[3] - MySQL / MariaDB
[4] - PostgreSQL
[5] - Microsoft SQL Server (Tech Preview)
[6] - SQL Anywhere
[7] - BDB
==============================================================================
Enter choice (1): 1
Database admin user (postgres):
Database name (ambari):
Postgres schema (ambari):
Username (ambari):
Enter Database Password (bigdata):
Default properties detected. Using built-in database.
Configuring ambari database...
Checking PostgreSQL...
Running initdb: This may take up to a minute.
Initializing database ... OK


About to start PostgreSQL
Configuring local database...
Configuring PostgreSQL...
Restarting PostgreSQL
Creating schema and user...
done.
Creating tables...
done.
Extracting system views...
ambari-admin-2.7.0.0.897.jar
....
Ambari repo file contains latest json url http://public-repo-1.hortonworks.com/HDP/hdp_urlinfo.json, updating stacks repoinfos with it...
Adjusting ambari-server permissions and ownership...
Ambari Server 'setup' completed successfully.
[root@ip-172-31-31-196 ~]# nano /etc/selinux/config
[root@ip-172-31-31-196 ~]# ambari-server setup
Using python  /usr/bin/python
Setup ambari-server
Checking SELinux...
SELinux status is 'enabled'
SELinux mode is 'permissive'
WARNING: SELinux is set to 'permissive' mode and temporarily disabled.
OK to continue [y/n] (y)? y
Customize user account for ambari-server daemon [y/n] (n)? y
Enter user account for ambari-server daemon (root):
Adjusting ambari-server permissions and ownership...
Checking firewall status...
Checking JDK...
Do you want to change Oracle JDK [y/n] (n)? n
Check JDK version for Ambari Server...
JDK version found: 8
Minimum JDK version is 8 for Ambari. Skipping to setup different JDK for Ambari Server.
Checking GPL software agreement...
GPL License for LZO: https://www.gnu.org/licenses/old-licenses/gpl-2.0.en.html
Enable Ambari Server to download and install GPL Licensed LZO packages [y/n] (n)? n
Completing setup...
Configuring database...
Enter advanced database configuration [y/n] (n)? y
Configuring database...
==============================================================================
Choose one of the following options:
[1] - PostgreSQL (Embedded)
[2] - Oracle
[3] - MySQL / MariaDB
[4] - PostgreSQL
[5] - Microsoft SQL Server (Tech Preview)
[6] - SQL Anywhere
[7] - BDB
==============================================================================
Enter choice (1): 1
Database admin user (postgres):
Database name (ambari):
Postgres schema (ambari):
Username (ambari):
Enter Database Password (bigdata):
Default properties detected. Using built-in database.
Configuring ambari database...
Checking PostgreSQL...
Configuring local database...
Configuring PostgreSQL...
Backup for pg_hba found, reconfiguration not required
Creating schema and user...
done.
Creating tables...
done.
Extracting system views...
.....
Ambari repo file contains latest json url http://public-repo-1.hortonworks.com/HDP/hdp_urlinfo.json, updating stacks repoinfos with it...
Adjusting ambari-server permissions and ownership...
Ambari Server 'setup' completed successfully.
[root@ip-172-31-31-196 ~]# sestatus
SELinux status:                 enabled
SELinuxfs mount:                /sys/fs/selinux
SELinux root directory:         /etc/selinux
Loaded policy name:             targeted
Current mode:                   permissive
Mode from config file:          disabled
Policy MLS status:              enabled
Policy deny_unknown status:     allowed
Max kernel policy version:      31
[root@ip-172-31-31-196 ~]# pkill -9 yum (lakukan perintah itu jika saat perintah install "yum" tidak dapat berhenti dan merepotkan)
[root@ip-172-31-31-196 ~]# sestatus
SELinux status:                 enabled
SELinuxfs mount:                /sys/fs/selinux
SELinux root directory:         /etc/selinux
Loaded policy name:             targeted
Current mode:                   permissive
Mode from config file:          disabled
Policy MLS status:              enabled
Policy deny_unknown status:     allowed
Max kernel policy version:      31
[root@ip-172-31-31-196 ~]# wget -nv http://public-repo-1.hortonworks.com/ambari/centos7/2.x/updates/2.2.2.0/ambari.repo -O /etc/yum.repos.d/ambari.repo
2019-07-29 09:42:08 URL:http://public-repo-1.hortonworks.com/ambari/centos7/2.x/updates/2.2.2.0/ambari.repo [287/287] -> "/etc/yum.repos.d/ambari.repo" [1]
[root@ip-172-31-31-196 ~]# ambari-server setup
Using python  /usr/bin/python
Setup ambari-server
Checking SELinux...
SELinux status is 'enabled'
SELinux mode is 'permissive'
WARNING: SELinux is set to 'permissive' mode and temporarily disabled.
OK to continue [y/n] (y)? y
Customize user account for ambari-server daemon [y/n] (n)? y
Enter user account for ambari-server daemon (root):
Adjusting ambari-server permissions and ownership...
Checking firewall status...
Checking JDK...
Do you want to change Oracle JDK [y/n] (n)?
Check JDK version for Ambari Server...
JDK version found: 8
Minimum JDK version is 8 for Ambari. Skipping to setup different JDK for Ambari Server.
Checking GPL software agreement...
GPL License for LZO: https://www.gnu.org/licenses/old-licenses/gpl-2.0.en.html
Enable Ambari Server to download and install GPL Licensed LZO packages [y/n] (n)?
Completing setup...
Configuring database...
Enter advanced database configuration [y/n] (n)?
Configuring database...
Default properties detected. Using built-in database.
Configuring ambari database...
Checking PostgreSQL...
Configuring local database...
Configuring PostgreSQL...
Backup for pg_hba found, reconfiguration not required
Creating schema and user...
done.
Creating tables...
done.
Extracting system views...
.....
Ambari repo file doesn't contain latest json url, skipping repoinfos modification
Adjusting ambari-server permissions and ownership...
Ambari Server 'setup' completed successfully.
[root@ip-172-31-31-196 ~]# ambari-server start
Using python  /usr/bin/python
Starting ambari-server
Ambari Server running with administrator privileges.
Organizing resource files at /var/lib/ambari-server/resources...
Ambari database consistency check started...
Server PID at: /var/run/ambari-server/ambari-server.pid
Server out at: /var/log/ambari-server/ambari-server.out
Server log at: /var/log/ambari-server/ambari-server.log
Waiting for server start.......................
Server started listening on 8080

DB configs consistency check: no errors and warnings were found.
Ambari Server 'start' completed successfully.
[root@ip-172-31-31-196 ~]#

jika "Ambari Server 'start' completed successfully." maka segera pindahkan public DNS(IPV4) kamu ke new tab di google chroom, jangan lupa tambahkan :8080 di belakangnya.


Continue reading Install ambari di centos 7 dan membuka web ambari

Sunday 6 September 2020

DESAIN BLOGSPOT UNTUK TOKO ONLINE

Hai hai hai.... selamat pagi teman-teman, jadi seperti yang tertulis di judul diatas,di sesi kali ini saya akan membahas tentang desain toko online dengan memanfaatkan akun blogspot.,

jadi ini yang sedang saya coba develop pada minggu-minggu ini, 

nah, pada sesi ini saya ingin menunjukkan bagaimana saya memulai editnya ya. mungkin sudah bvanyak yang menjelaskan langkah-langkahnya jadi mari kita bersama-sama lakukan,

1. nah, untuk yang pertama coba download Templatenya kemudian masuk ke menu template di akun blog kalian, kemudian klik tanda panah di samping tulisan CUSTOM okay,

2. selanjutnya pilih Restore selanjutnya upload template yang kalian tadi download yang ber tipe ".xml"


okay, selanjutnya 

3. yang ketiga klik di bagian script html, klik saja biasa biar nanti saat ctr+f (mode find atau mencari kata) komputer dapat mendeteksi kata di seluruh script html yang ingin di edit.



nah, pada bagian ini kalian harus sudah mengerti dasar penulisan HTML,  
area <body> sampai </body> nantinya akan menampilkan isi dari halaman tersebut, seperti produknya, tampilan halaman yang menu nya di klik dan sebagainya...
nah untuk awal mungkin kalian bisa edit menu dari template bawaan yang tampil
silakan dicoba dulu ya ... nanti kita lanjutnkan dengan :


- menampilkan gambar slide



-mengatur menu
-menambahkan halaman hubungi kami dengan google form
-menambahkan pesan balasan otomatis setelah mengirim data pemesanan menggunakan google form
-mengatur tampilan sider
-mengatur tampilan footer
- menampilkan page
okay sementara itu dulu mungkin ada yang ingin di tambahkan  tampilannya bisa komen dibawah okayyy....
Semoga bermanfaat sampai jumpa di tulisan selanjutnya, 
Wassalamu'alaikum... :D
*To be Continue







Continue reading DESAIN BLOGSPOT UNTUK TOKO ONLINE

Monday 3 August 2020

Membuat email Konfirmasi (pengisi formulir) dan Notifikasi (pemilik formulir)


Pilih yang dilingkari merah


Hapus script bawaan dan Masukkan script berikut: 





//script email notifikasi otomatis dengan google form mrmung.com
function emailkonfirmasi(e) {
  var nama=e.values[4]; //membaca email pada kolom kolom untuk mengisi nama setelah Yth.
  var email=e.values[1]; //membaca kolom ke kolom untuk mengirimkan email balasan
  var pesan=e.values[5]; //membaca kolom kolom F

  var subject="Syarat Pencairan DRPM 2020";

  var message=createHTMLHeader();

  message+="<b>Yth. "+nama+"</b><br/>";
  message+="Terima kasih atas partisipasinya dalam pengisian Syarat Pencairan DRPM 2020<br/><br/><br/>";
  //message+="Silahkan anda buka tautan berikut untuk mengetahui Jurusan: <br/>";
  //message+="<b>Kunjungi: https://www.polines.co.id/p/ebook.html </b> <br/><br/>";

  message+="Hormat Kami,<br/><br/>";
  message+="Kepala PM<br/>";
  message+="Dr.Ir.TM, MT <br/>";

  message+=createHTMLFooter();

  MailApp.sendEmail({to:email,
                     subject:subject,
                     htmlBody:message,
                     name:"Syarat Pencairan 70% DRPM 2020"
                    });
}

//script untuk membuat email notifikasi ke email anda sebagai pemilik formulir online
function emailNotifikasi(e) {
  var nama=e.values[4]; //membaca email pada kolom kolom E
  var nip=e.values[2]; //membaca email pada kolom kolom E
  var rek=e.values[3]; //membaca email pada kolom kolom E
  var email=e.values[1]; //membaca kolom ke kolom B
  var judul=e.values[5]; //membaca kolom kolom F
  var skem=e.values[6]; //membaca kolom kolom G
  var proposal=e.values[7]; //membaca kolom kolom H
  var sptb=e.values[8]; //membaca kolom kolom I

  var subject="Syarat Pencairan 70% DRPM 2020";

  var message=createHTMLHeader();

  message+="<b>Assalamualaikum PM POL,</b><br/><br/>";
  message+="Barusan ada yang mengisi Formulir Syarat Pencairan DRPM 2020<br/>";
  message+="<b>Berikut Data Ketua Pelaksananya:</b><br/>";
  message+="Nama Ketua      :"+nama+"<br/>";
  message+="NIP             :"+nip+"<br/>";
  message+="No.Rekening     :"+rek+"<br/>";
  message+="Email           :"+email+"<br/>";
  message+="Judul           :"+judul+"<br/>";
  message+="Skema Penelitian:"+skem+"<br/>";
  message+="Proposal        :"+proposal+"<br/>";
  message+="Proposal        :"+sptb+"<br/>";

  message+=createHTMLFooter();

  MailApp.sendEmail({
    to:"emailkamu@gmail.com", //GANTI UNTUK PENERIMA NOTIFIKASI data-data yang sudah diisi
    subject:subject,
    htmlBody:message,
    name:"Syarat Pencairan 70% DRPM 2020" //Judul
  });
}

function createHTMLHeader(){
  var html="<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>";
  html+="<html xmlns='https://www.w3.org/1999/xhtml'>";
  html+="<head>";
  html+="<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />";
  html+="</head>";
  html+="<body>";
  return html;
}

function createHTMLFooter(){
  var html="</body>";
  html+="</html>";
  return html;
}




Lalu Klik Save dan kasih nama sesuai file response.

Tahap selanjutnya mengatur Pemicu notifikasi, dengan cara pilih file edit, kemudian klik pemicu proyek saat ini, nanti akan muncul halaman baru seperti dibawah ini.
Selanjutnya atur dengan klik menu- menu yang dilingkari dibawah ini:

Mengatur Pemicu email Konfirmasi:
Mengatur Pemicu email Notifikasi:

Daaan, selesai teman-teman, semoga bermanfaat :)

HASIL EMAIL NOTIFIKASI TELAH MENGISI FORMULIR



Continue reading Membuat email Konfirmasi (pengisi formulir) dan Notifikasi (pemilik formulir)

Wednesday 22 April 2020

LINK BELJAR UNTUK DEVELOP APLIKASI DENGAN EXCEL

Assalamu'alaikum rekan-rekan, the day i will share a link.
semetara ini linknya dulu ya  buat catatan.
yang mau develop aplikasi di excel cusss.... di cek cek :) 
Semoga bermanfaat :) 

yang ini sesuai dengan yang sedang saya cari, jadi mungkin kalian bisa menyesuaikan apa yang kalian cari di website ini :D

Yang mau belajar ini udah ada yang buat: 

buat link yang sudah di share saya ucapkan terimakash buat sharingnya,
untuk tulisan selanjutnya saya berencana akan share potongan code macros yang saya pakai, 

:)
terimakasih semoga bermanfaat 
Wssalamu'alaikum warah matullahi wabarakaatuh :)
#diumahaja
Continue reading LINK BELJAR UNTUK DEVELOP APLIKASI DENGAN EXCEL