Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

The data edit tool is a Microsoft Access application that allows an administrator to directly edit distribution information.

It connects to the associated production instance as root, so it provides nearly unrestricted to the instance and is therefore very insecure and dangerous.

The main steps to configure the data edit tool for a specific PC are:

  1. Download and configure PuTTY (provides SSL connection to AWS instance).
  2. Create ODBC connection to postgres
  3. Install the data edit tool and run it using Access.

Configure Putty

Download PuTTY from http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

Run PuTTY and configure per below.  Notice that the highlighted category is a very light grey.

Configure Session

The username for dedicated AWS instances is root and it is ec2-user for instances running on docker.

Examples: ec2-user@benin-training.openlmis.org or root@selv.villagereach.org

Session Configuration - SELV

All the remaining editing is in the the connection category.

Configure SSH Category

Note that all the options below are defaults.  I'm including it in here in case they change.

Configure Auth Category

Here you most specify where the key file is used for security:

 

Configure Tunnels Category

Postgres uses port 5432, so the source port is 9738 (this port will be used when configuring the ODBC connection later) and the destination port is localhost:5432.

Make sure to save this configuration so you can load it later.

Configure ODBC Connection

The Access Application is configured to use a DSN named SELV32.  So, we need to create that DSN using a postgres driver and the port we just created.

  1. Control->Panel search for ODBC and choose "Set up ODBC data sources (32-bit)"
  2. Select the SystemDSN tab and choose Add...
  3. Select the PostgreSQL Unicode driver
  4. Enter the following
    1. Data Source: SELV32
    2. Database: open_lmis
    3. Server: localhost
    4. User Name: postgres
    5. SSL Mode: prefer
    6. Port: 9738 (the port we entered into PuTTY)
    7. Password: p@ssw0rd
    8. Save

Your ODBC connection is now setup.

Run SELVeditor

The actual SELVeditor tool is an Access Database configured to connect to the open_lmis database and manipulate the data collection tables.  You only have to configure everyone once, so running it is simpler.

  1. Run PuTTY
    1. Select the correct configuration that you saved above
    2. Select Load
    3. Select Open
    4. The following window will open and you can just minimize it.  It's important to NOT do anything in the window.
  2. Load the Access Database - SELVeditor
    1. The system will remind you to run PuTTY.  Click the initialize button.

You can now use the Data Edit tool to change distribution data.  Note, that information is changed immediately in the production database with no record of the change.  Be very careful with this tool.

 

 

 

 

 

  • No labels