Having trouble with TL 1.8 RC5 and Jira 3.12 integration

1.8 related questions and discussions.
Please upgrade to LATEST 1.9.x.
No more fixes for 1.8.

Moderators: Amaradana, TurboPT, TL Developers

Having trouble with TL 1.8 RC5 and Jira 3.12 integration

Postby Merch » Thu Mar 19, 2009 7:37 pm

I have been unable to get TL 1.8 RC5 and Jira 3.12 intergrated successfully, please have a look at my configs and let me know what I am missing.

jira.cfg.php
Code: Select all
<?php
/**
* TestLink Open Source Project - http://testlink.sourceforge.net/
* $Id: jira.cfg.php,v 1.0 2005/10/25 17:40:56
*
*
* 20051229 - scs - added DEFINE for the DB-Type
*/

// Contributed by  jbarchibald@gmail.com

//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', '172.21.4.201');

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

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

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

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

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

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


I can connect to the Jira db successfully from the box that hosts TL:
Code: Select all
$ psql -h 172.21.4.201 -U dbuser -d jiradb --password
Password for user dbuser:
Welcome to psql 8.3.6 (server 8.2.4), the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

WARNING:  You are connected to a server with major version 8.2,
but your psql client is major version 8.3.  Some backslash commands,
such as \d, might not work properly.

jiradb=>


config_check shows the following
Code: Select all
Connection to your Bug Tracking System has failed:<br />
                                Please check your configuration.<br />
                                Be careful this problem will degrade TestLink performance.


Changing BUG_TRACK_DB_TYPE in the Jira config to 'psql' causes Testlink to fail to load (I'll grab the error message if someone thinks it is relevant.)

Any assistance would be greatly appreciated.

Thanks
-Merch
Merch
TestLink user
 
Posts: 8
Joined: Thu Mar 19, 2009 7:26 pm

Postby Merch » Wed Mar 25, 2009 10:04 pm

SOLVED:

The LAMP did not have the pgsql plugin installed.
Code: Select all
sudo apt-get install php5-pgsql
Merch
TestLink user
 
Posts: 8
Joined: Thu Mar 19, 2009 7:26 pm

Postby havlatm » Tue Mar 31, 2009 9:33 am

Thank for feedback about solution.
havlatm
Member of TestLink Community
 
Posts: 940
Joined: Mon Oct 31, 2005 1:24 am
Location: Czech


Return to TestLink 1.8 (OBSOLETE => EOL)[LOCKED]



Who is online

Users browsing this forum: No registered users and 2 guests