Configur sql logging in symfony with doctrine

databases.yml

all:
  doctrine:
    class: sfDoctrineDatabase
    param:
      dsn: 'mysql:host=HOST;dbname=DBNAME'
      username: USERNAME
      password: PASSWORD
      profiler: true
      logging: true