Would you like us to simply guess which one covers your particular case? "linux OS" covers hundreds of distributions, each of which supports many filesystems, atop which you have SQLite's own multifarious build details, creating a combinatorial explosion of likely sources for your problem. Search for "read" in the SQLite change log, then ask yourself if you're seriously wanting someone to bisect 8 years of history with numerous changes to the required functionality for you, without even having a reproducible test case to do the bisecting with. Which version of sqlite properly allows for read only access as i've described? On some systems, you can even link it statically so it doesn't depend on platform libraries, so you may even be able to build on a different Linux system type and copy the executable over. You don't need complex packaging systems with carefully-crafted permission sets to make it work properly. Why are you limited to only what your sysadmins installed? SQLite is easy to compile and install. this post suggests adding a read only pragma to the reading session, is that required?ģ.7 is the version our sysadmins installed What is the recommended method to restrict read only perms to public users while allowing read write by the database owner? I've searched the docs but couldn't find anything specific about this. Its unclear why a select query should require a write operation? "Exception in thread "main" : unknown error (attempt to write a readonly database)" I have another use case where a different service account user is attempting to query a table via jdbc connection and that results in Loading resources from /users/******/.sqlitercĮnter SQL statements terminated with a " " ~$ sqlite3 /opt/bigcdr/nlp/db/prd/control/cdr_control.db eg if i run without sudo i'm able to open the sqlite tool but cannot view tables or open the database file? My issue is that no other user can access this. Sudo -u svc_merc_cdr_prod sqlite3 /opt/bigcdr/nlp/db/prd/control/cdr_control.db I can access this database as the service account and perform updates, eg from a linux terminal: rw-r-r- 1 svc_merc_cdr_prod svc_merc_cdr_prod 427008 Jul 9 11:08 /opt/bigcdr/nlp/db/prd/control/cdr_control.db * database file and containing directory path set up with chmod 644, eg * the database is created using sudo to a service account called svc_merc_cdr_prod "log_timestamp_format": "%Y-%m-%d %H:%M:%S.I need to create a database that can only be updated by the database owner, but allow all other users read privilege on the data. "authenticator_disable_time_drift": false, I am unsure on how to proceed, could anyone point me in the right direction? this tool was able to read and write to the copy, no problem. I saw in the issues on github that someone had a corrupt sqlite db, so I copied the db file to my pc, and tried opening it with “sqlitebrowser”. Looks normal to me, considdering that this docker uses uid 1000 by default.įor completeness I have also included the config.json, but note that that has not been changed in a few months, and it has been working fine up untill this morning. ĭrwxrwxrwx 1 nobody users 620 Dec 24 16:10. Well, here is the output of ls -al: total 412ĭrwxrwxrwx 1 nobody users 222 Jan 17 04:26. This seemed weird to me, so i made the usual checks: Diskspace: still more than 100GB free, shouldn’t be an issue. POST /identity/connect/token (login) => 400 Bad Request POST /api/accounts/prelogin (prelogin) => 200 OK Listening for new connections on 0.0.0.0:3012. SIGNUPS_ALLOWED, INVITATIONS_ALLOWED, ADMIN_TOKEN please use the admin panel to make changes to them: The following environment variables are being overriden by the config file, | Report suspected bugs/issues in the software itself at: | | Send usage/configuration questions or feature requests to: | | official channels to report bugs/features, regardless of client. | This is an *unofficial* Bitwarden implementation, DO NOT use the | Naturally I went to the logs: | Starting Vaultwarden | So this morning when trying to login to vaultwarden, i was greeted with an “Error saving device” message.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |