Explain database session storage config in Flex #8420
Description
According to docs on https://symfony.com/doc/current/doctrine/pdo_session_storage.html page to avoid duplication the PdoSessionHandler needs to be configured like this:
services:
# ...
Symfony\Component\HttpFoundation\Session\Storage\Handler\PdoSessionHandler:
public: false
arguments:
- 'mysql:host=%database_host%;port=%database_port%;dbname=%database_name%'
- { db_username: '%database_user%', db_password: '%database_password%' }Unfortunately when Symfony project is created using Flex there are no such container parameters anymore.
I've tried doing:
services:
Symfony\Component\HttpFoundation\Session\Storage\Handler\PdoSessionHandler:
arguments: ['%env(DATABASE_URL)%']but with DATABASE_URL defined in /.env as mysql://user:pass@127.0.0.1:3306/symfony?charset=utf8&serverVersion=5.5 it doesn't work and on attempt to save something to session I'm getting this error:
SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected