Kill Process MySQL

here I go with that trick:

1. Login to MySql.
2. run that query Select concat('KILL ',id,';') from information_schema.processlist where user='user';
3. This will print all the process with KILL command.
4. Copy all the query result, manipulate them and remove pipe. sign and paste all again into the query console. HIT ENTER.

Install phpMyAdmin from Source

Install phpMyAdmin from Source

While it’s not recommended for production servers, because you have to manually ensure your install of phpMyAdmin is kept up-to-date, you can also install phpMyAdmin from source.

Step 1: Identify Apache’s DocumentRoot

We need to find Apache’s DocumentRoot so we know where to place our phpMyAdmin files:

$ grep DocumentRoot /etc/apache2/sites-available/000-default.conf         DocumentRoot /var/www/html

In this case, we’ll need to put the phpMyAdmin files in /var/www/html.

Step 2: Download Latest Version of phpMyAdmin

The stable version of phpMyAdmin at the time this article was written: phpMyAdmin 4.3.11.1 (released 3/4/2015).
Visit the phpMyAdmin download page to grab the latest version of phpMyAdmin.
I ended up with a phpMyAdmin-4.3.11.1-english.tar.gz file in my /var/www/html directory.

$ cd /var/www/html $ ls index.html phpMyAdmin-4.3.11.1-english.tar.gz

Step 3: Unpack phpMyAdmin Files

sudo tar xvzf phpMyAdmin-4.3.11.1-english.tar.gz

Now rename the phpMyAdmin-4.3.11.1-english directory:

sudo mv phpMyAdmin-4.3.11.1-english phpmyadmin

Remove the phpMyAdmin files:

sudo rm phpMyAdmin-4.3.11.1-english.tar.gz

Step 4: Secure /phpmyadmin Directory

We want to set up a specific user for our phpMyAdmin install.

$ sudo adduser phpmyadmin Adding user `phpmyadmin' ... Adding new group `phpmyadmin' (1001) ... Adding new user `phpmyadmin' (1001) with group `phpmyadmin' ... Creating home directory `/home/phpmyadmin' ... Copying files from `/etc/skel' ... Enter new UNIX password: Retype new UNIX password: passwd: password updated successfully

sudo chown -R phpmyadmin.phpmyadmin /var/www/html/phpmyadmin

Step 5: Update phpMyAdmin config.inc With Install Wizard

To use the phpMyAdmin install wizard, we first need to set up the config.inc file.

cd /var/www/html/phpmyadmin sudo mkdir config sudo chmod o+rw config sudo cp config.sample.inc.php config/config.inc.php sudo chmod o+w config/config.inc.php

Step 6: Run phpMyAdmin Install Wizard

To begin the installation of phpMyAdmin, access the installation URL at:
http://example.com/phpmyadmin/setup/index.php
Under the “Servers” section, click on “New Server.”

Under the “Servers” section, click on “New Server.”

Under the “Authentication” tab, type in your MySQL root password in the “Password for Config Auth” box and then click “Apply.”

In the “Password for Config Auth” box, type in your MySQL root password.

Remove the phpMyAdmin /config directory for security.

1	sudo rm -rf /var/www/html/phpmyadmin/config

Insert to MySQL from JSon

Contoh hasil JSon String adalah sebagai berikut :

{
    "value": 4168,
    "currency": "CREDITS",
    "expiredDate": "11-12-2018"
}

JSon diatas merupakan hasil dari : http://api.nusasms.com/api/command?user=xxx_api&password=xxx_api_password&cmd=CREDITS&output=json

Create database sms_quota pada MySQL untuk menyimpan data string tersebut
dengan tabel sebagai berikut :

quota_id, quota_tgl, quota_value, quota_currency, expiredDate

Create file cek_data.php

<?php

$host="10.201.x.x";
$username="jaxxx";
$password="xxxx";
$dbase="sms-xxx";

$connection = mysqli_connect($host,$username,$password,$dbase) or die("Error " . mysqli_error($connection));

//untuk mendapatkan file json contoh data dari API URL
$jsondata = file_get_contents('http://api.nusasms.com/api/command?user=xxx_api&password=xxx_api_password&cmd=CREDITS&output=json');

//convert json ke data array
$data = json_decode($jsondata, true);

$value = $data['value'];
$currency = $data['currency'];
$expired = $data['expiredDate'];

$sql = "INSERT INTO sms_quota(quota_tgl, quota_value, quota_currency, expiredDate)
VALUES(NOW(), '$value', '$currency', '$expired')";

if(!mysqli_query($connection, $sql)){
  die("Error insert data ");
}else{
  echo "Success insert data";
}

?>

untuk memanggil jalankan http://[alamat]/cek_data.php

Selesai.....

Insert MySQL from other host with PHP

<?php

//fecth loop data kantor Host 1
$dBIP='10.xxx.xxx.x';
$dBADN='usr_xxxxx';
$dBPWD='pwd_xxxxx';
$dBDBS="xxxxx_db";

$CONNECTW=mysql_connect($dBIP,$dBADN,$dBPWD);
mysql_select_db($dBDBS, $CONNECTW)  or die("Can't connect to second database");


function createOtherConn($host, $uname, $pass, $db) {
$conn = new mysqli($host, $uname, $pass, $db);
          if (!$conn->connect_error) {
return $conn;
          } else {
return false;
          }
}

$query = mysql_query("SELECT kantor_host FROM data_kantor WHERE kantor_status = '1'");
// $start = 0;
while ($row = mysql_fetch_array($query)) {
//SELECT dari Host 2
$kantorConn = createOtherConn($row['kantor_host'], 'usr_xxx', 'xxx123!', 'sms');
      try{
if ($kantorConn) {
$sql = "SELECT dbase_register,dbase_kantor,dbase_kode,dbase_total
                             FROM temp_dbase";
$result = $kantorConn->query($sql);
if ($result->num_rows > 0) {
while ($rowData = $result->fetch_assoc()) {
$dbReg     = $rowData['dbase_register'];
$dbKantor = $rowData['dbase_kantor'];
$dbKode    = $rowData['dbase_kode'];
$dbTotal    = $rowData['dbase_total'];

$queryIns = mysql_query("INSERT INTO temp_dbase (dbase_register, dbase_kantor, dbase_kode, dbase_total) VALUES ('$dbReg', '$dbKantor', '$dbKode', '$dbTotal')");
if ($queryIns) {
echo sprintf('Fetch data %s sukses..', $row['kantor_host']);
echo "<br/>";

} else {
echo sprintf('Fetch data %s gagal.', $row['kantor_host']);
echo "<br/>";
}
}
} else {
echo "No data to print.";
}
} else {
echo sprintf('Koneksi ke %s gagal.', $row['kantor_host']);
}
}catch(Exception $e){
echo "error :". $e->getMessage();
}
$kantorConn->close();

// if ($start >= 10) {
// break;
// }
// $start++;
}

?>

Konfigurasi HTTPS pada Website Apache2 Ubuntu Server 14.04 | Self-Signed SSL

HTTPS adalah protokol website (http) yang sudah memiliki secure yang sangat terjamin dan membuat website lebih aman dari serangan hacker. HTTPS dibuat dan memerlukan sebuah SSL Certificate untuk mensecure port HTTP. dan SSL Certifikace tersebut kita harus membelinya jika untuk website yang sudah publik.

Namun jika kita ingin belajar menggunakan virtualbox atau hanya mengatasi rasa ingin tau maka cara ini bisa anda gunakan.Ingat!! Jangan gunakan cara ini untuk Publik website ya.

Membuat Private Key (Buatlah password jika diminta):


$ openssl genrsa -des3 -out server.key 1024

Buat certificate nya :

$ openssl req -new -key server.key -out server.csr

Hapus Passpharse dari key :

$ cp server.key server.key.org
$ openssl rsa -in server.key.org -out server.key

Buat self-signed ssl nya:

$ openssl x509 -req -days 365 -in server.csr -signkey server.key -out server.crt

Copy Certificate dan Key ke directory ssl apache2 :

$ cp server.crt /usr/local/apache/conf/ssl.crt
$ cp server.key /usr/local/apache/conf/ssl.key

Kemudian tambahkan ssl tsb ke VirtualHost yang ingin dibuat HTTPS , Letakkan script dibawah sebelum tag </VirtualHost> dan jangan lupa Port *:80 diganti dengan *:443

SSLEngine on
SSLCertificateFile /usr/local/apache/conf/ssl.crt/server.crt
SSLCertificateKeyFile /usr/local/apache/conf/ssl.key/server.key


Setelah itu restart apache anda :

$ a2enmod ssl
$ a2ensite default-ssl
$ service apache2 restart

Bukalah website anda dengan protokol https, Dan jangan lupa except certificate anda untuk bisa browse. Karna dianggap unsecure terhadap browser (karena self-signed SSL :D ):

https://www.domain.com

How to Install JAVA 8 on Ubuntu

Java is the widely used programming language used by billion of application. Generally, every system required Java installed there. You may also need to Install Oracle Java 8 on your Linux system. You will require the PPA maintained by Webupd8 Team to Install Oracle JAVA 8 on Your Ubuntu and Linux System.

Read this => Install Java 8 on Debian
>Read this => Install Java 8 on CentOS, RHEL & Fedora
Use this tutorial to install Oracle JAVA 8 (JDK 8u144) on Ubuntu 17.10, 17.04, 16.04, 14.04 and 12.04 LTS and LinuxMint 18, 17 systems using PPA.

Step 1 – Install JAVA 8

First of all, you need to add webupd8team Java PPA repository in your system. After that install, Oracle Java 8 using following a set of commands.

$ sudo add-apt-repository ppa:webupd8team/java
$ sudo apt-get update
$ sudo apt-get install oracle-java8-installer

Step 2 – Verify Installed Java Version

After successfully installing Oracle Java using above step verify installed version using the following command.

rahul@tecadmin:~$ java -version 

java version "1.8.0_144"
Java(TM) SE Runtime Environment (build 1.8.0_144-b01)
Java HotSpot(TM) 64-Bit Server VM (build 25.144-b01, mixed mode)

Step 3 – Setup Java Environment

Also, install Java configuration package. It seems like below package is already installed with latest operating systems during installation of JAVA packages. But you can still make sure by running below command.

$ sudo apt-get install oracle-java8-set-default

Now add the JAVA_HOME and JRE_HOME environment variable in /etc/environment configuration file using following command.

$ cat >> /etc/environment <<EOL
JAVA_HOME=/usr/lib/jvm/java-8-oracle
JRE_HOME=/usr/lib/jvm/java-8-oracle/jre
EOL

atau bisa menggunakan metode ini

$ sudo add-apt-repository ppa:openjdk-r/ppa

jika ada pesan error spt ini

Cannot add PPA: 'ppa:openjdk-r/ppa

maka jalankan perintah ini

$ sudo apt-get install --reinstall ca-certificates

lalu jalankan kembali 

$ sudo apt-get update

selanjutnya jalankan perintah ini

$ sudo apt-get install openjdk-8-jdk

lalu chek versi javanya

$ java -version 

openjdk version "1.8.0_292"
OpenJDK Runtime Environment (build 1.8.0_292-8u292-b10-0ubuntu1~14.04-b10)
OpenJDK 64-Bit Server VM (build 25.292-b10, mixed mode)

 

ADD-APT-REPOSITORY: COMMAND NOT FOUND

The last time I encountered the add-apt-repository: command not found error I was using Ubuntu Server 12.4 Lucid. The solution then was to install python-software-properties as follows:

$ sudo apt-get install python-software-properties


This did not resolve the issue on my minimal virtual machine installation on Trusty so I installed apt-file – which is an apt package searching utility:

$ sudo apt-get install apt-file


Update apt-file:

$ apt-file update


Finally use apt-file to search for the add-apt-repository package:

$ apt-file search add-apt-repository


As you can see add-apt-repository is in software-properties-common:

software-properties-common: /usr/bin/add-apt-repository
software-properties-common: /usr/share/man/man1/add-apt-repository.1.gz


After installing software-properties-common I was able to use add-apt-repository without any further issue:

$ sudo apt-get install software-properties-common