![]() ![]() I would not use the versions above to tell your sysadmins to install 3.22.0 or 3.23.0, though. If these informed guesses are wrong, then we're down to filesystem issues, kernel details, build details.all things that are currently hidden from us by your vague "linux OS" specifier. open directly.)Īnother platform-independent guess is that you're using WAL mode, so the read-only WAL feature that went into 3.22.0 is what you need, possibly coupled with the -readonly flag. open command, but the flag is available to the shell itself, so you can add -readonly to your calls to sqlite3 without using. (The commit comment only speaks of the shell's. That feature alone might make the difference between success and failure. What I can tell you without knowing your platform details is that the -readonly flag went into the sqlite3 shell in February of 2018, subsequently released in 3.23.0. 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 Jaar.PNG (51.98 KiB) Viewed 888 times maand.PNG (44.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. Also if someone has a bright idea on how to do the Bruto Verbruik, in a smarter way please share, currently did a transform in Grafana with a nasty outerjoin, should be a smarter way. ![]() If people are interested in the queries, let me know, happy to share them. I'm a beginner when it comes to writing SQL, not my core competence, however i mages to create a Monthly and a Yearly totals dashboard directly using the SQL plugin and using Meter_calendar and MultiMeter_calendar. FluxQL is not month away so the graphs look strange. I could use Grafana for this but but had 2 problems 1. I have a Synology job which runs every night so i have Today-1 which is more than enough for Monthly and Yearly statistics. Even when the database was in readonly mode, so solve this i'm making a daily copy (realtime data is commingg in using influx for daily stats). Initially I had some issues with getting erros after refresing the dashboard "Database malformed 11". Finally after some struggeling to get the Database History in grafana I'm not also using the SQL Lit plugin.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |