Mar 02, 2015; 20:39
Johan Solve
SQLite permission problems (solved)
Just something for the archives...
I unfortunately had reason to restore a lot of files from an
incomplete Time Machine backup to my local machine (don't ask...).
Among other things my local Lasso 8 installation.
Lasso 8 wouldn't start up. Lasso console showed things like this:
StorageManager had an "issue" VACUUMing the internal database. errno=8
"attempt to write a readonly database"
SQLite Error: 1 SQL logic error or missing database while executing:
BEGIN IMMEDIATESQLite Error: 1 SQL logic error or missing database
while executing: INSERT INTO errors
So it was a permissions error. The SQLite db files had correct
permissions rw-r----- with lasso as owner, but they also had extended
attributes and ACL permissions set, shown by @ or +. This is
apparently something that Time Machine adds when a backup is in
progress.
This was the fix:
Recursively remove extended atttributes:
sudo xattr -rc ~lasso
Recursively remove ACL permissions:
sudo chmod -R -N ~lasso
--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad Stockholm
http://www.montania.se
Johan Sölve
Mobil +46 709-51 55 70
johan@montania.se
Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 | Fax +46 35-136801
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>