Aller au contenu

Installing InteLIS on a Windows Machine

InteLIS was previously called VLSM. The Windows install folder, the site hostname, and the database are still named vlsm, and this guide keeps those names so they match an existing installation.

0. Download

1. Installing WAMP Server

  • Update Windows fully
  • Install the VC Packages. Install all of them on 64-bit, and only the 32-bit packages on a 32-bit system
  • Reboot the machine
  • Launch WampServer and confirm the tray icon is green

2. Configuring PHP and MySQL

2.1 PHP Setup

  • Download cacert.pem from https://curl.se/docs/caextract.html and place it in C:\wamp\ or C:\wamp64\
  • Switch the PHP version to 8.2.13: WampServer > PHP > version > 8.2.13
  • Open php.ini via WampServer > PHP > php.ini and change:
  • memory_limit from 128M to 2G, or higher if the machine allows
  • post_max_size from 8M to 500M
  • upload_max_filesize from 2M to 500M
  • ;openssl.cafile= to openssl.cafile='C:\wamp64\cacert.pem'
  • ;curl.cainfo = to curl.cainfo ='C:\wamp64\cacert.pem'
  • error_reporting to error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED & ~E_WARNING
  • max_execution_time to max_execution_time = 1200
  • Repeat the same edits in C:\wamp64\bin\php\php8.2.13\php.ini

2.2 MySQL Setup

Fix the MySQL mode

  • Open the WampServer icon > MySQL > my.ini
  • Find sql_mode and comment it out with a leading ;
  • Add these lines:
sql_mode =
innodb_strict_mode = 0
  • Find innodb_default_row_format=compact and change it to innodb_default_row_format=dynamic. Add the line if it is missing.
  • Save and close

Change the MySQL password

  • Open the WampServer icon > MySQL > MySQL Console
  • Username: root
  • Password: leave blank and press Enter
  • Run:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
FLUSH PRIVILEGES;
exit;

Final steps

3. Setting up InteLIS

3.1 InteLIS Application Setup

cd C:\wamp64\www\vlsm
set PATH=C:\wamp64\bin\php\php8.2.13;%PATH%
php composer.phar install --no-dev
php composer.phar dump-autoload -o

Database setup

CREATE DATABASE `vlsm` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
  • Import sql/init.sql into the vlsm database

Configuration

  • Rename configs/config.production.dist.php to configs/config.production.php
  • Edit that file and set:
  • STS URL: $systemConfig['remoteURL'] = 'https://STSURL';
  • Module settings, enabled or disabled as needed
  • Database credentials
  • Interfacing database details

Virtual host setup

  • Open C:\windows\system32\drivers\etc\hosts as administrator
  • Add: 127.0.0.1 vlsm
  • Edit C:\wamp64\bin\apache\apache2.4.54.2\conf\extra\httpd-vhosts.conf:
<VirtualHost *:80>
  ServerName localhost
  ServerAlias vlsm
  DocumentRoot "${INSTALL_DIR}/www/vlsm/public"
  <Directory "${INSTALL_DIR}/www/vlsm/public/">
    AddDefaultCharset UTF-8
    Options +Indexes +Includes +FollowSymLinks +MultiViews
    AllowOverride All
    Require local
  </Directory>
</VirtualHost>
  • Restart all WampServer services

Application initialization

  • Run in a command prompt:
cd C:\wamp64\www\vlsm
set PATH=C:\wamp64\bin\php\php8.2.13;%PATH%
php composer.phar post-install
  • Generate the audit triggers. Run this after post-install, because the generator reads the migrated schema:
php bin\setup\regenerate-audit-triggers.php --apply install
  • Open http://vlsm
  • Register the admin user and log in
  • Select instance type "BOTH"
  • Click "Force Remote Sync" and wait for it to finish

System admin setup

  • Open http://vlsm/system-admin
  • Read the secret key from C:\wamp64\www\vlsm\app\system-admin\secretKey.txt
  • Register the system admin user
  • Select instance type "Lab Instance" and choose the lab name
  • Sign out

3.2 Task Scheduler

  • Open Task Scheduler and create a new task named "InteLIS Task"
  • Select "Run whether user is logged on or not"
  • On the Triggers tab, create a trigger:
  • Select Daily
  • Check "Repeat Task Every" and set it to 1 minute indefinitely
  • Check "Stop task if runs longer than". The default of 3 days is fine.
  • On the Actions tab, create an action:
  • Program: C:\wamp64\bin\php\php8.2.13\php.exe
  • Arguments: C:\wamp64\www\vlsm\vendor\bin\crunz schedule:run
  • Enter the Windows user password when prompted

4. Setting up Interfacing

  • Open phpMyAdmin at http://localhost/phpmyadmin
  • Run these statements. Replace interface@12345 with a password you choose, because the value below is published in this guide:
CREATE DATABASE `interfacing` CHARACTER SET utf8mb4
COLLATE utf8mb4_general_ci;

CREATE USER 'interfaceadmin'@'%' IDENTIFIED
WITH mysql_native_password BY 'interface@12345';

GRANT USAGE ON *.* TO 'interfaceadmin'@'%' REQUIRE NONE
WITH MAX_QUERIES_PER_HOUR 0
MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;

GRANT ALL PRIVILEGES ON `interfacing`.* TO 'interfaceadmin'@'%';
  • Import the interfacing database SQL file
  • Download and install the latest Interfacing executable
  • Log in with admin / admin
  • Configure the MySQL details and the instrument interface settings
  • Confirm the connection status before releasing results from instruments