Re: [sqlite] Transaction journal corrupted by antivirus
Voxen wrote: The problem is my application is used by thousand of customers. I cannot ask them to tweak their antivirus. An observation. Thunderbird uses simple text files to store unencrypted messages. I am not aware of anti-virus programs having trouble with those files. Perhaps a little research into how Mozilla has avoided the problem would be warranted? If it turns out that their text files themselves are not affected by the anti-virus operation, then perhaps base 64 encoding would be sufficient for your application. John - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Transaction journal corrupted by antivirus
You are in a sticky situation. Read below -- On 5/3/07, Voxen <[EMAIL PROTECTED]> wrote: Hi, My application is storing email messages in a SQLite database (raw email messages as they are downloaded from the mail server). This is done under a transaction. Sometimes I get the SQLITE_MISUSE error and by watching the antivirus (Avast) log, I found this: Sign of "Uruguay 6/7/8" has been found in "C:\Documents and Settings\Voxen\Application Data\MyApp\mail.db-jounal" file. This means the antivirus found a virus in the transaction journal file and removes it. Its altering the journal file and then produces a SQLITE_MISUSE error. How can I work around this? Do I need to ZIP or encode the email message before storing it in the database? Your antivirus software is doing you a favor by removing the virus, and you really don't want to stop it from doing so, else your db will be carrying the virus within it. On the other hand, the antivirus software is really like another user. Just like you can't stop a user (or yourself) from destroying the journal/db file, you can't really stop the antivirus software from doing so. Perhaps you could implement an antivirus scanning _before_ you insert the messages into your database. Of course, then you would not only have to write such an antivirus software portion yourself, you will have to distribute the antivirus-strengthened email program to all your users. Otherwise, yes, you would have to stop your av software from scanning your db, but that means your db will be carrying viral payloads. Dang! -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ - collaborate, communicate, compete = - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Transaction journal corrupted by antivirus
Voxen <[EMAIL PROTECTED]> wrote: > The problem is my application is used by thousand of customers. > I cannot ask them to tweak their antivirus. > > > > > How can I work around this? > > Do I need to ZIP or encode the email message before storing it in the > > database? > > If the antivirus is seeing virus signatures in the email messages, then by compressing the message using zlib before adding it to the database you should be able to defeat the antivirus software. This will have the added bonus of reducing disk I/O which will likely make your program appear to run faster. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Transaction journal corrupted by antivirus
The problem is my application is used by thousand of customers. I cannot ask them to tweak their antivirus. Most anti-virus software allows you to specify an exception folder and/or file. Tell the anti-virus to ignore sqlite db and the journal. Sam --- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: Voxen [mailto:[EMAIL PROTECTED] Sent: Thursday, May 03, 2007 2:58 AM To: sqlite-users@sqlite.org Subject: [sqlite] Transaction journal corrupted by antivirus Hi, My application is storing email messages in a SQLite database (raw email messages as they are downloaded from the mail server). This is done under a transaction. Sometimes I get the SQLITE_MISUSE error and by watching the antivirus (Avast) log, I found this: Sign of "Uruguay 6/7/8" has been found in "C:\Documents and Settings\Voxen\Application Data\MyApp\mail.db-jounal" file. This means the antivirus found a virus in the transaction journal file and removes it. Its altering the journal file and then produces a SQLITE_MISUSE error. How can I work around this? Do I need to ZIP or encode the email message before storing it in the database? Thanks Voxen - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Transaction journal corrupted by antivirus
Most anti-virus software allows you to specify an exception folder and/or file. Tell the anti-virus to ignore sqlite db and the journal. Sam --- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: Voxen [mailto:[EMAIL PROTECTED] Sent: Thursday, May 03, 2007 2:58 AM To: sqlite-users@sqlite.org Subject: [sqlite] Transaction journal corrupted by antivirus Hi, My application is storing email messages in a SQLite database (raw email messages as they are downloaded from the mail server). This is done under a transaction. Sometimes I get the SQLITE_MISUSE error and by watching the antivirus (Avast) log, I found this: Sign of "Uruguay 6/7/8" has been found in "C:\Documents and Settings\Voxen\Application Data\MyApp\mail.db-jounal" file. This means the antivirus found a virus in the transaction journal file and removes it. Its altering the journal file and then produces a SQLITE_MISUSE error. How can I work around this? Do I need to ZIP or encode the email message before storing it in the database? Thanks Voxen - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -