All of a sudden unable to login

The release related discussions, plans and questions.
Locked
pudreaux
TestLink user
Posts: 5
Joined: Wed Jan 30, 2008 3:58 pm

All of a sudden unable to login

Post by pudreaux »

I'm running 1.7.3 and all of a sudden can no longer login. It was working fine for 2-3 weeks then stops allowing logins.

After entering a valid username/password and clicking on the Login button, it just refreshes the login screen and no error is displayed.

I did have one session already open and saw the following error when clicking on the Home link:

1 - Can't create/write to file '#sql_daf_0.MYD' (Errcode: 28) - SELECT nodes_hierarchy.id, nodes_hierarchy.name, notes,active, testproject_id FROM nodes_hierarchy,testplans WHERE nodes_hierarchy.id=testplans.id AND (testproject_id = 30143 ) AND active = 1 ORDER BY name

Any ideas?
fman
Member of TestLink Community
Posts: 3123
Joined: Tue Nov 15, 2005 7:19 am

Post by fman »

This is a MySQL error.
Search on Mysql site.
You need to do run some sanity checks on your db
shanks
TestLink user
Posts: 3
Joined: Mon Feb 25, 2008 8:48 am

What solved my login issue

Post by shanks »

1. Take a back up of the php.ini file in your machine.
2. Replace the attached php.ini file.
3. Make the following path changes in the php.ini file according to your machine path location:
Ini File Location:c:\PHP\php.ini

Path changes to be made:
Comment this ;upload_tmp_dir="C:\DOCUME~1\gdeepak\LOCALS~1\Temp\php\upload"
upload_tmp_dir="C:\testlink\upload"
Comment this ;session.save_path="C:\DOCUME~1\gdeepak\LOCALS~1\Temp\php\session"
session.save_path="C:\testlink"
4. Restart machine
5. Check if these changes have taken effect by launching: http://localhost/testlink/phpinfo.php and search for the following directive for valid path: session.save_path
6. Now try loggin in!
Locked