Hi
Can someone share their experiences installing testlink on
IIS and SQL server.
Thanks in advance
Rj
Pls share experiences with Testlink 1.7 + IIS + SQL Server
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
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