Laravel 5.5 api authorization with API Token

Question

I am trying to authenticate our user using the API token,

Here is my code config/auth.php code

  'guards' => [
        'web' => [
            'driver' => 'session',
            'provider' => 'users',
        ],

        'api' => [
            'driver' => 'token',
            'provider' => 'users',
        ],
    ],

My Api.php is like this

Route::group(['middleware' => ['subdomain_setup','auth::api'],'prefix'=>'v1'], function () {
    Route::get('getCoupons','Api\CouponAPI@getCoupons');
});

Now I am getting this error while accessing my api URL

Column not found: 1054 Unknown column 'api_token' in 'where clause' (SQL: select * from users where api_token =

does your users table have a token column? are you sure it shouldn't be another table? — delboy1978uk
– delboy1978uk, Commented Sep 26, 2017 at 11:29

dif · Accepted Answer · 2018-12-12 13:23:51Z

14

Make sure you have run Passport migration and ['guards']['api']['driver'] set to passport in config/auth.php, and updated the configuration cache

'guards' => [
    'web' => [
        'driver' => 'session', 
        'provider' => 'users', 
    ], 

    'api' => [ 
        'driver' => 'passport', 
        'provider' => 'users', 
    ], 
],

edited Dec 12, 2018 at 13:23

dif

2,5036 gold badges38 silver badges51 bronze badges

answered Dec 12, 2018 at 12:22

Sahak Hakobyan

1441 silver badge8 bronze badges

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

1 Comment

Sahak Hakobyan Over a year ago

'guards' => [ 'web' => [ 'driver' => 'session', 'provider' => 'users', ], 'api' => [ 'driver' => 'passport', 'provider' => 'users', ], ],

huangfu · Accepted Answer · 2017-11-28 02:43:41Z

2

You must alter table to add a 'api_token' field.

Schema::create('users', function (Blueprint $table) {
    $table->increments('id');
    $table->string('name');
    $table->string('email')->unique();
    $table->string('password');

    //Add api_token field
    $table->string('api_token', 60)->unique();

    $table->rememberToken();
    $table->timestamps();
});

answered Nov 28, 2017 at 2:43

huangfu

375 bronze badges

1 Comment

Julian Over a year ago

additional instructions on setting up api tokens in the docs laravel.com/docs/5.8/api-authentication#database-preparation

Mr.Senhaji · Accepted Answer · 2019-10-28 11:46:49Z

1

Clear the cache :

Clear Application Cache Run the following command to clear application cache of the Laravel application.

php artisan cache:clear

Clear config cache You can use config:clear to clear the config cache of the Laravel application.

php artisan config:clear

answered Oct 28, 2019 at 11:46

Mr.Senhaji

4507 silver badges13 bronze badges

Collectives™ on Stack Overflow

Laravel 5.5 api authorization with API Token

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related