Search code examples
phpsessionlaravel-5

Laravel 5.4 database session not working

I have problems with the database driver for storing sessions :

Connection to database is currently working. Cookies are not set in the browser but are set in my database.

i have run :

php artisan session:table

My .env :

SESSION_DRIVER=database

config/session.php

'driver' => env('SESSION_DRIVER', 'file'),
'connection' => 'mysql',
'table' => 'sessions',

EDIT 1:

my route :

Route::group(['domain' => GetDomainInfo::GetDomainName(), 'middleware' => 'web'], function ()
{
  Route::get('/', "HomeController@index");
}

Thanks for help.

Solution

  • When you work with the database driver for sessions, you have to create the session table.

    I'll assume you already scaffold the native authentication system by doing php artisan make:auth and migrated the migrations.

    So first you generate the migration, and then migrate:

    php artisan session:table

    Execute the migration:

    php artisan migrate

    Obviously, this won't work if the routes you're checking on, aren't using the web middleware. If you're not registering the routes in /routes/web.php, then you have to manually specify the web middleware for them. Either in your controller's constructor, or directly in the route itself.

    Also, check your domain in config/session.php is the same you're using in development or production, depending where you are working on.