MySQL PDO install

[digitaljesus]

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

[IWorx-Paul]

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..._long_constant

Paul

[netipro]

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