Anthony Thyssen wrote: > On Thu, 22 Apr 2010 08:42:59 +0000 (UTC) > user1 <bq...@telia.com> wrote: > > | O> > | > i've just started using encfs-1.2.0 on debian-3.1 to store an > | > sqlite-3.4.2 database used by a website. i quickly started getting some > | > scary messages from sqlite3 about the database being malformed or tables > | > not existing. > | > will then be upgraded to debian-5.0 which has encfs-1.4.2 in stable. > | > > | > my question is: does anyone have any idea what the cause of these > | > problems might be and, if so, which version of encfs (if any) will solve > | > it? i.e. will encfs-1.4.2 be enough? > | > | I do not know, but I am using ubuntu 9.04 and encfs 1.4.2-2 and it works > | fine for me > | > how often are the sqlite3 databases being modified?
it's being modified most of the time by website users. when testing with the new ubuntu version of encfs i was getting errors with effectively just two concurrent users (i.e. a mass import of data into the database and one website user (i.e. myself) doing things at the same time. > It may be you will need to use sqlite commands to generate a separate > copy for backup purposes, leaving the original one on a exclusion list. the manpage for encfs makes no mention of an exclusion list. but that's effectively what i've done. instead of using encfs for everything associated with the website and its database, i'm only using it to encrypt certain directories that contain write-once files that contain sensitive data. it was unfortunate because it meant that i had to make code changes so that the application itself performed the necessary encrytion in the database rather than letting encfs take care of it without making code changes. > the sqlite3 command shows a 'backup' command as one of its options. it's called ".dump". > Anthony Thyssen ( System Programmer ) <a.thys...@griffith.edu.au> > -------------------------------------------------------------------------- > I don't make the rules... I just impliment them! > -- Programmers Law of Policy > -------------------------------------------------------------------------- > Anthony's Castle http://www.cit.griffith.edu.au/~anthony/ > > ------------------------------------------------------------------------------ cheers, raf ------------------------------------------------------------------------------ _______________________________________________ Encfs-users mailing list Encfs-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/encfs-users
