Friday, March 16, 2007

SQL Server Full Text Search service running problem in Windows Vista

I use Windows Vista Business with all features turned on. When I installed SQL Server 2005 Developer Edition, I found Full Text Search service can't start itself. I tried running it from Management Console -> Services. It still fails with message: "The dependency service does not exist or has been marked for deletion."

So, what I did to remove the dependencies:

  • Opened Registry Editor (regedit.exe)
  • Went to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\msftesql$SQLSERVER
  • Removed the contents (Data) of DependOnService key
  • Rebooted. Now works fine.

I wasn't sure what particular dependencies were culprit, so I removed all and it works fine. Another thing to remember when you'll see any correct FullText SQL isn't working, check if the FullText service is running smoothly

Tuesday, March 13, 2007

Setting up PHP environment for Selenium

If you have gone through configuring Selenium in Windows system by Setting up Selenium RC server in Windows and Setting up PHP in Windows using Abyss server, next thing you need to setup is the Selenium PHP client. Let me show you the steps I've gone through to accomplish this:

1. Open up the console with all administrative privileges especially in Vista
2. Go to the directory where PHP is installed
3. Execute command: php PEAR/go-pear.phar
4. Follow the instructions, and ignore the additional offerings to configure it
5. Install PHPUnit by:
pear channel-discover pear.phpunit.de
pear install phpunit/PHPUnit

6. Download Selenium PHP PEAR extension and place into your PHP directory
7. Run: pear install Testing_Selenium-0.4.2.tar
8. Download the sample GoogleTest and assuming you put it in C:\Tests folder
9. Now run: phpunit --verbose GoogleTest C:/Tests/GoogleTest.php
10. Remember the class name GoogleTest must be the same as the class name defined in the GoogleTest.php

Sunday, March 11, 2007

Setting up PHP in Windows using Abyss server

Reason behind installing another server to your system
Whichever platform you have been working with must using a server. For .NET developers, IIS eases all the pain. So, what is now if you must install PHP in your system side by side .NET. I suggest you not to install PHP in the same server the .NET is working in. So, install another server which will work with all burdens of PHP stuffs.

Why Abyss?
The reasons behind choosing this server is Abyss is free, easy to configure, very lightweight, and small to download at only 344KB. It also has a preconfigured PHP version for them with all official extensions.

Step by Step
1. Download Abyss server, and install with default settings. Download and install preconfigured PHP version for Abyss
2. Hit this URL in your browser: http://127.0.0.1:9999/console/language
3. Choose your preferred language
4. Enter your chosen user name and password for the server, and click OK.
5. It will then ask your user name and password again, enter the credential and press OK. You will see the following screen:

clip_image002

6. Click on “Configure” from the Hosts table. You will find the following screen:

clip_image002[5]

7. Click on “Scripting Parameters”.
8. You will find the following Interpreters table, click “Add”:

clip_image002[7]

9. Set the Interface drop down to: FastCGI (Local - Pipes).
10. In interpreter field set the path: C:\Program Files\PHP5\php-cgi.exe if you have installed PHP in C:\ Program Files
11. Set Type drop down to PHP Style.
12. Make sure "Use the associated extensions to automatically update the Script Paths" is checked.
13. Click “Add” in Associated Extensions table:

clip_image002[9]

14. Type php in the extension field and pesss OK. Press two more OK.
15. Click on “Restart” to restart the server so that configuration changes can take effect.
16. If you have installed Abyss Server in C:\Program Files, we will have to deploy your web files inside C:\Program Files\Abyss Web Server\htdocs to make it work.
17. Your server address will be http://localhost:8000/

Setting up Selenium RC server in Windows

1. Download latest Java SE from http://java.sun.com/ and install

2. Download latest version of Selenium RC from and extract

3. Create a folder named Selenium at C:\Program Files\Java\jdk1.6.0_03\bin

4. Copy all files under Selenium-server-0.9.2 which you will find in the extracted folder and paste in the newly created folder

5. From Command prompt run the following commands:

cd \
cd C:\PROGRA~1\Java\jdk1.6.0_03\bin
java -jar .\Selenium\selenium-server.jar -interactive

If you see the following messages at the end of the console, you are quite confirm that the Selenium server is running fine:

Entering interactive mode... type Selenium commands here (e.g: cmd=open&1=http:/
/www.yahoo.com)