RedmineReceivingEmails and the cronjob

[Inkimar]

Following the guide here:
http://www.redmine.org/projects/redmine/wiki/RedmineReceivingEmails
Using the approach 'fetching emails from an IMAP server' and that is working great.
My project is here: https://github.com/DINA-Web/redmine-docker/tree/task760
I have created a script with the 'rake'-command to harvest my mailbox : receive_imap.sh with the following content

#!/bin/bash
source .env
echo "Mail $(date)" >>/var/log/cron-mail.log 2>&1 && rake -f /usr/src/redmine/Rakefile redmine:email:receive_imap RAILS_ENV=production host=imap.gmail.com port=993 ssl=1 username=$user password=$psw project=myproject tracker=Support

The user and the psw are in the .env-file
running the script manually works fine and an issue is created in my project 'myproject'.

The entry in the crontab (root account ) is like this >
* * * * * /usr/src/redmine/mail-script/receive_imap.sh

For the sake of testing I am running it right now every minute.
The only thing that I am seeing is the /var/log/cron-mail.log - no 'harvesting of my mailbox'.

Summary
Being new to Ruby.
One thing I see is that the crontab cannot find the environment for Ruby, it says it cannot find rake version 12.
As I understand this, this question boils down to 'the environment variables are not present with me when running crontab' - I tried to copy every environmental variable for root to a file and running source on that file when starting the script, but this does not help.

regards, Ingimar

[kebyn]

@yosifkit Hello, this docker does not have a planned mission environment, so
http://www.redmine.org/projects/redmine/wiki/RedmineReminderEmails
can not be done , I need your help, thank you very much .

[ToniIltanen]

I have the same issue, any progress on this?

[maximkrusina]

Yep, need some nice way to add cron jobs! E-mail fetfer and regular notifications...

[flantel]

Hi

I have just done this using the rufus-scheduler method and it appears to work fine.

It requires that you create your own Docker image, but really this is required if you are adding any plugins or to configure your outbound email settings.

My Dockerfile looks like this:

FROM redmine:3.4

ENV TZ=Europe/Dublin
RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone

WORKDIR /usr/src/redmine
COPY plugins plugins/
COPY configuration.yml config/configuration.yml
RUN gem install rufus-scheduler
COPY getmail.rb config/initializers/getmail.rb
RUN echo "gem 'rufus-scheduler'" >> Gemfile
RUN bundle install --without development test 

The getmail.rb then configures rufus-scheduler:

require 'rubygems'
require 'rake'
require 'rufus-scheduler'

load File.join(Rails.root, 'Rakefile')

ENV['host']='imap.gmail.com'
ENV['port']='993'
ENV['ssl']='SSL'
ENV['username']='user@example.com'
ENV['password']='mypassword'
ENV['project']='support'

scheduler = Rufus::Scheduler.new
# Check emails every 10 mins
scheduler.interval '10m' do
  task = Rake.application['redmine:email:receive_imap']
  task.reenable
  task.invoke 
end

In the getmail.rb, you can set any of the receive email parameters using ENV , like default-group and project_from_subaddress, etc.

Hope this helps.

-Barry Flanagan

[maximkrusina]

Hi everybody, finally I decided to handle all cron jobs via another external container, here is something interesting: http://deck-chores.readthedocs.io/en/stable/index.html

Why? Coz our production server is getting more and more containers I need one centralized place for managing cron jobs. One, place, easy to read and configure, no need to manually adjust each of the containers.

[michael-fuchs]

I used @flantel 's approach with the rufus-scheduler using the docker image for redmine 4.0. I had the issue that Redmine:IMAP was not found and I got following ruby error:

rufus-scheduler intercepted an error:
redmine_1               |   47305684005800   job:
redmine_1               |   47305684005800     Rufus::Scheduler::EveryJob "30s" {}
redmine_1               |   47305684005800   error:
redmine_1               |   47305684005800     47305684005800
redmine_1               |   47305684005800     NameError
redmine_1               |   47305684005800     uninitialized constant Redmine::IMAP

Same with POP3.
I solved this by an additional import in the rufus-scheduler script (getmail.rb in the example above):
require 'redmine/imap.rb'

[lmoellendorf]

If you do not want to create your own Docker image you could also add a cronjob on the host.

Create the script /home/user/docker/redmine/receive_imap.sh with the content below:

#!/bin/bash
docker container exec -i docker_redmine_1 rake -f /usr/src/redmine/Rakefile redmine:email:receive_imap RAILS_ENV="production" host=imap.yourmail.org username=redmine@yourmail.org password=secret starttls=1 >> /tmp/receive_imap.log 2>&1

Where docker_redmine_1 is your container's name which you can retrieve using docker container ls

Make the script executable:

chmod u+x /home/user/docker/redmine/receive_imap.sh

Edit the crontab of the user which is running the container:

crontab -e

...and add this line to execute your script

* * * * * /home/user/docker/redmine/receive_imap.sh >> /tmp/cron.log 2>&1

This will execute every minute.

[rafaelteb]

Hi there!
Im having an issue in this line I think. Im getting pretty crazy currently. Got the feeling that I miss something really simple :D
Would be very thankful for any help.
Maybe I should add rufus to a Dockerfile like its done above?

Currently wanted to setup with cron. But Im constantly getting this error:

rake aborted! OpenSSL::SSL::SSLError: SSL_connect returned=1 errno=0 state=error: certificate verify failed (unable to get local issuer certificate)

Opened this issue on this subject: #232

[EchedelleLR]

#64 (comment)

If you do not want to create your own Docker image you could also add a cronjob on the host.

I am unsure this would work if the container is inside a Kubernetes cluster which could change machine in each restart or, mostly, if the cluster is managed in the cloud such as ECS by AWS.