Project

General

Profile

HowTo Install Redmine 12x with Mercurial and Subversion on Ubuntu Server 1004 » History » Version 49

Dimitry Profus, 2011-09-22 04:33

1 1 Dimitry Profus
h1. HowTo Install Redmine 1.2.x with Mercurial and Subversion on Ubuntu Server 10.04
2
3
{{toc}}
4
5
h2. Redmine Installation
6
7
# Install the LAMP stack
8
<pre>
9
$ sudo tasksel install lamp-server
10
</pre>
11
# Install the required packages
12
<pre>
13
$ sudo apt-get install build-essential subversion llibmysqlclient15-dev libdigest-sha1-perl libgemplugin-ruby libgemplugin-ruby1.8 libruby-extras libruby1.8-extras rails rake ruby rubygems rubygems1.8 ruby1.8-dev libopenssl-ruby1.8 
14
</pre>
15
# Install the required Ruby gems
16
<pre>
17
$ sudo gem install rails -v=2.3.11 --no-ri --no-rdoc
18
$ sudo gem install rake -v=0.8.7 --no-ri --no-rdoc
19
$ sudo gem uninstall rake -v=0.9.2 
20
$ sudo gem install i18n -v=0.4.2 --no-ri --no-rdoc
21
$ sudo gem install mysql --no-ri --no-rdoc
22
</pre> 
23
# Download Redmine into /user/share/redmine directory
24
<pre>
25
$ sudo svn co http://redmine.rubyforge.org/svn/branches/1.2-stable /usr/share/redmine
26
</pre>
27
# Create an empty MySQL database and accompanying user named redmine for example.
28
<pre>
29
$ mysql -u root -p
30
(enter the mysql root user password)
31
> create database redmine character set utf8;
32
> create user 'redmine'@'localhost' identified by '[password]';
33
> grant all privileges on redmine.* to 'redmine'@'localhost' identified by '[password]';
34
> exit
35
</pre>
36
# Copy config/database.yml.example to config/database.yml and edit this file in order to configure your database settings for "production" environment.
37
<pre>
38
$ sudo cp /usr/share/redmine/config/database.yml.example /usr/share/redmine/config/database.yml
39
40
$ sudo nano /usr/share/redmine/config/database.yml
41
42
Modify to the following and save (ctrl+x)
43
44
production:
45
  adapter: mysql
46
  socket: /var/run/mysqld/mysqld.sock
47
  database: redmine
48
  host: localhost
49
  username: redmine
50
  password: [password]
51
  encoding: utf8
52
</pre>
53
# Generate a session store secret.
54
<pre>
55
$ cd /usr/share/redmine
56
57
$ sudo rake generate_session_store
58
</pre>
59
# Create the database structure, by running the following command under the application root directory:
60
<pre>
61
$ cd /usr/share/redmine
62
63
$ sudo rake db:migrate RAILS_ENV="production" 
64
</pre>
65
# Insert default configuration data in database, by running the following command:
66
<pre>
67
$ sudo RAILS_ENV=production rake redmine:load_default_data
68
</pre>
69
# Setting up permissions
70
<pre>
71
$ cd /usr/share/redmine
72
$ sudo chown -R www-data:www-data files log tmp public/plugin_assets
73
$ sudo chmod -R 755 files log tmp public/plugin_assets
74
</pre>
75
# Test using the webrick web server
76
<pre>
77
$ cd /usr/share/redmine
78
79
$ ruby script/server webrick -e production
80
81
Point your web browser at http://[my server ip]:3000
82
83
You should now see the application welcome page.
84
</pre>
85
86
87
h2. Apache Integration
88
89
# Install the required packages
90
<pre>
91
$ sudo apt-get install libapache2-mod-passenger
92
</pre>
93
# Add a symbolic link to the public redmine web directory
94
<pre>
95
$ sudo ln -s /usr/share/redmine/public /var/www/redmine
96
</pre>
97
# Configure Passanger to run as www-data
98
<pre>
99
$ sudo nano /etc/apache2/mods-available/passenger.conf
100
101
Add the follow line and save (ctrl+x)
102
103
PassengerDefaultUser www-data
104
</pre>
105
# Create a new Apache site file
106
<pre> 
107
$ sudo nano /etc/apache2/sites-available/redmine 
108
</pre>
109
Add the following lines and save (ctrl+x)
110
<pre>
111
<VirtualHost *:80>
112
        ServerAdmin webmaster@localhost
113
        DocumentRoot /var/www
114
        ServerName myservername
115
        
116
        RewriteEngine on
117
        RewriteRule   ^/$  /redmine  [R]
118
119
        <Directory /var/www/redmine>
120
                RailsBaseURI /redmine
121
                PassengerResolveSymlinksInDocumentRoot on
122
        </Directory>
123
124
        ErrorLog /var/log/apache2/error.log
125
126
        # Possible values include: debug, info, notice, warn, error, crit,
127
        # alert, emerg.
128
        LogLevel warn
129
130
        CustomLog /var/log/apache2/access.log combined
131
</VirtualHost>
132
</pre>
133
For SSL add the following text instead
134
<pre>
135
<VirtualHost *:443>
136
        ServerAdmin webmaster@localhost
137
        DocumentRoot /var/www
138
        ServerName myservername
139
140
        SSLEngine On
141
        SSLCertificateFile /etc/apache2/ssl/redmine.pem
142
143
        RewriteEngine on
144
        RewriteRule   ^/$  /redmine  [R]
145
146
        <Directory /var/www/redmine>
147
                RailsBaseURI /redmine
148
                PassengerResolveSymlinksInDocumentRoot on
149
        </Directory>
150
151
        ErrorLog /var/log/apache2/error.log
152
153
        # Possible values include: debug, info, notice, warn, error, crit,
154
        # alert, emerg.
155
        LogLevel warn
156
157
        CustomLog /var/log/apache2/access.log combined
158
</VirtualHost>
159
</pre>
160
# Enable the Redmine website
161
<pre>
162
$ sudo a2dissite default
163
$ sudo a2ensite redmine
164
</pre> 
165
# Enable the Passenger and Rewite modules and restart Apache
166 5 Dimitry Profus
<pre>
167 1 Dimitry Profus
$ sudo a2enmod passenger
168
$ sudo a2enmod rewrite
169
$ sudo /etc/init.d/apache2 restart
170
</pre> 
171
# Test the setup
172
<pre>
173
Open up your favorite web browser and goto
174
175
http://[my site or ip]/redmine
176
</pre>
177
178
h2. Mercurial Integration
179
180
# Install the latest Mercurial release 
181
<pre>
182
$ sudo apt-get install python-software-properties
183
$ sudo add-apt-repository ppa:mercurial-ppa/releases
184
$ sudo apt-get update
185
$ sudo apt-get install mercurial libapache-dbi-perl libapache2-mod-perl2
186
</pre>
187
# Create the hg web directory
188
<pre>
189 12 Dimitry Profus
$ sudo mkdir -p /var/hg/repos
190 1 Dimitry Profus
</pre>
191
# Create the web cgi script file
192
<pre>
193 12 Dimitry Profus
$ sudo nano /var/hg/hgwebdir.cgi
194 1 Dimitry Profus
195
Add the following and save
196
197
#!/usr/bin/env python
198
#
199
from mercurial import demandimport; demandimport.enable()
200
from mercurial.hgweb.hgwebdir_mod import hgwebdir
201
import mercurial.hgweb.wsgicgi as wsgicgi
202
application = hgwebdir('hgweb.config')
203
wsgicgi.launch(application)
204
</pre>
205
# Create the cgi web config file 
206
<pre>
207 12 Dimitry Profus
$ sudo nano /var/hg/hgweb.config
208 1 Dimitry Profus
209
Add the following and save
210
211
[paths]
212 12 Dimitry Profus
/=/var/hg/repos/**
213 1 Dimitry Profus
214
[web]
215
allow_push = *
216
push_ssl = false
217
allowbz2 = yes
218
allowgz = yes
219
allowzip = yes
220
</pre>
221
# Setup permissions
222
<pre>
223 12 Dimitry Profus
$ sudo chown -R www-data:www-data /var/hg
224
$ sudo chmod gu+x /var/hg/hgwebdir.cgi
225 1 Dimitry Profus
</pre>
226
# Create a Apache config file
227
<pre>
228
$ sudo nano /etc/apache2/conf.d/hg.config
229
230
Add the following and save
231
 
232
PerlLoadModule Apache::Redmine
233 12 Dimitry Profus
ScriptAlias /hg  "/var/hg/hgwebdir.cgi"
234 1 Dimitry Profus
<Location /hg  >
235
	AuthType Basic
236 13 Dimitry Profus
	AuthName "Redmine Mercurial Repository" 
237 1 Dimitry Profus
	Require valid-user
238
239
	#Redmine auth
240
	PerlAccessHandler Apache::Authn::Redmine::access_handler
241
	PerlAuthenHandler Apache::Authn::Redmine::authen_handler
242
	RedmineDSN "DBI:mysql:database=redmine;host=localhost" 
243
	RedmineDbUser "redmine" 
244
	RedmineDbPass "password" 
245
</Location>
246
</pre>
247
# Add a symbolic link to Redmine.pm
248
<pre>
249
$ sudo ln -s /usr/share/redmine/extra/svn/Redmine.pm /usr/lib/perl5/Apache/Redmine.pm
250
$ sudo ln -s /usr/share/redmine/extra/svn/Redmine.pm /usr/lib/perl5/Apache2/Redmine.pm  
251
</pre>
252
# Enable the required Apache modules and restart Apache
253
<pre>
254
$ sudo /etc/init.d/apache2 restart
255
</pre>
256
# Create a new test repository and project in Redmine
257
<pre>
258 12 Dimitry Profus
$ sudo hg init /var/hg/repos/test
259
$ sudo chown -R www-data:www-data /var/hg/repos/test
260 1 Dimitry Profus
261
Create a new project with and identifier 'test'
262
263
In the project Settings > Repository set
264
SCM: Mercurial
265 12 Dimitry Profus
Path to repository: /var/hg/repos/test
266 1 Dimitry Profus
Press the 'Create' button
267
268
Goto to the Repository tab of the test project
269
</pre>
270
# View the test repository in the web browser 
271
<pre>
272
> http://[my site name]/hg/test
273
</pre>
274
275
h2. Subversion Integration
276
277
# Install the latest Mercurial release 
278
<pre>
279
$ sudo apt-get install subversion libapache2-svn libapache-dbi-perl libapache2-mod-perl2
280
</pre>
281
# Create the svn repository directory
282
<pre>
283 12 Dimitry Profus
$ sudo mkdir /var/svn
284 1 Dimitry Profus
</pre>
285
# Setup permissions
286
<pre>
287 12 Dimitry Profus
$ sudo chown -R www-data:www-data /var/svn
288 1 Dimitry Profus
</pre>
289
# Add a symbolic link to Redmine.pm
290
<pre>
291
$ sudo ln -s /usr/share/redmine/extra/svn/Redmine.pm /usr/lib/perl5/Apache/Redmine.pm
292
$ sudo ln -s /usr/share/redmine/extra/svn/Redmine.pm /usr/lib/perl5/Apache2/Redmine.pm  
293
</pre>
294
# Create a Apache config file
295
<pre>
296
$ sudo nano /etc/apache2/conf.d/svn.config
297
</pre>
298
Add the following and save
299
<pre>
300 16 Dimitry Profus
PerlLoadModule Apache::Redmine
301
<Location /svn>
302
	DAV svn
303
	SVNParentPath "/var/svn" 
304
	Order deny,allow
305
	Deny from all
306
	Satisfy any
307 1 Dimitry Profus
308 16 Dimitry Profus
	PerlAccessHandler Apache::Authn::Redmine::access_handler
309
	PerlAuthenHandler Apache::Authn::Redmine::authen_handler
310
	AuthType Basic
311
	AuthName "Redmine Subversion Repository" 
312 1 Dimitry Profus
313 16 Dimitry Profus
	#read-only access    
314
	<Limit GET PROPFIND OPTIONS REPORT>
315
		Require valid-user
316
		Allow from [my server ip]
317
		# Allow from another-ip
318
		 Satisfy any
319
	</Limit>
320
		# write access
321
		<LimitExcept GET PROPFIND OPTIONS REPORT>
322
		Require valid-user
323
	</LimitExcept>
324 1 Dimitry Profus
325 16 Dimitry Profus
	## for mysql
326
	RedmineDSN "DBI:mysql:database=redmine;host=localhost" 
327
	RedmineDbUser "redmine" 
328
	RedmineDbPass "password" 
329
</Location>
330 1 Dimitry Profus
</pre>
331
# Enable the required Apache modules and restart Apache
332
<pre>
333
$ sudo a2enmod dav_svn
334
$ sudo /etc/init.d/apache2 restart
335
</pre>
336
# Create a new test repository
337
<pre>
338 12 Dimitry Profus
$ sudo svnadmin create /var/svn/test
339
$ sudo chown -R www-data:www-data /var/svn/test
340 1 Dimitry Profus
</pre>
341
342 7 Dimitry Profus
h2. Automate Repository Creation
343 5 Dimitry Profus
344 3 Dimitry Profus
# Enable WS for repository management and generate and API key
345
<pre>
346
* From the Redmine Administration menu select Settings
347
* Click on the Repositories tab
348
* Enable the 'Enable WS for repository management' checkbox
349
* Click the 'Generate a key' link 
350
* Press the 'Save' button
351
</pre>
352
# Modify reposman.rb
353
<pre>
354
$ sudo nano /usr/share/extra/svn/reposman.rb
355
356
Add the following to module SCM and save  
357
358
  module Mercurial
359
    def self.create(path)
360
      Dir.mkdir path
361
      Dir.chdir(path) do
362
        system_or_raise "hg init"
363
      end
364
    end
365
  end
366
</pre>
367 6 Dimitry Profus
# Schedule the reposman.rb script to run every minute
368 3 Dimitry Profus
<pre>
369
$ sudo nano /etc/cron.d/redmine
370 7 Dimitry Profus
</pre>
371 9 Dimitry Profus
Add one of the following lines (not both) and save.
372 1 Dimitry Profus
(Note: you will need to replace [my API key]  with the API key you generated in step 1) 
373 7 Dimitry Profus
.
374 11 Dimitry Profus
To create subversion repositories add:
375 7 Dimitry Profus
<pre>
376 14 Dimitry Profus
* * * * * root ruby /usr/share/redmine/extra/svn/reposman.rb --redmine localhost/redmine --scm Subversion --svn-dir /var/hg/repos --owner www-data --url file:///var/svn --key=[my API key] >> /var/log/reposman.log
377 7 Dimitry Profus
</pre>
378 11 Dimitry Profus
OR to create Mecurial repositories add:
379 8 Dimitry Profus
<pre>
380 14 Dimitry Profus
* * * * * root ruby /usr/share/redmine/extra/svn/reposman.rb --redmine localhost/redmine --scm Mercurial --svn-dir /var/hg/repos --owner www-data --url /var/hg/repos --key=[my API key] >> /var/log/reposman.log
381 1 Dimitry Profus
</pre>
382 5 Dimitry Profus
383 15 Dimitry Profus
h2. Automatic refresh of repositories in Redmine
384
385
# Schedule the fetch_changesets script to run every 15 minutes
386
<pre>
387 17 Dimitry Profus
$ sudo nano /var/cron.d/redmine
388
389
Add the following line and save
390
391 15 Dimitry Profus
*/15 * * * * root ruby /usr/share/redmine/script/runner "Repository.fetch_changesets" -e production > /dev/null 2>&1
392
</pre>
393 16 Dimitry Profus
# Setup a changegroup script on the Mercurial server to run fetch_changesets after each push to a Mercurial repository 
394 15 Dimitry Profus
<pre>
395
$ sudo nano /var/hg/changegroup-hook
396
</pre>
397
Add the following text and save
398
(Note: you will need to replace [your API key] the API key you generated in Redmine
399
<pre>
400
#!/bin/sh
401
curl "http://localhost/redmine/sys/fetch_changesets?key=[your API key]"  > /dev/null 2>&1
402
</pre>
403
Setup permissions
404
<pre>
405
$ sudo chown www-data:www-data /var/hg/changegroup-hook
406
$ sudo chmod ug+x /var/hg/changegroup-hook
407
</pre>
408
Modify the hgweb.config file
409
<pre>
410
$ sudo nano /var/hg/hgweb.config
411
</pre>
412
Add the following section and save
413
<pre>
414
[hooks]
415
changegroup = /var/hg/changegroup-hook
416
</pre>
417
418 1 Dimitry Profus
h2. Email Integration
419
420
# Install and configure Sendmail
421
<pre>
422
$ sudo apt-get install sendmail
423
$ sudo sendmailconfig
424
425
(Answer Yes to all questions which you will be asked)
426
</pre>
427
# Update the Redmine configuration file
428
<pre>
429
$ sudo nano /usr/share/redmine/config/configuration.yml
430
431
Add the following text and save
432
433
 production:
434
   email_delivery:
435
     delivery_method: :sendmail
436
</pre>
437 18 Dimitry Profus
438 23 Dimitry Profus
h2. Backup to Amazon S3 cloud storage
439 18 Dimitry Profus
440 22 Dimitry Profus
# Create an account at http://aws.amazon.com/ 
441 18 Dimitry Profus
# Create a S3 bucket using the aws management console https://console.aws.amazon.com/ec2/home
442 21 Dimitry Profus
# View your Access Keys at https://aws-portal.amazon.com/gp/aws/developer/account/index.html?action=access-key
443 18 Dimitry Profus
# Build and install fuse to 2.8.4
444
<pre>
445
$ sudo wget https://launchpad.net/ubuntu/+archive/primary/+files/fuse_2.8.4.orig.tar.gz
446
$ cd fuse-2.8.4/
447
$ tar xzf fuse_2.8.4.orig.tar.gz 
448
$ sudo ./configure 
449
$ sudo make
450
$ sudo make install
451
</pre>
452
# Build and install s3fs 1.61 
453
<pre>
454
$ sudo apt-get install libxml2-dev
455
$ wget http://s3fs.googlecode.com/files/s3fs-1.61.tar.gz
456
$ tar xzf s3fs-1.61.tar.gz 
457
$ cd s3fs-1.61/
458
$ sudo ./configure 
459
$ sudo make
460
$ sudo make install
461
</pre>
462 42 Dimitry Profus
# Create a s3fs password file
463 18 Dimitry Profus
<pre>
464
$ sudo nano /etc/passwd-s3fs
465
</pre>
466 24 Dimitry Profus
Added your 'Access Key ID' and 'Secret Access Key' separated by a colon
467
<pre>
468 18 Dimitry Profus
[accessKeyId]:[secretAccessKey]
469
</pre>
470
Setup permissions
471
<pre>
472
sudo chmod 650 /etc/passwd-s3fs
473
</pre> 
474
# Create mounting point
475
<pre>
476
$ sudo mkdir /mnt/s3
477
</pre>
478 25 Dimitry Profus
# Mount your S3 bucket
479 18 Dimitry Profus
<pre>
480
$ sudo s3fs [your-s3-bucket-name] /mnt/s3 -ouse_cache=/tmp -o allow_other
481
</pre>
482 37 Dimitry Profus
# Test it worked and unmount
483 18 Dimitry Profus
<pre>
484 38 Dimitry Profus
$ echo hello > /mnt/s3/welcome.txt
485 1 Dimitry Profus
$ ls /mnt/s3
486 36 Dimitry Profus
$ sudo umount /mnt/s3
487 18 Dimitry Profus
</pre>
488
# Create upstart job to mount the s3 file system start up
489
<pre>
490
$ sudo nano /etc/init/s3.conf
491
</pre>
492
Add the following text and save.
493
<pre>
494 43 Dimitry Profus
description "Mount Amazon S3 file system on system start"
495 18 Dimitry Profus
496
start on (local-filesystems and net-device-up IFACE!=lo)
497
stop on runlevel [016]
498
499
respawn
500
501
exec s3fs -f [your-s3-bucket-name] /mnt/s3 -ouse_cache=/tmp -o allow_other
502
</pre>
503 35 Dimitry Profus
# Start the s3 job
504
<pre>
505
sudo start s3
506 1 Dimitry Profus
</pre>
507 40 Dimitry Profus
# Test it worked
508 38 Dimitry Profus
<pre>
509
$ echo hello > /mnt/s3/welcome2.txt
510
$ ls /mnt/s3
511 39 Dimitry Profus
</pre>
512 19 Dimitry Profus
# Create the backup script file
513
<pre>
514 27 Dimitry Profus
$ sudo apt-get install mailutils
515 32 Dimitry Profus
$ sudo nano /usr/local/bin/backup-redmine.sh
516 29 Dimitry Profus
</pre>
517 19 Dimitry Profus
Add the following text and save.
518 29 Dimitry Profus
<pre>
519 19 Dimitry Profus
#!/bin/bash
520
####################################
521
#
522 30 Dimitry Profus
# Backup Redmine to S3 mount script with
523 19 Dimitry Profus
# grandfather-father-son rotation.
524
#
525 1 Dimitry Profus
####################################
526
527 32 Dimitry Profus
# Admin email address
528
admin_email="admin@domain.com"
529 1 Dimitry Profus
530 32 Dimitry Profus
# What to backup
531
db_dump_file="/usr/share/redmine/db/redmine-database-dump.sql"
532
backup_files="$db_dump_file /usr/share/redmine/files /var/hg /var/svn /etc/apache2/conf.d /etc/apache2/sites-available"
533 1 Dimitry Profus
534 32 Dimitry Profus
# Where to backup to
535
backup_dir="/mnt/s3"
536 1 Dimitry Profus
537 32 Dimitry Profus
# Set database access
538
redmine_db_name="redmine"
539
redmine_db_user="redmine"
540
redmine_db_password="password"
541 45 Dimitry Profus
542
# Encryption
543
encrypt="false"
544
secret_passphrase="yourpassword"
545 32 Dimitry Profus
 
546
# Set rotation in units of days
547
daily_remove_older_than=6
548
weekly_remove_older_than=28
549
monthly_remove_older_than=65
550 1 Dimitry Profus
551 32 Dimitry Profus
# Redirect stderr to a log file
552
error_log="/tmp/backup-redmine.log"
553
exec 6>&2
554
exec 2>$error_log
555 1 Dimitry Profus
556 32 Dimitry Profus
trap on_exit EXIT SIGHUP SIGINT SIGQUIT SIGTERM
557 1 Dimitry Profus
558 32 Dimitry Profus
on_exit() {
559
    # Restore IO output
560
    exec 2>&6  6>$-
561 1 Dimitry Profus
562 32 Dimitry Profus
    # Check for errors
563
    if [ -s "$error_log" ]; then
564
        logger -t "$0"  -s "#### Backup Failed ####"
565
        logger -t "$0" -s -f "$error_log"
566
        cat "$error_log" | mail -s "Backup failed!"  $admin_email
567
     else
568
        logger -t "$0" -s "Backup Complete"
569
    fi
570 28 Dimitry Profus
571 32 Dimitry Profus
    # Clean up
572
    rm -f $error_log
573
}
574
575 1 Dimitry Profus
# Setup variables for the archive filename.
576 26 Dimitry Profus
hostname=$(hostname -s)
577 32 Dimitry Profus
date_time_stamp=`date +%Y-%m-%d_%Hh%Mm`        # Datestamp e.g 2011-12-31_23h59m
578
date_stamp=`date +%Y-%m-%d`                    # Date p e.g 2011-12-31
579
date_day_of_week=`date +%A`                    # Day of the week e.g. Monday
580
date_day_of_month=`date +%e`                   # Date of the Month e.g. 27
581 31 Dimitry Profus
582 32 Dimitry Profus
# Make required directories
583
[ -d "$backup_dir/monthly" ] || mkdir "$backup_dir/monthly"
584
[ -d "$backup_dir/weekly" ] || mkdir "$backup_dir/weekly"
585
[ -d "$backup_dir/daily" ] || mkdir "$backup_dir/daily"
586 29 Dimitry Profus
587 32 Dimitry Profus
# Delete old archives
588
find "${backup_dir}/monthly" -mtime +"$monthly_remove_older_than" -type f -name "${hostname}_*" -exec rm {} \;
589
find "${backup_dir}/weekly" -mtime +"$weekly_remove_older_than" -type f -name "${hostname}_*" -exec rm {} \;
590 31 Dimitry Profus
find "${backup_dir}/daily" -mtime +"$daily_remove_older_than" -type f -name "${hostname}_*" -exec rm {} \;
591 1 Dimitry Profus
592 45 Dimitry Profus
archive_file="${backup_dir}/daily/${hostname}_${date_time_stamp}.tgz"
593 1 Dimitry Profus
594 49 Dimitry Profus
[ $encrypt == "true" ] && archive_file="${archive_file}.gpg"
595 45 Dimitry Profus
    
596 32 Dimitry Profus
# Write a daily backup
597 1 Dimitry Profus
if mount | grep -sq "$backup_dir"; then
598
    # Dump the redmine database
599
    mysqldump --user="${redmine_db_name}" --password="${redmine_db_password}" "${redmine_db_name}" > $db_dump_file
600 45 Dimitry Profus
    
601 48 Dimitry Profus
    # Write the archive file to the backup directory
602 45 Dimitry Profus
    if [ $? == 0 ]; then
603 1 Dimitry Profus
       if [ $encrypt == "true" ]; then
604 49 Dimitry Profus
           rm -f "$archive_file"
605 45 Dimitry Profus
           tar czP $backup_files | gpg -c --passphrase="${secret_passphrase}" -o "${archive_file}"
606
       else
607
           tar czfP "${archive_file}" $backup_files
608
       fi
609
    fi
610 19 Dimitry Profus
else
611
    echo "backup destination ${backup_dir} is not mounted" >&2
612 1 Dimitry Profus
fi
613
614
# Make a weekly backup on Saturday
615
if [ $date_day_of_week == "Saturday" ]; then
616
    weekly_count=$(find "${backup_dir}/weekly" -type f -name "${hostname}_${date_stamp}*" | wc -l)
617 45 Dimitry Profus
    [ $weekly_count == "0" ] && cp "${archive_file}" "${backup_dir}/weekly/"
618 1 Dimitry Profus
fi
619 44 Dimitry Profus
620
# Make a monthly backup on the first day of every  month
621
if [ $date_day_of_month == "1" ]; then
622
    monthly_count=$(find "${backup_dir}/monthly" -type f -name "${hostname}_${date_stamp}*" | wc -l)
623 45 Dimitry Profus
    [ $monthly_count == "0" ] && cp "${archive_file}" "${backup_dir}/monthly/"
624 1 Dimitry Profus
fi
625 32 Dimitry Profus
626
[ -s $error_log ] && exit 1
627 1 Dimitry Profus
</pre>
628
# Setup permissions 
629
<pre>
630 32 Dimitry Profus
sudo chmod ug+x /usr/local/bin/backup-redmine.sh
631 47 Dimitry Profus
sudo chmod o-r /usr/local/bin/backup-redmine.sh
632 1 Dimitry Profus
</pre>
633
# Schedule the backup to run once a day at 12am
634
<pre>
635
$ sudo nano /etc/cron.d/redmine
636
637
Add the following line and save
638
639 32 Dimitry Profus
0 0 * * * root /usr/local/bin/backup-redmine.sh
640 1 Dimitry Profus
</pre>
641
# Test the script
642
<pre>
643 41 Dimitry Profus
$ sudo backup-redmine.sh
644
$ ls -R /mnt/s3
645 1 Dimitry Profus
</pre>