PDA

View Full Version : For Windows 2000 +PHP and SQL


Greg|NJ
Mon 25th Mar '02, 8:19pm
Anyone got a real true way on how to get this going?

live2travel
Mon 25th Mar '02, 11:55pm
1. Download the windows installer version of PHP 4.1.2 from php.net

2. ALSO download the windows .zip version (which contains all the extra extensions and other items)

3. Unzip the zip version into a temp folder.

4. Run the installer version.

5. Setup php to run as ISAPI, not with CGI. Do this by following the readme instructions in the unzipped version of PHP you downloaded from php.net.

To do so copy the SAPI folder from the temporary folder where you unzipped the .zip version of php.

Then you must set up php in the ISAPI filters list with php as the extension and c:\php\sapi\php4isapi.dll as the executable. Also, you must include php4isapi.dll as the executable for php extensions in the application exension mappings area of the "home directory" configuration area of your IIS Management area.

6. BE SURE to put php4ts.dll in the c:\winnt\system32 folder, as well as in c:\php

7. Copy the extensions folder from the unzipped PHP version into the c:\php or other similar folder where php was installed.

8. Edit your php.ini file to include gzip functionality and point the appropriate part of the file to the extensions folder you've created.

Here is a copy of my php.ini (the one setup by the php windows installer, with my modifications for gzip and 120 second php execution time).


; php.ini for PEAR tests
include_path=..
[mail function]
upload_tmp_dir = C:\PHP\uploadtemp ; temporary directory for HTTP uploaded files (will use system default if not specified)
[Session]
[PHP]
max_execution_time = 120
extension_dir = c:\php\extensions
extension=php_zlib.dll
[mail function]
; For Win32 only.
SMTP = localhost

; For Win32 only.
sendmail_from = webmaster@localhost.com


Let me know if this does NOT make sense, and I'll try to refine it for you if I can.

I've got it setup this way and it's been running great and fast.

Mark

Greg|NJ
Tue 26th Mar '02, 4:28pm
:( I get this:

Warning: Unlink failed (Permission denied) in c:\inetpub\wwwroot\vbb\admin\install.php on line 289

Attempting to attach to database...


Warning: Can't connect to MySQL server on 'localhost' (10061) in c:\inetpub\wwwroot\vbb\admin\db_mysql.php on line 38

Warning: Supplied argument is not a valid MySQL-Link resource in c:\inetpub\wwwroot\vbb\admin\db_mysql.php on line 47

The database has failed to connect because you do not have permission to connect to the server. Please go back to the last step and ensure that you have entered all your login details correctly.


I'm stuck, now what do I do?

Greg|NJ
Tue 26th Mar '02, 8:04pm
Anyone? :confused:

sHORTYWZ
Mon 1st Apr '02, 6:55pm
What is the advantage to setting up PHP as ISAPI vs CGI?

hypedave
Mon 1st Apr '02, 7:02pm
what steps have you done so far, and how is your ws2k box configured ?

what version of php are you running
what version of mysql are you running
what version of vb are you running

Greg|NJ
Mon 1st Apr '02, 8:11pm
1. Copied the files to c:\inetpub\wwwroot\vbb
2. Edited config.php
3. Powered up IIS and MySQL
4. Ran through the install
5. Got up to step three and get that message

PHP = 4.1.2
SQL = 3.29
VBB = 2.2.4

Greg|NJ
Tue 2nd Apr '02, 9:51pm
It has to be something I did. Because I can't install Ikonboard with MySQL.I did about a week ago.I tried uninstalling it and reinstalling it. No go. Oh well, going to switch servers soon. :D