Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008797TestLinkInstallerpublic2019-11-07 18:312019-12-28 12:11
Reporterjgaluska 
Assigned Tofman 
PrioritynormalSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
Platformx86_64OSUbuntuOS Version18.04
Product Version1.9.19.01 (1.9.19 fixes) 
Fixed in Version1.9.19.01 (1.9.19 fixes) 
Summary0008797: Installer does not grant the TestLink user permissions to access the TestLink database
DescriptionI am using version 1.9.20 [DEV](Raijin). Git Commit b196603

I am using MySQL to serve the database


Once installed, the main web page complains that it can't access the database:

    1044 - Access denied for user 'testlinkuser'@'localhost' to database 'testlink'
    
    TestLink ::: Fatal Error
    
    Connect to database testlink on Host localhost fails
    DBMS Error Message: 1044 - Access denied for user 'testlinkuser'@'localhost' to database 'testlink'



This can be resolved by executing the following in MySQL:

    mysql -u root -p${MYSQL_ROOT_PASSWORD} -e "GRANT SELECT, INSERT, UPDATE, DELETE ON ${TL_DATABASE}.* TO '${TL_DATABASE_USER}'@'localhost';"

Of course, you will have to substitute the correct values for ${MYSQL_ROOT_PASSWORD}, ${TL_DATABASE}, & ${TL_DATABASE_USER}
Steps To Reproduce1) Install Ubuntu 18.04, Apache2, and MySQL Ver 5.7.
2) Clone the current TestLink repository
3) Browse to the TestLink web site and follow the installer. Do not use the mySQL root user credentials for the TestLink database.
4) execute the follow on steps (import file 'testlink_create_udf0.sql' and delete the install directory)
5) Browse to the TestLink web site and log in, you will see the error specified in the Description
6) On the command console execute the command specified in the Description
7) Re-log into the Testlink, the error will be gone.
Additional InformationSorry if I posted this in the wrong place, I did not see the 1.9.20 in the Product Version list.
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL ver 5.7
BrowserChrome
PHP Version7.2
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships
related to 0008733resolvedfman Database error on installation. 

-  Notes
(0029355)
fman (administrator)
2019-12-28 12:10

thanks for reporting.

has been fixed today 20191218.

- Issue History
Date Modified Username Field Change
2019-11-07 18:31 jgaluska New Issue
2019-12-28 12:10 fman Note Added: 0029355
2019-12-28 12:11 fman Relationship added related to 0008733
2019-12-28 12:11 fman QA Team - Task Workflow Status => TBD
2019-12-28 12:11 fman Status new => resolved
2019-12-28 12:11 fman Fixed in Version => 1.9.19.01 (1.9.19 fixes)
2019-12-28 12:11 fman Resolution open => fixed
2019-12-28 12:11 fman Assigned To => fman



Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker