Laravel user auth using existing database table

Question

I have laravel 5.2 project and need to add Authentication, but I need to connect it to my table, that has Username and Password, also change default email/password to username/password. Also in my table passwords are not crypted.

I have change login.blade.php file from email field to username.

Also change user.php model:

 protected $table = 'LoginTable';

Also change AuthController.php. Add this:

 protected $username = 'username';

and change validator and create methods:

 return Validator::make($data, [
        'username' => 'required|max:255',
        'password' => 'required|min:6|confirmed',
    ]);
 return User::create([
        'username' => $data['username'],
        'password' => bcrypt($data['password']),
    ]);

But I cant login.It's saying 'These credentials do not match our records.'. How can I check what is the problem? Can anyone help me with this issue?

UPDATE

I have change password to hashed password, but still cant make auth work.It is still saying: These credentials do not match our records.

I want to mention that in Database I have only username and password, and dont have name and email.

Have you gone through docs? Here is how you can manually authenticate a user. docs — Qasim Ali
– Qasim Ali, Commented Nov 23, 2016 at 9:51
Manual authentication is probably not the best idea. There's a lot of extra goodies you lose by doing that. — Richard Vanbergen
– Richard Vanbergen, Commented Nov 23, 2016 at 9:54

Catalin Dumitrescu · Accepted Answer · 2016-11-23 10:04:19Z

1

If you are trying to authenticate with an existing user with an unencrypted password it won't work.

Laravel auth requires all passwords to be encrypted to pass validation. So first you'll need to update the database and encrypt all passwords with the same encryption key defined in config/app.php or in the .env file.

Also as a rule of thumb you should never ever keep clear text passwords in the database.

answered Nov 23, 2016 at 10:04

Catalin Dumitrescu

1112 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Lusine Martirosyan Over a year ago

thanks for your resposne. Are other changes correct? just need to encrypt password? One more think, in app.php I found 'cipher' => 'AES-256-CBC', and in env.file I found APP_KEY=base64:y6raQpepxEWDZVsX6gwhRuRvOxPoKaj1SJUvzzPV/U0=. Which one is the one I need?

Catalin Dumitrescu Over a year ago

Yes, all other changes are correct. The setting in the config/app.php is the one above 'cipher', the one named 'key' which by default reads the setting APP_KEY from the .env file.

Hammerbot Over a year ago

You just need to bcrypt() all your passwords, this will use your APP_KEY.

Collectives™ on Stack Overflow

Laravel user auth using existing database table

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related