I've added a module in redmine, how can I enable it for many projects at once?

Question

I've got all these great new plugins enabled, and I can enable them on any given project.

However, I don't see a way to add/remove them from many projects at once.

Perhaps I need a module management plugin? ;-)

Answer 1

In my case Redmine 3.1.0 and MySQL is used as DB server. I think, you'll get the main idea in case of other confuguration.

DELETE FROM `enabled_modules` WHERE `name` = 'module_name_here';
INSERT INTO `enabled_modules` 
    (`project_id`, `name`) 
SELECT 
    `id`, 'module_name_here' 
FROM 
    `projects`

You can activate module for one project to discover its name from enabled_modules. Or you can find it in plugin sources, it should look like 'project_module :module_name_here'

Please, don't do this if you do not completely understand, what is this answer about!

PS: Yes, I know - it is a dirty solution, but it's fast and easy enough for operation which is neccesary once a year or less.