jira修改license

If for whatever reason the JIRA license key needs to be extracted from the database, it can be done with the following SQL:

1
2
3
4
5

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

(info) This is tested on PostgreSQL and may need modifying for other DBMS such as Oracle or SQL Server.

For JIRA 7.0.5 and above:

1

SELECT * FROM productlicense;

Updating the License
The license can be updated as per Specifying your License Details. If this does not work, it is possible to do so with an update to the database however it is not recommended. This is because it can cause data integrity problems and may lead to data corruption. If you choose to do this please keep in mind we may be unable to provide support.

Always back up your data before performing any modification to the database. If possible, try your modifications on a test server.

Stop JIRA.
Execute the following to locate the ID to modify:

JIRA 7.0.4 and below

1
2
3
4
5

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

JIRA 7.0.4 and above

1

SELECT * FROM productlicense;

Update the license with the following:

JIRA 7.0.4 and below

1

UPDATE propertytext SET propertyvalue = '<license_string>' WHERE id = <id_from_step_2>;

JIRA 7.0.4 and above

1

update productlicense set license ='<license_string>' WHERE id= <id_from_step_2>;

Start JIRA.