Updating settings

Procedures to inspect and update MFSQL Connector settings for vault and database configuration.

The settings can be updated by rerunning the installation packages.

Alternatively procedures can be used. a) Updating vault connection settings b) Updating standard Connector setting

check out the settings table

Select * from mfvaultsettings

Inspect the settings if there is a problem with the connection to the vault. Table MFVaultSettings show some settings but not all while MFSettings table show the other settings for the Connector and other structure tables need to be join to show all the related components of the vault settings. Use the view to show these relations.

SELECT * FROM MFvwVaultSettings

or use the function to provide vault connection settings string as an input for the Vaultsettings parameter used in the CLR procedures.

SELECT dbo.FnMFVaultSettings()

Update the settings using the dedicated procedure. Note that only the items requiring a change need to be included as parameters.

updating the M-Files user name

EXEC spMFSettingsForVaultUpdate @Username = 'Admin'

change the password

EXEC spmfsettingsForVaultUpdate @Password = 'MotSys123'

perform procedure a connection test to show if the changes was successful

  DECLARE @MessageOut NVARCHAR(50);
  EXEC dbo.spMFVaultConnectionTest @MessageOut = @MessageOut OUTPUT

  SELECT @MessageOut

Other settings that can be reset with spmfsettingsForVaultUpdate include

  - `@NetworkAddress`
  - `@Vaultname`
  - `@MFProtocolType_ID`  (default: 1)
  - `@Endpoint`  (default: 2266)
  - `@MFAuthenticationType_ID`  (default: 4)
  - `@Domain`
  - `@VaultGUID`
  - `@ServerURL`

the Protocol type and authentication type are referenced in other tables

SELECT * FROM dbo.MFProtocolType AS mpt
SELECT * FROM dbo.MFAuthenticationType AS mat

To make changes to the other Connector settings:

  • only specify the items that should change

  • to add multiple users to the support email, separate the email addresses by ; eg ‘myemail@gmail.com;support@lamininsolutions.lcom’

DECLARE
@MFInstallationPath   nvarchar(128),
@MFilesVersion        nvarchar(128),
@AssemblyInstallationPath     nvarchar(128),
@SQLConnectorLogin    nvarchar(128),
@UserRole     nvarchar(128),
@SupportEmailAccount  nvarchar(128),
@EmailProfile         nvarchar(128),
@DetailLogging        nvarchar(128),
@DBName       nvarchar(128),
@RootFolder   nvarchar(128),
@FileTransferLocation         nvarchar(128),
@Debug        SMALLINT;


EXEC dbo.spMFSettingsForDBUpdate
   @MFInstallationPath = @MFInstallationPath,
   @MFilesVersion = @MFilesVersion,
   @AssemblyInstallationPath = @AssemblyInstallationPath,
   @SQLConnectorLogin = @SQLConnectorLogin,
   @UserRole = @UserRole,
   @SupportEmailAccount = @SupportEmailAccount,
   @EmailProfile = @EmailProfile,
   @DetailLogging = @DetailLogging,
   @DBName = @DBName,
   @RootFolder = @RootFolder,
   @FileTransferLocation = @FileTransferLocation,
   @Debug = @Debug