Pls share experiences with Testlink 1.7 + IIS + SQL Server

The release related discussions, plans and questions.

Pls share experiences with Testlink 1.7 + IIS + SQL Server

Postby rajprasa » Thu Feb 26, 2009 6:17 pm

Hi

Can someone share their experiences installing testlink on
IIS and SQL server.

Thanks in advance

Rj
rajprasa
TestLink user
 
Posts: 14
Joined: Wed Jan 21, 2009 1:28 am

Postby rajprasa » Tue Jun 02, 2009 9:52 pm

Configuring PHP with IIS

PHP with Microsoft IIS

Please make sure the following are taken care



The IIS user (usually IUSR_MACHINENAME) needs permission to read various files and directories, such as php.ini, docroot, and the session tmp directory.
Be sure the extension_dir and doc_root PHP directives are appropriately set in php.ini. These directives depend on the system that PHP is being installed on. In PHP 4, the extension_dir is extensions while with PHP 5 it's ext. So, an example PHP 5 extensions_dir value is "c:\php\ext" and an example IIS doc_root value is "c:\Inetpub\wwwroot".
Permission change for IUSR_MACHINNAME


Change the IUSR_MACHINENAME group owner to Administrator



Navigate to Control Panel à User Accounts à User Accounts

It would be something like IUSR_XXXXX .. it is owned by Guests


Changed the below users group permissions to “Administrators”

IUSR_XXXXX

Copy php.ini-recommended file
Navigate to the php extracted folder c:\php


Copy the php.ini-recommended file and rename the file as “php.ini”
Open php.ini file in a text editor


Delete the semicolon at the beginning of the include_path


; Windows: "\path1;\path2"

;include_path = ".;c:\php\includes"



To



; Windows: "\path1;\path2"

include_path = ".;c:\php\includes"





doc_root value in php.ini


Add c:\Inetpub\wwwroot as the value for doc_root


doc_root = "C:\Inetpub\wwwroot"



extension_dir value in php.ini
Add the below value in extension_dir



extension_dir = "C:\php\ext"



Uncomment the below line


extension=php_mssql.dll



Uncomment the session.save_path for temporary value


; where MODE is the octal representation of the mode. Note that this

; does not overwrite the process's umask.

session.save_path = "C:\temp"



Uncomment variables related to mssql


Uncomment the below lines

mssql.batchsize = 0

mssql.datetimeconvert = On




; Use NT authentication when connecting to the server

mssql.secure_connection = Off

ntwdblib.dll



Copy the ntwdblib.dll in the below locations



C:\php

And

C:\windows\system32


Version of the ntwdblib.dll 2000.80.194.0

Set Environment Variable for PHP


PATH variable append

Go to Start > Settings > Control Panel



In Control Panel, double click on “System”.

In System Properties window,

Click on “Advanced” Tab and

Click on “Environmental Variables”



In “Environmental Variables” window, Click on Path variable under

“System Variable” and click “Edit” button


Add C:\php; at the end of Variable value. Click OK

Click OK for Environment Variables and System Properties

PPHPRC variable creation



Go to Start > Settings > Control Panel



In Control Panel, double click on “System”.

In System Properties window,

Click on “Advanced” Tab and

Click on “Environmental Variables”



In “Environmental Variables” window, Click on Path variable under

“System Variable” and click “New” button



Add the System Variable à PHPRC in the System Environment Variables with the value “C:\php”

Click OK

Configure IIS to use ISAPI module


To use the ISAPI module, do the following:

If you don't want to perform HTTP Authentication using PHP, you can (and should) skip this step. Under ISAPI Filters, add a new ISAPI filter. Use PHP as the filter name, and supply a path to the php4isapi.dll / php5isapi.dll.
Under 'Home Directory', 'Virtual Directory', or 'Directory', do the following:
Change the Execute Permissions to 'Scripts only'
Click on the 'Configuration' button, and choose the Application Mappings tab. Click Add and set the Executable path to the appropriate ISAPI DLL. An example PHP 5 value is: C:\php\php5isapi.dll Supply .php as the extension. Leave 'Method exclusions' blank, and check the 'Script engine' checkbox. Now, click OK a few times.
Stop IIS completely (NET STOP iisadmin)
Start IIS again (NET START w3svc)


Navigate to Control Panel à Performance and Maintenance à Administrative Tools

Double click the icon à Internet Information Services(IIS6) Manager

Select “Default Web Site” à Home Directory

Change the Execute permission to à Scripts only



Make sure the Local Path is “c:\inetpub\wwwroot”


Click Configuration… button


And choose the Application Mappings tab. Click Add and set the Execuctable path to the appropriate ISAPI DLL. ( “C:\php\php5isapi.dll”)

Supply .php as the extension

Cick OK

Restart the IIS Server



Restart the IIS server after the above configuration changes



Navigate to the Control Panel

And restart the service as below:





By clicking Yes, it will stop and start the following

Simple Mail Transfer Protocol

WorldWide Web Publishing

IIS service

Create test PHP file


Open Notepad and type the following code:



<html>

<body>

<?php phpinfo() ?>

</body>

</html>




Save the file as test.php in C:\Inetpub\wwwroot

Test the PHP Installation

http://localhost/test.php


Please make sure “php.ini” file is loaded and mssql is enabled
rajprasa
TestLink user
 
Posts: 14
Joined: Wed Jan 21, 2009 1:28 am


Return to TestLink 1.7 (Closed)



Who is online

Users browsing this forum: No registered users and 2 guests