MantisBT - TestLink
View Issue Details
0008526TestLinkInstallerpublic2018-12-31 11:012019-04-02 20:41
Balawoo 
fman 
normalblockalways
closedno change required 
MacMojave10.14
1.9.18 (2018 Q3) 
 
MySQL8.0.13
Safari
7.1.19
TBD
0008526: Error during creation database
Hello,

I'm facing an issue and can't find solution, this is copy of my error:
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 'root'@'localhost' IDENTIFIED BY 'NewPass') called at [/Users/sapfinance/Sites/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 'NewPass'' 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, root, NewPass) called at [/Users/sapfinance/Sites/testlink/install/installUtils.php:544]
0000002 _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] => 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 'NewPass'' 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, root, NewPass) called at [/Users/sapfinance/Sites/testlink/install/installUtils.php:310]
0000003 create_user_for_db(mysql, testlink, localhost, root, NewPass, root, NewPass) called at [/Users/sapfinance/Sites/testlink/install/installNewDB.php:410]
During phase Create DB, testlink DB user, structures and default data & create configuration file. I have this error.

I add in attachment the result of phpinfo.

this is the summary of phase :

TestLink will carry out a number of checks to see if everything's ready to start the setup.
System requirements
Web and PHP configuration
   Server Operating System (no constrains) Darwin
PHP version OK ( 5.5.0 [minimum version] <= 7.1.19 [your version] )
 
Maximum Session Idle Time before Timeout
Checking max. execution time (Parameter max_execution_time)
Checking maximal allowed memory (Parameter memory_limit)
Checking if Register Globals is disabled Checking Postgres Database
Checking MySQL Database
Checking MSSQL Database
Checking GD Graphic library Checking LDAP library Checking JSON library Checking cURL library
24 minutes and 0 seconds - (Short. Consider to extend.)
30 seconds - We suggest 120 seconds in order to manage hundred of test cases (edit php.ini)
OK (128 MegaBytes)
OK
OK
OK
Failed! MSSQL Database cannot be used. OK
OK OK OK
Read/write permissions
For security reasons we suggest that directories tagged with [S] on following messages, will be made UNREACHEABLE from browser.
Give a look to README file, section 'Installation & SECURITY' to understand how to change the defaults.
Checking if /Users/sapfinance/Sites/testlink/gui/templates_c directory exists OK Checking if /Users/sapfinance/Sites/testlink/gui/templates_c directory is writable (by user used to OK
run webserver process)
Checking if /var/testlink/logs/ directory exists [S] OK Checking if /var/testlink/logs/ directory is writable (by user used to run webserver process) OK Checking if /var/testlink/upload_area/ directory exists [S] OK
http://localhost/~sapfinance/testlink/install/installCheck.php?licenseOK=on [^] Page 1 sur 2
TestLink 1.9.18 (Gaura) - New installation 31/12/2018 11(56
Checking if /var/testlink/upload_area/ directory is writable (by user used to run webserver process) OK
  Your system is prepared for TestLink configuration (no fatal problem found).
No tags attached.
pdf phpinfo.pdf (1,036,311) 2018-12-31 11:01
http://mantis.testlink.org/file_download.php?file_id=5073&type=bug
Issue History
2018-12-31 11:01BalawooNew Issue
2018-12-31 11:01BalawooFile Added: phpinfo.pdf
2019-01-01 13:00fmanNote Added: 0028401
2019-01-01 13:02fmanAssigned To => fman
2019-01-01 13:02fmanStatusnew => feedback
2019-01-01 17:21BalawooNote Added: 0028403
2019-01-01 17:21BalawooStatusfeedback => assigned
2019-01-01 17:37fmanNote Added: 0028404
2019-01-01 17:37fmanQA Team - Task Workflow Status => TBD
2019-01-01 17:37fmanStatusassigned => resolved
2019-01-01 17:37fmanResolutionopen => no change required
2019-04-02 20:41fmanStatusresolved => closed

Notes
(0028401)
fman   
2019-01-01 13:00   
best option => get bitnami installer
(0028403)
Balawoo   
2019-01-01 17:21   
Yes it's working. It's not perfect but it's ok

Thanks,

Philippe
(0028404)
fman   
2019-01-01 17:37   
I use mac, but use MAMPro without no issues