Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
    • Getting started
    • Introduction video
      Welcome to Accure Project Management System
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.

    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support

    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?
      Create a new account

Side Menu

  • Overview
  • Documents
  • Impulse DW
    Impulse DW
  • Inset BI
    Inset BI
  • Momentum User Guide
    Momentum User Guide
  • Wiki
    Wiki

Content

You are here:
  1. Impulse DW
  2. 3. Security, Roles and Privilege Management
  3. 3.2 Securing Backend SQL Engine

3.2 Securing Backend SQL Engine

  • More
    • Print
    • Table of contents

The Impulse SQL engine uses a default system user and password. This user is the default admin user and can perform all SQL related activities on all tables within the system. Therefore, this user must be kept secured and protected. You must change the default username and password after the first logon to the system. 

You must change the default impulse user and password for the security reason.

You must be an admin to perform the following steps:

  1. Click System Config from the main navigation menu
  2. As shown in Figure 3.2a below, locate the following fields and provide secured username and password. For security reason, both the user and password are never displayed. Make sure you key-in the username and password correctly.
    1. IMPULSE_DB_SYS_USER: a default admin user (do not use admin or sysadmin)
    2. IMPULSE_DB_SYS_PASS: enter a complex password that can not be gassed or be a victim of random attack.
    3. Save the config
    4. In the next page, restart the web server.
  3. After the web console is reloaded (after the restart), stop and start the backend services. 
    1. Click System Services and stop the following services one by one:
      1. impulse-http
      2. impulse-master
      3. impulse-worker
    2. Start the above three services one by one

Your new username and password will apply to the backend SQL engine.

Figure 3.2a: Screen showing a portion of the system config form, indicating system user and password fields.

Loading...