How to Get and Update JIRA License String from the Database

Hi,

 

We did follow the steps in your documentation and still not able to change it: here the command lines:

 

mysql> SELECT * FROM productlicense;

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect...

Connection id:    28228

Current database: jira_7_0_11

 

+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| ID    | LICENSE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |

+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| 10000 | AAABnw0ODAoPeNp9kUtv2zAQhO/8FQR6aQ8ULBl2awME6kgMoMKP1LITIOiFpdYxW4kSlpTb/PtSD6MO4uQmisud+WY+7I4NzaCmUUTD8XwymodjGic7Go3CKXlCAHOs6howWGoFxoLItdOV4WK9E9u7bZoJsm7Kn4Cbw94CWs5CElfGSeXWsgQeH1FbequhyMkvjTJ4NX3XoDpKC4l0wFtZFoYsisgguHuuod+0Wa3ENk4Xy/OV+FtrfO7eNabQpXaQn8XFSuqCq1Y9OLTqX600uba/A1WVJAM8AaYJX9w+3LDH6WzC9uniO7uf3Tz2Nmus8ka5oD0wWx3cH4kQ+MX6BNxhA/3Y26lcye4airdpHBhp1CWOj+HzEMM7bl5FOeh4rmWaZGLNotFk8mU6I/6bX57fWZo5iQ6QH2RhgWzwSRptZUeXSZP4BEmM0P3439hoxqIxKXr5e++mHY9eZAAeE2tfxxBfAlahrrvF39LtgmaDA/qxb+cT3Z9LpR3hjzmNq7IEVFoWdGDtUd7q5Vril6Yu34mTLJoetGf/BwjnEuQwLAIUWcdUkR2oof+Co3TZTqelblZ+8fYCFG78SeScXF71k0IRbsFKeQfdMdz6X02k0 |

+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.30 sec)

 

mysql>

--------------------------------

 

update productlicense set license ='AAABYQ0ODAoPeNqVkT1vwjAQhnf/Cktd2iFRghpASJGKklSiAlIR2i5dXHMBQ2xHZ4ePf18nhKodO

3jx3T1+7vXdetfQnFsaRDQYT6LxJIxokq7pIAhHZNnIL8C8fDOAJh4EQUBSMBxFbYVW8ctsNaULY

Tj90HgoK32i2dmCMq5oaKmRdh33BeAR8IG2ANqxPic00VICcsEqOhfcDQFJEFgLTpmFuBXwwsALh

iTRyjJul0xCnOxQGPosoNoQrqUvlNJHVumtv5cn8PcCmSedknfqlTz4UfIdRBwhttjADZotmKhi3

lL9sqU+GaY2whx8RyeZQzedU1yyyilWV9V3t0N7OSBuXDk+Uxyycy3wcpMfd/IRyXHLlDBXSMFU6

tikyJaxO67lMRxFo+H/VyksQwvYa/UJ/jJoVCWksLC51daXGq4J5otFtkpm0/n/XwW3K9Yuqz7E1

wb5jhn4+2MR+QYswNEOMCwCFFKdBqAjXuYvYDtmV1Y/ICqk4s4MAhQpUS2EfPdZuI0fWLUWWr1/o

/W3Pg==X02hd' WHERE id= 10001;

 

 

---------- 

We still have the previous license key:

 

| 10000 | AAABnw0ODAoPeNp9kUtv2zAQhO/8FQR6aQ8ULBl2awME6kgMoMKP1LITIOiFpdYxW4kSlpTb/PtSD6MO4uQmisud+WY+7I4NzaCmUUTD8XwymodjGic7Go3CKXlCAHOs6howWGoFxoLItdOV4WK9E9u7bZoJsm7Kn4Cbw94CWs5CElfGSeXWsgQeH1FbequhyMkvjTJ4NX3XoDpKC4l0wFtZFoYsisgguHuuod+0Wa3ENk4Xy/OV+FtrfO7eNabQpXaQn8XFSuqCq1Y9OLTqX600uba/A1WVJAM8AaYJX9w+3LDH6WzC9uniO7uf3Tz2Nmus8ka5oD0wWx3cH4kQ+MX6BNxhA/3Y26lcye4airdpHBhp1CWOj+HzEMM7bl5FOeh4rmWaZGLNotFk8mU6I/6bX57fWZo5iQ6QH2RhgWzwSRptZUeXSZP4BEmM0P3439hoxqIxKXr5e++mHY9eZAAeE2tfxxBfAlahrrvF39LtgmaDA/qxb+cT3Z9LpR3hjzmNq7IEVFoWdGDtUd7q5Vril6Yu34mTLJoetGf/BwjnEuQwLAIUWcdUkR2oof+Co3TZTqelblZ+8fYCFG78SeScXF71k0IRbsFKeQfdMdz6X02k0 |

 

=================

The good key:

AAABYQ0ODAoPeNqVkT1vwjAQhnf/Cktd2iFRghpASJGKklSiAlIR2i5dXHMBQ2xHZ4ePf18nhKodO

3jx3T1+7vXdetfQnFsaRDQYT6LxJIxokq7pIAhHZNnIL8C8fDOAJh4EQUBSMBxFbYVW8ctsNaULY

Tj90HgoK32i2dmCMq5oaKmRdh33BeAR8IG2ANqxPic00VICcsEqOhfcDQFJEFgLTpmFuBXwwsALh

iTRyjJul0xCnOxQGPosoNoQrqUvlNJHVumtv5cn8PcCmSedknfqlTz4UfIdRBwhttjADZotmKhi3

lL9sqU+GaY2whx8RyeZQzedU1yyyilWV9V3t0N7OSBuXDk+Uxyycy3wcpMfd/IRyXHLlDBXSMFU6

tikyJaxO67lMRxFo+H/VyksQwvYa/UJ/jJoVCWksLC51daXGq4J5otFtkpm0/n/XwW3K9Yuqz7E1

wb5jhn4+2MR+QYswNEOMCwCFFKdBqAjXuYvYDtmV1Y/ICqk4s4MAhQpUS2EfPdZuI0fWLUWWr1/o

/W3Pg==X02hd

 

1 answer

This widget could not be displayed.

I take it you're following the steps in this KB:

https://confluence.atlassian.com/jirakb/how-to-get-and-update-jira-license-string-from-the-database-441746313.html

I see in your steps that your old license had an id value of 10000 when you follow step #2 of that KB.  However for your update SQL statement for step #3 you entered a value of 10001.  That's why you still see the old license key.   Instead I believe your update statement's where clause should have been referring to the id value of 10000 instead of 10001.

... and from this moment forward, Andrew, you shall be known as 'Hawk-eye'.  good catch

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

220 views 3 0
Join discussion

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