Redmine 203 with Subversion and LDAP Authentication (for Redmine and Subversion through Redmine) on Centos 6 i386 - detailed » History » Version 19

Hung Nguyen Vu, 2012-08-30 17:41
Note on remote mysql setting

1 7 Hung Nguyen Vu
h1. Redmine 2.0.3 on Centos 6.3
2 2 Sven Nosse
3 2 Sven Nosse
{{>toc}}
4 2 Sven Nosse
5 2 Sven Nosse
h2. Introduction
6 2 Sven Nosse
7 6 Hung Nguyen Vu
Our company was using the BITNAMI stack with Redmine and Subversion for our production environment. So the goal was about changing the server and migrating the data from Redmine 1.4 to Redmine 2.0.3 including getting all repositories and permissions preserved. 
8 1 Sven Nosse
9 6 Hung Nguyen Vu
I've tried to avoid webrick but rather use the fastCGI Module for Apache2. 
10 6 Hung Nguyen Vu
11 6 Hung Nguyen Vu
12 6 Hung Nguyen Vu
Second was converting the built-in accounts from the database to LDAP (ActiveDirectory). This is the result of 2 days of work and googling is this little tutorial for setting up a mentioned box doing exactly this stuff. We are using CentOS 6 (i386) for that task. 
13 6 Hung Nguyen Vu
14 6 Hung Nguyen Vu
# Please excuse my bad english for I am not used anymore to post long instruction manuals. Feel free to edit whatever you want. 
15 6 Hung Nguyen Vu
16 6 Hung Nguyen Vu
First of all, I tend to use vi so if you cannot operate vi I'd recommend to use any editor you like. If my instruction tells you to edit a file, you can find the sequence "..." which means, there is something above or below that line of text, that needs to be edited. Do not include those dots... 
17 6 Hung Nguyen Vu
18 1 Sven Nosse
h2. Assumptions
19 1 Sven Nosse
20 2 Sven Nosse
* You have a CentOS 6.3 installation (minimum install) working and SSH access to your box
21 6 Hung Nguyen Vu
* You can access the Internet
22 6 Hung Nguyen Vu
* You are logged in as root
23 1 Sven Nosse
24 6 Hung Nguyen Vu
h2. Redmine Installation Instruction
25 2 Sven Nosse
26 2 Sven Nosse
My personal flavour is to use as less self compiled packages as necessary to get the package up and runnning. So I try to use as many repository packages as possible.
27 2 Sven Nosse
28 6 Hung Nguyen Vu
h3. Turn off SE-Linux
29 3 Sven Nosse
30 6 Hung Nguyen Vu
I spent a lot of time to find out, that selinux can be a real party pooper. So I strongly recommend to disable that first before installing anything else. You can find a tutorial inside the howto section describing how to enable SELinux for your installation.
31 2 Sven Nosse
<pre>
32 2 Sven Nosse
vi /etc/selinux/config
33 2 Sven Nosse
</pre>
34 2 Sven Nosse
35 1 Sven Nosse
find the line with SELINUX and set it to
36 2 Sven Nosse
<pre>
37 2 Sven Nosse
...
38 2 Sven Nosse
SELINUX=disabled
39 2 Sven Nosse
...
40 2 Sven Nosse
</pre>
41 2 Sven Nosse
Do a reboot *NOW*
42 2 Sven Nosse
43 6 Hung Nguyen Vu
h3. Install basic services (Apache, mySQL, and several tools...)
44 2 Sven Nosse
45 9 Hung Nguyen Vu
Now we are good to go to install some tools that might be useful during our installation... 
46 9 Hung Nguyen Vu
47 9 Hung Nguyen Vu
First of all, update your system, make sure it is up to date,
48 1 Sven Nosse
<pre>
49 1 Sven Nosse
yum update
50 9 Hung Nguyen Vu
</pre>
51 9 Hung Nguyen Vu
52 9 Hung Nguyen Vu
and then install some prerequisite packages to the setup,
53 9 Hung Nguyen Vu
<pre>
54 9 Hung Nguyen Vu
yum -y install wget vim \\
55 9 Hung Nguyen Vu
       system-config-network system-config-firewall vim openssh-clients
56 9 Hung Nguyen Vu
</pre>
57 9 Hung Nguyen Vu
58 9 Hung Nguyen Vu
anhd some packages needed for Redmine
59 9 Hung Nguyen Vu
<pre>
60 2 Sven Nosse
yum -y install httpd mysql mysql-server 
61 1 Sven Nosse
</pre>
62 2 Sven Nosse
After that continue and install all packages that might be necessary during the ruby and redmine installation.
63 2 Sven Nosse
<pre>
64 2 Sven Nosse
yum -y install ruby rubygems 
65 6 Hung Nguyen Vu
yum -y install zlib-devel curl-devel openssl-devel httpd-devel apr-devel apr-util-devel mysql-devel gcc ruby-devel \\
66 6 Hung Nguyen Vu
      gcc-c++ make postgresql-devel ImageMagick-devel sqlite-devel perl-LDAP mod_perl perl-Digest-SHA
67 2 Sven Nosse
</pre>
68 2 Sven Nosse
69 2 Sven Nosse
h3. Configure basic services
70 2 Sven Nosse
71 6 Hung Nguyen Vu
Let's configure the basic services, first of all, make mySQL and Apache to start at boot
72 2 Sven Nosse
<pre>
73 18 Hung Nguyen Vu
chkconfig httpd on --level 35
74 18 Hung Nguyen Vu
chkconfig mysqld on --level 35
75 2 Sven Nosse
</pre>
76 2 Sven Nosse
After configuring these, start them up
77 2 Sven Nosse
<pre>
78 2 Sven Nosse
service httpd start
79 2 Sven Nosse
service mysqld start
80 2 Sven Nosse
</pre>
81 18 Hung Nguyen Vu
Now configure your new mySQL Installation and follow the instructions. Please note/write down administrator password to MySQL you've just installed.
82 2 Sven Nosse
<pre>
83 2 Sven Nosse
/usr/bin/mysql_secure_installation
84 2 Sven Nosse
</pre>
85 2 Sven Nosse
86 2 Sven Nosse
h3. Configure passenger for Apache
87 2 Sven Nosse
88 2 Sven Nosse
You need to install passenger for Apache using gem. Do the following on the command line
89 2 Sven Nosse
<pre>
90 2 Sven Nosse
gem install passenger
91 2 Sven Nosse
passenger-install-apache2-module
92 2 Sven Nosse
</pre>
93 2 Sven Nosse
Please notice the installation messages! The next .conf file might use another path or version! 
94 2 Sven Nosse
After this you need to generate a conf file with the displayed content
95 2 Sven Nosse
<pre>
96 2 Sven Nosse
vi /etc/httpd/conf.d/ruby.conf
97 2 Sven Nosse
</pre>
98 2 Sven Nosse
During my installation the following content was displayed and needs to be entered in that file:
99 2 Sven Nosse
<pre>
100 2 Sven Nosse
   LoadModule passenger_module /usr/lib/ruby/gems/1.8/gems/passenger-3.0.15/ext/apache2/mod_passenger.so
101 2 Sven Nosse
   PassengerRoot /usr/lib/ruby/gems/1.8/gems/passenger-3.0.15
102 2 Sven Nosse
   PassengerRuby /usr/bin/ruby
103 2 Sven Nosse
</pre>
104 2 Sven Nosse
Restart your apache with
105 2 Sven Nosse
<pre>
106 2 Sven Nosse
service httpd restart
107 2 Sven Nosse
</pre>
108 2 Sven Nosse
109 1 Sven Nosse
h3. Get Redmine and install it
110 1 Sven Nosse
111 1 Sven Nosse
change to your home directory and download the latest version, expand it and copy it to the right place.
112 1 Sven Nosse
<pre>
113 1 Sven Nosse
cd
114 1 Sven Nosse
wget http://rubyforge.org/frs/download.php/76259/redmine-2.0.3.tar.gz
115 1 Sven Nosse
tar xvfz redmine-2.0.3.tar.gz
116 11 Hung Nguyen Vu
mkdir -p /var/www/redmine
117 12 Hung Nguyen Vu
cp redmine-2.0.3/* /var/www/redmine
118 1 Sven Nosse
</pre>
119 6 Hung Nguyen Vu
120 6 Hung Nguyen Vu
or you can do
121 6 Hung Nguyen Vu
122 6 Hung Nguyen Vu
<pre>
123 6 Hung Nguyen Vu
cd /var/www
124 6 Hung Nguyen Vu
wget http://rubyforge.org/frs/download.php/76259/redmine-2.0.3.tar.gz
125 6 Hung Nguyen Vu
tar xvfz redmine-2.0.3.tar.gz
126 6 Hung Nguyen Vu
ln -s redmine-2.0 redmine
127 6 Hung Nguyen Vu
</pre>
128 6 Hung Nguyen Vu
129 1 Sven Nosse
Next is to install bundler and let it install the production environment (with automatic resolve)
130 1 Sven Nosse
Now change to this directory - *this is your new Redmine application directory!*
131 2 Sven Nosse
<pre>
132 2 Sven Nosse
cd /var/www/redmine
133 2 Sven Nosse
gem install bundler
134 2 Sven Nosse
bundle install --without development test
135 1 Sven Nosse
</pre>
136 10 Hung Nguyen Vu
fetch some coffee... this might take some time...
137 2 Sven Nosse
138 2 Sven Nosse
h3. Create Redmine database
139 2 Sven Nosse
140 6 Hung Nguyen Vu
Next to generate a new database for redmine
141 14 Sven Nosse
Log on to your database with the following command. If prompted for a password, enter it.
142 2 Sven Nosse
<pre>
143 2 Sven Nosse
mysql -u root -p
144 2 Sven Nosse
</pre>
145 2 Sven Nosse
I tend to create a local only user for that database, change the password 'very_secret' to a better one :)
146 2 Sven Nosse
<pre>
147 2 Sven Nosse
create database redmine character set utf8;
148 2 Sven Nosse
create user 'redmine'@'localhost' identified by 'very_secret';
149 2 Sven Nosse
grant all privileges on redmine.* to 'redmine'@'localhost'; 
150 2 Sven Nosse
quit;
151 2 Sven Nosse
</pre>
152 2 Sven Nosse
153 19 Hung Nguyen Vu
Note: If you are going to store Redmine's database to a machine that is not the server you are going to install Redmine - whose IP address is 192.168.10.100, the settings should be: 
154 19 Hung Nguyen Vu
<pre>
155 19 Hung Nguyen Vu
create database redmine character set utf8;
156 19 Hung Nguyen Vu
create user 'redmine'@'192.168.10.100' identified by 'very_secret';
157 19 Hung Nguyen Vu
grant all privileges on redmine.* to 'redmine'@'192.168.10.100'; 
158 19 Hung Nguyen Vu
quit;
159 19 Hung Nguyen Vu
</pre>
160 19 Hung Nguyen Vu
161 19 Hung Nguyen Vu
162 2 Sven Nosse
h3. Configure Redmine
163 2 Sven Nosse
164 2 Sven Nosse
First of all, copy the example config to a productive one and edit the config for your needs
165 2 Sven Nosse
<pre>
166 2 Sven Nosse
cd /var/www/redmine/config
167 2 Sven Nosse
cp database.yml.example database.yml
168 2 Sven Nosse
vi /var/www/redmine/config/database.yml
169 2 Sven Nosse
</pre>
170 2 Sven Nosse
Now find the production section inside this file and edit it like that
171 2 Sven Nosse
<pre>
172 2 Sven Nosse
...
173 2 Sven Nosse
production:
174 13 Hung Nguyen Vu
# adapter = mysql2 is newer and proven to be more better than mysql
175 13 Hung Nguyen Vu
# adapter: mysql2
176 2 Sven Nosse
  adapter: mysql
177 2 Sven Nosse
  database: redmine
178 2 Sven Nosse
  host: localhost
179 2 Sven Nosse
  username: redmine
180 2 Sven Nosse
  password: very_secret
181 2 Sven Nosse
  encoding: utf8
182 2 Sven Nosse
...
183 2 Sven Nosse
</pre>
184 2 Sven Nosse
Head back to your application directory and generate a secret token
185 2 Sven Nosse
<pre>
186 2 Sven Nosse
cd /var/www/redmine/
187 2 Sven Nosse
rake generate_secret_token
188 2 Sven Nosse
</pre>
189 1 Sven Nosse
Now it is about time to generate the database structure (application directory!)
190 1 Sven Nosse
<pre>
191 2 Sven Nosse
cd /var/www/redmine/
192 2 Sven Nosse
RAILS_ENV=production rake db:migrate
193 2 Sven Nosse
</pre>
194 2 Sven Nosse
fill the database with default values...
195 1 Sven Nosse
<pre>
196 2 Sven Nosse
cd /var/www/redmine/
197 2 Sven Nosse
RAILS_ENV=production rake redmine:load_default_data
198 2 Sven Nosse
</pre>
199 2 Sven Nosse
follow the instructions to select your language.
200 2 Sven Nosse
201 6 Hung Nguyen Vu
h3. Mind the firewall!
202 2 Sven Nosse
203 6 Hung Nguyen Vu
Be aware that the firewall is enabled by default (which is good!). So if you know which ports to open, do it now or disable the firewall (just for testing purposes). I'd really recommend disabling the firewall during installation and enable it (opening ports) after you are sure that everything works.
204 1 Sven Nosse
<pre>
205 2 Sven Nosse
system-config-firewall
206 2 Sven Nosse
</pre>
207 2 Sven Nosse
use the onscreen menu to disable it or adjust the values.
208 2 Sven Nosse
209 8 Hung Nguyen Vu
or simply disable iptables during Redmine's setup
210 8 Hung Nguyen Vu
<pre>
211 8 Hung Nguyen Vu
service iptables stop
212 8 Hung Nguyen Vu
</pre>
213 8 Hung Nguyen Vu
214 6 Hung Nguyen Vu
h3. Do a testdrive!
215 2 Sven Nosse
216 2 Sven Nosse
I mentioned that I wanted not to use webrick, but for a testdrive, it'll work. This helps finding bugs and errors that might have occured before.
217 2 Sven Nosse
<pre>
218 2 Sven Nosse
cd /var/www/redmine/
219 2 Sven Nosse
ruby script/rails server webrick -e production
220 2 Sven Nosse
</pre>
221 2 Sven Nosse
Open up a browser and point it to: http://yoursystemname.yourdomain.com:3000 - the default username and password is 'admin'.
222 2 Sven Nosse
If everything is working, you are good to go! Kill webrick by hitting Ctrl+C.
223 2 Sven Nosse
224 6 Hung Nguyen Vu
h3. Activate FCGI and generate plugin directory
225 2 Sven Nosse
226 2 Sven Nosse
To activate the fcgi module you need to copy the example file and edit the very first line. During this step it is recommended to generate the default .htaccess config as well.
227 2 Sven Nosse
<pre>
228 2 Sven Nosse
cd /var/www/redmine/public
229 2 Sven Nosse
mkdir plugin_assets
230 2 Sven Nosse
cp dispatch.fcgi.example dispatch.fcgi
231 2 Sven Nosse
cp htaccess.fcgi.example .htaccess
232 1 Sven Nosse
vi /var/www/redmine/public/dispatch.fcgi
233 1 Sven Nosse
</pre>
234 2 Sven Nosse
now edit dispatch.fcgi and change it like this...
235 2 Sven Nosse
<pre>
236 2 Sven Nosse
#!/usr/bin/ruby
237 2 Sven Nosse
...
238 2 Sven Nosse
</pre>
239 2 Sven Nosse
240 2 Sven Nosse
h3. Apache permissions!
241 2 Sven Nosse
242 2 Sven Nosse
this one is important, so don't miss that one... 
243 1 Sven Nosse
<pre>
244 2 Sven Nosse
chown -R apache:apache /var/www/redmine/
245 1 Sven Nosse
</pre>
246 2 Sven Nosse
247 6 Hung Nguyen Vu
Note: "apache" is the user that runs httpd (apache) service, as defined in /etc/password and /etc/httpd/conf/httpd.conf 
248 6 Hung Nguyen Vu
249 2 Sven Nosse
h3. Getting Apache to work with FastCGI
250 2 Sven Nosse
251 2 Sven Nosse
Unfortunately the default Repo from CentOS cannot deliver the fcgid module so it is important to include a replo, that can deliver this package. I use the Fedora Repo so it is time to activate this... Again - this can change so please take care which repository to use.
252 2 Sven Nosse
<pre>
253 2 Sven Nosse
rpm --import https://fedoraproject.org/static/0608B895.txt
254 2 Sven Nosse
wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-7.noarch.rpm
255 2 Sven Nosse
rpm -ivh epel-release-6-7.noarch.rpm
256 2 Sven Nosse
yum -y install mod_fcgid
257 2 Sven Nosse
</pre>
258 2 Sven Nosse
259 6 Hung Nguyen Vu
h3. Set the file path for Redmine
260 2 Sven Nosse
261 2 Sven Nosse
I wanted to move the files to another location, so I decided to move them to /opt/redmine
262 2 Sven Nosse
<pre>
263 6 Hung Nguyen Vu
mkdir -p /opt/redmine/files
264 2 Sven Nosse
chown -R apache:apache /opt/redmine
265 2 Sven Nosse
</pre>
266 2 Sven Nosse
now edit the configuration
267 2 Sven Nosse
<pre>
268 2 Sven Nosse
cd /var/www/redmine/config
269 2 Sven Nosse
cp configuration.yml.example configuration.yml
270 2 Sven Nosse
vi /var/www/redmine/config/configuration.yml
271 2 Sven Nosse
</pre>
272 2 Sven Nosse
edit the path settings inside this file...
273 2 Sven Nosse
<pre>
274 2 Sven Nosse
...
275 2 Sven Nosse
  attachments_storage_path: /opt/redmine/files
276 2 Sven Nosse
...
277 2 Sven Nosse
</pre>
278 2 Sven Nosse
279 2 Sven Nosse
h3. Telling Apache to serve REDMINE
280 2 Sven Nosse
281 2 Sven Nosse
The final step is to tell apache, where to find Redmine and what to do with it. Generate a new conf file for your virtual host to serve redmine...
282 2 Sven Nosse
<pre>
283 2 Sven Nosse
vi /etc/httpd/conf.d/redmine.conf
284 2 Sven Nosse
</pre>
285 2 Sven Nosse
and enter the following config (adjust to your needs ;) )
286 2 Sven Nosse
<pre>
287 2 Sven Nosse
<VirtualHost *:80>
288 2 Sven Nosse
        ServerName yoursystemname.yourdomain.com
289 2 Sven Nosse
        ServerAdmin yourmail@yourdomain.com
290 2 Sven Nosse
        DocumentRoot /var/www/redmine/public/
291 2 Sven Nosse
        ErrorLog logs/redmine_error_log
292 2 Sven Nosse
293 2 Sven Nosse
        MaxRequestLen 20971520
294 2 Sven Nosse
295 2 Sven Nosse
        <Directory "/var/www/redmine/public/">
296 2 Sven Nosse
297 2 Sven Nosse
                Options Indexes ExecCGI FollowSymLinks
298 2 Sven Nosse
                Order allow,deny
299 2 Sven Nosse
                Allow from all
300 2 Sven Nosse
                AllowOverride all
301 2 Sven Nosse
        </Directory>
302 2 Sven Nosse
</VirtualHost>
303 2 Sven Nosse
</pre>
304 2 Sven Nosse
Restart Apache and cross your fingers, wheter you can access http://yoursystemname.yourdomain.com - redmine should be available right now...
305 2 Sven Nosse
<pre>
306 2 Sven Nosse
service httpd restart
307 2 Sven Nosse
</pre>
308 2 Sven Nosse
309 2 Sven Nosse
h3. Additional Config: E-Mail System
310 2 Sven Nosse
311 1 Sven Nosse
in order to get emails sent to your clients, edit the configuration.yml and enter your server settings...
312 1 Sven Nosse
<pre>
313 1 Sven Nosse
vi /var/www/redmine/config/configuration.yml
314 1 Sven Nosse
</pre>
315 1 Sven Nosse
now find the settings for your server... the following settings describe an anonymous relay on an internal server. You need to remove the username and password line if you use anonymous sign on.
316 1 Sven Nosse
<pre>
317 1 Sven Nosse
...
318 1 Sven Nosse
default:
319 1 Sven Nosse
  # Outgoing emails configuration (see examples above)
320 1 Sven Nosse
  email_delivery:
321 1 Sven Nosse
    delivery_method: :smtp
322 1 Sven Nosse
    smtp_settings:
323 1 Sven Nosse
      address: mailserver.yourdomain.com
324 1 Sven Nosse
      port: 25
325 1 Sven Nosse
      domain: yourdomain.com
326 1 Sven Nosse
...
327 1 Sven Nosse
</pre>
328 1 Sven Nosse
329 6 Hung Nguyen Vu
Here is the configration if you use Google's SMTP server
330 6 Hung Nguyen Vu
331 6 Hung Nguyen Vu
<pre>
332 6 Hung Nguyen Vu
production:
333 6 Hung Nguyen Vu
  email_delivery:
334 6 Hung Nguyen Vu
    delivery_method: :smtp
335 6 Hung Nguyen Vu
    smtp_settings:
336 6 Hung Nguyen Vu
#      tls: true
337 6 Hung Nguyen Vu
      enable_starttls_auto: true
338 6 Hung Nguyen Vu
      address: "smtp.gmail.com"
339 6 Hung Nguyen Vu
      port: '587'
340 6 Hung Nguyen Vu
      domain: "smtp.gmail.com"
341 6 Hung Nguyen Vu
      authentication: :plain
342 6 Hung Nguyen Vu
      user_name: "google-account-name@domain-name.domain-extension"
343 6 Hung Nguyen Vu
      password: "password"
344 6 Hung Nguyen Vu
</pre>
345 6 Hung Nguyen Vu
346 1 Sven Nosse
h2. Getting Subversion working
347 2 Sven Nosse
348 2 Sven Nosse
After getting Redmine working, it is time to get Subversion working... The goal is to integrate the repositories inside Redmine and host them on the same server...
349 2 Sven Nosse
350 2 Sven Nosse
h3. Installing Packages for Subversion
351 2 Sven Nosse
352 2 Sven Nosse
Install the following packages
353 1 Sven Nosse
<pre>
354 2 Sven Nosse
yum -y install mod_dav_svn subversion subversion-ruby
355 2 Sven Nosse
</pre>
356 2 Sven Nosse
357 2 Sven Nosse
h3. Linking authentication for Redmine
358 2 Sven Nosse
359 2 Sven Nosse
Redmine provides a perl module to handle Apache authentication on SVN DAV repositories. First step is to link that module into the search path
360 2 Sven Nosse
<pre>
361 2 Sven Nosse
mkdir /usr/lib/perl5/vendor_perl/Apache
362 2 Sven Nosse
ln -s /var/www/redmine/extra/svn/Redmine.pm /usr/lib/perl5/vendor_perl/Apache/Redmine.pm
363 2 Sven Nosse
</pre>
364 2 Sven Nosse
365 16 Sven Nosse
h3. Creating a path for subversion repositories
366 2 Sven Nosse
367 2 Sven Nosse
create a path and set permissions for your SVN repo...
368 2 Sven Nosse
<pre>
369 2 Sven Nosse
mkdir /opt/subversion
370 2 Sven Nosse
chown -R apache:apache /opt/subversion
371 2 Sven Nosse
</pre>
372 2 Sven Nosse
373 6 Hung Nguyen Vu
h3. Edit virtual host for apache to serve SVN with redmine
374 2 Sven Nosse
375 2 Sven Nosse
to get Apache working with subversion, you need to adjust (create) the virtual host file
376 2 Sven Nosse
<pre>
377 2 Sven Nosse
vi /etc/httpd/conf.d/subversion.conf
378 2 Sven Nosse
</pre>
379 2 Sven Nosse
now enter/edit the following
380 2 Sven Nosse
<pre>
381 2 Sven Nosse
PerlLoadModule Apache::Redmine
382 2 Sven Nosse
<Location /svn>
383 2 Sven Nosse
        DAV svn
384 2 Sven Nosse
        SVNParentPath "/opt/subversion"
385 2 Sven Nosse
        SVNListParentPath on
386 2 Sven Nosse
        Order deny,allow
387 2 Sven Nosse
        Deny from all
388 2 Sven Nosse
        Satisfy any
389 2 Sven Nosse
        LimitXMLRequestBody 0
390 2 Sven Nosse
        SVNPathAuthz off
391 2 Sven Nosse
392 2 Sven Nosse
        PerlAccessHandler Apache::Authn::Redmine::access_handler
393 2 Sven Nosse
        PerlAuthenHandler Apache::Authn::Redmine::authen_handler
394 2 Sven Nosse
        AuthType Basic
395 2 Sven Nosse
        AuthName "Redmine SVN Repository"
396 2 Sven Nosse
397 2 Sven Nosse
        Require valid-user
398 2 Sven Nosse
        RedmineDSN "DBI:mysql:database=redmine;host=localhost:3306"
399 2 Sven Nosse
        RedmineDbUser "redmine"
400 15 Sven Nosse
        RedmineDbPass "very_secret"
401 2 Sven Nosse
402 2 Sven Nosse
        # cache max. 50 passwords
403 1 Sven Nosse
        RedmineCacheCredsMax 50
404 1 Sven Nosse
</Location>
405 14 Sven Nosse
</pre>
406 14 Sven Nosse
407 17 Hung Nguyen Vu
h3. Achievements
408 14 Sven Nosse
409 17 Hung Nguyen Vu
What we've done at this point:
410 17 Hung Nguyen Vu
* A running Redmine v2.0.3 installation using Apache Passenger
411 17 Hung Nguyen Vu
* Working authentication with Redmine's builtin database
412 17 Hung Nguyen Vu
* Working Subversion with Apache's WebDav
413 17 Hung Nguyen Vu
* Subversion authentication against redmine's builtin database
414 14 Sven Nosse
415 14 Sven Nosse
h2. Authentication against Active Directory
416 14 Sven Nosse
417 14 Sven Nosse
The last step requires some knowledge how to authenticate against your Active directory. First of all, open up Redmine in a web interface and enter the Administration dialogue. Select LDAP-Authentication adn create a new authentication entry.
418 14 Sven Nosse
419 14 Sven Nosse
* Name: Enter a NAME for your entry, this can be anything... 
420 14 Sven Nosse
* Host: Enter the IP address of a domain controler unless you are really sure, that DNS is working correctly
421 14 Sven Nosse
* Port: 389
422 14 Sven Nosse
* Account: This one is kind of a pitfall. Enter the DN of the user object that can authenticate against the Active Directory.
423 14 Sven Nosse
??EXAMPLE??: Assume that you have a domain that is called: mynetwork.local and an organizational unit that is named: myUsers. The DN of this organizational unit is: @OU=myUsers, DC=mynetwork, DC=local@ If you create a user, which Display name is like ??ldap authentication user?? then the Account you need to enter is: @CN=ldap authentication user, OU=myUsers, DC=mynetwork, DC=local@. I'd recommend using a tool like Sysinternals ADExplorer if you are unsure about the distinguished name of your authentication user.
424 14 Sven Nosse
* Base DN: This is the entry point, where Redmine tries to find users. In the example above you want to enter: @OU=myUsers, DC=mynetwork, DC=local@
425 14 Sven Nosse
* LDAP Filter: You can enter any filter you like here, a valid filter for finding users is: @(&(objectClass=user)(objectCategory=person))@. 
426 14 Sven Nosse
* On-the-fly Usercreation: I tend to check this.. This allows the initial creation of a new user when the user logs on redmine.
427 14 Sven Nosse
428 14 Sven Nosse
Attributes: _(I am not sure, whether the fields below are correctly tranlsated... please correct if necessary)_
429 14 Sven Nosse
* member name: sAMAccountName
430 14 Sven Nosse
* first name: givenname
431 14 Sven Nosse
* surname: sn
432 14 Sven Nosse
* E-Mail: mail
433 14 Sven Nosse
434 14 Sven Nosse
Save it, try it :)
435 14 Sven Nosse
436 14 Sven Nosse
You should be able to log on with your windows logon name and your windows passwort. If you've never logged on a new account should have been created within the redmine built in database.
437 14 Sven Nosse
438 14 Sven Nosse
h2. Last step - authenticate Subversion against active directory (by using the built in database from redmine!)
439 14 Sven Nosse
440 14 Sven Nosse
This one is tricky, you want the authentication data from Active Directory but you also want the group permissions from redmine. So you need to tell the logon mechanism to authenticate against AD and check inside the database, whether the user is SVN editor or not. Finally most of the work is done here with the redmine.pm script (remember, we've linked that already). But unfortunatelly the CentOS Perl implementation includes no module for Simple::LDAP. So we need to do some compiler work... 
441 14 Sven Nosse
442 14 Sven Nosse
First of all, fetch the packages needed for building the necessary perl module(s).
443 14 Sven Nosse
<pre>
444 14 Sven Nosse
yum -y install perl-CPAN perl-YAML
445 14 Sven Nosse
</pre>
446 14 Sven Nosse
447 14 Sven Nosse
There are a lot of dependencies when trying to build the module, so I recommend to turn on automatic dependency handling inside the CPAN shell....
448 14 Sven Nosse
Start up the shell:
449 14 Sven Nosse
<pre>
450 14 Sven Nosse
perl -MCPAN -e shell
451 14 Sven Nosse
</pre>
452 14 Sven Nosse
and then run the following two commands:
453 14 Sven Nosse
<pre>
454 14 Sven Nosse
o conf prerequisites_policy follow
455 14 Sven Nosse
o conf commit
456 14 Sven Nosse
</pre>
457 14 Sven Nosse
Now it is time, to install the module, still inside the shell. Enter
458 14 Sven Nosse
<pre>
459 14 Sven Nosse
install Authen::Simple::LDAP
460 14 Sven Nosse
</pre>
461 14 Sven Nosse
This takes some time... If queried for any dependencies or defaults, just acknowledge them with their default values - this should work.
462 14 Sven Nosse
Close the shell after everything is done by entering
463 14 Sven Nosse
<pre>
464 14 Sven Nosse
exit
465 14 Sven Nosse
</pre>
466 14 Sven Nosse
467 14 Sven Nosse
Now we need to tell Apache where to find the authentication data, this is simple by editing the subversion.conf
468 14 Sven Nosse
<pre>
469 14 Sven Nosse
vi /etc/httpd/conf.d/subversion.conf
470 14 Sven Nosse
</pre>
471 14 Sven Nosse
just add the Simple::LDAP Perl module by editing it this way:
472 14 Sven Nosse
<pre>
473 14 Sven Nosse
   ...
474 14 Sven Nosse
   PerlLoadModule Apache::Redmine
475 14 Sven Nosse
   PerlLoadModule  Authen::Simple::LDAP
476 14 Sven Nosse
   <Location /svn>
477 14 Sven Nosse
     DAV svn
478 14 Sven Nosse
     ...
479 14 Sven Nosse
</pre>
480 14 Sven Nosse
481 14 Sven Nosse
Restart Apache and LDAP Authentication should work now
482 14 Sven Nosse
<pre>
483 14 Sven Nosse
service httpd restart
484 2 Sven Nosse
</pre>