Setting up Monaco SQL Editor On-Prem

A guide explaining how to configure Monaco SQL Editor Locally for an On-Prem Instance of Halo In this guide we will cover: – Why you may need to configure this locally – How to configure this locally – Troubleshooting Why you may need to configure this locally Depending on your On-Prem setup your webapp server […]

Enabling Reference Tokens

Enabling reference tokens in the Halo API allows sessions and tokens to be stored in the database. Each API call will check the token is still valid in the database. Enable Reference Tokens in the Halo API and Auth server by setting  "UseReferenceTokens": true Inside both the API and Auth appsettings.json. Activating this will invalidate […]

Multiple New Portals with different branding for one customer [On-Prem]

This outlines how to set up one customer to have multiple new web portals with different branding on each for On-Prem Customers Copy the \WebApp\portal\ directory into a new directory in the \WebApp\ folder. E.g. \WebApp\portal2 Copy the appsettings.json file from the \Web App\ directory into the new directory, if it does not already exist. This […]

Password hashing work factor

The work factor is the amount of iterations of the hashing algorithm that are performed for each password. The higher the number the more computationally expensive the hash calculation becomes, which reduces the speed and/or increases the cost for would be attackers. The amount of iterations needs to strike a balance between performance and security. […]

Accessing your On-Prem Logs

This guide details how you can find your On-Prem Halo instance logs to help with troubleshooting an issue. You may be asked to provide these if you host Halo yourself, On-Prem. The logs for your API and Auth server are stored by default in the root directory of your IIS site, under the corresponding folders. […]

Providing your On-Prem Halo DB for Debugging

This guide details how you can provide a backup of your On-Prem Halo database (DB) to the Halo development team for debugging purposes. Please only do this if requested by our development team. To begin, you will need to follow the steps outlined in this guide: https://support.haloservicedesk.com/kb?id=1706 and then provide us with the public key […]

On-Prem – Pre-requisites

Prerequisites To use Halo in the most performant manner, we recommend deploying two separate servers. These should be scaled up accordingly based on agent needs. These servers will be utilised for IIS Halo Application Hosting and SQL Server Database Hosting.  Each server should have at least the below minimum specifications: Platform: 32-bit (x86) or 64-bit […]

Checking your DB Size

This guide details how you can check your On-Premise Halo database size. Please run the below query directly on your Halo database: SELECT s.name AS SchemaName, t.name AS TableName, SUM(p.rows) AS RowCounts, — Total space in MB and GB CAST(SUM(a.total_pages) * 8.0 / 1024 AS DECIMAL(10,2)) AS TotalSpaceMB, CAST(SUM(a.total_pages) * 8.0 / (1024 * 1024) […]

On-Prem Instance to Instance Refresh

The guide will detail how you can refresh your Halo On-Prem instance with that of another On-Prem instance, such as a production instance to a UAT / Dev instance. Throughout this guide I will reference the two instances as below: Source: The instance you are copying from Destination: The instance you are copying to Information […]

Restoring a DB Backup

This guide will show you how to restore a database backup. This guide only applies if you are running Halo yourself, On-Prem. Warning You must ensure that the database backup is using a database version the same as or older than your Halo app version. You can find the database version using the below command: […]