etsy / 411

An Alert Management Web Application
https://demo.fouroneone.io
MIT License
969 stars 112 forks source link

SQLSTATE[HY000]: General error: 8 attempt to write a readonly database #212

Closed narezatel closed 4 years ago

narezatel commented 4 years ago

Hi all ,

Using docker deployment kaiz/411:es6x I get "SQLSTATE[HY000]: General error: 8 attempt to write a readonly database" error when trying to add, delete or modify settings after deployment.

If I connect to the container's shell and run bin/create_user.php manually - i'm able to add a new user and I see this new user in "Users" tab in 411 GUI. If I try to delete the user from GUI - I get this error.

All files are owned by "www-data" user :

root@fe3fbc420bf3:/app# ls -lah total 1.3M drwxrwxr-x 1 www-data www-data 4.0K Oct 3 09:35 . drwxr-xr-x 1 www-data www-data 62 Oct 3 09:31 .. -rw-rw-r-- 1 www-data www-data 701 Oct 15 2018 .gitignore -rw-rw-r-- 1 www-data www-data 509 Mar 14 2019 411.conf -rw-rw-r-- 1 www-data www-data 194 Oct 26 2018 CODE_OF_CONDUCT.md -rw-rw-r-- 1 www-data www-data 258 Oct 15 2018 CONTRIBUTING.md -rw-rw-r-- 1 www-data www-data 8.5K Oct 15 2018 Gruntfile.js -rw-rw-r-- 1 www-data www-data 1.1K Oct 15 2018 LICENSE -rw-rw-r-- 1 www-data www-data 2.1K Mar 14 2019 README.md -rw-rw-r-- 1 www-data www-data 2.3K Oct 15 2018 RELEASE.md drwxrwxr-x 1 www-data www-data 259 May 19 04:09 bin -rw-rw-r-- 1 www-data www-data 1017 Oct 15 2018 bower.json drwxrwxr-x 1 www-data www-data 4.0K May 19 04:30 bower_components -rwxrwxr-x 1 www-data www-data 920 May 19 04:07 composer-es2x.json -rw-rw-r-- 1 www-data www-data 187K May 19 04:17 composer-es2x.lock -rwxrwxr-x 1 www-data www-data 920 May 19 04:07 composer-es5x.json -rw-rw-r-- 1 www-data www-data 187K May 19 04:19 composer-es5x.lock -rwxrwxr-x 1 www-data www-data 920 May 19 04:07 composer-es6x.json -rw-rw-r-- 1 www-data www-data 187K May 19 04:19 composer-es6x.lock lrwxrwxrwx 1 www-data www-data 16 May 19 04:31 config.php -> /data/config.php -rw-rw-r-- 1 www-data www-data 5.8K Mar 14 2019 config_example.php drw-rw-rw- 1 www-data www-data 94 May 18 19:28 data -rw-rw-rw- 1 www-data www-data 516K Oct 3 09:35 data.db -rw-rw-r-- 1 www-data www-data 19K Oct 15 2018 db.sql -rw-rw-r-- 1 www-data www-data 17K Oct 15 2018 db_mysql.sql -rw-rw-r-- 1 www-data www-data 208 Mar 14 2019 docker-compose-es2x.yml -rw-rw-r-- 1 www-data www-data 208 Mar 14 2019 docker-compose-es5x.yml -rw-rw-r-- 1 www-data www-data 208 Mar 14 2019 docker-compose-es6x.yml drwxrwxr-x 1 www-data www-data 144 May 19 04:30 htdocs drwxrwxr-x 1 www-data www-data 4.0K May 19 04:30 node_modules -rw-rw-r-- 1 www-data www-data 28K May 19 04:30 package-lock.json -rw-rw-r-- 1 www-data www-data 649 May 19 04:30 package.json drwxrwxr-x 1 www-data www-data 4.0K May 18 19:29 phplib -rw-rw-r-- 1 www-data www-data 573 Oct 3 10:34 supervisord.log -rw-rw-r-- 1 www-data www-data 2 Oct 3 09:31 supervisord.pid drwxrwxr-x 1 www-data www-data 241 Oct 15 2018 templates drwxrwxr-x 1 www-data www-data 206 May 19 04:30 vendor

Regards.

narezatel commented 4 years ago

fixed by adding "exec" permission for www-data user