CakePHP Authentication - Username and Password in different tables

Question

I have the following tables:

People
Users
Emails

The user's password is stored in the Users table and I want them to use their default email address which is stored in the Emails table to authenticate. The email is indicated as their default by a boolean column in the Emails table.

How do I use CakePHP's Authentication component in this setup?

santiagobasulto · Answer 1 · 2011-11-15T22:52:17.077

1

I think you shoulnd't split the info in separate tables. Put everything in your Users table, and then make one-to-one relationships.

Anyway, if you want to do it this way you should override the login() method in the UsersController.

Here you have an example: http://bakery.cakephp.org/articles/SeanCallan/2007/04/17/simple-form-authentication-in-1-2-x-x

This is the method you need to override:

http://api13.cakephp.org/class/auth-component#method-AuthComponentlogin

EDIT:

Make your auth data depends on Users only. I mean, put email, username (if you have one), and password there. After that, if you have, for example, People table to record other info (first name, addres, phone, etc), make an one-to-one relationship with that table. If you have your Customer table, and your customer can be users, make a one-to-one relationship.

I ran into this troubles some time ago, and was useful to solve it as Django do, and is with this one-to-one solution.

edited Nov 15 '11 at 22:52

answered Nov 15 '11 at 13:29

santiagobasulto

11,320
11
64
88

thanks. Can you clarify what you mean by 'Put everything in your Users table, and then make one-to-one relationships.'. – freshest Nov 15 '11 at 22:07
I edited the original post. Hope you get the idea, my english isn't very good. – santiagobasulto Nov 15 '11 at 22:52
I want People to have many email addresses, and also want Users to log in with their default email address. How does this change your solution? – freshest Nov 15 '11 at 23:00
You mean that a person can login with different emails and passwords? That's definitely a bad idea. Each user should have just one credential. – santiagobasulto Nov 15 '11 at 23:15
No, a user can only login with their default email, and their password. – freshest Nov 15 '11 at 23:56

score 0 · Answer 2 · edited May 23 '17 at 12:11

0

This answer should be enough evidence that you will not be able to use multiple models for your Auth component. It only supports a string, not an array. But if you keep reading, there might be a work around for you.

edited May 23 '17 at 12:11

Community

1
1

answered Nov 15 '11 at 14:32

Tim Joyce

4,487
5
34
50

score 0 · Accepted Answer · answered Nov 17 '11 at 12:14

Create a /app/Controller/Component/Auth/MyFormAuthenticate.php file, and setup Auth to use MyForm instead of Form for authentication.

In this file include the authenticate function and the _findUser function.

You then need to override the _findUser function to suit your needs.

Thanks to Ceeram on the CakePHP freenode channel for this solution.

CakePHP Authentication - Username and Password in different tables

3 Answers3