PostgreSQL Problem (could not connect to server: No such file or directory.)

"PostgreSQL Problem (could not connect to server: No such file or directory.)"

Cara mengatasinya, buka putty. Kemudian ketikkan command:

mv /var/lib/pgsql/data{,.backup}
/sbin/service postgresql initdb
/sbin/service postgresql start

[bash collapse="false"]
root@server5 [~]# mv /var/lib/pgsql/data{,.backup}
root@server5 [~]#
[/bash]

[bash collapse="false"]
root@server5 [~]# /sbin/service postgresql initdb
Initializing database: [ OK ]
root@server5 [~]#
[/bash]

[bash collapse="false"]
root@server5 [~]# /sbin/service postgresql start
Starting postgresql service: [ OK ]
root@server5 [~]#
[/bash]

Selesai.

Selengkapnya

Install PostgreSQL Pada cPanel/WHM Server

PostgreSQL merupakan salah satu basis data yang paling banyak digunakan saat ini, selain MySQL dan Oracle. PostgreSQL menyediakan fitur yang berguna untuk replikasi basis data. Fitur-fitur yang disediakan PostgreSQL antara lain DB Mirror, PGPool, Slony, PGCluster, dan lain-lain.

PostgreSQL adalah sistem database yang kuat untuk urusan relasi, open source. Memiliki lebih dari 15 tahun pengembangan aktif dan sudah terbukti segala rancangan arsitekturnya telah mendapat reputasi tentang "kuat", "handal", "integritas data", dan "akurasi data".
Sumber: http://id.wikipedia.org/wiki/PostgreSQL

Install PostgreSQL pada cPanel/WHM server sangatlah mudah, ketikkan command berikut:

/scripts/installpostgres

[bash]
root@server5 [~]# /scripts/installpostgres
This script will install PostgreSQL 7.4.x or later
If you have an older version installed you wil need to
Dump your databases to a file and then restore them
after the install as 7.4.x is not backwards compatible.
If you do not have any databases, you can just run:
mv /var/lib/pgsql /var/lib/pgsql.old
/sbin/service postgresql stop
/sbin/service postgresql start
to force creating a 7.4.x style setup. Do not do this if
you have databases that you wish to keep!

Are you sure you wish to proceed? y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.idrepo.or.id
* extras: centos.idrepo.or.id
* updates: centos.idrepo.or.id
Setting up Install Process
No package rh-postgresql available.
No package rh-postgresql-devel available.
No package rh-postgresql-libs available.
No package rh-postgresql-server available.
Resolving Dependencies
--> Running transaction check
---> Package postgresql.x86_64 0:8.4.11-1.el6_2 will be installed
---> Package postgresql-devel.x86_64 0:8.4.11-1.el6_2 will be installed
---> Package postgresql-libs.x86_64 0:8.4.11-1.el6_2 will be installed
---> Package postgresql-server.x86_64 0:8.4.11-1.el6_2 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
postgresql x86_64 8.4.11-1.el6_2 updates 2.7 M
postgresql-devel x86_64 8.4.11-1.el6_2 updates 808 k
postgresql-libs x86_64 8.4.11-1.el6_2 updates 198 k
postgresql-server x86_64 8.4.11-1.el6_2 updates 3.3 M

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

Total download size: 7.0 M
Installed size: 32 M
Downloading Packages:
--------------------------------------------------------------------------------
Total 154 kB/s | 7.0 MB 00:46
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : postgresql-libs-8.4.11-1.el6_2.x86_64 1/4
Installing : postgresql-8.4.11-1.el6_2.x86_64 2/4
Installing : postgresql-devel-8.4.11-1.el6_2.x86_64 3/4
Installing : postgresql-server-8.4.11-1.el6_2.x86_64 4/4

Installed:
postgresql.x86_64 0:8.4.11-1.el6_2
postgresql-devel.x86_64 0:8.4.11-1.el6_2
postgresql-libs.x86_64 0:8.4.11-1.el6_2
postgresql-server.x86_64 0:8.4.11-1.el6_2

Complete!

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.
Installing Bundle::DBD::Pg
.........
.........
.........
.........
.........

The PostgreSQL packages have been installed successfully. To configure,
navigate to WHM's Postgres Config feature where you can set your password
and enable PostgreSQL functionality for existing user accounts.

root@server5 [~]#
[/bash]

Untuk mengaktifkan PostgreSQL, Login WHM → SQL Services → Postgres Config → Klik tombol Install Config - Popup dialog konfirmasi, klik tombol OK

[caption id="attachment_1259" align="alignnone" width="150" caption="PostgreSQL cPanel"][/caption]

Selesai. PostgreSQL database siap digunakan.

[caption id="attachment_1260" align="alignleft" width="150" caption="PostgreSQL cPanel 2"][/caption][caption id="attachment_1261" align="alignleft" width="150" caption="PostgreSQL cPanel 3"][/caption][caption id="attachment_1262" align="alignleft" width="150" caption="PostgreSQL cPanel 4"][/caption]

Untuk uninstall PostgreSQL, jalankan command berikut:

rpm -qa | grep postgre

[bash collapse="false"]
[root@server5 ~]# rpm -qa | grep postgre

// this will show the rpm's for postgre.. now remove it as below ..
// where file is the rpm names that you got from the above command (1).
// there will be a problem uninstalling the lib rpm... just don't worry.. he is of no harm.

#rpm -e
[/bash]

Dokumentasi install PostgreSQL cPanel: http://docs.cpanel.net/twiki/bin/view/AllDocumentation/InstallationGuide/InstallingPostgresql

Selengkapnya

Panduan Singkat Install cPanel

cPanel merupakan control panel web yang memudahkan user account hosting memanage mail, Database MySQL, subdomain, dns, ftp account, SSH/Shell Access dan beberapa fitur lainnya. Pengertian cPanel menurut Wikipedia:

Dari Wikipedia bahasa Indonesia, ensiklopedia bebas

cPanel adalah sebuah control panel web hosting pada Linux yang memberikan tampilan grafis dan peralatan automasi yang dibuat untuk memudahkan proses hosting di sebuah situs web. cPanel menggunakan 3 tingkat struktur untuk memberikan fungsi administrator, agen, dan pemilik situs web untuk mengatur berbagai macam aspek dari situs web dan administrasi server melalui sebuah penjelajah web standar. Selain memberikan Guide User Interface untuk memudahkan pengguna, cPanel juga dilengkapi dengan perintah dalam teks dan berdasarkan API agar vendor perangkat lunak pihak ketiga, organisasi web hosting dan pengembang untuk automasi sistem standar proses administrasinya

cPanel didesain untuk berfungsi pada dedicated server ataupun virtual private server yang bisa digunakan pada Sistem Operasi centOS, Red Hat Linux, dan FreeBSD. Aplikasi-aplikasi didukung cPanel termasuk Apache, PHP, mySQL, Postgres, Perl, Python, and BIND, dengan email seperti POP3, IMAP, layanan-layanan SMTP.

Sumber: http://id.wikipedia.org/wiki/CPanel

Install cPanel/WHM sebagai control panel website tidaklah rumit. Berikut panduan singkat install cPanel (Fresh Install OS):

Login ke SSH Server sebagai root user, kemudian ketikkan command:

cd /home
wget -N http://httpupdate.cpanel.net/latest
sh latest

[bash collapse="false"]
[root@server5 ~]# cd /home
[root@server5 home]#
[/bash]

[bash collapse="false"]
[root@server5 home]# wget -N http://httpupdate.cpanel.net/latest
--2012-05-27 22:43:52-- http://httpupdate.cpanel.net/latest
Resolving httpupdate.cpanel.net... 208.78.42.4, 208.82.118.100, 209.85.80.214, ...
Connecting to httpupdate.cpanel.net|208.78.42.4|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 32145 (31K) [application/octet-stream]
Saving to: âlatestâ

100%[======================================>] 32,145 16.6K/s in 1.9s

2012-05-27 22:43:55 (16.6 KB/s) - âlatestâ

[root@server5 home]#
[/bash]

[bash]
[root@server5 home]# sh latest
Creating directory installd
Verifying archive integrity... All good.
Uncompressing Cpanel & WHM Installer.............
____ _
___| _ \ __ _ _ __ ___| |
/ __| |_) / _` | '_ \ / _ \ |
| (__| __/ (_| | | | | __/ |
\___|_| \__,_|_| |_|\___|_|

Installer Version v00021 r76bbb37d4fd42509adbd80d6b12bf47e3845c762

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
...
...
opt/curlssl//include -I/opt/php_with_imap_client//include -I/usr/include/mysql -I/home/cpeasyapache/src/php-5.3.13/TSRM -I/home/cpeasyapache/src/php-5.3.13/Zend -g -O2 -fvisibility=hidden -c /home/cpeasyapache/src/php-5.3.13/ext/dom/domimplementation.c -o ext/dom/domimplementation.lo
2012-05-27 20:44:58 788 (DEBUG): /bin/sh /home/cpeasyapache/src/php-5.3.13/libtool --silent --preserve-dup-deps --mode=compile gcc -Iext/dom/ -I/home/cpeasyapache/src/php-5.3.13/ext/dom/ -DPHP_ATOM_INC -I/home/cpeasyapache/src/php-5.3.13/include -I/home/cpeasyapache/src/php-5.3.13/main -I/home/cpeasyapache/src/php-5.3.13 -I/home/cpeasyapache/src/php-5.3.13/ext/date/lib -I/home/cpeasyapache/src/php-5.3.13/ext/ereg/regex -I/opt/xml2/include/libxml2 -I/opt/pcre/include -I/opt/curlssl//include -I/opt/php_with_imap_client//include -I/usr/include/mysql -I/home/cpeasyapache/src/php-5.3.13/TSRM -I/home/cpeasyapache/src/php-5.3.13/Zend -g -O2 -fvisibility=hidden -c /home/cpeasyapache/src/php-5.3.13/ext/dom/element.c -o ext/dom/element.lo
2012-05-27 20:44:59 788 (DEBUG): /bin/sh /home/cpeasyapache/src/php-5.3.13/libtool --silent --preserve-dup-deps --mode=compile gcc -Iext/dom/ -I/home/cpeasyapache/src/php-5.3.13/ext/dom/ -DPHP_ATOM_INC -I/home/cpeasyapache/src/php-5.3.13/include -I/home/cpeasyapache/src/php-5.3.13/main -I/home/cpeasyapache/src/php-5.3.13 -I/home/cpeasyapache/src/php-5.3.13/ext/date/lib -I/home/cpeasyapache/src/php-5.3.13/ext/ereg/regex -I/opt/xml2/include/libxml2 -I/opt/pcre/include -I/opt/curlssl//include -I/opt/php_with_imap_client//include -I/usr/include/mysql -I/home/cpeasyapache/src/php-5.3.13/TSRM -I/home/cpeasyapache/src/php-5.3.13/Zend -g -O2 -fvisibility=hidden -c /home/cpeasyapache/src/php-5.3.13/ext/dom/node.c -o ext/dom/node.lo
2012-05-27 20:45:00 788 (DEBUG): /bin/sh /home/cpeasyapache/src/php-5.3.13/libtool --silent --preserve-dup-deps --mode=compile gcc -Iext/dom/ -I/home/cpeasyapache/src/php-5.3.13/ext/dom/ -DPHP_ATOM_INC -I/home/cpeasyapache/src/php-5.3.13/include -I/home/cpeasyapache/src/php-5.3.13/main -I/home/cpeasyapache/src/php-5.3.13 -I/home/cpeasyapache/src/php-5.3.13/ext/date/lib -I/home/cpeasyapache/src/php-5.3.13/ext/ereg/regex -I/opt/xml2/include/libxml2 -I/opt/pcre/include -I/opt/curlssl//include -I/opt/php_with_imap_client//include -I/usr/include/mysql -I/home/cpeasyapache/src/php-5.3.13/TSRM -I/home/cpeasyapache/src/php-5.3.13/Zend -g -O2 -fvisibility=hidden -c /home/cpeasyapache/src/php-5.3.13/ext/dom/string_extend.c -o ext/dom/string_extend.lo
2012-05-27 20:45:00 788 (DEBUG): /bin/sh /home/cpeasyapache/src/php-5.3.13/libtool --silent --preserve-dup-deps --mode=compile gcc -Iext/dom/ -I/home/cpeasyapache/src/php-5.3.13/ext/dom/ -DPHP_ATOM_INC -I/home/cpeasyapache/src/php-5.3.13/include -I/home/cpeasyapache/src/php-5.3.13/main -I/home/cpeasyapache/src/php-5.3.13 -I/home/cpeasyapache/src/php-5.3.13/ext/date/lib -I/home/cpeasyapache/src/php-5.3.13/ext/ereg/regex -I/opt/xml2/include/libxml2 -I/opt/pcre/include -I/opt/curlssl//include -I/opt/php_with_imap_client//include -I/usr/include/mysql -I/home/cpeasyapache/src/php-5.3.13/TSRM -I/home/cpeasyapache/src/php-5.3.13/Zend -g -O2 -fvisibility=hidden -c /home/cpeasyapache/src/php-5.3.13/ext/dom/characterdata.c -o ext/dom/characterdata.lo
2012-05-27 20:45:00 788 (DEBUG): /bin/sh /home/cpeasyapache/src/php-5.3.13/libtool --silent --preserve-dup-deps --mode=compile gcc -Iext/dom/ -I/home/cpeasyapache/src/php-5.3.13/ext/dom/ -DPHP_ATOM_INC -I/home/cpeasyapache/src/php-5.3.13/include -I/home/cpeasyapache/src/php-5.3.13/main -I/home/cpeasyapache/src/php-5.3.13 -I/home/cpeasyapache/src/php-5.3.13/ext/date/lib -I/home/cpeasyapache/src/php-5.3.13/ext/ereg/regex -I/opt/xml2/include/libxml2 -I/opt/pcre/include -I/opt/curlssl//include -I/opt/php_with_imap_client//include -I/usr/include/mysql -I/home/cpeasyapache/src/php-5.3.13/TSRM -I/home/cpeasyapache/src/php-5.3.13/Zend -g -O2 -fvisibility=hidden -c /home/cpeasyapache/src/php-5.3.13/ext/dom/documenttype.c -o ext/dom/documenttype.lo
2012-05-27 20:45:00 788 (DEBUG): /bin/sh /home/cpeasyapache/src/php-5.3.13/libtool --silent --preserve-dup-deps --mode=compile gcc -Iext/dom/ -I/home/cpeasyapache/src/php-5.3.13/ext/dom/ -DPHP_ATOM_INC -I/home/cpeasyapache/src/php-5.3.13/include -I/home/cpeasyapache/src/php-5.3.13/main -I/home/cpeasyapache/src/php-5.3.13 -I/home/cpeasyapache/src/php-5.3.13/ext/date/lib -I/home/cpeasyapache/src/php-5.3.13/ext/ereg/regex -I/opt/xml2/include/libxml2 -I/opt/pcre/include -I/opt/curlssl//include -I/opt/php_with_imap_client//include -I/usr/include/mysql -I/home/cpeasyapache/src/php-5.3.13/TSRM -I/home/cpeasyapache/src/php-5.3.13/Zend -g -O2 -fvisibility=hidden -c /home/cpeasyapache/src/php-5.3.13/ext/dom/domimplementationlist.c -o ext/dom/domimplementationlist.lo
2012-05-27 20:45:00 788 (DEBUG): /bin/sh /home/cpeasyapache/src/php-5.3.13/libtool --silent --preserve-dup-deps --mode=compile gcc -Iext/dom/ -I/home/cpeasyapache/src/php-5.3.13/ext/dom/ -DPHP_ATOM_INC -I/home/cpeasyapache/src/php-5.3.13/include -I/home/cpeasyapache/src/php-5.3.13/main -I/home/cpeasyapache/src/php-5.3.13 -I/home/cpeasyapache/src/php-5.3.13/ext/date/lib -I/home/cpeasyapache/src/php-5.3.13/ext/ereg/regex -I/opt/xml2/include/libxml2 -I/opt/pcre/include -I/opt/curlssl//include -I/opt/php_with_imap_client//include -I/usr/include/mysql -I/home/cpeasyapache/src/php-5.3.13/TSRM -I/home/cpeasyapache/src/php-5.3.13/Zend -g -O2 -fvisibility=hidden -c /home/cpeasyapache/src/php-5.3.13/ext/dom/entity.c -o ext/dom/entity.lo
...
...
2012-05-27 20:47:20 788 (DEBUG): /opt/php_with_imap_client//lib64/libc-client.a(osdep.o): In function `ssl_onceonlyinit':
2012-05-27 20:47:20 788 (DEBUG): /home/cpeasyapache/src/imap-2007f/c-client/osdep.c:302: warning: the use of `tmpnam' is dangerous, better use `mkstemp'
2012-05-27 20:47:20 788 (DEBUG): Generating phar.php
2012-05-27 20:47:20 788 (DEBUG): Generating phar.phar
2012-05-27 20:47:20 788 (DEBUG): PEAR package PHP_Archive not installed: generated phar will require PHP's phar extension be enabled.
2012-05-27 20:47:20 788 (DEBUG): invertedregexiterator.inc
2012-05-27 20:47:20 788 (DEBUG): pharcommand.inc
2012-05-27 20:47:20 788 (DEBUG): directorygraphiterator.inc
2012-05-27 20:47:20 788 (DEBUG): clicommand.inc
2012-05-27 20:47:20 788 (DEBUG): directorytreeiterator.inc
2012-05-27 20:47:20 788 (DEBUG): phar.inc
2012-05-27 20:47:20 788 (DEBUG): Build complete.
2012-05-27 20:47:20 788 (DEBUG): Don't forget to run 'make test'.
2012-05-27 20:47:20 788 (DEBUG): -- End step 'make for system PHP' --
2012-05-27 20:47:20 788 (DEBUG): -- Begin step 'make install for system PHP' --
2012-05-27 20:47:20 788 (DEBUG): Installing PHP SAPI module: cgi
2012-05-27 20:47:20 788 (DEBUG): Installing PHP CGI binary: /usr/bin/
2012-05-27 20:47:20 788 (DEBUG): Installing build environment: /usr/lib/php/build/
2012-05-27 20:47:25 788 (DEBUG): Installing header files: /usr/include/php/
2012-05-27 20:47:31 788 (DEBUG): Installing helper programs: /usr/bin/
2012-05-27 20:47:31 788 (DEBUG): program: phpize
2012-05-27 20:47:31 788 (DEBUG): program: php-config
2012-05-27 20:47:31 788 (DEBUG): Installing man pages: /usr/man/man1/
2012-05-27 20:47:31 788 (DEBUG): page: phpize.1
2012-05-27 20:47:31 788 (DEBUG): page: php-config.1
2012-05-27 20:47:31 788 (DEBUG): Installing PEAR environment: /usr/lib/php/
2012-05-27 20:47:31 788 (DEBUG): [PEAR] Archive_Tar - installed: 1.3.7
2012-05-27 20:47:31 788 (DEBUG): [PEAR] Console_Getopt - installed: 1.3.0
2012-05-27 20:47:31 788 (DEBUG): [PEAR] Structures_Graph- installed: 1.0.4
2012-05-27 20:47:31 788 (DEBUG): [PEAR] XML_Util - installed: 1.2.1
2012-05-27 20:47:31 788 (DEBUG): [PEAR] PEAR - installed: 1.9.4
2012-05-27 20:47:31 788 (DEBUG): Wrote PEAR system config file at: /usr/etc/pear.conf
2012-05-27 20:47:31 788 (DEBUG): You may want to add: /usr/lib/php to your php.ini include_path
2012-05-27 20:47:31 788 (DEBUG): /home/cpeasyapache/src/php-5.3.13/build/shtool install -c ext/phar/phar.phar /usr/bin
2012-05-27 20:47:31 788 (DEBUG): ln -s -f /usr/bin/phar.phar /usr/bin/phar
2012-05-27 20:47:31 788 (DEBUG): -- End step 'make install for system PHP' --
2012-05-27 20:47:31 788 (DEBUG): -- Begin step 'symlink php.ini' --
2012-05-27 20:47:31 788 (DEBUG): -- End step 'symlink php.ini' --
2012-05-27 20:47:31 788 (DEBUG): -- Begin step 'set extension_dir in php.ini' --
2012-05-27 20:47:31 788 (DEBUG): -- End step 'set extension_dir in php.ini' --
2012-05-27 20:47:31 788 (DEBUG): -- Begin step 'PHP httpd.conf setup' --
2012-05-27 20:47:31 788 (DEBUG): -- End step 'PHP httpd.conf setup' --
2012-05-27 20:47:31 788 (DEBUG): -- Begin step 'Update PHP magicloader if necessary' --
2012-05-27 20:47:31 788 (DEBUG): -- End step 'Update PHP magicloader if necessary' --
2012-05-27 20:47:31 788 (DEBUG): -- Begin step 'Update PHP version files' --
2012-05-27 20:47:31 788 (DEBUG): !! '/usr/local/apache/conf/php5.version' has been updated to '5.3.13' !!
...
...
2012-05-27 20:49:01 211 (DEBUG): [20120527.204901] [10741] The following modules are now being installed/updated/verified: Locales,version,CDB_File,Module::Build,BSD::Resource,Class::Std,Digest::MD5::File,Expect,Encode::Guess,Encode::MIME::Name,Encode::Detect::Detector,Data::Dump,File::Copy::Recursive,File::ReadBackwards,File::Find::Rule,IO::Tty,Sys::Hostname::Long,local::lib,AppConfig,Template,YAML::Syck,JSON::Syck,cPanel::MemTest,List::MoreUtils,DateTime::Locale,DateTime,DB_File,HTTP::Date,Scalar::Util,MIME::Base64,URI,Net::FTP,HTML::Tagset,HTML::Parser,HTML::HeadParser,LWP,Bundle::LWP,DBI,Crypt::SSLeay,CPAN::SQLite,Data::Dumper,Digest::MD5,Digest::SHA1,Encode,ExtUtils::Constant,ExtUtils::Install,ExtUtils::ParseXS,File::Touch,Filesys::Df,Filesys::Virtual,Filter::Util::Call,Getopt::Long,Getopt::Param::Tiny,IO::Interactive::Tiny,Compress::Raw::Zlib,Authen::Libwrap,Net::FTPSSL,Net::SSL,Net::SSLeay,IO::Compress::Gzip,IO::Scalar,IO::Socket::INET6,IO::Socket::SSL,IO::Stty,IO::Uncompress::Gunzip,Lchown,List::Util,MD5,Net::DNS,Net::OSCAR,Net::LibIDN,Pod::Perldoc,Socket6,Storable,Sys::Syslog,TAP::Harness,Term::ReadKey,Term::ReadLine::Perl,Time::HiRes,Tree::MultiNode,Unix::PID,Unix::PID::Tiny,XML::LibXML::Common,XML::LibXML,XML::Parser,XML::SAX,XML::Simple,lib::restrict,Crypt::Passwd::XS,DBD::mysql,Filesys::Statvfs,Crypt::GPG,Class::Accessor,Class::Accessor::Fast,File::MMagic::XS,Email::Valid,ExtUtils::MakeMaker,Mail::SRS,Acme::Spork,Archive::Tar,Archive::Tar::Streamed,Archive::Zip,MIME::Lite,Business::OnlinePayment::AuthorizeNet,Business::UPS,CGI,Class::Std::Utils,Compress::Bzip2,Compress::Zlib,DBIx::MyParsePP,DBD::SQLite2,Date::Parse,File::Tail,GD::Graph,GD::Text::Align,Memoize,Geo::IPfree,HTTP::Daemon::App,IO::Socket::ByteCounter,Image::Size,Mail::DomainKeys,Error,NetAddr::IP,Net::DNS::Resolver::Programmable,Mail::SPF,Mail::SPF::Query,Mail::DKIM,IP::Country,Graph::Easy,Graph::Flowchart,Mail::SpamAssassin,URI::Escape,File::Find::Rule::Filesys::Virtual,File::Slurp,Net::DAV::Server,Net::Daemon,Net::Daemon::SSL,Net::LDAP,Net::LDAP::Schema,Net::LDAP::Server,Net::IP::Match::Regexp,OLE::Storage_Lite,Parse::RecDescent,Quota,SVG::TT::Graph,Safe::Hole,Text::CSV,Spreadsheet::ParseExcel,Spreadsheet::WriteExcel,String::CRC32,SQL::Statement,Set::Crontab,Tie::IxHash,Tie::ShadowHash,Tie::DBI,URI::URL,Bundle::Interchange,Devel::PPPort,Linux::Inotify2
...
...
2012-05-27 21:16:26 211 (DEBUG): [20120527.211626] [4308] Provided options list is: deliver_queue_load_max|queue_only_load|daemon_smtp_ports|tls_on_connect_ports|system_filter_user|system_filter_group|tls_require_ciphers|hostlist loopback|hostlist senderverifybypass_hosts|hostlist skipsmtpcheck_hosts|hostlist spammeripblocks|hostlist backupmx_hosts|hostlist trustedmailhosts|hostlist relay_hosts|domainlist user_domains|remote_max_parallel|smtp_receive_timeout|ignore_bounce_errors_after|rfc1413_query_timeout|timeout_frozen_after|auto_thaw|callout_domain_negative_expire|callout_negative_expire|acl_smtp_connect|acl_smtp_data|acl_smtp_mail|acl_smtp_quit|acl_smtp_notquit|acl_smtp_rcpt|message_body_newlines|deliver_queue_load_max|queue_only_load|daemon_smtp_ports|tls_on_connect_ports|system_filter_user|system_filter_group|tls_require_ciphers|spamd_address
2012-05-27 21:16:26 211 (DEBUG): [20120527.211626] [4308] Exim Insert Regex is: virtual_userdelivery|virtual_aliases|democheck|remote_smtp|lookuphost|address_pipe|virtual_user|localuser|virtual_sa_user
2012-05-27 21:16:26 211 (DEBUG): [20120527.211626] [4308] Exim Replace Regex is: virtual_sa_user|sa_localuser|virtual_sa_userdelivery|local_sa_delivery|central_filter|central_user_filter|democheck|fail_remote_domains|fixed_login|fixed_plain|has_alias_but_no_mailbox_discarded_to_prevent_loop|literal|local_delivery|local_delivery_spam|localuser|localuser_spam|lookuphost|remote_smtp|secure_login|secure_plain|userforward|virtual_aliases|virtual_aliases_nostar|virtual_user|virtual_user_spam|virtual_userdelivery|virtual_userdelivery_spam
2012-05-27 21:16:26 211 (DEBUG): [20120527.211626] [4308] Exim Match Insert Regex is: quota_directory|maildir_format
2012-05-27 21:16:26 211 (DEBUG): [20120527.211626] [4308] Exim version 4.77 #2 built 03-Nov-2011 00:54:21
2012-05-27 21:16:26 211 (DEBUG): [20120527.211626] [4308] Copyright (c) University of Cambridge, 1995 - 2007
2012-05-27 21:16:26 211 (DEBUG): [20120527.211626] [4308] Berkeley DB: Berkeley DB 4.7.25: (November 12, 2010)
2012-05-27 21:16:26 211 (DEBUG): [20120527.211626] [4308] Support for: crypteq iconv() IPv6 PAM Perl OpenSSL Content_Scanning DKIM Old_Demime Experimental_SPF Experimental_SRS
2012-05-27 21:16:26 211 (DEBUG): [20120527.211626] [4308] Lookups (built-in): lsearch wildlsearch nwildlsearch iplsearch dbm dbmnz passwd
2012-05-27 21:16:26 211 (DEBUG): [20120527.211626] [4308] Authenticators: cram_md5 dovecot plaintext spa
...
...
2012-05-27 21:17:39 211 (DEBUG): [20120527.211739] Removing upcp pidfile
2012-05-27 21:17:39 211 (DEBUG): [20120527.211739]
2012-05-27 21:17:39 211 (DEBUG): [20120527.211739] Completed all updates
2012-05-27 21:17:39 211 (DEBUG): => Log closed Sun May 27 21:17:39 2012
2012-05-27 21:17:39 211 (DEBUG): - ssystem [END]
2012-05-27 21:17:39 217 ( INFO): Adding services to chkconfig.
2012-05-27 21:17:39 219 ( INFO): - Enabling cpanel
2012-05-27 21:17:39 220 (DEBUG): - ssystem [BEGIN]: /sbin/chkconfig --level 35 cpanel on
2012-05-27 21:17:39 220 (DEBUG): - ssystem [END]
2012-05-27 21:17:39 219 ( INFO): - Enabling mysql
2012-05-27 21:17:39 220 (DEBUG): - ssystem [BEGIN]: /sbin/chkconfig --level 35 mysql on
2012-05-27 21:17:40 220 (DEBUG): - ssystem [END]
2012-05-27 21:17:40 219 ( INFO): - Enabling sshd
2012-05-27 21:17:40 220 (DEBUG): - ssystem [BEGIN]: /sbin/chkconfig --level 35 sshd on
2012-05-27 21:17:40 220 (DEBUG): - ssystem [END]
2012-05-27 21:17:40 1755 ( INFO): Enabling cphulkd ...
2012-05-27 21:17:40 1762 ( INFO): Done
2012-05-27 21:17:40 236 ( INFO): cPanel install finished in 329 minutes and 54 seconds!
2012-05-27 21:17:40 1582 ( WARN): !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
2012-05-27 21:17:40 1583 ( WARN): Your system kernel may have been updated.
2012-05-27 21:17:40 1584 ( WARN): Current kernel (2.6.32-220.el6.x86_64) has been changed to: 2.6.32-220.17.1.el6.x86_64
2012-05-27 21:17:40 1585 ( WARN): Before rebooting the system, please ensure that the installed kernel version is compatible with your deployment.
2012-05-27 21:17:40 1595 ( WARN): !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Removing /root/installer.lock
[root@server5 home]#
[/bash]

Tunggu beberapa saat sampai proses instalasi selesai (tergantung koneksi server yang dipakai). Setelah itu validasi lisensi cPanel dengan cara mengetikkan command:

/usr/local/cpanel/cpkeyclt

[bash collapse="false"]
root@server5 [~]# /usr/local/cpanel/cpkeyclt
Updating cPanel license...Done. Update succeeded.
Building global cache for cpanel...Done
root@server5 [~]#
[/bash]

cPanel/WHM Setup:

» Login WHM sebagai root user (http://ip-address:2086)

[caption id="attachment_1271" align="alignnone" width="150" caption="WHM Login"][/caption]

» Klik tombol I Agree/Go to Step 2

[caption id="attachment_1272" align="alignnone" width="150" caption="Install cPanel 2"][/caption]

» Server Contact Email Address, isikan email administrator server → This Server's Hostname, isikan dengan hostname server (misal; server.domainmuxyz.com).

[caption id="attachment_1273" align="alignnone" width="150" caption="Install cPanel 3"][/caption]

» Primary Resolver *, isikan IP Address 1 → Secondary Resolver *, isikan IP Address 2 → Klik tombol Save & go to Step 3

[caption id="attachment_1274" align="alignnone" width="150" caption="Install cPanel 4"][/caption]

» Jika ingin menambahkan IP, masukkan IP pada text field IP Address(es) to add kemudian klik tombol Add IP(s). Jika tidak klik pada tombol Skip This Step and Use Default Settings.

[caption id="attachment_1275" align="alignnone" width="150" caption="Install cPanel 5"][/caption]

» Nameserver Configuration pilih BIND DNS

[caption id="attachment_1276" align="alignnone" width="150" caption="Install cPanel 6"][/caption]

» Nameserver 1 * isikan dengan default NS1, Nameserver 2 * isikan dengan default NS2 → Centang checkbox Add "A Entries" for all Nameservers & Add "A Entries" for Hostname. Klik tombol Save & go to Step 5.

[caption id="attachment_1277" align="alignnone" width="150" caption="Install cPanel 7"][/caption]

» FTP Configuration pilih default setting Pure-FTPD → Mail Configuration pilih Dovecot → Klik tombol Save & go to Step 6

[caption id="attachment_1278" align="alignleft" width="150" caption="FTP Configuration"][/caption][caption id="attachment_1279" align="alignleft" width="150" caption="Mail Configuration"][/caption][caption id="attachment_1280" align="alignleft" width="150" caption="Save Setting Step 5"][/caption]

» Quotas pilih Use file system quotas. → Klik tombol Finish Setup Wizard

[caption id="attachment_1281" align="alignnone" width="150" caption="File System Quotas"][/caption]

» Anda akan diarahkan ke halaman main page WHM.

[caption id="attachment_1282" align="alignnone" width="150" caption="WHM Main Page"][/caption]

Selesai, cPanel/WHM siap digunakan.

Dokumentasi install cPanel.
http://docs.cpanel.net/twiki/bin/view/AllDocumentation/InstallationGuide/WebHome

Selengkapnya

Update Versi PHP Centos (CentOS/RHEL 5.6) Ke PHP Versi 5.3

Sebelum update, pastikan menambah yum repository source RPM. Buka terminal atau remote SSH via putty, kemudian ketikkan:

[bash collapse="false"]
[root@localhost ~]# rpm -Uvh http://repo.webtatic.com/yum/centos/5/latest.rpm
[/bash]

Upgrade versi PHP dengan mengetikkan command berikut:

[bash collapse="false"]
[root@localhost ~]# yum --enablerepo=webtatic install php
[/bash]

Atau update instalasi php yang sudah ada, dimana akan update semua modul php yang sebelumnya sudah terinstall dengan cara berikut:

[bash collapse="false"]
[root@localhost ~]# yum --enablerepo=webtatic update php
[/bash]

Selesai. Cek versi PHP dengan cara mengetikkan command "php -v":

[bash collapse="false"]
[root@localhost ~]# php -v
PHP 5.3.13 (cli) (built: May 9 2012 16:20:45)
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies
with the ionCube PHP Loader v4.0.12, Copyright (c) 2002-2011, by ionCube Ltd.
[/bash]

Selesai.

Selengkapnya

500 Internal Server Error (Incorrect File Ownership)

Cara mengatasi 500 Internal Server Error dikarenakan ownership file ('index.php' misalnya) berbeda/tidak sama dengan ownership domain, adalah dengan cara mengganti ownership file yang error ke username domain:

1. Buka Putty & login sebagai root


2. Ketikkan Command Berikut ini (asumsi control panel web cPanel/sesuaikan dengan direktori error file):
   
   
   [bash collapse="false"]
   [root@localhost ~]# chown -R username:username /home/username/public_html
   [root@localhost ~]# chown username:nobody /home/username/public_html
   [/bash]
   
   Ganti "username" dengan aktual username.


3. Selesai. Refresh ulang halaman yang error.

Selengkapnya

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

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