Collecting MustGather data for access control issues

Prepare the following MustGather information before you call HCL Support to help with access control issues.

Procedure

  1. Configure the following trace strings.
    • In the Transaction server Docker container
      com.ibm.websphere.commerce.WC_SERVER=all:com.ibm.websphere.commerce.WC_USER=all:com.ibm.websphere.commerce.WC_ACCESSCONTROL=all
      For information about how to set trace strings, see Configuring logging for the Transaction server.
    • In the Store server Docker container
      com.ibm.commerce.component.helper.*=all:com.ibm.commerce.component.registry.*=all:com.ibm.commerce.foundation.logging.*=all
      For information about how to set trace strings, see Configuring logging for the Store server.
  2. Reproduce the problem.

    Record the specific steps that you used to reproduce the problem and any details that might be relevant.

  3. Collect the following files.
    • From the Transaction server Docker container.
      • /opt/WebSphere/AppServer/profiles/default/logs/server1/SystemOut*.log
      • /opt/WebSphere/AppServer/profiles/default/logs/server1/SystemErr*.log
      • /opt/WebSphere/AppServer/profiles/default/logs/server1/trace*.log
    • From the Store server Docker container.
      • /opt/WebSphere/Liberty/usr/servers/default/logs/SystemOut*.log
      • /opt/WebSphere/Liberty/usr/servers/default/logs/SystemErr*.log
      • /opt/WebSphere/Liberty/usr/servers/default/logs/trace*.log
  4. Run the following database queries to collect the necessary information from your database (output results in CSV format).
    SELECT * FROM SITE > SITE.csv
    select * from ACPOLICY > ACPOLICY.csv
    select * from ACRESCGRY > ACRESCGRY.csv
    select * from ACRESGRP > ACRESGRP.csv
    select * from ACRESGPRES > ACRESGPRES.csv
    select * from ACACTION >   ACACTION.csv
    select * from ACACTGRP >   ACACTGRP.csv
    select * from ACACTACTGP > ACACTACTGP.csv
    select * from ACPOLGRP >   ACPOLGRP.csv
    select * from ACPLGPSUBS > ACPLGPSUBS.csv
    select * from ACPOLGPPOL > ACPOLGPPOL.csv
    select * from ORGENTITY > ORGENTITY.csv