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

1548 Cannot load from mysql.proc. The table is probably corrupted

error seperti ini biasanya terjadi pada saat restore database dari Engine database yang lebih tinggi ke Engine database dengan versi lebih rendah misal database MySQL versi 5.5 di restore ke database MySQL versi 5.1

MySQL will sometimes return the error message “Cannot load from mysql.proc. The table is probably corrupted”. This happens due to schema changes required for different MySQL server versions. The simple fix to this problem is to run the mysql_upgrade command from the command line.

About mysql_upgrade

mysql_upgrade examines all tables across all databases for incompatibilities with the current version of MySQL Server. mysql_upgrade also upgrades the system tables so that you can take advantage of new privileges or capabilities that might have been added.

mysql_upgrade should be executed each time you upgrade MySQL. It supersedes the older mysql_fix_privilege_tables script, which should no longer be used.

mysql_upgrade executes the following commands to check and repair tables and to upgrade the system tables:

mysqlcheck --all-databases --check-upgrade --auto-repair

mysql < fix_priv_tables

Run mysql_upgrade From Command Line

To use mysql_upgrade, make sure your MySQL server is running and then invoke mysql_upgrade from the command line tool:

mysql_upgrade -uroot -p --force

You should then be prompted to enter the MySQL root's password and mysql_upgrade will check all the databases and tables and fix them where appropriate. You may need to specify the full path to the above command if it's not in the shell's search path.

On Debian 6 it should be loacted at:

/usr/bin/mysql_upgrade -uroot -p --force

On Mac's MAMP the default path is:

/Applications/MAMP/Library/bin/mysql_upgrade -uroot -p --force

On Windows it'll be where MySQL is installed and contained in the bin subdirectory. By default it should be located at:

"C:\Program Files\MySQL\MySQL Server\[*CHANGE TO MySQL SERVER*]\bin\mysqladmin" -u root shutdown

VICTORY!

After running mysql_upgrade, stop the server and restart it so that any changes made to the system tables are ensured to take effect.

All checked and repaired tables are marked with the current MySQL version number. This ensures that next time you run mysql_upgrade with the same version of the server, it can tell whether there is any need to check or repair the table again.

URL Sumber : http://www.myguysolutions.com/2013/10/30/how-to-resolve-mysql-error-code-1548-cannot-load-from-mysql-proc-the-table-is-probably-corrupted/