converting mqsilist output to a csv file

 #!/bin/bash

RESFILE="/home/priyesh.singh/scripts/flow-list/ACE_Flow_Details.csv"

WORKDIR="/home/priyesh.singh/scripts/flow-list"

echo "App-Flow, EG, Status" >> $RESFILE

grep -i ": Application" $WORKDIR/ACE_App_list.txt >> $WORKDIR/ACE-flow-List-Nov-2024.txt

while read templine; do

AppName=`echo $templine | cut -d":" -f2 | cut -d"'" -f2`

EGName=`echo $templine | cut -d":" -f2 | cut -d"'" -f4`

Status=`echo $templine | cut -d" " -f9 | cut -d"." -f1`

echo "$AppName, $EGName, $Status" >>$RESFILE

done < $WORKDIR/ACE-flow-List-Nov-2024.txt

#rm $WORKDIR/ACE_App_list.txt

#rm $WORKDIR/ACE_AppTemp_list.txt

Importing a pfx/p12 certificate into jks/keystore

 

Problem Statement:

User has a certificate in pfx format (p12), which he needs to import in java keystore for IBM ACE/IIB.

Requirement:

1. Make sure to have an alias for the certificate in the pfx file, by default the alias will be - 1.

so what alias user wants to keep in the java keystore for the certificate, he should change the existing alias (1) to that one first before import - 

use below command to change the alias of the certificate in the pfx file

keytool -changealias -alias "1" -destalias "New-Alias" -keystore "D:\username\certificate.pfx"

2. As every pfx or p12 file will be password protected, and so the keystore too.

but they both should have same password to work properly, and the java keystore password should be preserved as that only be used by ACE/IIB.

So, user should change the password before importing the certificate or can be done after import as well.

use below command to import the certificate    the pfx file -

keytool -importkeystore -srckeystore certificate.pfx -destkeystore ACENode.jks -srcstoretype pkcs12 -alias New-Alias

now use below command to change the password of the pfx file in the keystore -

keytool -keypasswd -alias New-Alias -keystore ACENode.jks