MySQL PDO install

Hello Everyone,

Came up with an interesting issue today and was wondering if anyone else has had something similar/knows a fix for this.

I’m installing the Magento eCommerce cart and it’s requiring PDO_MYSQL to be installed, so I followed the directions of this site which shows how to do it using pecl, and followed it to the letter, but now whenever I include extension=pdo_mysql.so in the php.ini file Apache blows up and shoots out the following error message:

Mon Aug 25 16:11:25 2008] [notice] Digest: done
/usr/sbin/httpd: symbol lookup error: /usr/lib64/php5/pdo_mysql.so: undefined symbol: php_pdo_declare_long_constant

No clue what I’m doing wrong. I’m on CentOS 4.6 and InterWorx 3.0.4 and PHP 5.2.5

Funny thing is, apparently PDO is installed somewhere and I can’t access it. My PHP.INI file right now has these extensions commented out:

;extension=pdo.so
;extension=pdo_mysql.so

Yet if you look at my PHPinfo() file on the server, it stil seems to be accessing it.

Anybody have any ideas what I’m doing wrong?

Thanks,
Dan

Hi Dan,

My guess is that it’s loading from one of the /etc/php.d/*.ini files. As far the actual problem - I’m not sure, but googling that error does bring up some hits, so that’s the first thing I’d check.

http://www.google.com/search?hl=en&q=undefined+symbol%3A+php_pdo_declare_long_constant

Paul

Hi

If I remember well, if you build the PDO extension as “shared” then you HAVE TO build the mysql-pdo, sqlite-pdo etc as shared too.

Also you’ll maybe have to recompile both php and mysql