Test Block Top

The Blog...
Articles, Tips & Trick and Other Interesting Information...
Tampilkan postingan dengan label Unix. Tampilkan semua postingan
Tampilkan postingan dengan label Unix. Tampilkan semua postingan
17 Mei 2012

RAR & Unrar CentOS Linux

Untuk extract atau buat archive RAR, jika anda pakai sistem operasi windows bisa dilakukan dengan terlebih dahulu install executable file (.exe) software RAR seperti WinRAR atau 7zip misalnya. Namun tidak demikian halnya dengan CentOS Linux, instalasi RAR & UNRAR dilakukan dengan mengetikkan command pada jendela terminal (bash).

Command: yum install rar & yum install unrar.


[root@linggih ~]# yum install rar
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
epel/metalink                                            | 4.1 kB     00:00
* base: centos.biz.net.id
* epel: epel.idrepo.or.id
* extras: centos.biz.net.id
* remi: rpms.famillecollet.com
* updates: centos.idrepo.or.id
base                                                     | 3.7 kB     00:00
extras                                                   | 3.5 kB     00:00
remi                                                     | 2.9 kB     00:00
updates                                                  | 3.5 kB     00:00
Setting up Install Process
No package rar available.
Error: Nothing to do
[root@linggih ~]#

Seperti yang terlihat di atas, RAR & UNRAR tidak tersedia pada yum repositories default CentOS Linux. Untuk install RAR & UNRAR via yum, rpmforge repo terlebih dahulu harus terinstall.

Install rpmforge Repo

Pertama, cek arsitektur CentOS (32-Bit atau 64-Bit). Cek command; uname -a atau uname -i

32-Bit CentOS Linux (i386)



[root@localhost ~]# uname -a
Linux localhost.localdomain 2.6.18-308.4.1.el5 #1 SMP Tue Apr 17 17:08:10 EDT 2012 i686 athlon i386 GNU/Linux
[root@localhost ~]# uname -i
i386
[root@localhost ~]#

64-Bit CentOS Linux (x86_64)



[root@linggih ~]# uname -a
Linux linggih.sytes.net 2.6.32-220.13.1.el6.x86_64 #1 SMP Tue Apr 17 23:56:34 BST 2012 x86_64 x86_64 x86_64 GNU/Linux
[root@linggih ~]# uname -i
x86_64
[root@linggih ~]#

Install rpmforge 32-Bit System



[root@localhost ~]# rpm -Uhv http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.i386.rpm
Retrieving http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.i386.rpm
warning: /var/tmp/rpm-xfer.j1iAgn: Header V3 DSA signature: NOKEY, key ID 6b8d79e6
Preparing...                ########################################### [100%]
1:rpmforge-release       ########################################### [100%]
[root@localhost ~]#

Install rpmforge 64-Bit System



[root@linggih ~]# rpm -Uhv http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm
Retrieving http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm
warning: /var/tmp/rpm-tmp.KfyCjc: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY
Preparing...                ########################################### [100%]
1:rpmforge-release       ########################################### [100%]
[root@linggih ~]#

Command di atas akan install file rpmforge.repo pada direktori /etc/yum.repos.d dan rpm-gpg key pada direktori /etc/pki. Untuk disable rpmforge repo, edit rpmforge.repo pada direktori /etc/yum.repos.d dan set value enabled ke 0.

Install RAR

Setelah rpmforge repo terinstall, sekarang RAR dapat diinstall via yum.

Command install: yum install rar



[root@linggih ~]# yum install rar
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.biz.net.id
* epel: sulawesi.idrepo.or.id
* extras: centos.biz.net.id
* remi: remirpm.mirror.gymkl.ch
* rpmforge: mirror.oscc.org.my
* updates: centos.idrepo.or.id
rpmforge                                                 | 1.1 kB     00:00
rpmforge/primary                                         | 4.0 MB     00:18
rpmforge                                                            11165/11165
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package rar.x86_64 0:3.8.0-1.el5.rf will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package      Arch            Version                   Repository         Size
================================================================================
Installing:
rar          x86_64          3.8.0-1.el5.rf            rpmforge          265 k

Transaction Summary
================================================================================
Install       1 Package(s)

Total download size: 265 k
Installed size: 546 k
Is this ok [y/N]: y
Downloading Packages:
rar-3.8.0-1.el5.rf.x86_64.rpm                            | 265 kB     00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Installing : rar-3.8.0-1.el5.rf.x86_64                                    1/1

Installed:
rar.x86_64 0:3.8.0-1.el5.rf

Complete!
[root@linggih ~]#

Install UNRAR


Command Install: yum install unrar



[root@linggih ~]# yum install unrar
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.biz.net.id
* epel: mirror.nus.edu.sg
* extras: centos.biz.net.id
* remi: remirpm.mirror.gymkl.ch
* rpmforge: mirror.oscc.org.my
* updates: centos.idrepo.or.id
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package unrar.x86_64 0:4.1.4-1.el5.rf will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package        Arch            Version                 Repository         Size
================================================================================
Installing:
unrar          x86_64          4.1.4-1.el5.rf          rpmforge          115 k

Transaction Summary
================================================================================
Install       1 Package(s)

Total download size: 115 k
Installed size: 233 k
Is this ok [y/N]: y
Downloading Packages:
unrar-4.1.4-1.el5.rf.x86_64.rpm                          | 115 kB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : unrar-4.1.4-1.el5.rf.x86_64                                  1/1

Installed:
unrar.x86_64 0:4.1.4-1.el5.rf

Complete!
[root@linggih ~]#

Contoh Penggunaan Command RAR & UNRAR

UNRAR

command: unrar x namafile.rar

Contoh:



[root@localhost plugins]# unrar x SyntaxHighlighter_1.5.1.rar

UNRAR 4.10 freeware      Copyright (c) 1993-2012 Alexander Roshal


Extracting from SyntaxHighlighter_1.5.1.rar

Creating    dp.SyntaxHighlighter                                      OK
Creating    dp.SyntaxHighlighter/Scripts                              OK
Extracting  dp.SyntaxHighlighter/Scripts/clipboard.swf                OK
Extracting  dp.SyntaxHighlighter/Scripts/shBrushCpp.js                OK
Extracting  dp.SyntaxHighlighter/Scripts/shBrushCSharp.js             OK
Extracting  dp.SyntaxHighlighter/Scripts/shBrushCss.js                OK
Extracting  dp.SyntaxHighlighter/Scripts/shBrushDelphi.js             OK
Extracting  dp.SyntaxHighlighter/Scripts/shBrushJava.js               OK
Extracting  dp.SyntaxHighlighter/Scripts/shBrushJScript.js            OK
Extracting  dp.SyntaxHighlighter/Scripts/shBrushPhp.js                OK
Extracting  dp.SyntaxHighlighter/Scripts/shBrushPython.js             OK
Extracting  dp.SyntaxHighlighter/Scripts/shBrushRuby.js               OK
Extracting  dp.SyntaxHighlighter/Scripts/shBrushSql.js                OK
Extracting  dp.SyntaxHighlighter/Scripts/shBrushVb.js                 OK
Extracting  dp.SyntaxHighlighter/Scripts/shBrushXml.js                OK
Extracting  dp.SyntaxHighlighter/Scripts/shCore.js                    OK
Creating    dp.SyntaxHighlighter/Styles                               OK
Extracting  dp.SyntaxHighlighter/Styles/SyntaxHighlighter.css         OK
Creating    dp.SyntaxHighlighter/Uncompressed                         OK
Extracting  dp.SyntaxHighlighter/Uncompressed/shBrushCpp.js           OK
Extracting  dp.SyntaxHighlighter/Uncompressed/shBrushCSharp.js        OK
Extracting  dp.SyntaxHighlighter/Uncompressed/shBrushCss.js           OK
Extracting  dp.SyntaxHighlighter/Uncompressed/shBrushDelphi.js        OK
Extracting  dp.SyntaxHighlighter/Uncompressed/shBrushJava.js          OK
Extracting  dp.SyntaxHighlighter/Uncompressed/shBrushJScript.js       OK
Extracting  dp.SyntaxHighlighter/Uncompressed/shBrushPhp.js           OK
Extracting  dp.SyntaxHighlighter/Uncompressed/shBrushPython.js        OK
Extracting  dp.SyntaxHighlighter/Uncompressed/shBrushRuby.js          OK
Extracting  dp.SyntaxHighlighter/Uncompressed/shBrushSql.js           OK
Extracting  dp.SyntaxHighlighter/Uncompressed/shBrushVb.js            OK
Extracting  dp.SyntaxHighlighter/Uncompressed/shBrushXml.js           OK
Extracting  dp.SyntaxHighlighter/Uncompressed/shCore.js               OK
All OK
[root@localhost plugins]#

Buat archive RAR

Command: rar a target-rar.rar target-file



[root@localhost plugins]# rar a testing.rar testing.php

RAR 3.80   Copyright (c) 1993-2008 Alexander Roshal   16 Sep 2008
Shareware version         Type RAR -? for help

Evaluation copy. Please register.

Creating archive testing.rar

Adding    testing.php                                                 OK
Done
[root@localhost plugins]#

Buat archive split RAR

Menggunakan command RAR untuk compress dan split file menjadi beberapa bagian. Untuk file yang berukuran besar (tergantung spesifikasi mesin komputer), anda harus tunggu beberapa saat sampai proses split & compress selesai.

Contoh: Ukuran file kurang lebih 122 MB MySQL dump, target size per split 20 MB, hasil split 5 file berukuran 20 MB & 1 file berukuran 18 MB.

Command: rar a -v?????k target-rar.rar target-file



[root@localhost ~]# rar a -v20480k kompres-sql.rar gede_database.sql

RAR 3.80   Copyright (c) 1993-2008 Alexander Roshal   16 Sep 2008
Shareware version         Type RAR -? for help

Evaluation copy. Please register.

Creating archive kompres-sql.rar

Adding    gede_database.sql
Calculating the control sum

Creating archive kompres-sql.part2.rar

...       gede_database.sql
Calculating the control sum

Creating archive kompres-sql.part3.rar

...       gede_database.sql
Calculating the control sum

Creating archive kompres-sql.part4.rar

...       gede_database.sql
Calculating the control sum

Creating archive kompres-sql.part5.rar

...       gede_database.sql
Calculating the control sum

Creating archive kompres-sql.part6.rar

...       gede_database.sql                                           OK
Calculating the control sum
Done
You have new mail in /var/spool/mail/root
[root@localhost ~]#

Split RAR Linux

Split RAR Linux

Extract Multiple Split File RAR

untuk extract multiple split file RAR ketikkan command:

unrar x namafile.part1.rar



[root@localhost ~]# unrar x kompres-sql.part1.rar

UNRAR 4.10 freeware      Copyright (c) 1993-2012 Alexander Roshal


Extracting from kompres-sql.part1.rar

Extracting  gede_database.sql                                         17%

Extracting from kompres-sql.part2.rar

...         gede_database.sql                                         34%

Extracting from kompres-sql.part3.rar

...         gede_database.sql                                         51%

Extracting from kompres-sql.part4.rar

...         gede_database.sql                                         68%

Extracting from kompres-sql.part5.rar

...         gede_database.sql                                         85%

Extracting from kompres-sql.part6.rar

...         gede_database.sql                                         OK
All OK
[root@localhost ~]#

UNRAR Split RAR Linux

UNRAR Split RAR Linux

05 Mei 2012

Ubuntu Server "Setup Home Dedicated Server"

Pada kesempatan kali ini saya akan mencoba menuliskan cara install home dedicated server gratis menggunakan komputer rumah. Sistem Operasi yang akan dipakai menggunakan Ubuntu Server 64 bit, aplikasi web yang dipakai menggunakan Apache, MySQL dan PHP, sedangkan script untuk test website akan menggunakan WordPress.

Ada beberapa alasan kenapa harus coba buat dedicated server sendiri di rumah, diantaranya adalah membiasakan diri (latihan) manage dedicated server jika mungkin kedepannya anda berniat untuk sewa dedicated server, bebas untuk modifikasi (coba-coba) server tanpa takut mengeluarkan biaya perbaikan error server dan yang pasti gratis. Sekarang mari mulai!

Syarat Minimal Home Dedicated Server

Yang diperlukan untuk install home dedicated server diantaranya:
  1. Seperangkat komputer (tidak harus bagus / asal komputer bisa berjalan normal) dengan support koneksi internet
  2. CD untuk burning sistem operasi server
  3. Sistem Operasi Server (Server Operating System), pada tutorial ini akan menggunakan Ubuntu Server 64 bit
  4. OpenSSH Server untuk remote server
  5. Aplikasi Web (Web Application), menggunakan Apache, MySQL dan PHP
  6. Firewall untuk membuat batasan akses

Download Ubuntu Server

Download OS Ubuntu server pada halaman ini. Pilih arsitektur OS 32 bit atau 64 bit (untuk RAM/Memory di atas 3 GB), sesuaikan dengan komputer di rumah anda kemudian klik tombol Start download. Setelah download selesai, burn file ISO ke CD menggunakan software burning, Windows Disc Image Burner atau Nero Burning misalnya.
Download Ubuntu Server

Download Ubuntu Server

Panduan burning ISO Ubuntu dapat dilihat pada halaman ini:

https://help.ubuntu.com/community/BurningIsoHowto

Install Ubuntu Server

Setelah Ubuntu Server selesai di burning ke CD, masukkan CD pada CD/DVD Drive kemudian first boot (booting awal) setting ke CD/DVD Drive. Hal ini bisa anda lakukan dengan menekan tombol F2 atau F12 (tergantung mainboard) atau setting urutan booting (boot sequence) pada BIOS.

Setelah berhasil booting ke CD, anda akan melihat tampilan seperti pada gambar di bawah.
Install Ubuntu server

Install Ubuntu server

Pilih bahasa yang tersedia dan tekan tombol Enter. Pada tutorial ini, bahasa yang dipilih adalah Inggris (English). Layar berikutnya pilih Install Ubuntu Server & tekan tombol Enter Screenshot 1. Pilih bahasa default sesuai keinginan anda (Screenshot 2), pada tutorial ini akan menggunakan bahasa Inggris (English).

Screenshot 1

Screenshot 2

Lanjutkan proses install (beberapa screenshot tidak akan ditampilkan sampai step ini) sampai anda diminta untuk menentukan Primary Network Interface (Network Interface Card / NIC). Sesuaikan pilihan anda, pada tutorial ini primary network interface memakai eth0 (Screenshot 4).

Setelah selesai memilih primary network interface, anda akan diminta menentukan hostname (Screenshot 5). Anda bisa menentukan nama apa saja untuk bagian setting hostname ini, misal dengan nama anda (tidak harus subdomain). Pada tutorial ini hostname yang dipakai menggunakan linggih.servehttp.com.

Screenshot 3

Screenshot 4

Screenshot 5

Layar berikutnya setup user & password. Isikan nama lengkap user (Screenshot 6), kemudian tentukan username untuk user baru ini (Screenshot 7). Kemudian tentukan password untuk user yang baru saja dibuat (Screenshot 8), isikan password → tekan tombol Enter. Ketik ulang untuk verifikasi kecocokan password (screenshot 9). Encrypt home directory bebas anda tentukan (Screenshot 10), pada tutorial ini memilih opsi <Yes>. Verifikasi time zone (Screenshot 11), jika sudah benar pilih opsi <Yes> dan tekan Enter untuk melanjutkan.

Screenshot 6

Screenshot 7

Install_Ubuntu_server

Screenshot 8

Install_Ubuntu_server17

Screenshot 9

Install_Ubuntu_server18

Screenshot 10

Install_Ubuntu_server19

Screenshot 11

Sistem akan mendeteksi komponen hardware lainnya (Disk), anda akan diminta menentukan partisi. Pilih opsi Guided – use entire disk (Screenshot 12), tekan Enter.

Pada tutorial ini, hanya ada satu pilihan disk, namun jika pada komputer anda terpasang beberapa disk, opsi pilihan akan akan lebih banyak pada bagian ini (Screenshot 13). Pilih partisi sesuai keinginan anda kemudian tekan Enter.

Selanjutnya konfirmasi format partisi disk (Screenshot 14), Pilih <Yes> dan tekan Enter.
Install_Ubuntu_server20

Screenshot 12

Install_Ubuntu_server21

Screenshot 13

Install_Ubuntu_server22

Screenshot 14

Sistem akan mulai proses install untuk beberapa menit ke depan (jangka waktu install tergantung pada hardware yang dipakai). Anda akan diminta submit proxy (Screenshot 16), ini opsional (boleh dikosongkan) jika tidak ada, tekan Enter untuk malanjutkan.

Layar berikutnya opsi update terdapat tiga pilihan (Screenshot 17), pada tutorial ini akan memilih opsi No automatic updates, tekan Enter untuk melanjutkan.
Install_Ubuntu_server23

Screenshot 15

Install_Ubuntu_server24

Screenshot 16

Install_Ubuntu_server25

Screenshot 17

Software selection. Anda akan diberi beberapa pilihan install paket software, pada tutorial ini hanya akan install OpenSSH server (Screenshot 18). Pilih OpenSSH server kemudian tekan tombol Space untuk mengaktifkan (centang), jangan tekan Enter. Jika anda tekan Enter, proses setup akan dilanjutkan tanpa install OpenSSH Server. Jika OpenSSH server sudah tercentang baru tekan Enter.

Proses setup dilanjutkan dengan install software tambahan sesuai dengan opsi yang anda pilih (Screenshot 19). Layar berikutnya Install GRUB boot loader (Screenshot 20), pilih Yes dan tekan Enter.
Install_Ubuntu_server26

Screenshot 18

Install_Ubuntu_server27

Screenshot 19

Install_Ubuntu_server28

Screenshot 20

Proses install selesai (Screenshot 21). Keluarkan CD dari CD/DVD Drive kemudian tekan Enter. Sistem akan otomatis restart dengan sendirinya. Setelah sistem boot up, ketikkan user login & password. Karakter password tidak akan terlihat pada waktu diketikkan, Unix OS memang didesign seperti itu. Jangan panik, terus ketik password kemudian tekan Enter (Screenshot 22). Setelah berhasil login, anda akan melihat tampilan kurang lebih seperti pada gambar Screenshot 23.
Install_Ubuntu_server29

Screenshot 21

Install_Ubuntu_server30

Screenshot 22

Install_Ubuntu_server31

Screenshot 23

Jika sampai step ini tidak ada masalah, Selamat! Ubuntu berhasil diinstall dengan sukses. Sekarang saatnya install komponen tambahan (Web Server Component).

Update Komponen Sistem

Sebelum melanjutkan, pastikan sistem software server up-to-date. Ketikkan sudo aptitude update && sudo aptitude dist-upgrade pada jendela bash untuk update komponen sistem. Anda akan diminta lagi untuk input user password, ketikkan password kemudian tekan Enter.

Anda akan ditanya Do you want to continue? [Y/n/?] (baris 108) untuk melanjutkan proses setup berdasarkan pertimbangan install, remove & upgrade (baris 97 - 107), ketikkan Y dan tekan tombol Enter.



linggih@linggih:~$ sudo aptitude update && sudo aptitude dist-upgrade
[sudo] password for linggih:
Ign http://security.ubuntu.com precise-security InRelease
Ign http://id.archive.ubuntu.com precise InRelease
Ign http://id.archive.ubuntu.com precise-updates InRelease
Ign http://id.archive.ubuntu.com precise-backports InRelease
Get: 1 http://security.ubuntu.com precise-security Release.gpg [198 B]
Get: 2 http://id.archive.ubuntu.com precise Release.gpg [198 B]
Get: 3 http://security.ubuntu.com precise-security Release [49.6 kB]
Get: 4 http://id.archive.ubuntu.com precise-updates Release.gpg [198 B]
Get: 5 http://id.archive.ubuntu.com precise-backports Release.gpg [198 B]
Get: 6 http://id.archive.ubuntu.com precise Release [49.6 kB]
Get: 7 http://id.archive.ubuntu.com precise-updates Release [49.6 kB]
Get: 8 http://security.ubuntu.com precise-security/main Sources [3,873 B]
Get: 9 http://security.ubuntu.com precise-security/restricted Sources [14 B]
Get: 10 http://security.ubuntu.com precise-security/universe Sources [2,143 B]
Get: 11 http://security.ubuntu.com precise-security/multiverse Sources [14 B]
Get: 12 http://security.ubuntu.com precise-security/main amd64 Packages [17.9 kB]
Get: 13 http://id.archive.ubuntu.com precise-backports Release [49.6 kB]
Get: 14 http://security.ubuntu.com precise-security/restricted amd64 Packages [14 B]
Get: 15 http://security.ubuntu.com precise-security/universe amd64 Packages [3,186 B]
Get: 16 http://security.ubuntu.com precise-security/multiverse amd64 Packages [14 B]
Get: 17 http://security.ubuntu.com precise-security/main i386 Packages [17.9 kB]
Get: 18 http://id.archive.ubuntu.com precise/main Sources [934 kB]
Get: 19 http://security.ubuntu.com precise-security/restricted i386 Packages [14 B]
Get: 20 http://security.ubuntu.com precise-security/universe i386 Packages [3,190 B]
Get: 21 http://security.ubuntu.com precise-security/multiverse i386 Packages [14 B]
Hit http://security.ubuntu.com precise-security/main TranslationIndex
Hit http://security.ubuntu.com precise-security/multiverse TranslationIndex
Hit http://security.ubuntu.com precise-security/restricted TranslationIndex
Hit http://security.ubuntu.com precise-security/universe TranslationIndex
Hit http://security.ubuntu.com precise-security/main Translation-en
Hit http://security.ubuntu.com precise-security/multiverse Translation-en
Hit http://security.ubuntu.com precise-security/restricted Translation-en
Hit http://security.ubuntu.com precise-security/universe Translation-en
Get: 22 http://id.archive.ubuntu.com precise/restricted Sources [5,470 B]
Get: 23 http://id.archive.ubuntu.com precise/universe Sources [5,019 kB]
Get: 24 http://id.archive.ubuntu.com precise/multiverse Sources [155 kB]
Get: 25 http://id.archive.ubuntu.com precise/main amd64 Packages [1,273 kB]
Get: 26 http://id.archive.ubuntu.com precise/restricted amd64 Packages [8,452 B]
Get: 27 http://id.archive.ubuntu.com precise/universe amd64 Packages [4,786 kB]
Get: 28 http://id.archive.ubuntu.com precise/multiverse amd64 Packages [119 kB]
Get: 29 http://id.archive.ubuntu.com precise/main i386 Packages [1,274 kB]
Get: 30 http://id.archive.ubuntu.com precise/restricted i386 Packages [8,431 B]
Get: 31 http://id.archive.ubuntu.com precise/universe i386 Packages [4,796 kB]
Get: 32 http://id.archive.ubuntu.com precise/multiverse i386 Packages [121 kB]
Hit http://id.archive.ubuntu.com precise/main TranslationIndex
Hit http://id.archive.ubuntu.com precise/multiverse TranslationIndex
Hit http://id.archive.ubuntu.com precise/restricted TranslationIndex
Hit http://id.archive.ubuntu.com precise/universe TranslationIndex
Get: 33 http://id.archive.ubuntu.com precise-updates/main Sources [12.3 kB]
Get: 34 http://id.archive.ubuntu.com precise-updates/restricted Sources [765 B]
Get: 35 http://id.archive.ubuntu.com precise-updates/universe Sources [4,206 B]
Get: 36 http://id.archive.ubuntu.com precise-updates/multiverse Sources [14 B]
Get: 37 http://id.archive.ubuntu.com precise-updates/main amd64 Packages [36.4 kB]
Get: 38 http://id.archive.ubuntu.com precise-updates/restricted amd64 Packages [757 B]
Get: 39 http://id.archive.ubuntu.com precise-updates/universe amd64 Packages [11.5 kB]
Get: 40 http://id.archive.ubuntu.com precise-updates/multiverse amd64 Packages [14 B]
Get: 41 http://id.archive.ubuntu.com precise-updates/main i386 Packages [37.5 kB]
Get: 42 http://id.archive.ubuntu.com precise-updates/restricted i386 Packages [770 B]
Get: 43 http://id.archive.ubuntu.com precise-updates/universe i386 Packages [11.5 kB]
Get: 44 http://id.archive.ubuntu.com precise-updates/multiverse i386 Packages [14 B]
Hit http://id.archive.ubuntu.com precise-updates/main TranslationIndex
Hit http://id.archive.ubuntu.com precise-updates/multiverse TranslationIndex
Hit http://id.archive.ubuntu.com precise-updates/restricted TranslationIndex
Hit http://id.archive.ubuntu.com precise-updates/universe TranslationIndex
Get: 45 http://id.archive.ubuntu.com precise-backports/main Sources [700 B]
Get: 46 http://id.archive.ubuntu.com precise-backports/restricted Sources [14 B]
Get: 47 http://id.archive.ubuntu.com precise-backports/universe Sources [14 B]
Get: 48 http://id.archive.ubuntu.com precise-backports/multiverse Sources [14 B]
Get: 49 http://id.archive.ubuntu.com precise-backports/main amd64 Packages [559 B]
Get: 50 http://id.archive.ubuntu.com precise-backports/restricted amd64 Packages [14 B]
Get: 51 http://id.archive.ubuntu.com precise-backports/universe amd64 Packages [14 B]
Get: 52 http://id.archive.ubuntu.com precise-backports/multiverse amd64 Packages [14 B]
Get: 53 http://id.archive.ubuntu.com precise-backports/main i386 Packages [559 B]
Get: 54 http://id.archive.ubuntu.com precise-backports/restricted i386 Packages [14 B]
Get: 55 http://id.archive.ubuntu.com precise-backports/universe i386 Packages [14 B]
Get: 56 http://id.archive.ubuntu.com precise-backports/multiverse i386 Packages [14 B]
Hit http://id.archive.ubuntu.com precise-backports/main TranslationIndex
Hit http://id.archive.ubuntu.com precise-backports/multiverse TranslationIndex
Hit http://id.archive.ubuntu.com precise-backports/restricted TranslationIndex
Hit http://id.archive.ubuntu.com precise-backports/universe TranslationIndex
Hit http://id.archive.ubuntu.com precise/main Translation-en
Hit http://id.archive.ubuntu.com precise/multiverse Translation-en
Hit http://id.archive.ubuntu.com precise/restricted Translation-en
Hit http://id.archive.ubuntu.com precise/universe Translation-en
Hit http://id.archive.ubuntu.com precise-updates/main Translation-en
Hit http://id.archive.ubuntu.com precise-updates/multiverse Translation-en
Hit http://id.archive.ubuntu.com precise-updates/restricted Translation-en
Hit http://id.archive.ubuntu.com precise-updates/universe Translation-en
Hit http://id.archive.ubuntu.com precise-backports/main Translation-en
Hit http://id.archive.ubuntu.com precise-backports/multiverse Translation-en
Hit http://id.archive.ubuntu.com precise-backports/restricted Translation-en
Hit http://id.archive.ubuntu.com precise-backports/universe Translation-en
Fetched 18.9 MB in 1min 58s (159 kB/s)

The following NEW packages will be installed:
linux-headers-3.2.0-24{a} linux-headers-3.2.0-24-generic{a}
linux-image-3.2.0-24-generic
The following packages will be REMOVED:
linux-headers-3.2.0-23{u} linux-headers-3.2.0-23-generic{u}
The following packages will be upgraded:
apport libssl1.0.0 libtasn1-3 linux-headers-server linux-image-server
linux-server openssl python-apport python-problem-report
update-manager-core
10 packages upgraded, 3 newly installed, 2 to remove and 0 not upgraded.
Need to get 52.5 MB of archives. After unpacking 149 MB will be used.
Do you want to continue? [Y/n/?] Y
Get: 1 http://id.archive.ubuntu.com/ubuntu/ precise-updates/main linux-headers-3.2.0-24 all 3.2.0-24.37 [11.4 MB]
Get: 2 http://id.archive.ubuntu.com/ubuntu/ precise-updates/main linux-headers-3.2.0-24-generic amd64 3.2.0-24.37 [952 kB]
Get: 3 http://id.archive.ubuntu.com/ubuntu/ precise-updates/main linux-headers-server amd64 3.2.0.24.26 [2,538 B]
Get: 4 http://id.archive.ubuntu.com/ubuntu/ precise-updates/main libssl1.0.0 amd64 1.0.1-4ubuntu5 [1,013 kB]
Get: 5 http://id.archive.ubuntu.com/ubuntu/ precise-updates/main libtasn1-3 amd64 2.10-1ubuntu1.1 [43.3 kB]
Get: 6 http://id.archive.ubuntu.com/ubuntu/ precise-updates/main linux-image-3.2.0-24-generic amd64 3.2.0-24.37 [38.2 MB]
Get: 7 http://id.archive.ubuntu.com/ubuntu/ precise-updates/main openssl amd64 1.0.1-4ubuntu5 [524 kB]
Get: 8 http://id.archive.ubuntu.com/ubuntu/ precise-updates/main update-manager-core amd64 1:0.156.14.1 [181 kB]
Get: 9 http://id.archive.ubuntu.com/ubuntu/ precise-updates/main python-problem-report all 2.0.1-0ubuntu7 [9,550 B]
Get: 10 http://id.archive.ubuntu.com/ubuntu/ precise-updates/main python-apport all 2.0.1-0ubuntu7 [78.2 kB]
Get: 11 http://id.archive.ubuntu.com/ubuntu/ precise-updates/main apport all 2.0.1-0ubuntu7 [141 kB]
Get: 12 http://id.archive.ubuntu.com/ubuntu/ precise-updates/main linux-server amd64 3.2.0.24.26 [1,728 B]
Get: 13 http://id.archive.ubuntu.com/ubuntu/ precise-updates/main linux-image-server amd64 3.2.0.24.26 [2,540 B]
Fetched 52.5 MB in 4min 12s (208 kB/s)
Preconfiguring packages ...
Selecting previously unselected package linux-headers-3.2.0-24.
(Reading database ... 48907 files and directories currently installed.)
Unpacking linux-headers-3.2.0-24 (from .../linux-headers-3.2.0-24_3.2.0-24.37_all.deb) ...
Selecting previously unselected package linux-headers-3.2.0-24-generic.
Unpacking linux-headers-3.2.0-24-generic (from .../linux-headers-3.2.0-24-generic_3.2.0-24.37_amd64.deb) ...
Preparing to replace linux-headers-server 3.2.0.23.25 (using .../linux-headers-server_3.2.0.24.26_amd64.deb) ...
Unpacking replacement linux-headers-server ...
(Reading database ... 70909 files and directories currently installed.)
Removing linux-headers-3.2.0-23-generic ...
Removing linux-headers-3.2.0-23 ...
(Reading database ... 48913 files and directories currently installed.)
Preparing to replace libssl1.0.0 1.0.1-4ubuntu3 (using .../libssl1.0.0_1.0.1-4ubuntu5_amd64.deb) ...
Unpacking replacement libssl1.0.0 ...
Setting up libssl1.0.0 (1.0.1-4ubuntu5) ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
(Reading database ... 48913 files and directories currently installed.)
Preparing to replace libtasn1-3 2.10-1ubuntu1 (using .../libtasn1-3_2.10-1ubuntu1.1_amd64.deb) ...
Unpacking replacement libtasn1-3 ...
Selecting previously unselected package linux-image-3.2.0-24-generic.
Unpacking linux-image-3.2.0-24-generic (from .../linux-image-3.2.0-24-generic_3.2.0-24.37_amd64.deb) ...
Done.
Preparing to replace openssl 1.0.1-4ubuntu3 (using .../openssl_1.0.1-4ubuntu5_amd64.deb) ...
Unpacking replacement openssl ...
Preparing to replace update-manager-core 1:0.156.14 (using .../update-manager-core_1%3a0.156.14.1_amd64.deb) ...
Unpacking replacement update-manager-core ...
Preparing to replace python-problem-report 2.0.1-0ubuntu5 (using .../python-problem-report_2.0.1-0ubuntu7_all.deb) ...
Unpacking replacement python-problem-report ...
Preparing to replace python-apport 2.0.1-0ubuntu5 (using .../python-apport_2.0.1-0ubuntu7_all.deb) ...
Unpacking replacement python-apport ...
Preparing to replace apport 2.0.1-0ubuntu5 (using .../apport_2.0.1-0ubuntu7_all.deb) ...
apport stop/waiting
Unpacking replacement apport ...
Preparing to replace linux-server 3.2.0.23.25 (using .../linux-server_3.2.0.24.26_amd64.deb) ...
Unpacking replacement linux-server ...
Preparing to replace linux-image-server 3.2.0.23.25 (using .../linux-image-server_3.2.0.24.26_amd64.deb) ...
Unpacking replacement linux-image-server ...
Processing triggers for man-db ...
Processing triggers for ureadahead ...
ureadahead will be reprofiled on next reboot
Setting up linux-headers-3.2.0-24 (3.2.0-24.37) ...
Setting up linux-headers-3.2.0-24-generic (3.2.0-24.37) ...
Setting up linux-headers-server (3.2.0.24.26) ...
Setting up libtasn1-3 (2.10-1ubuntu1.1) ...
Setting up linux-image-3.2.0-24-generic (3.2.0-24.37) ...
Running depmod.
update-initramfs: deferring update (hook will be called later)
Examining /etc/kernel/postinst.d.
run-parts: executing /etc/kernel/postinst.d/initramfs-tools 3.2.0-24-generic /boot/vmlinuz-3.2.0-24-generic
update-initramfs: Generating /boot/initrd.img-3.2.0-24-generic
run-parts: executing /etc/kernel/postinst.d/update-notifier 3.2.0-24-generic /boot/vmlinuz-3.2.0-24-generic
run-parts: executing /etc/kernel/postinst.d/zz-update-grub 3.2.0-24-generic /boot/vmlinuz-3.2.0-24-generic
Generating grub.cfg ...
Found linux image: /boot/vmlinuz-3.2.0-24-generic
Found initrd image: /boot/initrd.img-3.2.0-24-generic
Found linux image: /boot/vmlinuz-3.2.0-23-generic
Found initrd image: /boot/initrd.img-3.2.0-23-generic
Found memtest86+ image: /boot/memtest86+.bin
done
Setting up openssl (1.0.1-4ubuntu5) ...
Setting up update-manager-core (1:0.156.14.1) ...
Setting up python-problem-report (2.0.1-0ubuntu7) ...
Setting up python-apport (2.0.1-0ubuntu7) ...
Setting up apport (2.0.1-0ubuntu7) ...
apport start/running
Setting up linux-image-server (3.2.0.24.26) ...
Setting up linux-server (3.2.0.24.26) ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place

Current status: 0 updates [-10].
linggih@linggih:~$

Setelah anda konfirmasi, sistem akan download dan install komponen update. Lama proses download & install ini tergantung dari koneksi kecepatan internet anda. Setelah update selesai, restart komputer untuk apply komponen update dengan mengetikkan command sudo shutdown -r now.



linggih@linggih:~$ sudo shutdown -r now
linggih@linggih:~$
Broadcast message from linggih@linggih
(/dev/pts/0) at 18:31 ...

The system is going down for reboot NOW!


Install Apache, MySQL & PHP

Sekarang saatnya install komponen aplikasi web. Syarat situs/website anda dapat diakses via internet, web server terlebih dahulu harus terinstall pada mesin server. Pada tutorial ini akan menggunakan web server Apache, database server menggunakan MySQL & server-side language menggunakan PHP.

Ketiga komponen aplikasi web ini sudah cukup untuk menjalankan script website/blog. Setelah ketiganya terinstall, akan dilanjutkan dengan install script WordPress untuk test website.

Install program pada Unix OS Ubuntu berbeda dengan install program pada OS seperti Windows atau OS lainya. Pada Ubuntu program harus di download & install menggunakan command line.

Untuk mulai install Apache Web Server, MySQL Database Server & PHP, ketikkan command berikut:

sudo aptitude install apache2 php5-mysql libapache2-mod-php5 mysql-server

Package manager akan download & install paket program sesuai dengan command di atas dan juga download & install dependencies tambahan jika tersedia.



linggih@linggih:~$ sudo aptitude install apache2 php5-mysql libapache2-mod-php5 mysql-server
....
....
....
php5-mysql ssl-cert{a}
0 packages upgraded, 28 newly installed, 0 to remove and 0 not upgraded.
Need to get 35.7 MB of archives. After unpacking 121 MB will be used.
The following packages have unmet dependencies:
apache2-mpm-worker : Conflicts: apache2-mpm which is a virtual package.
apache2-mpm-prefork : Conflicts: apache2-mpm which is a virtual package.
The following actions will resolve these dependencies:

Keep the following packages at their current version:
1)     apache2-mpm-worker [Not Installed]



Accept this solution? [Y/n/q/?] Y
The following NEW packages will be installed:
apache2 apache2-mpm-prefork{a} apache2-utils{a} apache2.2-bin{a}
apache2.2-common{a} libapache2-mod-php5 libapr1{a} libaprutil1{a}
libaprutil1-dbd-sqlite3{a} libaprutil1-ldap{a} libcap2{a}
libdbd-mysql-perl{a} libdbi-perl{a} libhtml-template-perl{a}
libmysqlclient18{a} libnet-daemon-perl{a} libplrpc-perl{a}
mysql-client-5.5{a} mysql-client-core-5.5{a} mysql-common{a} mysql-server
mysql-server-5.5{a} mysql-server-core-5.5{a} php5-cli{a} php5-common{a}
php5-mysql ssl-cert{a}
0 packages upgraded, 27 newly installed, 0 to remove and 0 not upgraded.
Need to get 35.7 MB of archives. After unpacking 121 MB will be used.
Do you want to continue? [Y/n/?] Y
Get: 1 http://id.archive.ubuntu.com/ubuntu/ precise/main libcap2 amd64 1:2.22-1ubuntu3 [12.0 kB]
Get: 2 http://id.archive.ubuntu.com/ubuntu/ precise/main mysql-common all 5.5.22-0ubuntu1 [13.7 kB]
Get: 3 http://id.archive.ubuntu.com/ubuntu/ precise/main libmysqlclient18 amd64 5.5.22-0ubuntu1 [946 kB]
Get: 4 http://id.archive.ubuntu.com/ubuntu/ precise/main libnet-daemon-perl all 0.48-1 [43.1 kB]
Get: 5 http://id.archive.ubuntu.com/ubuntu/ precise/main libplrpc-perl all 0.2020-2 [36.0 kB]
Get: 6 http://id.archive.ubuntu.com/ubuntu/ precise/main libdbi-perl amd64 1.616-1build2 [849 kB]
Get: 7 http://id.archive.ubuntu.com/ubuntu/ precise/main libdbd-mysql-perl amd64 4.020-1build2 [106 kB]
Get: 8 http://id.archive.ubuntu.com/ubuntu/ precise/main mysql-client-core-5.5 amd64 5.5.22-0ubuntu1 [1,926 kB]
Get: 9 http://id.archive.ubuntu.com/ubuntu/ precise/main mysql-client-5.5 amd64 5.5.22-0ubuntu1 [8,298 kB]
Get: 10 http://id.archive.ubuntu.com/ubuntu/ precise/main mysql-server-core-5.5 amd64 5.5.22-0ubuntu1 [6,022 kB]
Get: 11 http://id.archive.ubuntu.com/ubuntu/ precise/main mysql-server-5.5 amd64 5.5.22-0ubuntu1 [8,816 kB]
Get: 12 http://id.archive.ubuntu.com/ubuntu/ precise/main libapr1 amd64 1.4.6-1 [89.6 kB]
Get: 13 http://id.archive.ubuntu.com/ubuntu/ precise/main libaprutil1 amd64 1.3.12+dfsg-3 [74.6 kB]
Get: 14 http://id.archive.ubuntu.com/ubuntu/ precise/main libaprutil1-dbd-sqlite3 amd64 1.3.12+dfsg-3 [10.4 kB]
Get: 15 http://id.archive.ubuntu.com/ubuntu/ precise/main libaprutil1-ldap amd64 1.3.12+dfsg-3 [8,044 B]
Get: 16 http://id.archive.ubuntu.com/ubuntu/ precise/main apache2.2-bin amd64 2.2.22-1ubuntu1 [1,337 kB]
Get: 17 http://id.archive.ubuntu.com/ubuntu/ precise/main apache2-utils amd64 2.2.22-1ubuntu1 [91.0 kB]
Get: 18 http://id.archive.ubuntu.com/ubuntu/ precise/main apache2.2-common amd64 2.2.22-1ubuntu1 [228 kB]
Get: 19 http://id.archive.ubuntu.com/ubuntu/ precise/main apache2-mpm-prefork amd64 2.2.22-1ubuntu1 [2,402 B]
Get: 20 http://id.archive.ubuntu.com/ubuntu/ precise/main apache2 amd64 2.2.22-1ubuntu1 [1,484 B]
Get: 21 http://id.archive.ubuntu.com/ubuntu/ precise/main php5-common amd64 5.3.10-1ubuntu3 [430 kB]
Get: 22 http://id.archive.ubuntu.com/ubuntu/ precise/main libapache2-mod-php5 amd64 5.3.10-1ubuntu3 [3,136 kB]
Get: 23 http://id.archive.ubuntu.com/ubuntu/ precise/main libhtml-template-perl all 2.10-1 [65.0 kB]
Get: 24 http://id.archive.ubuntu.com/ubuntu/ precise/main mysql-server all 5.5.22-0ubuntu1 [11.8 kB]
Get: 25 http://id.archive.ubuntu.com/ubuntu/ precise/main php5-cli amd64 5.3.10-1ubuntu3 [3,050 kB]
Get: 26 http://id.archive.ubuntu.com/ubuntu/ precise/main php5-mysql amd64 5.3.10-1ubuntu3 [76.6 kB]
Get: 27 http://id.archive.ubuntu.com/ubuntu/ precise/main ssl-cert all 1.0.28 [12.2 kB]
Fetched 35.7 MB in 2min 34s (231 kB/s)
Preconfiguring packages ...
Selecting previously unselected package libcap2.
(Reading database ... 53039 files and directories currently installed.)
Unpacking libcap2 (from .../libcap2_1%3a2.22-1ubuntu3_amd64.deb) ...
Selecting previously unselected package mysql-common.
Unpacking mysql-common (from .../mysql-common_5.5.22-0ubuntu1_all.deb) ...
Selecting previously unselected package libmysqlclient18.
Unpacking libmysqlclient18 (from .../libmysqlclient18_5.5.22-0ubuntu1_amd64.deb) ...
Selecting previously unselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.48-1_all.deb) ...
Selecting previously unselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...
Selecting previously unselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.616-1build2_amd64.deb) ...
Selecting previously unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.020-1build2_amd64.deb) ...
Selecting previously unselected package mysql-client-core-5.5.
Unpacking mysql-client-core-5.5 (from .../mysql-client-core-5.5_5.5.22-0ubuntu1_amd64.deb) ...
Selecting previously unselected package mysql-client-5.5.
Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.22-0ubuntu1_amd64.deb) ...
Selecting previously unselected package mysql-server-core-5.5.
Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.22-0ubuntu1_amd64.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.5.22-0ubuntu1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 53410 files and directories currently installed.)
Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.22-0ubuntu1_amd64.deb) ...
Selecting previously unselected package libapr1.
Unpacking libapr1 (from .../libapr1_1.4.6-1_amd64.deb) ...
Selecting previously unselected package libaprutil1.
Unpacking libaprutil1 (from .../libaprutil1_1.3.12+dfsg-3_amd64.deb) ...
Selecting previously unselected package libaprutil1-dbd-sqlite3.
Unpacking libaprutil1-dbd-sqlite3 (from .../libaprutil1-dbd-sqlite3_1.3.12+dfsg-3_amd64.deb) ...
Selecting previously unselected package libaprutil1-ldap.
Unpacking libaprutil1-ldap (from .../libaprutil1-ldap_1.3.12+dfsg-3_amd64.deb) ...
Selecting previously unselected package apache2.2-bin.
Unpacking apache2.2-bin (from .../apache2.2-bin_2.2.22-1ubuntu1_amd64.deb) ...
Selecting previously unselected package apache2-utils.
Unpacking apache2-utils (from .../apache2-utils_2.2.22-1ubuntu1_amd64.deb) ...
Selecting previously unselected package apache2.2-common.
Unpacking apache2.2-common (from .../apache2.2-common_2.2.22-1ubuntu1_amd64.deb) ...
Selecting previously unselected package apache2-mpm-prefork.
Unpacking apache2-mpm-prefork (from .../apache2-mpm-prefork_2.2.22-1ubuntu1_amd64.deb) ...
Selecting previously unselected package apache2.
Unpacking apache2 (from .../apache2_2.2.22-1ubuntu1_amd64.deb) ...
Selecting previously unselected package php5-common.
Unpacking php5-common (from .../php5-common_5.3.10-1ubuntu3_amd64.deb) ...
Selecting previously unselected package libapache2-mod-php5.
Unpacking libapache2-mod-php5 (from .../libapache2-mod-php5_5.3.10-1ubuntu3_amd64.deb) ...
Selecting previously unselected package libhtml-template-perl.
Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.10-1_all.deb) ...
Selecting previously unselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.5.22-0ubuntu1_all.deb) ...
Selecting previously unselected package php5-cli.
Unpacking php5-cli (from .../php5-cli_5.3.10-1ubuntu3_amd64.deb) ...
Selecting previously unselected package php5-mysql.
Unpacking php5-mysql (from .../php5-mysql_5.3.10-1ubuntu3_amd64.deb) ...
Selecting previously unselected package ssl-cert.
Unpacking ssl-cert (from .../ssl-cert_1.0.28_all.deb) ...
Processing triggers for ureadahead ...
ureadahead will be reprofiled on next reboot
Processing triggers for man-db ...
Processing triggers for ufw ...
Setting up libcap2 (1:2.22-1ubuntu3) ...
Setting up libmysqlclient18 (5.5.22-0ubuntu1) ...
Setting up libnet-daemon-perl (0.48-1) ...
Setting up libplrpc-perl (0.2020-2) ...
Setting up libdbi-perl (1.616-1build2) ...
Setting up libdbd-mysql-perl (4.020-1build2) ...
Setting up mysql-client-core-5.5 (5.5.22-0ubuntu1) ...
Setting up mysql-client-5.5 (5.5.22-0ubuntu1) ...
Setting up mysql-server-core-5.5 (5.5.22-0ubuntu1) ...
Setting up mysql-server-5.5 (5.5.22-0ubuntu1) ...
120503 18:58:40 [Note] Plugin 'FEDERATED' is disabled.
120503 18:58:40 InnoDB: The InnoDB memory heap is disabled
120503 18:58:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120503 18:58:40 InnoDB: Compressed tables use zlib 1.2.3.4
120503 18:58:40 InnoDB: Initializing buffer pool, size = 128.0M
120503 18:58:40 InnoDB: Completed initialization of buffer pool
120503 18:58:40 InnoDB: highest supported file format is Barracuda.
120503 18:58:40  InnoDB: Waiting for the background threads to start
120503 18:58:41 InnoDB: 1.1.8 started; log sequence number 1595675
120503 18:58:41  InnoDB: Starting shutdown...
120503 18:58:42  InnoDB: Shutdown completed; log sequence number 1595675
mysql start/running, process 3380
Setting up libapr1 (1.4.6-1) ...
Setting up libaprutil1 (1.3.12+dfsg-3) ...
Setting up libaprutil1-dbd-sqlite3 (1.3.12+dfsg-3) ...
Setting up libaprutil1-ldap (1.3.12+dfsg-3) ...
Setting up apache2.2-bin (2.2.22-1ubuntu1) ...
Setting up apache2-utils (2.2.22-1ubuntu1) ...
Setting up apache2.2-common (2.2.22-1ubuntu1) ...
Enabling site default.
Enabling module alias.
Enabling module autoindex.
Enabling module dir.
Enabling module env.
Enabling module mime.
Enabling module negotiation.
Enabling module setenvif.
Enabling module status.
Enabling module auth_basic.
Enabling module deflate.
Enabling module authz_default.
Enabling module authz_user.
Enabling module authz_groupfile.
Enabling module authn_file.
Enabling module authz_host.
Enabling module reqtimeout.
Setting up apache2-mpm-prefork (2.2.22-1ubuntu1) ...
* Starting web server apache2                                           [ OK ]
Setting up apache2 (2.2.22-1ubuntu1) ...
Setting up php5-common (5.3.10-1ubuntu3) ...
Setting up libapache2-mod-php5 (5.3.10-1ubuntu3) ...

Creating config file /etc/php5/apache2/php.ini with new version
* Restarting web server apache2                                                 ... waiting                                                             [ OK ]
Setting up libhtml-template-perl (2.10-1) ...
Setting up mysql-server (5.5.22-0ubuntu1) ...
Setting up php5-cli (5.3.10-1ubuntu3) ...

Creating config file /etc/php5/cli/php.ini with new version
update-alternatives: using /usr/bin/php5 to provide /usr/bin/php (php) in auto mode.
Setting up php5-mysql (5.3.10-1ubuntu3) ...
Setting up ssl-cert (1.0.28) ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place

linggih@linggih:~$

Selama proses install, MySQL akan meminta anda setting password root. Jangan sampai dikosongkan step setup password ini, pastikan password yang anda buat cukup rumit untuk ditebak. Ketikkan password root (Screenshot 24) → tekan Enter, dan ketik ulang password (Screenshot 25) → tekan Enter.
Install_Ubuntu_server31

Screenshot 24

Install_Ubuntu_server32

Screenshot 25

Berikutnya, test web server apakah sudah aktif. Untuk test, pertama cari informasi IP Server dengan mengetikkan command:

ifconfig | grep inet (baris 1) atau ifconfig -a (baris 7). Data IP pada tutorial ini, webserver bisa diakses dengan alamat IP 192.168.111.131 (baris 2) atau 192.168.1.8 (baris 4). Atau subdomain hostname (hostname sebelumnya disetup menggunakan linggih.servehttp.com).



linggih@linggih:~$ ifconfig | grep inet
inet addr:192.168.111.131  Bcast:192.168.111.255  Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe83:1376/64 Scope:Link
inet addr:192.168.1.8  Bcast:255.255.255.255  Mask:255.255.255.0
inet addr:127.0.0.1  Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
linggih@linggih:~$ ifconfig -a
eth0      Link encap:Ethernet  HWaddr 00:0c:29:83:13:76
inet addr:192.168.111.131  Bcast:192.168.111.255  Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe83:1376/64 Scope:Link
UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
RX packets:26459 errors:0 dropped:0 overruns:0 frame:0
TX packets:14528 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:37203057 (37.2 MB)  TX bytes:1032616 (1.0 MB)

eth1      Link encap:Ethernet  HWaddr 00:0c:29:83:13:80
inet addr:192.168.1.8  Bcast:255.255.255.255  Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST  MTU:576  Metric:1
RX packets:29 errors:0 dropped:0 overruns:0 frame:0
TX packets:12 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:4950 (4.9 KB)  TX bytes:3270 (3.2 KB)

lo        Link encap:Local Loopback
inet addr:127.0.0.1  Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING  MTU:16436  Metric:1
RX packets:56 errors:0 dropped:0 overruns:0 frame:0
TX packets:56 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:4592 (4.5 KB)  TX bytes:4592 (4.5 KB)

linggih@linggih:~$

Copy dan paste alamat ip pada web browser, kemudian tekan enter. Jika webserver sudah berjalan & aktif, halaman default index server Ubuntu yang akan muncul kurang lebih bertuliskan: "It works! This is the default web page for this server. The web server software is running but no content has been added, yet." (Screenshot 26).
Install_Ubuntu_server33

Screenshot 26

Untuk alasan memperkecil resiko user melihat celah keamanan pada informasi Apache atau PHP, edit konfigurasi security berikut ini. Pertama backup dulu file security Apache dengan mengetikkan command:

sudo cp /etc/apache2/conf.d/security /etc/apache2/conf.d/security.backup



linggih@linggih:~$ sudo cp /etc/apache2/conf.d/security /etc/apache2/conf.d/security.backup
linggih@linggih:~$

Buka dan edit file security Apache dengan mengetikkan command:

sudo nano /etc/apache2/conf.d/security

Cari dan ganti ServerTokens OS ke ServerTokens Prod (code baris ke-9). Kedua, ganti ServerSignature On ke ServerSignature Off (code baris ke-20). Tekan tombol Ctrl + O untuk simpan perubahan, kemudian tekan tombol Ctrl + X untuk keluar text editor.



# ServerTokens
# This directive configures what you return as the Server HTTP response
# Header. The default is 'Full' which sends information about the OS-Type
# and compiled in modules.
# Set to one of:  Full | OS | Minimal | Minor | Major | Prod
# where Full conveys the most information, and Prod the least.
#
#ServerTokens Minimal
ServerTokens Prod
#ServerTokens Full

#
# Optionally add a line containing the server version and virtual host
# name to server-generated pages (internal error documents, FTP directory
# listings, mod_status and mod_info output etc., but not CGI generated
# documents or custom error documents).
# Set to "EMail" to also include a mailto: link to the ServerAdmin.
# Set to one of:  On | Off | EMail
#
ServerSignature Off
#ServerSignature On

Sekarang, edit file konfigurasi PHP. Pertama backup dulu file konfigurasi PHP dengan mengetikkan command:

sudo cp /etc/php5/apache2/php.ini /etc/php5/apache2/php.ini.backup

Buka file konfigurasi php dengan mengetikkan command:

sudo nano /etc/php5/apache2/php.ini

Ganti expose_php = On ke expose_php = Off (code baris ke-10).



;;;;;;;;;;;;;;;;;
; Miscellaneous ;
;;;;;;;;;;;;;;;;;

; Decides whether PHP may expose the fact that it is installed on the server
; (e.g. by adding its signature to the Web server header).  It is no security
; threat in any way, but it makes it possible to determine whether you use PHP
; on your server or not.
; http://php.net/expose-php
expose_php = Off

Tekan tombol Ctrl + O untuk simpan perubahan, kemudian tekan tombol Ctrl + X untuk keluar text editor. Selanjutnya restart Apache web server dengan mengetikkan command:

sudo /etc/init.d/apache2 restart



root@linggih:~# /etc/init.d/apache2 restart
* Restarting web server apache2                                                 ... waiting                                                             [ OK ]
root@linggih:~#

Setting Apache Web Server, MySQL, and PHP selesai.

Konfigurasi Firewall

Cek status Firewall apakah aktif atau tidak dengan mengetikkan command sudo ufw status. Dua kemungkinan status:



root@linggih:~# sudo ufw status
Status: inactive

atau



root@linggih:~# sudo ufw status
Status: active

Jika firewall tidak aktif (Status: inactive), aktifkan firewall dengan mengetikkan command sudo ufw enable. Pesan konfirmasi Proceed with operation (y|n)?, ketikkan y dan tekan Enter.



root@linggih:~# sudo ufw enable
Command may disrupt existing ssh connections. Proceed with operation (y|n)? y
Firewall is active and enabled on system startup
linggih@linggih:~$

Firewall pada Ubuntu Server setting default terinstall belum ada rule. Pada tutorial ini akan setting rule baru untuk allow port HTTP (80) dan SSH (22).

Allow port 80 (HTTP) dengan mengetikkan command:

sudo ufw allow 80



linggih@linggih:~$ sudo ufw allow 80
Rule added
Rule added (v6)
linggih@linggih:~$

Kemudian allow port SSH (22) dengan mengetikkan command:

sudo ufw allow 22



linggih@linggih:~$ sudo ufw allow 22
Rule added
Rule added (v6)

Jika diperlukan, reboot server dengan mengetikkan command:

sudo shutdown -r now

Install Script Website

Setelah Apache, MySQL, PHP terinstall & firewall sudah di setting, sekarang saatnya setup website untuk mengganti (replace) halaman default apache (index.html) yang terletak pada direktori folder /var/www.

Mulai tahapan Install script WordPress:
  1. Untuk memudahkan setting script WordPress, pada tutorial ini terlebih dahulu setup user root dengan mengetikkan command:

    sudo passwd root

    Ketikkan password root & ketik ulang password root.



    linggih@linggih:~$ sudo passwd root
    Enter new UNIX password:
    Retype new UNIX password:
    passwd: password updated successfully
    linggih@linggih:~$

  2. Kemudian login root user dengan mengetikkan command:

    su root

    Ketikkan password root dan tekan Enter.



    linggih@linggih:~$ su root
    Password:
    root@linggih:/home/linggih#

  3. Setelah login root user, rename file index.html yang terletak pada direktori folder /var/www menjadi index.html.backup dengan mengetikkan command;
    mv /var/www/index.html /var/www/index.html.backup



    root@linggih:/home/linggih# mv /var/www/index.html /var/www/index.html.backup
    root@linggih:/home/linggih#

  4. Masuk ke direktori folder /var dengan mengetikkan command cd /var



    root@linggih:/home/linggih# cd /var
    root@linggih:/var#

  5. Download Script WordPress dengan mengetikkan command wget http://wordpress.org/latest.tar.gz



    root@linggih:/var# wget http://wordpress.org/latest.tar.gz
    --2012-05-04 13:56:41--  http://wordpress.org/latest.tar.gz
    Resolving wordpress.org (wordpress.org)... 72.233.56.139, 72.233.56.138
    Connecting to wordpress.org (wordpress.org)|72.233.56.139|:80... connected.
    HTTP request sent, awaiting response... 200 OK
    Length: unspecified [application/x-gzip]
    Saving to: `latest.tar.gz'
    
    [        <=>                            ] 3,883,667    234K/s   in 19s
    
    2012-05-04 13:57:01 (204 KB/s) - `latest.tar.gz' saved [3883667]
    
    root@linggih:/var#

  6. Untar (Extract) file dengan mengetikkan command tar -xvzf latest.tar.gz



    root@linggih:/var# tar -xvzf latest.tar.gz
    wordpress/
    wordpress/license.txt
    wordpress/wp-activate.php
    ...
    ...
    wordpress/wp-admin/css/
    wordpress/wp-admin/css/ie.css
    wordpress/wp-admin/css/farbtastic.css
    wordpress/wp-admin/css/wp-admin-rtl.css
    wordpress/wp-admin/css/ie-rtl.css
    ...
    ...
    wordpress/wp-admin/js/
    wordpress/wp-admin/js/common.js
    wordpress/wp-admin/js/editor.dev.js
    ...
    ...
    wordpress/wp-admin/js/set-post-thumbnail.dev.js
    wordpress/wp-admin/js/post.js
    wordpress/wp-admin/js/image-edit.js
    wordpress/wp-admin/js/inline-edit-post.dev.js
    ...
    ...
    wordpress/wp-admin/images/button-grad.png
    wordpress/wp-admin/images/wp-logo-vs.png
    wordpress/wp-admin/images/media-button-video.gif
    wordpress/wp-admin/images/media-button-image.gif
    wordpress/wp-admin/images/archive-link.png
    ...
    ...
    wordpress/wp-admin/images/screenshots/welcome-screen.png
    wordpress/wp-admin/images/screenshots/coediting.png
    wordpress/wp-admin/images/screenshots/media-icon.png
    ...
    ...
    wordpress/wp-admin/menu-header.php
    wordpress/wp-admin/post-new.php
    wordpress/wp-admin/user-new.php
    wordpress/wp-admin/link-manager.php
    wordpress/wp-admin/theme-editor.php
    ...
    ...
    wordpress/wp-admin/network/admin.php
    wordpress/wp-admin/network/users.php
    wordpress/wp-admin/network/sites.php
    ...
    ...
    wordpress/wp-admin/includes/class-wp-filesystem-base.php
    wordpress/wp-admin/includes/class-wp-links-list-table.php
    wordpress/wp-admin/includes/import.php
    wordpress/wp-admin/includes/dashboard.php
    ...
    ...
    wordpress/wp-includes/class-wp.php
    wordpress/wp-includes/class-IXR.php
    wordpress/wp-includes/feed-rss2-comments.php
    wordpress/wp-includes/class-smtp.php
    ...
    ...
    wordpress/wp-includes/class-wp-admin-bar.php
    wordpress/wp-includes/class.wp-scripts.php
    wordpress/wp-includes/atomlib.php
    wordpress/wp-includes/default-constants.php
    ...
    ...
    wordpress/wp-includes/js/plupload/handlers.dev.js
    wordpress/wp-includes/js/plupload/plupload.silverlight.js
    wordpress/wp-includes/js/wplink.js
    wordpress/wp-includes/js/tw-sack.js
    wordpress/wp-includes/js/quicktags.dev.js
    ...
    ...
    wordpress/wp-includes/js/tinymce/themes/advanced/js/source_editor.js
    wordpress/wp-includes/js/tinymce/themes/advanced/js/anchor.js
    wordpress/wp-includes/js/tinymce/themes/advanced/js/about.js
    wordpress/wp-includes/js/tinymce/themes/advanced/js/link.js
    ...
    ...
    wordpress/wp-includes/functions.wp-scripts.php
    wordpress/wp-includes/link-template.php
    wordpress/wp-includes/bookmark-template.php
    wordpress/wp-includes/author-template.php
    wordpress/wp-includes/locale.php
    ...
    ...
    wordpress/wp-content/themes/twentyeleven/images/headers/
    wordpress/wp-content/themes/twentyeleven/images/headers/shore-thumbnail.jpg
    wordpress/wp-content/themes/twentyeleven/images/headers/hanoi.jpg
    wordpress/wp-content/themes/twentyeleven/images/headers/lanterns.jpg
    ...
    ...
    wordpress/wp-links-opml.php
    wordpress/wp-comments-post.php
    wordpress/wp-app.php
    root@linggih:/var#

  7. Pindahkan konten script yang baru saja terekstract ke direktori /www dengan mengetikkan command:

    mv wordpress/* www/



    root@linggih:/var# mv wordpress/* www/
    root@linggih:/var#

  8. Selanjutnya buat user dan database MySQL. Login ke MySQL server sebagai user root dengan mengetikkan command mysql -u root -p, kemudian ketikkan password root dan tekan enter. Buat database, user & setting password baru, pada tutorial ini database yang akan dibuat wordpressdb, user baru adalah wordpress dengan password wordpresspass.
    • Untuk buat database baru ketikkan command:

      CREATE DATABASE wordpressdb; (lihat code baris ke-15)
    • Untuk setting user & password, ketikkan command:

      CREATE USER 'wordpress'@'localhost' IDENTIFIED BY 'wordpresspass'; (lihat code baris ke-18)
    • Grant Privileges user ke database dengan mengetikkan command:

      GRANT ALL PRIVILEGES ON wordpressdb.* to wordpress@localhost; (lihat code baris ke-21)
    Jika sudah selesai, ketik exit dan tekan enter (code baris ke-24).



    root@linggih:/var# mysql -u root -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 38
    Server version: 5.5.22-0ubuntu1 (Ubuntu)
    
    Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> CREATE DATABASE wordpressdb;
    Query OK, 1 row affected (0.00 sec)
    
    mysql> CREATE USER 'wordpress'@'localhost' IDENTIFIED BY 'wordpresspass';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> GRANT ALL PRIVILEGES ON wordpressdb.* to wordpress@localhost;
    Query OK, 0 rows affected (0.01 sec)
    
    mysql> exit
    Bye
    root@linggih:/var#

  9. Hampir Selesai. Sekarang mulai setup Wordpress. Buka alamat IP seperti yang sudah dijelaskan di atas pada halaman web browser. Ketikkan ifconfig -a pada jendela bash untuk identifikasi alamat ip. Pada tutorial ini tidak akan menggunakan alamat IP, namun akan menggunakan hostname (linggih.httpserve.com). Karena Script WordPress belum disetup, maka akan keluar halaman Error seperti pada gambar Screenshot 27. Klik pada tombol Create a Configuration File untuk mulai setup wordpress.
  10. Selanjutnya anda akan diminta menyediakan persyaratan-persyaratan sebelum melanjutkan proses setup (Database name, Database username, Database password, Database host). Semua persyaratan sudah dibuat pada poin sebelumnya, klik tombol Let's go! untuk melanjutkan (Screenshot 28).
  11. Detail database connection, isikan dengan detail database yang sudah dibuat pada poin sebelumnya. Pada tutorial ini, detail database connection yang dipakai:
    • Database Name: wordpressdb
    • Username: wordpress
    • Password: wordpresspass
    • Database Host: localhost
    • Table Prefix biarkan dengan value default wp_.
    Klik tombol Submit untuk melanjutkan (Screenshot 29).
    Install_Ubuntu_server34

    Screenshot 27

    Install_Ubuntu_server35

    Screenshot 28

    Install_Ubuntu_server36

    Screenshot 29

  12. Jika infomasi detail database cocok & WordPress dapat terhubung dengan MySQL, maka akan keluar tampilan seperti gambar di bawah (Screenshot 30). Klik tombol Run the install untuk mulai proses install Script WordPress
  13. Pada halaman selanjutnya, tentukan informasi situs yang ingin anda gunakan (Site Title, Username Admin, Password dan E-mail). Setelah selesai tekan tombol Install WordPress (Screenshot 31).
  14. Selesai. Situs WordPress anda berhasil di setup, klik tombol Log In untuk masuk pada halaman admin panel (Screenshot 39).
    Install_Ubuntu_server37

    Screenshot 30

    Install_Ubuntu_server38

    Screenshot 31

    Install_Ubuntu_server39

    Screenshot 32

    Install_Ubuntu_server40

    Screenshot 33

    Install_Ubuntu_server41

    Screenshot 34


Setting Remote Server

OpenSSH memberikan kemudahan akses bagi anda untuk login ke server tanpa harus via bash Ubuntu Server. Jika anda memakai OS Windows, anda perlu software SSH client untuk remote server. Kebanyakan orang menggunakan Putty, download Putty di sini.

Setelah terinstall, buka program Putty. Host Name (or IP address) isikan dengan alamat ip atau hostnamenya, Port isikan dengan port SSH (Default Port 22). Isikan Saved Sessions dengan nama terserah & klik tombol Save untuk simpan sesi login server atau klik tombol Open untuk login ke server tanpa simpan sesi login server (Screenshot 35).

Anda akan mendapat pesan peringatan (Putty Security Alert) ketika sukses login server (Screenshot 36). Tekan tombol Yes, setelah login anda dapat mengetikkan command seperti layaknya mengetikkan command pada jendela bash Ubuntu Server. Setelah selesai, ketik exit dan tekan Enter (Screenshot 37).
Install_Ubuntu_server42

Screenshot 35

Install_Ubuntu_server43

Screenshot 36

Install_Ubuntu_server44

Screenshot 37


Trik Membuat Home Dedicated Server Dapat Diakses Via Internet

Persyaratan utama yang harus dipenuhi untuk trik ini adalah menggunakan DMZ atau Port Forwarding, dengan kata lain koneksi internet di rumah anda harus dimanage via router. Karena DMZ atau port forwarding hanya bisa dimanipulasi oleh router.

Jika router tersedia, selanjutnya setting domain anda pada http://dyn.com/ atau http://www.no-ip.com/. Setting port forwarding tidak akan dijelaskan pada artikel kali ini, akan saya coba tuliskan di lain waktu.

Selesai.

Anda sekarang tahu mengenai fungsi dan cara setup basic web server. Artikel ini hanya untuk tujuan testing semata, dan mungkin bisa dijadikan alternatif web server jika traffic situs tidak terlalu besar dan komputer anda selalu online. Namun jika situs anda merupakan situs bisnis & mempunyai banyak client, jangan menggunakan alternatif ini. Karena mengapa??? Tentu saja anda tidak akan mau server menggunakan satu sumber tenaga (power source) dengan mesin cuci, hairdryer, kulkas, mesin pemanas atau komponen boros energi lainnya. Kalau listrik tidak sanggup handle, down servermu... hehe... :D.

Disarankan anda sewa dedicated server pada provider khusus server, karena mereka punya sumber tenaga yang baik dan selalu termonitor 24/7.

Penulis berharap artikel ini dapat memberikan pemahaman bagi anda yang masih awam mengenai server, bagi para master.. terima kasih sudah mampir serta diharapkan saran & masukannya.

Semoga bermanfaat.
:)
02 Mei 2012

Install phpMyAdmin Via yum Pada CentOS

phpMyAdmin adalah script (software) tool php yang dikhususkan untuk meng-handle administrasi database MySQL dan dapat diakses via internet (menggunakan Web Browser) dari seluruh dunia. Script ini dapat handle seluruh MySQL database (diperlukan satu super-user) sehingga memudahkan administrator untuk memanage database-database pada server.

Pada posting artikel kali ini, saya akan coba menunjukkan cara mudah install phpMyAdmin pada CentOS (Versi 6.2) menggunakan yum.

Download & Install EPEL Repository




  1. i386
    wget ftp://ftp.pbone.net/mirror/download.fedora.redhat.com/pub/fedora/epel/beta/6/i386/epel-release-6-5.noarch.rpm

  2. x86_64
    wget ftp://ftp.pbone.net/mirror/download.fedora.redhat.com/pub/fedora/epel/beta/6/x86_64/epel-release-6-5.noarch.rpm



[bash autolinks="true"]
[root@linggih ~]# wget ftp://ftp.pbone.net/mirror/download.fedora.redhat.com/pub/fedora/epel/beta/6/x86_64/epel-release-6-5.noarch.rpm
--2012-05-01 14:08:48-- ftp://ftp.pbone.net/mirror/download.fedora.redhat.com/pub/fedora/epel/beta/6/x86_64/epel-release-6-5.noarch.rpm
=> âepel-release-6-5.noarch.rpmâ
esolving ftp.pbone.net... 85.14.85.4
Connecting to ftp.pbone.net|85.14.85.4|:21... connected.
Logging in as anonymous ... Logged in!
==> SYST ... done. ==> PWD ... done.
==> TYPE I ... done. ==> CWD (1) /mirror/download.fedora.redhat.com/pub/fedora/epel/beta/6/x86_64 ... done.
==> SIZE epel-release-6-5.noarch.rpm ... 14064
==> PASV ... done. ==> RETR epel-release-6-5.noarch.rpm ... done.
Length: 14064 (14K) (unauthoritative)

100%[======================================>] 14,064 15.2K/s in 0.9s

2012-05-01 14:08:55 (15.2 KB/s) - âepel-release-6-5.noarch.rpmâ

[root@linggih ~]#
[/bash]

Install rpm dengan command rpm -Uvh epel-release-6*.rpm

[bash autolinks="true"]
[root@linggih ~]# rpm -Uvh epel-release-6*.rpm
warning: epel-release-6-5.noarch.rpm: Header V3 RSA/SHA256 Signature, key ID 0608b895: NOKEY
Preparing... ########################################### [100%]
1:epel-release ########################################### [100%]
[root@linggih ~]#
[/bash]

Download & Install Remi Repository




  1. i386
    ftp://ftp.pbone.net/mirror/rpms.famillecollet.com/enterprise/6/remi/i386/remi-release-6-1.el6.remi.noarch.rpm

  2. x86_64
    ftp://ftp.pbone.net/mirror/rpms.famillecollet.com/enterprise/6/remi/x86_64/remi-release-6-1.el6.remi.noarch.rpm



[bash autolinks="true"]
[root@linggih ~]# wget ftp://ftp.pbone.net/mirror/rpms.famillecollet.com/enterprise/6/remi/x86_64/remi-release-6-1.el6.remi.noarch.rpm
--2012-05-01 14:12:38-- ftp://ftp.pbone.net/mirror/rpms.famillecollet.com/enterprise/6/remi/x86_64/remi-release-6-1.el6.remi.noarch.rpm
=> âremi-release-6-1.el6.remi.noarch.rpmâ
esolving ftp.pbone.net... 85.14.85.4
Connecting to ftp.pbone.net|85.14.85.4|:21... connected.
Logging in as anonymous ... Logged in!
==> SYST ... done. ==> PWD ... done.
==> TYPE I ... done. ==> CWD (1) /mirror/rpms.famillecollet.com/enterprise/6/remi/x86_64 ... done.
==> SIZE remi-release-6-1.el6.remi.noarch.rpm ... 5292
==> PASV ... done. ==> RETR remi-release-6-1.el6.remi.noarch.rpm ... done.
Length: 5292 (5.2K) (unauthoritative)

100%[======================================>] 5,292 --.-K/s in 0.01s

2012-05-01 14:12:44 (376 KB/s) - âremi-release-6-1.el6.remi.noarch.rpmâ

[root@linggih ~]#
[/bash]

Install rpm dengan command rpm -Uvh remi-release-6*.rpm

[bash autolinks="true"]
[root@linggih ~]# rpm -Uvh remi-release-6*.rpm
warning: remi-release-6-1.el6.remi.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 00f97f56: NOKEY
Preparing... ########################################### [100%]
1:remi-release ########################################### [100%]
[root@linggih ~]#
[/bash]

Konfigurasi Remi Repository

Buka file Remi repository "/etc/yum.repos.d/remi.repo" dan edit value enabled=0 ke enabled=1.

[apache autolinks="true" firstline="1" gutter="true" highlight="5" light="true" ruler="true" smarttabs="true" tabsize="4" toolbar="true"]
[remi]
name=Les RPM de remi pour Enterprise Linux $releasever - $basearch
#baseurl=http://rpms.famillecollet.com/enterprise/$releasever/remi/$basearch/
mirrorlist=http://rpms.famillecollet.com/enterprise/$releasever/remi/mirror
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-remi
failovermethod=priority
[/apache]

Install phpMyAdmin



Jalankan command yum berikut ini untuk mulai install phpMyAdmin

yum install phpmyadmin

[bash autolinks="true"]
[root@linggih ~]# yum install phpmyadmin
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
epel/metalink | 4.7 kB 00:00
* base: centos.biz.net.id
* epel: epel.idrepo.or.id
* extras: centos.biz.net.id
* remi: rpms.famillecollet.com
* updates: mirror.vietoss.com
epel | 4.0 kB 00:00
epel/primary_db | 4.3 MB 00:19
remi | 2.9 kB 00:00
remi/primary_db | 247 kB 00:03
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package phpMyAdmin.noarch 0:3.5.0-1.el6.remi will be installed
--> Processing Dependency: php-mcrypt >= 5.2.0 for package: phpMyAdmin-3.5.0-1.el6.remi.noarch
--> Running transaction check
---> Package php-mcrypt.x86_64 0:5.3.11-1.el6.remi will be installed
--> Processing Dependency: php-common(x86-64) = 5.3.11-1.el6.remi for package: php-mcrypt-5.3.11-1.el6.remi.x86_64
--> Processing Dependency: libmcrypt.so.4()(64bit) for package: php-mcrypt-5.3.11-1.el6.remi.x86_64
--> Running transaction check
---> Package libmcrypt.x86_64 0:2.5.8-9.el6 will be installed
---> Package php-common.x86_64 0:5.3.3-3.el6_2.6 will be updated
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-xmlrpc-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-cli-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-odbc-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-ldap-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-mysql-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-pgsql-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-intl-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-tidy-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-soap-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-enchant-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-zts-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-xml-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-process-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-embedded-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-imap-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-pspell-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-gd-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-recode-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-mbstring-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-dba-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-snmp-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-pdo-5.3.3-3.el6_2.6.x86_64
--> Processing Dependency: php-common = 5.3.3-3.el6_2.6 for package: php-bcmath-5.3.3-3.el6_2.6.x86_64
---> Package php-common.x86_64 0:5.3.11-1.el6.remi will be an update
--> Running transaction check
---> Package php.x86_64 0:5.3.3-3.el6_2.6 will be updated
--> Processing Dependency: php = 5.3.3-3.el6_2.6 for package: php-devel-5.3.3-3.el6_2.6.x86_64
---> Package php.x86_64 0:5.3.11-1.el6.remi will be obsoleting
---> Package php-bcmath.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-bcmath.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-cli.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-cli.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-dba.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-dba.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-embedded.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-embedded.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-enchant.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-enchant.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-gd.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-gd.x86_64 0:5.3.11-1.el6.remi will be an update
--> Processing Dependency: libt1.so.5()(64bit) for package: php-gd-5.3.11-1.el6.remi.x86_64
---> Package php-imap.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-imap.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-intl.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-intl.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-ldap.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-ldap.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-mbstring.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-mbstring.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-mysql.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-mysql.x86_64 0:5.3.11-1.el6.remi will be an update
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: php-mysql-5.3.11-1.el6.remi.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: php-mysql-5.3.11-1.el6.remi.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: php-mysql-5.3.11-1.el6.remi.x86_64
---> Package php-odbc.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-odbc.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-pdo.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-pdo.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-pgsql.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-pgsql.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-process.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-process.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-pspell.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-pspell.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-recode.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-recode.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-snmp.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-snmp.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-soap.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-soap.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-tidy.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-tidy.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-xml.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-xml.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-xmlrpc.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-xmlrpc.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package php-zts.x86_64 0:5.3.3-3.el6_2.6 will be obsoleted
--> Running transaction check
---> Package mysql-libs.x86_64 0:5.1.61-1.el6_2.1 will be updated
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: mysql-server-5.1.61-1.el6_2.1.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: mysql-5.1.61-1.el6_2.1.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: mysql-server-5.1.61-1.el6_2.1.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: mysql-5.1.61-1.el6_2.1.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient_r.so.16()(64bit) for package: mysql-server-5.1.61-1.el6_2.1.x86_64
--> Processing Dependency: libmysqlclient_r.so.16()(64bit) for package: mysql-5.1.61-1.el6_2.1.x86_64
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: mysql-server-5.1.61-1.el6_2.1.x86_64
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: mysql-5.1.61-1.el6_2.1.x86_64
--> Processing Dependency: mysql-libs = 5.1.61-1.el6_2.1 for package: mysql-5.1.61-1.el6_2.1.x86_64
---> Package mysql-libs.x86_64 0:5.5.23-1.el6.remi will be an update
---> Package php-devel.x86_64 0:5.3.3-3.el6_2.6 will be updated
---> Package php-devel.x86_64 0:5.3.11-1.el6.remi will be an update
---> Package t1lib.x86_64 0:5.1.2-6.el6_2.1 will be installed
--> Running transaction check
---> Package compat-mysql51.x86_64 0:5.1.54-1.el6.remi will be installed
---> Package mysql.x86_64 0:5.1.61-1.el6_2.1 will be updated
---> Package mysql.x86_64 0:5.5.23-1.el6.remi will be an update
---> Package mysql-server.x86_64 0:5.1.61-1.el6_2.1 will be updated
---> Package mysql-server.x86_64 0:5.5.23-1.el6.remi will be an update
--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql-server-5.5.23-1.el6.remi.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql-server-5.5.23-1.el6.remi.x86_64
--> Processing Dependency: libaio.so.1()(64bit) for package: mysql-server-5.5.23-1.el6.remi.x86_64
--> Running transaction check
---> Package libaio.x86_64 0:0.3.107-10.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
php x86_64 5.3.11-1.el6.remi remi 2.3 M
replacing php-zts.x86_64 5.3.3-3.el6_2.6
phpMyAdmin noarch 3.5.0-1.el6.remi remi 4.7 M
Installing for dependencies:
compat-mysql51 x86_64 5.1.54-1.el6.remi remi 1.4 M
libaio x86_64 0.3.107-10.el6 base 21 k
libmcrypt x86_64 2.5.8-9.el6 epel 96 k
php-mcrypt x86_64 5.3.11-1.el6.remi remi 40 k
t1lib x86_64 5.1.2-6.el6_2.1 updates 160 k
Updating for dependencies:
mysql x86_64 5.5.23-1.el6.remi remi 5.7 M
mysql-libs x86_64 5.5.23-1.el6.remi remi 768 k
mysql-server x86_64 5.5.23-1.el6.remi remi 10 M
php-bcmath x86_64 5.3.11-1.el6.remi remi 40 k
php-cli x86_64 5.3.11-1.el6.remi remi 2.2 M
php-common x86_64 5.3.11-1.el6.remi remi 891 k
php-dba x86_64 5.3.11-1.el6.remi remi 51 k
php-devel x86_64 5.3.11-1.el6.remi remi 2.1 M
php-embedded x86_64 5.3.11-1.el6.remi remi 1.1 M
php-enchant x86_64 5.3.11-1.el6.remi remi 32 k
php-gd x86_64 5.3.11-1.el6.remi remi 132 k
php-imap x86_64 5.3.11-1.el6.remi remi 69 k
php-intl x86_64 5.3.11-1.el6.remi remi 102 k
php-ldap x86_64 5.3.11-1.el6.remi remi 47 k
php-mbstring x86_64 5.3.11-1.el6.remi remi 895 k
php-mysql x86_64 5.3.11-1.el6.remi remi 124 k
php-odbc x86_64 5.3.11-1.el6.remi remi 67 k
php-pdo x86_64 5.3.11-1.el6.remi remi 109 k
php-pgsql x86_64 5.3.11-1.el6.remi remi 102 k
php-process x86_64 5.3.11-1.el6.remi remi 50 k
php-pspell x86_64 5.3.11-1.el6.remi remi 31 k
php-recode x86_64 5.3.11-1.el6.remi remi 26 k
php-snmp x86_64 5.3.11-1.el6.remi remi 34 k
php-soap x86_64 5.3.11-1.el6.remi remi 208 k
php-tidy x86_64 5.3.11-1.el6.remi remi 44 k
php-xml x86_64 5.3.11-1.el6.remi remi 160 k
php-xmlrpc x86_64 5.3.11-1.el6.remi remi 60 k

Transaction Summary
================================================================================
Install 7 Package(s)
Upgrade 27 Package(s)

Total download size: 34 M
Is this ok [y/N]: y
Downloading Packages:
(1/34): compat-mysql51-5.1.54-1.el6.remi.x86_64.rpm | 1.4 MB 00:12
http://centos.biz.net.id/6.2/os/x86_64/Packages/libaio-0.3.107-10.el6.x86_64.rpm: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404"
Trying other mirror.
(2/34): libaio-0.3.107-10.el6.x86_64.rpm | 21 kB 00:00
(3/34): libmcrypt-2.5.8-9.el6.x86_64.rpm | 96 kB 00:00
(4/34): mysql-5.5.23-1.el6.remi.x86_64.rpm | 5.7 MB 00:34
(5/34): mysql-libs-5.5.23-1.el6.remi.x86_64.rpm | 768 kB 00:07
(6/34): mysql-server-5.5.23-1.el6.remi.x86_64.rpm | 10 MB 00:49
(7/34): php-5.3.11-1.el6.remi.x86_64.rpm | 2.3 MB 00:16
(8/34): php-bcmath-5.3.11-1.el6.remi.x86_64.rpm | 40 kB 00:02
(9/34): php-cli-5.3.11-1.el6.remi.x86_64.rpm | 2.2 MB 00:17
(10/34): php-common-5.3.11-1.el6.remi.x86_64.rpm | 891 kB 00:08
(11/34): php-dba-5.3.11-1.el6.remi.x86_64.rpm | 51 kB 00:02
(12/34): php-devel-5.3.11-1.el6.remi.x86_64.rpm | 2.1 MB 00:17
(13/34): php-embedded-5.3.11-1.el6.remi.x86_64.rpm | 1.1 MB 00:09
(14/34): php-enchant-5.3.11-1.el6.remi.x86_64.rpm | 32 kB 00:01
(15/34): php-gd-5.3.11-1.el6.remi.x86_64.rpm | 132 kB 00:04
(16/34): php-imap-5.3.11-1.el6.remi.x86_64.rpm | 69 kB 00:02
(17/34): php-intl-5.3.11-1.el6.remi.x86_64.rpm | 102 kB 00:03
(18/34): php-ldap-5.3.11-1.el6.remi.x86_64.rpm | 47 kB 00:02
(19/34): php-mbstring-5.3.11-1.el6.remi.x86_64.rpm | 895 kB 00:08
(20/34): php-mcrypt-5.3.11-1.el6.remi.x86_64.rpm | 40 kB 00:02
(21/34): php-mysql-5.3.11-1.el6.remi.x86_64.rpm | 124 kB 00:03
(22/34): php-odbc-5.3.11-1.el6.remi.x86_64.rpm | 67 kB 00:02
(23/34): php-pdo-5.3.11-1.el6.remi.x86_64.rpm | 109 kB 00:03
(24/34): php-pgsql-5.3.11-1.el6.remi.x86_64.rpm | 102 kB 00:03
(25/34): php-process-5.3.11-1.el6.remi.x86_64.rpm | 50 kB 00:02
(26/34): php-pspell-5.3.11-1.el6.remi.x86_64.rpm | 31 kB 00:01
(27/34): php-recode-5.3.11-1.el6.remi.x86_64.rpm | 26 kB 00:01
(28/34): php-snmp-5.3.11-1.el6.remi.x86_64.rpm | 34 kB 00:01
(29/34): php-soap-5.3.11-1.el6.remi.x86_64.rpm | 208 kB 00:04
(30/34): php-tidy-5.3.11-1.el6.remi.x86_64.rpm | 44 kB 00:01
(31/34): php-xml-5.3.11-1.el6.remi.x86_64.rpm | 160 kB 00:03
(32/34): php-xmlrpc-5.3.11-1.el6.remi.x86_64.rpm | 60 kB 00:02
(33/34): phpMyAdmin-3.5.0-1.el6.remi.noarch.rpm | 4.7 MB 00:27
(34/34): t1lib-5.1.2-6.el6_2.1.x86_64.rpm | 160 kB 00:08
--------------------------------------------------------------------------------
Total 117 kB/s | 34 MB 04:57
warning: rpmts_HdrFromFdno: Header V3 DSA/SHA1 Signature, key ID 00f97f56: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-remi
Importing GPG key 0x00F97F56:
Userid : Remi Collet <RPMS@FamilleCollet.com>
Package: remi-release-6-1.el6.remi.noarch (installed)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-remi
Is this ok [y/N]: y
warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID 0608b895: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-6
Importing GPG key 0x0608B895:
Userid : EPEL (6) <epel@fedoraproject.org>
Package: epel-release-6-5.noarch (installed)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-6
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Updating : php-common-5.3.11-1.el6.remi.x86_64 1/63

WARNING : These php-* RPM are not official Fedora/Redhat build and
overrides the official ones. Don't file bugs on Fedora Project nor Redhat.

Use dedicated forums http://forums.famillecollet.com/

Updating : php-pdo-5.3.11-1.el6.remi.x86_64 2/63
Updating : mysql-libs-5.5.23-1.el6.remi.x86_64 3/63

WARNING : This MySQL RPM is not an official Fedora/Redhat build and it
overrides the official one. Don't file bugs on Fedora Project nor Redhat.
Use dedicated forums http://forums.famillecollet.com/

Updating : php-mysql-5.3.11-1.el6.remi.x86_64 4/63
Updating : mysql-5.5.23-1.el6.remi.x86_64 5/63
Updating : php-cli-5.3.11-1.el6.remi.x86_64 6/63
Installing : php-5.3.11-1.el6.remi.x86_64 7/63
Updating : php-mbstring-5.3.11-1.el6.remi.x86_64 8/63
Installing : t1lib-5.1.2-6.el6_2.1.x86_64 9/63
Updating : php-gd-5.3.11-1.el6.remi.x86_64 10/63
Installing : libmcrypt-2.5.8-9.el6.x86_64 11/63
Installing : php-mcrypt-5.3.11-1.el6.remi.x86_64 12/63
Installing : libaio-0.3.107-10.el6.x86_64 13/63
Updating : mysql-server-5.5.23-1.el6.remi.x86_64 14/63
Installing : phpMyAdmin-3.5.0-1.el6.remi.noarch 15/63
Updating : php-devel-5.3.11-1.el6.remi.x86_64 16/63
Updating : php-odbc-5.3.11-1.el6.remi.x86_64 17/63
Updating : php-pgsql-5.3.11-1.el6.remi.x86_64 18/63
Updating : php-soap-5.3.11-1.el6.remi.x86_64 19/63
Updating : php-bcmath-5.3.11-1.el6.remi.x86_64 20/63
Updating : php-tidy-5.3.11-1.el6.remi.x86_64 21/63
Updating : php-xml-5.3.11-1.el6.remi.x86_64 22/63
Updating : php-xmlrpc-5.3.11-1.el6.remi.x86_64 23/63
Updating : php-embedded-5.3.11-1.el6.remi.x86_64 24/63
Updating : php-dba-5.3.11-1.el6.remi.x86_64 25/63
Updating : php-snmp-5.3.11-1.el6.remi.x86_64 26/63
Updating : php-process-5.3.11-1.el6.remi.x86_64 27/63
Updating : php-recode-5.3.11-1.el6.remi.x86_64 28/63
Updating : php-ldap-5.3.11-1.el6.remi.x86_64 29/63
Updating : php-imap-5.3.11-1.el6.remi.x86_64 30/63
Updating : php-pspell-5.3.11-1.el6.remi.x86_64 31/63
Updating : php-intl-5.3.11-1.el6.remi.x86_64 32/63
Updating : php-enchant-5.3.11-1.el6.remi.x86_64 33/63
Installing : compat-mysql51-5.1.54-1.el6.remi.x86_64 34/63
Cleanup : php-devel-5.3.3-3.el6_2.6.x86_64 35/63
Cleanup : php-mysql-5.3.3-3.el6_2.6.x86_64 36/63
Cleanup : php-5.3.3-3.el6_2.6.x86_64 37/63
Cleanup : php-pgsql-5.3.3-3.el6_2.6.x86_64 38/63
Cleanup : mysql-server-5.1.61-1.el6_2.1.x86_64 39/63
Cleanup : php-odbc-5.3.3-3.el6_2.6.x86_64 40/63
Cleanup : php-pdo-5.3.3-3.el6_2.6.x86_64 41/63
Cleanup : mysql-5.1.61-1.el6_2.1.x86_64 42/63
Cleanup : php-cli-5.3.3-3.el6_2.6.x86_64 43/63
Cleanup : php-mbstring-5.3.3-3.el6_2.6.x86_64 44/63
Cleanup : php-enchant-5.3.3-3.el6_2.6.x86_64 45/63
Cleanup : php-intl-5.3.3-3.el6_2.6.x86_64 46/63
Cleanup : php-pspell-5.3.3-3.el6_2.6.x86_64 47/63
Cleanup : php-imap-5.3.3-3.el6_2.6.x86_64 48/63
Cleanup : php-ldap-5.3.3-3.el6_2.6.x86_64 49/63
Cleanup : php-recode-5.3.3-3.el6_2.6.x86_64 50/63
Erasing : php-zts-5.3.3-3.el6_2.6.x86_64 51/63
Cleanup : php-process-5.3.3-3.el6_2.6.x86_64 52/63
Cleanup : php-snmp-5.3.3-3.el6_2.6.x86_64 53/63
Cleanup : php-gd-5.3.3-3.el6_2.6.x86_64 54/63
Cleanup : php-dba-5.3.3-3.el6_2.6.x86_64 55/63
Cleanup : php-embedded-5.3.3-3.el6_2.6.x86_64 56/63
Cleanup : php-xmlrpc-5.3.3-3.el6_2.6.x86_64 57/63
Cleanup : php-xml-5.3.3-3.el6_2.6.x86_64 58/63
Cleanup : php-tidy-5.3.3-3.el6_2.6.x86_64 59/63
Cleanup : php-bcmath-5.3.3-3.el6_2.6.x86_64 60/63
Cleanup : php-soap-5.3.3-3.el6_2.6.x86_64 61/63
Cleanup : php-common-5.3.3-3.el6_2.6.x86_64 62/63
Cleanup : mysql-libs-5.1.61-1.el6_2.1.x86_64 63/63

Installed:
php.x86_64 0:5.3.11-1.el6.remi phpMyAdmin.noarch 0:3.5.0-1.el6.remi

Dependency Installed:
compat-mysql51.x86_64 0:5.1.54-1.el6.remi
libaio.x86_64 0:0.3.107-10.el6
libmcrypt.x86_64 0:2.5.8-9.el6
php-mcrypt.x86_64 0:5.3.11-1.el6.remi
t1lib.x86_64 0:5.1.2-6.el6_2.1

Dependency Updated:
mysql.x86_64 0:5.5.23-1.el6.remi
mysql-libs.x86_64 0:5.5.23-1.el6.remi
mysql-server.x86_64 0:5.5.23-1.el6.remi
php-bcmath.x86_64 0:5.3.11-1.el6.remi
php-cli.x86_64 0:5.3.11-1.el6.remi
php-common.x86_64 0:5.3.11-1.el6.remi
php-dba.x86_64 0:5.3.11-1.el6.remi
php-devel.x86_64 0:5.3.11-1.el6.remi
php-embedded.x86_64 0:5.3.11-1.el6.remi
php-enchant.x86_64 0:5.3.11-1.el6.remi
php-gd.x86_64 0:5.3.11-1.el6.remi
php-imap.x86_64 0:5.3.11-1.el6.remi
php-intl.x86_64 0:5.3.11-1.el6.remi
php-ldap.x86_64 0:5.3.11-1.el6.remi
php-mbstring.x86_64 0:5.3.11-1.el6.remi
php-mysql.x86_64 0:5.3.11-1.el6.remi
php-odbc.x86_64 0:5.3.11-1.el6.remi
php-pdo.x86_64 0:5.3.11-1.el6.remi
php-pgsql.x86_64 0:5.3.11-1.el6.remi
php-process.x86_64 0:5.3.11-1.el6.remi
php-pspell.x86_64 0:5.3.11-1.el6.remi
php-recode.x86_64 0:5.3.11-1.el6.remi
php-snmp.x86_64 0:5.3.11-1.el6.remi
php-soap.x86_64 0:5.3.11-1.el6.remi
php-tidy.x86_64 0:5.3.11-1.el6.remi
php-xml.x86_64 0:5.3.11-1.el6.remi
php-xmlrpc.x86_64 0:5.3.11-1.el6.remi

Replaced:
php-zts.x86_64 0:5.3.3-3.el6_2.6

Complete!
[root@linggih ~]#
[/bash]

Setting database phpMyAdmin



Ketikkan command mysql -u root. Jika keluar pesan error "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)" berarti user root sudah ada, pakai command mysql -u root -p. Kemudian ketikkan password root.

Jika anda install phpMyAdmin ini pada fresh install OS (Minimal Install), buat user root terlebih dahulu dengan command:


  1. mysql -u root

  2. SET PASSWORD FOR 'root'@'localhost' = PASSWORD('passwordroot');. Ganti passwordroot dengan password root anda.

  3. Tekan tombol Ctrl + C atau ketikkan exit untuk keluar



[bash autolinks="true"]
[root@linggih ~]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.61 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('passwordroot');
Query OK, 0 rows affected (0.00 sec)

mysql>

mysql> Ctrl-C -- exit!
Aborted
[root@linggih ~]#
[/bash]

Buat database phpMyAdmin



Command:


  1. mysql -u root -p. Kemudian ketikkan password root

  2. CREATE DATABASE phpmyadmin; → buat database phpmyadmin

  3. Tekan tombol Ctrl + C atau ketikkan exit untuk keluar



[bash autolinks="true"]
[root@linggih ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.5.23 MySQL Community Server (GPL) by Remi

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE phpmyadmin;
Query OK, 1 row affected (0.00 sec)

mysql> exit
Bye
[root@linggih ~]#
[/bash]

Control-User



Setting pma user dan grant akses ke database phpmyadmin

Command:


  1. mysql -u root -p, kemudian ketikkan password root.

  2. CREATE USER 'pma'@'localhost' IDENTIFIED BY 'pmapass';. Setting user permission (pma) @ localhost, user password pmapass

  3. GRANT ALL PRIVILEGES ON phpmyadmin.* to pma@localhost;. Setting all privileges database permission (phpmyadmin) oleh user pma @ localhost

  4. Tekan tombol Ctrl + C atau ketikkan exit untuk keluar



[bash autolinks="true"]
[root@linggih phpMyAdmin]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.5.23 MySQL Community Server (GPL) by Remi

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE USER 'pma'@'localhost' IDENTIFIED BY 'pmapass';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON phpmyadmin.* to pma@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
[root@linggih phpMyAdmin]#
[/bash]

Import Table



Import (execute) create_tables.sql pada direktori "/usr/share/phpMyAdmin/examples/" ke database phpmyadmin.

Command:


  1. mysql -u pma -p -h localhost phpmyadmin < /usr/share/phpMyAdmin/examples/create_tables.sql

  2. Ketikkan password user pma (password default pmapass), tekan enter



[bash autolinks="true"]
[root@linggih phpMyAdmin]# mysql -u pma -p -h localhost phpmyadmin < /usr/share/phpMyAdmin/examples/create_tables.sql
Enter password:
[root@linggih phpMyAdmin]#
[/bash]

Edit File Konfigurasi



Copy file konfigurasi phpMyAdmin "config.sample.inc.php" dengan nama "config.inc.php".

[bash autolinks="true"]
[root@linggih ~]# cd /usr/share/phpMyAdmin
[root@linggih phpMyAdmin]# cp config.sample.inc.php config.inc.php
[root@linggih phpMyAdmin]#
[/bash]

blowfish_secret

Edit blowfish_secret pada file config.inc.php (/usr/share/phpMyAdmin/config.inc.php).

[php autolinks="true"]
$cfg['blowfish_secret'] = 'NV_jqqx5{3hdi[=$jAv)8eUHdxlNzU0UBfFnFY8#_$R++'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
[/php]

Jika anda tidak tahu, bisa copy paste via blowfish_secret generator di sini.

[caption id="attachment_773" align="alignnone" width="229" caption="Blowfish Secret Generator"]Blowfish Secret Generator[/caption]

Set auth_type ke "cookie"

[php autolinks="true"]
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
[/php]

Enable advanced features pada file konfigurasi seperti contoh di bawah. Uncomment dua garis miring (//):

[php autolinks="true"]
/*
* phpMyAdmin configuration storage settings.
*/

/* User used to manipulate with storage */
$cfg['Servers'][$i]['controlhost'] = 'localhost';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';

/* Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
$cfg['Servers'][$i]['recent'] = 'pma_recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';
[/php]

Buka file /etc/httpd/conf.d/phpMyAdmin.conf, kemudian edit deny from all ke allow from all untuk menghindari pesan Error "Forbidden (You don't have permission to access /phpmyadmin on this server.)".

[apache autolinks="true"]
<Directory /usr/share/phpMyAdmin/>
order deny,allow
allow from all
allow from 127.0.0.1
allow from ::1
</Directory>
[/apache]

Restart Apache Web Server

Restart Apache Web Server, ketikkan command service httpd restart atau /etc/init.d/httpd restart

[bash autolinks="true"]
[root@linggih ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]
[root@linggih ~]#
[/bash]

Test phpMyAdmin



buka halaman main index/phpmyadmin (http://domain-anda.com/phpmyadmin) pada web browser. Jika phpMyAdmin sukses terinstall, anda akan diminta memasukkan detail user login. Masukkan username dan password root, kemudian klik tombol Go.

[caption id="attachment_774" align="alignnone" width="300" caption="phpMyAdmin Login Screen"]phpMyAdmin Login Screen[/caption]

Jika otentikasi login sukses, anda akan diarahkan pada halaman utama phpMyAdmin.

[caption id="attachment_775" align="alignnone" width="300" caption="phpMyAdmin Main Page"]phpMyAdmin Main Page[/caption]

Selesai. Semoga bermanfaat.
:D

referensi:

http://wiki.phpmyadmin.net/pma/Welcome_to_phpMyAdmin_Wiki
Loncat ke Atas ↑