Manage JIRA server license using the database queries with ease.

At Bobcares, we offer solutions for every query, big and small, as a part of our Server Management Service.

Let’s take a look at how our Support Team recently helped a customer manage JIRA server license using database queries.

How to manage JIRA server license using the database queries

If you are looking for a way to extract the JIRA license key from the database, the following SQL will come in handy:

SELECT propertyvalue AS license 
FROM   propertytext pt 
       JOIN propertyentry pe 
         ON pt.id = pe.id 
WHERE  property_key = 'License20';

According to our Support Team, the following command works for JIRA 7.0.5 and above:

SELECT * FROM productlicense;

We can also update the license with database queries. However, our experts do not recommend that unless doing it via JIRA AGILE. Furthermore, updating the license via database queries may also result in data integrity problems or even data corruption.

Our Support Engineers recommend taking a backup of your JIRA database before proceeding with the steps below:

1. First, we have to stop JIRA.
2. Then, we will execute the command below in order to locate the ID which we will be modifying:

   For JIRA 7.0.4 and above:

   SELECT * FROM productlicense;

   For JIRA 7.0.4 and below:

   SELECT pt.id 
   FROM   propertytext pt 
          JOIN propertyentry pe 
            ON pt.id = pe.id 
   WHERE  property_key = 'License20';
3. After that we will update the license with these commands:

   For JIRA 7.0.4 and above:

    update productlicense set license ='' WHERE id= ;

   For JIRA 7.0.4 and below:

   UPDATE propertytext SET propertyvalue = '<license_string>' WHERE id = <id_from_step_2>;
4. Finally, we will start JIRA for the changes to take effect.

[Need for a solution to another query? We are just a click away.]

Conclusion

In brief, the skilled Support Engineers at Bobcares demonstrated how to update or modify the JIRA license through database queries.