Page 1 of 1

Having trouble with TL 1.8 RC5 and Jira 3.12 integration

PostPosted: Thu Mar 19, 2009 7:37 pm
by Merch
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

PostPosted: Wed Mar 25, 2009 10:04 pm
by Merch
SOLVED:

The LAMP did not have the pgsql plugin installed.
Code: Select all
sudo apt-get install php5-pgsql

PostPosted: Tue Mar 31, 2009 9:33 am
by havlatm
Thank for feedback about solution.