Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008797TestLinkInstallerpublic2019-11-07 18:312019-11-07 18:31
Reporterjgaluska 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
Platformx86_64OSUbuntuOS Version18.04
Product Version1.9.19.01 (1.9.19 fixes) 
Fixed in Version 
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 Status
Attached Files

- Relationships

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2019-11-07 18:31 jgaluska New Issue



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker