Testlink安装使用

Testlink安装记录:
Dennis 2012-3-19

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
系统/软件环境:
centos 5.5
php 5.2
apache 2.2.3
mysql   5.1.58

[root@NanjingBaseServer www]# lsb_release -a
LSB Version:    :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: CentOS
Description:    CentOS release 5.5 (Final)
Release:        5.5
Codename:       Final
[root@NanjingBaseServer www]# mysql --version
mysql  Ver 14.14 Distrib 5.1.58, for redhat-linux-gnu (i686) using readline 5.1
[root@NanjingBaseServer www]# php --version
PHP 5.2.17 (cli) (built: Aug 31 2011 17:06:47)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies
[root@NanjingBaseServer www]# whereis apachectl
apachectl: /usr/sbin/apachectl /usr/share/man/man8/apachectl.8.gz
[root@NanjingBaseServer www]# /usr/sbin/apachectl -v
Server version: Apache/2.2.3
Server built:   Oct 20 2011 17:00:12
[root@NanjingBaseServer www]#

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
下载:
http://sourceforge.net/projects/testlink/
安装:(在/var/www/中解压)

[root@NanjingBaseServer www]tar zxvf testlink-1.9.3.tar.gz
[root@NanjingBaseServer www]mv testlink-1.9.3 testlink

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
使用myql 创建操作testlink的账号和密码:
mysql 创建数据库testlink用户名密码

mysql > grant select,insert,update,delete on testlink.* to testlink@localhost identified by "mypassword"; 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
网页安装:
http://192.168.1.28/testlink
设置数据库账号密码(账号root,密码默认情况为空)
设置操作testlink数据库的账号和密码(账号为testlink，密码为mypassword)

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
安装错误:
TestLink setup will now attempt to setup the database:

Creating connection to Database Server:OK!

Connecting to database `testlink`:OK!
Creating Testlink DB user `testlink`:OK! (ok - user_exists ok - grant assignment) 
Processing:sql/mysql/testlink_create_tables.sql
OK!
Writing configuration file:Failed!

TestLink couldn't write the config file. Please copy the following into the ../config_db.inc.php file:
<?php
// Automatically Generated by TestLink Installer
define('DB_TYPE', 'mysql');
define('DB_USER', 'testlink');
define('DB_PASS', 'mypassword');
define('DB_HOST', 'localhost');
define('DB_NAME', 'testlink');
define('DB_TABLE_PREFIX', '');
?>

Once that's been done, you can log into TestLink by pointing your browser at your TestLink site.

解决方式:
在testlink目录中创建config_db.inc.php文件，并拷贝php的代码即可

[root@NanjingBaseServer testlink]$ vim config.inc.php
[root@NanjingBaseServer testlink]$ touch config_db.inc.php; vim config_db.inc.php

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
登陆:
http://192.168.1.28/testlink
默认登陆账号密码都是admin

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
警告信息:
你需要注意一些安全警告. 查看详细信息在文件: /var/www/testlink/logs/config_check.txt. 
要禁用警告输出，设置 $tlCfg->config_check_warning_mode = 'SILENT';

[root@NanjingBaseServer testlink]# vim config.inc.php

修改
$tlCfg->config_check_warning_mode = 'FILE'; 
为
$tlCfg->config_check_warning_mode = 'SILENT';

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
修改页面显示语言:
登陆后进入个人账号修改语言选择即可

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
配置SMTP:

[root@NanjingBaseServer testlink]# vim config.inc.php

// ----------------------------------------------------------------------------
/* [SMTP] */


/**
* @var string SMTP server name or IP address ("localhost" should work in the most cases)
* Configure using custom_config.inc.php
* @uses lib/functions/email_api.php
*/
$g_smtp_host        = 'mytest.com.cn';  # SMTP server MUST BE configured


# Configure using custom_config.inc.php
$g_tl_admin_email     = 'testlink@mytest.com.cn'; # for problem/error notification
$g_from_email         = 'testlink@mytest.com.cn';  # email sender
$g_return_path_email  = 'testlink@mytest.com.cn';


/**
* Email notification priority (low by default)
* Urgent = 1, Not Urgent = 5, Disable = 0
**/
$g_mail_priority = 5;


/**
* Taken from mantis for phpmailer config
* select the method to mail by:
* PHPMAILER_METHOD_MAIL - mail()
* PHPMAILER_METHOD_SENDMAIL - sendmail
* PHPMAILER_METHOD_SMTP - SMTP
*/
$g_phpMailer_method = PHPMAILER_METHOD_SMTP;


/** Configure only if SMTP server requires authentication */
$g_smtp_username    = 'testlink@mytest.com.cn';  # user
$g_smtp_password    = 'testlink_psw';  # password

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
删除用户:
网页无法删除账号
进入mysql删除:

[root@NanjingBaseServer testlink]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 106
Server version: 5.1.58 MySQL Community Server (GPL) by Utter Ramblings


Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mantisbt           |
| mysql              |
| test               |
| testlink           |
+--------------------+
5 rows in set (0.03 sec)

mysql> use testlink;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select * from users;
+----+---------+----------------------------------+---------+
| id | login   | password                         | role_id |
+----+---------+----------------------------------+---------+
|  1 | admin   | 21232f297a57a5a743894a0e4a801fc3 |       8 |
|  2 | test123 | e10adc3949ba59abbe56e057f20f883e |       5 |
+----+---------+----------------------------------+---------+
4 rows in set (0.00 sec)

mysql> delete from users where login='test123';
Query OK, 1 row affected (0.00 sec)

mysql> select * from users;
+----+-------+----------------------------------+---------+
| id | login | password                         | role_id | 
+----+-------+----------------------------------+---------+
|  1 | admin | 21232f297a57a5a743894a0e4a801fc3 |       8 |
+----+-------+----------------------------------+---------+
1 row in set (0.00 sec)

mysql>