Chiliproject¶

La machine chiliproject contient:

- une base données postgres
 - une application installé dans /srv/http/chiliproject-X.X.X
 - une copie du gitolite de git.tetaneutral.net dans /srv/http/repositories (maj automatiquement par gitolite)

L'application:¶

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

La procédure de mise à jour est la suivante:

/etc/init.d/apache2 stop
# su - postgres
# pgdump chiliproject > chiliproject-3.X.X-20130108.sql
# exit
# cd /srv/http/chiliproject
# git fetch origin
# git branch ttnn-prod-3.6.0     # Création d'un nouvelle branche qui contient les modifications ttnn
# git checkout ttnn-prod-3.6.0   # Utilisation de cette branche
# git rebase v3.6.0              # rebase la branche ttnn avec la dernière version de chiliproject

Et continuer les étapes 4 à 10 du howto de chiliproject (cf: https://www.chiliproject.org/projects/chiliproject/wiki/Upgrade#Step-4-Library-installation)
Version rapide:

bundle update
gem cleanup
bundle update
bundle exec rake generate_session_store
bundle exec rake db:migrate RAILS_ENV=production
bundle exec rake db:migrate:plugins RAILS_ENV=production
bundle exec rake tmp:cache:clear
bundle exec rake tmp:sessions:clear

Restart de chili

/etc/init.d/apache2 start

La DB du postgres normal:¶

# su - postgres
# psql chiliproject
chiliproject=# \dt
 public | attachments                         | table | chiliproject
 public | auth_sources                        | table | chiliproject
 public | boards                              | table | chiliproject
 public | changes                             | table | chiliproject
 public | changesets                          | table | chiliproject
 public | changesets_issues                   | table | chiliproject
 public | comments                            | table | chiliproject
 public | custom_fields                       | table | chiliproject
 public | custom_fields_projects              | table | chiliproject
 public | custom_fields_trackers              | table | chiliproject
 public | custom_values                       | table | chiliproject
 public | documents                           | table | chiliproject
 public | enabled_modules                     | table | chiliproject
 public | enumerations                        | table | chiliproject
 public | groups_users                        | table | chiliproject
 public | issue_categories                    | table | chiliproject
 public | issue_relations                     | table | chiliproject
 public | issue_statuses                      | table | chiliproject
 public | issues                              | table | chiliproject
 public | journal_details                     | table | chiliproject
 public | journals                            | table | chiliproject
 public | member_roles                        | table | chiliproject
 public | members                             | table | chiliproject
 public | messages                            | table | chiliproject
 public | news                                | table | chiliproject
 public | open_id_authentication_associations | table | chiliproject
 public | open_id_authentication_nonces       | table | chiliproject
 public | projects                            | table | chiliproject
 public | projects_trackers                   | table | chiliproject
 public | queries                             | table | chiliproject
 public | repositories                        | table | chiliproject
 public | roles                               | table | chiliproject
 public | schema_migrations                   | table | chiliproject
 public | settings                            | table | chiliproject
 public | taggings                            | table | chiliproject
 public | tags                                | table | chiliproject
 public | time_entries                        | table | chiliproject
 public | tokens                              | table | chiliproject
 public | trackers                            | table | chiliproject
 public | user_preferences                    | table | chiliproject
 public | users                               | table | chiliproject
 public | versions                            | table | chiliproject
 public | watchers                            | table | chiliproject
 public | wiki_content_versions               | table | chiliproject
 public | wiki_contents                       | table | chiliproject
 public | wiki_pages                          | table | chiliproject
 public | wiki_redirects                      | table | chiliproject
 public | wikis                               | table | chiliproject
 public | workflows                           | table | chiliproject