Quantcast

Problems on integration of CodeStriker and Bugzilla

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Problems on integration of CodeStriker and Bugzilla

Gary Yang

Hi,

There is a bug ID, 6401 in Bugzilla. However, I got errors when I create a topic in CodeStriker. Can someone tell me what are the possible reasons?

Error:
Bug ID 6401 does not exist.
For security reasons, please re-enter the file name to upload, if required.

codestriker.conf:

# Bug database connection details.
$bug_db = 'bugzilla';
$bug_db_host = 'sdcrevc04';
$bug_db_name = 'bugs';
$bug_db_password = 'bug4adm';
$bug_db_dbname = 'bugs';

$bugtracker = 'http://sdcrevc04.company.com:8080/bugzilla/show_bug.cgi?id=';

Thanks,


Gary



     

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Codestriker-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/codestriker-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problems on integration of CodeStriker and Bugzilla

David Sitsky
Administrator
Hi Gary,

For Bugzilla, the check for the existence of a specific bug just runs
the following query, and checks it is not equal to 0:

SELECT COUNT(*) FROM bugs WHERE bug_id = ?

Since you have already reached this part in the code, I would assume
that Codestriker has already connected to your Bugzilla database.  The
only thing I can think of is some obscure mysql permissions getting in
the way.

On the same machine that Codestriker runs from, try connecting to the
Bugzilla database using the mysql command-line tool to see if you can
run the query:

SELECT COUNT(*) FROM bugs WHERE bug_id = 6401

Hopefully that will show what the issue might be?

Cheers,
David

On Sat, May 2, 2009 at 10:36 AM, Gary Yang <[hidden email]> wrote:

>
> Hi,
>
> There is a bug ID, 6401 in Bugzilla. However, I got errors when I create a topic in CodeStriker. Can someone tell me what are the possible reasons?
>
> Error:
> Bug ID 6401 does not exist.
> For security reasons, please re-enter the file name to upload, if required.
>
> codestriker.conf:
>
> # Bug database connection details.
> $bug_db = 'bugzilla';
> $bug_db_host = 'sdcrevc04';
> $bug_db_name = 'bugs';
> $bug_db_password = 'bug4adm';
> $bug_db_dbname = 'bugs';
>
> $bugtracker = 'http://sdcrevc04.company.com:8080/bugzilla/show_bug.cgi?id=';
>
> Thanks,
>
>
> Gary
>
>
>
>
>
> ------------------------------------------------------------------------------
> Register Now & Save for Velocity, the Web Performance & Operations
> Conference from O'Reilly Media. Velocity features a full day of
> expert-led, hands-on workshops and two days of sessions from industry
> leaders in dedicated Performance & Operations tracks. Use code vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> Codestriker-user mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/codestriker-user
>

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Codestriker-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/codestriker-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problems on integration of CodeStriker and Bugzilla

Gary Yang
In reply to this post by Gary Yang

David,

I got the output below. But, I do not know what it means. Any idea?

mysql> SELECT COUNT(*) FROM bugs WHERE bug_id = 6401;
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.05 sec)


Thanks.


--- On Sun, 5/3/09, David Sitsky <[hidden email]> wrote:

> From: David Sitsky <[hidden email]>
> Subject: Re: [Codestriker-user] Problems on integration of CodeStriker and  Bugzilla
> To: "Gary Yang" <[hidden email]>
> Cc: [hidden email]
> Date: Sunday, May 3, 2009, 6:12 PM
> Hi Gary,
>
> For Bugzilla, the check for the existence of a specific bug
> just runs
> the following query, and checks it is not equal to 0:
>
> SELECT COUNT(*) FROM bugs WHERE bug_id = ?
>
> Since you have already reached this part in the code, I
> would assume
> that Codestriker has already connected to your Bugzilla
> database.  The
> only thing I can think of is some obscure mysql permissions
> getting in
> the way.
>
> On the same machine that Codestriker runs from, try
> connecting to the
> Bugzilla database using the mysql command-line tool to see
> if you can
> run the query:
>
> SELECT COUNT(*) FROM bugs WHERE bug_id = 6401
>
> Hopefully that will show what the issue might be?
>
> Cheers,
> David
>
> On Sat, May 2, 2009 at 10:36 AM, Gary Yang <[hidden email]>
> wrote:
> >
> > Hi,
> >
> > There is a bug ID, 6401 in Bugzilla. However, I got
> errors when I create a topic in CodeStriker. Can someone
> tell me what are the possible reasons?
> >
> > Error:
> > Bug ID 6401 does not exist.
> > For security reasons, please re-enter the file name to
> upload, if required.
> >
> > codestriker.conf:
> >
> > # Bug database connection details.
> > $bug_db = 'bugzilla';
> > $bug_db_host = 'sdcrevc04';
> > $bug_db_name = 'bugs';
> > $bug_db_password = 'bug4adm';
> > $bug_db_dbname = 'bugs';
> >
> > $bugtracker = 'http://sdcrevc04.company.com:8080/bugzilla/show_bug.cgi?id=';
> >
> > Thanks,
> >
> >
> > Gary
> >
> >
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > Register Now & Save for Velocity, the Web
> Performance & Operations
> > Conference from O'Reilly Media. Velocity features a
> full day of
> > expert-led, hands-on workshops and two days of
> sessions from industry
> > leaders in dedicated Performance & Operations
> tracks. Use code vel09scf
> > and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> > _______________________________________________
> > Codestriker-user mailing list
> > [hidden email]
> > https://lists.sourceforge.net/lists/listinfo/codestriker-user
> >
>


     

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Codestriker-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/codestriker-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problems on integration of CodeStriker and Bugzilla

Gary Yang
In reply to this post by Gary Yang


Here are more info:

mysql> SELECT COUNT(*) FROM bugs;
+----------+
| COUNT(*) |
+----------+
|     4372 |
+----------+
1 row in set (0.03 sec)


mysql> describe bugs;
+---------------------+--------------+------+-----+---------+----------------+
| Field               | Type         | Null | Key | Default | Extra          |
+---------------------+--------------+------+-----+---------+----------------+
| bug_id              | mediumint(9) | NO   | PRI | NULL    | auto_increment |
| assigned_to         | mediumint(9) | NO   | MUL | 0       |                |
| bug_file_loc        | text         | YES  |     | NULL    |                |
| bug_severity        | varchar(64)  | NO   | MUL | NULL    |                |
| bug_status          | varchar(64)  | NO   | MUL | NULL    |                |
| creation_ts         | datetime     | YES  | MUL | NULL    |                |
| delta_ts            | datetime     | NO   | MUL | NULL    |                |
| short_desc          | varchar(255) | NO   |     | NULL    |                |
| op_sys              | varchar(64)  | NO   | MUL | NULL    |                |
| priority            | varchar(64)  | NO   | MUL | NULL    |                |
| product_id          | smallint(6)  | NO   | MUL | 0       |                |
| rep_platform        | varchar(64)  | NO   |     | NULL    |                |
| reporter            | mediumint(9) | NO   | MUL | 0       |                |
| version             | varchar(64)  | NO   | MUL | NULL    |                |
| component_id        | smallint(6)  | NO   | MUL | 0       |                |
| resolution          | varchar(64)  | NO   | MUL | NULL    |                |
| target_milestone    | varchar(20)  | NO   | MUL | ---     |                |
| qa_contact          | mediumint(9) | YES  | MUL | NULL    |                |
| status_whiteboard   | mediumtext   | NO   |     | NULL    |                |
| votes               | mediumint(9) | NO   | MUL | 0       |                |
| keywords            | mediumtext   | NO   |     | NULL    |                |
| lastdiffed          | datetime     | YES  |     | NULL    |                |
| everconfirmed       | tinyint(4)   | NO   |     | 0       |                |
| reporter_accessible | tinyint(4)   | NO   |     | 1       |                |
| cclist_accessible   | tinyint(4)   | NO   |     | 1       |                |
| estimated_time      | decimal(5,2) | NO   |     | 0.00    |                |
| remaining_time      | decimal(5,2) | NO   |     | 0.00    |                |
| alias               | varchar(20)  | YES  | UNI | NULL    |                |
| deadline            | datetime     | YES  |     | NULL    |                |
| cf_reflib           | varchar(132) | NO   |     | ---     |                |
| cf_revision         | varchar(255) | YES  |     | NULL    |                |
| cf_version          | varchar(255) | YES  |     | NULL    |                |
+---------------------+--------------+------+-----+---------+----------------+
32 rows in set (0.99 sec)



--- On Mon, 5/4/09, Gary Yang <[hidden email]> wrote:

> From: Gary Yang <[hidden email]>
> Subject: Re: [Codestriker-user] Problems on integration of CodeStriker and Bugzilla
> To: "David Sitsky" <[hidden email]>
> Cc: [hidden email]
> Date: Monday, May 4, 2009, 2:54 PM
>
> David,
>
> I got the output below. But, I do not know what it means.
> Any idea?
>
> mysql> SELECT COUNT(*) FROM bugs WHERE bug_id = 6401;
> +----------+
> | COUNT(*) |
> +----------+
> |        0 |
> +----------+
> 1 row in set (0.05 sec)
>
>
> Thanks.
>
>
> --- On Sun, 5/3/09, David Sitsky <[hidden email]>
> wrote:
>
> > From: David Sitsky <[hidden email]>
> > Subject: Re: [Codestriker-user] Problems on
> integration of CodeStriker and  Bugzilla
> > To: "Gary Yang" <[hidden email]>
> > Cc: [hidden email]
> > Date: Sunday, May 3, 2009, 6:12 PM
> > Hi Gary,
> >
> > For Bugzilla, the check for the existence of a
> specific bug
> > just runs
> > the following query, and checks it is not equal to 0:
> >
> > SELECT COUNT(*) FROM bugs WHERE bug_id = ?
> >
> > Since you have already reached this part in the code,
> I
> > would assume
> > that Codestriker has already connected to your
> Bugzilla
> > database.  The
> > only thing I can think of is some obscure mysql
> permissions
> > getting in
> > the way.
> >
> > On the same machine that Codestriker runs from, try
> > connecting to the
> > Bugzilla database using the mysql command-line tool to
> see
> > if you can
> > run the query:
> >
> > SELECT COUNT(*) FROM bugs WHERE bug_id = 6401
> >
> > Hopefully that will show what the issue might be?
> >
> > Cheers,
> > David
> >
> > On Sat, May 2, 2009 at 10:36 AM, Gary Yang <[hidden email]>
> > wrote:
> > >
> > > Hi,
> > >
> > > There is a bug ID, 6401 in Bugzilla. However, I
> got
> > errors when I create a topic in CodeStriker. Can
> someone
> > tell me what are the possible reasons?
> > >
> > > Error:
> > > Bug ID 6401 does not exist.
> > > For security reasons, please re-enter the file
> name to
> > upload, if required.
> > >
> > > codestriker.conf:
> > >
> > > # Bug database connection details.
> > > $bug_db = 'bugzilla';
> > > $bug_db_host = 'sdcrevc04';
> > > $bug_db_name = 'bugs';
> > > $bug_db_password = 'bug4adm';
> > > $bug_db_dbname = 'bugs';
> > >
> > > $bugtracker = 'http://sdcrevc04.company.com:8080/bugzilla/show_bug.cgi?id=';
> > >
> > > Thanks,
> > >
> > >
> > > Gary
> > >
> > >
> > >
> > >
> > >
> > >
> >
> ------------------------------------------------------------------------------
> > > Register Now & Save for Velocity, the Web
> > Performance & Operations
> > > Conference from O'Reilly Media. Velocity features
> a
> > full day of
> > > expert-led, hands-on workshops and two days of
> > sessions from industry
> > > leaders in dedicated Performance &
> Operations
> > tracks. Use code vel09scf
> > > and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> > > _______________________________________________
> > > Codestriker-user mailing list
> > > [hidden email]
> > > https://lists.sourceforge.net/lists/listinfo/codestriker-user
> > >
> >
>
>
>      
>
> ------------------------------------------------------------------------------
> Register Now & Save for Velocity, the Web Performance
> & Operations
> Conference from O'Reilly Media. Velocity features a full
> day of
> expert-led, hands-on workshops and two days of sessions
> from industry
> leaders in dedicated Performance & Operations tracks.
> Use code vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> Codestriker-user mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/codestriker-user
>


     

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Codestriker-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/codestriker-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problems on integration of CodeStriker and Bugzilla

David Sitsky
Administrator
In reply to this post by Gary Yang
It means bug ID 6401 does not exist in that specific Bugzilla database
you have connected to (0 rows returned, instead of 1).  Is it possible
you have more than one Bugzilla instance, and you have connected to
the wrong one?  That is what seems to be happening.

Cheers,
David

On Tue, May 5, 2009 at 7:54 AM, Gary Yang <[hidden email]> wrote:

>
> David,
>
> I got the output below. But, I do not know what it means. Any idea?
>
> mysql> SELECT COUNT(*) FROM bugs WHERE bug_id = 6401;
> +----------+
> | COUNT(*) |
> +----------+
> |        0 |
> +----------+
> 1 row in set (0.05 sec)
>
>
> Thanks.
>
>
> --- On Sun, 5/3/09, David Sitsky <[hidden email]> wrote:
>
>> From: David Sitsky <[hidden email]>
>> Subject: Re: [Codestriker-user] Problems on integration of CodeStriker and  Bugzilla
>> To: "Gary Yang" <[hidden email]>
>> Cc: [hidden email]
>> Date: Sunday, May 3, 2009, 6:12 PM
>> Hi Gary,
>>
>> For Bugzilla, the check for the existence of a specific bug
>> just runs
>> the following query, and checks it is not equal to 0:
>>
>> SELECT COUNT(*) FROM bugs WHERE bug_id = ?
>>
>> Since you have already reached this part in the code, I
>> would assume
>> that Codestriker has already connected to your Bugzilla
>> database.  The
>> only thing I can think of is some obscure mysql permissions
>> getting in
>> the way.
>>
>> On the same machine that Codestriker runs from, try
>> connecting to the
>> Bugzilla database using the mysql command-line tool to see
>> if you can
>> run the query:
>>
>> SELECT COUNT(*) FROM bugs WHERE bug_id = 6401
>>
>> Hopefully that will show what the issue might be?
>>
>> Cheers,
>> David
>>
>> On Sat, May 2, 2009 at 10:36 AM, Gary Yang <[hidden email]>
>> wrote:
>> >
>> > Hi,
>> >
>> > There is a bug ID, 6401 in Bugzilla. However, I got
>> errors when I create a topic in CodeStriker. Can someone
>> tell me what are the possible reasons?
>> >
>> > Error:
>> > Bug ID 6401 does not exist.
>> > For security reasons, please re-enter the file name to
>> upload, if required.
>> >
>> > codestriker.conf:
>> >
>> > # Bug database connection details.
>> > $bug_db = 'bugzilla';
>> > $bug_db_host = 'sdcrevc04';
>> > $bug_db_name = 'bugs';
>> > $bug_db_password = 'bug4adm';
>> > $bug_db_dbname = 'bugs';
>> >
>> > $bugtracker = 'http://sdcrevc04.company.com:8080/bugzilla/show_bug.cgi?id=';
>> >
>> > Thanks,
>> >
>> >
>> > Gary
>> >
>> >
>> >
>> >
>> >
>> >
>> ------------------------------------------------------------------------------
>> > Register Now & Save for Velocity, the Web
>> Performance & Operations
>> > Conference from O'Reilly Media. Velocity features a
>> full day of
>> > expert-led, hands-on workshops and two days of
>> sessions from industry
>> > leaders in dedicated Performance & Operations
>> tracks. Use code vel09scf
>> > and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
>> > _______________________________________________
>> > Codestriker-user mailing list
>> > [hidden email]
>> > https://lists.sourceforge.net/lists/listinfo/codestriker-user
>> >
>>
>
>
>
>

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Codestriker-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/codestriker-user
Loading...