Laravel 5.4 on localhost: QueryException could not find driver (SQL: select * from `sessions`

Question

I'm trying to run laravel 5.4 on localhost php 5.6 using XAMPP with these laravel .env configurations

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=dbname_here
DB_USERNAME=root
DB_PASSWORD=

But I get QueryException could not find driver (SQL: select * from sessions

In log file

local.ERROR: PDOException: could not find driver in D:\xampp\htdocs\laravel\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:43
Stack trace:
#0 D:\xampp\htdocs\laravel\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(43): PDO->__construct('mysql:host=loca...', 'root', '', Array)

But PDO is already installed

I tried to clear the cache but that didn't solve the problem. Any ideas?

[update]

After an edit by changing "SESSION_DRIVER=file" Now I get

FatalThrowableError
Call to undefined function openssl_encrypt()

local.ERROR: Symfony\Component\Debug\Exception\FatalThrowableError: Call to undefined function openssl_encrypt() in D:\xampp\htdocs\laravel\vendor\laravel\framework\src\Illuminate\Encryption\Encrypter.php:78
Stack trace:
#0 D:\xampp\htdocs\laravel\vendor\laravel\framework\src\Illuminate\Session\EncryptedStore.php(57): Illuminate\Encryption\Encrypter->encrypt('a:3:{s:6:"_toke...')

now I get Call to undefined function openssl_encrypt() though extension=php_openssl.dll is not commented @Davit — PHP User, Jul 08 '18 at 08:53
@ggdx yes sure it's installed and I can connect to it and imported the database — PHP User, Jul 08 '18 at 08:53
did you check the requirements?: https://laravel.com/docs/5.4#server-requirements — Hussein, Jul 08 '18 at 09:10
openssl is already enabled from phpinfo() and the extension is in the correct path — PHP User, Jul 08 '18 at 09:19

TalESid · Answer 1 · 2018-07-08T11:12:28.697

0

Might be the issue of missing dependency. Try the following command:

composer require doctrine/dbal

and also comment-out the following line in your php.ini file:

;extension=pdo_mysql.so

Laravel 5 PDOException Could Not Find Driver

Also, if you haven't installed php-mysql driver, install it with following command (depending on PHP version):

sudo apt-get install php7.0-mysql

edited Jul 08 '18 at 11:12

answered Jul 08 '18 at 11:01

TalESid

2,304
1
20
41

Laravel 5.4 on localhost: QueryException could not find driver (SQL: select * from `sessions`

1 Answers1