TL & JIRA (mysql) connection problems

[eds219]

We're in the process of implementing TL at our company and have it installed on a linux (centOS) box. However, hitting a roadblock when trying to link to our JIRA db (mysql). I've edited jira.cfg.php and enabled Jira BTS in custom_config.inc.php but still getting the message "Connection to your Bug Tracking System has failed:Please check your configuration." at the login page." I am able to connect to the JIRA db via SQL command line using the same information that was entered in the config file. I've tried enabling debug mode, but the logs make no mention of a connection failure or where the problem might lie. Looking for any help, as we are very excited to start using TL. Thanks.

[fman]

you need to use a PHP program test to test your connection to JIRA
using other SQL tool is not a good test

[eds219]

Thanks for the reply. The reason I tried the mysql tool is to verify the "path" from the 2 boxes, and that the Jira box isn't refusing the connection. So, at your suggestion I tried a small PHP test page just to test if the attempt is even being made, and using tcpdump/wireshark, I don't even see an attempt. The message on the page is:

"Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '172.20.2.250' (13) in /var/www/html/testphp.php on line 4
DB connection failed: Can't connect to MySQL server on '172.20.2.250' (13)"

Any/all advice is appreciated...

[havlatm]

Check if your server is not under firewall. Try ping the MySQL port ... or ask your network admin to look at.

[eds219]

I had the network admin take a look, and he verified that the server is not firewalled. I am also able to both ping and telnet successfully through the MySQL port from the Testlink server to the Jira server. Could this possibly be a permission problem on the Testlink server itself of some sort? If so, can someone point me in the direction of what I should check?

[eds219]

...OR, could it possibly be that the server is missing something for mySQL and/or PHP?

[havlatm]

I've checked www. It seems like DB permission problem. Check if your DB user is defined as local only. I guess that he cannot access the database from TL server.
It should not be a problem of php.

[eds219]

I too came across that, so I verified the mysql user list on the Jira server which appeared fine, in fact, I'm able to login to the Jira DB from the mysql command line of my TestLink server. So, it is accepting the username/pw from the TL server (not local). Can you tell me where/how is TL initiating the connection? I've looked, but I can't quite figure it out.

[havlatm]

Check lib/bugtracking/int_bugtracking.php
function connect()