variable escaping issue [rindolf]
[catagits/Catalyst-Manual.git] / lib / Catalyst / Manual / Tutorial / Authentication.pod
CommitLineData
d442cc9f 1=head1 NAME
2
3Catalyst::Manual::Tutorial::Authentication - Catalyst Tutorial - Part 4: Authentication
4
5
6=head1 OVERVIEW
7
8This is B<Part 4 of 9> for the Catalyst tutorial.
9
10L<Tutorial Overview|Catalyst::Manual::Tutorial>
11
12=over 4
13
14=item 1
15
16L<Introduction|Catalyst::Manual::Tutorial::Intro>
17
18=item 2
19
20L<Catalyst Basics|Catalyst::Manual::Tutorial::CatalystBasics>
21
22=item 3
23
24L<Basic CRUD|Catalyst::Manual::Tutorial::BasicCRUD>
25
26=item 4
27
28B<Authentication>
29
30=item 5
31
32L<Authorization|Catalyst::Manual::Tutorial::Authorization>
33
34=item 6
35
36L<Debugging|Catalyst::Manual::Tutorial::Debugging>
37
38=item 7
39
40L<Testing|Catalyst::Manual::Tutorial::Testing>
41
42=item 8
43
44L<AdvancedCRUD|Catalyst::Manual::Tutorial::AdvancedCRUD>
45
46=item 9
47
48L<Appendices|Catalyst::Manual::Tutorial::Appendices>
49
50=back
51
52
53=head1 DESCRIPTION
54
55Now that we finally have a simple yet functional application, we can
56focus on providing authentication (with authorization coming next in
57Part 5).
58
59This part of the tutorial is divided into two main sections: 1) basic,
60cleartext authentication and 2) hash-based authentication.
61
62You can checkout the source code for this example from the catalyst
63subversion repository as per the instructions in
64L<Catalyst::Manual::Tutorial::Intro>
65
66=head1 BASIC AUTHENTICATION
67
68This section explores how to add authentication logic to a Catalyst
69application.
70
71
72=head2 Add Users and Roles to the Database
73
74First, we add both user and role information to the database (we will
75add the role information here although it will not be used until the
76authorization section, Part 5). Create a new SQL script file by opening
77C<myapp02.sql> in your editor and insert:
78
79 --
80 -- Add users and roles tables, along with a many-to-many join table
81 --
82 CREATE TABLE users (
83 id INTEGER PRIMARY KEY,
84 username TEXT,
85 password TEXT,
86 email_address TEXT,
87 first_name TEXT,
88 last_name TEXT,
89 active INTEGER
90 );
91 CREATE TABLE roles (
92 id INTEGER PRIMARY KEY,
93 role TEXT
94 );
95 CREATE TABLE user_roles (
96 user_id INTEGER,
97 role_id INTEGER,
98 PRIMARY KEY (user_id, role_id)
99 );
100 --
101 -- Load up some initial test data
102 --
103 INSERT INTO users VALUES (1, 'test01', 'mypass', 't01@na.com', 'Joe', 'Blow', 1);
104 INSERT INTO users VALUES (2, 'test02', 'mypass', 't02@na.com', 'Jane', 'Doe', 1);
105 INSERT INTO users VALUES (3, 'test03', 'mypass', 't03@na.com', 'No', 'Go', 0);
106 INSERT INTO roles VALUES (1, 'user');
107 INSERT INTO roles VALUES (2, 'admin');
108 INSERT INTO user_roles VALUES (1, 1);
109 INSERT INTO user_roles VALUES (1, 2);
110 INSERT INTO user_roles VALUES (2, 1);
111 INSERT INTO user_roles VALUES (3, 1);
112
113Then load this into the C<myapp.db> database with the following command:
114
115 $ sqlite3 myapp.db < myapp02.sql
116
117
118=head2 Add User and Role Information to DBIC Schema
119
120This step adds DBIC-based classes for the user-related database tables
121(the role information will not be used until Part 5):
122
123Edit C<lib/MyAppDB.pm> and update the contents to match (only the
124C<MyAppDB =E<gt> [qw/Book BookAuthor Author User UserRole Role/]> line
125has changed):
126
127 package MyAppDB;
128
129 =head1 NAME
130
131 MyAppDB -- DBIC Schema Class
132
133 =cut
134
135 # Our schema needs to inherit from 'DBIx::Class::Schema'
136 use base qw/DBIx::Class::Schema/;
137
138 # Need to load the DB Model classes here.
139 # You can use this syntax if you want:
140 # __PACKAGE__->load_classes(qw/Book BookAuthor Author User UserRole Role/);
141 # Also, if you simply want to load all of the classes in a directory
142 # of the same name as your schema class (as we do here) you can use:
143 # __PACKAGE__->load_classes(qw//);
144 # But the variation below is more flexible in that it can be used to
145 # load from multiple namespaces.
146 __PACKAGE__->load_classes({
147 MyAppDB => [qw/Book BookAuthor Author User UserRole Role/]
148 });
149
150 1;
151
152
153=head2 Create New "Result Source Objects"
154
155Create the following three files with the content shown below.
156
157C<lib/MyAppDB/User.pm>:
158
159 package MyAppDB::User;
160
161 use base qw/DBIx::Class/;
162
163 # Load required DBIC stuff
164 __PACKAGE__->load_components(qw/PK::Auto Core/);
165 # Set the table name
166 __PACKAGE__->table('users');
167 # Set columns in table
168 __PACKAGE__->add_columns(qw/id username password email_address first_name last_name/);
169 # Set the primary key for the table
170 __PACKAGE__->set_primary_key('id');
171
172 #
173 # Set relationships:
174 #
175
176 # has_many():
177 # args:
178 # 1) Name of relationship, DBIC will create accessor with this name
179 # 2) Name of the model class referenced by this relationship
180 # 3) Column name in *foreign* table
181 __PACKAGE__->has_many(map_user_role => 'MyAppDB::UserRole', 'user_id');
182
183
184 =head1 NAME
185
186 MyAppDB::User - A model object representing a person with access to the system.
187
188 =head1 DESCRIPTION
189
190 This is an object that represents a row in the 'users' table of your application
191 database. It uses DBIx::Class (aka, DBIC) to do ORM.
192
193 For Catalyst, this is designed to be used through MyApp::Model::MyAppDB.
194 Offline utilities may wish to use this class directly.
195
196 =cut
197
198 1;
199
200
201C<lib/MyAppDB/Role.pm>:
202
203 package MyAppDB::Role;
204
205 use base qw/DBIx::Class/;
206
207 # Load required DBIC stuff
208 __PACKAGE__->load_components(qw/PK::Auto Core/);
209 # Set the table name
210 __PACKAGE__->table('roles');
211 # Set columns in table
212 __PACKAGE__->add_columns(qw/id role/);
213 # Set the primary key for the table
214 __PACKAGE__->set_primary_key('id');
215
216 #
217 # Set relationships:
218 #
219
220 # has_many():
221 # args:
222 # 1) Name of relationship, DBIC will create accessor with this name
223 # 2) Name of the model class referenced by this relationship
224 # 3) Column name in *foreign* table
225 __PACKAGE__->has_many(map_user_role => 'MyAppDB::UserRole', 'role_id');
226
227
228 =head1 NAME
229
230 MyAppDB::Role - A model object representing a class of access permissions to
231 the system.
232
233 =head1 DESCRIPTION
234
235 This is an object that represents a row in the 'roles' table of your
236 application database. It uses DBIx::Class (aka, DBIC) to do ORM.
237
238 For Catalyst, this is designed to be used through MyApp::Model::MyAppDB.
239 "Offline" utilities may wish to use this class directly.
240
241 =cut
242
243 1;
244
245
246C<lib/MyAppDB/UserRole.pm>:
247
248 package MyAppDB::UserRole;
249
250 use base qw/DBIx::Class/;
251
252 # Load required DBIC stuff
253 __PACKAGE__->load_components(qw/PK::Auto Core/);
254 # Set the table name
255 __PACKAGE__->table('user_roles');
256 # Set columns in table
257 __PACKAGE__->add_columns(qw/user_id role_id/);
258 # Set the primary key for the table
259 __PACKAGE__->set_primary_key(qw/user_id role_id/);
260
261 #
262 # Set relationships:
263 #
264
265 # belongs_to():
266 # args:
267 # 1) Name of relationship, DBIC will create accessor with this name
268 # 2) Name of the model class referenced by this relationship
269 # 3) Column name in *this* table
270 __PACKAGE__->belongs_to(user => 'MyAppDB::User', 'user_id');
271
272 # belongs_to():
273 # args:
274 # 1) Name of relationship, DBIC will create accessor with this name
275 # 2) Name of the model class referenced by this relationship
276 # 3) Column name in *this* table
277 __PACKAGE__->belongs_to(role => 'MyAppDB::Role', 'role_id');
278
279
280 =head1 NAME
281
282 MyAppDB::UserRole - A model object representing the JOIN between Users and Roles.
283
284 =head1 DESCRIPTION
285
286 This is an object that represents a row in the 'user_roles' table of your application
287 database. It uses DBIx::Class (aka, DBIC) to do ORM.
288
289 You probably won't need to use this class directly -- it will be automatically
290 used by DBIC where joins are needed.
291
292 For Catalyst, this is designed to be used through MyApp::Model::MyAppDB.
293 Offline utilities may wish to use this class directly.
294
295 =cut
296
297 1;
298
299The code for these three result source classes is obviously very familiar to the C<Book>, C<Author>, and C<BookAuthor> classes created in Part 2.
300
301
302=head2 Sanity-Check Reload of Development Server
303
304We aren't ready to try out the authentication just yet; we only want to do a quick check to be sure our model loads correctly. Press C<Ctrl-C> to kill the previous server instance (if it's still running) and restart it:
305
306 $ script/myapp_server.pl
307
308Look for the three new model objects in the startup debug output:
309
310 ...
311 .-------------------------------------------------------------------+----------.
312 | Class | Type |
313 +-------------------------------------------------------------------+----------+
314 | MyApp::Controller::Books | instance |
315 | MyApp::Controller::Root | instance |
316 | MyApp::Model::MyAppDB | instance |
317 | MyApp::Model::MyAppDB::Author | class |
318 | MyApp::Model::MyAppDB::Book | class |
319 | MyApp::Model::MyAppDB::BookAuthor | class |
320 | MyApp::Model::MyAppDB::Role | class |
321 | MyApp::Model::MyAppDB::User | class |
322 | MyApp::Model::MyAppDB::UserRole | class |
323 | MyApp::View::TT | instance |
324 '-------------------------------------------------------------------+----------'
325 ...
326
327Again, notice that your "result source" classes have been "re-loaded" by Catalyst under C<MyApp::Model>.
328
329
330=head2 Include Authentication and Session Plugins
331
332Edit C<lib/MyApp.pm> and update it as follows (everything below C<StackTrace> is new):
333
334 use Catalyst qw/
335 -Debug
336 ConfigLoader
337 Static::Simple
338
339 StackTrace
340
341 Authentication
342 Authentication::Store::DBIC
343 Authentication::Credential::Password
344
345 Session
346 Session::Store::FastMmap
347 Session::State::Cookie
348 /;
349
350The three C<Authentication> plugins work together to support
351Authentication while the C<Session> plugins are required to maintain
352state across multiple HTTP requests. Note that there are several
e74b1cd1 353options for L<Session::Store|Catalyst::Plugin::Session::Store>
d442cc9f 354(L<Session::Store::FastMmap|Catalyst::Plugin::Session::Store::FastMmap>
355is generally a good choice if you are on Unix; try
e74b1cd1 356L<Session::Store::File|Catalyst::Plugin::Session::Store::File> if you
357are on Win32) -- consult
358L<Session::Store|Catalyst::Plugin::Session::Store> and its subclasses
359for additional information and options (for example to use a
360database-backed session store).
d442cc9f 361
362
363=head2 Configure Authentication
364
365Although C<__PACKAGE__-E<gt>config(name =E<gt> 'value');> is still
366supported, newer Catalyst applications tend to place all configuration
367information in C<myapp.yml> and automatically load this information into
368C<MyApp-E<gt>config> using the
369L<ConfigLoader|Catalyst::Plugin::ConfigLoader> plugin. Here, we need
370to load several parameters that tell
371L<Catalyst::Plugin::Authentication|Catalyst::Plugin::Authentication>
372where to locate information in your database. To do this, edit the
373C<myapp.yml> YAML and update it to match:
374
375 ---
376 name: MyApp
377 authentication:
378 dbic:
379 # Note this first definition would be the same as setting
380 # __PACKAGE__->config->{authentication}->{dbic}->{user_class} = 'MyAppDB::User'
381 # in lib/MyApp.pm (IOW, each hash key becomes a "name:" in the YAML file).
382 #
383 # This is the model object created by Catalyst::Model::DBIC from your
384 # schema (you created 'MyAppDB::User' but as the Catalyst startup
385 # debug messages show, it was loaded as 'MyApp::Model::MyAppDB::User').
386 # NOTE: Omit 'MyApp::Model' to avoid a component lookup issue in Catalyst 5.66
387 user_class: MyAppDB::User
388 # This is the name of the field in your 'users' table that contains the user's name
389 user_field: username
390 # This is the name of the field in your 'users' table that contains the password
391 password_field: password
392 # Other options can go here for hashed passwords
393
394Inline comments in the code above explain how each field is being used.
395
396B<TIP>: Although YAML uses a very simple and easy-to-ready format, it
397does require the use of a consistent level of indenting. Be sure you
398line up everything on a given 'level' with the same number of indents.
399Also, be sure not to use C<tab> characters (YAML does not support them
400because they are handled inconsistently across editors).
401
402
403=head2 Add Login and Logout Controllers
404
405Use the Catalyst create script to create two stub controller files:
406
407 $ script/myapp_create.pl controller Login
408 $ script/myapp_create.pl controller Logout
409
410B<NOTE>: You could easily use a single controller here. For example,
411you could have a C<User> controller with both C<login> and C<logout>
412actions. Remember, Catalyst is designed to be very flexible, and leaves
413such matters up to you, the designer and programmer.
414
415Then open C<lib/MyApp/Controller/Login.pm>, locate the C<sub index :
416Private> method (this was automatically inserted by the helpers when we
417created the Login controller above), and delete this line:
418
419 $c->response->body('Matched MyApp::Controller::Login in Login.');
420
421Then update it to match:
422
423 =head2 index
424
425 Login logic
426
427 =cut
428
429 sub index : Private {
430 my ($self, $c) = @_;
431
432 # Get the username and password from form
433 my $username = $c->request->params->{username} || "";
434 my $password = $c->request->params->{password} || "";
435
436 # If the username and password values were found in form
437 if ($username && $password) {
438 # Attempt to log the user in
439 if ($c->login($username, $password)) {
440 # If successful, then let them use the application
441 $c->response->redirect($c->uri_for('/books/list'));
442 return;
443 } else {
444 # Set an error message
445 $c->stash->{error_msg} = "Bad username or password.";
446 }
447 }
448
449 # If either of above don't work out, send to the login page
450 $c->stash->{template} = 'login.tt2';
451 }
452
453This controller fetches the C<username> and C<password> values from the
454login form and attempts to perform a login. If successful, it redirects
455the user to the book list page. If the login fails, the user will stay
456at the login page but receive an error message. If the C<username> and
457C<password> values are not present in the form, the user will be taken
458to the empty login form.
459
460Note that we could have used something like C<sub default :Private>;
461however, the use of C<default> actions is discouraged because it does
462not receive path args as with other actions. The recommended practice
463is to only use C<default> in C<MyApp::Controller::Root>.
464
465Another option would be to use something like
466C<sub base :Path :Args(0) {...}> (where the C<...> refers to the login
467code shown in C<sub index : Private> above). We are using C<sub base
468:Path :Args(0) {...}> here to specifically match the URL C</login>.
469C<Path> actions (aka, "literal actions") create URI matches relative to
470the namespace of the controller where they are defined. Although
471C<Path> supports arguments that allow relative and absolute paths to be
472defined, here we use an empty C<Path> definition to match on just the
473name of the controller itself. The method name, C<base>, is arbitrary.
474We make the match even more specific with the C<:Args(0)> action
475modifier -- this forces the match on I<only> C</login>, not
476C</login/somethingelse>.
477
478Next, update the corresponding method in C<lib/MyApp/Controller/Logout.pm>
479to match:
480
481 =head2 index
482
483 Logout logic
484
485 =cut
486
487 sub index : Private {
488 my ($self, $c) = @_;
489
490 # Clear the user's state
491 $c->logout;
492
493 # Send the user to the starting point
494 $c->response->redirect($c->uri_for('/'));
495 }
496
497As with the login controller, be sure to delete the
498C<$c->response->body('Matched MyApp::Controller::Logout in Logout.');>
499line of the C<sub index>.
500
501
502=head2 Add a Login Form TT Template Page
503
504Create a login form by opening C<root/src/login.tt2> and inserting:
505
506 [% META title = 'Login' %]
507
508 <!-- Login form -->
509 <form method="post" action=" [% Catalyst.uri_for('/login') %] ">
510 <table>
511 <tr>
512 <td>Username:</td>
513 <td><input type="text" name="username" size="40" /></td>
514 </tr>
515 <tr>
516 <td>Password:</td>
517 <td><input type="password" name="password" size="40" /></td>
518 </tr>
519 <tr>
520 <td colspan="2"><input type="submit" name="submit" value="Submit" /></td>
521 </tr>
522 </table>
523 </form>
524
525
526=head2 Add Valid User Check
527
528We need something that provides enforcement for the authentication
529mechanism -- a I<global> mechanism that prevents users who have not
530passed authentication from reaching any pages except the login page.
531This is generally done via an C<auto> action/method (prior to Catalyst
532v5.66, this sort of thing would go in C<MyApp.pm>, but starting in
533v5.66, the preferred location is C<lib/MyApp/Controller/Root.pm>).
534
535Edit the existing C<lib/MyApp/Controller/Root.pm> class file and insert
536the following method:
537
538 =head2 auto
539
540 Check if there is a user and, if not, forward to login page
541
542 =cut
543
544 # Note that 'auto' runs after 'begin' but before your actions and that
545 # 'auto' "chain" (all from application path to most specific class are run)
546 # See the 'Actions' section of 'Catalyst::Manual::Intro' for more info.
547 sub auto : Private {
548 my ($self, $c) = @_;
549
550 # Allow unauthenticated users to reach the login page. This
551 # allows anauthenticated users to reach any action in the Login
552 # controller. To lock it down to a single action, we could use:
553 # if ($c->action eq $c->controller('Login')->action_for('index'))
554 # to only allow unauthenticated access to the C<index> action we
555 # added above.
556 if ($c->controller eq $c->controller('Login')) {
557 return 1;
558 }
559
560 # If a user doesn't exist, force login
561 if (!$c->user_exists) {
562 # Dump a log message to the development server debug output
563 $c->log->debug('***Root::auto User not found, forwarding to /login');
564 # Redirect the user to the login page
565 $c->response->redirect($c->uri_for('/login'));
566 # Return 0 to cancel 'post-auto' processing and prevent use of application
567 return 0;
568 }
569
570 # User found, so return 1 to continue with processing after this 'auto'
571 return 1;
572 }
573
574B<Note:> Catalyst provides a number of different types of actions, such
575as C<Local>, C<Regex>, and C<Private>. You should refer to
576L<Catalyst::Manual::Intro> for a more detailed explanation, but the
577following bullet points provide a quick introduction:
578
579=over 4
580
581=item *
582
583The majority of application use C<Local> actions for items that respond
584to user requests and C<Private> actions for those that do not directly
585respond to user input.
586
587=item *
588
589There are five types of C<Private> actions: C<begin>, C<end>,
590C<default>, C<index>, and C<auto>.
591
592=item *
593
594With C<begin>, C<end>, C<default>, C<index> private actions, only the
595most specific action of each type will be called. For example, if you
596define a C<begin> action in your controller it will I<override> a
597C<begin> action in your application/root controller -- I<only> the
598action in your controller will be called.
599
600=item *
601
602Unlike the other actions where only a single method is called for each
603request, I<every> auto action along the chain of namespaces will be
604called. Each C<auto> action will be called I<from the application/root
605controller down through the most specific class>.
606
607=back
608
609By placing the authentication enforcement code inside the C<auto> method
610of C<lib/MyApp/Controller/Root.pm> (or C<lib/MyApp.pm>), it will be
611called for I<every> request that is received by the entire application.
612
613
614=head2 Displaying Content Only to Authenticated Users
615
616Let's say you want to provide some information on the login page that
617changes depending on whether the user has authenticated yet. To do
618this, open C<root/src/login.tt2> in your editor and add the following
619lines to the bottom of the file:
620
621 <p>
622 [%
623 # This code illustrates how certain parts of the TT
624 # template will only be shown to users who have logged in
625 %]
626 [% IF Catalyst.user_exists %]
627 Please Note: You are already logged in as '[% Catalyst.user.username %]'.
628 You can <a href="[% Catalyst.uri_for('/logout') %]">logout</a> here.
629 [% ELSE %]
630 You need to log in to use this application.
631 [% END %]
632 [%#
633 Note that this whole block is a comment because the "#" appears
634 immediate after the "[%" (with no spaces in between). Although it
635 can be a handy way to temporarily "comment out" a whole block of
636 TT code, it's probably a little too subtle for use in "normal"
637 comments.
638 %]
5edc2aae 639 </p>
d442cc9f 640
641Although most of the code is comments, the middle few lines provide a
642"you are already logged in" reminder if the user returns to the login
643page after they have already authenticated. For users who have not yet
644authenticated, a "You need to log in..." message is displayed (note the
645use of an IF-THEN-ELSE construct in TT).
646
647
648=head2 Try Out Authentication
649
650Press C<Ctrl-C> to kill the previous server instance (if it's still
651running) and restart it:
652
653 $ script/myapp_server.pl
654
655B<IMPORTANT NOTE>: If you happen to be using Internet Explorer, you may
656need to use the command C<script/myapp_server.pl -k> to enable the
657keepalive feature in the development server. Otherwise, the HTTP
658redirect on successful login may not work correctly with IE (it seems to
659work without -k if you are running the web browser and development
660server on the same machine). If you are using browser a browser other
661than IE, it should work either way. If you want to make keepalive the
662default, you can edit C<script/myapp_server.pl> and change the
663initialization value for C<$keepalive> to C<1>. (You will need to do
664this every time you create a new Catalyst application or rebuild the
665C<myapp_server.pl> script.)
666
667Now trying going to L<http://localhost:3000/books/list> and you should
668be redirected to the login page, hitting Shift+Reload if necessary (the
669"You are already logged in" message should I<not> appear -- if it does,
670click the C<logout> button and try again). Note the C<***Root::auto User
671not found...> debug message in the development server output. Enter
672username C<test01> and password C<mypass>, and you should be taken to
673the Book List page.
674
675Open C<root/src/books/list.tt2> and add the following lines to the
676bottom:
677
678 <p>
679 <a href="[% Catalyst.uri_for('/login') %]">Login</a>
680 <a href="[% Catalyst.uri_for('form_create') %]">Create</a>
681 </p>
682
683Reload your browser and you should now see a "Login" and "Create" links
684at the bottom of the page (as mentioned earlier, you can update template
685files without reloading the development server). Click the first link
686to return to the login page. This time you I<should> see the "You are
687already logged in" message.
688
689Finally, click the C<You can logout here> link on the C</login> page.
690You should stay at the login page, but the message should change to "You
691need to log in to use this application."
692
693
694=head1 USING PASSWORD HASHES
695
696In this section we increase the security of our system by converting
697from cleartext passwords to SHA-1 password hashes.
698
699B<Note:> This section is optional. You can skip it and the rest of the
700tutorial will function normally.
701
702Note that even with the techniques shown in this section, the browser
703still transmits the passwords in cleartext to your application. We are
704just avoiding the I<storage> of cleartext passwords in the database by
705using a SHA-1 hash. If you are concerned about cleartext passwords
706between the browser and your application, consider using SSL/TLS, made
707easy with the Catalyst plugin Catalyst::Plugin:RequireSSL.
708
709
710=head2 Get a SHA-1 Hash for the Password
711
712Catalyst uses the C<Digest> module to support a variety of hashing
713algorithms. Here we will use SHA-1 (SHA = Secure Hash Algorithm).
714First, we should compute the SHA-1 hash for the "mypass" password we are
715using. The following command-line Perl script provides a "quick and
716dirty" way to do this:
717
718 $ perl -MDigest::SHA -e 'print Digest::SHA::sha1_hex("mypass"), "\n"'
719 e727d1464ae12436e899a726da5b2f11d8381b26
720 $
721
722B<Note:> You should probably modify this code for production use to
723not read the password from the command line. By having the script
724prompt for the cleartext password, it avoids having the password linger
725in forms such as your C<.bash_history> files (assuming you are using
726BASH as your shell). An example of such a script can be found in
727Appendix 3.
728
729
730=head2 Switch to SHA-1 Password Hashes in the Database
731
732Next, we need to change the C<password> column of our C<users> table to
733store this hash value vs. the existing cleartext password. Open
734C<myapp03.sql> in your editor and enter:
735
736 --
737 -- Convert passwords to SHA-1 hashes
738 --
739 UPDATE users SET password = 'e727d1464ae12436e899a726da5b2f11d8381b26' WHERE id = 1;
740 UPDATE users SET password = 'e727d1464ae12436e899a726da5b2f11d8381b26' WHERE id = 2;
741 UPDATE users SET password = 'e727d1464ae12436e899a726da5b2f11d8381b26' WHERE id = 3;
742
743Then use the following command to update the SQLite database:
744
745 $ sqlite3 myapp.db < myapp03.sql
746
747B<Note:> We are using SHA-1 hashes here, but many other hashing
748algorithms are supported. See C<Digest> for more information.
749
750
751=head2 Enable SHA-1 Hash Passwords in
752C<Catalyst::Plugin::Authentication::Store::DBIC>
753
754Edit C<myapp.yml> and update it to match (the C<password_type> and
755C<password_hash_type> are new, everything else is the same):
756
757 ---
758 name: MyApp
759 authentication:
760 dbic:
761 # Note this first definition would be the same as setting
762 # __PACKAGE__->config->{authentication}->{dbic}->{user_class} = 'MyAppDB::User'
763 # in lib/MyApp.pm (IOW, each hash key becomes a "name:" in the YAML file).
764 #
765 # This is the model object created by Catalyst::Model::DBIC from your
766 # schema (you created 'MyAppDB::User' but as the Catalyst startup
767 # debug messages show, it was loaded as 'MyApp::Model::MyAppDB::User').
768 # NOTE: Omit 'MyApp::Model' here just as you would when using
769 # '$c->model("MyAppDB::User)'
770 user_class: MyAppDB::User
771 # This is the name of the field in your 'users' table that contains the user's name
772 user_field: username
773 # This is the name of the field in your 'users' table that contains the password
774 password_field: password
775 # Other options can go here for hashed passwords
776 # Enabled hashed passwords
777 password_type: hashed
778 # Use the SHA-1 hashing algorithm
779 password_hash_type: SHA-1
780
781
782=head2 Try Out the Hashed Passwords
783
784Press C<Ctrl-C> to kill the previous server instance (if it's still
785running) and restart it:
786
787 $ script/myapp_server.pl
788
789You should now be able to go to L<http://localhost:3000/books/list> and
790login as before. When done, click the "Logout" link on the login page
791(or point your browser at L<http://localhost:3000/logout>).
792
793B<Note:> If you receive the debug screen in your browser with a
794C<Can't call method "stash" on an undefined value...> error message,
795make sure that you are using v0.07 of
796L<Catalyst::Plugin::Authorization::ACL|Catalyst::Plugin::Authorization::ACL>.
797The following command can be a useful way to quickly dump the version number
798of this module on your system:
799
800 perl -MCatalyst::Plugin::Authorization::ACL -e 'print $Catalyst::Plugin::Authorization::ACL::VERSION, "\n";'
801
802
803=head1 USING THE SESSION FOR FLASH
804
805As discussed in Part 3 of the tutorial, C<flash> allows you to set
806variables in a way that is very similar to C<stash>, but it will
807remain set across multiple requests. Once the value is read, it
808is cleared (unless reset). Although C<flash> has nothing to do with
809authentication, it does leverage the same session plugins. Now that
810those plugins are enabled, let's go back and improve the "delete
811and redirect with query parameters" code seen at the end of the
812L<Basic CRUD|Catalyst::Manual::Tutorial::BasicCRUD> part of the
813tutorial.
814
815First, open C<lib/MyApp/Controller/Books.pm> and modify C<sub delete>
816to match the following:
817
818 =head2 delete
819
820 Delete a book
821
822 =cut
823
824 sub delete : Local {
825 # $id = primary key of book to delete
826 my ($self, $c, $id) = @_;
827
828 # Search for the book and then delete it
829 $c->model('MyAppDB::Book')->search({id => $id})->delete_all;
830
831 # Use 'flash' to save information across requests until it's read
832 $c->flash->{status_msg} = "Book deleted";
833
834 # Redirect the user back to the list page with status msg as an arg
835 $c->response->redirect($c->uri_for('/books/list'));
836 }
837
838Next, open C<root/lib/site/layout> and update the TT code to pull from
839flash vs. the C<status_msg> query parameter:
840
841 <div id="header">[% PROCESS site/header %]</div>
842
843 <div id="content">
844 <span class="message">[% status_msg || Catalyst.flash.status_msg %]</span>
845 <span class="error">[% error_msg %]</span>
846 [% content %]
847 </div>
848
849 <div id="footer">[% PROCESS site/footer %]</div>
850
851
852=head2 Try Out Flash
853
854Restart the development server and point your browser to
855L<http://localhost:3000/books/url_create/Test/1/4> to create an extra
856book. Click the "Return to list" link and delete the "Test" book you
857just added. The C<flash> mechanism should retain our "Book deleted"
858status message across the redirect.
859
860B<NOTE:> While C<flash> will save information across multiple requests,
861I<it does get cleared the first time it is read>. In general, this is
862exactly what you want -- the C<flash> message will get displayed on
863the next screen where it's appropriate, but it won't "keep showing up"
864after that first time (unless you reset it). Please refer to
865L<Catalyst::Plugin::Session|Catalyst::Plugin::Session> for additional
866information.
867
868
869=head1 AUTHOR
870
871Kennedy Clark, C<hkclark@gmail.com>
872
873Please report any errors, issues or suggestions to the author. The
874most recent version of the Catalyst Tutorial can be found at
d712b826 875L<http://dev.catalyst.perl.org/repos/Catalyst/trunk/Catalyst-Manual/lib/Catalyst/Manual/Tutorial/>.
d442cc9f 876
877Copyright 2006, Kennedy Clark, under Creative Commons License
878(L<http://creativecommons.org/licenses/by-nc-sa/2.5/>).