PDO Sqlite3 Not Working In PHP 5.3.3 And WHM/Cpanel 11.26.8

The latest PHP v.5.3.3 doesn’t work good with PDO Sqlite3. I am using a VPS (Virtual Private Server) with Centos 5 and WHM/Cpanel 11.26.8. Everything goes fine except there is an error message “undefined symbol: sqlite3_libversion” in all users error_log.

I did compile my server with this configuration:
Apache v2.2
PHP 5.3.3
PDO and PDO_MySQL enabled

The compile process run without problem and success. But if you notice that, in error_log will show an error message like this:
/usr/local/bin/php: symbol lookup error: /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so: undefined symbol: sqlite3_libversion

I check my pdo with this command:

/usr/local/bin/php --ri pdo_sqlite

and the result is:
Extension ‘pdo_sqlite’ not present.

Even i installed it from the EasyApache from WHM, the pdo and pdo_sqlite doesn’t installed on my system. And when i looked into php.ini configuration, pdo_sqlite extension is enabled. So i tried to install pdo with this command below:

pecl install pdo

i got this error message:
make: *** [pdo_dbh.lo] Error 1
ERROR: `make’ failed

After i Googled, i found that it’s not only me that have the same problem. See the links below:
http://forums.cpanel.net/f5/undefined-symbol-sqlite3_libversion-148993.html
http://bugs.php.net/bug.php?id=48614

So the solution for now, i turned off or remove the pdo extension from php.ini and restart the apache. Because i don’t use pdo extension for now. But i wish this bugs will be solved soon.

PS: to clean all the error_logs from the pdo_sqlite error message you can use this command:

find /home/ -iname 'error_log' -exec sed -i '/no-debug-non-zts-20090626/d' {} +

Comments

  1. Rdsalodkar says:

    I have same problem pdo driver on ubuntu lucid , using php5.3
    when working with zend-framework tutorial I executed the command
    php load.sqlite.php

    I was given message that pdo driver is not found

  2. Becca says:

    I'm having the same problem on a VPS with cPanel/CentOS and unfortunately I want PDO enabled so that I can use PHProjekt.

Give me your feedback

This site uses Akismet to reduce spam. Learn how your comment data is processed.