How can I deactivate an add-on by command line?

[Begoña Bonet]

Hi,

We have problems because after activating a plugin (Subversion plugin ALM) it has stated to indexing repositories and JIRA interface keeps locked for users. Thus we can't access as administrator to add-on management option to deactivate it.

It's possible to deactivate an add-on from command line?

Thanks

Begoña

[Boris Berenberg · Accepted solution]

You can shut down JIRA, then remove the add-on from the <JIRA HOME>/plugins/installed-plugins folder.

[Begoña Bonet]

Thanks Boris! It worked!

[Trevor Hunt]

A new, better solution is to disable via the command line as outlined in this article. This is particularly useful when restoring a dev instance from a prod backup.

[Andriy Yakovlev [Atlassian]]

Another method, more complex:
(!) Always backup your data before performing any modification to the database. If possible, try your modifications on a test server.

1. Execute SQL query and find your plugin key

   SELECT * FROM pluginversion where pluginname like '%text%';

2. Execute SQL query and disable plugin:

   INSERT into pluginstate (pluginkey, pluginenabled) VALUES ('<pluginkey from query above>','false');

3. Restart JIRA

[Suyash Jain]

Hi,

I can't locate table pluginversion in Confluence 5.8.4 as well as the latest v6.2.3. Has the approach changed or the table names are changed.

Thanks

Suyash