Swardana Linggih Blog

Home » All posts

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:

Seperangkat komputer (tidak harus bagus / asal komputer bisa berjalan normal) dengan support koneksi internet
CD untuk burning sistem operasi server
Sistem Operasi Server (Server Operating System), pada tutorial ini akan menggunakan Ubuntu Server 64 bit
OpenSSH Server untuk remote server
Aplikasi Web (Web Application), menggunakan Apache, MySQL dan PHP
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

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

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

Screenshot 8

Screenshot 9

Screenshot 10

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.

Screenshot 12

Screenshot 13

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.

Screenshot 15

Screenshot 16

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.

Screenshot 18

Screenshot 19

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.

Screenshot 21

Screenshot 22

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.

Screenshot 24

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).

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:

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:~$
```
Kemudian login root user dengan mengetikkan command:

su root

Ketikkan password root dan tekan Enter.
```
linggih@linggih:~$ su root
Password:
root@linggih:/home/linggih#
```
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#
```
Masuk ke direktori folder /var dengan mengetikkan command cd /var
```
root@linggih:/home/linggih# cd /var
root@linggih:/var#
```

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#

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#

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#
```

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#

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.
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).
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).

Screenshot 27
Screenshot 28
Screenshot 29

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
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).
Selesai. Situs WordPress anda berhasil di setup, klik tombol Log In untuk masuk pada halaman admin panel (Screenshot 39).

Screenshot 30
Screenshot 31
Screenshot 32
Screenshot 33
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).

Screenshot 35

Screenshot 36

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.
:)

Selengkapnya

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

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

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

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

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:

mysql -u root

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

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:

mysql -u root -p. Kemudian ketikkan password root

CREATE DATABASE phpmyadmin; → buat database phpmyadmin

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:

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

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

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

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:

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

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"]

[/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"]

[/caption]

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

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

[/caption]

Selesai. Semoga bermanfaat.
:D

referensi:

http://wiki.phpmyadmin.net/pma/Welcome_to_phpMyAdmin_Wiki

Selengkapnya

30 April 2012

Windows 7 Trick "GodMode" All In One Control Panel Applet

Windows 7 merupakan salah satu Sistem Operasi (Operating System) software terkemuka di pasaran saat ini dari beberapa sistem operasi terkemuka lainnya. Keunggulan sistem operasi ini diantaranya mulai dari kinerja yang dibuat lebih cepat dari sistem operasi versi sebelumnya (Windows XP & Vista), compatible driver & software hampir pada semua aplikasi, tampilan (interface) yang menarik, beragam fitur yang mudah dioperasikan dan beberapa keunggulan lainnya.

Bicara mengenai fitur, berikut beberapa keunggulan fitur yang ada pada sistem operasi Windows 7:

Kinerja lebih cepat & responsif
Media Streaming
HomeGroup
Taskbar & Full-Screen Preview dibuat lebih baik
Jump Lists
Desktop enhancements
Windows Search
Device management yang lebih baik
View Available Network (VAN)
Restore data mudah dengan automatic backup & restore
Pilihan bahasa lebih banyak (saat ini belum support Bahasa Indonesia)
Tonton tayangan acara televisi gratis menggunakan Internet TV
Dan lain sebagainya

Dengan banyaknya fitur yang ditawarkan otomatis banyak juga item setting yang tersedia. Bagi anda yang kurang familiar dengan setting & interface Windows 7, mungkin akan memakan waktu sedikit lebih lama untuk mencari setting fitur tertentu pada Control Panel Windows. Berikut ada trik yang akan memberikan kemudahan bagi anda untuk melihat semua setting & fitur Windows 7 pada satu lokasi file (single control panel applet).

Bagaimana cara melakukannya?

Mudah. Buat folder baru dengan lokasi dimana saja dan beri nama (rename) dengan "GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}" (tanpa tanda petik), kemudian tekan enter.

Windows 7 Trick: GodMode1

Windows 7 Trick: GodMode 2

Windows 7 Trick: GodMode 3

Windows 7 Trick: GodMode 4

Buka file folder GodMode, tampilannya akan tampak seperti screenshot di bawah. Jika anda ingin mencari fitur (setting) tertentu, ketikkan kata kunci pada kotak pencarian (gambar di bawah). Hasil pencarian akan disaring (filter) berdasarkan keyword (kata kunci) yang anda ketikkan.

Windows 7 Trick: GodMode Screenshot 1

Windows 7 Trick: GodMode Screenshot 2

Windows 7 Trick: GodMode Search Filter

Selesai. Semoga bermanfaat.
:)

Selengkapnya

29 April 2012

Install PHP Pada CentOS

Pada artikel kali ini saya akan coba share cara paling gampang install php pada CentOS. Diasumsikan anda install CentOS dengan pilihan minimal install dan anda sudah setup local yum repository.

Untuk mulai install php, ketikkan command; yum install php*.

[root@linggih ~]# yum install php*
...
...
...
---> Package enchant.x86_64 1:1.5.0-4.el6 will be installed
--> Processing Dependency: libhunspell-1.2.so.0()(64bit) for package: 1:enchant-1.5.0-4.el6.x86_64
---> Package libc-client.x86_64 0:2007e-11.el6 will be installed
---> Package libedit.x86_64 0:2.11-4.20080712cvs.1.el6 will be installed
---> Package libtidy.x86_64 0:0.99.0-19.20070615.1.el6 will be installed
---> Package libxslt.x86_64 0:1.1.26-2.el6 will be installed
---> Package net-snmp.x86_64 1:5.5-37.el6_2.1 will be installed
--> Processing Dependency: libsensors.so.4()(64bit) for package: 1:net-snmp-5.5-37.el6_2.1.x86_64
---> Package net-snmp-libs.x86_64 1:5.5-37.el6_2.1 will be installed
---> Package postgresql-libs.x86_64 0:8.4.9-1.el6_1.1 will be installed
---> Package recode.x86_64 0:3.6-28.1.el6 will be installed
---> Package unixODBC.x86_64 0:2.2.14-11.el6 will be installed
--> Processing Dependency: libltdl.so.7()(64bit) for package: unixODBC-2.2.14-11.el6.x86_64
--> Running transaction check
---> Package hunspell.x86_64 0:1.2.8-16.el6 will be installed
---> Package libtool-ltdl.x86_64 0:2.2.6-15.5.el6 will be installed
---> Package lm_sensors-libs.x86_64 0:3.1.1-10.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package              Arch      Version                        Repository  Size
================================================================================
Installing:
php                  x86_64    5.3.3-3.el6_2.6                updates    1.1 M
php-bcmath           x86_64    5.3.3-3.el6_2.6                updates     32 k
php-cli              x86_64    5.3.3-3.el6_2.6                updates    2.2 M
php-common           x86_64    5.3.3-3.el6_2.6                updates    522 k
php-dba              x86_64    5.3.3-3.el6_2.6                updates     38 k
php-devel            x86_64    5.3.3-3.el6_2.6                updates    505 k
php-embedded         x86_64    5.3.3-3.el6_2.6                updates    1.1 M
php-enchant          x86_64    5.3.3-3.el6_2.6                updates     27 k
php-gd               x86_64    5.3.3-3.el6_2.6                updates    104 k
php-imap             x86_64    5.3.3-3.el6_2.6                updates     48 k
php-intl             x86_64    5.3.3-3.el6_2.6                updates     68 k
php-ldap             x86_64    5.3.3-3.el6_2.6                updates     36 k
php-mbstring         x86_64    5.3.3-3.el6_2.6                updates    453 k
php-mysql            x86_64    5.3.3-3.el6_2.6                updates     79 k
php-odbc             x86_64    5.3.3-3.el6_2.6                updates     48 k
php-pdo              x86_64    5.3.3-3.el6_2.6                updates     73 k
php-pear             noarch    1:1.9.4-4.el6                  base       393 k
php-pecl-apc         x86_64    3.1.3p1-1.2.el6.1              base        93 k
php-pecl-memcache    x86_64    3.0.5-3.el6                    base        60 k
php-pgsql            x86_64    5.3.3-3.el6_2.6                updates     68 k
php-process          x86_64    5.3.3-3.el6_2.6                updates     37 k
php-pspell           x86_64    5.3.3-3.el6_2.6                updates     26 k
php-recode           x86_64    5.3.3-3.el6_2.6                updates     23 k
php-snmp             x86_64    5.3.3-3.el6_2.6                updates     28 k
php-soap             x86_64    5.3.3-3.el6_2.6                updates    138 k
php-tidy             x86_64    5.3.3-3.el6_2.6                updates     34 k
php-xml              x86_64    5.3.3-3.el6_2.6                updates    100 k
php-xmlrpc           x86_64    5.3.3-3.el6_2.6                updates     50 k
php-zts              x86_64    5.3.3-3.el6_2.6                updates    1.2 M
Installing for dependencies:
aspell               x86_64    12:0.60.6-12.el6               base       648 k
enchant              x86_64    1:1.5.0-4.el6                  base        49 k
hunspell             x86_64    1.2.8-16.el6                   base       177 k
libc-client          x86_64    2007e-11.el6                   base       515 k
libedit              x86_64    2.11-4.20080712cvs.1.el6       base        74 k
libtidy              x86_64    0.99.0-19.20070615.1.el6       base       127 k
libtool-ltdl         x86_64    2.2.6-15.5.el6                 base        44 k
libxslt              x86_64    1.1.26-2.el6                   base       450 k
lm_sensors-libs      x86_64    3.1.1-10.el6                   base        37 k
net-snmp             x86_64    1:5.5-37.el6_2.1               updates    300 k
net-snmp-libs        x86_64    1:5.5-37.el6_2.1               updates    1.5 M
postgresql-libs      x86_64    8.4.9-1.el6_1.1                base       198 k
recode               x86_64    3.6-28.1.el6                   base       712 k
unixODBC             x86_64    2.2.14-11.el6                  base       378 k

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

Total download size: 14 M
Installed size: 47 M
Is this ok [y/N]: y
Downloading Packages:
(1/43): aspell-0.60.6-12.el6.x86_64.rpm                  | 648 kB     00:28
(2/43): enchant-1.5.0-4.el6.x86_64.rpm                   |  49 kB     00:02
(3/43): hunspell-1.2.8-16.el6.x86_64.rpm                 | 177 kB     00:06
(4/43): libc-client-2007e-11.el6.x86_64.rpm              | 515 kB     00:26
(5/43): libedit-2.11-4.20080712cvs.1.el6.x86_64.rpm      |  74 kB     00:04
(6/43): libtidy-0.99.0-19.20070615.1.el6.x86_64.rpm      | 127 kB     00:05
(7/43): libtool-ltdl-2.2.6-15.5.el6.x86_64.rpm           |  44 kB     00:01
(8/43): libxslt-1.1.26-2.el6.x86_64.rpm                  | 450 kB     00:29
(9/43): lm_sensors-libs-3.1.1-10.el6.x86_64.rpm          |  37 kB     00:01
(10/43): net-snmp-5.5-37.el6_2.1.x86_64.rpm              | 300 kB     00:14
(11/43): net-snmp-libs-5.5-37.el6_2.1.x86_64.rpm         | 1.5 MB     01:11
(12/43): php-5.3.3-3.el6_2.6.x86_64.rpm                  | 1.1 MB     01:04
(13/43): php-bcmath-5.3.3-3.el6_2.6.x86_64.rpm           |  32 kB     00:01
(14/43): php-cli-5.3.3-3.el6_2.6.x86_64.rpm              | 2.2 MB     01:45
(15/43): php-common-5.3.3-3.el6_2.6.x86_64.rpm           | 522 kB     00:21
(16/43): php-dba-5.3.3-3.el6_2.6.x86_64.rpm              |  38 kB     00:00
(17/43): php-devel-5.3.3-3.el6_2.6.x86_64.rpm            | 505 kB     00:19
(18/43): php-embedded-5.3.3-3.el6_2.6.x86_64.rpm         | 1.1 MB     00:50
(19/43): php-enchant-5.3.3-3.el6_2.6.x86_64.rpm          |  27 kB     00:00
(20/43): php-gd-5.3.3-3.el6_2.6.x86_64.rpm               | 104 kB     00:04
(21/43): php-imap-5.3.3-3.el6_2.6.x86_64.rpm             |  48 kB     00:04
(22/43): php-intl-5.3.3-3.el6_2.6.x86_64.rpm             |  68 kB     00:02
(23/43): php-ldap-5.3.3-3.el6_2.6.x86_64.rpm             |  36 kB     00:01
(24/43): php-mbstring-5.3.3-3.el6_2.6.x86_64.rpm         | 453 kB     00:20
(25/43): php-mysql-5.3.3-3.el6_2.6.x86_64.rpm            |  79 kB     00:03
(26/43): php-odbc-5.3.3-3.el6_2.6.x86_64.rpm             |  48 kB     00:03
(27/43): php-pdo-5.3.3-3.el6_2.6.x86_64.rpm              |  73 kB     00:03
(28/43): php-pear-1.9.4-4.el6.noarch.rpm                 | 393 kB     00:32
(29/43): php-pecl-apc-3.1.3p1-1.2.el6.1.x86_64.rpm       |  93 kB     00:04
(30/43): php-pecl-memcache-3.0.5-3.el6.x86_64.rpm        |  60 kB     00:02
(31/43): php-pgsql-5.3.3-3.el6_2.6.x86_64.rpm            |  68 kB     00:04
(32/43): php-process-5.3.3-3.el6_2.6.x86_64.rpm          |  37 kB     00:01
(33/43): php-pspell-5.3.3-3.el6_2.6.x86_64.rpm           |  26 kB     00:01
(34/43): php-recode-5.3.3-3.el6_2.6.x86_64.rpm           |  23 kB     00:02
(35/43): php-snmp-5.3.3-3.el6_2.6.x86_64.rpm             |  28 kB     00:00
(36/43): php-soap-5.3.3-3.el6_2.6.x86_64.rpm             | 138 kB     00:06
(37/43): php-tidy-5.3.3-3.el6_2.6.x86_64.rpm             |  34 kB     00:01
(38/43): php-xml-5.3.3-3.el6_2.6.x86_64.rpm              | 100 kB     00:16
(39/43): php-xmlrpc-5.3.3-3.el6_2.6.x86_64.rpm           |  50 kB     00:07
(40/43): php-zts-5.3.3-3.el6_2.6.x86_64.rpm              | 1.2 MB     01:54
(41/43): postgresql-libs-8.4.9-1.el6_1.1.x86_64.rpm      | 198 kB     00:07
(42/43): recode-3.6-28.1.el6.x86_64.rpm                  | 712 kB     00:25
(43/43): unixODBC-2.2.14-11.el6.x86_64.rpm               | 378 kB     00:16
--------------------------------------------------------------------------------
Total                                            19 kB/s |  14 MB     12:34
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Installing : php-common-5.3.3-3.el6_2.6.x86_64                           1/43
Installing : php-pdo-5.3.3-3.el6_2.6.x86_64                              2/43
Installing : lm_sensors-libs-3.1.1-10.el6.x86_64                         3/43
Installing : 1:net-snmp-libs-5.5-37.el6_2.1.x86_64                       4/43
Installing : 1:net-snmp-5.5-37.el6_2.1.x86_64                            5/43
Installing : postgresql-libs-8.4.9-1.el6_1.1.x86_64                      6/43
Installing : libedit-2.11-4.20080712cvs.1.el6.x86_64                     7/43
Installing : php-cli-5.3.3-3.el6_2.6.x86_64                              8/43
Installing : 1:php-pear-1.9.4-4.el6.noarch                               9/43
Installing : php-5.3.3-3.el6_2.6.x86_64                                 10/43
Installing : recode-3.6-28.1.el6.x86_64                                 11/43
Installing : 12:aspell-0.60.6-12.el6.x86_64                             12/43
Installing : libxslt-1.1.26-2.el6.x86_64                                13/43
Installing : libc-client-2007e-11.el6.x86_64                            14/43
Installing : libtidy-0.99.0-19.20070615.1.el6.x86_64                    15/43
Installing : libtool-ltdl-2.2.6-15.5.el6.x86_64                         16/43
Installing : unixODBC-2.2.14-11.el6.x86_64                              17/43
Installing : hunspell-1.2.8-16.el6.x86_64                               18/43
Installing : 1:enchant-1.5.0-4.el6.x86_64                               19/43
Installing : php-enchant-5.3.3-3.el6_2.6.x86_64                         20/43
Installing : php-odbc-5.3.3-3.el6_2.6.x86_64                            21/43
Installing : php-tidy-5.3.3-3.el6_2.6.x86_64                            22/43
Installing : php-imap-5.3.3-3.el6_2.6.x86_64                            23/43
Installing : php-xml-5.3.3-3.el6_2.6.x86_64                             24/43
Installing : php-pspell-5.3.3-3.el6_2.6.x86_64                          25/43
Installing : php-recode-5.3.3-3.el6_2.6.x86_64                          26/43
Installing : php-devel-5.3.3-3.el6_2.6.x86_64                           27/43
Installing : php-pecl-apc-3.1.3p1-1.2.el6.1.x86_64                      28/43
Installing : php-pecl-memcache-3.0.5-3.el6.x86_64                       29/43
Installing : php-pgsql-5.3.3-3.el6_2.6.x86_64                           30/43
Installing : php-snmp-5.3.3-3.el6_2.6.x86_64                            31/43
Installing : php-mysql-5.3.3-3.el6_2.6.x86_64                           32/43
Installing : php-gd-5.3.3-3.el6_2.6.x86_64                              33/43
Installing : php-mbstring-5.3.3-3.el6_2.6.x86_64                        34/43
Installing : php-zts-5.3.3-3.el6_2.6.x86_64                             35/43
Installing : php-intl-5.3.3-3.el6_2.6.x86_64                            36/43
Installing : php-embedded-5.3.3-3.el6_2.6.x86_64                        37/43
Installing : php-soap-5.3.3-3.el6_2.6.x86_64                            38/43
Installing : php-process-5.3.3-3.el6_2.6.x86_64                         39/43
Installing : php-bcmath-5.3.3-3.el6_2.6.x86_64                          40/43
Installing : php-ldap-5.3.3-3.el6_2.6.x86_64                            41/43
Installing : php-dba-5.3.3-3.el6_2.6.x86_64                             42/43
Installing : php-xmlrpc-5.3.3-3.el6_2.6.x86_64                          43/43

Installed:
php.x86_64 0:5.3.3-3.el6_2.6
php-bcmath.x86_64 0:5.3.3-3.el6_2.6
php-cli.x86_64 0:5.3.3-3.el6_2.6
php-common.x86_64 0:5.3.3-3.el6_2.6
php-dba.x86_64 0:5.3.3-3.el6_2.6
php-devel.x86_64 0:5.3.3-3.el6_2.6
php-embedded.x86_64 0:5.3.3-3.el6_2.6
php-enchant.x86_64 0:5.3.3-3.el6_2.6
php-gd.x86_64 0:5.3.3-3.el6_2.6
php-imap.x86_64 0:5.3.3-3.el6_2.6
php-intl.x86_64 0:5.3.3-3.el6_2.6
php-ldap.x86_64 0:5.3.3-3.el6_2.6
php-mbstring.x86_64 0:5.3.3-3.el6_2.6
php-mysql.x86_64 0:5.3.3-3.el6_2.6
php-odbc.x86_64 0:5.3.3-3.el6_2.6
php-pdo.x86_64 0:5.3.3-3.el6_2.6
php-pear.noarch 1:1.9.4-4.el6
php-pecl-apc.x86_64 0:3.1.3p1-1.2.el6.1
php-pecl-memcache.x86_64 0:3.0.5-3.el6
php-pgsql.x86_64 0:5.3.3-3.el6_2.6
php-process.x86_64 0:5.3.3-3.el6_2.6
php-pspell.x86_64 0:5.3.3-3.el6_2.6
php-recode.x86_64 0:5.3.3-3.el6_2.6
php-snmp.x86_64 0:5.3.3-3.el6_2.6
php-soap.x86_64 0:5.3.3-3.el6_2.6
php-tidy.x86_64 0:5.3.3-3.el6_2.6
php-xml.x86_64 0:5.3.3-3.el6_2.6
php-xmlrpc.x86_64 0:5.3.3-3.el6_2.6
php-zts.x86_64 0:5.3.3-3.el6_2.6

Dependency Installed:
aspell.x86_64 12:0.60.6-12.el6
enchant.x86_64 1:1.5.0-4.el6
hunspell.x86_64 0:1.2.8-16.el6
libc-client.x86_64 0:2007e-11.el6
libedit.x86_64 0:2.11-4.20080712cvs.1.el6
libtidy.x86_64 0:0.99.0-19.20070615.1.el6
libtool-ltdl.x86_64 0:2.2.6-15.5.el6
libxslt.x86_64 0:1.1.26-2.el6
lm_sensors-libs.x86_64 0:3.1.1-10.el6
net-snmp.x86_64 1:5.5-37.el6_2.1
net-snmp-libs.x86_64 1:5.5-37.el6_2.1
postgresql-libs.x86_64 0:8.4.9-1.el6_1.1
recode.x86_64 0:3.6-28.1.el6
unixODBC.x86_64 0:2.2.14-11.el6

Complete!
[root@linggih ~]#

Setelah php terinstall, restart apache dengan command: /etc/init.d/httpd restart atau service httpd restart

[root@linggih ~]# service httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]
[root@linggih ~]#

Untuk cek info php, buat file php baru dengan nama terserah (misalnya: phpinfo.php). Kemudian isikan code php berikut pada file php:

<?php phpinfo(); ?>

[root@linggih ~]# cd /var/www/html
[root@linggih html]# touch phpinfo.php
[root@linggih html]# nano phpinfo.php
[root@linggih html]#

Buka dokumen halaman php yang baru saja dibuat pada halaman web browser (http://domain-anda/phpinfo.php)

Install PHP: PHP Info

Selesai. Semoga bermanfaat.
:D

Selengkapnya

Install MySQL Server Pada CentOS

MySQL Database Server merupakan database web hosting yang digunakan untuk menyimpan berbagai macam data informasi seperti blog post, detail informasi user, comment dlsb. MySQL merupakan database server yang paling populer dan banyak digunakan oleh webmaster saat ini, dikarenakan selain gratis namun juga sangat fleksibel dan mampu handle berbagai macam tipe dinamic web (PHP, ASP, Perl dlsb).

Install MySQL Database Pada OS CentOS

Berikut cara simpel install MySQL Database Server pada CentOS:. Ketikkan command yum install mysql-server mysql php-mysql

[root@server5 ~]# yum install mysql-server mysql php-mysql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.biz.net.id
* extras: centos.biz.net.id
* updates: mirror.averse.net
Setting up Install Process
Package mysql-5.1.61-1.el6_2.1.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package mysql-server.x86_64 0:5.1.61-1.el6_2.1 will be installed
--> Processing Dependency: perl-DBI for package: mysql-server-5.1.61-1.el6_2.1.x86_64
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.1.61-1.el6_2.1.x86_64
--> Processing Dependency: perl(DBI) for package: mysql-server-5.1.61-1.el6_2.1.x86_64
---> Package php-mysql.x86_64 0:5.3.3-3.el6_2.6 will be installed
--> 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-pdo for package: php-mysql-5.3.3-3.el6_2.6.x86_64
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
---> Package php-common.x86_64 0:5.3.3-3.el6_2.6 will be installed
---> Package php-pdo.x86_64 0:5.3.3-3.el6_2.6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package              Arch         Version                  Repository     Size
================================================================================
Installing:
mysql-server         x86_64       5.1.61-1.el6_2.1         updates       8.1 M
php-mysql            x86_64       5.3.3-3.el6_2.6          updates        79 k
Installing for dependencies:
perl-DBD-MySQL       x86_64       4.013-3.el6              base          134 k
perl-DBI             x86_64       1.609-4.el6              base          705 k
php-common           x86_64       5.3.3-3.el6_2.6          updates       522 k
php-pdo              x86_64       5.3.3-3.el6_2.6          updates        73 k

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

Total download size: 9.6 M
Installed size: 29 M
Is this ok [y/N]: y
Downloading Packages:
(1/6): mysql-server-5.1.61-1.el6_2.1.x86_64.rpm          | 8.1 MB     00:35
http://centos.biz.net.id/6.2/os/x86_64/Packages/perl-DBD-MySQL-4.013-3.el6.x86_64.rpm: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404"
Trying other mirror.
(2/6): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm             | 134 kB     00:00
(3/6): perl-DBI-1.609-4.el6.x86_64.rpm                   | 705 kB     00:03
(4/6): php-common-5.3.3-3.el6_2.6.x86_64.rpm             | 522 kB     00:02
(5/6): php-mysql-5.3.3-3.el6_2.6.x86_64.rpm              |  79 kB     00:00
(6/6): php-pdo-5.3.3-3.el6_2.6.x86_64.rpm                |  73 kB     00:00
--------------------------------------------------------------------------------
Total                                           225 kB/s | 9.6 MB     00:43
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : php-common-5.3.3-3.el6_2.6.x86_64                            1/6
Installing : perl-DBI-1.609-4.el6.x86_64                                  2/6
Installing : perl-DBD-MySQL-4.013-3.el6.x86_64                            3/6
Installing : php-pdo-5.3.3-3.el6_2.6.x86_64                               4/6
Installing : php-mysql-5.3.3-3.el6_2.6.x86_64                             5/6
Installing : mysql-server-5.1.61-1.el6_2.1.x86_64                         6/6

Installed:
mysql-server.x86_64 0:5.1.61-1.el6_2.1   php-mysql.x86_64 0:5.3.3-3.el6_2.6

Dependency Installed:
perl-DBD-MySQL.x86_64 0:4.013-3.el6      perl-DBI.x86_64 0:1.609-4.el6
php-common.x86_64 0:5.3.3-3.el6_2.6      php-pdo.x86_64 0:5.3.3-3.el6_2.6

Complete!
[root@server5 ~]#

Untuk load MySQL service ketika mesin server boot (start up), ketikkan command berikut; chkconfig mysqld on

[root@server5 ~]# chkconfig mysqld on
[root@server5 ~]#

Jalankan MySQL Dengan Command; service mysqld start

[root@server5 ~]# service mysqld start
Initializing MySQL database:  WARNING: The host 'server5' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h server5 password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

[  OK  ]
Starting mysqld:                                           [  OK  ]
[root@server5 ~]#

Set password MySQL root; ketikkan command; mysql -u root. Jika selesai, tekan tombol "Ctrl + C" untuk keluar.

[root@server5 ~]# 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('testingpassword');
Query OK, 0 rows affected (0.00 sec)

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

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

mysql>

mysql> Ctrl-C -- exit!
Aborted
[root@server5 ~]#

Untuk cek versi MySQL, ketikkan command mysql --version

[root@server5 ~]# mysql --version
mysql  Ver 14.14 Distrib 5.1.61, for redhat-linux-gnu (x86_64) using readline 5.1
[root@server5 ~]#

Selesai. Semoga bermanfaat.
:)

Selengkapnya

Install Apache Webserver Pada CentOS

Sebelum konten halaman web dinamic (PHP, ASP, Perl, dlsb) dapat ditampilkan pada halaman web browser, web server (misalnya: apache) harus terlebih dahulu terinstall pada mesin server. Apache merupakan salah satu webserver gratis paling poluler yang banyak digunakan oleh webmaster dan juga dapat handle bermacam tipe website (PHP, ASP, Perl, dlsb). Pada artikel kali ini akan mengulas tentang cara install apache webserver pada sistem operasi CentOS.

Berikut cara simpel install Apache Webserver pada OS CentOS:

Buka terminal atau connect ke webserver menggunakan putty atau program sejenis lainnya, kemudian ketikkan command yum -y groupinstall "Web Server"

[root@server5 ~]# yum -y groupinstall "Web Server"
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.biz.net.id
* extras: centos.biz.net.id
* updates: mirror.averse.net
Setting up Group Process
Checking for new repos for mirrors
http://centos.biz.net.id/6.2/os/x86_64/repodata/badeded316fc87571779d92c5cde816fdc357646b84cb191c4611e05c981ffa1-c6-x86_64-comps.xml.gz: [Errno 14] PYCURL ERROR 18 - "transfer closed with 203863 bytes remaining to read"
Trying other mirror.
base/group_gz                                            | 199 kB     00:00
Warning: Group MySQL Database does not exist.
Resolving Dependencies
--> Running transaction check
---> Package crypto-utils.x86_64 0:2.4.1-24.2.el6 will be installed
--> Processing Dependency: perl(Newt) for package: crypto-utils-2.4.1-24.2.el6.x86_64
---> Package httpd.x86_64 0:2.2.15-15.el6.centos.1 will be installed
--> Processing Dependency: httpd-tools = 2.2.15-15.el6.centos.1 for package: httpd-2.2.15-15.el6.centos.1.x86_64
--> Processing Dependency: /etc/mime.types for package: httpd-2.2.15-15.el6.centos.1.x86_64
--> Processing Dependency: apr-util-ldap for package: httpd-2.2.15-15.el6.centos.1.x86_64
--> Processing Dependency: libaprutil-1.so.0()(64bit) for package: httpd-2.2.15-15.el6.centos.1.x86_64
--> Processing Dependency: libapr-1.so.0()(64bit) for package: httpd-2.2.15-15.el6.centos.1.x86_64
---> Package httpd-manual.noarch 0:2.2.15-15.el6.centos.1 will be installed
---> Package mod_perl.x86_64 0:2.0.4-10.el6 will be installed
--> Processing Dependency: perl(ExtUtils::MakeMaker) for package: mod_perl-2.0.4-10.el6.x86_64
--> Processing Dependency: perl(BSD::Resource) for package: mod_perl-2.0.4-10.el6.x86_64
---> Package mod_ssl.x86_64 1:2.2.15-15.el6.centos.1 will be installed
---> Package mod_wsgi.x86_64 0:3.2-1.el6 will be installed
---> Package webalizer.x86_64 0:2.21_02-3.3.el6 will be installed
--> Processing Dependency: libgd.so.2()(64bit) for package: webalizer-2.21_02-3.3.el6.x86_64
--> Processing Dependency: libpng12.so.0()(64bit) for package: webalizer-2.21_02-3.3.el6.x86_64
--> Running transaction check
---> Package apr.x86_64 0:1.3.9-3.el6_1.2 will be installed
---> Package apr-util.x86_64 0:1.3.9-3.el6_0.1 will be installed
---> Package apr-util-ldap.x86_64 0:1.3.9-3.el6_0.1 will be installed
---> Package gd.x86_64 0:2.0.35-10.el6 will be installed
--> Processing Dependency: libXpm.so.4()(64bit) for package: gd-2.0.35-10.el6.x86_64
--> Processing Dependency: libX11.so.6()(64bit) for package: gd-2.0.35-10.el6.x86_64
--> Processing Dependency: libfontconfig.so.1()(64bit) for package: gd-2.0.35-10.el6.x86_64
--> Processing Dependency: libfreetype.so.6()(64bit) for package: gd-2.0.35-10.el6.x86_64
--> Processing Dependency: libjpeg.so.62()(64bit) for package: gd-2.0.35-10.el6.x86_64
---> Package httpd-tools.x86_64 0:2.2.15-15.el6.centos.1 will be installed
---> Package libpng.x86_64 2:1.2.48-1.el6_2 will be installed
---> Package mailcap.noarch 0:2.1.31-2.el6 will be installed
---> Package perl-BSD-Resource.x86_64 0:1.29.03-3.el6 will be installed
---> Package perl-ExtUtils-MakeMaker.x86_64 0:6.55-119.el6_1.1 will be installed
--> Processing Dependency: perl(Test::Harness) for package: perl-ExtUtils-MakeMaker-6.55-119.el6_1.1.x86_64
--> Processing Dependency: perl-devel for package: perl-ExtUtils-MakeMaker-6.55-119.el6_1.1.x86_64
---> Package perl-Newt.x86_64 0:1.08-26.el6 will be installed
--> Running transaction check
---> Package fontconfig.x86_64 0:2.8.0-3.el6 will be installed
---> Package freetype.x86_64 0:2.3.11-6.el6_2.9 will be installed
---> Package libX11.x86_64 0:1.3-2.el6 will be installed
--> Processing Dependency: libX11-common = 1.3-2.el6 for package: libX11-1.3-2.el6.x86_64
--> Processing Dependency: libxcb.so.1()(64bit) for package: libX11-1.3-2.el6.x86_64
---> Package libXpm.x86_64 0:3.5.8-2.el6 will be installed
---> Package libjpeg.x86_64 0:6b-46.el6 will be installed
---> Package perl-Test-Harness.x86_64 0:3.17-119.el6_1.1 will be installed
---> Package perl-devel.x86_64 4:5.10.1-119.el6_1.1 will be installed
--> Processing Dependency: perl(ExtUtils::ParseXS) for package: 4:perl-devel-5.10.1-119.el6_1.1.x86_64
--> Running transaction check
---> Package libX11-common.noarch 0:1.3-2.el6 will be installed
---> Package libxcb.x86_64 0:1.5-1.el6 will be installed
--> Processing Dependency: libXau.so.6()(64bit) for package: libxcb-1.5-1.el6.x86_64
---> Package perl-ExtUtils-ParseXS.x86_64 1:2.2003.0-119.el6_1.1 will be installed
--> Running transaction check
---> Package libXau.x86_64 0:1.0.5-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package                   Arch     Version                     Repository
Size
================================================================================
Installing:
crypto-utils              x86_64   2.4.1-24.2.el6              base       76 k
httpd                     x86_64   2.2.15-15.el6.centos.1      updates   813 k
httpd-manual              noarch   2.2.15-15.el6.centos.1      updates   781 k
mod_perl                  x86_64   2.0.4-10.el6                base      3.2 M
mod_ssl                   x86_64   1:2.2.15-15.el6.centos.1    updates    87 k
mod_wsgi                  x86_64   3.2-1.el6                   base       66 k
webalizer                 x86_64   2.21_02-3.3.el6             base      128 k
Installing for dependencies:
apr                       x86_64   1.3.9-3.el6_1.2             base      123 k
apr-util                  x86_64   1.3.9-3.el6_0.1             base       87 k
apr-util-ldap             x86_64   1.3.9-3.el6_0.1             base       15 k
fontconfig                x86_64   2.8.0-3.el6                 base      186 k
freetype                  x86_64   2.3.11-6.el6_2.9            updates   359 k
gd                        x86_64   2.0.35-10.el6               base      142 k
httpd-tools               x86_64   2.2.15-15.el6.centos.1      updates    70 k
libX11                    x86_64   1.3-2.el6                   base      582 k
libX11-common             noarch   1.3-2.el6                   base      188 k
libXau                    x86_64   1.0.5-1.el6                 base       22 k
libXpm                    x86_64   3.5.8-2.el6                 base       59 k
libjpeg                   x86_64   6b-46.el6                   base      134 k
libpng                    x86_64   2:1.2.48-1.el6_2            updates   181 k
libxcb                    x86_64   1.5-1.el6                   base      100 k
mailcap                   noarch   2.1.31-2.el6                base       27 k
perl-BSD-Resource         x86_64   1.29.03-3.el6               base       35 k
perl-ExtUtils-MakeMaker   x86_64   6.55-119.el6_1.1            base      290 k
perl-ExtUtils-ParseXS     x86_64   1:2.2003.0-119.el6_1.1      base       42 k
perl-Newt                 x86_64   1.08-26.el6                 base       72 k
perl-Test-Harness         x86_64   3.17-119.el6_1.1            base      229 k
perl-devel                x86_64   4:5.10.1-119.el6_1.1        base      420 k

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

Total download size: 8.3 M
Installed size: 24 M
Downloading Packages:
(1/28): apr-1.3.9-3.el6_1.2.x86_64.rpm                   | 123 kB     00:00
(2/28): apr-util-1.3.9-3.el6_0.1.x86_64.rpm              |  87 kB     00:00
(3/28): apr-util-ldap-1.3.9-3.el6_0.1.x86_64.rpm         |  15 kB     00:00
(4/28): crypto-utils-2.4.1-24.2.el6.x86_64.rpm           |  76 kB     00:00
(5/28): fontconfig-2.8.0-3.el6.x86_64.rpm                | 186 kB     00:00
(6/28): freetype-2.3.11-6.el6_2.9.x86_64.rpm             | 359 kB     00:01
(7/28): gd-2.0.35-10.el6.x86_64.rpm                      | 142 kB     00:00
(8/28): httpd-2.2.15-15.el6.centos.1.x86_64.rpm          | 813 kB     00:03
(9/28): httpd-manual-2.2.15-15.el6.centos.1.noarch.rpm   | 781 kB     00:03
(10/28): httpd-tools-2.2.15-15.el6.centos.1.x86_64.rpm   |  70 kB     00:00
(11/28): libX11-1.3-2.el6.x86_64.rpm                     | 582 kB     00:02
(12/28): libX11-common-1.3-2.el6.noarch.rpm              | 188 kB     00:00
(13/28): libXau-1.0.5-1.el6.x86_64.rpm                   |  22 kB     00:00
(14/28): libXpm-3.5.8-2.el6.x86_64.rpm                   |  59 kB     00:00
(15/28): libjpeg-6b-46.el6.x86_64.rpm                    | 134 kB     00:00
(16/28): libpng-1.2.48-1.el6_2.x86_64.rpm                | 181 kB     00:00
(17/28): libxcb-1.5-1.el6.x86_64.rpm                     | 100 kB     00:00
(18/28): mailcap-2.1.31-2.el6.noarch.rpm                 |  27 kB     00:00
(19/28): mod_perl-2.0.4-10.el6.x86_64.rpm                | 3.2 MB     00:13
(20/28): mod_ssl-2.2.15-15.el6.centos.1.x86_64.rpm       |  87 kB     00:00
(21/28): mod_wsgi-3.2-1.el6.x86_64.rpm                   |  66 kB     00:00
(22/28): perl-BSD-Resource-1.29.03-3.el6.x86_64.rpm      |  35 kB     00:00
(23/28): perl-ExtUtils-MakeMaker-6.55-119.el6_1.1.x86_64 | 290 kB     00:01
(24/28): perl-ExtUtils-ParseXS-2.2003.0-119.el6_1.1.x86_ |  42 kB     00:00
(25/28): perl-Newt-1.08-26.el6.x86_64.rpm                |  72 kB     00:00
(26/28): perl-Test-Harness-3.17-119.el6_1.1.x86_64.rpm   | 229 kB     00:01
(27/28): perl-devel-5.10.1-119.el6_1.1.x86_64.rpm        | 420 kB     00:01
(28/28): webalizer-2.21_02-3.3.el6.x86_64.rpm            | 128 kB     00:00
--------------------------------------------------------------------------------
Total                                           217 kB/s | 8.3 MB     00:39
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Installing : apr-1.3.9-3.el6_1.2.x86_64                                  1/28
Installing : apr-util-1.3.9-3.el6_0.1.x86_64                             2/28
Installing : 2:libpng-1.2.48-1.el6_2.x86_64                              3/28
Installing : freetype-2.3.11-6.el6_2.9.x86_64                            4/28
Installing : fontconfig-2.8.0-3.el6.x86_64                               5/28
Installing : apr-util-ldap-1.3.9-3.el6_0.1.x86_64                        6/28
Installing : httpd-tools-2.2.15-15.el6.centos.1.x86_64                   7/28
Installing : 1:perl-ExtUtils-ParseXS-2.2003.0-119.el6_1.1.x86_64         8/28
Installing : 4:perl-devel-5.10.1-119.el6_1.1.x86_64                      9/28
Installing : perl-Test-Harness-3.17-119.el6_1.1.x86_64                  10/28
Installing : perl-ExtUtils-MakeMaker-6.55-119.el6_1.1.x86_64            11/28
Installing : libXau-1.0.5-1.el6.x86_64                                  12/28
Installing : libxcb-1.5-1.el6.x86_64                                    13/28
Installing : libjpeg-6b-46.el6.x86_64                                   14/28
Installing : mailcap-2.1.31-2.el6.noarch                                15/28
Installing : httpd-2.2.15-15.el6.centos.1.x86_64                        16/28
Installing : perl-Newt-1.08-26.el6.x86_64                               17/28
Installing : perl-BSD-Resource-1.29.03-3.el6.x86_64                     18/28
Installing : libX11-common-1.3-2.el6.noarch                             19/28
Installing : libX11-1.3-2.el6.x86_64                                    20/28
Installing : libXpm-3.5.8-2.el6.x86_64                                  21/28
Installing : gd-2.0.35-10.el6.x86_64                                    22/28
Installing : webalizer-2.21_02-3.3.el6.x86_64                           23/28
Installing : mod_perl-2.0.4-10.el6.x86_64                               24/28
Installing : crypto-utils-2.4.1-24.2.el6.x86_64                         25/28
Installing : httpd-manual-2.2.15-15.el6.centos.1.noarch                 26/28
Installing : mod_wsgi-3.2-1.el6.x86_64                                  27/28
Installing : 1:mod_ssl-2.2.15-15.el6.centos.1.x86_64                    28/28

Installed:
crypto-utils.x86_64 0:2.4.1-24.2.el6
httpd.x86_64 0:2.2.15-15.el6.centos.1
httpd-manual.noarch 0:2.2.15-15.el6.centos.1
mod_perl.x86_64 0:2.0.4-10.el6
mod_ssl.x86_64 1:2.2.15-15.el6.centos.1
mod_wsgi.x86_64 0:3.2-1.el6
webalizer.x86_64 0:2.21_02-3.3.el6

Dependency Installed:
apr.x86_64 0:1.3.9-3.el6_1.2
apr-util.x86_64 0:1.3.9-3.el6_0.1
apr-util-ldap.x86_64 0:1.3.9-3.el6_0.1
fontconfig.x86_64 0:2.8.0-3.el6
freetype.x86_64 0:2.3.11-6.el6_2.9
gd.x86_64 0:2.0.35-10.el6
httpd-tools.x86_64 0:2.2.15-15.el6.centos.1
libX11.x86_64 0:1.3-2.el6
libX11-common.noarch 0:1.3-2.el6
libXau.x86_64 0:1.0.5-1.el6
libXpm.x86_64 0:3.5.8-2.el6
libjpeg.x86_64 0:6b-46.el6
libpng.x86_64 2:1.2.48-1.el6_2
libxcb.x86_64 0:1.5-1.el6
mailcap.noarch 0:2.1.31-2.el6
perl-BSD-Resource.x86_64 0:1.29.03-3.el6
perl-ExtUtils-MakeMaker.x86_64 0:6.55-119.el6_1.1
perl-ExtUtils-ParseXS.x86_64 1:2.2003.0-119.el6_1.1
perl-Newt.x86_64 0:1.08-26.el6
perl-Test-Harness.x86_64 0:3.17-119.el6_1.1
perl-devel.x86_64 4:5.10.1-119.el6_1.1

Complete!
[root@server5 ~]#

Kemudian jalankan apache webserver dengan mengetikkan command service httpd start.

[root@server5 ~]# service httpd start
Starting httpd: httpd: apr_sockaddr_info_get() failed for server5
httpd: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName
[  OK  ]
[root@server5 src]#

Untuk load apache ketika mesin boot (start up), ketikkan command chkconfig httpd on.

[root@server5 ~]# chkconfig httpd on
[root@server5 ~]#

Untuk cek versi apache, ketikkan command rpm -q httpd.

[root@server5 ~]# rpm -q httpd
httpd-2.2.15-15.el6.centos.1.x86_64
[root@server5 ~]#

Screenshot tampilan halaman default apache:

Apache Default Page

Selesai. Semoga Membantu...
:)

Selengkapnya

Halaman

Test Block Top

Ubuntu Server "Setup Home Dedicated Server"

Syarat Minimal Home Dedicated Server

Download Ubuntu Server

Install Ubuntu Server

Update Komponen Sistem

Install Apache, MySQL & PHP

Konfigurasi Firewall

Install Script Website

Setting Remote Server

Trik Membuat Home Dedicated Server Dapat Diakses Via Internet

Install phpMyAdmin Via yum Pada CentOS

Download & Install EPEL Repository

Download & Install Remi Repository

Install phpMyAdmin

Setting database phpMyAdmin

Buat database phpMyAdmin

Control-User

Import Table

Edit File Konfigurasi

Test phpMyAdmin

Windows 7 Trick "GodMode" All In One Control Panel Applet

Install PHP Pada CentOS

Install MySQL Server Pada CentOS

Install MySQL Database Pada OS CentOS

Install Apache Webserver Pada CentOS

Link 2 My Blog

Recent Posts

Stay Connected

Experience the joy of sharing!

E-Mail: