OpUtils - System Requirements

    Table of Contents:

    Hardware Requirements

    Hardware Recommended
    Processor Dual Core/Core 2 Duo or Quad Core
    RAM 4 GB
    Disk Space Above 10 GB

    Software Requirements

    These are the minimum requirements to run the system.

    Software 

    Version requirements for Evaluation 

    Version requirements for Production 

     Windows OS

    Windows 10 (or) Windows Server 2012

    Windows Server 2022/ 2019/ 2016/ 2012 R2/ 2012

     Linux OS

    Ubuntu 14 to 22.04/ CentOS 7/ Fedora 37/ Red Hat 7 to 9.4/ Opensuse 15.4/ Debian 10 to 11.6

    Ubuntu 14 to 22.04/ Red Hat version 7 to 9.4/ CentOS Stream 8/ CentOS 7/ CentOS Stream 9

     Browsers

    Chrome/ Firefox/ Edge

    Chrome (preferred)/ Firefox/ Edge

    Client machines: OpUtils uses a client side javascript based MVC architecture and it is preferred to view this from a 64 bit laptop for better viewing experience.

    User privileges: Local administrative privileges required.

     

    Bandwidth Required for OpUtils Scanning

    If all the tools are scanning simultaneously, the approximate bandwidth utilization would be ~150 KBps.

     

    PostgreSQL

    Comes bundled with the product (PostgreSQL version 14.7).

    For Remote PostgreSQL, OpUtils supports PostgreSQL versions 14.7 to 14.x.

     

    Microsoft SQL

    1. Supported versions:

    SQL 2019 (from build 125379) | SQL 2017 | SQL 2016 | SQL 2014

    2. Important Notices:

    1. For production use 64 bit versions of SQL.

    2. Recovery mode should be set to SIMPLE.

    3. SQL and OpUtils should be in the same LAN. Currently WAN based SQL installations are not supported.

    4. Developer edition of SQL Server is not supported.

    3. Collation:

    English with collation setting (SQL_Latin1_General_CP1_CI_AS)

    Norwegian with collation setting (Danish_Norwegian_CI_AS)

    Simplified Chinese with collation setting (Chinese_PRC_CI_AS)

    Japanese with collation setting (Japanese_CI_AS)

    German with collation setting (German_PhoneBook_CI_AS)

    4. Authentication:

    Mixed mode (MSSQL and Windows Authentication).

    5. BCP:

    The "bcp.exe"(Windows)/"bcp"(Linux) and "bcp.rll" must be available in the OpUtils bin directory.

    The BCP utility provided with Microsoft SQL Server is a command line utility that allows you to import and export large amounts of data in and out of SQL server databases quickly.

    For Windows:

    The bcp.exe and bcp.rll will be available in the MSSQL installation directory. If MSSQL is in a remote machine, copy bcp.exe and bcp.rll files and paste them in the <\OpUtils\bin> directory.

    The SQL server version compliant with the SQL Native Client must be installed in the same Server.

    For Linux:

    For BCP utility in Linux, mssql-tools (Microsoft ODBC driver for Linux) should be installed on an OpUtils installed machine. Please follow the steps in the document provided below to install Microsoft ODBC driver on Linux servers.

    https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server

    The command to install ODBC driver is different for every Linux flavor. Please choose the correct Linux flavor and install the ODBC driver.

    • Steps to move BCP utility to OpUtils:
      • After the ODBC driver is installed in Linux servers, the bcp utility files can be found in the below mentioned path. Copy both bcp and bcp.rll files to <OpUtils_home>/bin and start OpUtils once.
        • For ODBC driver version 18: bcp file in /opt/mssql-tools18/bin/ and bcp.rll file in /opt/mssql-tools18/share/resources/en_US/
        • For other versions of ODBC: bcp file in /opt/mssql-tools/bin/ and bcp.rll file in /opt/mssql-tools/share/resources/en_US/

    6. User-role requirement:

    Server roles - "dbcreator", "public" and "sysadmin". User Mapping - Map this login to "master" with database role ownership as "db_owner" and "public".