[HOW-TO] Enable and setup PHP-FPM in DirectAdmin (PHP 5.3)

I've heard about PHP-FPM about a month ago from DirectAdmin webboard. Then, a few weeks ago, I had a couple websites that I need to make it run faster. After tried to do many things with it like ... to use mod_fcgid / XCache / Memcached, I feel like there was something in XCache since "Page execution time" is quite high. Then, I remember that I've read from many websites that XCache doesn't really work with mod_fcgid. From the technical point, all of them explained it clearly to understand.

[HOW-TO] Drupal 6 : Add additional "Add Comment" link into the node


Just edit node.tpl.php and insert code below to anywhere you want :

print l(t('Add Comment'), 'comment/reply/' . $node->nid, array('fragment' => 'comment-form'));

Make sure that , 'comment/reply/' part is relative to your path. If you access your website through www.myweb.com/web. Then, that part would be , 'web/comment/reply/'

Note : In case you are using Acquia Prosper theme, edit node-product.tpl.php instead.

[HOW-TO] Display pager in the top of the node in Drupal 6 with Zen Theme


I need to display pager for both top and bottom of the node for user to easily to move between pages. The one in the bottom is normally display but I want it to display in the top section also. To do that, Just put the following code :

<?php echo theme('pager', null, 1, 0, array(), 9); ?>

If you want to change the number of pages in the list, just change number 9 to anything you want.

When put that code in page.tpl.php, it will look like below :


[HOW-TO] DirectAdmin with mod_fcgid

All steps below should be done with a new clean install of DirectAdmin. It is possible to make it work on the server that already have users on it. I did that and it works perfectly fine. However, the steps will be a bit different and it won't work if you just follow instruction below.

1. Copy and paste below command into your SSH

cd /usr/local/src
wget http://mirrors.issp.co.th/apache/httpd/mod_fcgid/mod_fcgid-2.3.5.tar.bz2
tar jxf mod_fcgid-2.3.5.tar.bz2
cd mod_fcgid-2.3.5
APXS=/usr/sbin/apxs ./configure.apxs && make && make install

Use .htaccess on subfolders with Drupal


My objective is to protect XCache Admin directory under drupal website. The build-in authentication by XCache doesn't work correctly with mod_fcgi setup. I have no idea why. (It works perfectly with mod_php) So, I just tried to use .htaccess and .htpassword to protect that XCache Admin directory instead.

Drupal 6 + Views 2 : Created similar node based on Node Title


I need my node to show related nodes below it. Since I know that my Node Title will be very similar in the name but different Season or Number like example below. Node 1 - Final Destination DVD Node 2 - Final Destination DVD 2 Node 3 - Final Destination DVD 3 Node 4 - Lost Season 1 Node 5 - Lost Season 2 When I open Node 1, links to Node 2 and Node 3 should be there below the content. When I open Node 5, links to Node 4 should be there below the content. I can do that by set Views as below:

Replace normal " Build-in InnoDB" with "InnoDB Plugin" under DirectAdmin + CentOS 64 bits + MySQL 5.1

For some reason, under CentOS, Custombuild in DirectAdmin use "MySQL - Generic Linux (glibc 2.3) (x86, 64-bit) RPM file" instead of MySQL RPM files for Redhat. The different for these 2 packages are that, RPM for Redhat contain "ha_innodb_plugin.so" but not in Generic RPM package.

Compare files in Plugin folder on two different RPM.

MySQL Linux Generic RPM

MySQL Linux Redhat RPM

Apache Error : [emerg] (28)No space left on device: mod_fcgid: Can't create global fcgid-proctbl mutex

My server run DirectAdmin with mod_fcgid installed. After I tuned MySQL. I, then, restarted both httpd and MySQL service. Both services started without any problem but I can't access my website at all. After I checked my Apache Error log, I found an error which said :

[emerg] (28)No space left on device: mod_fcgid: Can't create global fcgid-proctbl mutex
After search around how to fix this problem, I believe it's something about IPCS. Try run
# ipcs -a

PECL Install Error: /bin/sh: bad interpreter: Permission denied

When I tried to use PECL to install APC. I got error below : # pecl install apc downloading APC-3.0.19.tgz ... Starting to download APC-3.0.19.tgz (115,735 bytes) .........................done: 115,735 bytes 47 source files, building WARNING: php_bin /usr/local/php5/bin/php appears to have a suffix 5/bin/php, but config variable php_suffix does not match running: phpize Configuring for: PHP Api Version: 20041225 Zend Module Api No: 20060613 Zend Extension Api No: 220060519

How to secure /tmp and /dev/shm Partition


How to secure /tmp if we didn't partition /tmp when installed CentOS. Also, secure /dev/shm to protect rootkits. 1. Secure /tmp partition 1.1: Backup your fstab file cp /etc/fstab /etc/fstab.bak 1.2: Creating tmpMnt partition file (~ 1Gb in size) cd /var dd if=/dev/zero of=tmpMnt bs=1024 count=1048576 1.3: Format new partition mkfs.ext3 -j /var/tmpMnt It will show /var/tmpMnt is not a block special device. Proceed anyway? (y,n) Just press Y