IBM License Metric Tool (ILMT)

IBM License Metric Tool (ILMT)

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Updating certificat from command line

    Posted Tue May 13, 2025 07:08 AM

    Hi!
    This a problem that starts to be a show stopper for ILMT.
    It is more and more common that companies do not allow https certificates that are not CA signed.
    E.g. the self signed certificate created during the ILMT installation.
    The manual describes very well how to create a new certificate and have it signed by an authorized CA.
    But for the last step, Security -> Configuring secure communication with a CA-signed certificate -> Step 3: Enabling secure communication, you must do it in ILMT WebUI.
    You cannot do that if the original self signed certificate is not permitted!

    So in this case I need instructions for:
    1. Obtain the key_store password (as you can in the WebUI)
    2. The keytool command to enable the new CA signed certificate

    Or some other solution that fix this problem.

    //Christer



    ------------------------------
    Christer Borg
    ------------------------------


  • 2.  RE: Updating certificat from command line

    Posted Tue May 13, 2025 11:45 AM

    Hello,


    To find out key_server.p12 password we would require a master.tag file from your local ILMT instance.
    That file presents some confidential data so the best way would be to pass this through Support ticket.


    However, the quick workaround would be to use HTTP protocol to connect to ILMT and replace certificate.
    Due to security concerns one should use a browser located directly on ILMT server, so, the whole http session would be confined to ILMT server itself.
    To enable HTTP protocol please open up the server.xml file and change the httpsPort to httpPort.
    Restart ILMT sever after that.



    ------------------------------
    Thank you,
    Oktawian

    Oktawian Powązka, L3 Support
    IBM License Metric Tool
    ------------------------------



  • 3.  RE: Updating certificat from command line

    Posted Wed May 14, 2025 03:45 AM

    Thanks Oktawian!

    One more question:

    I create and sign my new cert and have the resulting file certificate.arm (as described in the documentation).
    What is the keytool command to replace the current one (using the obtained key_store password)?

    //Christer



    ------------------------------
    Christer Borg
    ------------------------------



  • 4.  RE: Updating certificat from command line
    Best Answer

    Posted Wed May 14, 2025 06:04 AM

    Following should do the job:
    <install_dir>/jre/jre/bin/keytool -importcert -alias default -file certificate.arm -storetype PKCS12 -keystore <install_dir>\wlp\usr\servers\server1\resources\security\key_server.p12 -storepass <xxx>




    ------------------------------
    Thank you,
    Oktawian

    Oktawian Powązka, L3 Support
    IBM License Metric Tool
    ------------------------------



  • 5.  RE: Updating certificat from command line

    Posted Mon May 19, 2025 11:48 AM
    Edited by Christer Borg Mon May 19, 2025 11:49 AM

    Hi!

    I have an update on this issue.

    The customer deleted the original key_server.p12 and created a new one, signed by an authorized CA.
    They then edited server.xml, and changed the password in section  <keyStore ...>
    This seems to work, at least they could go on and do the initial setup, defining Db2 parameters etc.

    My question is if this method is OK, or may there be some implications later?

    //Christer



    ------------------------------
    Christer Borg
    ------------------------------



  • 6.  RE: Updating certificat from command line

    Posted Tue May 20, 2025 02:05 PM

    It's OK,
    I don't see any implications.
    Upgrade process should keep key_server.p12 without alterations.



    ------------------------------
    Thank you,
    Oktawian

    Oktawian Powązka, L3 Support
    IBM License Metric Tool
    ------------------------------



  • 7.  RE: Updating certificat from command line

    Posted Thu May 22, 2025 08:35 AM

    OK!

    FWIW, here how it was done, if any one else is stuck in the same situation:

    A private.key and a csr-file was generated, as described in the documentation (step 1). 

    It was sent to get signed by a authorized CA cert, and a cer-file was returned (step 2).

    Instead of step3, these commands where done:

    1. Remove the old keystore, which we did not have the password to
      cd <install_dir>/wlp/usr/servers/server1/resources/security
      ren key_server.p12 key_server_original.p12

    2. Create a new keystore, with a signed cert and known password:
      cd <dir of new keystore, with signed cert>
      openssl pkcz12 -export -inkey <private.key> -in <signed-cert.cer> -out key_server_new.p12
      <install_dir>/jre/bin/keytool -import \
        -destkeystore <install_dir>/wlp/usr/servers/server1/resources/security/key_server.p12 \
        -srckeystore key_server_new.p12 -srcstoretype PKCS12 \
        -deststoretype PKCS12 -deststorepass <password>

    3. Edit the file <install_dir>/wlp/usr/servers/server1/server.xml.
      Change the password=  in the <keyStore section

    This worked for us.

    If this is an unsupported way of doing it, please tell me.

    Otherwise I think it should go into the manual.

    //Christer

     



    ------------------------------
    Christer Borg
    ------------------------------



  • 8.  RE: Updating certificat from command line

    Posted Fri May 23, 2025 04:09 AM

    Definitely it's a supported way.

    Obviously, there are two ways of addressing that.

    1. creating a new p12 keystore,
    2. importing private key + certificate to existing key_server.p12.

    I'll propose internally documenting that part.



    ------------------------------
    Thank you,
    Oktawian

    Oktawian Powązka, L3 Support
    IBM License Metric Tool
    ------------------------------