Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008526TestLinkInstallerpublic2018-12-31 11:012019-04-02 20:41
ReporterBalawoo 
Assigned Tofman 
PrioritynormalSeverityblockReproducibilityalways
StatusclosedResolutionno change required 
PlatformMacOSMojaveOS Version10.14
Product Version1.9.18 (2018 Q3) 
Fixed in Version 
Summary0008526: Error during creation database
DescriptionHello,

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]
Steps To ReproduceDuring 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.

Additional Informationthis 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).
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL8.0.13
BrowserSafari
PHP Version7.1.19
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Filespdf file icon phpinfo.pdf [^] (1,036,311 bytes) 2018-12-31 11:01

- Relationships

-  Notes
(0028401)
fman (administrator)
2019-01-01 13:00

best option => get bitnami installer
(0028403)
Balawoo (reporter)
2019-01-01 17:21

Yes it's working. It's not perfect but it's ok

Thanks,

Philippe
(0028404)
fman (administrator)
2019-01-01 17:37

I use mac, but use MAMPro without no issues

- Issue History
Date Modified Username Field Change
2018-12-31 11:01 Balawoo New Issue
2018-12-31 11:01 Balawoo File Added: phpinfo.pdf
2019-01-01 13:00 fman Note Added: 0028401
2019-01-01 13:02 fman Assigned To => fman
2019-01-01 13:02 fman Status new => feedback
2019-01-01 17:21 Balawoo Note Added: 0028403
2019-01-01 17:21 Balawoo Status feedback => assigned
2019-01-01 17:37 fman Note Added: 0028404
2019-01-01 17:37 fman QA Team - Task Workflow Status => TBD
2019-01-01 17:37 fman Status assigned => resolved
2019-01-01 17:37 fman Resolution open => no change required
2019-04-02 20:41 fman Status resolved => closed



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker