Install PDO MySQL Pada Centos

Apa itu PDO MySQL? PDO adalah singkatan dari PHP Data Objects, berdasarkan wiki mysql.com, PDO adalah...

PDO_MYSQL is the MySQL driver for PDO (PHP Data Objects). Under the name PDO_MYSQLND a patch which allows to compile PDO_MYSQL against the MySQL native driver for PHP (mysqlnd) or the mysql client library (like ever since) has been developed.

Pada artikel tidak akan mengulas apa itu PDO, namun cara install PDO MySQL pada OS CentOS. Untuk mulai install PDO MySQL, ketikkan command:

yum install php-devel php-pear mysql-devel httpd-devel

[bash]
[root@linggih ~]# yum install php-devel php-pear mysql-devel httpd-devel
...
...
--> Processing Dependency: libapr-1.so.0()(64bit) for package: apr-devel-1.3.9-3.el6_1.2.x86_64
---> Package apr-util-devel.x86_64 0:1.3.9-3.el6_0.1 will be installed
--> Processing Dependency: apr-util = 1.3.9-3.el6_0.1 for package: apr-util-devel-1.3.9-3.el6_0.1.x86_64
--> Processing Dependency: openldap-devel for package: apr-util-devel-1.3.9-3.el6_0.1.x86_64
--> Processing Dependency: db4-devel for package: apr-util-devel-1.3.9-3.el6_0.1.x86_64
--> Processing Dependency: expat-devel for package: apr-util-devel-1.3.9-3.el6_0.1.x86_64
--> Processing Dependency: libaprutil-1.so.0()(64bit) for package: apr-util-devel-1.3.9-3.el6_0.1.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
---> Package mysql.x86_64 0:5.1.61-1.el6_2.1 will be installed
---> Package openssl-devel.x86_64 0:1.0.0-20.el6_2.4 will be installed
--> Processing Dependency: zlib-devel for package: openssl-devel-1.0.0-20.el6_2.4.x86_64
--> Processing Dependency: krb5-devel for package: openssl-devel-1.0.0-20.el6_2.4.x86_64
---> Package php.x86_64 0:5.3.3-3.el6_2.8 will be installed
--> Processing Dependency: php-common = 5.3.3-3.el6_2.8 for package: php-5.3.3-3.el6_2.8.x86_64
---> Package php-cli.x86_64 0:5.3.3-3.el6_2.8 will be installed
--> Processing Dependency: libedit.so.0()(64bit) for package: php-cli-5.3.3-3.el6_2.8.x86_64
---> Package pkgconfig.x86_64 1:0.23-9.1.el6 will be installed
--> 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 db4-devel.x86_64 0:4.7.25-16.el6 will be installed
--> Processing Dependency: db4-cxx = 4.7.25-16.el6 for package: db4-devel-4.7.25-16.el6.x86_64
--> Processing Dependency: libdb_cxx-4.7.so()(64bit) for package: db4-devel-4.7.25-16.el6.x86_64
---> Package expat-devel.x86_64 0:2.0.1-9.1.el6 will be installed
---> Package httpd-tools.x86_64 0:2.2.15-15.el6.centos.1 will be installed
---> Package krb5-devel.x86_64 0:1.9-22.el6_2.1 will be installed
--> Processing Dependency: libcom_err-devel for package: krb5-devel-1.9-22.el6_2.1.x86_64
--> Processing Dependency: keyutils-libs-devel for package: krb5-devel-1.9-22.el6_2.1.x86_64
--> Processing Dependency: libselinux-devel for package: krb5-devel-1.9-22.el6_2.1.x86_64
---> Package libedit.x86_64 0:2.11-4.20080712cvs.1.el6 will be installed
---> Package mailcap.noarch 0:2.1.31-2.el6 will be installed
---> Package openldap-devel.x86_64 0:2.4.23-20.el6 will be installed
--> Processing Dependency: cyrus-sasl-devel >= 2.1 for package: openldap-devel-2.4.23-20.el6.x86_64
---> Package php-common.x86_64 0:5.3.3-3.el6_2.8 will be installed
---> Package zlib-devel.x86_64 0:1.2.3-27.el6 will be installed
--> Running transaction check
---> Package cyrus-sasl-devel.x86_64 0:2.1.23-13.el6 will be installed
---> Package db4-cxx.x86_64 0:4.7.25-16.el6 will be installed
---> Package keyutils-libs-devel.x86_64 0:1.4-3.el6 will be installed
---> Package libcom_err-devel.x86_64 0:1.41.12-11.el6 will be installed
---> Package libselinux-devel.x86_64 0:2.0.94-5.2.el6 will be installed
--> Processing Dependency: libsepol-devel >= 2.0.32-1 for package: libselinux-devel-2.0.94-5.2.el6.x86_64
--> Processing Dependency: pkgconfig(libsepol) for package: libselinux-devel-2.0.94-5.2.el6.x86_64
--> Running transaction check
---> Package libsepol-devel.x86_64 0:2.0.41-4.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
httpd-devel x86_64 2.2.15-15.el6.centos.1 updates 147 k
mysql-devel x86_64 5.1.61-1.el6_2.1 updates 127 k
php-devel x86_64 5.3.3-3.el6_2.8 updates 506 k
php-pear noarch 1:1.9.4-4.el6 base 393 k
Installing for dependencies:
apr x86_64 1.3.9-3.el6_1.2 base 123 k
apr-devel x86_64 1.3.9-3.el6_1.2 base 176 k
apr-util x86_64 1.3.9-3.el6_0.1 base 87 k
apr-util-devel x86_64 1.3.9-3.el6_0.1 base 69 k
apr-util-ldap x86_64 1.3.9-3.el6_0.1 base 15 k
cyrus-sasl-devel x86_64 2.1.23-13.el6 base 302 k
db4-cxx x86_64 4.7.25-16.el6 base 590 k
db4-devel x86_64 4.7.25-16.el6 base 6.6 M
expat-devel x86_64 2.0.1-9.1.el6 base 119 k
httpd x86_64 2.2.15-15.el6.centos.1 updates 813 k
httpd-tools x86_64 2.2.15-15.el6.centos.1 updates 70 k
keyutils-libs-devel x86_64 1.4-3.el6 base 28 k
krb5-devel x86_64 1.9-22.el6_2.1 updates 1.2 M
libcom_err-devel x86_64 1.41.12-11.el6 base 31 k
libedit x86_64 2.11-4.20080712cvs.1.el6 base 74 k
libselinux-devel x86_64 2.0.94-5.2.el6 base 136 k
libsepol-devel x86_64 2.0.41-4.el6 base 64 k
mailcap noarch 2.1.31-2.el6 base 27 k
mysql x86_64 5.1.61-1.el6_2.1 updates 881 k
openldap-devel x86_64 2.4.23-20.el6 base 1.1 M
openssl-devel x86_64 1.0.0-20.el6_2.4 updates 1.1 M
php x86_64 5.3.3-3.el6_2.8 updates 1.1 M
php-cli x86_64 5.3.3-3.el6_2.8 updates 2.2 M
php-common x86_64 5.3.3-3.el6_2.8 updates 522 k
pkgconfig x86_64 1:0.23-9.1.el6 base 70 k
zlib-devel x86_64 1.2.3-27.el6 base 44 k

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

Total download size: 19 M
Installed size: 64 M
Is this ok [y/N]: y
Downloading Packages:
http://centos.biz.net.id/6.2/os/x86_64/Packages/apr-1.3.9-3.el6_1.2.x86_64.rpm: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404"
Trying other mirror.
(1/30): apr-1.3.9-3.el6_1.2.x86_64.rpm | 123 kB 00:00
(2/30): apr-devel-1.3.9-3.el6_1.2.x86_64.rpm | 176 kB 00:00
(3/30): apr-util-1.3.9-3.el6_0.1.x86_64.rpm | 87 kB 00:00
(4/30): apr-util-devel-1.3.9-3.el6_0.1.x86_64.rpm | 69 kB 00:00
(5/30): apr-util-ldap-1.3.9-3.el6_0.1.x86_64.rpm | 15 kB 00:00
(6/30): cyrus-sasl-devel-2.1.23-13.el6.x86_64.rpm | 302 kB 00:01
(7/30): db4-cxx-4.7.25-16.el6.x86_64.rpm | 590 kB 00:02
(8/30): db4-devel-4.7.25-16.el6.x86_64.rpm | 6.6 MB 00:29
(9/30): expat-devel-2.0.1-9.1.el6.x86_64.rpm | 119 kB 00:00
(10/30): httpd-2.2.15-15.el6.centos.1.x86_64.rpm | 813 kB 00:03
(11/30): httpd-devel-2.2.15-15.el6.centos.1.x86_64.rpm | 147 kB 00:00
(12/30): httpd-tools-2.2.15-15.el6.centos.1.x86_64.rpm | 70 kB 00:00
(13/30): keyutils-libs-devel-1.4-3.el6.x86_64.rpm | 28 kB 00:00
(14/30): krb5-devel-1.9-22.el6_2.1.x86_64.rpm | 1.2 MB 00:05
(15/30): libcom_err-devel-1.41.12-11.el6.x86_64.rpm | 31 kB 00:00
(16/30): libedit-2.11-4.20080712cvs.1.el6.x86_64.rpm | 74 kB 00:00
(17/30): libselinux-devel-2.0.94-5.2.el6.x86_64.rpm | 136 kB 00:00
(18/30): libsepol-devel-2.0.41-4.el6.x86_64.rpm | 64 kB 00:00
(19/30): mailcap-2.1.31-2.el6.noarch.rpm | 27 kB 00:00
(20/30): mysql-5.1.61-1.el6_2.1.x86_64.rpm | 881 kB 00:03
(21/30): mysql-devel-5.1.61-1.el6_2.1.x86_64.rpm | 127 kB 00:00
(22/30): openldap-devel-2.4.23-20.el6.x86_64.rpm | 1.1 MB 00:04
(23/30): openssl-devel-1.0.0-20.el6_2.4.x86_64.rpm | 1.1 MB 00:05
(24/30): php-5.3.3-3.el6_2.8.x86_64.rpm | 1.1 MB 00:04
(25/30): php-cli-5.3.3-3.el6_2.8.x86_64.rpm | 2.2 MB 00:09
(26/30): php-common-5.3.3-3.el6_2.8.x86_64.rpm | 522 kB 00:02
(27/30): php-devel-5.3.3-3.el6_2.8.x86_64.rpm | 506 kB 00:02
(28/30): php-pear-1.9.4-4.el6.noarch.rpm | 393 kB 00:01
(29/30): pkgconfig-0.23-9.1.el6.x86_64.rpm | 70 kB 00:00
(30/30): zlib-devel-1.2.3-27.el6.x86_64.rpm | 44 kB 00:00
--------------------------------------------------------------------------------
Total 228 kB/s | 19 MB 01:23
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : 1:pkgconfig-0.23-9.1.el6.x86_64 1/30
Installing : apr-1.3.9-3.el6_1.2.x86_64 2/30
Installing : apr-util-1.3.9-3.el6_0.1.x86_64 3/30
Installing : apr-devel-1.3.9-3.el6_1.2.x86_64 4/30
Installing : php-common-5.3.3-3.el6_2.8.x86_64 5/30
Installing : apr-util-ldap-1.3.9-3.el6_0.1.x86_64 6/30
Installing : httpd-tools-2.2.15-15.el6.centos.1.x86_64 7/30
Installing : zlib-devel-1.2.3-27.el6.x86_64 8/30
Installing : libcom_err-devel-1.41.12-11.el6.x86_64 9/30
Installing : libsepol-devel-2.0.41-4.el6.x86_64 10/30
Installing : libselinux-devel-2.0.94-5.2.el6.x86_64 11/30
Installing : expat-devel-2.0.1-9.1.el6.x86_64 12/30
Installing : cyrus-sasl-devel-2.1.23-13.el6.x86_64 13/30
Installing : openldap-devel-2.4.23-20.el6.x86_64 14/30
Installing : libedit-2.11-4.20080712cvs.1.el6.x86_64 15/30
Installing : php-cli-5.3.3-3.el6_2.8.x86_64 16/30
Installing : mailcap-2.1.31-2.el6.noarch 17/30
Installing : httpd-2.2.15-15.el6.centos.1.x86_64 18/30
Installing : php-5.3.3-3.el6_2.8.x86_64 19/30
Installing : db4-cxx-4.7.25-16.el6.x86_64 20/30
Installing : db4-devel-4.7.25-16.el6.x86_64 21/30
Installing : apr-util-devel-1.3.9-3.el6_0.1.x86_64 22/30
Installing : mysql-5.1.61-1.el6_2.1.x86_64 23/30
Installing : keyutils-libs-devel-1.4-3.el6.x86_64 24/30
Installing : krb5-devel-1.9-22.el6_2.1.x86_64 25/30
Installing : openssl-devel-1.0.0-20.el6_2.4.x86_64 26/30
Installing : mysql-devel-5.1.61-1.el6_2.1.x86_64 27/30
Installing : httpd-devel-2.2.15-15.el6.centos.1.x86_64 28/30
Installing : php-devel-5.3.3-3.el6_2.8.x86_64 29/30
Installing : 1:php-pear-1.9.4-4.el6.noarch 30/30

Installed:
httpd-devel.x86_64 0:2.2.15-15.el6.centos.1
mysql-devel.x86_64 0:5.1.61-1.el6_2.1
php-devel.x86_64 0:5.3.3-3.el6_2.8
php-pear.noarch 1:1.9.4-4.el6

Dependency Installed:
apr.x86_64 0:1.3.9-3.el6_1.2
apr-devel.x86_64 0:1.3.9-3.el6_1.2
apr-util.x86_64 0:1.3.9-3.el6_0.1
apr-util-devel.x86_64 0:1.3.9-3.el6_0.1
apr-util-ldap.x86_64 0:1.3.9-3.el6_0.1
cyrus-sasl-devel.x86_64 0:2.1.23-13.el6
db4-cxx.x86_64 0:4.7.25-16.el6
db4-devel.x86_64 0:4.7.25-16.el6
expat-devel.x86_64 0:2.0.1-9.1.el6
httpd.x86_64 0:2.2.15-15.el6.centos.1
httpd-tools.x86_64 0:2.2.15-15.el6.centos.1
keyutils-libs-devel.x86_64 0:1.4-3.el6
krb5-devel.x86_64 0:1.9-22.el6_2.1
libcom_err-devel.x86_64 0:1.41.12-11.el6
libedit.x86_64 0:2.11-4.20080712cvs.1.el6
libselinux-devel.x86_64 0:2.0.94-5.2.el6
libsepol-devel.x86_64 0:2.0.41-4.el6
mailcap.noarch 0:2.1.31-2.el6
mysql.x86_64 0:5.1.61-1.el6_2.1
openldap-devel.x86_64 0:2.4.23-20.el6
openssl-devel.x86_64 0:1.0.0-20.el6_2.4
php.x86_64 0:5.3.3-3.el6_2.8
php-cli.x86_64 0:5.3.3-3.el6_2.8
php-common.x86_64 0:5.3.3-3.el6_2.8
pkgconfig.x86_64 1:0.23-9.1.el6
zlib-devel.x86_64 0:1.2.3-27.el6

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

yum install php-pdo

[bash]
[root@linggih ~]# yum install php-pdo
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.biz.net.id
* extras: centos.biz.net.id
* updates: centos.idrepo.or.id
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php-pdo.x86_64 0:5.3.3-3.el6_2.8 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
php-pdo x86_64 5.3.3-3.el6_2.8 updates 73 k

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

Total download size: 73 k
Installed size: 168 k
Is this ok [y/N]: y
Downloading Packages:
php-pdo-5.3.3-3.el6_2.8.x86_64.rpm | 73 kB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : php-pdo-5.3.3-3.el6_2.8.x86_64 1/1

Installed:
php-pdo.x86_64 0:5.3.3-3.el6_2.8

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

PHP_PDO_SHARED=1 yum install php-pdo_mysql

[bash]
[root@linggih ~]# PHP_PDO_SHARED=1 yum install php-pdo_mysql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.biz.net.id
* extras: centos.biz.net.id
* updates: centos.idrepo.or.id
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php-mysql.x86_64 0:5.3.3-3.el6_2.8 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
php-mysql x86_64 5.3.3-3.el6_2.8 updates 79 k

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

Total download size: 79 k
Installed size: 215 k
Is this ok [y/N]: y
Downloading Packages:
php-mysql-5.3.3-3.el6_2.8.x86_64.rpm | 79 kB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : php-mysql-5.3.3-3.el6_2.8.x86_64 1/1

Installed:
php-mysql.x86_64 0:5.3.3-3.el6_2.8

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

Restart Apache

service httpd restart atau /etc/init.d/httpd restart

[bash collapse="false"]
[root@linggih ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name, using linggih.sytes.net for ServerName
[ OK ]
[root@linggih ~]#
[/bash]

Cek php extention. pdo_mysql (lihat pada baris ke-26)

php -me

[bash highlight="26"]
[root@linggih ~]# php -me
[PHP Modules]
bz2
calendar
Core
ctype
curl
date
ereg
exif
fileinfo
filter
ftp
gettext
gmp
hash
iconv
json
libxml
mysql
mysqli
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
readline
Reflection
session
shmop
SimpleXML
sockets
SPL
sqlite3
standard
tokenizer
xml
zip
zlib

[Zend Modules]

[root@linggih ~]#
[/bash]

Semoga bermanfaat...
:D

Selengkapnya

Install Litespeed Webserver

Berikut Panduan Tutorial Singkat Command Line Install Litespeed Webserver

General Install:

Latest Version Download Link:
http://www.litespeedtech.com/litespeed-web-server-downloads.html

Command:

[bash collapse="false"]
[root@localhost ~]# wget http://www.litespeedtech.com/packages/4.0/lsws-4.0.20-ent-x86_64-linux.tar.gz
[root@localhost ~]# tar zxvf lsws-4.0.20-ent-x86_64-linux.tar.gz
[root@localhost lsws-4.0.20]# cd lsws-4.0.20
[root@localhost lsws-4.0.20]# sh install.sh
[root@localhost lsws-4.0.20]# cd ..
[/bash]

WHM Plugin Install Command

Command:

[bash collapse="false"]
[root@localhost ~]# cd /usr/src
[root@localhost src]# wget http://www.litespeedtech.com/packages/cpanel/lsws_whm_plugin_install.sh
[root@localhost src]# sh ./lsws_whm_plugin_install.sh
[root@localhost src]# rm -f lsws_whm_plugin_install.sh
[/bash]

Referensi:

1. http://www.litespeedtech.com/docs/webserver/admin/ServerStat_Help.html


2. http://www.litespeedtech.com/docs/webserver/install/config.html


3. http://www.litespeedtech.com/docs/webserver/install/

Selengkapnya

Install Nginx Webserver Webmin Plugin

Tutorial Install Nginx Webserver Webmin Plugin

» Buka link 'Webmin' → 'Webmin Configuration' → 'Webmin Modules'

[caption id="attachment_1291" align="alignnone" width="150" caption="Webmin Modules"][/caption]

» Pada halaman 'Install Module', silahkan pilih mode instalasi (local file, uploaded file, ftp/http url). Pada artikel ini akan menggunakan type instalasi ftp/http url. Klik checkbox 'From ftp or http URL', kemudian isikan dengan alamat url download.

Contoh: https://github.com/downloads/vixh/nginx-webmin/nginx0.0.2.wbm.gz (dapat dilihat pada alamat url https://github.com/vixh/nginx-webmin/downloads).

» Klik tombol Install Module

[caption id="attachment_1292" align="alignleft" width="150" caption="Install Module"][/caption][caption id="attachment_1293" align="alignleft" width="150" caption="Module Installed"][/caption]

Selesai. Manage Nginx di menu "Servers" > "Nginx Webserver".

[caption id="attachment_1294" align="alignnone" width="150" caption="Webmin Nginx Webserver"][/caption]

Selengkapnya

Upload Error: File Size Melebihi Batas Upload Maksimal

Upload Error: File Melebihi Batas Upload Maksimal. Berikut peringatan yang muncul ketika execute tombol upload:

"The uploaded file exceeds the upload_max_filesize directive in php.ini"

[caption id="" align="alignnone" width="700" caption="Upload Error WordPress"][/caption]

Error di atas muncul jika file yang diimport melebihi ukuran batas maksimal, misal; 2 MB. Solusinya adalah dengan meningkatkan batas upload maksimal ke nilai (value) yang lebih tinggi, caranya seperti berikut:

» Buka File "php.ini" (/etc/php.ini) → asumsi, OS menggunakan CentOS.

» Edit value upload_max_filesize ke nilai yang lebih besar (misalnya; upload_max_filesize = 50M).

[apache collapse="false"]
;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;

; Whether to allow HTTP file uploads.
file_uploads = On

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
;upload_tmp_dir =

; Maximum allowed size for uploaded files.
upload_max_filesize = 50M
[/apache]

» Restart apache webserver

Command:

service httpd restart

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

Atau jika anda tidak punya akses ke direktori file /etc/php.ini (menggunakan shared hosting account), cari atau buat file baru pada direktori root website (public_html atau htdocs) → edit/buat baru file .htaccess atau php.ini. Kemudian tambahkan code seperti di bawah:

php_value upload_max_filesize 50M

Simpan file & coba upload ulang.

Selengkapnya

Website Tidak Bisa Dibuka Meskipun Modul mod_rewrite On

Beberapa hari yang lalu saya coba installkan blog wordpress teman pada vps. Setting permalink saya set ke "Custom Structure → /%category%/%postname%/", file .htaccess baru sudah otomatis tersetup namun ketika test buka halaman posting website error (Not Found).

Berikut Solusinya:

Cek dulu apakah modul mod_rewrite sudah aktif pada webserver apache, login ssh & ketikkan command:

apachectl -M

[bash highlight="6"]
[root@victor ~]# apachectl -M
Loaded Modules:
...
...
alias_module (shared)
rewrite_module (shared)
...
...
cgi_module (shared)
version_module (shared)
...
...
python_module (shared)
ssl_module (shared)
Syntax OK
[/bash]

Jika modul rewrite sudah aktif (rewrite_module (shared)) → baris ke-6 pada code di atas, kemungkinan AllowOverride pada file konfigurasi apache (httpd.conf) masih di set ke "None" (AllowOverride None).

Edit value "AllowOverride None" ke "AllowOverride All" pada file httpd.conf (/etc/httpd/conf/httpd.conf) untuk semua dokumen root direktori (biasanya "/var/www/html") → lihat baris ke-17 pada code di bawah.

[apache highlight="17"]
# DocumentRoot: The directory out of which you will serve your
# documents. By default, all requests are taken from this directory, but
# symbolic links and aliases may be used to point to other locations.
#
DocumentRoot "/var/www/html"

#
# Each directory to which Apache has access can be configured with respect
# to which services and features are allowed and/or disabled in that
# directory (and its subdirectories).
#
# First, we configure the "default" to be a very restrictive set of
# features.
#
<Directory />
Options FollowSymLinks
AllowOverride All
</Directory>
[/apache]

Restart apache daemon:

[bash collapse="false"]
[root@victor ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]
[root@victor ~]#
[/bash]

Selesai, refresh halaman yang tadinya tidak bisa di buka (Not Found).

Selengkapnya

5 Kesalahan Dalam Melakukan Link Exchange

1. Memasang semua link pada satu halaman web.
   
   Membuat halaman khusus yang berisi kumpulan link exchange dengan mudah akan terdeteksi oleh search engine. Search akan mendeteksi halaman ini sebagai halaman "Link Exchange" dimana aktifitas link exchange ini dikategorikan illegal oleh search engine.
2. Tukar link dengan website/blog yang tidak relevan.
   
   Google tidak hanya memperhatikan kuantitas dan kualitas link, tetapi tingkat relevansi dari source link (link sumber) ke link lainnya juga dipertimbangkan. Karena, link dari web/blog lain yang mempunyai PageRank tinggi dengan topik yang sama biasanya lebih cepat meningkatkan PageRank web/blog anda. Harap selalu diingat dalam melakukan tukar link dengan situs lain, selalu pertimbangkan memilih situs yang memiliki topik yang sama (relevan) dengan situs anda.
3. Tukar link tanpa ada backlink.
   
   Ini adalah kesalahan umum yang biasa dilakukan oleh blogger pemula. Ketika blogger pasang link, mereka yakin bahwa web/blog mereka juga akan dipasang pada web/blog partner link yang bersangkutan. Namun pada kenyataannya, blog owner partner link kadang-kadang lupa atau bahkan mengabaikan request link exchange ini. Hal ini bisa terjadi jika request exchange link yang diajukan masuk ke folder spam (SPAM Box), jadi dengan mudah mereka akan mengabaikan request link exchange ini atau pesan terhapus karena banyaknya email spam & webmaster partner link malas/tidak sempat cek spam satu-persatu.
4. Menggunakan Anchor Text yang tidak relevan saat tukar link.
   
   Anchor Text adalah kata atau kalimat (text) yang tampak (muncul) pada suatu link. Jika ingin memeperoleh hasil optimal pada SERP (Search Engine Results Page) berdasarkan keyword tertentu, disarankan menggunakan relevan keyword pada anchor text link blog anda. Tetapi dengan syarat anchor text yang dipasang pada blog lain ini harus relevan dengan topic web/blog partner link yang bersangkutan. Tidak kalah penting, tambahkan juga title link pada anchor text link web/blog anda.
5. Tukarlah link dengan web/blog yang mempunyai page rank tinggi.
   
   Memang benar tukar link dengan blog yang mempunyai PageRank tinggi dapat membantu meningkatkan PageRank web/blog anda. Namun, tolak ukur page rank google seperti dijelaskan di atas harus memperhatikan kualitas, kuantitas dan tingkat relevansi topic blog partner link.

Semoga bermanfaat...
:)

Selengkapnya

Membuat Form Kontak Menggunakan Simple PHP Script

Jika pada posting sebelumnya tentang cara membuat form kontak dengan menggunakan google docs & online form generator, sekarang sedikit mengulas tentang Cara Membuat Kontak Form Dengan Menggunakan Simple PHP Script.

Langsung saja & tanpa banyak basa-basi. Begini tahapannya:

Buat dahulu file phpnya.

[php]
<?php

if(!$_POST) exit;

$email = $_POST['email'];


//$error[] = preg_match('/\b[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}\b/i', $_POST['email']) ? '' : 'INVALID EMAIL ADDRESS';
if(!eregi("^[a-z0-9]+([_\\.-][a-z0-9]+)*" ."@"."([a-z0-9]+([\.-][a-z0-9]+)*)+"."\\.[a-z]{2,}"."$",$email )){
$error.="Alamat email yang anda masukkan tidak valid";
$errors=1;
}
if($errors==1) echo $error;
else{
$values = array ('nama','email','pesan');
$required = array('nama','email','pesan');

$your_email = "emailanda@email.com";
$email_subject = "Pesan baru: ".$_POST['subject'];
$email_content = "Isi pesan:\n";

foreach($values as $key => $value){
if(in_array($value,$required)){
if ($key != 'subject' && $key != 'subject') {
if( empty($_POST[$value]) ) { echo 'Jangan kosongkan field yang wajib diisi'; exit; }
}
$email_content .= $value.': '.$_POST[$value]."\n";
}
}

if(@mail($your_email,$email_subject,$email_content)) {
echo 'Pesan terkirim! Terima Kasih. Secepatnya kami akan menanggapi pesan anda.';
} else {
echo 'ERROR!';
}
}
?>
[/php]

Copy dan pastekan kode di atas pada text editor (notepad misalnya) dan berilah nama terserah & diakhiri dengan file extention php (.php), atau;

Download filenya di sini.

Yang harus anda edit:

"Alamat email yang anda masukkan tidak valid" → Notifikasi ke visitor jika input alamat email yang di isi tidak valid.

"emailanda@email.com" → alamat email dimana seluruh konten isi pesan akan dikirimkan (isikan dengan alamat email anda).

"Pesan baru: ".$_POST['subject']" → Subjek pesan yang akan ditampilkan di alamat email anda (Pesan baru: diikuti dengan subjek pesan yang diisikan pada form kontak). Ganti tulisan "Subjek pesan:" dengan text terserah anda.

"Pesan terkirim! Terima Kasih. Secepatnya kami akan menanggapi pesan anda." → Ganti dengan kata-kata anda.

Upload file php di atas ke web server, atau jika anda akan menggunakan form kontak ini di blogspot, upload ke google site.

Selanjutnya, copy dan pastekan kode di bawah ini antara tag "<head> Kode di sini </head>" (blogspot → sisipkan kode ini pada tab "Edit HTML").

[jscript]
<script type="text/javascript">
// <![CDATA[
jQuery(document).ready(function(){
$('#contactform').submit(function(){
var action = $(this).attr('action');
$.post(action, {
Nama: $('#nama').val(),
eMail: $('#email').val(),
Subject: $('#subject').val(),
Pesan: $('#pesan').val()
},
function(data){
$('#contactform #submit').attr('disabled','');
$('.response').remove();
$('#contactform').before('<p class="response">'+data+'');
$('.response').slideDown();
if(data=='Pesan terkirim! Terima Kasih. Secepatnya kami akan menanggapi pesan anda.') $('#contactform').slideUp();
}
);
return false;
});
});
// ]]>
</script>
[/jscript]

Buat property css untuk kontak form. CSS ini terserah mau anda buat seperti apa, namun ID form harus sama dengan tag ID & Class yang ada pada kode script di atas ("#contactform" dan ".response").

Untuk blogspot, copy dan pastekan kode di bawah ini di atas kode "]]>" pada tab "Edit HTML".

[css]
#contactform {margin:0; padding:5px 10px;}
#contactform * {color:#222222;}
#contactform ol {margin:0; padding:0; list-style:none;}
#contactform li {margin:0; padding:0; background:none; border:none; display:block;}
#contactform li.buttons {margin:5px 0 5px 0;}
#contactform label {margin:0; width:110px; display:block; padding:5px 0; font:normal 12px Arial, Helvetica, sans-serif; color:#2c2c2c; text-transform:capitalize;}
#contactform label span {display:block; font:normal 10px Arial, Helvetica, sans-serif;}
#contactform input.text {width:440px; border:1px solid #dcdcdc; margin:5px 0; padding:5px 2px; height:16px; background:#f5f5f5;}
#contactform input.text:hover {border: 1px solid #048bfe;background:#fff; cursor: default}
#contactform input.text:focus {color:#222; border: 1px solid #048bfe; background:#fff; cursor:text;}
#contactform textarea {width:440px; border:1px solid #dcdcdc; margin:10px 0; padding:2px; background:#f5f5f5;}
#contactform textarea:hover {border: 1px solid #048bfe;background:#fff; cursor: default}
#contactform textareat:focus {color:#222; border: 1px solid #048bfe; background:#fff; cursor:text;}
#contactform li.buttons input {padding:3px 0; margin:0; border:0; color:#FFF;}
p.response {text-align:center; color:#2c2c2c; font:bold 11px Arial, Helvetica, sans-serif; line-height:1.8em; width:auto; }
#contactform li.buttons {margin:5px 0 5px 0;}
.kirimpesan {margin: 1em 0 1em 0; width: 116px; height: 30px; position: relative; overflow: hidden; padding: 0; border: none; }
.kirimpesan input{background: url(kirim_pesan.jpg) 0 0 no-repeat; width: 116px; height:30px; float:left; padding: 0; overflow: hidden; border: 0; text-indent: -9000px; cursor: pointer;}
.kirimpesan input:hover{background-position: 0 -30px;}
[/css]

Sekarang tinggal buat halaman presentasi (visual) kontak form. Kode html nya seperti contoh di bawah ini:

[html]
<form action="contact.php" method="post" id="contactform">
<ol>
<li>
<label for="name">Nama <span>Isikan nama anda</span></label>
<input id="name" name="name" class="text" />
</li>
<li>
<label for="email">Email <span style="text-align:left">Isikan alamat email valid</span></label>
<input id="email" name="email" class="text" />
</li>
<li>
<label for="subject">Subjek <span>Subjek pesan anda</span></label>
<input id="subject" name="subject" class="text" />
</li>
<li>
<label for="message">Pesan <span style="text-align:left">Yang ingin anda sampaikan</span></label>
<textarea id="message" name="message" rows="6" cols="50"></textarea>
</li>
<li class="buttons">
<span class="kirimpesan"><input name="imageField" type="submit" /></span>
</li>
</ol>
</form>
[/html]

Ganti "contact.php" dengan alamat url dimana script php contact anda letakkan.

Tampilannya akan seperti ini:

1. 
   Nama Isikan nama anda
   
   
2. 
   Email Isikan alamat email valid
   
   
3. 
   Subjek Subjek pesan anda
   
   
4. 
   Pesan Yang ingin anda sampaikan
   
   
5. 
   
   

Selesai. Semua pesan yang diisikan melalui form kontak di atas akan dikirimkan ke alamat email sesuai dengan alamat email pilihan anda.

Monggo dicoba.

Selengkapnya