Create ACL - Intergraph Smart Materials - Version 2020 (10.0) - Installation & Upgrade - Hexagon

Intergraph Smart Materials Installation (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
2020 (10.0)

Before the database can access the license webservice, it is required to enter the hostname of the license webservice in the access control list (ACL). Maintaining the ACL is a DBA task. You can create an ACL for the licensing or you can use an existing one. To create an ACL, do the following:

  1. Open a Command Prompt window.

  2. Launch a SQL*Plus session.

  3. Connect as M_SYS.

  4. Perform this command to create the access control list:

    Exec DBMS_NETWORK_ACL_ADMIN.create_acl ('SBCS.xml','Access control list for the session-based-check-SmartLicensing','M_SYS',TRUE,'connect',NULL,NULL);

    with these parameters:

    acl

    'SBCS.xml'

    description

    'Access control list for the session-based-check-SmartLicensing'

    principal

    'M_SYS'

    is_grant

    TRUE

    privilege

    'connect'

    start_date

    NULL

    end_date

    NULL

  5. Once the ACL got created, you can assign all hostnames you want to allow. Assume your license webservice uses the following URL:

    myWebService/SmartMaterialsLicenseWebservice2020/SmartLicensingService/service/home

    The first token one is the hostname. With this token, you would perform the following command:

    exec DBMS_NETWORK_ACL_ADMIN.assign_acl ('SBCS.xml','myWebservice',NULL,NULL);

    with these parameters:

    acl

    'SBCS.xml'

    host

    'myWebservice'

    lower_port

    NULL

    upper_port

    NULL

    This enables the database to contact the remote node. If you need to include the domain name in the URL, you also need to include it in the assign_acl command. If you want to go by IP-address, assign the IP address.

    • The license webservice needs to be available while Smart Materials or Smart Reference Data products are in use. Otherwise it will result in database sessions being outdated and terminated by the application.

    • Do not restart the license webservice while users are working in Smart Materials or Smart Reference Data applications. The service will be initialized again in this case. Previously connected sessions will not be able to refresh and will disconnect from the database after some timeout period.

      Hence, whenever you plan to make the license webservice unavailable after it started being used, first make sure that all currently connected Smart Materials or Smart Reference Data users are logged off, to avoid that seats cannot be returned cleanly to the license pool.

    • Also make sure, that virus-scan or backup actions do not touch file attributes in LicenseService folder, because this could make the application recycle so that licenses could get hanged in ISL.

  6. To check which ACL file is currently saved in the database, use this command:

    select * from dba_network_acls;