Setting up e-mail parsing using POP3 (or IMAP) on Windows 2003 Server

[bardfor]

All,

This is a two part set of instructions. The first half of these instructions goes over how to install SupportSuite on Windows 2003 Server. The second half goes over setting up e-mail parsing on Windows 2003 Server.

Attached to this page (at the bottom) are two PDF files with these two sets of instructions that may be easier to print or read (formatting is a little better).

For the first half, the SupportSuite installation, I've updated the instructions originally posted by Brendan.main (here) and update by mopa (here).

For the second half, the e-mail parsing, these were gleaned from a few sources.

---------------------

SupportSuite Installation on Windows 2003 Server

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

-------------------------------------------------------------------

Setting up e-mail parsing using POP3 (or IMAP) on Windows 2003 Server

This set of instructions should help guide you through creating a successful POP3 (or IMAP) implementation for a SupportSuite installation. These instructions were created with the following software installed:

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

E-mail parsing instructions

1. Create an e-mail account & password

2. Log in to the Admin console of SupportSuite

3. Click on Settings, CPU Optimization & Server
3.a. Input the Account information in the SMTP settings
3.b. Click Update Settings

4. Click on Mail Parser
4.a. Select Insert E-mail Queue
4.b. Fill in the appropriate blocks (name, e-mail address, etc.)
4.c. Select POP3 (or POP3S, IMAP, or IMAPS depending on your environment)
4.c.1. Ensure extension=php_imap.dll does not have a “;” in front of it in your php.ini file
4.d. Click Next
4.e. Select the appropriate department
4.f. Click Update

5. Click on Scheduled Tasks
5.a. Click “Enable” on POP3/IMAP Fetching (if necessary)

6. Download the latest version of wget
6.a. One location to get wget is: Windows Wget files
6.b. Create the folder C:\Program Files\wget
6.c. Extract wget.exe in to the folder you just created

7. Log in to the actual Windows host system

8. Open Internet Explorer
8.a. Go to: http://{site}/cron/index.php?_t=parser
8.b. You should get a screen that shows something similar to this:

Total Messages in Inbox: 0
0 Total Messages
Rejected Messages: 0
Accepted Messages: 0

8.c. If so, your mail parser is set up correctly

9. Select Start, Control Panel, Scheduled Tasks, Add Scheduled Task
9.a. Click Next
9.b. When prompted for the program, click Browse & navigate to C:\Program Files\wget\wget.exe
9.c. When prompted for the time to run the task, select “Daily” and click Next
9.d. Leave the defaults & click Next
9.e. Enter the username & password of the account that will be used to run this process & click Next
9.e.1. If you are on an Active Directory domain w/ Exchange, this can be the same account that is associated with the e-mail address
9.f. Check the box “Open advanced properties for this task when I click Finish” and click Finish

10. The “Advanced” properties window should open
10.a. Update the run line to: "C:\Program Files\wget\wget.exe" -q -O NUL http://{site}/cron/index.php?_t=parser
10.b. Ensure “Enabled” is checked
10.c. Click on Schedule tab
10.d. Click the “Advanced” button
10.d.1. Check “Repeat task”
10.d.2. Change the interval (if necessary)
10.d.3. Change the duration to 23 hours, 59 minutes
10.e. Click OK or Apply as necessary to exit

Instructions created by B. Cary

[supportskins]

Excellent, great share!

[Jamie Edwards]

Hi there,

Thank you very much for sharing this guide; I am sure many users will find it useful

[tazwilks]

Great guide, wish I'd found it first; the title is very misleading though. I'm sure this would be invaluable for all new users setting up their SupportSuite. Perhaps Jaimie could put it under Installation & Upgrading and with a more appropriate title and make it sticky.

[craigbrass]

I disagree. This post is about setting up the mail parser which is why it is in this board.

[asiri]

I too agree (with tazwilks) that this should be in the "Installation..." keyword thread. The mail parser is only a small part of the article. This article would have saved me a lot of trouble if it were in the correct area.

[dohongphuc]

Great! I'm sure Ioncube is the same.

[thill]

this information was very helpful, thx