Project

General

Profile

Chiliproject » History » Version 2

Mehdi Abaakouk, 01/08/2013 10:39 PM

1 1 Mehdi Abaakouk
h1. Chiliproject
2 1 Mehdi Abaakouk
3 1 Mehdi Abaakouk
La machine chiliproject contient:
4 1 Mehdi Abaakouk
5 1 Mehdi Abaakouk
 - une base données postgres
6 1 Mehdi Abaakouk
 - une application installé dans /srv/http/chiliproject-X.X.X
7 1 Mehdi Abaakouk
 - une copie du gitolite de git.tetaneutral.net dans /srv/http/repositories (maj automatiquement par gitolite)
8 1 Mehdi Abaakouk
9 1 Mehdi Abaakouk
h2. L'application:
10 1 Mehdi Abaakouk
11 1 Mehdi Abaakouk
Le vhost d'apache est /etc/apache2/sites-enabled/chiliproject.tetaneutral.net, il pointe vers le répertoire /srv/http/chiliproject qui est un lien symbolique vers /srv/http/chiliproject-X.X.X
12 1 Mehdi Abaakouk
13 1 Mehdi Abaakouk
La procédure de mise est la suivante:
14 1 Mehdi Abaakouk
<pre>
15 1 Mehdi Abaakouk
/etc/init.d/apache2 stop
16 1 Mehdi Abaakouk
# su - postgres
17 1 Mehdi Abaakouk
# pgdump chiliproject > chiliproject-3.X.X-20130108.sql
18 1 Mehdi Abaakouk
# exit
19 1 Mehdi Abaakouk
# cd /srv/http
20 1 Mehdi Abaakouk
# wget http:///...../chiliproject-X.X.X.tar.gz
21 1 Mehdi Abaakouk
# ln -sf chiliproject-X.X.X chiliproject
22 1 Mehdi Abaakouk
</pre>
23 1 Mehdi Abaakouk
24 1 Mehdi Abaakouk
Copier les fichiers de configuration et les fichiers uploader de l'ancien chiliproject vers le nouveau.
25 1 Mehdi Abaakouk
cf: https://www.chiliproject.org/projects/chiliproject/wiki/Upgrade#Zip-or-Tar-archive
26 1 Mehdi Abaakouk
27 1 Mehdi Abaakouk
Et continuer les étapes 4 à 10 du howto de chiliproject (cf: https://www.chiliproject.org/projects/chiliproject/wiki/Upgrade#Step-4-Library-installation):
28 1 Mehdi Abaakouk
<pre>
29 2 Mehdi Abaakouk
cd /srv/http/chiliproject
30 1 Mehdi Abaakouk
bundle install
31 1 Mehdi Abaakouk
bundle exec rake generate_session_store
32 1 Mehdi Abaakouk
bundle exec rake db:migrate RAILS_ENV=production
33 1 Mehdi Abaakouk
bundle exec rake db:migrate:plugins RAILS_ENV=production
34 1 Mehdi Abaakouk
bundle exec rake tmp:cache:clear
35 1 Mehdi Abaakouk
bundle exec rake tmp:sessions:clear
36 1 Mehdi Abaakouk
</pre>
37 1 Mehdi Abaakouk
38 1 Mehdi Abaakouk
Ajout des modifications tetaneutral.net:
39 1 Mehdi Abaakouk
40 1 Mehdi Abaakouk
<pre>
41 2 Mehdi Abaakouk
cd /srv/http/chiliproject
42 2 Mehdi Abaakouk
# patch -p1 --dry-run < ../custom_mailer.patch 
43 2 Mehdi Abaakouk
# patch -p1 < ../custom_mailer.patch 
44 1 Mehdi Abaakouk
</pre>
45 1 Mehdi Abaakouk
46 1 Mehdi Abaakouk
h2. La DB du postgres normal:
47 1 Mehdi Abaakouk
48 1 Mehdi Abaakouk
<pre>
49 1 Mehdi Abaakouk
# su - postgres
50 1 Mehdi Abaakouk
# psql chiliproject
51 1 Mehdi Abaakouk
chiliproject=# \dt
52 1 Mehdi Abaakouk
 public | attachments                         | table | chiliproject
53 1 Mehdi Abaakouk
 public | auth_sources                        | table | chiliproject
54 1 Mehdi Abaakouk
 public | boards                              | table | chiliproject
55 1 Mehdi Abaakouk
 public | changes                             | table | chiliproject
56 1 Mehdi Abaakouk
 public | changesets                          | table | chiliproject
57 1 Mehdi Abaakouk
 public | changesets_issues                   | table | chiliproject
58 1 Mehdi Abaakouk
 public | comments                            | table | chiliproject
59 1 Mehdi Abaakouk
 public | custom_fields                       | table | chiliproject
60 1 Mehdi Abaakouk
 public | custom_fields_projects              | table | chiliproject
61 1 Mehdi Abaakouk
 public | custom_fields_trackers              | table | chiliproject
62 1 Mehdi Abaakouk
 public | custom_values                       | table | chiliproject
63 1 Mehdi Abaakouk
 public | documents                           | table | chiliproject
64 1 Mehdi Abaakouk
 public | enabled_modules                     | table | chiliproject
65 1 Mehdi Abaakouk
 public | enumerations                        | table | chiliproject
66 1 Mehdi Abaakouk
 public | groups_users                        | table | chiliproject
67 1 Mehdi Abaakouk
 public | issue_categories                    | table | chiliproject
68 1 Mehdi Abaakouk
 public | issue_relations                     | table | chiliproject
69 1 Mehdi Abaakouk
 public | issue_statuses                      | table | chiliproject
70 1 Mehdi Abaakouk
 public | issues                              | table | chiliproject
71 1 Mehdi Abaakouk
 public | journal_details                     | table | chiliproject
72 1 Mehdi Abaakouk
 public | journals                            | table | chiliproject
73 1 Mehdi Abaakouk
 public | member_roles                        | table | chiliproject
74 1 Mehdi Abaakouk
 public | members                             | table | chiliproject
75 1 Mehdi Abaakouk
 public | messages                            | table | chiliproject
76 1 Mehdi Abaakouk
 public | news                                | table | chiliproject
77 1 Mehdi Abaakouk
 public | open_id_authentication_associations | table | chiliproject
78 1 Mehdi Abaakouk
 public | open_id_authentication_nonces       | table | chiliproject
79 1 Mehdi Abaakouk
 public | projects                            | table | chiliproject
80 1 Mehdi Abaakouk
 public | projects_trackers                   | table | chiliproject
81 1 Mehdi Abaakouk
 public | queries                             | table | chiliproject
82 1 Mehdi Abaakouk
 public | repositories                        | table | chiliproject
83 1 Mehdi Abaakouk
 public | roles                               | table | chiliproject
84 1 Mehdi Abaakouk
 public | schema_migrations                   | table | chiliproject
85 1 Mehdi Abaakouk
 public | settings                            | table | chiliproject
86 1 Mehdi Abaakouk
 public | taggings                            | table | chiliproject
87 1 Mehdi Abaakouk
 public | tags                                | table | chiliproject
88 1 Mehdi Abaakouk
 public | time_entries                        | table | chiliproject
89 1 Mehdi Abaakouk
 public | tokens                              | table | chiliproject
90 1 Mehdi Abaakouk
 public | trackers                            | table | chiliproject
91 1 Mehdi Abaakouk
 public | user_preferences                    | table | chiliproject
92 1 Mehdi Abaakouk
 public | users                               | table | chiliproject
93 1 Mehdi Abaakouk
 public | versions                            | table | chiliproject
94 1 Mehdi Abaakouk
 public | watchers                            | table | chiliproject
95 1 Mehdi Abaakouk
 public | wiki_content_versions               | table | chiliproject
96 1 Mehdi Abaakouk
 public | wiki_contents                       | table | chiliproject
97 1 Mehdi Abaakouk
 public | wiki_pages                          | table | chiliproject
98 1 Mehdi Abaakouk
 public | wiki_redirects                      | table | chiliproject
99 1 Mehdi Abaakouk
 public | wikis                               | table | chiliproject
100 1 Mehdi Abaakouk
 public | workflows                           | table | chiliproject
101 1 Mehdi Abaakouk
</pre>