Can't operate on the database

[Former user]

Hello,

I can't seem to do any writing operation on the database and the error message doesn't say anything explicit :

ERROR: 
This may be a bug that needs to be reported at https://bitbucket.org/phpliteadmin/public/issues?status=new&status=open

There's probably a permission issue but the database should be available since it works using sqlite3 with the www-data user.

SQLite version: 3.8.7.1 SQLite extension [?]: PDO PHP version: 5.6.30-0+deb8u1 phpLiteAdmin version: 1.9.7.1

Thank you for your help

[phpLiteAdmin]

On the left where you can choose the database, does it say [r] or [rw] next to the database name?

[Vincent A]

It says [r] When I set the file permission mask to 777 it works. It seems www-data is not the user accessing it. Is it a user specific to PHP ?

Edit : i reloaded apache and removed a directory instruction specific to the repertory the files were in, and it works (rw).

[phpLiteAdmin]

The user that php runs under depends on how you run php. If you run php using the Apache module mod_php5, it will use the same user as apache, usually www-data. If you run php using PHP-FPM, you can define the user that php runs under for each pool, similar for PHP-FCGID I think.

So I guess your issue is solved? Maybe we should add better error messages here, though.

[sdsd]

Hi. Mine is already rw yet phpliteadmin won't let me create a new table. I'm using a csv file as database, which I've taken from cs50 week 9 lesson. Please help me out. Thanks.

[phpLiteAdmin]

what does "won't let me create a new table" mean? what exactly do you try and what exactly happens? Any error message?

[phpLiteAdmin]

Insufficient file permissions of the database file is not a bug of phpLiteAdmin. The second poster (sdsd) did not reply anymore. So this issue is closed.