Symfony3 demo project don't work: PDO Exception Could not find driver (sqlite case)

Question

Recently i've created Symfony3 project by command:

symfony new myproject

The project uses mysql and it works fine.

After that i've created demo project to study symfony best practices:

symfony demo

Project was created successfully. Config.php shows, that everything is ok. app_dev.php was successfully opened in my web browser. But when i try to open "http://localhost/app_dev.php/ru/blog/" (there is a public part of the app) 500 internal server error will appear. /app_dev.php/ru/blog/ shows:

Error message:

An exception occured in driver: could not find driver

500 Internal Server Error - DriverException

2 linked Exceptions:

PDOException »

PDOException »

Critical part in call stack:

CRITICAL - Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occured in driver: could not find driver" at /var/www/symfony_demo/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractSQLiteDriver.php line 85

I've read all stack exchange issues about PDO Exception, but none helps me...

I use Ubuntu, Nginx.

Mysql, sqlite, php5-sqlite, sqlite3, libsqlite3-dev are installed. Nginx and php5-fpm are restarted. php.ini SQLite 3.x driver for PDO Wez Furlong.

Demo app parameters.yml:

database_driver: pdo_sqlite
database_host: 127.0.0.1
database_port: null
database_name: null
database_user: root
database_password: null
database_path: '%kernel.root_dir%/data/blog.sqlite'
mailer_transport: smtp
mailer_host: 127.0.0.1
mailer_user: null
mailer_password: null
locale: en
secret: secret_value_for_symfony_demo_application

php.ini file:

[sqlite]
; http://php.net/sqlite.assoc-case
;sqlite.assoc_case = 0

[sqlite3]
;sqlite3.extension_dir =

I have no idea, what is the reason of the problem and how to resolve it.

Help please!

php app/check.php shows 3 errors: app/cache, app/logs must be writable, timezone should be set. But it's all about cli. Web server permissions and timezone are correct. web/config.php shows "Your configuration looks good to run Symfony" — Andrew
– Andrew, Commented Mar 21, 2016 at 22:48
double check phpinfo() (if you are running symfony in dev environment - there is link to phpinfo in developer toolbar) - if you have both pdo and pdo_sqlite extensions enabled — Miro
– Miro, Commented Mar 21, 2016 at 23:01
also, check if in config.yml you have driver set as "%database_driver%" (so it takes the one from parameters.yml), because in new symfony installations there is pdo_mysql by default — Miro
– Miro, Commented Mar 21, 2016 at 23:04
doctrine dbal driver is %database_driver%. php.ini pdo drives: mysql only in enable column — Andrew
– Andrew, Commented Mar 21, 2016 at 23:07

Xavi Montero · Accepted Answer · 2017-10-11 17:53:04Z

13

Just install:

sudo apt install php-sqlite3

edited Oct 11, 2017 at 17:53

Xavi Montero

11.1k9 gold badges62 silver badges91 bronze badges

answered Jun 4, 2016 at 16:33

Pavel Novák

1681 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

barak · Accepted Answer · 2016-07-18 23:11:47Z

9

For me in ubuntu that work

sudo apt-get install php5.6-sqlite

answered Jul 18, 2016 at 23:11

barak

9191 gold badge11 silver badges15 bronze badges

1 Comment

dufte Over a year ago

Worked for me with PHP7 and sudo apt install php7.0-sqlite3. A more general/abstract solution would be something like that: sudo apt-get install phpX.Y-sqlite

Evan Genest · Accepted Answer · 2021-07-01 14:34:02Z

On my system, this worked. Might not be for everyone though:

I had used Symfony earlier this year, with PostGRESQL
Today I did what I thought was a clean symfony project install, using composer and the directions at symfony.com
I got the error you described \
I looked at everything. Finally saw, for some reason, my .env was set to use postGreSQL. Commented that line back out of the /.env file and set it for SQLite:

###> doctrine/doctrine-bundle ###
# Format described at https://www.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/configuration.html#connecting-using-a-url
# IMPORTANT: You MUST configure your server version, either here or in config/packages/doctrine.yaml
#
DATABASE_URL="sqlite:///%kernel.project_dir%/var/data.db"
# DATABASE_URL="mysql://db_user:[email protected]:3306/db_name?serverVersion=5.7"
# DATABASE_URL="postgresql://db_user:[email protected]:5432/db_name?serverVersion=13&charset=utf8"
###< doctrine/doctrine-bundle ###

Collectives™ on Stack Overflow

Symfony3 demo project don't work: PDO Exception Could not find driver (sqlite case)

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related