Following a clean install of QaTraq the user_name/password combinations shown below should log you into QaTraq. :
test1 / test1
or
admin / admin
Sometimes however, you may have problems logging in following an install. Sometimes this is because of something we've done wrong and sometimes its because of something you've done wrong. You may find that one or more of the steps below will help you out with login problems. If they don't please don't hesitate to
contact us for more help.
First, make sure you have the QaTraq config file (db_params.php) set up properly. See the 'Modify the db_params.php' section in the following install instructions:
Second, make sure the two Mysql user accounts required by QaTraq have been set up correctly. Again, see the 'Create the QaTraq database' section in the install instructions:
If both of the above are correct then we have to dig a bit deeper....
Third, try taking a look at the log files. So enable logging and then take a look at the log files.
Edit the file lib/db_qatraq.php changing the following line to enable logging
$GLOBALS['LOG_ON_QUERY'] = 1;
Running under windows then you'll need to change the place where the log files are created in the file lib/log.inc....
define ('TMT_LOG_FILE', '/tmp/tmt'.date("Ymd").'.log'); // log file
define ('TMT_ERR_FILE', '/tmp/tmt_err'.date("Ymd").'.log'); // error file
Should be changed to something like...
define ('TMT_LOG_FILE', '\Temp\tmt'.date("Ymd").'.log'); // log file
define ('TMT_ERR_FILE', '\Temp\tmt_err'.date("Ymd").'.log'); // error file
Once these have been changed you should be fine with the logging on windows.
If the logging step doesn't point you in the right direction then.....
Fourth, take a look at the users table with 'Select * from users'. You should see a table with values like this....
1 test1 test1 <xxx encrypted password xxx>
2 admin admin <xxx encrypted password xxx>
3 dummy dummy <xxx encrypted password xxx>
Finally, dropping the database and creating the database again with (we're assuming you've not entered any data here....as you'll loose everything when you drop the database)....
mysql -u root -p<password> -e "drop database qatraq"
mysql -u root -p<password> -e "create database qatraq"
cd qatraq/DB
mysql -u root -p<password> qatraq < qatraq.sql
If you still can't login after going through these steps then please
get in touch. Send us the relevant lines from the log files and the users table. Then we'll see if we can get you sorted out. If you can provide us with the following information too then this would help:
Version of QaTraq: eg qatraq_5_1_rc
OS: eg windows Xp
From lib/db_qatraq.php the following:
$db_data['tmt'] = array(
'host' => 'localhost',
'db' => 'qatraq',
'user' => 'qatraq',
'password' => 'xxxx'
);
QaTraq does have a logging process, which can help identify issues. For logging on Windows you'll need to change the place where the log files are created in the file lib\log.inc....
define ('TMT_LOG_FILE', '/tmp/tmt'.date("Ymd").'.log'); // log file
define ('TMT_ERR_FILE', '/tmp/tmt_err'.date("Ymd").'.log'); // error file
Should be changed to something like...
define ('TMT_LOG_FILE', '\Temp\tmt'.date("Ymd").'.log'); // log file
define ('TMT_ERR_FILE', '\Temp\tmt_err'.date("Ymd").'.log'); // error file
Logging can be turned off or on by editing
lib/db_qatraq.php
Logging can be configured by editing this file
lib/log.inc