1. The forum you are viewing relates to Kayako 3, which reached end of life in 2012. Please be aware that a lot of information relating to features, sales and the roadmap in the Kayako 3 forums is now outdated or defunct (i.e. plain wrong!).

    If unsure about anything, please create a new thread or contact us.

    You can visit the main forums for the latest Kayako here.

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

Discussion in 'Email piping' started by bardfor, May 30, 2008.

  1. bardfor

    bardfor New Member

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

    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\includes"”
    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
     

    Attached Files:

  2. supportskins

    supportskins Kayako Guru

    Excellent, great share!
     
  3. Jamie Edwards

    Jamie Edwards Chief Limey Staff Member

    Hi there,

    Thank you very much for sharing this guide; I am sure many users will find it useful [​IMG]
     
  4. tazwilks

    tazwilks New Member

    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.
     
  5. craigbrass

    craigbrass New Member

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

    asiri Member

    I 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.
     
  7. dohongphuc

    dohongphuc New Member

    Great! I'm sure Ioncube is the same.
     
  8. thill

    thill New Member

    this information was very helpful, thx
     
  9. MatiasCandy

    MatiasCandy New Member

    Do I still have to do the wget with the latest version and enable POP3/IMAP Fetching?
     
  10. supportskins

    supportskins Kayako Guru

    Yes you do need wget.
     
  11. kyenilmez

    kyenilmez New Member

    Hello,

    In support suite default time for POP3/IMAP Fetching Task is 10 Minutes. Is there any chance to change time setting?

    Thanks.
     
  12. Casey Rousseau

    Casey Rousseau New Member

    Not in the interface. You can manually force the POP3/IMAP Fetching Task by clicking its Run button from Admin CP > Scheduled Tasks. Note that you could also regulate this on a more frequent than ten minutes rate by setting up a scheduled task to run that link's url (http://mysupportsite.url/admin/index.php?_m=core&_a=managetasks&do=run&taskid=3)
     
  13. bstrauss

    bstrauss New Member

    Hi, I'm dealing with an existing installation on a win2k3 server. We have not had email parsing before and I am trying to get it working.

    I completed steps 16.c.8 through 16.c.10 above and the completed through 8.a in the second section. At 8.b I get the following message:
    -------
    ERROR: Your PHP is not compiled with IMAP Support.
    *NIX Users should recompile the PHP with the --with-imap flag and Windows users can simply uncomment the extension='php_imap.dll' line in their php.ini
    -------
    So I made sure the line was not commented in php.ini, and even restarted IIS. Did I miss something? I'm not very familiar with php installs on windows, so I could be missing something really silly here.

    Thanks in advance
     
  14. idxman01

    idxman01 Member

    apache flavor

    Not to hijack bardfor's hard work with the IIS/PHP setup, but if I have time I can try to do a quick checklist for using Apache via the XAMPP package if that would help. We're currently using it to demo eSupport on a Windows 2003 server. (R2 enterprise)

    Many of the steps are similar, but I think there may have been fewer configuration changes required.

    Although good info on some of the PHP settings barfor. I hadn't adjusted any of them just yet.
     
  15. jchin23

    jchin23 New Member

    I'd be interested in those instructions.
     

Share This Page