hello, im using for my api 2 token one fix token and the refresh token the error its when i use the access token from postman to try larravel not decoding the token i try to decode my access_token it was the same inside the table but when i try to check it its wrongtoken its my checkapitokenphp frorom the middleware:
@bsrour You don’t “decode” a refresh token. Refresh tokens are just strings.
You use refresh tokens to extend the lifetime of an OAuth access token. If either the access token or refresh token have expired, then the user will need to authorise your application again.
its an example what i mean : here what im sending from post man in the header: for the authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJhdWQiOiIxMiIsImp0aSI6IjZiYjdkMmJkMjBmZjQxNzcyYTU1ZmIyZDUwMTM5ZWFjZTgwNGFkZThhN2QwY2Y1ZTA5ZDY3MDhjNDliZTIxYzA5ZDk3ZmM5NDc5YmI0M2U0IiwiaWF0IjoxNzAyNjQ0MjEwLjUzMDAxOSwibmJmIjoxNzAyNjQ0MjEwLjUzMDAyMywiZXhwIjoxNzAzOTQwMjEwLjIyMjMxMiwic3ViIjoiMjYiLCJzY29wZXMiOltdfQ.efwtUGz1LAn850yr4qLYORIPX3uzGNlLzLm8kOTpzzk7m_RIwh65DHcYe8eEfccfQMNgvbUU1jIW87HZ6mNL-z4HD9qbF2BHHvfN-7feZup3fdXqxzDnxET8S7dY-d_Z6eS_PESiRELJya51Q1SDCjx5NPTJHKscWChsGU5wsNDHL81F15FXJrAdAsnEoFTGEB-qIO_kALMKzk0eQW5EaunL3mncdjLsP51SK27yRQCy5u72OkkEPQObhnbVcOAq04-ioDvu7B5mZCA_hm0x3AcF6quQ79-TeL5LyQtXpOgGOCqPjbO7uCBP7QWClo0OtTcp1hEnvjr5U73OZjKhRzw11X3znAXC_g9ZXfotAYLtOxG8QynP9F7cuTrzqU5YmAyN11ez2Fp_Lpe1ViXczii2iJCHSrmKWBB8r3R6eyCYuDgtP0cjoFUqvSWePXsbjyCZ2j0ntAAA22K6Kfk7mDpzU6JCmu600Qj_aPrRBxts21W0S-nag9Nh0FmA-Ot367PEQYErYT1JhMXnJsCzi7H2GsyLvbG28N3yx4EYmCrVZErxA9I-9M7zeH6NGPty2rXKGzS7wwGnUYLXFI0q4KTJk3U84BqKJUxzLJB83gLWpzhj66MdO3Wj_8SKAsjrNkibgrS3tCVQTXxz9DzJ6R7E1pWANUZ30_WnNj7hcKg buti ts my error:
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'access_token' in 'where clause' at D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Database\Connection.php:416) [stacktrace] #0 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Database\Connection.php(416): PDO->prepare() #1 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Database\Connection.php(809): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Database\Connection.php(776): Illuminate\Database\Connection->runQueryCallback() #3 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Database\Connection.php(407): Illuminate\Database\Connection->run() #4 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2751): Illuminate\Database\Connection->select() #5 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2740): Illuminate\Database\Query\Builder->runSelect() #6 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(3294): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #7 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2739): Illuminate\Database\Query\Builder->onceWithColumns() #8 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(737): Illuminate\Database\Query\Builder->get() #9 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(721): Illuminate\Database\Eloquent\Builder->getModels() #10 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Database\Concerns\BuildsQueries.php(333): Illuminate\Database\Eloquent\Builder->get() #11 D:\xamppphp82\htdocs\last\backend\backend\app\Http\Middleware\CheckApiToken.php(47): Illuminate\Database\Eloquent\Builder->first() #12 D:\xamppphp82\htdocs\last\backend\backend\app\Http\Middleware\CheckApiToken.php(30): App\Http\Middleware\CheckApiToken->isValidAccessToken() #13 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): App\Http\Middleware\CheckApiToken->handle() #14 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #15 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle() #16 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Routing\Middleware\ThrottleRequests.php(159): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #17 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Routing\Middleware\ThrottleRequests.php(90): Illuminate\Routing\Middleware\ThrottleRequests->handleRequest() #18 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Routing\Middleware\ThrottleRequests->handle() #19 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Routing\Middleware\ThrottleRequests.php(159): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #20 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Routing\Middleware\ThrottleRequests.php(125): Illuminate\Routing\Middleware\ThrottleRequests->handleRequest() #21 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Routing\Middleware\ThrottleRequests.php(87): Illuminate\Routing\Middleware\ThrottleRequests->handleRequestUsingNamedLimiter() #22 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Routing\Middleware\ThrottleRequests->handle() #23 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Auth\Middleware\Authenticate.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #24 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Auth\Middleware\Authenticate->handle() #25 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #26 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Cookie\Middleware\EncryptCookies->handle() #27 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #28 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Routing\Router.php(805): Illuminate\Pipeline\Pipeline->then() #29 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Routing\Router.php(784): Illuminate\Routing\Router->runRouteWithinStack() #30 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Routing\Router.php(748): Illuminate\Routing\Router->runRoute() #31 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Routing\Router.php(737): Illuminate\Routing\Router->dispatchToRoute() #32 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(200): Illuminate\Routing\Router->dispatch() #33 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #34 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #35 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #36 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle() #37 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #38 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #39 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle() #40 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #41 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #42 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #43 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #44 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Http\Middleware\HandleCors.php(62): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #45 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Http\Middleware\HandleCors->handle() #46 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Http\Middleware\TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #47 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle() #48 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #49 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(175): Illuminate\Pipeline\Pipeline->then() #50 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #51 D:\xamppphp82\htdocs\last\backend\backend\public\index.php(51): Illuminate\Foundation\Http\Kernel->handle() #52 D:\xamppphp82\htdocs\last\backend\backend\vendor\laravel\framework\src\Illuminate\Foundation\resources\server.php(16): require_once('...') #53 {main} "}
its my oauth_access_tokens table columns:
Schema::create('oauth_access_tokens', function (Blueprint $table) { $table->string('id', 100)->primary(); $table->unsignedBigInteger('user_id')->nullable()->index(); $table->unsignedBigInteger('client_id'); $table->string('name')->nullable(); $table->text('scopes')->nullable(); $table->boolean('revoked'); $table->timestamps(); $table->dateTime('expires_at')->nullable(); });
Please or to participate in this conversation.