nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

expired license trifecta

Jonathan Marra

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

Accepted answers

All comments

Nic Brough -Adaptavist-

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.

Jonathan Marra

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.

Jonathan Marra

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 Brough -Adaptavist-

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

Jonathan Marra_eanp5c

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.

Nic Brough -Adaptavist-

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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration