WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  WAS 9 - user registry from DB

    Posted 03/06/23 03:08 PM

    Hi!

    Does anyone of you know if in websphere 9, I can use a database as a user repository? Do you have any examples of how I can do this. I would be very grateful for your help.



    ------------------------------
    Łukasz Piotrowski
    ------------------------------


  • 2.  RE: WAS 9 - user registry from DB

    Posted 03/06/23 04:15 PM
      |   view attached

    Hi,

    As of my knowledge you must implement the custom registry implementation(requires some development), please check : 






  • 3.  RE: WAS 9 - user registry from DB

    Posted 03/06/23 04:35 PM

    Yes, I've seen those articles. But do I have to create a class to handle such a user register myself or is it already provided by IBM?



    ------------------------------
    Łukasz Piotrowski
    ------------------------------

    Original Message


  • 4.  RE: WAS 9 - user registry from DB

    Posted 03/06/23 04:38 PM
      |   view attached
    Hi,

    There is an old example with the code here :

    Hope it helps.





    Original Message


  • 5.  RE: WAS 9 - user registry from DB

    Posted 03/06/23 04:54 PM

    Thanks! But do I understand correctly, according to this example, I can integrate with a custom registry of users that are in the file, right? And is it possible to somehow use a DB2 database instead of a file?



    ------------------------------
    Łukasz Piotrowski
    ------------------------------

    Original Message


  • 6.  RE: WAS 9 - user registry from DB

    Posted 03/06/23 04:56 PM
    Hi,

    Exactly you just have to adjust the java code to retrieve the credentials from the DB2 database.

    Good luck

    Best regards, 
    --------------------------------------------------------------
    Walid Largou
    Solution Architect / Service Delivery Manager
    Mobile : +212 621 31 98 71
    Email : l.walid@powerm.ma
    320 Bd Zertouni 6th Floor, Casablanca, Morocco
    --------------------------------------------------------------
    https://www.powerm.ma
    Power Maroc #1 IBM Business Partner – Power Maroc
    This message is confidential .Its contents do not constitute a commitment by Power Maroc S.A.R.L except where provided for in a written agreement between you and Power Maroc S.A.R.L. Any authorized disclosure, use or dissemination, either whole or partial, is prohibited. If you are not the intended recipient of the message, please notify the sender immediately.



    Original Message


  • 7.  RE: WAS 9 - user registry from DB

    Posted 03/07/23 03:23 AM

    In addition to the customer user registry as suggested by @Largou walid you could also check if using federated repositor with the database registry migh be working for your use case?

    Please see:

    https://www.ibm.com/docs/en/was-nd/8.5.5?topic=configuration-federated-repositories

    https://www.ibm.com/docs/en/was-nd/8.5.5?topic=cperifrc-setting-up-entry-mapping-repository-property-extension-repository-custom-registry-database-repository-using-wsadmin-commands

    https://www.ibm.com/docs/en/was/8.5.5?topic=scripting-idmgrdbsetup-command-group-admintask-object#rxml_atidmgrDBSetup__setupIdMgrDBTables

    Have to admit - I never used that but maybe that's another option worth to investigate.

    Hope that helps, 



    ------------------------------
    Hermann Huebler
    2innovate IT Consulting GmbH
    Vienna
    Austria

    #IBMChampion
    ------------------------------

    Original Message


  • 8.  RE: WAS 9 - user registry from DB

    Posted 03/07/23 11:46 AM

    Hi Lukasz. Yes - you can use a DB as a user repository. It is supported out of the box. However; you must configure it using wsadmin scripting.

    You can follow the steps at the link below to setup a database repository. Note that it also tells you how to setup a property extension repository and an entry mapping repository. You want to setup a database repository / registry, so be aware as you go through the steps.

    I hope this helps.



    ------------------------------
    JESSE VAN HILL
    ------------------------------



  • 9.  RE: WAS 9 - user registry from DB

    Posted 03/09/23 02:27 PM

    Thanks @JESSE VAN HILL !

    Please tell me if this configuration is enough? Do I need to write some custom VMM i java for this?



    ------------------------------
    Łukasz Piotrowski
    ------------------------------

    Original Message


  • 10.  RE: WAS 9 - user registry from DB

    Posted 03/09/23 02:54 PM

    Łukasz -

    There is no need to write any code. The configuration steps include the setup of the datasource, setup of all the tables in your database according to WIM's schema, and the configuration of the builtin database user repository.



    ------------------------------
    JESSE VAN HILL
    ------------------------------

    Original Message


Related Content