Kayako logo
SupportSuite, eSupport and LiveResponse Discussion, troubleshooting and feedback related to Kayako's flagship support desk products SupportSuite, eSupport and LiveResponse.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  (#16) Old
elephant Offline
New Member
 
Posts: 20
Join Date: Apr 2005
27-09-2005, 03:09 AM

Doing a little more digging, it seems that IIS 6 security model has changed causing PHP not to allow shell_exec()

Can anyone confirm aspell in kayako is working under Windows 2003?
   
Reply With Quote
  (#17) Old
netFusion Offline
Member
 
Posts: 343
Join Date: Sep 2003
Location: My wife calls it the doghouse...
27-09-2005, 08:01 AM

Quote:
Originally Posted by elephant
Doing a little more digging, it seems that IIS 6 security model has changed causing PHP not to allow shell_exec()

Can anyone confirm aspell in kayako is working under Windows 2003?

I have it working under Windows 2003.

The problem you are seeing with shell_exec() failing is because of the way you have the security permissions set on your server. Don't worry, this is a good thing! It means you have your web site users locked out of your Windows system folder.

In order to get the shell_exec() to work, you will need to give the web site user account (IUSR_...) Execute privileges on the system file %systemroot%\system32\cmd.exe (C:\WINDOWS\SYSTEM32\CMD.EXE).

SHELL_EXEC() fails because PHP launches CMD.EXE in order to run the command line app for aspell.exe.

This should be done VERY VERY VERY carefully because it can compromise the security on your server.

Make SURE that you ONLY grant the web site user for your SupportSuite/eSupport web site execute permissions to that one file. Do NOT give the web site user access to the folder or anything else in that folder.

Make SURE that nobody else (other than you) has ANY access to upload scripts of ANY kind to the web site running your SupportSuite/eSupport web site.

If you let anyone upload a script to that website, and the script calls a shell command via PHP, their script can compromise your server.

Again, be VERY careful to make sure you grant ONLY the web site user account access to ONLY that file in the system32 directory.

Note that in addition to mhunt's instructions above, I also had to add the "C:\Program Files\Aspell\bin" folder to the system path in order to get Aspell to find the dictionary files.

Oh, and did I remember to mention that you NEED to be careful with your permissions?

Eddie


netFusion Computer and Network Solutions
Web Site: http://www.netFusionKC.com
Web Store: https://www.netfusionkc.com/store/

Anything I say or do is my own opinion and may make absolutely no sense to anyone but me...

Last edited by netFusion; 27-09-2005 at 08:20 AM..
   
Reply With Quote
  (#18) Old
netFusion Offline
Member
 
Posts: 343
Join Date: Sep 2003
Location: My wife calls it the doghouse...
27-09-2005, 08:14 AM

Quote:
Originally Posted by mhunt
. . . I have no idea why this is needed, but for some reason, the Windows version of php/aspell won’t support the data files which are installed by default.

This is because the files provided are from a *nix platform. It was the CR/LF conversion when they were extracted from the tar.gz file onto the Windows platform that killed them.

Eddie


netFusion Computer and Network Solutions
Web Site: http://www.netFusionKC.com
Web Store: https://www.netfusionkc.com/store/

Anything I say or do is my own opinion and may make absolutely no sense to anyone but me...
   
Reply With Quote
  (#19) Old
mhunt Offline
Member
 
Posts: 42
Join Date: May 2005
27-09-2005, 08:33 AM

Thanks Eddie....that makes sense. Hopefully the info in this thread will make it through to the manual.
   
Reply With Quote
  (#20) Old
elephant Offline
New Member
 
Posts: 20
Join Date: Apr 2005
27-09-2005, 01:04 PM

Since the speller is a .dll loaded into php, why cant the methods for pspell be called thru php rather than dropping to CMD and running the executible?

This does seem like it could be a potentially a bad security risk.
   
Reply With Quote
  (#21) Old
netFusion Offline
Member
 
Posts: 343
Join Date: Sep 2003
Location: My wife calls it the doghouse...
27-09-2005, 04:30 PM

Quote:
Originally Posted by elephant
Since the speller is a .dll loaded into php, why cant the methods for pspell be called thru php rather than dropping to CMD and running the executible?

This does seem like it could be a potentially a bad security risk.
The speller (aspell.exe) is actually a windows command line application, not a dll loaded into php. That's the catch... php_pspell.dll is an interface that allows it to call the speller interface. It actually calls the aspell-15.dll shim that shells to CMD and runs aspell.exe. aspell-15.dll isn't the actual speller.

If someone knew enough to rewrite/recompile aspell.exe as an actual php module instead of a windows command line app, there would be a lot of happy campers visiting the GNU ASPELL web site!


netFusion Computer and Network Solutions
Web Site: http://www.netFusionKC.com
Web Store: https://www.netfusionkc.com/store/

Anything I say or do is my own opinion and may make absolutely no sense to anyone but me...
   
Reply With Quote
  (#22) Old
elephant Offline
New Member
 
Posts: 20
Join Date: Apr 2005
27-09-2005, 06:40 PM

There has to be a spell checker for PHP thats integrated.

Or how about a webservice, like Google Spell Checker API. Here some details:

http://www.dotnetjunkies.com/Tutoria...3C09CD94B.dcik
   
Reply With Quote
  (#23) Old
Varun Shoor Offline
Chief Executive Officer
 
Varun Shoor's Avatar
 
Posts: 2,651
Join Date: May 2003
28-09-2005, 10:34 PM

We can use the PHP inbuilt spell checker, It might not make into the gold but the code can certainly be edited to support it.

Regards,

Varun Shoor


Varun Shoor (varun.shoor ]at[ kayako.com)
----------------------------------------------------------------
---
   
Reply With Quote
  (#24) Old
chrisbuk112
Guest
 
Posts: n/a
07-12-2005, 04:21 PM

hi

as anyone got the aspell-data.zip file? as the above links dont work.
   
Reply With Quote
  (#25) Old
elephant Offline
New Member
 
Posts: 20
Join Date: Apr 2005
07-12-2005, 08:29 PM

Does anyone have a way to use the internal php speller? Am sure this is going to be an issue for Windows installations of kayako.
   
Reply With Quote
  (#26) Old
elephant Offline
New Member
 
Posts: 20
Join Date: Apr 2005
28-04-2006, 09:25 PM

Ping. Does anyone have a new solution for getting spellcheck to work in Windows 2003?
   
Reply With Quote
  (#27) Old
gguarnere Offline
Member
 
Posts: 42
Join Date: Jul 2006
18-08-2006, 04:59 PM

same issue here...please help
   
Reply With Quote
  (#28) Old
Varun Shoor Offline
Chief Executive Officer
 
Varun Shoor's Avatar
 
Posts: 2,651
Join Date: May 2003
18-08-2006, 09:03 PM

I will see if we can add a toggle to switch to Aspell extension available with PHP (On most systems atleast) on Monday.

If not, Then it might not make into the .98 stable build.

Regards,

Varun Shoor


Varun Shoor (varun.shoor ]at[ kayako.com)
----------------------------------------------------------------
---
   
Reply With Quote
  (#29) Old
scoutdriver73 Offline
New Member
 
Posts: 1
Join Date: Oct 2006
Aspell working with Server 2003 SP1 - 01-10-2006, 08:11 PM

I know this thread is old, but I was trying to get Aspell to work Windows Server 2003 SP1, and was getting the System Error: Aspell program execution failed

Following the instuctions in this thread did not solve my problem. I had to give the "everyone" group read/write access to temp directory. After doing this, Aspell worked great.

To Recap:

1. Follow directions posted by mhunt.
2. Add permission to cmd.exe as outlined by netFusion.
3. Give "Everyone Group" read/write permsions on the Windows\Temp dir
   
Reply With Quote
  (#30) Old
webit_csullivan Offline
New Member
 
webit_csullivan's Avatar
 
Posts: 6
Join Date: Oct 2006
30-10-2006, 05:05 PM

Thanks scoutdriver73 the missing thing for me was giving the correct permissions to the Windows temp dir like you said in number 3. My only small suggestion is to give Authenticated Users read/write permissions as it is a little more secure than the everyone group. I did and it works just great now.

Kudos to you!

Thanks everyone and especially md3v for your help.

Chad
   
Reply With Quote
Reply

Tags
checker, spell

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Spell Checker error ]SK[ SupportSuite, eSupport and LiveResponse 7 03-09-2007 06:49 PM
No words in spell checker dictionary IVRnet SupportSuite, eSupport and LiveResponse 0 06-07-2007 10:26 PM
Adding the JSpell Spell Checker to Submit a Ticket chelsel Developers & Code 5 27-03-2007 04:57 PM
Spell Checker Failure. Darren SupportSuite, eSupport and LiveResponse 23 30-10-2006 05:06 PM



Powered by vBulletin® Version 3.7.5
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
Help desk software by Kayako.


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48