51Testing软件测试论坛

标题: TestLink1.9.16整合Bugfree2.1的问题 [打印本页]

作者: 轻歌越野 时间: 2018-12-11 11:18
标题: TestLink1.9.16整合Bugfree2.1的问题
管理员身份登入testlink的主页，【Issue Tracker Management】-bugzilla(Interface:db)配置：


<issuetracker>
<dbhost>localhost</dbhost>
<dbname>bugfree2</dbname>
<dbschema>bugfree2</dbschema>
<dbtype>mysql</dbtype>
<dbuser>root</dbuser>
<dbpassword>admin</dbpassword>
<uricreate>http://192.168.137.47:81/bugfree</uricreate>
<uriview>http://192.168.137.47:81/bugfree/show_bug.cgi?id=</uriview>

该配置完成后，也在测试项目里绑定了 Issue Tracker
[attach]119962[/attach]

结果，测试执行时页面报错：

Attention Please:

Something is preventing connection to Bug Tracking System,

and is going to create performance issues.

Please contact your TestLink Administrator

完全没有头绪，求助

作者: 轻歌越野 时间: 2018-12-13 15:27
补充环境说明：
1.TestLink1.9.16环境（XAMPP5.6.38+TestLink1.9.16）：http://192.168.137.49:8099/testlink
2.Bugfree2.1环境(XAMPP1.6.8+Bugfree2.1)：http://192.168.137.47:81/bugfree/

问题排查：
查看/opt/lampp/htdocs/testlink/logs/userlog1.log发现：

mysqli_real_connect(): (HY000/1049): Unknown database 'bugfree2'
- in /opt/lampp/htdocs/testlink/third_party/adodb/drivers/adodb-mysqli.inc.php - Line 124
[18/Dec/12 01:43:24][ERROR][9vup27eep18rruinnhdum6qi75][GUI - Test Project ID : 1]
Connect to Bug Tracker database fails: (interface: - Host:->dbhost - DBName: ->dbname - User: ->dbuser) 1049 - Unknown database 'bugfree2'

于是在192.168.137.47的数据库上查看了防火墙设置，并授权给192.168.137.49数据库访问权限

也启用了3306端口监听

在192.168.137.49上telnet 192.168.137.47 3306成功
Trying 192.168.137.47...
Connected to 192.168.137.47.
Escape character is '^]'.
4
5.0.67R6ZAwV)eD,dK+4ao*}\3)sConnection closed by foreign host.

但是49访问47的mysql还是失败
root@de-47:/# /opt/lampp/bin/mysql -u root -p -h 192.168.137.49
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.137.49' (111)

欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)