How to Build TestLink
Reference:
http://www.cnblogs.com/fnng/archive/2011/11/24/2262357.html
http://www.ossxp.com/doc/testlink/admin_guide/admin_guide.html#id7
http://www.diybl.com/course/7_databases/mysql/Mysqljs/20110813/558038.html
http://wiki.ubuntu.org.cn/MySQL安装指南
http://www.nhlcgz.com/blog/u/21/archives/2000/347.html (MySQL 忘记密码解决办法)
安装MySQL
sudo apt-get install mysql-server
密码少了不安全,多了会经常忘记。这不,把家里Ubuntu中mysql的root密码给忘记了,在网上兜了一圈,终于找到解决的办法。
1、先把mysql给停了
lin@ubuntu:~$ sudo /etc/init.d/mysql stop
2、估计是进入安全模式
sudo mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
3、登录mysql
输入mysql -u root mysql
4、修改密码,注意这里要用Password这个函数来设置密码。现在假设密码重置为123456。一开是我用set password='123456',始终登录不进去,后来才发现要加个函数,没详细了解这个password()函数,估计是md5吧。
mysql> update user set password=password('123456') where user='root';
mysql> flush privileges;
mysql> quit
5、一切顺利后,重启mysql
lin@ubuntu:~$ sudo /etc/init.d/mysql restart
终于把密码给搞定了。
TestLink LDAP 配置
/** LDAP authentication credentials */
$tlCfg->authentication['ldap_server'] = '';
$tlCfg->authentication['ldap_port'] = '3268';
$tlCfg->authentication['ldap_version'] = '3'; // could be '2' in some cases
$tlCfg->authentication['ldap_root_dn'] = '';
$tlCfg->authentication['ldap_organization'] = ''; // e.g. '(organizationname=*Traffic)'
$tlCfg->authentication['ldap_uid_field'] = 'sAMAccountName'; // Use 'sAMAccountName' for Active Directory
$tlCfg->authentication['ldap_bind_dn'] = ''; // Left empty for anonymous LDAP >
$tlCfg->authentication['ldap_bind_passwd'] = ''; // Left empty for anonymous LDAP binding
$tlCfg->authentication['ldap_tls'] = false; // true -> use tls
PS :在设置LDAP认证之后,直接登录会失败,需要用域名注册一下,(注册的时候不会要求输入密码),然后采用域名和域密码登录。
登录成功之后,进入mysql数据库修改用户权限
Then go into mysql (mysql -u root -p testlink) and make yourself an admin:
update users set role_id=8 where id=2;
Assuming that you are the first user you created (admin is id=1) (see the users table and the roles table for more information). Now go back and log into the web interface.