I went back to test mysql. it did not pass, so I uninstalled 5.5 in favor of trying 5.1.
Long story short, that didn't work, either:
<?php
# Define MySQL Settingsdefine("MYSQL_HOST",
"localhost");define("MYSQL_USER",
"root");define("MYSQL_PASS",
"password");define("MYSQL_DB", "test");
$conn = mysql_connect("".MYSQL_HOST."",
"".MYSQL_USER."",
"".MYSQL_PASS."") or
die(mysql_error());mysql_select_db("".MYSQL_DB."",$conn) or
die(mysql_error());
$sql = "SELECT * FROM test";$res = mysql_query($sql);
while ($field = mysql_fetch_array($res)){$id = $field['id'];$name =
$field['name'];
echo 'ID: ' . $field['id'] . '<br />';echo 'Name: '
. $field['name'] . '<br /><br />';}
?>
*/Fatal error: Call to undefined function mysql_connect() in
C:\Apache2\htdocs\mysql_test.php on line 9/*
In custom set up, I noticed some lib files were 'optional'. Since it looked like
these might be the connectors/extensions I needed, I added them, but it made no
difference.
--- On Sun, 4/10/11, Platonides <Platonides(a)gmail.com> wrote:
From: Platonides <Platonides(a)gmail.com>
Subject: Re: [Mediawiki-l] Install on Windows Problem
To: mediawiki-l(a)lists.wikimedia.org
Date: Sunday, April 10, 2011, 3:40 PM
Nat Colley wrote:
I now have a new error, which is as follows:
Checking environment...Please include all of the lines below when reporting installation
problems.§ PHP 5.3.6 installedCould not find a suitable database driver!§ For MySQL,
compile PHP using --with-mysql, or install the mysql.so modulenow, even though it's
happening in a different place, as I understand it from my extensive study of this
tortured relationship between PHP and MySQL, this is really still the same error I've
been having for almost a month now: that PHP and MySQL can't talk to each other.
In the earlier incarnations of this problem, I was at least getting further along with
the mediawiki install. In those days, I always crashed and burned at the inability of PHP
to work with MySQL's password regimen. The reasons for this depend entirely on whom
you choose to believe: the people who work at PHP, or the people who work at MySQL. But
supposedly, fortunately, all this was fixed as of PHP 5.3, because from that point forward
they were using MySQLnd, which is to say, native driver.
Apparently people who were putting out their own stacks of PHP, such as the person I got
my wamp stack I've already mentioned, have their own reasons for not including MySQL
native driver, which is why I was never getting anywhere even though I thought I had PHP
5.3, in fact had a modified version which was missing the thing I needed most.
All right. So now I've got all the latest software direct from the source, and
everything should flow smoothly this time. Both Apache "it works" and the
PHPinfo screens show themselves. I've checked to see that indeed this version of PHP
does have mySQL native driver. All lights are green and then I try to install MediaWiki
and I get this error that I mentioned at the beginning. So I wasn't even getting as
far as I had without MySQL native driver.
There's an interesting thing about this error message because it says it could not
find a suitable database driver and then as for MySQL specifically indicates that I should
compile PHP, which of course I have no idea how to even begin to do, or install MySQL.SO.
Now when you say install something, that makes it sound like it's a package or
application that you can get somewhere and just stick into your computer, but no, that
apparently is not the case. Various web forums I looked at have said the file I need is
MySQL.dll and that somehow that magically "installs" MySQL.SO. I don't
pretend to be making sense of any of this I'm simply reporting what I've tried to
do so you can find a way to help me if that's possible.
But here's the thing: I thought mySQL native driver eliminated the need for MySQLI.
That being so, why is MediaWiki looking for this old driver instead of the new one,
mysqlnd?
In his last helpful posting on this topic Platonides suggested that I needed to do
something with Apache. But you will recall that I said I'd followed the instructions
of some Australian webmaster, and among his instructions was doing exactly what Platonides
had suggested, so obviously that by itself isn't the problem. One thing that was
different from the PHP website was another line about add handler, so I cut and paste that
in but, yes, you guessed it, it made no difference.
So the other suggestions I've tried were telling PHP where the extensions directory
was, uncommenting MySQLI specifically, but it was already uncommented, and other devices
that sort.
I guess that brings you up to date. I have no more magic. If you have any, fire away.
You don't need mysql.so (.so are for Linux), you need php_mysql.dll
(well, and having mysql installed)
Your steps would be like
* Download php from
http://windows.php.net/download/
* Copy php.ini-production to php.ini
* Uncomment extension_dir = "ext"
* Uncomment extension=php_mysql.dll
* Restart apache
Note that you still need to enable mysql extension for php, and that
mysqli is a different extension than mysql.
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l