Skip to main content

Hardware, OS and DBMS Setup

Hardware, OS and DBMS Setup

Slide 1


Configuration Topics

  • POS Hardware
  • Operating Systems
  • DBMS Installation and Configuration

OS and DBMS Options

Operating System

  • Enactor supports Windows and most Linux varieties
  • Enactor recommends Windows 10 for client/store devices

DBMS

  • Enactor supports several JDBC-compliant databases, including MS SQL Server, MySQL, MariaDB
  • Enactor recommends MariaDB 10.3+ for client/store devices

Hardware and OS Setup

Hardware Setup

Usually this comprises:

  • Connecting all required peripherals
  • Testing key hardware components (e.g. touchscreen)

Operating System Setup

Usually comprises:

  • Setting display resolution
  • Setting language, region and date/time
  • Security policies, group memberships etc.
  • Other required applications (e.g. AntiVirus, management agents)
  • POS Application User configuration: often a generic user with local rights to execute and manage the POS application, set for auto-logon
  • POS Service User: for Windows this is usually LocalSystem; must have full rights to the Enactor folder

Database Setup

  • The DBMS should be configured to use a UTF-8 Character Set
  • DBMS memory/cache settings should be optimised based on available memory for the device (recommend between 30 and 50% of memory)
  • The Enactor DB and DB user need to be created once the DBMS is installed. The DB is initially empty - it will be populated by the Enactor application once installed and started
  • DB settings need to be reflected in the application Installer.ini, using the same DB, schema, user etc.

Exercise 3: DBMS Installation

Store Setup - Exercise 3

  1. Connect to your Virtual POS Device
  2. Find the Downloads folder C:\Users\training\Downloads. In this folder you will find: MariaDB installation MSI and Database setup script; Enactor POS Installation MSI; Installer.ini file
  3. Run the MariaDB installer MSI; accept the licence, choose the default features
  4. Set the root password to enactor (lower case)
  5. Enable remote root access
  6. Use UTF-8 character set
  7. Leave instance properties as default
  8. Ignore feedback settings and install
  9. When the installation is complete, run the setupdb.cmd file

Further Reading

For additional information and further reading on Systems Setup, please see the following guides:

DocumentDescription
How to: MariaDB InstallationMariaDB installation and configuration on Windows
How to: MariaDB Setup on Amazon RDSMariaDB provisioning on AWS RDS