Home » forums » Technology

MySQL in Prophecy 7.0

Hi. I was having problem trying to make mysql 5.x work with prophecy 7.0. I tried the two steps that were mentioned in this site. But what happened is that, it complained "unable to load ./php_pdo_mysql.dll" or something like that. I made sure that the file was copied in the right directory and I made sure that the extensions_dir was pointing towards the right direction but then it still couldn't find the file. And what I learned is that, only this extension cannot be found. Because the other extensions such as php_pdo_sqllite.dll and others which are in the same directory as php_pdo_mysql.dll got loaded successfully. So, I knew that the extensions_dir was really pointing towards that direction. But what seems to be the problem???

Please do help me on this.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Sounds like an interesting

Sounds like an interesting problem. I assume that you've downloaded the MySQL server as well as the DLL's, and that you've also restarted Prophecy's web server.

In my system, the php.ini file and the DLL's all reside in a single common directory, which is the main top-level Voxeo directory. Is that the case in your system?

Another trick to see how your system is function is to create a PHP file called phpinfo.php. The content of the file is:

<?php
phpinfo()
?>

Retrieve this fiie via your web server and you can see all sorts of information.

HTH,
Moshe

--
Moshe Yudkowsky * Administrator

PDO Extension and MySQL 5

Sorry I'm just coming across this post. I ran into a similar problem in a different context.

I think the problem is that the PHP Data Objects extension doesn't support MySQL 5 out of the box. According to the MySQL website:

"The PHP 5.1 distribution that is available on php.net is linked against an old version of the MySQL Client API library. The mysql and mysql extensions from php.net are based on the MySQL Client API version 4.1.7."

Not sure what version of PHP Prophecy ships with, but I think it might be 5.1.

There is a download available at http://dev.mysql.com/downloads/connector/php/ that nay solve the problem.

I've not tried it yet myself, but if I do and am successful, I'll update you.