AgileTrack
Put your development on the AgileTrack

agile track demo - deactivated the admin account now can't log in

I was seeing if I could deactive the admin account and activate a new account I created that had admin privs but with my info as the user. I did this because I am just demoing the software and you only have 1 user. Anyway it said I had no license for my user I created so before I closed AgileTrack I tried enabling the admin account but it said there was no license for it either.

I closed AgileTrack and now it says that the admin user is invalid. I am using the default HSQLDB agiletrack_db is there anyway I can fix it to let me log back in?

—Posted by Jeremy on Jan 12, 2009


	Forum AgileTrack Client


	Reply

Well, that's a bit of a bug there that you were able to lock yourself out. To reset things, you can either entirely delete your hsql database, create a new one, or manually edit the hsql database to reenable your user.

To delete the database, just find the .script and .properties files for your database and delete those.

To create a different database, you can go into settings from the login screen and rename the database.

And to fix the user, you'll need to open the .script file for the database in a text editor. Search for "INSERT INTO USER VALUES(". You should be able to see the username toward the end of those lines. Change the FALSE to TRUE in line with the user you want to enable, and save the file. That should reenable the user and you should be able to log in.

I hope that helps.

—Posted by Adam Lane on Jan 12, 2009 at 5:57:29 PM

"And to fix the user, you'll need to open the .script file for the database in a text editor. Search for "INSERT INTO USER VALUES(". You should be able to see the username toward the end of those lines. Change the FALSE to TRUE in line with the user you want to enable, and save the file. That should reenable the user and you should be able to log in."

That fixed it, thanks for the info and the quick response.

—Posted by Jeremy on Jan 12, 2009 at 8:39:17 PM