Skip to main content

Server Preparation

First review our system requirements to ensure that your environment meets our minimum requirements.

Then install the pre-requisites as detailed below. All sections should be executed on the web server, unless marked as 'Database Server'.

Microsoft SQL Server 2022 (Database Server)​

Note: This should be installed on the database

Install Microsoft SQL Server 2022 according to Microsoft documentation. In the Feature Selection pane of the SQL Server 2022 Setup, check the following features:

  • Database Engine Services
    • SQL Server Replication
    • Full-text Search

On the Instance Configuration screen, choose 'Default instance'.

On the Server Configuration screen, ensure the following settings:

ServiceAccount NameStartup Type
SQL Server AgentNT AUTHORITY\NETWORK SERVICEAutomatic
SQL Server Database EngineNT AUTHORITY\NETWORK SERVICEAutomatic
SQL Full-text Filter Daemon LauncherNT AUTHORITY\LOCAL SERVICEManual
SQL Server BrowserNT AUTHORITY\LOCAL SERVICEAutomatic

Note that some fields may be greyed out and therefore are unable to be changed. These can be left at their default values.

On the Database Engine Configuration screen, choose "Mixed Mode Authentication", and provide a strong password for the user "sa". Make a note of this password.

Note: The installer requires passwords are UTF-8 compatible, with alphanumerics preferred.

You will also need to provide at least one Windows user account, in the "Specify SQL Server administrators box".

Additional services

We recommend installing the following additional services:

Enable MS SQL for Remote Access_

In the SQL Server Configuration Manager, under 'SQL Server Network Configuration' > 'Protocols for MSSQLSERVER', enable:

  • Shared memory
  • Named pipes
  • TCP/IP

These changes will require restarting SQL Server. To do this, open Services.msc (this can be found by clicking "Start" and then typing "Services.msc" in the search box on the Start Menu). Locate "SQL Server (MSSQLSERVER)", right-click it and select "Restart".

Setting up Database users (Database Server)​

The Jadu Application requires 3 different database users to run the application. We recommend to create 3 users with the following names:

  • jadu
  • jaduGM
  • jaduGU

The users should use SQL authentication, and not enforce password expiration.

Make sure the password for these users strictly adheres to the organization policy. Please ensure passwords contain alphanumeric characters only. Make a note of the passwords, as you'll need them for the install later.

Note: The privilege of the users will be altered using installation.

IIS 10.0​

  1. Open Windows Server Manager and click "Add Roles & Features" from the Quick start section in the main panel.
  2. Click "Next" to begin selecting roles for the server.
  3. When prompted to select an installation type select "Role-based or Feature-based" and click "Next".
  4. You will now need to select the server to install the roles on. Make sure the "Select a server from the server pool" is selected and then choose the server you are connected to from the box below it and click "Next".
  5. Check "Web Server (IIS)" from the list and add any features that it shows are required. Click "Next".
  6. On the 'Features' screen, click "Next".
  7. You'll eventaully reach the 'Role services' screen for 'Web Server (IIS)'. Make sure to check the following services are enabled under Web Server, and click "Next":
    • Common HTTP Features - include all sub items
    • Performance - include all sub items
    • Health and Diagnostics
      • HTTP Logging
      • ODBC
      • Request Monitor
    • Security
      • Request Filtering
      • Digest Authentication
      • IP and Domain Restrictions
      • URL Authorization
    • Application Development
      • .NET Extensibilty 4.8
      • ASP .NET 4.8
      • CGI
      • ISAPI Extensions
      • ISAPI Filters
    • FTP Server (if setting up a load balanced environment)
    • Management Tools
      • IIS Management Console
      • IIS 6 Management Compatibility, including all sub items
  8. Check that everything required is listed and click "Install".
  9. Open IIS Manager, and delete the default site.

IIS URL Rewrite​

Install IIS URL Rewrite extension from the Microsoft site.

PHP​

Before installing PHP on your system please install the following:

Windows builds of PHP can be downloaded from http://windows.php.net/download/. For use with IIS and FastCGI the x64 Non Thread Safe version of PHP 8.3 should be downloaded.

  1. Extract the downloaded zip to a folder of your choice. For example C:\PHP\.
  2. Open the folder you extracted PHP to and make a copy of php.ini-production and rename it to php.ini
  3. Open this php.ini file and ensure the extension_dir setting is set to the ext folder within your php installation.
  4. Open the Control Panel, click System and Security, click System, and then click Advanced system settings.
  5. In the System Properties window, select the Advanced tab, and then click Environment Variables.
  6. Select Path under System Variables and click Edit.
  7. Add the path to where you extracted PHP onto the end. For example C:\PHP. Click OK.
  8. Open IIS Manager. Select the hostname of your server and double-click Handler Mappings.
  9. Click Add Module Mapping in the Action panel.
  10. Enter *.php in the Request Path. Select FastCgiModule from the Module menu.
  11. Type the full path to Php-cgi.exe into the Executable box. For example C:\PHP\php-cgi.exe
  12. Enter a suitable name into the Name box e.g. 'PHP FastCGI Handler' and click OK. If presented with a further question asking about adding an application for the executable, click 'Yes'.
  13. Return to the main screen for hostname.
  14. Double click Default Document.
  15. Click Add in the Action panel and enter index.php into the Name box then click OK
  16. Return to the main screen for hostname.
  17. Double click MIME Type
  18. Click "Add" from the right hand menu
  19. In the dialog box that opens specify .webmanifest in the filename extension box and application/manifest+json in the MIME type box

INI changes​

As standard, Jadu make a few changes to the distribution PHP configuration file to improve security and prevent common errors from being raised. In php.ini we need to:

  • Disable .user.ini by uncommenting the line
  • Disable exposing of PHP
  • Set the level of error logging
  • Set an appropriate time zone
  • Update the max_input_vars configuration value
  • Update the filesize limits

By changing the following lines:

user_ini.filename =
expose_php = Off
error_reporting = E_ALL & ~E_DEPRECATED & ~E_NOTICE
date.timezone = Europe/London
max_input_vars = 1250
post_max_size = 32M
upload_max_filesize = 24M

PHP modules​

Search within the php.ini file for:

extension=ldap
extension=curl
extension=fileinfo
extension=gd
extension=intl
extension=mbstring
extension=openssl
extension=soap
extension=zip
extension=enchant
zend_extension=opcache
opcache.enable=1

And ensure they are uncommented. If the line starts with a semi-colon (;) the line is commented out, remove the semi-colon to uncomment the line.

Uncomment and update the value of opcache.enable_cli to be On

Add the following line to the extensions list: extension=enchant

Microsoft Drivers for PHP for SQL Server​

Microsoft Drivers for PHP for SQL Server 5.12 can be downloaded from Microsoft.com

  1. Download the Windows 8.1 zip file, extract the file
  2. Copy the x64 versions of DLL to the location of the php extension directory. For example C:PHP\ext\
  3. Add the lines below to the end of the php.ini file:
extension=php_pdo_sqlsrv_83_nts_x64.dll
extension=php_sqlsrv_83_nts_x64.dll

APCu​

This can be downloaded from https://pecl.php.net/package/APCu

  1. Download the x64 Non Thread Safe version of PHP 8.3 and extract the files.
  2. Copy the DLL to the location of the php extension directory. For example C:PHP\ext\
  3. Add the lines below to the end of the php.ini file:
extension=php_apcu.dll
apc.enabled=1
apc.shm_size=32M
apc.ttl=7200
apc.enable_cli=1

Update CA Certificates​

  1. Download https://curl.se/ca/cacert.pem and place file in the PHP install directory
  2. Add: curl.cainfo=cacert.pem to the php.ini
  3. Reload IIS as Administrator. e.g. iisreset

Antivirus​

On Windows systems, clam can be installed by downloading a zip file from http://oss.netfarm.it/clamav/ - the mingw version should be selected.

  • Extract the downloaded zip to C:\ClamAV\
  • Create two empty folders named db and tmp inside the C:\ClamAV\ directory
  • Using the Windows command prompt, navigate to C:\ClamAV and run:
> clamd --install
> freshclam
  • Open services.msc, set the Clam service to have a startup type of Automatic and start the service.
  • Make sure clamd.log has write/modify permissions for users (i.e users group)

Troubleshooting Clam​

If freshclam fails due to an SSL error, you need to add the root certificate for ClamAV to Windows itself. To do this:

  1. Open Powershell, by searching for it, right-clicking on it and choosing 'Run as Administrator'
  2. Run the Powershell script update_root_certs.ps1 provided by Jadu

Then attempt to run freshclam again.

Web statistics​

The default field settings for IIS logging will result in no results being shown in the web statistics report. For the application to correctly parse IIS log files, IIS field settings must be adjusted as follows:

  • date
  • time
  • c-ip
  • cs-username
  • s-sitename
  • s-ip
  • s-port
  • cs-method
  • cs-uri-stem
  • cs-uri-query
  • sc-status
  • sc-substatus
  • sc-win32-status
  • sc-bytes
  • cs-host
  • cs(User-Agent)
  • cs(Referer)

Java Runtime for Forms​

Jadu Central forms require additional prerequisites to be setup prior to installing. Ensure the Java Runtime Environment (JRE) is installed.

Jadu Central forms uses the JRE to generate PDF files of form submissions.

note

Jadu Central supports both Oracle and OpenJDK JRE versions. Jadu supports Java versions 8, 9 and 10.

The JRE should be callable via the command line, to test run the command in terminal/command prompt:

java -version

You should have output similar to:

openjdk version "1.8.0_282"
OpenJDK Runtime Environment (build 1.8.0_282-b08)
OpenJDK 64-Bit Server VM (build 25.282-b08, mixed mode)

If not, you may need to add Java to your Path variable:

  1. Open the Control Panel, click System and Security, click System, and then click Advanced system settings.
  2. In the System Properties window, select the Advanced tab, and then click Environment Variables.
  3. Select Path under System Variables and click Edit.
  4. Add the path to the Java bin folder. For example C:\Program Files\Java\bin. Click OK.

Enabling ImageMagick​

note

These instructions assume you are using PHP 8.1

To enable the Convert to Tiff Option within the Jadu Central integration with Perceptive Content, you will need to install ImageMagick, its associated PHP Plugin, and Ghostscript.

  1. Install ImageMagick
  2. Install Ghostscript 
    Copy-Item "C:\Program Files\gs\gs10.05.1\bin\gswin64c.exe" -Destination "C:\Program Files\gs\gs10.05.1\bin\gs.exe"
  3. Install the PHP PECL Module imagick 
    $packagePath="C:\Jadu\packages"


    New-Item -ItemType Directory -Path ("{0}/php_imagick" -f $packagePath) -Force


    Expand-Archive -Path ("{0}/php_imagick-3.8.0-8.1-nts-vs16-x64.zip" -f $packagePath) -DestinationPath ("{0}/php_imagick" -f $packagePath)
    • Enable the module in the PHP configuration, (e.g. php.ini), via the extension directive: extension=imagick - e.g. From an Administrator Powershell:
    $phpConfigPath="C:\PHP\php.ini"
    $phpConfigExtensionPatternImagick='^extension=(imagick|php_imagick.dll)$'
    $phpConfigExtensionEntryImagick='extension=imagick'


    If ( ! (Select-String -Path $phpConfigPath -Pattern $phpConfigExtensionPatternImagick)) {
    Add-Content -Path $phpConfigPath -NoNewline -Value ("`n{0}" -f $phpConfigExtensionEntryImagick)
    }
    • Verify the module is loaded by running the following in a new Administrator cmd.exe or Powershell.exe window: php -m
    php -m | Select-String -Pattern "imagick"
  4. IIS Reload
    • To complete the installation, reload the IIS W3SVC service: iisreset /NOFORCE
  5. Verification
    • Check the PHP Info output, available from the Jadu Control Center Maintenance page: https://{your install domain}/jadu/maintenance/phpinfo.php
    • Verify that the imagick module is listed and enabled for the application.

Assuming this is visible, you should now see Convert to tiff option within the relevant forms configuration page.

It is worth after this step ensuring that you setup a Form with PDF output and Tiff conversion enabled to test that the actual Tiff is converting to an acceptable quality (there are some further config adjustments possible if necessary), and is able to be pushed into Perceptive Content successfully.

tip

You're now ready to begin the installation process.