fix grammar typo
[catagits/Catalyst-Manual.git] / lib / Catalyst / Manual / Tutorial / 05_Authentication.pod
CommitLineData
d442cc9f 1=head1 NAME
2
3ab6187c 3Catalyst::Manual::Tutorial::05_Authentication - Catalyst Tutorial - Chapter 5: Authentication
d442cc9f 4
5
6=head1 OVERVIEW
7
4b4d3884 8This is B<Chapter 5 of 10> for the Catalyst tutorial.
d442cc9f 9
10L<Tutorial Overview|Catalyst::Manual::Tutorial>
11
12=over 4
13
14=item 1
15
3ab6187c 16L<Introduction|Catalyst::Manual::Tutorial::01_Intro>
d442cc9f 17
18=item 2
19
3ab6187c 20L<Catalyst Basics|Catalyst::Manual::Tutorial::02_CatalystBasics>
d442cc9f 21
22=item 3
23
3ab6187c 24L<More Catalyst Basics|Catalyst::Manual::Tutorial::03_MoreCatalystBasics>
d442cc9f 25
26=item 4
27
3ab6187c 28L<Basic CRUD|Catalyst::Manual::Tutorial::04_BasicCRUD>
d442cc9f 29
30=item 5
31
3ab6187c 32B<05_Authentication>
d442cc9f 33
34=item 6
35
3ab6187c 36L<Authorization|Catalyst::Manual::Tutorial::06_Authorization>
d442cc9f 37
38=item 7
39
3ab6187c 40L<Debugging|Catalyst::Manual::Tutorial::07_Debugging>
d442cc9f 41
42=item 8
43
3ab6187c 44L<Testing|Catalyst::Manual::Tutorial::08_Testing>
d442cc9f 45
46=item 9
47
3ab6187c 48L<Advanced CRUD|Catalyst::Manual::Tutorial::09_AdvancedCRUD>
d442cc9f 49
3533daff 50=item 10
d442cc9f 51
3ab6187c 52L<Appendices|Catalyst::Manual::Tutorial::10_Appendices>
d442cc9f 53
3533daff 54=back
2d0526d1 55
2d0526d1 56
d442cc9f 57=head1 DESCRIPTION
58
905a3a26 59Now that we finally have a simple yet functional application, we can
60focus on providing authentication (with authorization coming next in
4b4d3884 61Chapter 6).
d442cc9f 62
4b4d3884 63This chapter of the tutorial is divided into two main sections: 1) basic,
d442cc9f 64cleartext authentication and 2) hash-based authentication.
65
66You can checkout the source code for this example from the catalyst
67subversion repository as per the instructions in
3ab6187c 68L<Catalyst::Manual::Tutorial::01_Intro|Catalyst::Manual::Tutorial::01_Intro>.
d442cc9f 69
fbbb9084 70
d442cc9f 71=head1 BASIC AUTHENTICATION
72
73This section explores how to add authentication logic to a Catalyst
74application.
75
76
77=head2 Add Users and Roles to the Database
78
79First, we add both user and role information to the database (we will
80add the role information here although it will not be used until the
4b4d3884 81authorization section, Chapter 6). Create a new SQL script file by opening
d442cc9f 82C<myapp02.sql> in your editor and insert:
83
84 --
3b1fa91b 85 -- Add user and role tables, along with a many-to-many join table
d442cc9f 86 --
3b1fa91b 87 CREATE TABLE user (
d442cc9f 88 id INTEGER PRIMARY KEY,
89 username TEXT,
90 password TEXT,
91 email_address TEXT,
92 first_name TEXT,
93 last_name TEXT,
94 active INTEGER
95 );
3b1fa91b 96 CREATE TABLE role (
d442cc9f 97 id INTEGER PRIMARY KEY,
98 role TEXT
99 );
3b1fa91b 100 CREATE TABLE user_role (
b66dd084 101 user_id INTEGER REFERENCES user(id) ON DELETE CASCADE ON UPDATE CASCADE,
102 role_id INTEGER REFERENCES role(id) ON DELETE CASCADE ON UPDATE CASCADE,
d442cc9f 103 PRIMARY KEY (user_id, role_id)
104 );
105 --
106 -- Load up some initial test data
107 --
3b1fa91b 108 INSERT INTO user VALUES (1, 'test01', 'mypass', 't01@na.com', 'Joe', 'Blow', 1);
109 INSERT INTO user VALUES (2, 'test02', 'mypass', 't02@na.com', 'Jane', 'Doe', 1);
110 INSERT INTO user VALUES (3, 'test03', 'mypass', 't03@na.com', 'No', 'Go', 0);
111 INSERT INTO role VALUES (1, 'user');
112 INSERT INTO role VALUES (2, 'admin');
113 INSERT INTO user_role VALUES (1, 1);
114 INSERT INTO user_role VALUES (1, 2);
115 INSERT INTO user_role VALUES (2, 1);
116 INSERT INTO user_role VALUES (3, 1);
d442cc9f 117
118Then load this into the C<myapp.db> database with the following command:
119
120 $ sqlite3 myapp.db < myapp02.sql
121
444d6b27 122
d442cc9f 123=head2 Add User and Role Information to DBIC Schema
124
3533daff 125Although we could manually edit the DBIC schema information to include
126the new tables added in the previous step, let's use the C<create=static>
127option on the DBIC model helper to do most of the work for us:
d442cc9f 128
acbd7bdd 129 $ script/myapp_create.pl model DB DBIC::Schema MyApp::Schema \
b66dd084 130 create=static components=TimeStamp dbi:SQLite:myapp.db \
131 on_connect_do="PRAGMA foreign_keys = ON"
1390ef0e 132 exists "/root/dev/MyApp/script/../lib/MyApp/Model"
133 exists "/root/dev/MyApp/script/../t"
134 Dumping manual schema for MyApp::Schema to directory /root/dev/MyApp/script/../lib ...
135 Schema dump completed.
136 exists "/root/dev/MyApp/script/../lib/MyApp/Model/DB.pm"
137 $
acbd7bdd 138 $ ls lib/MyApp/Schema/Result
3b1fa91b 139 Author.pm BookAuthor.pm Book.pm Role.pm User.pm UserRole.pm
d442cc9f 140
905a3a26 141Notice how the helper has added three new table-specific result source
acbd7bdd 142files to the C<lib/MyApp/Schema/Result> directory. And, more
905a3a26 143importantly, even if there were changes to the existing result source
144files, those changes would have only been written above the C<# DO NOT
191dee29 145MODIFY THIS OR ANYTHING ABOVE!> comment and your hand-edited
3533daff 146enhancements would have been preserved.
d442cc9f 147
3b1fa91b 148Speaking of "hand-editted enhancements," we should now add
905a3a26 149relationship information to the three new result source files. Edit
150each of these files and add the following information between the C<#
3533daff 151DO NOT MODIFY THIS OR ANYTHING ABOVE!> comment and the closing C<1;>:
d442cc9f 152
3b1fa91b 153C<lib/MyApp/Schema/Result/User.pm>:
d442cc9f 154
b66dd084 155
3533daff 156 # many_to_many():
157 # args:
158 # 1) Name of relationship, DBIC will create accessor with this name
905a3a26 159 # 2) Name of has_many() relationship this many_to_many() is shortcut for
160 # 3) Name of belongs_to() relationship in model class of has_many() above
3533daff 161 # You must already have the has_many() defined to use a many_to_many().
b66dd084 162 __PACKAGE__->many_to_many(roles => 'user_roles', 'role');
d442cc9f 163
3533daff 164
b66dd084 165The code for this update is obviously very similar to the edits we made to the
166C<Book> and C<Author> classes created in Chapter 3.
3533daff 167
636ba9f7 168Note that we do not need to make any change to the
169C<lib/MyApp/Schema.pm> schema file. It simply tells DBIC to load all
170of the Result Class and ResultSet Class files it finds in below the
171C<lib/MyApp/Schema> directory, so it will automatically pick up our
acbd7bdd 172new table information.
d442cc9f 173
174
175=head2 Sanity-Check Reload of Development Server
176
905a3a26 177We aren't ready to try out the authentication just yet; we only want
178to do a quick check to be sure our model loads correctly. Press
179C<Ctrl-C> to kill the previous server instance (if it's still running)
3533daff 180and restart it:
d442cc9f 181
182 $ script/myapp_server.pl
183
184Look for the three new model objects in the startup debug output:
185
186 ...
187 .-------------------------------------------------------------------+----------.
188 | Class | Type |
189 +-------------------------------------------------------------------+----------+
190 | MyApp::Controller::Books | instance |
191 | MyApp::Controller::Root | instance |
d0496197 192 | MyApp::Model::DB | instance |
193 | MyApp::Model::DB::Author | class |
3b1fa91b 194 | MyApp::Model::DB::Book | class |
195 | MyApp::Model::DB::BookAuthor | class |
196 | MyApp::Model::DB::Role | class |
197 | MyApp::Model::DB::User | class |
198 | MyApp::Model::DB::UserRole | class |
d442cc9f 199 | MyApp::View::TT | instance |
200 '-------------------------------------------------------------------+----------'
201 ...
202
acbd7bdd 203Again, notice that your "Result Class" classes have been "re-loaded"
3533daff 204by Catalyst under C<MyApp::Model>.
d442cc9f 205
206
207=head2 Include Authentication and Session Plugins
208
905a3a26 209Edit C<lib/MyApp.pm> and update it as follows (everything below
3533daff 210C<StackTrace> is new):
d442cc9f 211
acbd7bdd 212 # Load plugins
2a6eb5f9 213 use Catalyst qw/
214 -Debug
3b1fa91b 215 ConfigLoader
216 Static::Simple
efdaddec 217
3b1fa91b 218 StackTrace
efdaddec 219
3b1fa91b 220 Authentication
efdaddec 221
3b1fa91b 222 Session
223 Session::Store::FastMmap
224 Session::State::Cookie
225 /;
d442cc9f 226
636ba9f7 227B<Note:> As discussed in MoreCatalystBasics, different versions of
444d6b27 228C<Catalyst::Devel> have used a variety of methods to load the plugins,
229but we are going to use the current Catalyst 5.8X practice of putting
230them on the C<use Catalyst> line.
94d8da41 231
905a3a26 232The C<Authentication> plugin supports Authentication while the
233C<Session> plugins are required to maintain state across multiple HTTP
234requests.
6d0971ad 235
905a3a26 236Note that the only required Authentication class is the main one. This
237is a change that occurred in version 0.09999_01 of the
238C<Authentication> plugin. You B<do not need> to specify a particular
239Authentication::Store or Authentication::Credential plugin. Instead,
240indicate the Store and Credential you want to use in your application
6d0971ad 241configuration (see below).
242
3b1fa91b 243Make sure you include the additional plugins as new dependencies in
244the Makefile.PL file something like this:
245
246 requires (
247 'Catalyst::Plugin::Authentication' => '0',
248 'Catalyst::Plugin::Session' => '0',
249 'Catalyst::Plugin::Session::Store::FastMmap' => '0',
250 'Catalyst::Plugin::Session::State::Cookie' => '0',
251 );
252
905a3a26 253Note that there are several options for
254L<Session::Store|Catalyst::Plugin::Session::Store>
255(L<Session::Store::FastMmap|Catalyst::Plugin::Session::Store::FastMmap>
256is generally a good choice if you are on Unix; try
257L<Session::Store::File|Catalyst::Plugin::Session::Store::File> if you
258are on Win32) -- consult
259L<Session::Store|Catalyst::Plugin::Session::Store> and its subclasses
3533daff 260for additional information and options (for example to use a database-
261backed session store).
d442cc9f 262
263
264=head2 Configure Authentication
265
3b1fa91b 266There are a variety of ways to provide configuration information to
efdaddec 267L<Catalyst::Plugin::Authentication|Catalyst::Plugin::Authentication>.
268Here we will use
269L<Catalyst::Authentication::Realm::SimpleDB|Catalyst::Authentication::Realm::SimpleDB>
270because it automatically sets a reasonable set of defaults for us. Open
271C<lib/MyApp.pm> and place the following text above the call to
272C<__PACKAGE__-E<gt>setup();>:
273
274 # Configure SimpleDB Authentication
275 __PACKAGE__->config->{'Plugin::Authentication'} = {
276 default => {
277 class => 'SimpleDB',
3b1fa91b 278 user_model => 'DB::User',
efdaddec 279 password_type => 'clear',
280 },
281 };
282
283We could have placed this configuration in C<myapp.conf>, but placing
284it in C<lib/MyApp.pm> is probably a better place since it's not likely
285something that users of your application will want to change during
c3cf3bc3 286deployment (or you could use a mixture: leave C<class> and
287C<user_model> defined in C<lib/MyApp.pm> as we show above, but place
288C<password_type> in C<myapp.conf> to allow the type of password to be
289easily modified during deployment). We will stick with putting
290all of the authentication-related configuration in C<lib/MyApp.pm>
291for the tutorial, but if you wish to use C<myapp.conf>, just convert
292to the following code:
293
294 <Plugin::Authentication>
c3cf3bc3 295 <default>
43707053 296 password_type clear
3b1fa91b 297 user_model DB::User
c3cf3bc3 298 class SimpleDB
299 </default>
300 </Plugin::Authentication>
301
302B<TIP:> Here is a short script that will dump the contents of
303C<MyApp->config> to L<Config::General|Config::General> format in
304C<myapp.conf>:
305
306 $ perl -Ilib -e 'use MyApp; use Config::General;
307 Config::General->new->save_file("myapp.conf", MyApp->config);'
d442cc9f 308
c4fa597d 309B<NOTE:> Because we are using SimpleDB along with a database layout
310that complies with its default assumptions, we don't need to specify
311the names of the columns where our username and password information
312is stored (hence, the "Simple" part of "SimpleDB"). That being said,
87236f03 313SimpleDB lets you specify that type of information if you need to.
c4fa597d 314Take a look at
315C<Catalyst::Authentication::Realm::SimpleDB|Catalyst::Authentication::Realm::SimpleDB>
316for details.
317
1390ef0e 318
d442cc9f 319=head2 Add Login and Logout Controllers
320
321Use the Catalyst create script to create two stub controller files:
322
323 $ script/myapp_create.pl controller Login
324 $ script/myapp_create.pl controller Logout
325
636ba9f7 326You could easily use a single controller here. For example, you could
327have a C<User> controller with both C<login> and C<logout> actions.
328Remember, Catalyst is designed to be very flexible, and leaves such
fbbb9084 329matters up to you, the designer and programmer.
d442cc9f 330
636ba9f7 331Then open C<lib/MyApp/Controller/Login.pm>, locate the
332C<sub index :Path :Args(0)> method (or C<sub index : Private> if you
333are using an older version of Catalyst) that was automatically
334inserted by the helpers when we created the Login controller above,
fbbb9084 335and update the definition of C<sub index> to match:
d442cc9f 336
337 =head2 index
efdaddec 338
d442cc9f 339 Login logic
efdaddec 340
d442cc9f 341 =cut
efdaddec 342
ae492862 343 sub index :Path :Args(0) {
d442cc9f 344 my ($self, $c) = @_;
efdaddec 345
d442cc9f 346 # Get the username and password from form
ab0bd0bb 347 my $username = $c->request->params->{username};
348 my $password = $c->request->params->{password};
efdaddec 349
d442cc9f 350 # If the username and password values were found in form
ab0bd0bb 351 if ($username && $password) {
d442cc9f 352 # Attempt to log the user in
905a3a26 353 if ($c->authenticate({ username => $username,
5fefca35 354 password => $password } )) {
d442cc9f 355 # If successful, then let them use the application
0416017e 356 $c->response->redirect($c->uri_for(
357 $c->controller('Books')->action_for('list')));
d442cc9f 358 return;
359 } else {
360 # Set an error message
361 $c->stash->{error_msg} = "Bad username or password.";
362 }
ab0bd0bb 363 } else {
364 # Set an error message
365 $c->stash->{error_msg} = "Empty username or password.";
d442cc9f 366 }
efdaddec 367
d442cc9f 368 # If either of above don't work out, send to the login page
369 $c->stash->{template} = 'login.tt2';
370 }
371
3b1fa91b 372Be sure to remove the C<$c-E<gt>response-E<gt>body('Matched MyApp::Controller::Login in Login.');>
373line of the C<sub index>.
374
d442cc9f 375This controller fetches the C<username> and C<password> values from the
905a3a26 376login form and attempts to authenticate the user. If successful, it
377redirects the user to the book list page. If the login fails, the user
378will stay at the login page and receive an error message. If the
379C<username> and C<password> values are not present in the form, the
f632e28b 380user will be taken to the empty login form.
d442cc9f 381
636ba9f7 382Note that we could have used something like "C<sub default :Path>",
383however, it is generally recommended (partly for historical reasons,
384and partly for code clarity) only to use C<default> in
385C<MyApp::Controller::Root>, and then mainly to generate the 404 not
85d49fb6 386found page for the application.
ae492862 387
fbbb9084 388Instead, we are using "C<sub somename :Path :Args(0) {...}>" here to
905a3a26 389specifically match the URL C</login>. C<Path> actions (aka, "literal
390actions") create URI matches relative to the namespace of the
391controller where they are defined. Although C<Path> supports
392arguments that allow relative and absolute paths to be defined, here
393we use an empty C<Path> definition to match on just the name of the
394controller itself. The method name, C<index>, is arbitrary. We make
ae492862 395the match even more specific with the C<:Args(0)> action modifier --
905a3a26 396this forces the match on I<only> C</login>, not
d442cc9f 397C</login/somethingelse>.
398
905a3a26 399Next, update the corresponding method in
3533daff 400C<lib/MyApp/Controller/Logout.pm> to match:
d442cc9f 401
402 =head2 index
efdaddec 403
d442cc9f 404 Logout logic
efdaddec 405
d442cc9f 406 =cut
efdaddec 407
ae492862 408 sub index :Path :Args(0) {
d442cc9f 409 my ($self, $c) = @_;
efdaddec 410
d442cc9f 411 # Clear the user's state
412 $c->logout;
efdaddec 413
d442cc9f 414 # Send the user to the starting point
415 $c->response->redirect($c->uri_for('/'));
416 }
417
905a3a26 418As with the login controller, be sure to delete the
14e5ed66 419C<$c-E<gt>response-E<gt>body('Matched MyApp::Controller::Logout in Logout.');>
d442cc9f 420line of the C<sub index>.
421
422
423=head2 Add a Login Form TT Template Page
424
425Create a login form by opening C<root/src/login.tt2> and inserting:
426
427 [% META title = 'Login' %]
efdaddec 428
d442cc9f 429 <!-- Login form -->
8a7c5151 430 <form method="post" action="[% c.uri_for('/login') %]">
d442cc9f 431 <table>
432 <tr>
433 <td>Username:</td>
434 <td><input type="text" name="username" size="40" /></td>
435 </tr>
436 <tr>
437 <td>Password:</td>
438 <td><input type="password" name="password" size="40" /></td>
439 </tr>
440 <tr>
441 <td colspan="2"><input type="submit" name="submit" value="Submit" /></td>
442 </tr>
443 </table>
444 </form>
445
446
447=head2 Add Valid User Check
448
449We need something that provides enforcement for the authentication
450mechanism -- a I<global> mechanism that prevents users who have not
451passed authentication from reaching any pages except the login page.
444d6b27 452This is generally done via an C<auto> action/method in
453C<lib/MyApp/Controller/Root.pm>.
d442cc9f 454
455Edit the existing C<lib/MyApp/Controller/Root.pm> class file and insert
456the following method:
457
458 =head2 auto
efdaddec 459
d442cc9f 460 Check if there is a user and, if not, forward to login page
efdaddec 461
d442cc9f 462 =cut
efdaddec 463
d442cc9f 464 # Note that 'auto' runs after 'begin' but before your actions and that
905a3a26 465 # 'auto's "chain" (all from application path to most specific class are run)
d442cc9f 466 # See the 'Actions' section of 'Catalyst::Manual::Intro' for more info.
467 sub auto : Private {
468 my ($self, $c) = @_;
efdaddec 469
d442cc9f 470 # Allow unauthenticated users to reach the login page. This
191dee29 471 # allows unauthenticated users to reach any action in the Login
d442cc9f 472 # controller. To lock it down to a single action, we could use:
473 # if ($c->action eq $c->controller('Login')->action_for('index'))
905a3a26 474 # to only allow unauthenticated access to the 'index' action we
d442cc9f 475 # added above.
476 if ($c->controller eq $c->controller('Login')) {
477 return 1;
478 }
efdaddec 479
d442cc9f 480 # If a user doesn't exist, force login
481 if (!$c->user_exists) {
482 # Dump a log message to the development server debug output
483 $c->log->debug('***Root::auto User not found, forwarding to /login');
484 # Redirect the user to the login page
485 $c->response->redirect($c->uri_for('/login'));
486 # Return 0 to cancel 'post-auto' processing and prevent use of application
487 return 0;
488 }
efdaddec 489
d442cc9f 490 # User found, so return 1 to continue with processing after this 'auto'
491 return 1;
492 }
493
636ba9f7 494As discussed in
3ab6187c 495L<Catalyst::Manual::Tutorial::03_MoreCatalystBasics/CREATE A CATALYST CONTROLLER>,
636ba9f7 496every C<auto> method from the application/root controller down to the
497most specific controller will be called. By placing the
498authentication enforcement code inside the C<auto> method of
499C<lib/MyApp/Controller/Root.pm> (or C<lib/MyApp.pm>), it will be
500called for I<every> request that is received by the entire
0416017e 501application.
d442cc9f 502
503
504=head2 Displaying Content Only to Authenticated Users
505
506Let's say you want to provide some information on the login page that
507changes depending on whether the user has authenticated yet. To do
508this, open C<root/src/login.tt2> in your editor and add the following
509lines to the bottom of the file:
510
acbd7bdd 511 ...
d442cc9f 512 <p>
513 [%
905a3a26 514 # This code illustrates how certain parts of the TT
d442cc9f 515 # template will only be shown to users who have logged in
516 %]
8a7c5151 517 [% IF c.user_exists %]
518 Please Note: You are already logged in as '[% c.user.username %]'.
519 You can <a href="[% c.uri_for('/logout') %]">logout</a> here.
d442cc9f 520 [% ELSE %]
521 You need to log in to use this application.
522 [% END %]
523 [%#
524 Note that this whole block is a comment because the "#" appears
905a3a26 525 immediate after the "[%" (with no spaces in between). Although it
526 can be a handy way to temporarily "comment out" a whole block of
527 TT code, it's probably a little too subtle for use in "normal"
d442cc9f 528 comments.
529 %]
3533daff 530 </p>
d442cc9f 531
532Although most of the code is comments, the middle few lines provide a
533"you are already logged in" reminder if the user returns to the login
534page after they have already authenticated. For users who have not yet
535authenticated, a "You need to log in..." message is displayed (note the
536use of an IF-THEN-ELSE construct in TT).
537
538
539=head2 Try Out Authentication
540
541Press C<Ctrl-C> to kill the previous server instance (if it's still
542running) and restart it:
543
544 $ script/myapp_server.pl
545
636ba9f7 546B<IMPORTANT NOTE:> If you are having issues with authentication on
547Internet Explorer, be sure to check the system clocks on both your
548server and client machines. Internet Explorer is very picky about
acbd7bdd 549timestamps for cookies. You can quickly sync a Debian system by
550installing the "ntpdate" package:
551
552 sudo aptitude -y install ntpdate
553
554And then run the following command:
25ed8f40 555
acbd7bdd 556 sudo ntpdate-debian
d442cc9f 557
acbd7bdd 558Or, depending on your firewall configuration:
559
560 sudo ntpdate-debian -u
561
636ba9f7 562Note: NTP can be a little more finicky about firewalls because it uses
acbd7bdd 563UDP vs. the more common TCP that you see with most Internet protocols.
564Worse case, you might have to manually set the time on your development
565box instead of using NTP.
1390ef0e 566
636ba9f7 567Now trying going to L<http://localhost:3000/books/list> and you should
568be redirected to the login page, hitting Shift+Reload or Ctrl+Reload
569if necessary (the "You are already logged in" message should I<not>
570appear -- if it does, click the C<logout> button and try again). Note
571the C<***Root::auto User not found...> debug message in the
572development server output. Enter username C<test01> and password
1390ef0e 573C<mypass>, and you should be taken to the Book List page.
d442cc9f 574
575Open C<root/src/books/list.tt2> and add the following lines to the
3533daff 576bottom (below the closing </table> tag):
d442cc9f 577
578 <p>
8a7c5151 579 <a href="[% c.uri_for('/login') %]">Login</a>
0416017e 580 <a href="[% c.uri_for(c.controller.action_for('form_create')) %]">Create</a>
d442cc9f 581 </p>
582
905a3a26 583Reload your browser and you should now see a "Login" and "Create" links
584at the bottom of the page (as mentioned earlier, you can update template
585files without reloading the development server). Click the first link
586to return to the login page. This time you I<should> see the "You are
d442cc9f 587already logged in" message.
588
589Finally, click the C<You can logout here> link on the C</login> page.
590You should stay at the login page, but the message should change to "You
591need to log in to use this application."
592
593
594=head1 USING PASSWORD HASHES
595
efdaddec 596In this section we increase the security of our system by converting
597from cleartext passwords to SHA-1 password hashes that include a
598random "salt" value to make them extremely difficult to crack with
599dictionary and "rainbow table" attacks.
d442cc9f 600
601B<Note:> This section is optional. You can skip it and the rest of the
602tutorial will function normally.
603
fbbb9084 604Be aware that even with the techniques shown in this section, the browser
d442cc9f 605still transmits the passwords in cleartext to your application. We are
606just avoiding the I<storage> of cleartext passwords in the database by
efdaddec 607using a salted SHA-1 hash. If you are concerned about cleartext passwords
d442cc9f 608between the browser and your application, consider using SSL/TLS, made
efdaddec 609easy with the Catalyst plugin Catalyst::Plugin:RequireSSL.
d442cc9f 610
611
efdaddec 612=head2 Re-Run the DBIC::Schema Model Helper to Include DBIx::Class::EncodedColumn
d442cc9f 613
efdaddec 614Next, we can re-run the model helper to have it include
615L<DBIx::Class::EncodedColumn|DBIx::Class::EncodedColumn> in all of the
616Result Classes it generates for us. Simply use the same command we
617saw in Chapters 3 and 4, but add C<,EncodedColumn> to the C<components>
618argument:
d442cc9f 619
efdaddec 620 $ script/myapp_create.pl model DB DBIC::Schema MyApp::Schema \
b66dd084 621 create=static components=TimeStamp,EncodedColumn dbi:SQLite:myapp.db \
622 on_connect_do="PRAGMA foreign_keys = ON"
d442cc9f 623
efdaddec 624If you then open one of the Result Classes, you will see that it
625includes EncodedColumn in the C<load_components> line. Take a look at
3b1fa91b 626C<lib/MyApp/Schema/Result/User.pm> since that's the main class where we
efdaddec 627want to use hashed and salted passwords:
628
629 __PACKAGE__->load_components("InflateColumn::DateTime", "TimeStamp", "EncodedColumn", "Core");
630
631
632=head2 Modify the "password" Column to Use EncodedColumn
633
3b1fa91b 634Open the file C<lib/MyApp/Schema/Result/User.pm> and enter the following
efdaddec 635text below the "# DO NOT MODIFY THIS OR ANYTHING ABOVE!" line but above
636the closing "1;":
637
638 # Have the 'password' column use a SHA-1 hash and 10-character salt
639 # with hex encoding; Generate the 'check_password" method
640 __PACKAGE__->add_columns(
641 'password' => {
642 data_type => "TEXT",
643 size => undef,
644 encode_column => 1,
645 encode_class => 'Digest',
646 encode_args => {salt_length => 10},
647 encode_check_method => 'check_password',
648 },
649 );
650
651This redefines the automatically generated definition for the password
652fields at the top of the Result Class file to now use EncodedColumn
653logic (C<encoded_column> is set to 1). C<encode_class> can be set to
654either C<Digest> to use
655L<DBIx::Class::EncodedColumn::Digest|DBIx::Class::EncodedColumn::Digest>,
656or C<Crypt::Eksblowfish::Bcrypt> for
657L<DBIx::Class::EncodedColumn::Crypt::Eksblowfish::Bcrypt|DBIx::Class::EncodedColumn::Crypt::Eksblowfish::Bcrypt>.
658C<encode_args> is then used to customize the type of Digest you
659selected. Here we only specified the size of the salt to use, but
660we could have also modified the hashing algorithm ('SHA-256' is
661the default) and the format to use ('base64' is the default, but
662'hex' and 'binary' are other options). To use these, you could
663change the C<encode_args> to something like:
664
665 encode_args => {algorithm => 'SHA-1',
666 format => 'hex',
667 salt_length => 10},
668
669
670=head2 Load Hashed Passwords in the Database
671
672Next, let's create a quick script to load some hashed and salted passwords
673into the C<password> column of our C<users> table. Open the file
674C<set_hashed_passwords.pl> in your editor and enter the following text:
675
676 #!/usr/bin/perl
677
678 use strict;
679 use warnings;
680
681 use MyApp::Schema;
682
683 my $schema = MyApp::Schema->connect('dbi:SQLite:myapp.db');
684
3b1fa91b 685 my @users = $schema->resultset('User')->all;
efdaddec 686
687 foreach my $user (@users) {
688 $user->password('mypass');
689 $user->update;
690 }
691
692EncodedColumn lets us simple call C<$user->check_password($password)>
693to see if the user has supplied the correct password, or, as we show
694above, call C<$user->update($new_password)> to update the hashed
695password stored for this user.
696
697Then run the following command:
698
2a6eb5f9 699 $ DBIC_TRACE=1 perl -Ilib set_hashed_passwords.pl
efdaddec 700
c12b0d35 701We had to use the C<-Ilib> argument to tell perl to look under the
efdaddec 702C<lib> directory for our C<MyApp::Schema> model.
703
2a6eb5f9 704The DBIC_TRACE output should show that the update worked:
705
706 $ DBIC_TRACE=1 perl -Ilib set_hashed_passwords.pl
cc0ef55e 707 SELECT me.id, me.username, me.password, me.email_address,
708 me.first_name, me.last_name, me.active FROM user me:
709 UPDATE user SET password = ? WHERE ( id = ? ):
710 'oXiyAcGOjowz7ISUhpIm1IrS8AxSZ9r4jNjpX9VnVeQmN6GRtRKTz', '1'
711 UPDATE user SET password = ? WHERE ( id = ? ):
712 'PmyEPrkB8EGwvaF/DvJm7LIfxoZARjv8ygFIR7pc1gEA1OfwHGNzs', '2'
713 UPDATE user SET password = ? WHERE ( id = ? ):
714 'h7CS1Fm9UCs4hjcbu2im0HumaHCJUq4Uriac+SQgdUMUfFSoOrz3c', '3'
2a6eb5f9 715
716But we can further confirm our actions by dumping the users table:
efdaddec 717
3b1fa91b 718 $ sqlite3 myapp.db "select * from user"
efdaddec 719 1|test01|38d3974fa9e9263099f7bc2574284b2f55473a9bM=fwpX2NR8|t01@na.com|Joe|Blow|1
720 2|test02|6ed8586587e53e0d7509b1cfed5df08feadc68cbMJlnPyPt0I|t02@na.com|Jane|Doe|1
721 3|test03|af929a151340c6aed4d54d7e2651795d1ad2e2f7UW8dHoGv9z|t03@na.com|No|Go|0
722
723As you can see, the passwords are much harder to steal from the
444d6b27 724database (not only are the hashes stored, but every hash is different
725even though the passwords are the same because of the added "salt"
726value). Also note that this demonstrates how to use a DBIx::Class
efdaddec 727model outside of your web application -- a very useful feature in many
728situations.
729
730
731=head2 Enable Hashed and Salted Passwords
732
cc0ef55e 733Edit C<lib/MyApp.pm> and update it to match the following text (the
734only change is to the C<password_type> field):
efdaddec 735
736 # Configure SimpleDB Authentication
737 __PACKAGE__->config->{'Plugin::Authentication'} = {
738 default => {
739 class => 'SimpleDB',
3b1fa91b 740 user_model => 'DB::User',
efdaddec 741 password_type => 'self_check',
742 },
743 };
744
745The use of C<self_check> will cause
746Catalyst::Plugin::Authentication::Store::DBIC to call the
747C<check_password> method we enabled on our C<password> columns.
d442cc9f 748
1390ef0e 749
d442cc9f 750=head2 Try Out the Hashed Passwords
751
752Press C<Ctrl-C> to kill the previous server instance (if it's still
753running) and restart it:
754
755 $ script/myapp_server.pl
756
757You should now be able to go to L<http://localhost:3000/books/list> and
fbbb9084 758login as before. When done, click the "logout" link on the login page
d442cc9f 759(or point your browser at L<http://localhost:3000/logout>).
760
d442cc9f 761
762=head1 USING THE SESSION FOR FLASH
763
4b4d3884 764As discussed in the previous chapter of the tutorial, C<flash> allows
765you to set variables in a way that is very similar to C<stash>, but it
766will remain set across multiple requests. Once the value is read, it
767is cleared (unless reset). Although C<flash> has nothing to do with
768authentication, it does leverage the same session plugins. Now that
769those plugins are enabled, let's go back and update the "delete and
770redirect with query parameters" code seen at the end of the L<Basic
3ab6187c 771CRUD|Catalyst::Manual::Tutorial::04_BasicCRUD> chapter of the tutorial to
4b4d3884 772take advantage of C<flash>.
d442cc9f 773
774First, open C<lib/MyApp/Controller/Books.pm> and modify C<sub delete>
3533daff 775to match the following (everything after the model search line of code
776has changed):
d442cc9f 777
905a3a26 778 =head2 delete
efdaddec 779
d442cc9f 780 Delete a book
efdaddec 781
d442cc9f 782 =cut
efdaddec 783
fbbb9084 784 sub delete :Chained('object') :PathPart('delete') :Args(0) {
785 my ($self, $c) = @_;
efdaddec 786
fbbb9084 787 # Use the book object saved by 'object' and delete it along
788 # with related 'book_authors' entries
789 $c->stash->{object}->delete;
efdaddec 790
d442cc9f 791 # Use 'flash' to save information across requests until it's read
792 $c->flash->{status_msg} = "Book deleted";
efdaddec 793
3533daff 794 # Redirect the user back to the list page
0416017e 795 $c->response->redirect($c->uri_for($self->action_for('list')));
d442cc9f 796 }
797
1390ef0e 798Next, open C<root/src/wrapper.tt2> and update the TT code to pull from
d442cc9f 799flash vs. the C<status_msg> query parameter:
800
1390ef0e 801 ...
d442cc9f 802 <div id="content">
1390ef0e 803 [%# Status and error messages %]
804 <span class="message">[% status_msg || c.flash.status_msg %]</span>
805 <span class="error">[% error_msg %]</span>
806 [%# This is where TT will stick all of your template's contents. -%]
807 [% content %]
808 </div><!-- end content -->
809 ...
905a3a26 810
636ba9f7 811Although the sample above only shows the C<content> div, leave the
cc0ef55e 812rest of the file intact -- the only change we made to replace
813"|| c.request.params.status_msg" with "c.flash.status_msg" in the
814C<< <span class="message"> >> line.
d442cc9f 815
816
817=head2 Try Out Flash
818
636ba9f7 819Restart the development server, log in, and then point your browser to
820L<http://localhost:3000/books/url_create/Test/1/4> to create an extra
821several books. Click the "Return to list" link and delete one of the
822"Test" books you just added. The C<flash> mechanism should retain our
3533daff 823"Book deleted" status message across the redirect.
d442cc9f 824
825B<NOTE:> While C<flash> will save information across multiple requests,
826I<it does get cleared the first time it is read>. In general, this is
827exactly what you want -- the C<flash> message will get displayed on
828the next screen where it's appropriate, but it won't "keep showing up"
829after that first time (unless you reset it). Please refer to
830L<Catalyst::Plugin::Session|Catalyst::Plugin::Session> for additional
831information.
832
1390ef0e 833
3533daff 834=head2 Switch To Flash-To-Stash
835
636ba9f7 836Although the a use of flash above works well, the
1390ef0e 837C<status_msg || c.flash.status_msg> statement is a little ugly. A nice
905a3a26 838alternative is to use the C<flash_to_stash> feature that automatically
1390ef0e 839copies the content of flash to stash. This makes your controller
905a3a26 840and template code work regardless of where it was directly access, a
fbbb9084 841forward, or a redirect. To enable C<flash_to_stash>, you can either
905a3a26 842set the value in C<lib/MyApp.pm> by changing the default
3533daff 843C<__PACKAGE__-E<gt>config> setting to something like:
844
845 __PACKAGE__->config(
efdaddec 846 name => 'MyApp',
444d6b27 847 session => {flash_to_stash => 1},
3533daff 848 );
849
45d511e0 850B<or> add the following to C<myapp.conf>:
3533daff 851
45d511e0 852 <session>
853 flash_to_stash 1
854 </session>
3533daff 855
905a3a26 856The C<__PACKAGE__-E<gt>config> option is probably preferable here
857since it's not something you will want to change at runtime without it
3533daff 858possibly breaking some of your code.
859
1390ef0e 860Then edit C<root/src/wrapper.tt2> and change the C<status_msg> line
861to match the following:
3533daff 862
863 <span class="message">[% status_msg %]</span>
864
865Restart the development server and go to
905a3a26 866L<http://localhost:3000/books/list> in your browser. Delete another
3533daff 867of the "Test" books you added in the previous step. Flash should still
868maintain the status message across the redirect even though you are no
8a7c5151 869longer explicitly accessing C<c.flash>.
3533daff 870
d442cc9f 871
872=head1 AUTHOR
873
874Kennedy Clark, C<hkclark@gmail.com>
875
876Please report any errors, issues or suggestions to the author. The
877most recent version of the Catalyst Tutorial can be found at
59884771 878L<http://dev.catalyst.perl.org/repos/Catalyst/Catalyst-Manual/5.80/trunk/lib/Catalyst/Manual/Tutorial/>.
d442cc9f 879
45c7830f 880Copyright 2006-2008, Kennedy Clark, under Creative Commons License
95674086 881(L<http://creativecommons.org/licenses/by-sa/3.0/us/>).