php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #44984 PDO - MySQL WILL NOT install!!!
Submitted: 2008-05-13 20:44 UTC Modified: 2008-05-13 22:23 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:1 (100.0%)
Same OS:1 (100.0%)
From: infolock at gmail dot com Assigned:
Status: Closed Package: PDO related
PHP Version: 5.2CVS-2008-05-13 (CVS) OS: RedHat
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: infolock at gmail dot com
New email:
PHP Version: OS:

 

 [2008-05-13 20:44 UTC] infolock at gmail dot com 
Description:
------------
Hello all.  I've been using PHP for about 6 years now and have run into an issue I cannot solve.


Basically, I'm trying to install PDO with MySQL support on a RedHat server.

I ran the following commands:
pecl install pdo
pecl install pdo_mysql

I edited the php.ini file and added the following 2 lines:
extension=pdo.so
extension=pdo_mysql.so

I rebooted Apache.  It shows PDO installed, but ONLY with the sqlite2 and sqlite extensions installed!!!

I then tried uninstalling pdo_mysql and running this command:
PHP_PDO_SHARED=1 pecl install pdo_mysql

rebooted Apache and the SAME PROBLEM!!!

I cannot for the life of me figure out how to fix this issue.  Has anyone else had this issue?  It works fine for FreeBSD but for whatever reason I can't get it to work on RedHat.  

Also, why is it that SQLite is installed?? I can't find it anywhere in the php.ini file as being an installed extension, and yet PDO is using it's driver by default and completely ignoring my extension.


here is what it shows in phpinfo():

PDO
PDO support	enabled
PDO drivers 	sqlite2, sqlite

pdo_sqlite
PDO Driver for SQLite 3.x	enabled
PECL Module version 	(bundled) 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.2 2007/03/23 14:30:00 wez Exp $
SQLite Library 	3.3.17



Also, I tried connecting through a basic script and it reports error: "can not find driver".


Expected result:
----------------
Shows PDO MySQL installed

Actual result:
--------------
Only shows PDO SQLite installed

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2008-05-13 20:45 UTC] infolock at gmail dot com 
FYI, I am using PHP 5.2.3
 [2008-05-13 20:56 UTC] pajoye@php.net 
Don't use PECL to install pdo_mysql and try using PHP 5.2.6.
 [2008-05-13 21:03 UTC] infolock at gmail dot com 
Is there a reason for having to upgrade to PHP 5.2.3?  Sorry to ask, but the process for upgrading isn't exactly a quick process as it has to be scheduled with the Administrator, and they'll want to have a compelling argument as to why they should upgrade their corporate server ;)

Don't get me wrong, I trust you 100% (thus why I'm here).  Just I have to , as i said, give them evidence ;)
 [2008-05-13 21:12 UTC] infolock at gmail dot com 
also, here is my configure command:


'./configure' '--with-apxs2=/web/apps/apache-2.2.4/bin/apxs' '--disable-debug' '--enable-ftp' '--enable-inline-optimization' '--enable-magic-quotes' '--enable-mbstring' '--enable-mm=shared' '--enable-safe-mode' '--enable-track-vars' '--enable-trans-sid' '--enable-wddx=shared' '--enable-xml' '--with-jpeg-dir=/usr/lib' '--with-dom' '--with-gd=/usr/lib' '--with-gettext' '--with-mysql=/web/apps/mysql-5.0.45' '--with-regex=system' '--with-xml' '--with-oci8=instantclient,/usr/include/oracle/10.2.0.3/client' '--with-oci8=instantclient,/usr/lib/oracle/10.2.0.3/client/lib' '--with-zlib-dir=/usr/lib'
 [2008-05-13 21:16 UTC] pajoye@php.net 
There is plenty of reasons like security fixes in the previous php releases and in your particular case, all PDO bugs fixed in php releases only. These fixes never made it via PECL.
 [2008-05-13 21:18 UTC] infolock at gmail dot com 
Sorry, I didn't mean to offend.  I guess my final question is, if i can't install it via PECL, how else am I to install it?  Thanks a lot for your help!
 [2008-05-13 22:08 UTC] pajoye@php.net 
Via PHP releases.
 [2008-05-13 22:23 UTC] infolock at gmail dot com 
Well, I guess that was a stupid question on my part.  Thanks a lot for your help!
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat May 18 15:01:33 2024 UTC