PDOException: could not find driver when using phpunit

Question

I am starting to use laravel 4 and I am trying to start using unit tests so I can make my live easier. Well as all of you will guess my development hasn't become easier after trying phpunit tests. The simple tests are well, easy but when the things start to get a bit more complicated they does not go as I though they will.

The problem is I have conducted simple tests but I get some strange error PDOException: could not find driver. I have read a few articles and post on this topic but nothing solved my problem. I have installed php5-mysql and when I call php -m it says that I have both PDO and pdo_mysql. The actual command I use is php -m |grep -i "pdo" and the output is:

PDO
pdo_mysql

Well I've tried to actualy test PDOException class in the browser. For that purpose I have change the mysql user password to incorrect one and tested what will happen in artisan server (called with command php artisan serve ---> http://localhost:8000/). In the browser everything works as a charm but when I try to call ``phpunit` in the console the result is not the same.

I have tried to see if webserver and cli have different configuration files but it turnout that the files are identical. The configuration files that I have compared are:

for the web server

/etc/php5/apache2/conf.d/20-pdo_mysql.ini
/etc/php5/apache2/conf.d/05-opcache.ini
/etc/php5/apache2/conf.d/20-json.ini
/etc/php5/apache2/conf.d/20-mysql.ini
/etc/php5/apache2/conf.d/20-mysqli.ini
/etc/php5/apache2/conf.d/10-pdo.ini
/etc/php5/apache2/conf.d/20-mcrypt.ini
/etc/php5/apache2/conf.d/20-curl.ini
/etc/php5/apache2/php.ini

for command line

/etc/php5/cli/conf.d/20-pdo_mysql.ini
/etc/php5/cli/conf.d/05-opcache.ini
/etc/php5/cli/conf.d/20-json.ini
/etc/php5/cli/conf.d/20-mysql.ini
/etc/php5/cli/conf.d/20-mysqli.ini
/etc/php5/cli/conf.d/10-pdo.ini
/etc/php5/cli/conf.d/20-mcrypt.ini
/etc/php5/cli/conf.d/20-curl.ini
/etc/php5/cli/php.ini

to compare them I user the diff command like so diff -s /path/to/file1 /path/to/file2.

The errors look like this:

1) ExampleTest::testBasicExample
PDOException: could not find driver

/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:47
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Database/Connectors/SQLiteConnector.php:22
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php:59
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php:47
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php:127
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php:63
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php:167
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php:135
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:366
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:93
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:56
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Console/Command.php:108
/var/www/smlsspd/vendor/symfony/console/Symfony/Component/Console/Command/Command.php:241
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Console/Command.php:96
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Console/Application.php:96
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Foundation/Artisan.php:57
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:208
/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:208
/var/www/smlsspd/app/tests/TestCase.php:70
/var/www/smlsspd/app/tests/TestCase.php:70
/var/www/smlsspd/app/tests/TestCase.php:46
phar:///var/www/smlsspd/phpunit.phar/phpunit/TextUI/Command.php:179
phar:///var/www/smlsspd/phpunit.phar/phpunit/TextUI/Command.php:132

Can you give me a hint or solution to this problem?

Thank you for your time :)

common sense · Accepted Answer · 2014-04-23 14:30:13Z

23

It seems Laravel using SQLite as database for testing. See the backtrace at line 2:

/var/www/smlsspd/vendor/laravel/framework/src/Illuminate/Database/Connectors/SQLiteConnector.php:22

But this seems not installed on your system. So I think you need to install the SQLite driver.

answered Apr 23, 2014 at 14:30

common sense

3,9106 gold badges26 silver badges35 bronze badges

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

2 Comments

melanholly Over a year ago

Ok that seem to be a problem because I really don't have SQLite PDO driver installed. I'll test things out later.

melanholly Over a year ago

I finaly got home and tested things out. It seems like I don't read all the error messages. Thank you for your help.

Ganesh Bhosale · Accepted Answer · 2016-10-19 12:06:36Z

23

If you are using sqlite for testing you will need php sqlite drivers

For Ubuntu 14.04

sudo apt-get install php5-sqlite
sudo service apache2 restart

In ubuntu 16.04 there is no php5-sqlite

sudo apt-get install php7.0-sqlite
sudo service apache2 restart

answered Oct 19, 2016 at 12:06

Ganesh Bhosale

2,11019 silver badges23 bronze badges

1 Comment

Tajuddin Khandaker Over a year ago

I have php 7.1 what should be expected?

Mau Web · Accepted Answer · 2019-09-05 19:18:17Z

8

If you are occupying SqLite you have to enter php.init and uncomment this line.

;extension = pdo_sqlite

answered Sep 5, 2019 at 19:18

Mau Web

971 silver badge2 bronze badges

2 Comments

Tajuddin Khandaker Over a year ago

I did but still showing "$ php artisan migrate --env=testing PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/20160303/php_pdo_sqlite.dll' - /usr/lib/php/20160303/php_pdo_sqlite.dll: cannot open shared object file: No such file or directory in Unknown on line 0". My OS is Ubuntu 14.04 LTS

Mau Web Over a year ago

Apart uncomment this line in php.unit extension = pdo_sqlite In your phpunit.xml file you have to have these two lines <server name = "DB_CONNECTION" value = "sqlite" /> <server name = "DB_DATABASE" value = ": memory:" />

fabpico · Accepted Answer · 2017-06-30 07:34:59Z

4

On Windows i had to activate extension=php_pdo_sqlite.dll in php.ini.

answered Jun 30, 2017 at 7:34

fabpico

2,9864 gold badges32 silver badges50 bronze badges

Comments

camelCase · Accepted Answer · 2017-10-26 19:44:52Z

3

For those using Laravel Homestead, make sure you're running phpunit from within Homestead and not on your local machine! You can SSH into it with vagrant ssh.

As others have mentioned, it requires SQLite and thus running it within your virtual machine ensures that's available to your test.

answered Oct 26, 2017 at 19:44

camelCase

5,6383 gold badges36 silver badges38 bronze badges

Comments

Winnipass · Accepted Answer · 2018-04-11 16:52:30Z

2

php7.0-sqlite no longer works use php7.1-sqlite

sudo apt-get install php7.1-sqlite3
sudo service apache2 restart

edited Apr 11, 2018 at 16:52

answered Apr 9, 2018 at 17:10

Winnipass

95011 silver badges22 bronze badges

3 Comments

mikhail-t Over a year ago

I've run sudo apt-get update then sudo apt-get install php7.1-sqlite but got those errors:

E: Unable to locate package php7.1-sqlite E: Couldn't find any package by glob 'php7.1-sqlite' E: Couldn't find any package by regex 'php7.1-sqlite'

Winnipass Over a year ago

try sudo apt-get install php7.1-sqlite3

mikhail-t Over a year ago

that sneaky 3 I missed, in any case I did apt-cache search php7.1-sqlite3 and got no search results, and same for php7.1-sqlite only php7.0-sqlite returns php7.0-sqlite3 - SQLite3 module for PHP, I may be missing required ppa (I use Ubuntu subsystem on Windows)

Mahdi mehrabi · Accepted Answer · 2020-08-16 18:37:16Z

2

first, install SQLite for PHP with sudo apt-get install php-sqlite3

then check your php.ini and make sure the below line is uncommented

;extension = pdo_sqlite

then if you are using apache

sudo service apache2 restart

or if you are using Nginx

sudo service nginx restart

note: if you don't know where is your php.ini path use php -i |grep php.ini command

answered Aug 16, 2020 at 18:37

Mahdi mehrabi

1,7522 gold badges22 silver badges23 bronze badges

Comments

Mahsa · Accepted Answer · 2021-12-10 15:15:42Z

0

In Laravel, in phpunit.xml file, just set "DB_CONNECTION" and "DB_DATABASE" values. Since I was using mysql (not sqlite), I changed them like this:

<server name="DB_CONNECTION" value="mysql"/>
<server name="DB_DATABASE" value="db_name"/>

answered Dec 10, 2021 at 15:15

Mahsa

7627 silver badges16 bronze badges

Comments

Lincoln Biancardi · Accepted Answer · 2022-02-15 17:09:28Z

0

If using mysql, add this line in phpunit.xml:

<server name="DB_CONNECTION" value="mysql"/>

Then install the mysql package in php

$ apt-get install php-mysql

Try again :)

answered Feb 15, 2022 at 17:09

Lincoln Biancardi

11 bronze badge

Collectives™ on Stack Overflow

PDOException: could not find driver when using phpunit

9 Answers 9

2 Comments

1 Comment

2 Comments

Comments

Comments

3 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

9 Answers 9

2 Comments

1 Comment

2 Comments

Comments

Comments

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related