i can not create testcases ! ISS 7.0 , PHP 5.2.17. MSSQL

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

i can not create testcases ! ISS 7.0 , PHP 5.2.17. MSSQL

Postby KianSS » Fri May 18, 2012 6:56 pm

i can not create testcases !

hope you can help me .


i installed IIS 7 , FastCGI with PHP Version 5.2.17 , MS SQL 2008

i can create Users, can see the complete GUI "pictures, CSS files" which means for me , that i have the correct folder permissions.


i created a Database named testlink and run the following scripts:

1) testlink-1.9.3installsqlmssqltestlink_create_tables.sql
2) testlink-1.9.3installsqlmssqltestlink_create_default_data.sql



My problem:

i can create a Project , a Plan, creat new user, give them roles ! i can creat a Testsuite.


BUT when i want to create a testcase for the testsuite i will get a timout !

HTTP Error 500.0 - Internal Server Error

C:phpphp-cgi.exe - The FastCGI process exited unexpectedly




Module

FastCgiModule



Notification

ExecuteRequestHandler



Handler

php-5.2.17



Error Code

0xc0000005





Requested URL

http://localhost:80/lib/testcases/tcEdi ... tainerID=3



Physical Path

C:inetpubwwwrootlibtestcasestcEdit.php



Logon Method

Anonymous



Logon User

Anonymous



Failed Request Tracing Log Directory

C:inetpublogsFailedReqLogFiles



my phpinfo is showing mssql with alle the correct Configs:


[MSSQL]

mssql.allow_persistent = On
mssql.max_persistent = -1
mssql.max_links = -1
mssql.min_error_severity = 10
mssql.min_message_severity = 10
mssql.compatability_mode = Off
mssql.secure_connection = Off
mssql.connect_timeout = 5
mssql.timeout = 60
mssql.batchsize = 0
mssql.datetimeconvert = On

extension=php_mssql.dll


extension_dir = "C:phpext"
upload_tmp_dir = "C:inetpubwwwroottemp"
open_basedir = "C:inetpubwwwroot"
error_log = "C:WindowsTempphp-5.2.17_errors.log"
cgi.force_redirect = 0
cgi.fix_pathinfo = 1
fastcgi.impersonate = 1
html_errors = Off
fastcgi.logging =
KianSS
TestLink user
 
Posts: 5
Joined: Fri May 18, 2012 6:40 pm

Re: i can not create testcases ! ISS 7.0 , PHP 5.2.17. MSSQ

Postby fman » Sat May 19, 2012 8:36 am

Please if you post on forum, then do not open issue on mantis at SAME TIME.
fman
Member of TestLink Community
 
Posts: 3063
Joined: Tue Nov 15, 2005 7:19 am

Re: i can not create testcases ! ISS 7.0 , PHP 5.2.17. MSSQ

Postby KianSS » Sat May 19, 2012 9:58 am

Sorry but i am really annoyed about the problem and cant fix it by my own
KianSS
TestLink user
 
Posts: 5
Joined: Fri May 18, 2012 6:40 pm

Re: i can not create testcases ! ISS 7.0 , PHP 5.2.17. MSSQ

Postby KianSS » Sat May 19, 2012 10:16 am

i installed Testlink over the normal Install Process ( localhost/install )

on IIS 7.5, MS SQL 2008 Express RC2 , PHP 5.2.17 with PEAR. i can login, logout, create a testplan, work with the userroles. "didnt made any changes in the Config File" , I can see all Gifs,Jpegs, all CSS files will loaded correctly , which means for me that the Folder Permission is working fine.

Installation works after i created a empty Database "called testlink" via SQL Management Studio.

all tables and inserts worked fine , after that.



my problem is still the same : i can create Testsuites but no testcases ( runnning to a timeout and takes more than 3 minutes )

after refreshing the Webserver, i can the the testcase in the tree, but the creating is stucking
i had a look to the events : there are no problems there.
KianSS
TestLink user
 
Posts: 5
Joined: Fri May 18, 2012 6:40 pm

Re: i can not create testcases ! ISS 7.0 , PHP 5.2.17. MSSQ

Postby KianSS » Sat May 19, 2012 10:17 am

Test Project 'MAMIS' - Test Plan 'MAMIS Testplan' was created
19/05/2012 13:07:22
admin
Test Project 'MAMIS' was created
19/05/2012 13:07:03
admin
Login for 'admin' from '::1' succeeded
Log level: WARNING (5 Items)
19/05/2012 13:10:19
admin
E_NOTICE Undefined index: type - in C:\inetpub\wwwroot\lib\functions\exttable.class.php - Line 244
19/05/2012 13:10:19
admin
E_NOTICE Undefined index: type - in C:\inetpub\wwwroot\lib\functions\exttable.class.php - Line 244
19/05/2012 13:10:19
admin
E_NOTICE Undefined index: type - in C:\inetpub\wwwroot\lib\functions\exttable.class.php - Line 244
19/05/2012 13:10:19
admin
E_NOTICE Undefined index: type - in C:\inetpub\wwwroot\lib\functions\exttable.class.php - Line 244
19/05/2012 13:07:04
admin
No project found: Assume a new installation and redirect to create it
KianSS
TestLink user
 
Posts: 5
Joined: Fri May 18, 2012 6:40 pm

Re: i can not create testcases ! ISS 7.0 , PHP 5.2.17. MSSQ

Postby fman » Sat May 19, 2012 1:03 pm

IMHO, beign annoyed is not a good reason to generate noise.
From it release date on 07/2011 we have had several issues on TL with MSSQL.
Some of these are related to missing columns on tables
Yesterday an user has giving you this hint through mantis,
then
1. so search on mantis to look for similar issues
2. compare MySQL create table script with MSSQL, in order to find other missing columns, before posting

>> Installation works after i created a empty Database "called testlink" via SQL Management Studio.
this is sign of problems, because installer is responsible of creating DB (when a user with right grants is provided)
fman
Member of TestLink Community
 
Posts: 3063
Joined: Tue Nov 15, 2005 7:19 am

Re: i can not create testcases ! ISS 7.0 , PHP 5.2.17. MSSQ

Postby KianSS » Mon May 21, 2012 3:26 pm

i added the following coloumn in my database : ALTER TABLE dbo.tcversions ADD status smallint NOT NULL CONSTRAINT DF_tcversions_status DEFAULT ((1))

than i push the create button for creating a testcase in a testsuite and it takes 2 minutes "to reach a timeout".

getting a HTTP Error 500.0 - Internal Server Error
FastCgiHandler
ExecuteRequestHandler
Requested URL :http://localhost:80/lib/testcases/tcEdit.php?containerID=9 [^]
Physical Path :C:\inetpub\wwwroot\lib\testcases\tcEdit.php


really strange behavior , because everything else like roles, testplan, project etc. is working pretty fine


Same Problem happens if I want to create

1. a Build under Test Execution.
2. Create ReQ
3. Click to Test Report


things which are working :

creating a Project
creating a testplan

Going to Events
Going to User Management and define userroles and order people to the roles.
Genrate Test Specs Documents
KianSS
TestLink user
 
Posts: 5
Joined: Fri May 18, 2012 6:40 pm

Re: i can not create testcases ! ISS 7.0 , PHP 5.2.17. MSSQ

Postby Billhelmke » Thu Jul 05, 2012 3:23 pm

Has anyone gotten testlink working with IIS7.5 MSSQL 2008 and PHP 5.3? If so can you please provide details, I feel like I take one step forward and two steps back.
Billhelmke
TestLink user
 
Posts: 7
Joined: Wed Jul 04, 2012 5:07 pm

Re: i can not create testcases ! ISS 7.0 , PHP 5.2.17. MSSQ

Postby fman » Thu Jul 05, 2012 7:55 pm

Hi, again with the risk to seems not polite:

unfortunatelly this a common pattern on forums: people start asking desperately for help, and when they got the answer ..., no time to share with others.

Please give a look to : http://mantis.testlink.org/view.php?id=5025#c16760 .
If issue persists, please create issue on mantis
fman
Member of TestLink Community
 
Posts: 3063
Joined: Tue Nov 15, 2005 7:19 am


Return to Installation and configuration



Who is online

Users browsing this forum: No registered users and 4 guests

cron