Project

General

Profile

Actions

Task #1417

closed

Add Cron Job to make "Redmine Issue Reminder plugin" working

Added by Luca Frosini over 9 years ago. Updated about 9 years ago.

Status:
Closed
Priority:
Normal
Category:
System Application
Target version:
Start date:
Nov 18, 2015
Due date:
Nov 23, 2015
% Done:

100%

Estimated time:
Infrastructure:
Production

Related issues

Related to D4Science Infrastructure - Incident #1874: Redmine automatic update reminders spamming ClosedLuca FrosiniJan 04, 2016Jan 05, 2016

Actions
Actions #1

Updated by Luca Frosini over 9 years ago

  • Due date set to Nov 27, 2015
  • Status changed from New to In Progress
  • Assignee changed from Andrea Dell'Amico to Luca Frosini

I'm going to implement this strategy to test it.
I'll delete from any project the reminder.
I'll add a reminder only on DTEAM project.
For that project I'll create tasks which will respect the reminder (One for me, one for @pasquale.pagano@isti.cnr.it and one for @andrea.dellamico@isti.cnr.it ).
We will receive the emails so we can check them. If we are satisfied I'll take care or adding back the reminder in different projects.
For the moment, I'm going to take in charge this ticket.

Actions #2

Updated by Luca Frosini over 9 years ago

  • Due date changed from Nov 27, 2015 to Nov 23, 2015
  • Assignee changed from Luca Frosini to Andrea Dell'Amico
  • % Done changed from 0 to 30

I have created tickets #1472 #1473 #1474 to test it. The due date is on 25/11/2015.
I have also added the reminder when the due date is one day.
@andrea.dellamico@isti.cnr.it I'll reassign the ticket to you. You can create the job to test it. If you add the cron before 23/11/2015 I'll change the due date earlier.

Actions #3

Updated by Luca Frosini over 9 years ago

Just a clarification fro @pasquale.pagano@isti.cnr.it The query are the query available for the project and used in gant and issue tabs. So we can create any query we want.

Actions #4

Updated by Andrea Dell'Amico over 9 years ago

I'm going to add the cron job on monday.

Actions #5

Updated by Luca Frosini over 9 years ago

Perfect. Thank you.

Actions #6

Updated by Andrea Dell'Amico over 9 years ago

  • Status changed from In Progress to Feedback
  • % Done changed from 30 to 100

Cron job added, it will run each morning at 5am.

Actions #7

Updated by Pasquale Pagano over 9 years ago

will it work for all projects?

Actions #8

Updated by Luca Frosini over 9 years ago

We will see tomorrow after 5 am.
Actually the reminder has been removed in all project except in DTEAM where I created the test tickets.

Actions #9

Updated by Luca Frosini over 9 years ago

  • Status changed from Feedback to In Progress
  • % Done changed from 100 to 80

The plugin seems not working. I created tickets, tryed different query and reminder in DTEAM project but I didn't receive any email.

Actions #10

Updated by Andrea Dell'Amico over 9 years ago

The cron job failed, the command was executed with the wrong options.

I'm going to run it manually in a couple of minutes.

Actions #11

Updated by Andrea Dell'Amico over 9 years ago

The manual execution went well. Did you receive any message?

Actions #12

Updated by Luca Frosini over 9 years ago

No, but There were no tickets matching the conditions. Let me modify the due date of testing ticket. When ready can you try to run the cron job again?

Actions #13

Updated by Andrea Dell'Amico over 9 years ago

Manually, even now.

Actions #14

Updated by Luca Frosini over 9 years ago

Due dates changed.
I set two type of reminder. Let's see what happen.
Can you please retry now?

Actions #15

Updated by Andrea Dell'Amico over 9 years ago

I just run it but I didn't see any output. It's possible that the execution date is saved in the db, so we need to wait until tomorrow evening and run it again.

Actions #16

Updated by Luca Frosini over 9 years ago

Ok I'll postpone the due date to the day after tomorrow.

Actions #17

Updated by Luca Frosini over 9 years ago

I didn't receive any email. The plugin seems not working or not configured properly (maybe I made some mistake).

Actions #18

Updated by Andrea Dell'Amico over 9 years ago

The plugin log output is clean, no errors have been reported. It just reported the list of users potentially involved:

andrea.dellamico@isti.cnr.it
luca.frosini@isti.cnr.it
tommaso.piccioli@isti.cnr.it
pasquale.pagano@isti.cnr.it
monja.dariva@isti.cnr.it
massimiliano.assante@isti.cnr.it
leonardo.candela@isti.cnr.it
g.panichi@isti.cnr.it
fabio.sinibaldi@isti.cnr.it
francesco.mangiacrapa@isti.cnr.it
gianpaolo.coro@isti.cnr.it
lucio.lelii@isti.cnr.it
valentina.marioli@isti.cnr.it
roberto.cirillo@isti.cnr.it
costantino.perciante@isti.cnr.it
Actions #19

Updated by Andrea Dell'Amico over 9 years ago

An alternative could be a different issues reminder plugin that's installed on the Openaire redmine. That one works but it is less configurable: the configuration is global so it applies equally to all the projects. You can see the configuration options here: https://issue.openaire.research-infrastructures.eu/settings/plugin/redmine_update_reminder

Actions #20

Updated by Andrea Dell'Amico over 9 years ago

Any opinion on this? do we want to remove the plugin?

Actions #21

Updated by Luca Frosini over 9 years ago

We can remove the plugin and use the one used by DNET (I can't access to DNET Redmine so I didn't see the configuration, but better than nothing)

Actions #22

Updated by Andrea Dell'Amico over 9 years ago

I can give you access to see if it fits with the workflow.

Actions #23

Updated by Luca Frosini over 9 years ago

There is a global (for all project) configuration for each tracker type. This is acceptable.
Moreover we need an user that receive all reminder too.
We can configure a email which discard all messages (I can provide one behaving like this) or use the one of @pasquale.pagano@isti.cnr.it which is interested to receive it.

Actions #24

Updated by Andrea Dell'Amico over 9 years ago

  • Status changed from In Progress to Feedback
  • % Done changed from 80 to 100

The new plugin has been installed. You can configure it from here: https://support.d4science.org/settings/plugin/redmine_update_reminder
Let me know when you're done, I've disabled the cron job that sends the emails in the meantime.

Actions #25

Updated by Luca Frosini over 9 years ago

I just configured the plugin. @pasquale.pagano@isti.cnr.it is the victim of receiving all the email in CC.
https://support.d4science.org/settings/plugin/redmine_update_reminder
@andrea.dellamico@isti.cnr.it can run the cron job?

Actions #26

Updated by Andrea Dell'Amico over 9 years ago

The cron job is now active, it will run for the first time tomorrow at 5AM.
A not so welcome Christmas present, I suppose :).

Actions #27

Updated by Luca Frosini over 9 years ago

:D

Actions #28

Updated by Andrea Dell'Amico over 9 years ago

  • Related to Incident #1874: Redmine automatic update reminders spamming added
Actions #29

Updated by Pasquale Pagano over 9 years ago

@massimiliano.assante@isti.cnr.it please provide your feedback here.

IMHO the reminder should notify a user if

  • the ticket is approaching the due date
  • the ticket is belonging to specific trackers (not all trackers)
  • the last update time of the ticket is older than a week wrt the date of the notification.
Actions #30

Updated by Massimiliano Assante over 9 years ago

Pasquale Pagano wrote:

@massimiliano.assante@isti.cnr.it please provide your feedback here.

IMHO the reminder should notify a user if

  • the ticket is approaching the due date

yes, a week pehaps?

  • the ticket is belonging to specific trackers (not all trackers)

yes, incidents for sure then we should understand what other type of trackers, for sure not the release ones.

  • the last update time of the ticket is older than a week wrt the date of the notification.

what do you mean? That i should get an email reminder if i haven't reacted within a week time? (After the ticket was assigned to me)

Actions #31

Updated by Andrea Dell'Amico over 9 years ago

The only available option is the interval from the last action on the ticket (any action, the ticket opening counts as an action) and the mail alert. Different intervals can be set for any tracker category. You are all administrators, you can see the configuration here: https://support.d4science.org/settings/plugin/redmine_update_reminder

Actions #32

Updated by Pasquale Pagano over 9 years ago

the interval from the last action on the ticket is acceptable.

Actions #33

Updated by Andrea Dell'Amico over 9 years ago

Any news on this one?

Actions #34

Updated by Luca Frosini over 9 years ago

No news. I don't know what to do. The plugin seems not working as expected even configured ad @pasquale.pagano@isti.cnr.it said.

Actions #35

Updated by Andrea Dell'Amico about 9 years ago

  • Status changed from Feedback to Closed

I'm disabling it for the time being.

Actions

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 8.91 MB)