How to set up SQLITE for laravel webserver?

Question

I want to use SQLITE for my laravel5 project on my webserver. I migrated my local laravel 5 project onto my AWS ec2 lamp Ubuntu server. http://realtoraxe.com/realtoraxe/public/ but it shows

InvalidArgumentException in SQLiteConnector.php line 34: Database does not exist.

I changed the database.php set for sqlite

 <?php
 return array(
    'default' => 'sqlite',
    'connections' => array(
    'sqlite' => array(
    'driver'   => 'sqlite',
    'database' =>    'http://realtoraxe.com/realtoraxe/storage/database.sqlite',
    'prefix'   => '',
     ),
   ),
  );
 ?>

and I changed the .env to

APP_ENV=local
APP_DEBUG=true
APP_KEY=mystring
DB_CONNECTION=sqlite
CACHE_DRIVER=file
SESSION_DRIVER=file

when I do php artisan migrate it says there is no database

I think what I wrote as the path for the database in the database.php is wrong and do I may need to somehow write where my ip adress is in the .env file? I have been googling all night and can't seem to figure this out.

There are default sqlite config options in database.php. Because it already expects the file to be in your storage folder and named database.sqlite, the only thing you have to do is add DB_CONNECTION=sqlite to your .env file. — user1669496
– user1669496, Commented Apr 1, 2016 at 16:14

The Surrican · Accepted Answer · 2017-01-05 10:53:04Z

9

You dont need to edit the .php files at all. You can all do it in the .env file, since the files in the config directory are written to first use the values from the .env file, and if they are not defined, fall back on what is defined there.

env('DB_CONNECTION','mysql') would yield the value from the .env file, and only if it is not defined fall back to mysql.

So in your .env file just put the following:

DB_CONNECTION=sqlite DB_DATABASE=database/database.sqlite and create a file called database.sqlite in your database directory (thats where its supposed to be by convention.). That's it.

answered Jan 5, 2017 at 10:53

The Surrican

30k24 gold badges127 silver badges168 bronze badges

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

Comments

score 5 · Accepted Answer · 2017-03-02 01:45:36Z

5

For default laravel 5.2+ installation:

create an sqlite database file

$ cd storage
$ touch database.sqlite
$ cd ..

make it writeable

$ chmod -R 777 storage

at ".env" file:

DB_CONNECTION=sqlite
DB_DATABASE=storage/database.sqlite

and remove or comment all other DB_* records

If you prefer to use relative path, instead of absolute to database file at "config/database.php"

instead of:

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

write:

'database' => __DIR__ . '/../' . env( 'DB_DATABASE' ),

now, laravel app will be able to find sqlite file, and php artisan will work too

edited Mar 2, 2017 at 1:45

answered Jun 3, 2016 at 9:04

user5205015

2 Comments

kjones Over a year ago

Any reason to store it in the storage directory instead of the database directory?

AlexioVay Over a year ago

FYI: Actually that changed in Laravel 9. It is now saved in database. @kjones

Alexey Mezenin · Accepted Answer · 2016-04-01 16:12:08Z

2

Why are you using HTTP link? I guess it should link to a .sqlite DB file:

'database' => __DIR__.'/../database/production.sqlite',

http://laravel-recipes.com/recipes/118/setting-up-the-sqlite-database-driver

answered Apr 1, 2016 at 16:12

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

3 Comments

It's Just a Printer Driver Over a year ago

yeah. thats an http link. Do i need to add anything else to my .env file?

Alexey Mezenin Over a year ago

@user432495, so did you understand that you can't use HTTP link? You should give a link to the concrete file.

It's Just a Printer Driver Over a year ago

yeah. The file is in the /database/database.sqlite. I wrote the line as 'database' => DIR.'/../database/database.sqlite', (It still doesn't see it)

Collectives™ on Stack Overflow

How to set up SQLITE for laravel webserver?

3 Answers 3

Comments

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related