DB Access Error/authenication error

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

DB Access Error/authenication error

Postby Tanglewood » Tue Apr 17, 2018 4:44 pm

Hi, I have reinstalled testlink 1.9.16 over the top of a current install as there were some issues with some screens not being available when running test plans. The database exists but no i have overwritten the folder cotaining the files I am getting the following error when trying to access the web app. Any help would be greatly appreciated.

==============================================================================
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(/* Class:tlEvent - Method: writeToDB */ INSERT INTO events (transaction_id,log_level,description,source,fired_at,object_id,object_type,activity) VALUES (0,2,'','',1523975774,0,NULL,'')) called at [/var/www/html/testlink-code-1.9.16/lib/functions/logger.class.php:892]
#1 tlEvent->writeToDB(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] => testlink,[host] => localhost,[user] => testlinkuser,[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] => ,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[*connectionParameters] => Array ()),[queries_array] => Array (),[is_connected] => ,[nQuery] => 0,[overallDuration] => 0,[dbType] => mysqli,[databaselogEnabled] => 0,[databaselogQueries] => 0)) called at [/var/www/html/testlink-code-1.9.16/lib/functions/logger.class.php:1026]
#2 tlDBLogger->writeEvent(tlEvent Object ([logLevel] => 2,[description] => E_WARNING
mysqli_real_connect(): (HY000/1045): Access denied for user 'testlinkuser'@'localhost' (using password: YES) - in /var/www/html/testlink-code-1.9.16/third_party/adodb/drivers/adodb-mysqli.inc.php - Line 124,[source] => GUI,[timestamp] => 1523975774,[userID] => 0,[sessionID] => ,[transactionID] => ,[activityCode] => PHP,[objectID] => ,[objectType] => ,[transaction] => ,[*activateCaching] => ,[dbID] => ,[*detailLevel] => 4294967295,[*userFeedback] => ,[*serializationInterfaces] => ,[*serializationFormatDescriptors] => ,[*tables] => Array ([assignment_status] => assignment_status,[assignment_types] => assignment_types,[attachments] => attachments,[builds] => builds,[cfield_build_design_values] => cfield_build_design_values,[cfield_design_values] => cfield_design_values,[cfield_execution_values] => cfield_execution_values,[cfield_node_types] => cfield_node_types,[cfield_testplan_design_values] => cfield_testplan_design_values,[cfield_testprojects] => cfield_testprojects,[custom_fields] => custom_fields,[db_version] => db_version,[events] => events,[execution_bugs] => execution_bugs,[execution_tcsteps] => execution_tcsteps,[executions] => executions,[inventory] => inventory,[issuetrackers] => issuetrackers,[testproject_issuetracker] => testproject_issuetracker,[keywords] => keywords,[milestones] => milestones,[node_types] => node_types,[nodes_hierarchy] => nodes_hierarchy,[object_keywords] => object_keywords,[platforms] => platforms,[plugins] => plugins,[plugins_configuration] => plugins_configuration,[req_coverage] => req_coverage,[req_relations] => req_relations,[req_specs] => req_specs,[req_specs_revisions] => req_specs_revisions,[reqmgrsystems] => reqmgrsystems,[testproject_reqmgrsystem] => testproject_reqmgrsystem,[requirements] => requirements,[req_versions] => req_versions,[req_revisions] => req_revisions,[req_notify_assignments] => req_notify_assignments,[req_monitor] => req_monitor,[rights] => rights,[risk_assignments] => risk_assignments,[role_rights] => role_rights,[roles] => roles,[testcase_relations] => testcase_relations,[tcversions] => tcversions,[tcsteps] => tcsteps,[testcase_keywords] => testcase_keywords,[testplan_platforms] => testplan_platforms,[testplan_tcversions] => testplan_tcversions,[testplans] => testplans,[testprojects] => testprojects,[testsuites] => testsuites,[text_templates] => text_templates,[transactions] => transactions,[user_assignments] => user_assignments,[user_group] => user_group,[user_group_assign] => user_group_assign,[user_testplan_roles] => user_testplan_roles,[user_testproject_roles] => user_testproject_roles,[users] => users),[*views] => Array ([tcversions_last_active] => tcversions_last_active,[last_executions] => last_executions,[last_executions_by_platforms] => last_executions_by_platforms),[*auditCfg] => stdClass Object ([eventSource] => GUI,[logEnabled] => 1))) called at [/var/www/html/testlink-code-1.9.16/lib/functions/logger.class.php:555]
#3 tlTransaction->writeEvent(tlEvent Object ([logLevel] => 2,[description] => E_WARNING
mysqli_real_connect(): (HY000/1045): Access denied for user 'testlinkuser'@'localhost' (using password: YES) - in /var/www/html/testlink-code-1.9.16/third_party/adodb/drivers/adodb-mysqli.inc.php - Line 124,[source] => GUI,[timestamp] => 1523975774,[userID] => 0,[sessionID] => ,[transactionID] => ,[activityCode] => PHP,[objectID] => ,[objectType] => ,[transaction] => ,[*activateCaching] => ,[dbID] => ,[*detailLevel] => 4294967295,[*userFeedback] => ,[*serializationInterfaces] => ,[*serializationFormatDescriptors] => ,[*tables] => Array ([assignment_status] => assignment_status,[assignment_types] => assignment_types,[attachments] => attachments,[builds] => builds,[cfield_build_design_values] => cfield_build_design_values,[cfield_design_values] => cfield_design_values,[cfield_execution_values] => cfield_execution_values,[cfield_node_types] => cfield_node_types,[cfield_testplan_design_values] => cfield_testplan_design_values,[cfield_testprojects] => cfield_testprojects,[custom_fields] => custom_fields,[db_version] => db_version,[events] => events,[execution_bugs] => execution_bugs,[execution_tcsteps] => execution_tcsteps,[executions] => executions,[inventory] => inventory,[issuetrackers] => issuetrackers,[testproject_issuetracker] => testproject_issuetracker,[keywords] => keywords,[milestones] => milestones,[node_types] => node_types,[nodes_hierarchy] => nodes_hierarchy,[object_keywords] => object_keywords,[platforms] => platforms,[plugins] => plugins,[plugins_configuration] => plugins_configuration,[req_coverage] => req_coverage,[req_relations] => req_relations,[req_specs] => req_specs,[req_specs_revisions] => req_specs_revisions,[reqmgrsystems] => reqmgrsystems,[testproject_reqmgrsystem] => testproject_reqmgrsystem,[requirements] => requirements,[req_versions] => req_versions,[req_revisions] => req_revisions,[req_notify_assignments] => req_notify_assignments,[req_monitor] => req_monitor,[rights] => rights,[risk_assignments] => risk_assignments,[role_rights] => role_rights,[roles] => roles,[testcase_relations] => testcase_relations,[tcversions] => tcversions,[tcsteps] => tcsteps,[testcase_keywords] => testcase_keywords,[testplan_platforms] => testplan_platforms,[testplan_tcversions] => testplan_tcversions,[testplans] => testplans,[testprojects] => testprojects,[testsuites] => testsuites,[text_templates] => text_templates,[transactions] => transactions,[user_assignments] => user_assignments,[user_group] => user_group,[user_group_assign] => user_group_assign,[user_testplan_roles] => user_testplan_roles,[user_testproject_roles] => user_testproject_roles,[users] => users),[*views] => Array ([tcversions_last_active] => tcversions_last_active,[last_executions] => last_executions,[last_executions_by_platforms] => last_executions_by_platforms),[*auditCfg] => stdClass Object ([eventSource] => GUI,[logEnabled] => 1))) called at [/var/www/html/testlink-code-1.9.16/lib/functions/logger.class.php:475]
#4 tlTransaction->add(2, E_WARNING
mysqli_real_connect(): (HY000/1045): Access denied for user 'testlinkuser'@'localhost' (using password: YES) - in /var/www/html/testlink-code-1.9.16/third_party/adodb/drivers/adodb-mysqli.inc.php - Line 124, GUI, PHP, , ) called at [/var/www/html/testlink-code-1.9.16/lib/functions/logging.inc.php:106]
#5 tLog(E_WARNING
mysqli_real_connect(): (HY000/1045): Access denied for user 'testlinkuser'@'localhost' (using password: YES) - in /var/www/html/testlink-code-1.9.16/third_party/adodb/drivers/adodb-mysqli.inc.php - Line 124, WARNING, GUI, , , PHP) called at [/var/www/html/testlink-code-1.9.16/lib/functions/logging.inc.php:50]
#6 logWarningEvent(E_WARNING
mysqli_real_connect(): (HY000/1045): Access denied for user 'testlinkuser'@'localhost' (using password: YES) - in /var/www/html/testlink-code-1.9.16/third_party/adodb/drivers/adodb-mysqli.inc.php - Line 124, PHP) called at [/var/www/html/testlink-code-1.9.16/lib/functions/logger.class.php:1440]
#7 watchPHPErrors(2, mysqli_real_connect(): (HY000/1045): Access denied for user 'testlinkuser'@'localhost' (using password: YES), /var/www/html/testlink-code-1.9.16/third_party/adodb/drivers/adodb-mysqli.inc.php, 124, Array ([argHostname] => localhost,[argUsername] => testlinkuser,[argPassword] => PSS911p,[argDatabasename] => testlink,[persist] => ,[arr] => Array ([0] => 5,[1] => 0)))
#8 mysqli_real_connect(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] => ), localhost, testlinkuser, PSS911p, testlink, 3306, , 0) called at [/var/www/html/testlink-code-1.9.16/third_party/adodb/drivers/adodb-mysqli.inc.php:124]
#9 ADODB_mysqli->_connect(localhost, testlinkuser, PSS911p, testlink) called at [/var/www/html/testlink-code-1.9.16/third_party/adodb/drivers/adodb-mysqli.inc.php:150]
#10 ADODB_mysqli->_nconnect(localhost, testlinkuser, PSS911p, testlink) called at [/var/www/html/testlink-code-1.9.16/third_party/adodb/adodb.inc.php:666]
#11 ADOConnection->Connect(localhost, testlinkuser, PSS911p, testlink, 1) called at [/var/www/html/testlink-code-1.9.16/third_party/adodb/adodb.inc.php:711]
#12 ADOConnection->NConnect(localhost, testlinkuser, PSS911p, testlink) called at [/var/www/html/testlink-code-1.9.16/lib/functions/database.class.php:147]
#13 database->connect(, localhost, testlinkuser, PSS911p, testlink) called at [/var/www/html/testlink-code-1.9.16/lib/functions/common.php:153]
#14 doDBConnect(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] => testlink,[host] => localhost,[user] => testlinkuser,[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] => ,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[*connectionParameters] => Array ()),[queries_array] => Array (),[is_connected] => ,[nQuery] => 0,[overallDuration] => 0,[dbType] => mysqli,[databaselogEnabled] => 0,[databaselogQueries] => 0), 1) called at [/var/www/html/testlink-code-1.9.16/login.php:29]
Tanglewood
TestLink user
 
Posts: 2
Joined: Thu Apr 12, 2018 5:53 pm

Re: DB Access Error/authenication error

Postby Tanglewood » Thu May 10, 2018 4:49 pm

Resolved by using bitnami install
Tanglewood
TestLink user
 
Posts: 2
Joined: Thu Apr 12, 2018 5:53 pm


Return to Installation and configuration



Who is online

Users browsing this forum: No registered users and 3 guests

cron