Posible MySql related problem preventing install

[Gnome]

I am having problems and I was wondering if anyone could give me some advice.  My system is configured as follows:

Windows XP Pro
Abyss Web Server X1 v1.2.3.0
PHP 5.0.1
MySql 4.0.21

I have created a user and password in MySql for the forum and created a database named SMF.  I can point my Browser to the SMF install PHP script and that fires up, I enter the details on the first page (step=0) and click on proceed, the next page comes up (step=1) but only the top banner comes up and notthing else, plus no tables within the database are created and I cannot see any database activity occurring at all.

One possible quirk that have noticed is that if I point my browser to "localhost", I get web pages servered by another machine on my home network, not sure why this is or whether it is related.

Any suggestions as to why I can not get things to install would be most welcome.

Regards

    Gnome

[[Unknown]]

Are you sure you have PHP set up to load the MySQL extension?  This is no longer the default as of PHP 5.

You'll need to edit php.ini.

-[Unknown]

[Gnome]

That is something I definitely have not done.

I have edited the php.ini file and made a change so that the mysql extension is called up, now when I run the install script I get an error message saying that the php_mysql.dll cannot be found.  Reading the PHP documentation, it says:

"In order to have these functions available, you must compile PHP with MySQL support."

Now as I have used a standard windows install, I get lost at this point.

The documentation confirms that mysql is not bundled with the windows versions and says that the file "libmysql.dll" should be copied into the windows directory or a path statement added.   Now when I do  a search for this file in the mysql install folder, I get 4 files coming up of three different sizes, copying the one from the bin director (which looks to be the most obvious) does not solve the problem.

I sounds like this is the cause of my problem, but I am struggling a bit.

Regards

    Gnome

[Grudge]

May not be much help but my dll file came with PHP5 (RC tho) and is 228kB. It actually sites in the Apache/bin directory but anywhere in path should be fine I guess. I say try them all until it works

[[Unknown]]

That is something I definitely have not done.

I have edited the php.ini file and made a change so that the mysql extension is called up, now when I run the install script I get an error message saying that the php_mysql.dll cannot be found.  Reading the PHP documentation, it says:

"In order to have these functions available, you must compile PHP with MySQL support."

Now as I have used a standard windows install, I get lost at this point.

You don't have to recompile it, don't worry.  That message is for Linux/Unix users.

It will say that file cannot be found if the extension_dir (or extensions_dir, I always forget ) is wrong, so make sure its set correctly too.  You also need to make sure libmysql.dll is in an accessable place; for example, in C:\WINDOWS.

The documentation confirms that mysql is not bundled with the windows versions and says that the file "libmysql.dll" should be copied into the windows directory or a path statement added.   Now when I do  a search for this file in the mysql install folder, I get 4 files coming up of three different sizes, copying the one from the bin director (which looks to be the most obvious) does not solve the problem.

You have a bin directory?  How did you install PHP?  With a pre-made package?  Make sure it's libmysql.dll not libmysqli.dll (note the i!)

Have you checked for a php_mysql.dll file in /ext/?  You may need to download the PECL extensions (from the download page at php.net) for it.  That or the zip file... it may not come with the installer/packages.

-[Unknown]

[Gnome]

I deleted the standard windows install, downloaded the full zip file and installed that, two minor edits to the php.ini file and it now all seems to work fine.   

Many thanks for the advice.

Regards

   Gnome

[[Unknown]]

Heh.  If you want my complete guide (pending time to update it for the new package layout in PHP 5) you can look at:

http://unknown.network32.net/tutorial.basic-server

Comments are welcome on it, but you probably already have everything set up as you want it.

-[Unknown]