Redmine¶

gem install rails -v=2.3.14
gem install i18n -v=0.4.2
gem install rack -v=1.1.1 or
gem install rack -v=1.1.2
gem install postgres-pr

apt-get install postgresql postgresql-server-dev-all apache2 subversion rake ruby-dev rubygems librmagick-ruby libopenssl-ruby libpgsql-ruby libapache2-mod-passenger imagemagick libmagickwand-dev libxslt-dev libxml2-dev
gem install -v=3.2.13 rails
gem install -v=2.35.1 selenium-webdriver
gem install rmagick
gem install -v=2.0.2 jquery-rails
gem install -v=1.0.9 coderay
gem install -v=1.5.0 fastercsv
gem install -v=3.0.0 builder
gem install -v=0.3.1 net-ldap
gem install -v=2.3.0 ruby-openid
gem install rack-openid
gem install pg
gem install yard
gem install -v=3.3.2 shoulda
gem install redcarpet
gem install -v=0.13.3 mocha
gem install -v=2.0.0 capybara
gem install -v=1.5.9 nokogiri

su postgres
psql
postgres=# CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD 'redmine' NOINHERIT VALID UNTIL 'infinity';
postgres=# CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine TEMPLATE template0;
postgres=# \q
exit

cd /tmp
svn co http://redmine.rubyforge.org/svn/branches/2.3-stable redmine-2.3
mv redmine-2.3/ /var/lib/redmine
cd /var/lib/redmine

echo "production:
 adapter: postgresql
 database: redmine
 host: localhost
 port:
 username: redmine
 password: redmine
 encoding: utf8
 schema_search_path: public" > config/database.yml

bundle install --without test production
rake generate_secret_token
RAILS_ENV=production rake db:migrate
RAILS_ENV=production rake redmine:load_default_data
ln -s /var/lib/redmine/public /var/www/redmine
chown -R www-data:www-data /var/www/redmine
chmod -R 777 files log tmp public/plugin_assets
echo "RailsBaseURI /redmine" > /etc/apache2/sites-available/redmine
a2ensite redmine
/etc/init.d/apache2 restart

production:
    delivery_method: :smtp
    smtp_settings:
        address: srvxxxx1
        port: 25
        domain: myprop-group.com
        authentication: :login
        user_name: "informatiquepz"
        password: "informatique"

version = '0.1'
author = 'Frederic Aoustin'
description = 'generate data for open flash chart'

class Chart:

    def __init__(self, file, cursor):
        try:
            self._desc = cursor.description
            self._data = cursor.fetchall()
            self._file = open(file,'w')
        except Exception as e:
            raise Exception, 'Error in chart, %s' % e

    def generate(self):
        pass

class PieChart(Chart):
    """cursor:
    |   |title|
    |lb1|val1 |
    |lb2|val2 |
    |lb3|val3 |
    """

    txt = """&bg_colour=#FDFDFD&
&pie=60,#505050,{font-size: 12px; color: #404040;}&
&values=%(values)s&
&pie_labels=%(labels)s&
&colours=#5E83BF,#C11B01,#D2D2FB,#B0C101,#d01f3c,#356aa0,#C79810,#80a033,#9933CC,#CC3399&
"""

    def __init__(self, file, cursor):
        Chart.__init__(self, file, cursor)

    def generate(self):
        id = {}
        id['labels'] = ','.join([str(item[0]) for item in self._data])
        id['values'] = ','.join([str(item[1]) for item in self._data])
        self._file.write(self.txt % id)
        self._file.close()

class BarSketchChart(Chart):
    """cursor:
    |   |y1  |y2  |
    |lb1|val1|val4|
    |lb2|val2|val5|
    |lb3|val3|val6|
    """
    txt = """&x_label_style=11,#303030,2&
&y_label_style=11,#303030&
&y_ticks=0,10,1&
&x_labels=%(labels)s&
&y_min=0&
&y_max=%(max_value)s&
&bg_colour=#FDFDFD&
&x_grid_colour=#FDFDFD&
&y_grid_colour=#FDFDFD&
"""
    txt2 = """&bar_sketch%(cnt)s=55,6,%(color)s,#000000,%(name)s,10&
&values%(cnt)s=%(values)s&
"""
    color = ["#5E83BF","#9933CC","#80a033","#C11B01","#CC3399","#D2D2FB","#B0C101","#d01f3c","#356aa0","#C79810","#80a033","#9933CC","#CC3399"]

    def __init__(self, file, cursor):
        Chart.__init__(self, file, cursor)

    def generate(self):
        id = {}
        id['labels'] = ','.join([str(item[0]) for item in self._data])
        ln = len(self._desc)-1
        m = []
        for i in self._data:
            for j in i[1:]:
                m.append(j)
        id['max_value'] = max(m)
        st = self.txt % id
        k=1
        for i in range(1,ln+1):
            id = {}
            id['values'] = ','.join([str(item[i]) for item in self._data])
            id['name'] = self._desc[i][0]
            id['color'] = self.color[i]
            id['max_value'] = max(m)
            if k == 1:
                id['cnt'] = ''
            else:
                id['cnt']='_%s' % k
            st = st + self.txt2 % id
            k = k+1
        self._file.write(st)
        self._file.close()

class BarGlassChart(BarSketchChart):
    """cursor:
    |   |y1  |y2  |
    |lb1|val1|val4|
    |lb2|val2|val5|
    |lb3|val3|val6|
    """
    txt2 = """&bar_glass%(cnt)s=55,%(color)s,,%(name)s,10&
&values%(cnt)s=%(values)s&
"""

    def __init__(self, file, cursor):
        BarSketchChart.__init__(self, file, cursor)

class LineHollowChart(BarSketchChart):
    """cursor:
    |   |y1  |y2  |
    |lb1|val1|val4|
    |lb2|val2|val5|
    |lb3|val3|val6|
    """
    txt2 = """&line_hollow%(cnt)s=2,%(color)s,%(name)s,10,4&
&values%(cnt)s=%(values)s&
"""

    def __init__(self, file, cursor):
        BarSketchChart.__init__(self, file, cursor)

class AreaHollowChart(BarSketchChart):
    """cursor:
    |   |y1  |y2  |
    |lb1|val1|val4|
    |lb2|val2|val5|
    |lb3|val3|val6|
    """
    txt2 = """&area_hollow%(cnt)s=2,3,25,%(color)s,%(name)s,10,%(color)s&
&values%(cnt)s=%(values)s&
"""

    def __init__(self, file, cursor):
        BarSketchChart.__init__(self, file, cursor)

import psycopg2
import pyofc

link = {'query1':{
                    'con' : "dbname='redmine_default' host='127.0.0.1' port=5432 user='postgres' password='postgres'",
                    'query':"""SELECT MOIS,
CREATED ,
TERMINATED,
(SELECT SUM(B.CREATED) FROM ZZ_SYNTHESE_MOIS AS B WHERE  B.MOIS <= A.MOIS) - (SELECT SUM(B.TERMINATED) FROM ZZ_SYNTHESE_MOIS AS B WHERE  B.MOIS <= A.MOIS) AS OPEN
FROM ZZ_SYNTHESE_MOIS AS A
""",
                    'chart':'LineHollowChart',
                    'file':'/usr/share/redmine/public/graph1.txt'
                 },
        'query2':{
                    'con' : "dbname='redmine_default' host='127.0.0.1' port=5432 user='postgres' password='postgres'",
                    'query':"""
SELECT WEEK,
CREATED ,
TERMINATED,
(SELECT SUM(B.CREATED) FROM ZZ_SYNTHESE_WEEK AS B WHERE  B.WEEK <= A.WEEK) - (SELECT SUM(B.TERMINATED) FROM ZZ_SYNTHESE_WEEK AS B WHERE  B.WEEK <= A.WEEK) AS OPEN
FROM ZZ_SYNTHESE_WEEK AS A""",
                    'chart':'LineHollowChart',
                    'file':'/usr/share/redmine/public/graph2.txt'
                 },
        'query3':{
                    'con' : "dbname='redmine_default' host='127.0.0.1' port=5432 user='postgres' password='postgres'",
                    'query':"""select * from (select
projects.name AS PROJECT,
count(*) *100 / (select count(*) from issues where to_char(issues.created_on, 'YYYY/WW')  > to_char(current_timestamp - interval '12 weeks', 'YYYY/WW') )AS CREATED
from issues, projects
WHERE issues.project_id = projects.id
and to_char(issues.created_on, 'YYYY/WW')  > to_char(current_timestamp - interval '12 weeks', 'YYYY/WW')
group by projects.name) as A where CREATED >0""",
                    'chart':'PieChart',
                    'file':'/usr/share/redmine/public/graph3.txt'
                 },
        'query4':{
                    'con' : "dbname='redmine_default' host='127.0.0.1' port=5432 user='postgres' password='postgres'",
                    'query':"""select * from (select
projects.name AS PROJECT,
count(*) *100 / (select count(*) from issues where to_char(issues.created_on, 'YYYY/MM')  > to_char(current_timestamp - interval '12 months', 'YYYY/MM') )AS CREATED
from issues, projects
WHERE issues.project_id = projects.id
and to_char(issues.created_on, 'YYYY/MM')  > to_char(current_timestamp - interval '12 months', 'YYYY/MM')
group by projects.name) as A where CREATED > 0""",
                    'chart':'PieChart',
                    'file':'/usr/share/redmine/public/graph4.txt'
                 },
        }

for i in link.keys():
    connect = psycopg2.connect(link[i]['con'])
    cursor = connect.cursor()
    cursor.execute(link[i]['query'])
    if link[i]['chart']=='PieChart':
        pyofc.PieChart(link[i]['file'],cursor).generate()
    if link[i]['chart']=='BarSketchChart':
        pyofc.BarSketchChart(link[i]['file'],cursor).generate()
    if link[i]['chart']=='BarGlassChart':
        pyofc.BarGlassChart(link[i]['file'],cursor).generate()
    if link[i]['chart']=='LineHollowChart':
        pyofc.LineHollowChart(link[i]['file'],cursor).generate()
    if link[i]['chart']=='AreaHollowChart':
        pyofc.AreaHollowChart(link[i]['file'],cursor).generate()
    cursor.close()
    connect.close()

<div class="splitcontentright">
<div id="nagiosinfo"></div>
<br/>
<table>
<tr><td></td><td>sur les 12 dernieres semaines</td></tr>
<tr><td>
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000"
  codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0"
  width="400" height="280" id="graph-3" align="middle">
<param name="allowScriptAccess" value="sameDomain" />
<param name="movie" value="open-flash-chart.swf?data=graph4.txt" />
<param name="quality" value="high" />
<!-- for firefox, nescape-->
<embed src="open-flash-chart.swf?data=graph4.txt" width="400" height="280"
  allowScriptAccess="sameDomain" align="middle" quality="high"/>
</object>
</td><td>
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000"
  codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0"
  width="400" height="280" id="graph-3" align="middle">
<param name="allowScriptAccess" value="sameDomain" />
<param name="movie" value="open-flash-chart.swf?data=graph2.txt" />
<param name="quality" value="high" />
<!-- for firefox, nescape-->
<embed src="open-flash-chart.swf?data=graph2.txt" width="400" height="280"
  allowScriptAccess="sameDomain" align="middle" quality="high"/>
</object>
</td></tr>
<tr><td></td><td>Sur les 12 derniers mois</td></tr>
<tr><td>
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000"
  codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0"
  width="400" height="280" id="graph-3" align="middle">
<param name="allowScriptAccess" value="sameDomain" />
<param name="movie" value="open-flash-chart.swf?data=graph3.txt" />
<param name="quality" value="high" />
<!-- for firefox, nescape-->
<embed src="open-flash-chart.swf?data=graph3.txt" width="400" height="280"
  allowScriptAccess="sameDomain" align="middle" quality="high"/>
</object>
</td><td>
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000"
  codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0"
  width="400" height="280" id="graph-3" align="middle">
<param name="allowScriptAccess" value="sameDomain" />
<param name="movie" value="open-flash-chart.swf?data=graph1.txt" />
<param name="quality" value="high" />
<!-- for firefox, nescape-->
<embed src="open-flash-chart.swf?data=graph1.txt" width="400" height="280"
  allowScriptAccess="sameDomain" align="middle" quality="high"/>
</object>
</td></tr>
</table>

</div>

<% content_for :header_tags do %>
<%= auto_discovery_link_tag(:atom, {:controller => 'news', :action => 'index', :key => User.current.rss_key, :format => 'atom'},
                                   :title => "#{Setting.app_title}: #{l(:label_news_latest)}") %>
<%= auto_discovery_link_tag(:atom, {:controller => 'projects', :action => 'activity', :key => User.current.rss_key, :format => 'atom'},
                                   :title => "#{Setting.app_title}: #{l(:label_activity)}") %>
<% end %>


<% content_for :header_tags do %>
<%= auto_discovery_link_tag(:atom, {:controller => 'news', :action => 'index', :key => User.current.rss_key, :format => 'atom'},
                                   :title => "#{Setting.app_title}: #{l(:label_news_latest)}") %>
<%= auto_discovery_link_tag(:atom, {:controller => 'projects', :action => 'activity', :key => User.current.rss_key, :format => 'atom'},
                                   :title => "#{Setting.app_title}: #{l(:label_activity)}") %>
<% end %>

su - postgres -c "pg_dump redmine_default" > redmine_default.sql
tar -cjf redmine_db.tar.gz redmine_default.sql
tar -cjf redmine_varlib.tar.gz /var/lib/redmine
tar -cjf redmine_usrshare.tar.gz /usr/share/redmine
smbclient //myservdev/REDMINE -U administrateur%Numeid@1525$ -c 'put redmine_db.tar.gz'
smbclient //myservdev/REDMINE -U administrateur%Numeid@1525$ -c 'put redmine_varlib.tar.gz'
smbclient //myservdev/REDMINE -U administrateur%Numeid@1525$ -c 'put redmine_usrshare.tar.gz'
su - postgres -c "vacuumdb --full --analyze redmine_default"