Ubuntu – How to install the SQLite PDO extension on Ubuntu

This answer works as of 29 Jan 2013.

First of all, inside ubuntu do

wget http://pecl.php.net/get/perl-1.0.1.tgz

to download the tgz file from http://pecl.php.net/package/perl

Unzip the tar

tar -zxvf perl-1.0.1.tgz

Go into the uncompressed folder

cd perl-1.0.1

Remove the current php_perl.c because for some reason, it did not work with my php5.

Download another php_perl.c from github repo https://github.com/do-aki/php-ext-perl

wget https://raw.github.com/do-aki/php-ext-perl/a3d7db22eb7964ea9cb39ea2f866d10df26655d4/php_perl.c

Run this line by line

export PHP_PREFIX="/usr"
export PERL_PREFIX="/usr"
$PHP_PREFIX/bin/phpize
./configure --with-perl=$PERL_PREFIX --with-php-config=$PHP_PREFIX/bin/php-config
make  

If you get errors like /usr/bin/ld: cannot find -lperl, then you need to install

sudo apt-get install libperl-dev

Install the extension (this step can require root privileges)

make install

Add perl extension into your php.ini (this step can require root privileges)

extension=perl.so

Restart your php5-fpm

sudo /etc/init.d/php5-fpm restart

You may get issues to do with locale when you run Perl.

Look at the missing locales. Assuming you have missing en_SG and en_SG.UTF-8

Try

sudo locale-gen en_SG en_SG.UTF-8
sudo dpkg-reconfigure locales

and then reboot.

If you still have locale issues,

Try

sudo nano /etc/environment

Append the missing locale to LC_ALL

LC_ALL = "en_SG.UTF-8"

Reboot.

I want to thank tm064 from #perl and NullDev from #ubuntu for helping me with this solution.

You can enable PDO in cPanel if you have cloudlinux installed. In cPanel search for PHP Version and on the resulting screen select and enable PDO and finally select save. * http://docs.cloudlinux.com/index.html?using_php_selector.html

If you do not have CloudLinux and PhpSelector installed you will need an administrator account to install PDO through easyapache. In WHM follow this guide:

Enabling PDO in Easyapache

1. Log in to WHM ( http://domain.com/whm )
2. Goto WHM »Software »EasyApache (Apache Update)
3. Select "Previously Saved Config (** DEFAULT **)" and click "Start customizing based on profile"
4. On the "Apache Version" page click "Next"
5. On the "PHP Version" page click "Next"
6. On the "Short Options List" page click"Exhaustive Options List"
7. On the "Exhaustive Options List" ensure that PDO, PDO sqlite and PDO MySQL are selected.
8. Then Click save & Build on the bottom of the page.