TestLink 1.7 + (Jira+Oracle)

[lgustavo_sjc]

Hello all,

I need configuration the TestLink1.7 with Jira+Oracle10G.
My web site for TestLink is http://172.16.0.21:88/apache2-default/t ... /login.php
My Jira work in another server: http://172.16.2.21:8081 using Oracle10G:
IP: 172.16.7.203
SID: ORACLE10G
User: JIRA_DEVEL
Pass: jiradevel

On file config.inc.php i alter the variable $g_interface_bugs= to 'JIRA',
and on file cfg/jira.cfg.php is config as below:


//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', 'ORACLE10G_172.16.7.203');

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

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

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

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

/** The DB type to use for connecting to the bugtracking db */
define('BUG_TRACK_DB_TYPE', 'oracle');

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


What I did mistake?

Tks,
Luis Gustavo from Brazil

[fman]

Scuse me but I'm not able to find, problem description on your post.
Anyway:

I've no way to test JIRA on Oracle

[havlatm]

I guess
define('BUG_TRACK_DB_HOST', 'ORACLE10G_172.16.7.203');
could be
define('BUG_TRACK_DB_HOST', '172.16.7.203');

[dmccoole]

We just recently went with TestLink and have 5 QA engineers converting all our Test Plans and Test Cases into it. So far so good!

I'm trying to link it with JIRA which we have set to an oracle back-end. I've set the cfg/jira.cfg.php accordingly. I'm getting the White blank page when I turn the integration on via: $g_interface_bugs='JIRA';

I've set TestLink logging to DEBUG but it is not showing any errors.

System is an XP running IIS. I don't see any IIS error messages. Anything in particular to look for?

Has anyone successfully integrated TestLink with JIRA with an Oracle backend?

Thanks!

-Dan

[kmielke]

Sorry, we are using Testlink and Jira with MySQL.

But the following entries should be DB independent.

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

/** link to the bugtracking system, for entering new bugs */
define('BUG_TRACK_ENTER_BUG_HREF',"https://<jiraserver>/secure/CreateIssue!default.jspa");

Just give it a try.

Regards
Kester

[dmccoole]

I'm not using https, but the links are very similar. These are my settings.

define('BUG_TRACK_DB_HOST', '172.16.1.38');
define('BUG_TRACK_DB_NAME', 'dev');
define('BUG_TRACK_DB_USER', 'jiraowner');
define('BUG_TRACK_DB_PASS', 'jiraowner');
define('BUG_TRACK_HREF', "http://joplin:8080/browse/");
define('BUG_TRACK_DB_TYPE', 'oracle');
define('BUG_TRACK_ENTER_BUG_HREF',"http://joplin:8080/secure/CreateIssue!default.jspa");

I still get the blank White page when I turn on the JIRA setting. I get this with Firefox and IE. No error messages.

Does anyone know of any other logging that can be turned on? Or add some logging statements in the PHP code that might help?

Thanks!

[fman]

please explain better, give detailed step by step procedure to reproduce error

[dmccoole]

Hi fman,

TestLink setup on Server 2003, with IIS and MS-SQL. That all runs great!

I modified the cfg/jira.cfg.php as described above to set the JIRA settings. JIRA is running on another system with an Oracle backend.

I then added "$g_interface_bugs='JIRA';" to custom_config.inc.php

I then used Firefox or IE to go to my TestLink site: http://qafileserver/testlink/login.php

And I get a blank white page. When I view source, it's blank as well.
I'm not seeing any error messages in the log path: gui\templates_c

If there is anything else I can provide, let me know. Thanks!

[dmccoole]

We have a test system that we installed TestLink on running with Apache. Trying to eliminate IIS. I did the same steps above and I am still getting the Blank page on FireFox. On IE, I'm getting a HTTP 500 Internal Server error. No logs get created in the TestLink gui\templates_c folder. When I set JIRA back to NO, and try to connect to website, I then get a log file, userlog0.log, which is just the basic connection DEBUG info for that attempt. I'm not seeing any errors in the Apache log files.

Anything else I can try?

[pfclaes]

if you are interracting with an oracle db, you must fisrt install a client.
The next step is then to define which driver you will use (see ADOdb site), in most cases the driver will be adodb-oci8.inc.php (for oracle version greater or equal than . So you have to put this line in jira.cfg.php

/** The DB type to use for connecting to the bugtracking db */
define('BUG_TRACK_DB_TYPE', 'oci8');

Hoping it works for you.

See you soon.

[fman]

Thanks, I will try yo add some new checks

[czerwonka]

Hi fman,

TestLink setup on Server 2003, with IIS and MS-SQL. That all runs great!

I modified the cfg/jira.cfg.php as described above to set the JIRA settings. JIRA is running on another system with an Oracle backend.

I then added "$g_interface_bugs='JIRA';" to custom_config.inc.php

I then used Firefox or IE to go to my TestLink site: http://qafileserver/testlink/login.php

And I get a blank white page. When I view source, it's blank as well.
I'm not seeing any error messages in the log path: gui\templates_c

If there is anything else I can provide, let me know. Thanks!

We're having the same problem here. I just won't work with MSSQL.

[ameer09]

Dear Luis Gustavo, you got any solution for this issue? I am having the issue in my environment.

[0_o]

I have the same problem with MSSQL database. Are there any solutions that work?