MantisBT - TestLink
View Issue Details
0008797TestLinkInstallerpublic2019-11-07 18:312019-12-28 12:11
jgaluska 
fman 
normalmajoralways
resolvedfixed 
x86_64Ubuntu18.04
1.9.19.01 (1.9.19 fixes) 
1.9.19.01 (1.9.19 fixes) 
MySQL ver 5.7
Chrome
7.2
TBD
0008797: Installer does not grant the TestLink user permissions to access the TestLink database
I 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}
1) 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.
Sorry if I posted this in the wrong place, I did not see the 1.9.20 in the Product Version list.
No tags attached.
related to 0008733resolved fman Database error on installation. 
Issue History
2019-11-07 18:31jgaluskaNew Issue
2019-12-28 12:10fmanNote Added: 0029355
2019-12-28 12:11fmanRelationship addedrelated to 0008733
2019-12-28 12:11fmanQA Team - Task Workflow Status => TBD
2019-12-28 12:11fmanStatusnew => resolved
2019-12-28 12:11fmanFixed in Version => 1.9.19.01 (1.9.19 fixes)
2019-12-28 12:11fmanResolutionopen => fixed
2019-12-28 12:11fmanAssigned To => fman

Notes
(0029355)
fman   
2019-12-28 12:10   
thanks for reporting.

has been fixed today 20191218.