IBM Verify

 View Only

  • 1.  Missing database "hvdb"

    Posted Mon July 26, 2021 07:42 AM
    Reply

    Hello everyone,

    I am trying to setup IdP with ISAM 9.0.7.1_IF4 using script from this link

    GitHub - jonpharry/isamdocker: Resources for deploying IBM Security Access Manager on Docker. 
    and this federation cookbook https://community.ibm.com/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=75e1aea2-96dc-96f1-4bf9-92c32f3dd048&forceDialog=0.

    The SP uses WebSphere Liberty. I encounter an error on the docker of isam-aac. 

    [7/25/21 15:40:52:051 SGT] 00000077 com.tivoli.am.fim.distributed.jdbc.JDBCCleanupThread I java.lang.RuntimeException: Cannot get a good connection from the database.
at com.tivoli.am.fim.utils.sql.DataSourceWithRetry.getConnection(DataSourceWithRetry.java:166)
at com.tivoli.am.fim.distributed.jdbc.JDBCDAOFactory.getTransaction(JDBCDAOFactory.java:76)
at com.tivoli.am.fim.distributed.jdbc.JDBCDBHelper.<init>(JDBCDBHelper.java:64)
at com.tivoli.am.fim.distributed.jdbc.JDBCCleanupThread.cleanUp(JDBCCleanupThread.java:77)
at com.tivoli.am.fim.distributed.jdbc.JDBCCleanupThread.run(JDBCCleanupThread.java:65)
Caused by: java.sql.SQLException: FATAL: database "hvdb" does not exist DSRA0010E: SQL State = 3D000, Error Code = 0
at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:572)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:177)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)


    Can someone advice which step that I miss out and how to create this database?

    Thanks



    ------------------------------
    Agustino Alim
    ------------------------------


  • 2.  RE: Missing database "hvdb"

    Posted Mon July 26, 2021 09:11 AM
    Reply
    Hi Agustino,

    When running under Docker, the "HVDB" or "Runtime database" must be configured using the LMI before you can configure anything in either AAC or Federation modules.  For testing, an as-is PostgreSQL image is provided that you can use as this runtime database.  The ISAM Docker assets that you refer to will create this database (and associated private keys) and the ISAM on Docker cookbook explains how to configure the connection.  Check section 6 of this document: https://ibm.biz/isamdockercookbook.

    These steps are NOT covered in the federation cookbook because it is written for the Virtual Appliance.

    Jon.

    P.S. You are running with ISAM v9.0.7.1 but the latest version of this product is Verify Access v10.0.2.0.  If you are starting a new project/build I would use this latest version.  Equivalent docker assets are at https://github.com/iamexploring/container-deployment.  There's a link to a similar cookbook from this page too.

    ------------------------------
    Jon Harry
    Consulting IT Security Specialist
    IBM
    ------------------------------

    Original Message


Related Content