expired license trifecta

Ok, I have backed myself into a corner.  Hoping the collective here can get me out.

I have been OOO on med leave for two weeks.  My trial license has expired, and since my two weeks I seem to have forgotten my logins.  Or at least the ones I am trying are not working.  The 3rd piece is I did not get SMTP and email going on this sandbox yet so I cannot have info sent by email.

All I need actually is the current stories I setup in this first install.  I can reinstall and import if needed.

 

Help please?

 

thanks

2 answers

1 vote

You can reset the admin password with https://confluence.atlassian.com/display/JIRA/Retrieving+the+JIRA+Administrator - that will get you back in, but the expired licence will stop you doing much beyond "read only" stuff.

Nic, you rock. Question as I am a newbie with SQL queries. What app do you use or recommend to run the queries against JIRA DB? I have not done this before so your help is greatly appreciated.

Nic, you rock.  Question as I am a newbie with SQL queries.  What app do you use or recommend to run the queries against JIRA DB?  I have not done this before so your help is greatly appreciated.

I've tended to lean on SquirrelSQL in the past, but also just the command lines for whatever database I'm using at the time. The main question is actually "which database are you using" - that determines the "best" tool

Nic, I tried installing the squirrelSQL but ran into some issues. Beyond the app to use how do I connect to the JIRA DB? I can find another app or tool to use if needed but never connected to a DB and ran queries before. This would be the first time I have accessed a DB to run queries. thanks for any help I realize this is basic DB 101.

I can't help you until you tell me what database you are using.

HSQL. the default DB used when installing JIRA locally. thank you

Well, the tool I'd recommend for HSQL is the "database manager" that the HSQL team wrote. But for resetting the admin password, don't bother! Find database.script in the jira-home directory, save a backup copy, and open it up in a plain text editor. Find the line that says "insert admin details into CWD_USER" and overwrite the "{pkcs52}randomstring" with "randomstring" given in the atlassian doc. Start JIRA and login with admin/sphere

Ok, this did the trick. I actually did not even need to reset password. The script file, which for me on MS was JIRADB.script. when opened in viewer allowed me to see all usernames. I was able to login as another user, eleveate permissions and reset password that way. thank you very much.

adding here as my answer from NIC above.

 

Ok, this did the trick.  I actually did not even need to reset password.  The script file, which for me on MS was JIRADB.script. when opened in viewer allowed me to see all usernames.  I was able to login as another user, elevate permissions and reset password that way.
thank you very much.

Ack, sorry, I've been tinkering with too many Confluences recently, where it's called database.script. I forgot JIRA names it jiradb.script. Still, not too far off, and I'm happy you managed to work out I'd given you the wrong name!

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

73 views 0 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you