Hi Everybody

I need some help testing a new server I have just set up. Im totally fine with the OS. What I have done is installed PHP, Active Perl, MySQL and Frontpage 2002 extensions.

The server is NT 4.0 with IIS 4.0.

I need somebody to upload a site and test that all of the above are functioning correctly. I would also need future support for all of the above.

I feel confident that Perl and the frontpage extensions are functioning correctly but Im not sure if PHP and MySQL are.

Ok so why would you help. Well im offering free hosting to whoever has the expertise and is willing to help from time to time.

I may ask you to VNC into the server concerned, and fix any issues that may need resolving.

If you can maybe help with just 1 part we can still come to some arrangement.

Thank

First things first.. you've patched that server before it goes online right? These days an unpatched IIS server will be swimming in worms before you can shake your head..

http://www.linux-france.org/article.../php3_tut2.html

The link above is in french but you'll see a small piece of php code near the top (the phpinfo one). If you put that in a page, then put that page on your server it should show a ton of system information when you load that page into a browser. That's a goos easy way to find out if PHP is running right.

Hope that helps a bit

Greg

To test that mysql / PHP is working, try the following script:

All you have to do is to replace the text between the asterisks with the name of the MySQL server or use "localhost" if it runs on the same server as PHP. Then then replace the text for the root password with your password.

All this script does is to open a connection to the default MySQL database and then attempt to add 2+2 using SQL. If the result 4 is returned, it must be working properly.

This can be customised or refined to increase the checks. I recommend linking the results of this page to a monitoring system which can page you or send an email to indicate that there is a problem with the PHP / MySQL combination.



<?php

$db=mysql_connect("**PUT SERVER NAME IN HERE OR localhost**","root","**PUT ROOT PASSWORD IN BETWEEN THESE QUOTES**");

mysql_select_db("");
$query="select 2+2 as result";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "$latest_array[result]";
echo "<BR>If 4 appears above, then all is ok with PHP and MySQL";
}

mysql_close($db);


?>