PDO - mysql driver problems

Question

Level 1

0 points

PDO - mysql driver problems

Hi all,

I have recently bought iMac for my development work.
I'm working on php developments and I use PDO library for mysql connection.
When I'm trying to connect to DB by using "mysql" driver I'm getting an error: "could not find driver".

How can I solve this problem the easiest way?
I found a lot of stuff in the internet but non of it worked.

Thanks a lot.

iMac, Mac OS X (10.5.3)

Posted on Jun 29, 2008 4:57 AM

Reply

Answer 1

Jun 29, 2008 5:42 AM in response to ShurikA

It would help to have a little more info: what was installed; can you access mysql through PHP without using the PDO library? Can you access mysql through Terminal? Have you changed the socket location in php.ini?

Reply

Answer 2

Jun 29, 2008 6:00 AM in response to ShurikA

One more thing: it looks like that the default PHP that comes with Leopard doesn't have the mysql driver for PDO. Apple always supplies the most basic PHP installation (no graphic libraries, for instance).

Reply

Answer 3

ShurikA Author

Level 1

0 points

Jun 29, 2008 1:00 PM in response to Joaquim Lopes

Basically, I haven't changed anything. Anyway, I can access MySQL if I use another driver for that; for example "sqlite".
I also do can work with MySQl through terminal.

Reply

Answer 4

Jun 29, 2008 1:12 PM in response to ShurikA

+I also do can work with MySQl through terminal.+
This just means that you have mySQL installed. Can you access a database using PHP but without using PDO? Something like this:

<?php
$hostname = "localhost";
$database = "a database name";
$username = "root"; // or whatever
$password = "your password here";
$connection = mysql_pconnect($hostname, $username, $password) or trigger(mysql_error(), E-USER_ERROR);
?>

Does this return an error?
If you haven't changed anything then PHP will be looking for the mysql socket in the wrong place (/var/mysql/mysql.sock instead of /tmp/mysql.sock). Also, the PDO manual mentions that you need to change the php.ini file.

Reply

Answer 5

ShurikA Author

Level 1

0 points

Jun 29, 2008 2:46 PM in response to Joaquim Lopes

This one also does work:

public function __construct(){
$registry = IibRegistry::getInstance();

$siteConf = $registry->getArray(IIB_SITE_CONFIG);
//print_r($siteConf);
//set all needed configuration.
$this->_dbHost = array_key_exists('db_host', $siteConf) ? $siteConf['db_host'] : 'localhost';
$this->_dbName = array_key_exists('db_name', $siteConf) ? $siteConf['db_name'] : '';
$this->_dbUser = array_key_exists('db_user', $siteConf) ? $siteConf['db_user'] : '';
$this->_dbPass = array_key_exists('db_pass', $siteConf) ? $siteConf['db_pass'] : '';
$this->_tablePrefix = array_key_exists('table_prefix', $siteConf) ? $siteConf['table_prefix'] : '';

// foreach(PDO::getAvailableDrivers() as $driver)
// {
// echo $driver.'
';
// }

parent::__construct('sqlite:host='.$this->_dbHost.';dbname='.$this->_dbName.'', $this->_dbUser, $this->_dbPass);//, array(PDO::ATTR_PERSISTENT => true));
$this->setAttribute(PDO::ATTR_STATEMENT_CLASS, array('IibStatement', array($this)));
//$this->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
}

Reply

Answer 6

ShurikA Author

Level 1

0 points

Jun 29, 2008 2:47 PM in response to Joaquim Lopes

What you are saying here is reinstall PHP and forget about the problems.

Reply

Answer 7

Jun 29, 2008 2:52 PM in response to ShurikA

Nope! I don't think that reinstalling PHP will solve your problem but probably reading the installation part of PDO's manual might.

Reply

Answer 8

ShurikA Author

Level 1

0 points

Jun 29, 2008 2:57 PM in response to Joaquim Lopes

I don't think I've ever found good installation instructions for PDO.

Reply

Answer 9

ShurikA Author

Level 1

0 points

Jun 29, 2008 2:59 PM in response to Joaquim Lopes

And what about all other parts that are not installed. As you said, graphics for example.

Reply

Answer 10

Jun 29, 2008 3:05 PM in response to ShurikA

Well, if you need GD support then you must reinstall PHP (that's what I did on my Tiger Server box because I needed that for Moodle).

Reply

Answer 11

ShurikA Author

Level 1

0 points

Jun 29, 2008 3:13 PM in response to Joaquim Lopes

Exactly, but will it solve all that kind of problems?

Reply

Answer 12

Jun 29, 2008 3:21 PM in response to ShurikA

I don't have a clue. I never used PDO, just plain PHP (although I think that the latest version of moodle I have installed on my MacPro uses it). Maybe you should move your question to the Server forums.

Reply

Answer 13

ShurikA Author

Level 1

0 points

Jun 29, 2008 3:27 PM in response to Joaquim Lopes

Do you have some good installation instruction for PHP5 on Mac? I want to try to replace the old php instance with a new one (and not just add new php). I'm trying to keep my computer clean.

P.S. I'm using iMac.

Reply

Answer 14

Jun 29, 2008 4:25 PM in response to ShurikA

I use Marc Liyanage package. He as some good instructions (although he doesn't have a specific version for Leopard and is stil on version 5.2.4).

Reply

Answer 15

Jun 30, 2008 10:37 AM in response to ShurikA

It's possible (and fairly easy) to compile a PHP module to add into an existing installation. Rather than doing "./configure", "make", "sudo make install" in the PHP source directory, you can go into, say, ext/pdo_mysql, type "phpize" and then do the "./configure", "make", "sudo make install" bit. Then you just enable the module in /etc/php.ini.

There are a few extra problems with PDO_mysql specifically, as the Apache/PHP install in Leopard is 64-bit, so it can be a little tricky to get the MySQL client library to play ball.

At the risk of being accused of spamming, I just blogged about this very issue (building PDO_mysql for Leopard):

http://gidden.net/tom/2008/06/30/mysql-and-pdo-on-os-x-leopard-intel/

The article assumes experience in building MySQL and PHP from source.

Reply