Link to home
Create AccountLog in
Avatar of jrm213jrm213
jrm213jrm213Flag for United States of America

asked on

PDO MySQL drivers not showing up after install

Hi,

I am working with a recently set up debian linux server (I didn't set it up so am not sure what all has been done). It has apache 2, and php 5.3.5 (built from source, with the following attached configure code showing from phpinfo())

phpinfo does show that pdo is installed, but it is only showing:
PDO drivers       sqlite, sqlite2
pdo_sqlite
PDO Driver for SQLite 3.x      enabled
SQLite Library       3.7.3


I used pecl to install pdo_mysql and it was succesful. I added the following to my php.ini file
extension=pdo.so
extension=pdo_mysql.so

I then restarted apache, but phpinfo still does not show that the mysql drivers for pdo are installed, and my application doesn't run...

Is there something else I need to do in order to get this to work? Any help is appreciated.

Thanks!

'./configure' '--prefix=/opt/php5' '--with-apxs2=/usr/bin/apxs2' '--enable-cli' '--with-regex=php' '--enable-calendar' '--with-iconv' '--with-gettext' '--with-pcre-regex' '--enable-mbstring' '--with-mysql=/usr/include/mysql/' '--with-mysqli=/usr/bin/mysql_config' '--with-zlib-dir=/usr/include/' '--with-jpeg-dir=/usr/lib' '--with-ldap' '--with-gd'

Open in new window

Avatar of jrm213jrm213
jrm213jrm213
Flag of United States of America image

ASKER

If I run php -m from the command line, it shows

PDO
pdo_mysql

...
ok, so the php error log was mis-configured and trying to write to a directory that didn't exist. I updated the phperror.log directory and now when I restart apache I get this in the php error log, It definitely seems to have something to do with the person that set this server up building php I think.

[15-Jun-2011 09:38:46] PHP Warning:  PHP Startup: PDO: Unable to initialize module
Module compiled with module API=20060613
PHP    compiled with module API=20090626
These options need to match
 in Unknown on line 0
[15-Jun-2011 09:38:46] PHP Warning:  PHP Startup: pdo_mysql: Unable to initialize module
Module compiled with module API=20060613
PHP    compiled with module API=20090626
These options need to match


Any idea how I fix this?
ASKER CERTIFIED SOLUTION
Avatar of jrm213jrm213
jrm213jrm213
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer