TL integration with Jira on Postgre DB

[norti]

I've configured the application according to TL-BTS-Howto manual. My configuration files look like below:

custom_config.inc.php file:

$g_interface_bugs='JIRA';

and cfg/jira.cfg.php file:

define('BUG_TRACK_DB_HOST', 'db-server');
define('BUG_TRACK_DB_NAME', 'jiradb');

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

define('BUG_TRACK_DB_USER', 'jirauser');
define('BUG_TRACK_DB_PASS', 'password%$%');

define('BUG_TRACK_DB_CHARSET',"windows-1250");


// I checked the two below options
//define('BUG_TRACK_HREF',"http://jiraserver:8080/jira/secure/Dashboard.jspa");
define('BUG_TRACK_HREF', "http://jiraserver:8080/jira/browse");


define('BUG_TRACK_ENTER_BUG_HREF',"http://jiraserver:8080/secure/CreateIssue!default.jspa");

When I open "http://localhost/testlink/" webpage I get the following message:

"Connection to your Bug Tracking System has failed:
Please check your configuration.
Be careful this problem will degrade TestLink performance."

Could you please tell me step by step on how to solve this problem ? Thanks in advance.

[davila]

It was useful for me to use a PHP script (v5.1.6) to test the connection from srvrA to srvrB (as other posts suggested) and the connection was successful with the script below. The error messages were helpful in figuring out what was up with the connection failure.

<?php
mssql_connect("$host", "$usr", "$pass") or die("unable to connect");
echo "Connected to MSSQL<br />";
?>

Are you able to connect through PHP; if not, you will not be able to connect using TL.