How to enable PDO extension

[tonyc]

hello guys i really have the problem in adding the good extension for php.

I have php 5.1.6 and i love it.

 

Now i'm trying to used the features of php 5 which i was not aware before. Now i realize its really good to used them.

I would like to enable PDO extenstion in my linux (fedora core 5) but i don't know how to do it without recompiling my php 5.1.6.

 

when i check in phpinfo() function i found out this line:

dba' '--without-unixODBC' '--disable-pdo' '--disable-xmlreader' '--disable-xmlwriter'

 

And yes, did not include PDO during my php compilation. So how am i going to enable it?

 

But it's kind a weird because when i check the modules where is located, i can see pdo.so

 

[root@server01 php.d]# ls -la /usr/lib/php/modules

total 2584

drwxr-xr-x 2 root root    4096 Jul  6 14:09 .

drwxr-xr-x 4 root root    4096 May  9 23:49 ..

-rwxr-xr-x 1 root root  164548 Oct 17  2006 eaccelerator.so

-rwxr-xr-x 1 root root  330764 May  9 23:49 gd.so

-rwxr-xr-x 1 root root  40780 May  9 23:49 ldap.so

-rwxr-xr-x 1 root root 1719696 May  9 23:49 mbstring.so

-rwxr-xr-x 1 root root  33028 Jun 20 20:46 mcrypt.so

-rwxr-xr-x 1 root root  106220 May  9 23:49 mysqli.so

-rwxr-xr-x 1 root root  49028 May  9 23:49 mysql.so

-rwxr-xr-x 1 root root  23532 May  9 23:49 pdo_mysql.so

-rwxr-xr-x 1 root root  82420 May  9 23:49 pdo.so

-rwxr-xr-x 1 root root  19916 May  9 23:49 pdo_sqlite.so

-rwxr-xr-x 1 root root  13228 Oct  5  2006 phpcups.so

 

As also in additional .ini files parsed

/etc/php.d/eaccelerator.ini, /etc/php.d/gd.ini, /etc/php.d/ldap.ini, /etc/php.d/mbstring.ini, /etc/php.d/mcrypt.ini, /etc/php.d/mysql.ini, /etc/php.d/mysqli.ini, /etc/php.d/pdo.ini, /etc/php.d/pdo_mysql.ini, /etc/php.d/pdo_sqlite.ini

 

Please help. A big thanks!

 

 

[trq]

If the *so is already residing in your extensions directory you may only need to add the lines....

 

extension=pdo.so
extension=pdo_mysql.so
extension=pdo_sqlite.so

 

to your php.ini file then restart your server.

[tonyc]

 

hello thrope,

Thank  you for a very quick reply.

 

well, i guess no need to do that in my case in my php.in i found out this line

 

;;;;

; Note: packaged extension modules are now loaded via the .ini files

; found in the directory /etc/php.d; these are loaded by default.

;;;;

 

and when i check it

 

[root@server01 php.d]# ls -la

total 76

drwxr-xr-x  2 root root  4096 Jul  6 14:09 .

drwxr-xr-x 93 root root 12288 Jul 25 06:11 ..

-rw-r--r--  1 root root  593 Apr 17 22:20 eaccelerator.ini

-rw-r--r--  1 root root  4521 Mar 16 20:53 eaccelerator.ini.back

-rw-r--r--  1 root root    45 May  9 23:49 gd.ini

-rw-r--r--  1 root root    49 May  9 23:49 ldap.ini

-rw-r--r--  1 root root    57 May  9 23:49 mbstring.ini

-rw-r--r--  1 root root    53 Jun 20 20:46 mcrypt.ini

-rw-r--r--  1 root root    53 May  9 23:49 mysqli.ini

-rw-r--r--  1 root root    51 May  9 23:49 mysql.ini

-rw-r--r--  1 root root    47 May  9 23:49 pdo.ini

-rw-r--r--  1 root root    59 May  9 23:49 pdo_mysql.ini

-rw-r--r--  1 root root    61 May  9 23:49 pdo_sqlite.ini

 

I open the file one by one to check if they comment it.

and found this content each file

 

pdo.ini

; Enable pdo extension module

extension=pdo.so

 

pdo_mysql.ini

; Enable pdo_mysql extension module

extension=pdo_mysql.so

 

pdo_sqlite.so

; Enable pdo_sqlite extension module

extension=pdo_sqlite.so

 

Of course restert Apache.

/etc/init.d/httpd restart

 

But when i run phpinfo() i can still see

'--without-unixODBC' '--disable-pdo' '--disable-xmlreader' '--disable-xmlwriter'

 

i'm confuse this time.

 

ok anyhow i will try to use pdo assuming i have this extension installed in my php..

hope i'm lucky. I keep you posted.

 

[tonyc]

i also did this:

 

yum list | grep php

...

php-mssql.i386                          5.1.6-4.fc6            extras         

php-mysql.i386                          5.1.6-3.5.fc6          updates       

php-ncurses.i386                        5.1.6-3.5.fc6          updates       

php-odbc.i386                            5.1.6-3.5.fc6          updates       

php-pdo.i386                              5.1.6-3.5.fc6          updates       

php-pear.noarch                        1:1.4.9-4              core           

php-pear-Auth-SASL.noarch        1.0.2-4.fc6            extras

.....