lizmap-web-client icon indicating copy to clipboard operation
lizmap-web-client copied to clipboard

Lizmap SQLite3::exec() ERROR

Open marco-03091991 opened this issue 4 years ago • 2 comments

Hi to everybody, i am facing this error from lizmap, how can i solve this problem? now i cannot visualize the demo file ( i will try to visualize new project folder) is this a consequence from this kind of error? This seem a permission problem to a default target database, because i didn't any change. Marco

Screenshots and logs

This is the error_log view from administrator panel:

2020-08-24 11:29:50 ::1 warning 2020-08-24 11:29:50 [2] SQLite3::exec(): attempt to write a readonly database /var/www/lizmap-web-client-3.3.9/lib/jelix/plugins/db/sqlite3/sqlite3.dbconnection.php 120

Environment

  • Lizmap version: 3.3.9
  • QGIS Server FULL version: 2.18.
  • QGIS Desktop FULL version: 2.18.28
  • OS : Ubuntu Server 16.04 LTS
  • Browser: Firefox
  • Lizmap admin information (users, logs…) stored into Sqlite (default)

marco-03091991 avatar Aug 24 '20 10:08 marco-03091991

Have you tried the lizmap/install/set_rights.sh ?

Gustry avatar Aug 25 '20 06:08 Gustry

This issue happens with 3.5.5 The directory does have the same root:root 664 inside the container.

/www/lizmap/var/db # ls -la
total 110
drwxrwxr-x    2 root     root             5 Jul 21 11:45 .
drwxrwxr-x    1 root     root          4096 Jul 21 10:34 ..
-rw-rw-r--    1 root     root             0 Jul 21 10:28 .empty
-rw-rw-r--    1 root     root         81920 Jul 21 11:45 jauth.db
-rw-rw-r--    1 root     root         20480 Jul 21 10:33 logs.db

Error 500. A technical error has occurred. Sorry for this trouble.

sincorchetes avatar Jul 22 '22 10:07 sincorchetes