Red Gate forums :: View topic - Temp file deleted by virusscanner
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK Previous Versions
SQL Comparison SDK Previous Versions forum

Temp file deleted by virusscanner

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
tombb



Joined: 06 Apr 2010
Posts: 3

PostPosted: Wed Apr 28, 2010 3:02 pm    Post subject: Temp file deleted by virusscanner Reply with quote

Hello,

I'm currently testing the SDK trial version. The plan is to use this for comparing data between databases.

When i run the comparison, temporarily files will be created in the C:\Documents and Settings\<username>\Local Settings\Temp\Red Gate. My virusscanner, McAffee, tells me that a certain tmp file is a trojan. Exploit-ObscuredHtml. The file get's deleted by the virusscanner and an error will be shown when looping trough the differences in resultsstore. FileNotFoundException, could not find file ....

Is this a problem in the SDK that makes the temp file look like a trojan?
Maybe this is to be solved by changing the directory where the temp files are created to an excluded zone of the virusscanner. How is this possible?

Additional note: This is not happening with every database i have tried, so the comparison is working correctly.

Thank you for your answer in advance!
Back to top
View user's profile Send private message
tombb



Joined: 06 Apr 2010
Posts: 3

PostPosted: Thu Apr 29, 2010 9:56 am    Post subject: Reply with quote

Solved the problem by moving the temp directory to a safe zone.

Used this topic: http://ftp.red-gate.com/messageboard/viewtopic.php?p=38749&sid=7d8ddcc78c3f669ab956073099fb931c
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6645

PostPosted: Thu Apr 29, 2010 4:50 pm    Post subject: Reply with quote

Hi Tom,

It does sound as if some of the data in the database actually triggers the virus scanner alert -- for instance, it could be some IMAGE data or a CLR assembly. You can move the temporary data to a different folder by setting an environment variable on the process block of the SDK application called RGTEMP, which will point to the dirtectory that you want to use. You can then exclude this well-known directory from scanning if you want to.

I hope this helps.
Back to top
View user's profile Send private message
tombb



Joined: 06 Apr 2010
Posts: 3

PostPosted: Mon May 03, 2010 4:07 pm    Post subject: Re: Reply with quote

Brian Donahue wrote:
Hi Tom,

It does sound as if some of the data in the database actually triggers the virus scanner alert -- for instance, it could be some IMAGE data or a CLR assembly. You can move the temporary data to a different folder by setting an environment variable on the process block of the SDK application called RGTEMP, which will point to the dirtectory that you want to use. You can then exclude this well-known directory from scanning if you want to.

I hope this helps.


Thank you for your response. I was also thinking this could be a problem with binary data. Is this something that can be fixed in the SDK or is this inevitable?

I solved the problem by moving the temp directory as explained in the topic i linked to earlier.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6645

PostPosted: Mon May 03, 2010 7:12 pm    Post subject: Reply with quote

If there is suspicious binary data in the database being written to SQL Data Compare's temp files, I don't know how you could change that so the virus scanner doesn't get upset about it, except of course to exclude the directory from being scanned.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group