I'm doing a new installation of testlink 1.8 RC1 on Red Hat Enterprise 5 with PHP 5.1.6 and MySQL 14.12 Distrib 5.0.22.
The database setup step returns the following:
"TestLink setup will now attempt to setup the database:
Creating connection to Database Server: Failed!
Please check the database login details and try again.
Database Error Message: Access denied for user 'eymanm'@'localhost' (using password: YES)"
Tried to specify different database user with administrative rights names, including root. Same error.
Any advice on fixing this problem will be appreciated.
-Mark
Creating connection to Database Server: Failed
Moderators: Amaradana, TurboPT, TL Developers
First I'd like to dig into 'root'@'localhost' doesn't work issue. Here's an exert from userlog0.log:
[09/Jan/5 15:57:12][WARNING][<nosession>][GUI]
E_WARNING
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'root'@'localhost' (using password: YES) - in /
usr/local/testlink_18RC1/third_party/adodb/drivers/adodb-mysql.inc.php - Line 364
[<<][49622dd827b94084397231][DEFAULT][/testlink/install/installNewDB.php][09/Jan/5 15:57:12][09/Jan/5 15:57:12][took 0.007142 secs]
[>>][49622ee752d30123980739][DEFAULT][/testlink/install/installNewDB.php][09/Jan/5 16:01:43]
Before messing up with the permissions I'd like to make sure that this is the issue. If it's feasible, I'd like to go with this approach:
Database User with administrative rights: root
Database User for Normal Testlink use: testlink (my assumption that this is not a Linux user. Is that correct?)
Two questions:
1. Does the log provide any clue of what's wrong?
2. Is the scenario with users root and testlik as described above is doable?
Thanks
-Mark
[09/Jan/5 15:57:12][WARNING][<nosession>][GUI]
E_WARNING
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'root'@'localhost' (using password: YES) - in /
usr/local/testlink_18RC1/third_party/adodb/drivers/adodb-mysql.inc.php - Line 364
[<<][49622dd827b94084397231][DEFAULT][/testlink/install/installNewDB.php][09/Jan/5 15:57:12][09/Jan/5 15:57:12][took 0.007142 secs]
[>>][49622ee752d30123980739][DEFAULT][/testlink/install/installNewDB.php][09/Jan/5 16:01:43]
Before messing up with the permissions I'd like to make sure that this is the issue. If it's feasible, I'd like to go with this approach:
Database User with administrative rights: root
Database User for Normal Testlink use: testlink (my assumption that this is not a Linux user. Is that correct?)
Two questions:
1. Does the log provide any clue of what's wrong?
2. Is the scenario with users root and testlik as described above is doable?
Thanks
-Mark
Note that login name include also server. So you should have several different accounts for root user: root@localhost, root@eymanm.com, root@google.com. Install phpMyAdmin and investigate it. Or check its configuration if you have already installed it.
There is nothing more required to log by TestLink. You must just setup or use correct user+password.
There is nothing more required to log by TestLink. You must just setup or use correct user+password.