MacUSA

I have a newly installed Windows Server 2003 Standard server. I downloaded and installed the 5.2.4 installer package for IIS CGI from php.net. Tried the test.php page I copied from another (Mac) server. Didn't work. Page not found error. I went through all the manual install instructions and verified that the automatic installer did it's job. There were a few discrepancies that I corrected in the php.ini file and the registry. NOTE: Before I installed PHP I had installed the new FileMaker Server 9 Advanced Demo package. There was a problem and I uninstalled it. This package installs PHP 5.2.1 on the server and creates registry entries. Uninstalling it removes PHP but not the registry entries. I found the IniFilePath key still pointing to FileMaker's removed install. I changed it to the correct path. The problem now is that I cannot get PHP to work without enabling "All Unknown CGI Extensions" in the "Web Service Extensions". Seems quite odd that PHP runs fine with the run all unknown option and not without. This is a security risk that I must correct before utilizing this server. I checked the websites, for all the typical things. MIME, file extensions/types/mappings, default documents, etc. Help! Thanks, Dan McFalls

Although I see no indication of damaged databases, I guess I'm just going to have to accept it. This database does not belong to me. We host it. We were responsible for backing it up. Unknown to us, it appearrently required a special backup requirement. We cannot recreate the database. I seem to be able to convert it to Access with a $40 utility app. Seems odd if they are truly damaged. Perhaps the last thing I do to salvage this account is to convert the databases to Access and back to MySQL. I’ve already lost many hours troubleshooting. What’s another $40 and an hour to save a 5 year account? Thanks for all your help! Dan

I already did try this. it didn't work.

1) There are no .ini files in the root level of the MySQL directory. 2) Once I get this working i would like to try getting the other unrelated databases going that are in the MySQL/data directory. Making the change you suggested would prevent those from working. 3) If the data connections work similar to what I use in ColdFusion and MS Access, making the directory change in the ini file wouldn't make a difference. The data connection and the file locations are unrelated once setup. 4) I'm wondering (again i know nothing about MySQL) were the databases supposed to undergo some conversion process going from version 4 to 5? Thanks again, Dan

Let me clarify. I copied all files off the drive (while SQL was disabled). Reformatted and reinstalled everything. Installed newer versions of MySQL and PHP that were on there previously. Copied all data back in the same position as previously. This site ran 5 years with the data directory within the database directory within the data directory of the MySQL directory. The database does not appear to be damaged. I’m reviewing its contents in the MySQL Query browser. I feel strongly that this is a configuration issue. I just don’t know what I’m doing. I am willing to pay somebody to hop on using Timbuktu or logmein.com to fix this ASAP. Thanks, Dan

I still have the original copies I backed up from the server before reformatting. Although they weren't saved in the method you suggest this doesn't appear to be the problem. The database is in a subdirectory named data of the main database directory. eg. MySQL/Data/handlessing/data/ I can see the database named COUNTER when I go to the Backup option in the Admin app and create a new backup project. So it is there but PHP thinks not. Dan

First I would like to thank all that have assisted. I keep getting a bit closer with your help. Next. As I mentioned previously, i know nothing about MySQL. I just realized that I was supposed to add the database user to the Adminstrator application. After doing that I now get: Detecting Mysql: MySQL Extension loaded Defining MySQL credentials... Connecting to mysql... Connection successful! Defining SQL query: (SELECT * FROM counter_tbl WHERE id=1) Running query... SQL Query Error: Table 'handblessings.counter_tbl' doesn't exist The path to the database is (and was previously): C:\mysql\data\handblessings Within that directory there are a bunch of files (tables i think) and another direcroty named data. This is where the counter table resides. I tried copying the files in the subfolder to the handblessings folder and still get the same message above. I reverted everything back. Dan

Detecting Mysql: MySQL Extension loaded Defining MySQL credentials... Connecting to mysql... Connection failed! Access denied for user 'USERNAME'@'localhost' (using password: YES) Is there somewhere in IIs or the PHP application that I need to define the "root" user and password that I assigned when installing MySQL? Thanks.

I'm assuming you wanted me to start a new php test document. Here's the results: PHP Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\www\members\handblessings\www\testr.php on line 3

Thanks for your assistance. Unfortunately I know nothing about MySQL and VERY LITTLE PHP. I expected this to just work like it did before I had to remake the server. I copied all the files before the reformat and put them all back except for installing the new PHP and MySQL. If I can't find someone to fix this I may just convert the SQL database to Access and redo the site in ColdFusion -- a language I can work with. Just a lot of unnecessary hours. Thanks again. Dan

Tried substituting the IP address and port 3306 for the localhost and using the full path to the database. Same results except the ez_sql.php page now displays: SQL/DB Error -- [ Error establishing a database connection! Are you sure you have the correct user/password? Are you sure that you have typed the correct hostname? Are you sure that the database server is running? ] SQL/DB Error -- [ Error selecting database C:\mysql\data\handblessings! Are you sure it exists? Are you sure there is a valid database connection? ] PHP Notice: Undefined property: db::$last_query in C:\www\members\handblessings\www\EZ_SQL.PHP on line 90 PHP Notice: Undefined property: db::$last_query in C:\www\members\handblessings\www\EZ_SQL.PHP on line 90

The attached TXT doc is before I started experimenting. Going to the page on the server yields: SQL/DB Error -- [ Error establishing a database connection! Are you sure you have the correct user/password? Are you sure that you have typed the correct hostname? Are you sure that the database server is running? ] SQL/DB Error -- [ Error selecting database handblessings! Are you sure it exists? Are you sure there is a valid database connection? I'm certain there is a connection and I have the correct login info. I was able to test it with the MySQL GUI tools. Thanks! [attachment deleted by admin]

Copied from the first few lines of the index page. <? include_once "ez_sql.php"; $counter = $db->get_row("Select * from counter Where id=6"); $count = $counter->counter+1; $db->query("Update counter set counter=$count Where id=6"); ?>

get_row("Select * from counter Where id=6"); $count = $counter->counter+1; $db->query("Update counter set counter=$count Where id=6"); ?>

Last week a hacker took the IIs 6 server down. It was running PHP 4 and an early version of MySQL. There's only one website utilizing PHP and MySQL on this server. I was forced to erased the HD and reinstall everything. Windows 2000 Server, PHP 5 and the current version of MySQL. PHP is working. MySQL is working. However they are not connecting to each other. Going to the website I see SQL commands at the top of each page. We know nothing about MySQL. The original developer is out of business. After spending many hours goofing around with this I'm mostly certain that it's just a configuration issue somewhere between MySQL and PHP. Or perhaps the upgraded PHP and MySQL is not compatible with the old MySQL database. I don't know what I've missed. Be happy to pay any developer that can get this site back up ASAP. Dan McFalls (708) 233-6200 ext. 101.