637595 - After installed Bugzilla and Testopia, cannot create or display a Test Plan.

Status: RESOLVED INVALID

(Testopia :: Test Plans, defect, P1)

Description

[Naoya Suzuki]

User-Agent:       Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
Build Identifier: Testopia-2.4, Bugzilla-3.6.2, Ubuntu Server.  Client: IE8 and Firefox.

First installed Bugzilla-3.6.4 and Testpia-2.4 using patch-3.6.2 (there was no 3.6.4), got this problem. 

When click the New Plan, no form appears to create a plan. When click My Plan get an error message.

So I thought I should use Bugzilla 3.6.2. Dropped all tables and keys and install 3.6.2 and still getting similar problem.

There is no New Plan to click (when called tr_new_plan.cgi manually, it said "You do not have sufficient rights to create new Test Plans).
When click the My Plan get an error:- 

DBD::mysql::db selectcol_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND test_plan_permissions.permissions > 0 AND test_plan_permissions.userid = 2' at line 1 [for Statement "SELECT DISTINCT test_plans.plan_id FROM test_plans  INNER JOIN test_plan_permissions ON (test_plans.plan_id = test_plan_permissions.plan_id) WHERE plan_id in () AND test_plan_permissions.permissions > 0 AND test_plan_permissions.userid = 2 AND test_plans.isactive = 1 AND 1 = 1"] at /loader/0xaa73178/Bugzilla/Extension/Testopia/Table.pm line 118
	Bugzilla::Extension::Testopia::Table::init('Bugzilla::Extension::Testopia::Table=HASH(0xb3494f8)', 'plan', 'tr_list_plans.cgi', 'Bugzilla::CGI=HASH(0xae9d5d8)', undef, 'SELECT DISTINCT test_plans.plan_id FROM test_plans  INNER JOI...') called at /loader/0xaa73178/Bugzilla/Extension/Testopia/Table.pm line 88
	Bugzilla::Extension::Testopia::Table::new('Bugzilla::Extension::Testopia::Table', 'plan', 'tr_list_plans.cgi', 'Bugzilla::CGI=HASH(0xae9d5d8)', undef, 'SELECT DISTINCT test_plans.plan_id FROM test_plans  INNER JOI...') called at /usr/lib/cgi-bin/bugzilla3/tr_list_plans.cgi line 89


Currently cannot create a plan.
Can I create a plan manually?  It might go a little foreward at least.
 

Reproducible: Always

Steps to Reproduce:
1.Install Ubuntu Server
2.Setup MTA, apach2 and mysql.
3.Install bugzilla-3.6.2 or 3.6.4, then install Testopia-2.4.
4.Go to home page and login as admin.

Actual Results:  
No "New Plan" to create a plan. 
When click My Plan gets an error.

Expected Results:  
I should be able to create a plan.
I should be able to see my plan, if there.  If not, nothing.
Once a plan been created, I should be able add Cases and Runs.


Gave me an error message or no response.

Comment 1

[Naoya Suzuki]

Since then I have tried various things and found out the following:-

1. No "New Plan" nor "My Plan" was fixed by setting Group Access.  Now I can see the "New Plan" and "My Plan".

2. When IE8 option "Display anotification about every script error" turned on, it said "YAHOO" is undefined. index.cgi Line 79 also Line 204, 278, 401.
When clicked Product Dushboard, "YAHOO" is undefined. tr_show_product.cgi, Line 88.  And "Testopia" is undefined. Line 238.  

I guess this means that javascript is not working or not sent. I also noticed css is not working or not sent.

So I looked at the error.log of apache2 and found out the folloing:-

A. Files with .js and .css got the Permission denied: exec of ... and Premature end of script headers.  apach2 was trying to execute these files in server instead of sending it to client.

Original setup was a symbolic link of bugzilla to /usr/lib/cgi-bin/ where apache2 /cgi-bin/.  It appeares that all files in cgi-bin, apache2 tries to execute them, even I set ForceType text/css and text/javascript.
I also tried to set bugzilla directory in /var/www as a symboic link.  But all .cgi files are displayed as text file, not executed.  I could not make apache2 to work with bugzilla yet.  It seems this apache2 is different from one I know and I could not make it work for bugzilla.
Does anyone know what to do for this?

apache2 -v said:-
Server Version: Apache/2.2.11 (Ubuntu)
Server built:   Aug 16 2010 17:47:23

uname -a said:-
Linux bzsvr 2.6.28-11-server #42-Ubuntu SMP Fri Apr 17 02:48:10 UTC 2009 i686 GNU/Linux

Any help?

Comment 2

[Naoya Suzuki]

No one really had looked at this problem.
But I found out a problem.
It seems that the problem is exec bit of files to execute and also because of that I placed the bugzilla directory in cgi-bin directory and in the cgi-bin directory, things just go wrong.

So what I did was set all cgi files 755 and placed bugzilla directory in www's home directory and then suddenly all working like magic.
I thought I changed 755 before, but somehow they were back to 710 and not working with this.  

Now they are all working except errors from js including extjs.
These problem will be reported as a different problem.