7 Set up Delivery of Reports Using E-mail

This chapter contains these topics:

A set up is required to ensure the successful delivery of reports through e-mail. Appropriate IBM i authority is required to set up e-mail availability.

7.1 Step 1 - Verify User ID is set up on the IBM i

  1. From the IBM i command line, type the following command:

    WRKDIRE USER (Web Enablement User ID)

    Where Web Enablement User ID is the User ID of the user you wish to set up on IBM i e-mail.

  2. Press Enter.

    If the following error message displays:

    User not enrolled in system distribution directory.

    Proceed to Step 2 - Set up E-mail Messages from the IBM i.

    If no error message displays, then proceed to Step 3 - Set up the "From" Address for E-mail Messages.

7.2 Step 2 - Set up E-mail Messages from the IBM i

  1. Create authority for the Web Enablement User ID on the IBM i. From the IBM i command line, type the following commands:

    ADDDIRE USRID(E-mail User ID My_IBM i) USRD('User Name') USER(User ID)

    Where My_IBM i is the IBM i machine name and E-Mail User ID is the new E-mail directory User ID and User ID is the Web Enablement User ID.

  2. Execute the following two statements, once, on the IBM i:

    ADDDIRE USRID(INTERNET GATEWAY) USRD('Allow OS/400 to send INTERNET Mail') SYSNAME(INTERNET) MSFSRVLVL(*USRIDX) PREFADR(NETUSRID *IBM ATCONTXT)

    CHGDSTA SMTPRTE(INTERNET GATEWAY)

7.3 Step 3 - Set up the "From" Address for E-mail Messages

The following steps set up the "From" address for e-mail messages sent from Web Enablement. Ensure the "From" address is set to a valid address that gets through the firewall issues when sending e-mail message to outbound source.

  1. If a User ID existed from the verification above, proceed to Step 4 - Finish set up to continue with setup. Otherwise, on the IBM i command line, type the following command:

    WRKDIRE USRID (E-mail User ID My_IBM i)

    Where My_IBM i is the IBM i machine name and E-mail User ID is the new E-mail directory User ID.

  2. Press Enter.

  3. Type 2 on the line that has the user profile set up for Web Enablement. Press Enter.

    Figure 7-1 Add Name for SMTP

    Description of Figure 7-1 follows
    Description of "Figure 7-1 Add Name for SMTP"

  4. Press F19 and then press Enter.

  5. Complete the following fields with the respective portions of the e-mail address.

    • SMTP User ID…………..John_Doe

    • SMTP Domain………….companyname.com

    Example of From e-mail address:

    John_Doe@companyname.com

  6. Press Enter until return to main menu.

7.4 Step 4 - Finish Set up

  1. If you have a firewall and/or a mail proxy, type the following on the OS/400 command line:

    CHGSMTPA MAILROUTER(MAIL.ROUTER.NAME) FIREWALL(*YES)

  2. Ensure that MAIL.ROUTER.NAME is in the AS/400 Host Table (CFGTCP, Option 10) or can be resolved via your Name Server (DNS).

    After all configurations are complete, proceed to step 3 below.

  3. From the IBM i command line, type the following:

    ENDTCPSVR *SMTP

    Press Enter.

  4. From the IBM i command line, type the following:

    ENDMSF

    Press Enter.

  5. On the IBM i command line, type the following:

    STRTCPSVR *SMTP

    Press Enter.

  6. On the IBM i command line, type the following:

    STRMSF

    Press Enter.

  7. On the IBM i command line, type the following:

    WRKACTJOB SBS(QSYSWRK)

    Press Enter.

  8. Verify the following results:

    • 3 jobs named QMSF running

    • A job named QTSMTPBRCL running

    • A job named QTSMTPBRSR running

    • A job named QTSMTPCLNT running

    • A job named QTSMTPSRVR running

    Note:

    If e-mail does not work after following the above instructions above, you can do some preliminary troubleshooting by looking at the job logs for QMSF and for QTSMTPBRSR, QTSMTPBRCL, QTSMTPCLNT, and QTSMTPSRVR. If any of these jobs is not running, check the job logs.

    Most error messages found in those logs have a workable recovery procedure or lead to a PTF.

  9. Create a folder on the IBM i. Type in the following command on the IBM i:

    CRTFLR FLR(My_Folder) TEXT('Folder_Description')

    Where My_Folder is the IBM i IFS Folder Name and Folder_Description is the description of the folder.

    To return to the User Options menu, press Enter.

  10. To grant authority for your folder, type the following on a command line on the IBM i:

    WRKFLR My_Folder

    Option 14 for authority change Public to *ALL.

  11. Verify the appropriate text file entry is set accordingly on the WV93.LWM and DYNBLD93.LWM.

    Use a text editor tool such as MS Notepad or MS WordPad to open the WV93.LWM and DYNBLD93.LWM files.

    The following are example paths for location of WV93.LWM and DYNBLD93.LWM.

    For IBM i Installation:

    • Your IBM i root folder /LEGASUITE/A93App/

    For Windows NT-2000-2003 Server and LegaSuite Client for Windows Installations:

    • C:\Inetpub\wwwroot\JWALKAPP\A93APP\

      WV93.LWM and DYNBLD93.LWM Text File Entry Updates:

    • SNDDSTFLR set to name of My_Folder