Jump to content

Issues with PDO with MYSQL


infolock

Recommended Posts

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

 

 

 

 

Link to comment
https://forums.phpfreaks.com/topic/105481-issues-with-pdo-with-mysql/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.