Laravel sqlite DB connection error

Question

In Laravel 5.3 I am using SQLite as my default DB connection and, my .env file I removed all MySQL connection details. when I use artisan command and tinker command to create a new entry and fetch entries are working fine. but from the controller or eloquent I cannot fetch or add a record, it throws strange MySQL connection fail error.

PDOException in Connector.php line 55:
SQLSTATE[HY000] [2002] Connection refused 

in Connector.php line 55
at PDO->__construct('mysql:host=127.0.0.1;port=3306;dbname=homestead',
 'homestead', 'secret', array('0', '2', '0', false, false)) in Connector.php line 55

is your mysql up and running?

SMA
– SMA

2016-07-30 10:18:54 +00:00
Commented Jul 30, 2016 at 10:18 — SMA
– SMA, Commented Jul 30, 2016 at 10:18
no, but I'm using sqlite

Zarah Dewayne
– Zarah Dewayne

2016-07-30 10:19:51 +00:00
Commented Jul 30, 2016 at 10:19 — Zarah Dewayne
– Zarah Dewayne, Commented Jul 30, 2016 at 10:19

Jesús Amieiro · Accepted Answer · 2016-07-30 10:26:49Z

3

If you remove the DB_CONNECTION element in the .env, Laravel will try to use de default configuration, defined in the file config/database.php

The default config is

'default' => env('DB_CONNECTION', 'mysql'),

so you probably are trying to use MySQL

If you want to use SQLite, you should add the next line in the .env file

DB_CONNECTION=sqlite

and adjust the

'database' => env('DB_DATABASE', database_path('database.sqlite')),

in the config/database.php or put your SQLite path in the DB_DATABASE variable, in the .env file.

DB_DATABASE='your SQLite file path'

answered Jul 30, 2016 at 10:26

Jesús Amieiro

2,49321 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Laravel sqlite DB connection error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related