DokuWiki

h1. Redmine bitnami 2 5 2 2

h1. Install

https://bitnami.com/stack/redmine/installer

h1. Migrate

http://wiki.bitnami.com/Applications/BitNami_Redmine

h1. Config

h2. setup email

add following parameter to @/opt/redmine-2.5.2-2/apps/redmine/htdocs/config/configuration.yml@

<pre><code class="ruby">

# about line 83

# default configuration options for all environments

default:

  # Outgoing emails configuration (see examples above)

  email_delivery:

    delivery_method: :smtp

    smtp_settings:

      address: "mail.example.com"

      port: 25

      domain: 'example.com'

      authentication: :login

      user_name: "redmine@example.com"

      password: "secret"

      enable_starttls_auto: true

      #openssl_verify_mode: 'none'

      #enable_starttls_auto: true

</code></pre>

h2. setup receiving email

add following shell-script to @/usr/local/bin/redmine_recv_mail.sh@

<pre><code class="bash">

#!/bin/sh

PATH="/opt/redmine-2.5.2-2/perl/bin:/opt/redmine-2.5.2-2/git/bin:/opt/redmine-2.5.2-2/sqlite/bin:/opt/redmine-2.5.2-2/ruby/bin:/opt/redmine-2.5.2-2/subversion/bin:/opt/redmine-2.5.2-2/postgresql/bin:/opt/redmine-2.5.2-2/php/bin:/opt/redmine-2.5.2-2/mysql/bin:/opt/redmine-2.5.2-2/apache2/bin:/opt/redmine-2.5.2-2/common/bin:$PATH"

/opt/redmine-2.5.2-2/ruby/bin/rake -f '/opt/redmine-2.5.2-2/apps/redmine/htdocs/Rakefile' redmine:email:receive_imap RAILS_ENV="production" ssl=1 host=mail.example.com port=993 username=redmine@example.com password=secret unknown_user=create no_permission_check=1 

</code></pre>

 this setup will accept mails from everyone and automagically register unknown users.

add following cron-file @/etc/cron.d/redmine_mail_recv@

<pre><code class="bash">

 */15 * * * * root /usr/local/bin/redmine_recv_mail.sh

</code></pre>

if you get an error about bundle you may want to try 

<pre><code class="bash">

cd /opt/redmine-2.5.2-2

./use_redmine

gem install rake -v 10.1.1

</code></pre>

if you get an error about SSL-certificate (self signed) you may bypass SSL-verify by adding this file to @/opt/redmine-2.5.2-2/apps/redmine/htdocs/config/initializers/avoid_ssl_verification.rb@

<pre><code class="ruby">

    require 'openssl'

    OpenSSL::SSL::VERIFY_PEER = OpenSSL::SSL::VERIFY_NONE

</code></pre>

h2. setup log-rotating

The Bitnami-Stack does not preconfigure log-rotating for the @production.log@ located in @/opt/redmine-2.5.2-2/apps/redmine/htdocs/log@. Although you could use the standard Logrotate it's recommended (http://www.redmine.org/boards/2/topics/11836) to use the Ruby-functionality. Add following parameter to @/opt/redmine-2.5.2-2/apps/redmine/htdocs/config/environments/production.rb@ and restart the Bitnami-Stack. 

According to http://www.redmine.org/issues/11603 you have to provide a file directly to @Logger.new@ instead of the sample in the @production.rb@.

<pre><code class="ruby">

# 7 log-files, 20MB each

config.logger = Logger.new('/opt/redmine-2.5.2-2/apps/redmine/htdocs/log/production.log', 7, 20971520)

config.logger.level = Logger::INFO

</code></pre>

<pre><code class="bash">

ll /opt/redmine-2.5.2-2/apps/redmine/htdocs/log/

</code></pre>

<pre><code class="bash">

total 1504

-rwxrwxr-x. 1 root   daemon      36 Jul  6 14:44 delete.me

-rw-r--r--. 1 daemon daemon    3295 Sep 20 10:55 production.log

-rwxrwxr-x. 1 root   daemon 1523773 Sep 20 10:52 production.log.0

</code></pre>

h2. setup Redmine-Logo

http://www.redmine.org/projects/redmine/wiki/Howto_add_a_logo_to_your_Redmine_banner

edit following file @/opt/redmine-2.5.2-2/apps/redmine/htdocs/app/views/layouts/base.html.erb@

<pre><code class="html">

#line 44

<h1><img src="<%= Redmine::Utils.relative_url_root %>/images/logo.png" style="top-margin: 15px; left-margin: 15px;"/> <%= page_header_title %></h1>

</code></pre>

copy @logo.png@ to @/opt/redmine-2.5.2-2/apps/redmine/htdocs/public/images@

h1. Nagging

There are a couple of plugins available, we are trying to do our own thing. 

h2. create a read only user

<pre><code class="sql">

mysql -u root -p

grant select on bitnami_redmine.* to 'redmine_reader'@'localhost';

</code></pre>

h2. create a sql-statement

http://www.redmine.org/projects/redmine/wiki/DatabaseModel

!Redmine_2_5_2_2_ER-databasemodel.png!

This statement lists all open issues from the project with the internal ID 33 and all sub-projects with a due-date earlier than today+7days. All issue-IDs will be click-able links in the nag-mail. 

<pre><code class="sql">

SELECT CONCAT('@@@1@http://www.example.com/redmine/issues/',_i.id,'@@@2@',_i.id,'@@@3@') AS ID,_is.name AS STATUS,_p.name AS Projekt ,LEFT(_i.subject,100) AS Thema,_i.due_date AS Zieldatum,_u.mail 

FROM (SELECT DISTINCT _b.id,_b.name 

      FROM (SELECT _p.name,_p.id 

            FROM projects AS _p 

            WHERE _p.id=33 OR _p.parent_id=33

           ) AS pp, projects AS _b 

      WHERE _b.parent_id=pp.id OR _b.id=33 ORDER BY _b.name

     ) AS _p,

     issues AS _i, 

     issue_statuses AS _is , 

     users AS _u 

WHERE _p.id = _i.project_id AND _i.status_id=_is.id AND _u.id=_i.assigned_to_id AND _is.is_closed=0 AND _i.due_date<=ADDDATE(curdate(),7) 

ORDER BY _p.name,_i.id;

</code></pre>

the funny @@@n@ groups are used later on.

h2. create a html-mail

create a little shell-sript @redmine_send_mail.sh@ that

* fetches the data from the database

* forms a valid html-mail

* sends the mail to one recipient

<pre><code class="bash">

#!/bin/sh

PATH="/opt/redmine-2.5.2-2/perl/bin:/opt/redmine-2.5.2-2/git/bin:/opt/redmine-2.5.2-2/sqlite/bin:/opt/redmine-2.5.2-2/ruby/bin:/opt/redmine-2.5.2-2/subversion/bin:/opt/redmine-2.5.2-2/postgresql/bin:/opt/redmine-2.5.2-2/php/bin:/opt/redmine-2.5.2-2/mysql/bin:/opt/redmine-2.5.2-2/apache2/bin:/opt/redmine-2.5.2-2/common/bin:$PATH"

#export List from DB

mysql -u redmine_reader -H -B bitnami_redmine < list.sql > /tmp/redmine_mysql_output

#replace special stuff

sed -i -e 's/@@@1@/<a href="/g' /tmp/redmine_mysql_output

sed -i -e 's/@@@2@/">/g' /tmp/redmine_mysql_output

sed -i -e 's/@@@3@/<\/a>/g' /tmp/redmine_mysql_output

echo 'Subject: weekly audit "all open issues due within the next 7 days"' > /tmp/redmine_mail_raw

echo 'to: user@example.com' >> /tmp/redmine_mail_raw

echo 'MIME-Version: 1.0' >> /tmp/redmine_mail_raw

echo 'Content-Type: text/html; charset=utf-8' >> /tmp/redmine_mail_raw

echo '' >> /tmp/redmine_mail_raw

echo '<html>' >> /tmp/redmine_mail_raw

echo '<meta http-equiv="Content-Type" content="text/html; charset=utf-8">' >> /tmp/redmine_mail_raw

#export List from DB

cat /tmp/redmine_mysql_output >> /tmp/redmine_mail_raw

echo '</html>' >> /tmp/redmine_mail_raw

#send mail

cat /tmp/redmine_mail_raw | sendmail -t

</code></pre>

h2. use cron to nag periodically

run the shell-script from above every monday at 8:00am. @/etc/cron.d/redmine_audit@

<pre><code class="bash">

# JKE 2014-10-22

#

# minute hour day month dayofweek

# m h d m d

# - - - - -

# | | | | |

# | | | | +-day of week (0-7) sunday=0 or 7

# | | | +---month (1-12)

# | | +-----day of month (1-31)

# | +-------hour (0-23)

# +---------min (0-59)

# 

	00	08	*	*	1	root	/usr/local/bin/redmine_send_mail.sh

</code></pre>