Important: Customers using Laserfiche Cloud Remote Agents must update to version 11.7.2405.42009 or greater by August 28, 2024 for them to continue to function. The latest Remote Agent can be downloaded by clicking your Remote Agent in the Integrations area and following the Installation Steps in the Workers tab.

Summary

This article details the changes for Laserfiche Remote Agent version 11.7.2405.42009 released on May 30, 2024. This update includes the following adjustments:

• Oracle drivers are no longer included in the Remote Agent package.
• MySQL drivers are no longer included in the Remote Agent package.

Additional Information

Remote Agent workers will no longer come packaged with copies of drivers to connect to Oracle and MySQL databases. Customers will be responsible for installing these packages separately if needed. The following instructions outline the steps to install these packages.

  Upgrading Remote Agent from an existing installation

• To download and place the Oracle DLL file for remote agents:

  1. Download and install the latest Remote Agent package from the Laserfiche Cloud Integrations area, following the Installation Steps in the Workers tab.
  2. Download the ODAC 21c (latest 64-bit version) package from Oracle's ODP.NET page in the ODAC Xcopy Packages section.
  3. Locate the downloaded ODAC21.12Xcopy_x64.zip file and unzip the package.
  4. Copy the full path of the Oracle.ManagedDataAccess.dll file from the unzipped package to your clipboard. Example: C:\Work\ODAC21.12Xcopy_x64\odpm\odp.net\managed\common\Oracle.ManagedDataAccess.dll
  5. Open the plugin_settings.json file located in the Remote Agent folder and add the following code, ensuring the DLL file path in the ExternalFilePath area matches the file path from step 3 and formatted for JSON syntax as shown in the code example:

     
     {
     	"RemoteScriptSourcePlugin": {
     		"AllowList": [ "." ],
     		"Disabled": false,
     		"Timeout": 60000
     	},
      
     	"RemoteDataSourcePlugin": {
     		"ExternalFilePaths": [ 
     		"C:\\Work\\ODAC21.12Xcopy_x64\\odpm\\odp.net\\managed\\common\\Oracle.ManagedDataAccess.dll"
     		]
     	}
     }
     

     Note: You must use the full file path. Relative paths are not sufficient.
  6. Locate the copied Oracle.ManagedDataAccess.dll file and ensure its Unblock security property is checked by right-clicking the file, choosing Properties, and locating the Unblock checkbox in the General tab. If the Unblock checkbox is not present, this step can be skipped.
  Note: Whenever you make a change to this DLL file or plugin_settings.json, you must restart the remote agent worker for the changes to take effect.

• To download and place the MySQL DLL file for remote agents:

  1. Download and install the latest Remote Agent package from the Laserfiche Cloud Integrations area, following the Installation Steps in the Workers tab.
  2. Download the mysql-connector-net-8.4.0.msi package from MySQL's Community Downloads page.
  3. Install the downloaded package.
  4. Copy the full path of the Oracle.ManagedDataAccess.dll file from the unzipped package to your clipboard. Example: C:\Program Files (x86)\MySQL\MySQL Connector NET 8.4\MySql.Data.dll
  5. Open the plugin_settings.json file located in the Remote Agent folder and add the following code, ensuring the DLL file path in the ExternalFilePath area matches the file path from step 3 and formatted for JSON syntax as shown in the code example:

     
     {
     	"RemoteScriptSourcePlugin": {
     		"AllowList": [ "." ],
     		"Disabled": false,
     		"Timeout": 60000
     	},
      
     	"RemoteDataSourcePlugin": {
     		"ExternalFilePaths": [ 
     		"C:\\Program Files (x86)\\MySQL\\MySQL Connector NET 8.4\\MySql.Data.dll"
     		]
     	}
     }
     

     Note: You must use the full file path. Relative paths are not sufficient.
  6. Locate the copied MySql.Data.dll file and ensure its Unblock security property is checked by right-clicking the file, choosing Properties, and locating the Unblock checkbox in the General tab.
  Note: Whenever you make a change to this DLL file or plugin_settings.json, you must restart the remote agent worker for the changes to take effect.

  New Remote Agent without an existing installation

• To download and place the Oracle DLL file for remote agents:

  1. Download and install the latest Remote Agent package from the Laserfiche Cloud Integrations area, following the Installation Steps in the Workers tab.
  2. Download the ODAC 21c (latest 64-bit version) package from Oracle's ODP.NET page in the ODAC Xcopy Packages section.
  3. Locate the downloaded ODAC21.12Xcopy_x64.zip file and unzip the package.
  4. Copy the full path of the Oracle.ManagedDataAccess.dll file from the unzipped package to your clipboard. Example: C:\Work\ODAC21.12Xcopy_x64\odpm\odp.net\managed\common\Oracle.ManagedDataAccess.dll
  5. Open the plugin_settings.json file located in the Remote Agent folder and add the DLL file path in the ExternalFilePath area copied from step 3, formatted for JSON syntax as shown in the code example:

     
     {
     	"RemoteScriptSourcePlugin": {
     		"AllowList": [ "." ],
     		"Disabled": false,
     		"Timeout": 60000
     	},
      
     	"RemoteDataSourcePlugin": {
     		"ExternalFilePaths": [ 
     		"C:\\Work\\ODAC21.12Xcopy_x64\\odpm\\odp.net\\managed\\common\\Oracle.ManagedDataAccess.dll"
     		]
     	}
     }
     

     Note: You must use the full file path. Relative paths are not sufficient.
  6. Locate the copied Oracle.ManagedDataAccess.dll file and ensure its Unblock security property is checked by right-clicking the file, choosing Properties, and locating the Unblock checkbox in the General tab. If the Unblock checkbox is not present, this step can be skipped.
  Note: Whenever you make a change to this DLL file or plugin_settings.json, you must restart the remote agent worker for the changes to take effect.

• To download and place the MySQL DLL file for remote agents:

  1. Download and install the latest Remote Agent package from the Laserfiche Cloud Integrations area, following the Installation Steps in the Workers tab.
  2. Download the mysql-connector-net-8.4.0.msi package from MySQL's Community Downloads page.
  3. Install the downloaded package.
  4. Copy the full path of the Oracle.ManagedDataAccess.dll file from the unzipped package to your clipboard. Example: C:\Program Files (x86)\MySQL\MySQL Connector NET 8.4\MySql.Data.dll
  5. Open the plugin_settings.json file located in the Remote Agent folder and add the DLL file path in the ExternalFilePath area copied from step 3, formatted for JSON syntax as shown in the code example:

     
     {
     	"RemoteScriptSourcePlugin": {
     		"AllowList": [ "." ],
     		"Disabled": false,
     		"Timeout": 60000
     	},
      
     	"RemoteDataSourcePlugin": {
     		"ExternalFilePaths": [ 
     		"C:\\Program Files (x86)\\MySQL\\MySQL Connector NET 8.4\\MySql.Data.dll"
     		]
     	}
     }
     

     Note: You must use the full file path. Relative paths are not sufficient.
  6. Locate the copied MySql.Data.dll file and ensure its Unblock security property is checked by right-clicking the file, choosing Properties, and locating the Unblock checkbox in the General tab.
  Note: Whenever you make a change to this DLL file or plugin_settings.json, you must restart the remote agent worker for the changes to take effect.

Release history

• Laserfiche Remote Agent May 30, 2024 Update: Version 11.7.2405.42009

  • Oracle drivers are no longer included in the Remote Agent package.
  • MySQL drivers are no longer included in the Remote Agent package.