h1. 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)

h2. 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:
<pre>
/etc/init.d/apache2 stop
# su - postgres
# pgdump chiliproject > chiliproject-3.X.X-20130108.sql
# exit
# cd /srv/http/chiliproject /srv/http
# git fetch origin wget http:///...../chiliproject-X.X.X.tar.gz
# git branch ttnn-prod-3.6.0 # Création d'un nouvelle branche qui contient ln -sf chiliproject-X.X.X chiliproject
</pre>

Copier les modifications ttnn
# git checkout ttnn-prod-3.6.0 # Utilisation fichiers de cette branche
# git rebase v3.6.0 # rebase la branche ttnn avec la dernière version configuration et les fichiers uploader de l'ancien chiliproject vers le nouveau.
</pre> cf: https://www.chiliproject.org/projects/chiliproject/wiki/Upgrade#Zip-or-Tar-archive

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:
<pre>
bundle update cd /srv/http/chiliproject
gem cleanup
bundle update install
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
</pre>



Ajout des modifications tetaneutral.net:

<pre>
cd /srv/http/chiliproject
# patch -p1 --dry-run < ../custom_mailer.patch
# patch -p1 < ../custom_mailer.patch
# patch -p1 --dry-run < ../remove_delete_button.patch
# patch -p1 < ../remove_delete_button.patch

</pre>

Restart de chili
<pre>
/etc/init.d/apache2 start
</pre>

h2. La DB du postgres normal:

<pre>
# 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
</pre>