php artisan migrate - Laravel

Question

As soon, i press Enter 'php artisan migrate' command on ubuntu terminal. Error coming like:- [PDOException] Could Not Find Driver

I'm not able to fix this problem as i'm new to it.

Please help me to fix this issue.

[Have a look at this](https://www.google.ro/search?client=ubuntu&channel=fs&q=[PDOException]+Could+Not+Find+Driver&ie=utf-8&oe=utf-8&gws_rd=cr&ei=mKbpVYftI4X9UIj7tcgL) — Andrei, Sep 04 '15 at 14:12
Do you have seperated php configurations for your CLI? Maybe the modules are not loaded in CLI only — Sander Visser, Sep 07 '15 at 15:15
`php -i | grep php.ini` should return which php.ini file is used. — Sander Visser, Sep 07 '15 at 15:16

Pastor Durán A. · Answer 1 · 2015-09-04T16:02:40.213

1

Yo should be enable the PDO extension for you Database Manager in you php.ini

;extension=php_pdo_firebird.dll
;extension=php_pdo_mssql.dll
;extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
;extension=php_pdo_odbc.dll
extension=php_pdo_pgsql.dll //In my Case the extension enable is for pgsql
;extension=php_pdo_sqlite.dll

For enable you should delete the ; char in the line of the extension restart the server and voila

edited Sep 04 '15 at 16:02

answered Sep 04 '15 at 14:48

Pastor Durán A.

364
1
12

Hi Mr Pastor. I was waiting for this answer only. As i searched many answer posted in stack over flow. Everyone asking whether PDO is enabled or not. But, for me ";extension=php_pdo_mssql.dll" is available.. So, it's enabled. Now, what to do next.? – Nana Partykar Sep 04 '15 at 15:05
i've to install php5-sqlite ? – Nana Partykar Sep 04 '15 at 15:17
Well, do you have it? The php-mssql extension. sudo apt-get install php5-php5-sybase and later pear install --nodeps MDB2_Driver_mssql – Pastor Durán A. Sep 04 '15 at 15:17
yeah. i installed this sybase – Nana Partykar Sep 04 '15 at 15:19
do you show me your phpinfo()??. The section PDO only please. – Pastor Durán A. Sep 04 '15 at 15:26
yeah. I Updated my question with PHP info file. You Can Check it Mr Pastor. – Nana Partykar Sep 04 '15 at 15:30
You only have enable the mysql,pgsql and sqlite drivers. If you recent enable the mssql driver please restart the webserver. – Pastor Durán A. Sep 04 '15 at 15:32
Ok. I'm restarting it. – Nana Partykar Sep 04 '15 at 15:34
Show me your phpinfo() again. – Pastor Durán A. Sep 04 '15 at 15:41
Edited My Question. You Can See It Mr Parter – Nana Partykar Sep 04 '15 at 15:42
you still disable the mssql extension for enable edit your php.ini (For enable you should delete the ; char in the line of the extension) ;extension=php_pdo_firebird.dll extension=php_pdo_mssql.dll extension=php_pdo_mysql.dll ;extension=php_pdo_oci.dll ;extension=php_pdo_odbc.dll extension=php_pdo_pgsql.dll extension=php_pdo_sqlite.dll – Pastor Durán A. Sep 04 '15 at 15:49
oh. is it so. Ok let me do. – Nana Partykar Sep 04 '15 at 15:50
Yeah Mr Pastor. I Edited my question with phpinfo( screenshot.) can you please check it.. – Nana Partykar Sep 04 '15 at 16:02
Edit your changes into php-cli.ini file please. You still disable the mssql extension – Pastor Durán A. Sep 04 '15 at 16:05
php-cli.ini file. ?? Where is this file located. Whatever you told me to do changes in php.ini.. i did.. Now, this is new file or what ?? – Nana Partykar Sep 04 '15 at 16:07
sorry i mean php.ini in folder /etc/php5/cli/php.ini – Pastor Durán A. Sep 04 '15 at 16:11
I made changes Pastor. – Nana Partykar Sep 04 '15 at 16:13
But, still same result – Nana Partykar Sep 04 '15 at 16:13
please chek this article http://blog.andyhunt.info/2013/11/29/php-mssql-pdo_dblib-freetds-support-on-mac-osx-10-9-mavericks/ – Pastor Durán A. Sep 04 '15 at 16:19
The oficial docshttp://us3.php.net/manual/en/mssql.requirements.php say that you should be use http://www.freetds.org/ for enable the extension – Pastor Durán A. Sep 04 '15 at 16:41

score -1 · Accepted Answer · answered Sep 07 '15 at 15:11

I made changes in "Project-Folder-Name/config/database.php". And, it worked. Added 'unix_socket' => '/opt/lampp/var/mysql/mysql.sock',

'mysql' => [
            'driver'    => 'mysql',
            'host'      => env('DB_HOST', 'localhost'),
            'database'  => env('DB_DATABASE', 'DatabaseName'),
            'username'  => env('DB_USERNAME', 'root'),
            'password'  => env('DB_PASSWORD', ''),
        'unix_socket'   => '/opt/lampp/var/mysql/mysql.sock', //Your sock got from above
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
            'strict'    => false,
        ],

This isn't the right solutions, because /opt/lampp/var/mysql/mysql.sock is far from the default configuration and it will break your application on other environments/systems. — Sander Visser, Sep 07 '15 at 15:51

Sander Visser · Answer 3 · 2015-09-07T15:55:58.093

I think you have a seperated configuration file (php.ini) for your CLI.

Try to execute php -i | grep php.ini in your console. And enable the required modules in that file.

It should return something like this:

sander@sander-Laptop:~$ php -i | grep php.ini
Configuration File (php.ini) Path => /etc/php5/cli
Loaded Configuration File => /etc/php5/cli/php.ini

As you can see it uses another php.ini file then what the phpinfo(); returns

Open that file and enable the required extensions there

so change the lines of the extensions that you require: ;extension=extension.so to extension=extension.so

Also a tip: If you use Laravel you can use the Homestead (vagrant, virtualbox) which is an virtual machine complete preinstalled for you laravel application

http://laravel.com/docs/5.1/homestead

php artisan migrate - Laravel

3 Answers3

Linked