tags:

views:

437

answers:

2
Q: 

Enable PDO for PHP5 on CentOS5 where PHP is configured as '--disable-pdo'

Hi

I have been given access to a CentOS5 machine by my client for their new site which uses Zend Framework.

phpinfo() states in Configure Command that PDO is disabled ('--disable-pdo'). How can enable it? Do I need to recompile PHP5 to enable it?

I have tried adding 'extension=pdo.so' in php.ini and restarting Apache, but this didn't work.

It would also be nice to understand what '--disable-pdo' actaully means, does it mean it's not compiled into PHP or does it mean its just not enabled?

Thanks for your time

+1  A: 

Not compiled. Install it from your distro's repositories, eg. yum install php-pdo.

jholster  2010-03-22 23:37:34
Ah thanks Yaggo - that installed fine.I notice on my phpinfo() that its only installed for sqlite and not for mysql. Is there another package that needs to be installed to enable this?
jakenoble  2010-03-23 01:05:42
You need specific driver, try _yum search mysql pdo_.
jholster  2010-03-23 08:57:26
Thought I should follow this up, I used yum install php-pdoFollowed by yum install php-mysqlThe second install for php-mysql failed, saying that my.cnf conflicted. I then restarted Apache and tried again and it worked fine.
jakenoble  2010-03-25 00:08:51
A: 

While Yaggo's suggestion solves the underlying problem the requester had, in the case where yum is not available (in my case due to painfully restrictive policies by the server administrators), there is a pure PHP library that can bridge the gap called PHPPDO.

It has a couple of caveats, but works pretty well.

  1. You should not extend PHPPDO or the statement object, because that will break the compatibility.
  2. Cursors are not supported.
Shabbyrobe  2010-04-28 12:58:25

related questions

How do I tell Apache which PHP to use?
PDO MySQL Driver on Mac
Named parameters, caching and PDO
How can I convert all values of an array to floats in PHP?
How can I implement commit/rollback for MySQL in PHP?
How do detect that transaction has already been started?
List of PDOStatement::bindParam data_type parameters
Is it possible to rewind a PDO result?
PDO try-catch usage in functions
How to change character encoding of a PDO/SQLite connection in PHP?
Can one convert a MySQL connection to a PDO connection?
Why is PHP PDO DSN a different format for MySQL versus PostgreSQL?
PDO Prepared Statements
Can PHP PDO Statements accept the table name as parameter?
What PHP / MySQL drivers or Database Abstraction Layers Support Prepared Statements?
How do I loop through a MySQL query via PDO in PHP?
Error with bindParam overwriting in PHP
Are PDO prepared statements sufficient to prevent SQL injection?
Installing PDO-drivers for PostgreSQL on Mac (using Zend for eclipse)
SQLite/PHP read-only?
How do you do fuzzy searches using bound parameters in PDO?
How do prepared statements work?
SQL Pagination
Persistent DB Connections - Yea or Nay?
mysqli or PDO - what are the pros and cons?