Is there a way to insert or update a Jira licence with Ansible?

Question

Can I in some way insert a JIRA licence with Ansible when i install or upgrade Jira?

thebro · Answer

Actually, for those of us who landed on this page but have JIRA 8.0+, the licence is indeed in the "productlicense" table, as stated here (changed since 7.0.5 and above):

https://confluence.atlassian.com/jirakb/manage-jira-server-license-using-database-queries-441746313.html

But I also have no clue yet what ID from the "productlicense" table is referencing, as it does not look like it references "propertyentry" table. The above link is not helpful about the ID column at the moment.

I had three rows and this is the ID to Application mapping that worked for me on my server:

10300 -> JIRA Core
10301 -> JIRA Service Desk
10302 -> JIRA Software

Tim · Answer

Here is your license:

select propertyvalue from propertytext where ID in (select id from propertyentry where property_key = 'License20');

as stated in https://answers.atlassian.com/questions/158813

Jerker Montelius · Answer

Well no.

No, I found that there esist a table "productlicense" where the licence ends up.

I have no idea how to use it.

id , licence

?