Setting up VLSM on a Windows Machine

run the SQL commands from this link https://github.com/deforay/vlsm/blob/master/sql/audit-triggers.sql
• Rename the file configs/config.production.dist.php to configs/config.production.php
• Enter Database User, Password, DB Name etc.

// VLSTS URL
$systemConfig['remoteURL'] = 'https://STSURL';


// Enable/Disable Modules
// true => Enabled
// false => Disabled
$systemConfig['modules']['vl'] = false;
$systemConfig['modules']['eid'] = true;
$systemConfig['modules']['covid19'] = false;
$systemConfig['modules']['hepatitis'] = false;
$systemConfig['modules']['tb'] = false;

// Database Settings
$systemConfig['database']['host']       = 'localhost';
$systemConfig['database']['username']   = 'root';
$systemConfig['database']['password']   = 'PASSWORD';
$systemConfig['database']['db']         = 'vlsm';
$systemConfig['database']['port']       = 3306;
$systemConfig['database']['charset']    = 'utf8mb4';

.
.
.
.
.


// Enable/Disable Interfacing
// true => Enabled
// false => Disabled
$systemConfig['interfacing']['enabled'] = true;

// Interfacing Database Details (not needed if above feature set to false)
$systemConfig['interfacing']['database']['host'] = 'localhost';
$systemConfig['interfacing']['database']['username'] = 'root';
$systemConfig['interfacing']['database']['password'] = 'PASSWORD';
$systemConfig['interfacing']['database']['db'] = 'interfacing';
$systemConfig['interfacing']['database']['port'] = 3306;
$systemConfig['interfacing']['database']['charset'] = 'utf8mb4';

• Next step is creating a virtual host pointing to the vlsm application

  • Start notepad or notepad++ as admin user (go to start menu, search for notepad and right click and click on Run as administrator)

  • open this file C:\windows\system32\drivers\etc\hosts

  • Add this line at the bottom 127.0.0.1 vlsm and save & close the file

  • Next open C:\wamp\bin\apache\apache2.4.54.2\conf\extra\httpd-vhosts.conf

  • change the existing vhost to the following:

    <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>
    

  • Save & Close this file

  • Click on WampServer icon and Restart all services

• Now go the command prompt and type these commands:

  cd C:\wamp64\www\vlsm
  
  set PATH=C:\wamp64\bin\php\php8.2.13;%PATH%
  
  php composer.phar post-install
  

• Now open http://vlsm

  • Register a new Admin user and Login
  • Fill the instance details in the popup. Select BOTH for type of Instance
  • Now scroll to the bottom and click on Force Remote Sync. Please wait for the sync to finish.

• Once sync is finished go to http://vlsm/system-admin

  • Secret Key can be found in C:\wamp64\www\vlsm\app\system-admin\secretKey.txt
  • Register new System Admin and Login
  • Select Instance Type as 'Lab Instance' and then select the Lab name from dropdown and click on Submit. (Ignore SMTP settings)
  • You can sign out

• Users can now start using vlsm from http://vlsm URL

3.2 Task Scheduler

• Run Task Scheduler. Click on "Create Task"
• Name : VLSM TASK
• Select "Run whether user is logged on or not"
• Now Go to the ‘Triggers’ tab which is next to the ‘General’ tab. And Click on the ‘New’ button.
• Select 'Daily'
• Check "Repeat Task Every" and make it as "1 minutes" and choose for a duration of "Indefnitely"
• Check the checkbox ‘Stop the task if it runs longer than’. It is optional. If the script goes in an indefinite loop or a similar situation due to any reason, the task will be terminated automatically after the day/time defined in this option. By default the value is ‘3 days’. Leave the default value.
• Click OK
• Click on the ‘Actions’ tab and click on the ‘New’ button inside it.
• in the Program/Script find the php exe file for eg. C:\wamp\bin\php\php8.2.13\php.exe or C:\wamp64\bin\php\php8.2.13\php.exe
• in Add Arguments type C:\wamp\www\vlsm\vendor\bin\crunz schedule:run or C:\wamp64\www\vlsm\vendor\bin\crunz schedule:run
• Click on OK
• When prompted for password, please enter the Windows user password (might be cphd123, but check with lab first)

4. Setting up Interfacing

• Start phpmyadmin by typing http://localhost/phpmyadmin in browser (login id is root and password is mko)(*&^)

• Click on SQL menu on top and type the following lines

  CREATE DATABASE `interfacing` CHARACTER SET utf8mb4
  COLLATE utf8mb4_general_ci;
  
  CREATE USER 'interfaceadmin'@'%' IDENTIFIED
  WITH mysql_native_password AS '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'@'%';
  

• This will create a blank interfacing database. Now click on interfacing on left and import the sql file

• Download the latest Interfacing executable

• Install the executable and login with the credentials admin and admin

• On the settings screen, please enter the correct MySQL details and Instrument Interface details

• Ensure that the interface shows connected before releasing results from the machine