Laravel + SQLite = SQLSTATE[HY000]General Error: 8 attempt to write a readonly database

Question

I'm trying to delete a db.sqlite file, create it again and then insert some info into this DB all in the same method. This is the method I'm using:

public function destroy()
{
    // Store all contents and delete the first one since this is created via seeder
    $contents = $this->contents->all()->toArray();
    array_shift($contents);

    // Delete db file, creates it from an example file and changes permissions
    system('rm -rf ../database/database.sqlite');
    system('cp ../database/database.sqlite.example ../database/database.sqlite');
    system('chmod 0777 ../database/');
    system('chmod 0777 ../database/database.sqlite');

    // Insert data
    foreach ($contents as $content) {
        $this->contents->create($content);
    }

    return response()->json(['message' => 'Data has been destroyed!']);
}

However when I try to run it i get the error described in the title:

SQLSTATE[HY000]General Error: 8 attempt to write a readonly database

I'm setting 777 permissions on the file and the folder as recommended by others questions' answers, so I have no idea why it isn't working.

Possible duplicate of [SQLite: read-only database](https://stackoverflow.com/questions/3319112/sqlite-read-only-database) — MCMXCII, Dec 15 '17 at 16:02
@MCMXCII I almost marked the question as the same dupe as well, but the question submitter does state "I'm giving 777 permissions to the file and the _folder_" in the last line of their question. — cteski, Dec 15 '17 at 16:05

score 36 · Answer 1 · edited Oct 01 '19 at 19:38

36

You need to run two commands

First, change ownership of the Laravel directory to web group:

sudo chown -R :www-data /var/www/yourLarvelFolder

Second, give privileges over storage directory so it can be writable:

sudo chmod -R 775 /var/www/yourLarvelFolder/storage

edited Oct 01 '19 at 19:38

Elijah Lynn

12,272
10
61
91

answered Jan 09 '18 at 03:35

Zymawy

1,511
16
15

score 4 · Answer 2 · answered Oct 22 '19 at 06:22

4

give permission here in ubuntu working on 18.04 and laravel 6

sudo chmod -R 775 database
sudo chown -R $(whoami) database

answered Oct 22 '19 at 06:22

Jignesh Joisar

13,720
5
57
57

score 2 · Answer 3 · answered Feb 15 '20 at 09:29

2

If you are on Fedora or Redhat with Selinux rememebr to switch off Selinux (or configure it correctly):

setenforce 0

answered Feb 15 '20 at 09:29

gdm

7,647
3
41
71

score 1 · Accepted Answer · answered Aug 09 '18 at 20:59

1

Finally I solved it by using to different methods, one to delete the DB and create again (returning all the contents) and then, the second one to insert all the contents to the new DB.

answered Aug 09 '18 at 20:59

miguelopezv

790
2
8
28

score 1 · Answer 5 · answered Jan 23 '19 at 15:36

1

First run the following command to check apache2's user. Usually it is www-data

ps aux | grep "apache2"

Then run the following commands to resolve your issue.

chgrp -R www-data your_application_directory
chmod -R g+rw your_application_directory

answered Jan 23 '19 at 15:36

Hamfri

1,979
24
28

Laravel + SQLite = SQLSTATE[HY000]General Error: 8 attempt to write a readonly database

5 Answers5

Linked