Can't operate on the database
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
Comments (6)
-
repo owner -
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).
-
repo owner 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.
-
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.
-
repo owner what does "won't let me create a new table" mean? what exactly do you try and what exactly happens? Any error message?
-
repo owner - changed status to invalid
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.
- Log in to comment
On the left where you can choose the database, does it say [r] or [rw] next to the database name?