Description
Customers with anti-virus installed on the ProjectDox Servers must enable the following exclusion rules in any scanning utilities installed to prevent issues with the function of the software. Avolve recommends that only the PdoxTemp folder be scanned in real-time. All other ProjectDox application folders and supporting folders, including all sub-folders, should be excluded from anti-virus applications real-time scanning. A nightly scan of the directories is acceptable. It is not recommended to have anti-virus installed on the Job Processors. Avolve cannot guarantee the operation of the Job Processors with anti-virus installed on the servers and, in the event issues occur with publishing, the first recommendation will be to remove the anti-virus application from the Job Processors and perform a full reboot. Perform testing after the Job Processor has been rebooted to see if the issue is resolved.
Solution
Avolve recommends setting up exclusion rules for the folders specified below on the ProjectDox servers indicated. Assuming the Operating System is installed on the C:\ drive and the ProjectDox, related services and Brava applications are installed on the E:\ drive, you would want to exclude the following folders, including any sub-folders, on the ProjectDox servers. A list of common Share Folder Names used by ProjectDox is provided below.
- UserFilesSource or UFS - Stores original files uploaded by users
- UserFilesPublish or UFP - Stores published ActiveX version of files uploaded by users
- DLCache - Stores published HTML version of files uploaded by users
- Queue - Stores Job Tickets created for publishing requests for the Job Processors
- PdoxLogs or Logs - Stores Archive PDFs if using ProjectDox Archive Feature
- PdoxExport or Export - Stores Exported Projects until retrieved by EDMS solution
- WFlowDLLCache - Stores ProjectFlow workflow instance DLLs for active workflows
- PdoxTemp - All uploaded files are stored in this folder first before being moved to the UserFilesSource folder. This folder should not be excluded as it is the single point of entry for any new files uploaded to ProjectDox and should be scanned in real-time.
NOTE: Some anti-virus applications may need an additional exclusion rule enabled for .rtf file types. If you experience trouble with missing Markups or Changemarks within the workflow, then please try adding the exclusion rule for file types of .rtf and see if that resolves your issue. Markups and Changemarks are saved to the PdoxTemp folder temporarily and some anti-virus applications will false alert and remove the .rtf file causing saved Markups and Changemarks to not show up in the workflow.
Job Processors
C:\Windows\system32\spool\PRINTERS\
C:\Windows\Temp\ ** (see additional info below)
C:\Users\NetItSvc\AppData\Local\Informative Graphics Corp\
C:\Users\NetItSvc\AppData\Local\Temp\
C:\Users\NetItSvc\AppData\Roaming\Informative Graphics Corp\
C:\ProgramData\IGC\ (Brava 16.2 and 16.4)
C:\ProgramData\OpenText\ (Brava 16.6 and up)
E:\Program Files (x86)\IGC\
E:\Program Files (x86)\Avolve\
E:\Program Files\IGC\
E:\JPTemp\ ** (see additional info below)
E:\ProjectDoxSupportFiles\ or E:\PDSF * (see note below)
Web Server
w3wp.exe Process
E:\ProjectDox\ (Superion customers may see E:\EPR instead of E:\ProjectDox)
E:\ProjectDox.Web.API
E:\ProjectDox.Web.UI
E:\Program Files (x86)\Avolve\
E:\ProjectDoxSupportFiles\ or E:\PDSF * (see note below)
Application Server
E:\Program Files (x86)\Avolve\
E:\ProjectDoxSupportFiles\ or E:\PDSF * (see note below)
NOTE *
ProjectDox file share folders may exist on any ProjectDox server, Network Storage Device or stand-alone File Server.
The PdoxTemp folder is the single entry point of new files to the server and therefore it is recommended to scan this folder only in real-time. A nightly scan can be performed of the folders if desired.
Exclude all share folders with the exception of PdoxTemp from real-time scanning.
ADDITIONAL INFO **
If you are unable to exclude C:\Windows\Temp on the Job Processors, you can update the system output path of the IGC Writer Print driver and use a different directory for example E:\JPTemp.
To do this:
- Create a folder on the E:\ drive named JPTemp
- Grant Full Control under the Security Options for the folder, to the PD_USR and NetISvc accounts
- In the Control Panel Printers and Faxes panel, right-click on the CSF Writer printer and select Properties
- Select the Advanced tab
- Click the Printing Defaults... button
- Select the Filename Generation tab
- Change the Output Directory path to the following: E:\JPTemp
- Click OK to save your settings.
Then add an exclusion rule for the E:\JPTemp folder on the Job Processors in place of the C:\Windows\Temp folder
SQL Server
Antivirus exclusion on SQL files:
When you configure antivirus software settings, make sure that you exclude the following files or directories on SQL Server machine from virus scanning. Doing this improves the performance of the files and helps make sure that the files are not locked when the SQL Server service must use them. However, if these files become infected, your antivirus software cannot detect the infection.
- SQL Server data files (.mdf, .ndf, .ldf files)
- SQL Server backup files (.bak, .trn files)
- Full-Text catalog files
- Trace files (.trc files )
- SQL audit files for SQL Server 2008 or later versions (.sqlaudit files)
- SQL query files (.sql files)
- The directory that holds Analysis Services data
- The directory that holds Analysis Services temporary files that are used during Analysis Services processing
- Analysis Services backup files
- The directory that holds Analysis Services log files
- Directories for any Analysis Services 2005 and later-version partitions that are not stored in the default data directory
- Filestream data files (SQL 2008 and later versions)
- Remote Blob Storage files (SQL 2008 and later versions)
- The directory that holds Reporting Services temporary files and Logs (RSTempFiles and LogFiles)
Processes to exclude from virus scanning
SQL Server 2016
- %ProgramFiles%\Microsoft SQL Server\MSSQL13.\MSSQL\Binn\SQLServr.exe
- %ProgramFiles%\Microsoft SQL Server\MSRS13.\Reporting Services\ReportServer\Bin\ReportingServicesService.exe
- %ProgramFiles%\Microsoft SQL Server\MSAS13.\OLAP\Bin\MSMDSrv.exe
SQL Server 2014
- %ProgramFiles%\Microsoft SQL Server\MSSQL12.\MSSQL\Binn\SQLServr.exe
- %ProgramFiles%\Microsoft SQL Server\MSRS12.\Reporting Services\ReportServer\Bin\ReportingServicesService.exe
- %ProgramFiles%\Microsoft SQL Server\MSAS12.\OLAP\Bin\MSMDSrv.exe
SQL Server 2012
- %ProgramFiles%\Microsoft SQL Server\MSSQL11.\MSSQL\Binn\SQLServr.exe
- %ProgramFiles%\Microsoft SQL Server\MSRS11.\Reporting Services\ReportServer\Bin\ReportingServicesService.exe
- %ProgramFiles%\Microsoft SQL Server\MSAS11.\OLAP\Bin\MSMDSrv.exe
SQL Server 2008 R2
- %ProgramFiles%\Microsoft SQL Server\MSSQL10_50.\MSSQL\Binn\SQLServr.exe
- %ProgramFiles%\Microsoft SQL Server\MSSQL10_50.\Reporting Services\ReportServer\Bin\ReportingServicesService.exe
- %ProgramFiles%\Microsoft SQL Server\MSSQL10_50.\OLAP\Bin\MSMDSrv.exe
SQL Server 2008
- %ProgramFiles%\Microsoft SQL Server\MSSQL10.\MSSQL\Binn\SQLServr.exe
- %ProgramFiles%\Microsoft SQL Server\MSSQL10.\Reporting Services\ReportServer\Bin\ReportingServicesService.exe
- %ProgramFiles%\Microsoft SQL Server\MSSQL10.\OLAP\Bin\MSMDSrv.exe
You can run antivirus software on a SQL Server cluster. However, you must make sure that the antivirus software is a cluster-aware version. If you are running antivirus software on a cluster, make sure that you also exclude these locations from virus scanning:
- Q:\ (Quorum drive)
- C:\Windows\Cluster
Please refer the article for more information: https://support.microsoft.com/en-us/help/309422/how-to-choose-antivirus-software-to-run-on-computers-that-are-running
Comments
0 comments
Please sign in to leave a comment.