Centos6上安装TestLink遇到的问题

Centos6上安装TestLink遇到的问题

===== 永久关闭防火墙 =====

chkconfig iptables off ===== 问题一：Security问题导致安装不继续 =====

按照[[知识库:testlink集合-_centos部署testlink|TestLink的安装说明]]说明，安装第三个步骤遇到如下问题：

{ {:知识库:2019-03-19_17-42-59_的屏幕截图.png|}}

==== 尝试解决方法： ====

给documentroot目录赋予权限

chmod -R 777 documentroot

然后根据security说明，创建以下目录，并赋权

#tar -zxvf testlink-1.9.14.tar.gz #mkdir /var/testlink/logs #mkdir /var/testlink/upload_area #chmod 777 /var/testlink/logs

=====问题二：Php-MySQL安装问题 =====

设置完数据库之后，发现如下问题：

{ {:知识库:2019-03-19_18-13-40_的屏幕截图.png|}}

==== 尝试解决办法 ====

yum search php

找到对应版本的mysql插件：

比如本台server安装的是php7.0，那么我们找到如下插件，并安装

yum install php70w-mysql.x86_64

问题解决

===== 问题三：数据库授权问题 =====

{ {:知识库:2019-03-19_18-49-52_的屏幕截图.png|}}

==== 尝试解决办法 ====

[root@testlink ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.15 MySQL Community Server - GPL

Copyright © 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;
Query OK, 0 rows affected (0.18 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)

问题解决

{ {:知识库:2019-03-20_10-47-19_的屏幕截图.png|}}

===== 问题四：testlink数据库不存在 =====

{ {:知识库:2019-03-20_10-47-19_的屏幕截图.png|}}

==== 尝试解决办法 ====
手动创建对应数据库

===== 问题五：数据库Grant问题 =====

数据库和用都创建成功之后，仍然遇到如下问题：

TestLink 1.9.19 (Metonic cycle) TestLink 1.9.19 (Metonic cycle) - New installation

TestLink setup will now attempt to setup the database:

Creating connection to Database Server:OK!

Connecting to database testlink:OK!

==============================================================================
DB Access Error - debug_print_backtrace() OUTPUT START
ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200)
Having this additional Information could be useful for reporting
issue to development TEAM.

#0 database->exec_query(GRANT SELECT, UPDATE, DELETE, INSERT ON testlink.* TO ‘testlink’@‘localhost’ IDENTIFIED BY ‘Nufront@liumin01’) called at [/var/www/html/testlink/install/installUtils.php:501]
#1 _mysql_make_user(database Object ([db] => ADODB_mysqli Object ([databaseType] => mysqli,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = ‘VIEW’ THEN ‘V’ ELSE ‘T’ END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=,[metaColumnsSQL] => SHOW COLUMNS FROM %s,[fmtTimeStamp] => ‘Y-m-d H:i:s’,[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => 1,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[port] => 3306,[socket] => ,[_bindInputArray] => ,[nameQuote] => ,[optionFlags] => Array ([0] => Array ([0] => 5,[1] => 0)),[arrayClass] => ADORecordSet_array_mysqli,[multiQuery] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table if not exists %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table if exists %s,[database] => mysql,[host] => localhost,[user] => root,[password] => not stored,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[bulkBind] => ,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => mysqli Object ([affected_rows] => ,[client_info] => ,[client_version] => ,[connect_errno] => ,[connect_error] => ,[errno] => ,[error] => ,[error_list] => ,[field_count] => ,[host_info] => ,[info] => ,[insert_id] => ,[server_info] => ,[server_version] => ,[stat] => ,[sqlstate] => ,[protocol_version] => ,[thread_id] => ,[warning_count] => ),[_errorMsg] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'Nufront@liumin01'' at line 1,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[*connectionParameters] => Array (),[databaseName] => mysql),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 0,[overallDuration] => 0,[dbType] => mysqli,[databaselogEnabled] => 0,[databaselogQueries] => 0), localhost, testlink, testlink, Nufront@liumin01) called at [/var/www/html/testlink/install/installUtils.php:544] #2 _mysql_assign_grants(database Object ([db] => ADODB_mysqli Object ([databaseType] => mysqli,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=,[metaColumnsSQL] => SHOW COLUMNS FROM%s,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => 1,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[port] => 3306,[socket] => ,[_bindInputArray] => ,[nameQuote] =>,[optionFlags] => Array ([0] => Array ([0] => 5,1 => 0)),[arrayClass] => ADORecordSet_array_mysqli,[multiQuery] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table if not exists %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[dropSeqSQL] => drop table if exists %s,[database] => mysql,[host] => localhost,[user] => root,[password] => not stored,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => ‘Y-m-d’,[true] => 1,[false] => 0,[replaceQuote] => ',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID