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 
      com.ibm.commerce.foundation.logging.ServiceLogger=all: com.ibm.websphere.commerce.WC_ACCESSCONTROL=all:com.ibm.commerce.foundation.rest.handlers.*=all
      For information about how to set trace strings, see Configuring logging for the.
    • In the 
      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.
  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 .
      • /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 .
      • /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