TESTLINK 1.9 integration with JIRA 4.1

[KORSA]

Hello

I installed Testlinink and i want configuire integration with jira.

i set up config.inc.php File


1. with JIRASOAP integration:

Code: Select all

$g_interface_bugs = 'JIRASOAP';

and

jirasoap.cfg.php

Code: Select all

//Set the bug tracking system Interface to JIRA 3.11.1 (tested with this version)
//-----------------------------------------------------------------------------------------
/* The following parameters are not in use. */
define('BUG_TRACK_DB_TYPE', '[Not in Use]');
define('BUG_TRACK_DB_NAME', '[Not in Use]');
define('BUG_TRACK_DB_CHARSET', '[Not in Use]');
define('BUG_TRACK_DB_USER', '[Not in Use]');
define('BUG_TRACK_DB_PASS', '[Not in Use]');
//-----------------------------------------------------------------------------------------

/** The Username being used by JIRA logon */
define('BUG_TRACK_USERNAME', 'Domain\User');

/** The Password being used by JIRA logon*/
define('BUG_TRACK_PASSWORD', 'Password');
/** link of the web server for JIRA*/
define('BUG_TRACK_HREF',"http://localhost:8080/");
/** path of JIRA WSDL */
define('BUG_TRACK_SOAP_HREF', "rpc/soap/jirasoapservice-v2?wsdl");

/** link of the web server for jira ticket*/
define('BUG_TRACK_SHOW_BUG_HREF', "browse/");
/** link of the web server for creating new jira ticket*/
define('BUG_TRACK_ENTER_BUG_HREF',"secure/Dashboard.jspa?os_destination=%2Fsecure%2FCreateIssue%21default.jspa");

and got this ERROR

Fatal error: require_once() [function.require]: Failed opening required 'soapclient.class.php' (include_path='.;C:\php5\pear;.;C:\AppServ\www\testlink\lib\functions\;C:\AppServ\www\testlink\third_party\') in C:\AppServ\www\testlink\lib\functions\common.php on line 100

2. with JIRA integration

Code: Select all

$g_interface_bugs = 'JIRA';

Code: Select all

//Set the bug tracking system Interface to JIRA 3.1.1
/** The DB host to use when connecting to the JIRA db */
define('BUG_TRACK_DB_HOST', 'SERVER\INSTANCE');
/** The DB type to use for connecting to the bugtracking db */
define('BUG_TRACK_DB_TYPE', 'MSSERVER');

/** The name of the database that contains the jira tables */
define('BUG_TRACK_DB_NAME', 'jira');

/** The DB type being used by jira */
define('BUG_TRACK_DB_USER', 'jirauser');

/** The DB password to use for connecting to the jira db */
define('BUG_TRACK_DB_PASS', 'jirapassword');

/** link of the web server for jira */
// define('BUG_TRACK_HREF', "http://localhost:8080/secure/Dashboard.jspa"); 
define('BUG_TRACK_HREF', "http://localhost:8080/browse/"); 



/** link to the bugtracking system, for entering new bugs */
define('BUG_TRACK_ENTER_BUG_HREF',"http://localhost:8080/browse/");

and got this ERROR

Fatal error: require_once() [function.require]: Failed opening required 'ADODB_msserver.class.php' (include_path='.;C:\php5\pear;.;C:\AppServ\www\testlink\lib\functions\;C:\AppServ\www\testlink\third_party\') in C:\AppServ\www\testlink\lib\functions\common.php on line 100

Any ideas, where do i have misconfiguration ?

[fman]

1, please search other post regarding JIRA
2. dbtype MSSERVER -> this does not seems OK that's why ADODB COMPLAINS

[amkhullar]

Please check if you have soap installed in php and i think same thing goes for the DB Drivers for PHP , check both.

I use Mysql / Jira 4.1 ( Soap) with My Testlink and have the following modules enabled in my PHP install.

( [0] => date [1] => libxml [2] => openssl [3] => pcre [4] => zlib [5] => ctype [6] => curl [7] => dba [8] => dom [9] => filter [10] => gd [11] => gettext [12] => hash [13] => iconv [14] => json [15] => ldap [16] => mysql [17] => SimpleXML [18] => SPL [19] => PDO [20] => posix [21] => Reflection [22] => session [23] => pdo_sqlite [24] => soap [25] => SQLite [26] => standard [27] => tokenizer [28] => xml [29] => xmlreader [30] => xmlrpc [31] => xmlwriter [32] => apache2handler )

[jack090]

Since your using MSSQL you need to go edit your \lib\bugtracking\int_jira.php and anywhere there are "selects" use something like this: "SELECT issuestatus FROM dbo.jiraissue". I've noticed that adding dbo to jiraissue and the other tables seems to fix the problem using higher versions of MSSQL.

[amkhullar]

I would not recommend this approach, best would be to enable the API's on JIRA and then use the JIRASOAP Plugin to connect to JIRA rather than fiddling with the db statements.

[jack090]

I would not recommend this approach, best would be to enable the API's on JIRA and then use the JIRASOAP Plugin to connect to JIRA rather than fiddling with the db statements.

Understandably but the sql statements don't work correctly on MSSQL 2008 & 2008 R2. If you keep a file (which everyone should) of any edits you make it takes about 2 minutes to fix your .php file.