Preparing the Lawson Environment

How to:

Preparing the Lawson environment involves extracting security information from Lawson, copying that information from flat files to the server, and refreshing the security extracts.

Important: Automatic Passthru must be disabled against Lawson data. To set Automatic Passthru off, enter the following command in the server profile, edasprof.prf:

SET APT = OFF


Top of page

x
Procedure: How to Extract the Lawson Security Information

Perform the following steps on the machine where Lawson is running:

  1. On the Lawson System, create the ibi_officer user ID, or any user ID with Security Officer capabilities. (This ID must be allowed to run the Lawson RNGDBDUMP command.)
  2. Copy lawsdmp.sh and lawsdmpu.sh from the bin directory and lawsfil.dat from the etc directory of EDAHOME into the home directory of the ibi_officer.

    EDAHOME is the location of the files that run your server. The following table shows the default locations for EDAHOME.

    Operating system

    EDAHOME default directory location and name

    Windows

    \ibi\srv77\home

    UNIX

    /home/iadmin/ibi/srv77/home

    IBM i (formerly known as i5/OS)

    /home/iadmin/ibi/srv77/home

  3. Change the execute attribute of lawsdmp.sh and of lawsdmpu.sh to On.
  4. Schedule or run either lawsdmp.sh or lawsdmpu.sh to extract the latest changes to the Lawson Security System:
    • Use lawsdmp.sh for initial setup and when you wish to refresh all files. (This script extracts all necessary security information.)
    • Use lawsdmpu.sh when you wish to refresh only the user information file.


x
Procedure: How to Copy the Lawson Security Information Flat Files to the Server
  1. Copy the lawsftp.dat file from the etc directory in EDAHOME to the lawsec app directory.
  2. Edit lawsftp.dat to indicate the host name, user ID, and password of the remote machine that contains the extracts derived from running the lawsdmp.sh script.
  3. If the server with the Adapter for Lawson is on the same machine as the Lawson System, copy the extracted files, *.ftm and *.cvs files, from the lawsdmp run home directory of ibi_officer to the Lawson Security Directory (the lawsec directory in APPROOT) of the server.

    If the server with the Adapter for Lawson is not on the same machine, run ftp with lawsftp.dat as input to ftp the extracted files to the Lawson Security Directory (the lawsec directory in APPROOT), as follows:

    ftp -niv < lawsftp.dat

Top of page

x
Procedure: How to Refresh Security Extracts
  1. If you have not already done so, start the server and the Web Console and/or Data Management Console (DMC).
  2. Right-click the configured adapter on the Adapters navigation pane and choose Refresh Security Extracts from the menu.

This process creates the LAW* FOCUS files needed by the Adapter for Lawson to apply the necessary filtering to queries against the Lawson database files.


iWay Software