Collecting MustGather data for access control issues

Prepare the following MustGather information before you call IBM 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 Configure 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 Configure logging for the Store server.

2. Reproduce the problem.

   Record the specific steps that we 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 the 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