DokuWiki

h1. Bitnami 3.0.3-0

h2. MySQL Redmine-Scripts

h3. Create MySQL-Reader-User

<pre><code class="sql">

mysql -u root -p

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

</code></pre>

h2. Troubleshoot imap

change @/opt/redmine-3.0.3-0/ruby/lib/ruby/2.0.0/net/imap.rb@ line ~1429

<pre><code class="ruby">

    def create_ssl_params(certs = nil, verify = true)

      params = {}

      if certs

        if File.file?(certs)

          params[:ca_file] = certs

        elsif File.directory?(certs)

          params[:ca_path] = certs

        end

      end

      if verify

      #  params[:verify_mode] = VERIFY_PEER

      #  taken out by JKE 2015-07-06

        params[:verify_mode] = VERIFY_NONE

      else

        params[:verify_mode] = VERIFY_NONE

      end

      return params

    end

</code></pre>

h2. setup log-rotating

h3. Redmine

The Bitnami-Stack does not preconfigure log-rotating for the @production.log@ located in @/opt/redmine-3.0.3-0/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-3.0.3-0/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-3.0.3-0/apps/redmine/htdocs/log/production.log', 7, 20971520)

config.logger.level = Logger::INFO

</code></pre>

<pre>

[root@redmine ~]# cd /opt/redmine-3.0.3-0/apps/redmine/htdocs/log/

[root@redmine log]# ll

total 1120

-rwxrwxr-x. 1 root   daemon      36 Jun 18  2012 delete.me

-rw-r--r--. 1 daemon daemon   12158 Jul  9 09:36 production.log

-rw-rw-r--. 1 root   daemon   30053 Jul  9 09:28 production.log.0

-rwxrwxr-x. 1 root   daemon 1093571 Jul  9 08:59 production.log.1

</pre>

h3. apache / mysql

let's use @logrotate@ for this task. There is @.conf@-files already shipped with the bitnami-stack.

<pre><code class="bash">

ln -s /opt/redmine-3.0.3-0/config/logrotate/logrotate.d/apache.conf /etc/logrotate.d/bitnami_3.0.3-0_apache.conf

ln -s /opt/redmine-3.0.3-0/config/logrotate/logrotate.d/mysql.conf /etc/logrotate.d/bitnami_3.0.3-0_mysql.conf

</code></pre>