MySQL, PHP, IISv6 & Zend Installation

[Brendan.main]

Kayako Suite Installation with IIS6, PHP 5.2, MySQL 5.0.27, Zend 3.2.2

1. Install Windows 2003 Server

2. Install IIS

3. Create new folder called “PHP” under C drive.

4. Extract PHP files to PHP folder

5. Install MySQL

6. Install MySQL Admin GUI

7. Install Zend.

8. Go into IIS, go to web extensions, click on “add new web service extension”.



9. Extension name “PHP”, click browse, go to “C:\PHP\php5isapi.dll”, click OK, tick “set extension status to allowed”, click OK.


10. Do the same again but call this one MySQL and select “php_mysql.dll”. (This is because by default MySQL and PHP don’t talk to each other in the latest versions.


11. Right click your website and go to properties, go to “ISAPI filters” tab, click add, Name “PHP” extension “C:\PHP\php5isapi.dll”.

12. Click OK and restart computer and a green arrow should appear next to ISAPI filter to say it’s loaded. After you have restarted the server.

13. Go to IIS Documents, Add “setup.php”.

14. Go to IIS “Home directory”, click on “configuration”, click “Add”, Browse to “php5isapi.dll” filter, name extension “.php”. Click OK.

15. Right click My Computer, got to Properties, Advanced, Enviroment Variables, Highlight “PATH”, Click Edit, Go to the very end of Variable value and enter in “;C:\PHP”. (Make sure a “;” is before C:\PHP).


16. Create folder called “Kayako” under “C:\Inetpub\wwwroot” for kayako files.

17. Extract “Upload” files from kayako setup to kayako folder you just created under C:\Inetpub\wwwroot.

18. Put license key in kayako folder under “C:\Inetpub\wwwroot\kayako”.

19. Open config folder under kayako and edit config.php file and change hostname to ‘localhost’, username = root, password = (password), DB name = kayako (Which we will create in a minute with MySQL Admin) Save!

20. Select kayako folder under C:\Inetpub\wwwroot and set IUSR_(Computername) to have modify under security in folder properties, then click Apply.

21. Go to C:\Program Files\MySQL\MySQL Server 5 and edit “my.ini” file.

Delete text between sql-mode = “ “ quotation marks.
(This is to allow the mysql connect problem to be resovled).

22. Edit the php.ini file located in \Windows directory.
Change: session.save_path = \Temp
session.cookie_path = \
extension_dir = "C:\PHP\ext"
doc_root = "C:\Inetpub\wwwroot"
include_path = ".;c:\PHP\ext"
include_path = ".;c:\PHP"
include_path = ".;c:\php\includes"

Enable: extension=php_mysql.dll

[Mahesh Slaria]

Hi,

Excellent work. Thanks for sharing.

Regards,

[tkurzynski]

I was only confused with the last portion of your guide. First off you do not go into information for creating the MySQL database. I assume its straight forward either through GUI or CMD-line but just confirming. Also near the end you say to edit the php.ini in the WINDOWS directory. How does that file get there? When I extract PHP it doesnt even have an php.ini file yet and also Zend requires you to point to the php.ini file which I renamed the php.ini-recommended file and pointed my zend install to c:\php. Does PHP require the php.ini file to be in the Windows directory and what about the phpisapi5.dll file, should that be moved or copied to WINDOWS\system 32?

I have opened a thread to help other users with same setup and same questions... This will complete this guide and cover those little details needed. You can search for it here - PHP 5.2 installation on Win2k3 server

[iTeque]

Also ensure that you have:

short_open_tag = On

in PHP.ini otherwise you will end up with the dreaded blank page!

--
Sam

[Tenchi Ko]

hi,

i managed to go through and follow all the steps but however, have some problems with step 10, 13 and 14.

(step 10)
can I know where to locate the file php_mysql.dll ? if it shoud be in the PHP folder, it is not there.

(step 13, 14)
I am also unable to locate 'IIS Documents' to add setup.php and IIS "home directory" to add the extension ".php"

Can anyone assist ?
thanks

[supportskins]

can I know where to locate the file php_mysql.dll ? if it shoud be in the PHP folder, it is not there.

It should be in the extensions directory of PHP; "ext" directory if you are installing PHP5's latest version.

[Dynadata]

When do you need the install file?
If you extract the zip file to (for example) "C:\PHP", you will find 3 .exe files.
- php-cgi.exe
- php-win.exe
- php.exe

When do you start one of those files?
Also is there any difference between de php-win.exe and the php.exe?

[mylove4life]

Thanks for that one, it took me 2 hours to see this post to solve the problem

Originally Posted by iTeque

Also ensure that you have:

short_open_tag = On

in PHP.ini otherwise you will end up with the dreaded blank page!

--
Sam

[bardfor]

All,

I've updated the instructions originally posted by Brendan.main (on this post) and update by mopa (here). Also attached to this page (at the bottom) is a PDF file with these instructions that may be easier to print or read (formatting is a little better).

These instructions should guide users through installing SupportSuite on Windows 2003 Server & was created using the following versions of software:

• Windows Standard 2003 R3 Server SP2, IIS6, and all hot fixes
• PHP 5.2.6
• MySQL 5.0.51b
• MySQL GUI Tools 5.0r12
• ZendOptimizer 3.3.0a
• SupportSuite 3.20.02

Installation instructions.

1. Install Windows Standard 2003 R2 Server SP2

2. Install IIS6

3. Run Windows Update (until complete)

4. Install PHP
4.a. Download latest from http://www.php.net
4.b. For these instructions, I used the .zip file (non Windows installer)
4.c. Unzip PHP in the folder -> C:\PHP_526 (or, C:\PHP_{version})
4.d. Make a copy of the file “php.ini-recommended” & rename it “php.ini”

5. Install MySQL
5.a. Download latest from http://www.mysql.com
5.b. For these instructions, I used the Windows Essentials (x86) file
5.c. Use the “Typical” installation
5.d. Allow MySQL installation routine to configure database
5.e. Choose detailed configuration
5.e.1. Select Server Machine
5.e.2. Select Multifunctional database
5.e.3. Default InnoDB Tablespace Settings
5.e.4. Select Online Transaction Processing (OLTP)
5.e.5. Default TCP/IP Networking & Strict Mode
5.e.6. Standard Character Set
5.e.7. Install as a Windows Service and check “Include Bin Directory in Windows PATH”
5.e.8. Set the root password

6. Install MySQL GUI Tools
6.a. Download latest from http://www.mysql.com
6.b. For these instructions, I used the Windows (x86) file (installer)
6.c. Use the “Complete” installation

7. Install ZendOptimizer
7.a. Download latest from http://www.zend.com
7.b. Select IIS6
7.c. Select the folder where your php.ini file is
7.c.1. In my case, C:\PHP_526
7.d. Select defaults for the rest

8. Open IIS Manager
8.a. Go to “Web Service Extensions”
8.b. Select “Add a new Web service extension…”
8.b.1. Type extension name PHP
8.b.2. Click Add & select C:\PHP_526\php5isapi.dll
8.b.2.a. (Substitute the correct PHP folder, if necessary)
8.b.3. Check “Set extension status to Allowed”
8.b.4. Click OK
8.c. Select “Add a new Web service extension…”
8.c.1. Type extension name MySQL
8.c.2. Click Add & select C:\PHP_526\ext\php_mysql.dll
8.c.2.a. (Substitute the correct PHP folder, if necessary)
8.c.3. Check “Set extension status to Allowed”
8.c.4. Click OK
8.d. Expand “Web Sites”, right click “Default Web Site”, select Properties
8.d.1. Click the Documents tab
8.d.1.a. Click Add
8.d.1.b. Add “index.php”
8.d.1.c. Click “Select All” for instance overrides
8.d.1.d. Click Apply
8.d.2. Click the ISAPI Filters tab
8.d.2.a. Click Add
8.d.2.b. Filter name = PHP
8.d.2.c. Executable = C:\PHP_526\php5isapi.dll
8.d.2.d. Click OK, then click Apply

9. Reboot your computer

10. After rebooting, open IIS Manager again
10.a. Expand “Web Sites”, right click “Default Web Site”, select Properties
10.a.1. Click the ISAPI Filters tab
10.a.1.a. A green up arrow should appear next to PHP
10.a.2. Click on the “Home Directory” tab
10.a.2.a. Click the “Configuration” button
10.a.2.b. Click the “Add” button
10.a.2.c. Executable = C:\PHP_526\php5isapi.dll
10.a.2.d. Extension = .php (note the period in front of PHP)
10.a.3. Click OK (as necessary) and exit IIS Manager

11. Right click on “My Computer” and select “Properties”
11.a. Select the “Advanced” tab
11.b. Click on the “Environment Variables” button
11.c. Highlight “Path” in the System Variables window
11.d. Click the “Edit” button
11.e. Go to the end of the Variable Value and type, “;C:\PHP_526;C:\PHP_526\ext”
11.e.1. Ensure there is a “;” before C:\PHP_526
11.f. Click OK (as necessary) and exit Properties

12. Open Windows Explorer
12.a. Navigate to “C:\Inetpub\wwwroot”
12.b. Create a new text file named “phpinfo.php”
12.c. Edit “phpinfo.php” using Notepad
12.d. Enter these three lines in “phpinfo.php”
12.d.1. <?php
12.d.2. phpinfo();
12.d.3. ?>
12.e. Save “phpinfo.php” and close Notepad

13. Open Internet Explorer
13.a. Navigate to http://localhost/phpinfo.php
13.b. You should get the PHP Version screen w/ all the information regarding your PHP installation

14. Open Windows Explorer
14.a. Navigate to “C:\Inetpub\wwwroot”
14.b. Create a new folder named “kayako”
14.c. Extract the folder “Upload” from the kayako setup to the new “kayako” folder you created
14.d. Place your license file “key.php” in the kayako directory “C:\Inetpub\wwwroot\kayako”
14.e. Right click the “kayako” folder and select Properties
14.f. Click the “Security” tab
14.g. Select “Internet Guest Account” (IUSR_*machinename*) and check the “Modify” box
14.h. Click OK as necessary

15. Open Windows Explorer
15.a. Navigate to “C:\Program Files\MySQL\MySQL Server 5.0”
15.b. Open “my.ini” with Notepad
15.c. Remove all the text from between the “” marks for sql-mode=""
15.c.1. This is line 87
15.c.2. This allows the MySQL connect problem to be resolved
15.d. Save & close “my.ini”

16. Open Windows Explorer
16.a. Navigate to “C:\PHP_526”
16.b. Open “php.ini” with Notepad
16.c. Make the following changes:
16.c.1. Change “short_open_tag = Off” to “short_open_tag = On”
16.c.1.a. This is line 131
16.c.2. Change “max_execution_time = 30” to “max_execution_time = 600”
16.c.2.a. This is line 303
16.c.3. Change “magic_quotes_gpc = Off” to “magic_quotes_gpc = On”
16.c.3.a. This is line 490
16.c.4. Change “; include_path = ".;c:\php\includes"” to “include_path = ".;c:\php_526;c:\php_526\ext;c:\php_526\includ es"”
16.c.4.a. This is line 522
16.c.4.b. Note that the path must be enclosed in “ marks in php.ini
16.c.5. Change “doc_root = “ to “doc_root = C:\Inetpub\wwwroot”
16.c.5.a. This is line 529
16.c.6. Change “extension_dir = "./"” to “extension_dir = "c:\php_526\ext"”
16.c.6.a. This is line 536
16.c.7. Change “upload_max_filesize = 2M” to “upload_max_filesize = 5M”
16.c.7.a. This is line 597
16.c.8. Remove the “;” from in front of “extension=php_imap.dll”
16.c.8.a. This is line 665
16.c.8.b. Change this only if you plan to POP or IMAP mail into your system
16.c.9. Remove the “;” from in front of “extension=php_mbstring.dll”
16.c.9.a. This is line 668
16.c.10. Remove the “;” from in front of “extension=php_mcrypt.dll”
16.c.10.a. This is line 669
16.c.11. Remove the “;” from in front of “extension=php_mysql.dll”
16.c.11.a. This is line 675
16.c.11.b. Note that the path must be enclosed in “ marks in php.ini
16.c.12. Change “;session.save_path = "/tmp"” to “session.save_path = "\Temp"”
16.c.12.a. This is line 1041
16.c.12.b. Note that the path must be enclosed in “ marks in php.ini
16.c.12.c. Note the “;” must be removed
16.c.13. Change “session.cookie_path = /” to “session.cookie_path = \”
16.c.13.a. This is line 1062
16.d. Save “php.ini” and close Notepad

17. Open MySQL Administrator
17.a. Log in using the credentials from step 5 (above)
17.b. Click “Catalogs” from the left pane
17.c. Right click on one of the databases (lower left corner)
17.d. Select “Create New Schema”
17.e. Name the Schema “kayako” and click OK
17.f. Close MySQL Administrator

18. Open Windows Explorer
18.a. Navigate to “C:\Inetpub\wwwroot\kayako\config”
18.b. Open “config.php” with Notepad
18.c. Make the following changes:
18.c.1. Insert your password in between the quotes for “$_DB["password"] = "";”
18.c.1.a. This is line 27
18.c.2. Change “$_DB["name"] = "swift";” to “$_DB["name"] = "kayako";”
18.c.2.a. This is line 32
18.d. Save “config.php” and close Notepad

19. Restart your computer

20. Complete the SupportSuite installation by going to your site & going to http://{site}/setup

Instructions created by B. Cary