• Intro
• Config
• Setup
• Debugging
• Maintenance
• Doctrine
• Issues

As of 2021/03: All Symfony setups are empty and unused, except for :

• /website/ - Basic config, dev stack, secrets
• /udemy-bikeshop/ - Udemy course data

Generic Symfony config.

Set in .env file:

DATABASE_URL="mysql://root:@127.0.0.1:3306/example_store"

Generic Symfony setup.

• MacOS: Switch to admin user and install there, than switch back
  • Root user might be disabled and cannot be used
  • Sudo user switching did not work in own test

• composer install
• npm i

• https://symfony.com/doc/current/frontend/encore/simple-example.html

• Set user and password in .env under DATABASE_URL
• Make sure SQL user has correct authentication method for SQL/PHP version
  • Here: Needs the older 'Standard' auth (not SHA2)

Optional, if files exist – Create DB + tables with content.

• php bin/console make:migration
• php bin/console doctrine:database:create

• php bin/console doctrine:migrations:migrate

Exemplaric showcases.

# Show Services + Use cases php bin/console debug:autowiring # Show Symfony, Kernel, PHP versions + other details php bin/console about # Security config php bin/console debug:config security # Show events php bin/console debug:event-dispatcher kernel.controller

Via Symfony CLI (install separately) - Check package security (similar to NPM).

symfony check:security

php bin/console doctrine:query:sql "SHOW VARIABLES"

On error: The metadata storage is not up to date ...

# - Create migration, migrate? # - Sync metadata (did not work during test) # - change .env file MySQL to MariaDB version php bin/console doctrine:migrations:generate php bin/console doctrine:migrations:migrate php bin/console doctrine:migrations:sync-metadata-storage