[SOLVED] Integration TestLink Mantis Problem

[Shuhaimie]

Hi,

I'm confusing what is the error. Can anybody guide me how to solve this problem?
Already installed the testlink 1.9.5, mantis 1.2.12, mysql workbench 5.2.
Both testlink and mantis can function as it is.
But when I try to integrate, I get an error.
I follow the steps in http://www.teamst.org/_tldoc/1.7/tl-bts-howto.pdf for integration.
Some said, there is bug tracker management button on the testlink page, but mine dont have.

Here is the error on top of the page:

Attention Please:
Something is preventing connection to Bug Tracking System,
and is going to create performance issues.
Please contact your TestLink Administrator

Regards,
Shuhaimie

[SThayalan]

We are planning to use the mantis hosted on a different server integrated to Testlink. I'm using Testlink 1.9.5

when using Mantis (interface:db) with the following configuration connection was successful.

<issuetracker>
<dbhost>localhost</dbhost>
<dbname>bugtracker</dbname>
<dbtype>mysql</dbtype>
<dbuser>mantis</dbuser>
<dbpassword>mantis</dbpassword>
<uriview>http://localhost:80/mantis/view.php?id=</uriview>
<uricreate>http://localhost:80/mantis/</uricreate>

However if I replace the localhost with the hostname 'XYLAPTOP123' it throws an error. From the event log I'm getting the following error. Please let me know whats really preventing us here.

Connect to Bug Tracker database fails: (interface: - Host: ->dbhost - DBName: ->dbname - User: ->dbuser) 0 -

E_WARNING mysql_connect(): Host 'xylaptop123.ca.local' is not allowed to connect to this MySQL server - in C:\xampp\htdocs\testlink195\third_party\adodb\drivers\adodb-mysql.inc.php - Line 365

[fman]

you have a config issue with MySQL Security => you need to check MySQL sites

E_WARNING mysql_connect(): Host 'xylaptop123.ca.local' is not allowed to connect to this MySQL server - in C:\xampp\htdocs\testlink195\third_party\adodb\drivers\adodb-mysql.inc.php - Line 365

[SThayalan]

Thanks fman. I was able to integrate successfully after grant required permission to the Mantis db.

GRANT ALL ON <database name>.* TO <user>@'%.domain.com ' IDENTIFIED BY '<new password>';
FLUSH PRIVILEGES;

[hiseju]

Hi SThayalan,

I am facing similar issue. Unable to integrate TestLink 1.9.5 hosted on one server and Mantis on another server. The two servers are not in same network. Tried to follow your steps by executing:

GRANT ALL ON <database name>.* TO shahs@'% ' IDENTIFIED BY '<new password>';
FLUSH PRIVILEGES;

"shahs" is the user that logs in to TestLink and tries to integrate a test case with an issue. But my issue is not resolved. Can you please let me know where am i going wrong.

[GunnarD]

Check so that there is no firewall thats blocks trafik and that mysql is listen on external interface not only localhost.

You can try the following command:

mysql -h "mysqlservern" -u username -p