MantisBT - TestLink
View Issue Details
0008797TestLinkInstallerpublic2019-11-07 18:312019-11-07 18:31
jgaluska 
 
normalmajoralways
newopen 
x86_64Ubuntu18.04
1.9.19.01 (1.9.19 fixes) 
 
MySQL ver 5.7
Chrome
7.2
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.
Issue History
2019-11-07 18:31jgaluskaNew Issue

There are no notes attached to this issue.