3.0 Configuring the PostgreSQL Database Connection and Credentials

The NetIQ Cloud Manager installation pattern includes an optional postgresql-server package. This package can be installed with Cloud Manager on the local host by default. No matter when it is installed, however, a PostgreSQL ORDBMS is required for Cloud Manager. This product uses a dedicated database in Postgres to store all of its data.

This section helps you to prepare the information you need to configure the Postgres instance you use for Cloud Manager.

  1. Make sure you know the information you are prompted to provide during the Postgres configuration:

    Information Needed for Configuration

    Description

    Database server

    You need to know the Postgres database server hostname or IP address. Unless you chose not to install the postgres package during the install, the Cloud Manager Application Server installs the packages in this pattern on the same server where you installed Cloud Manager.

    The default is localhost.

    Autoconfigure an unconfigured Postgres installation?

    If you install a Postgres ORDBMS intended for Cloud Manager but you have not yet configured it, Cloud Manager can autoconfigure it for your environment. Autoconfigure sets up the Postgres authentication method, changes the default postgres user password, and configures the database for local connections only.

    If you choose to autoconfigure, the tool sets up the environment and exits without displaying a summary of the settings it used. If you want to troubleshoot database problems, you can view the settings.

    Autoconfigure does the following:

    • Generates a Postgres user password and copies it to /etc/opt/netiq/cloudmanager/etc/pgusr.in.

    • Creates a database and names it cloudmanager.

    • Creates a database user and names it cmadmin.

    • Generates a database password for cmadmin and copies it to /etc/opt/netiq/cloudmanager/etc/com.novell.ncm.backend.connpool.cfg

    If you choose not to autoconfigure because your Postgres instance is already configured or because it is remotely located, the tool directs you to supply information for a new database configuration for Cloud Manager.

    IMPORTANT:Running autoconfigure on a Postgres instance that is already configured causes autoconfigure to fail.

    Database server port

    You need to know the port that your Postgres server uses for outside communication.

    The default is 5432.

    NOTE:This documentation does not discuss the configuration for the Postgres server.

    Create a new Postgres database?

    (You can choose to use an existing database instead of creating an new one.)

    If you want to use Cloud Manager with a fresh database, you can choose to create that database. The configuration tool configures that database with data that you supply when prompted:

    • Administrator Name: An administrative user with permission to create a database.

    • Database Administrator Password: The password that the Administrator designated above uses to log in to the database.

    • Database Name: An arbitrary name you specify to identify the database. The default is cloudmanager.

    • Database User Name: A user to be created who must have read/write permissions to the database. The default is cmadmin.

    • Database User Password: The password that the database user (designated above) uses to log in to the database.

    Use an existing Postgres database

    If you want to use an existing Postgres database, that database should not have been used prior for any other purpose. The configuration tool configures that database with authentication data that you supply when prompted:

    • Database Name: An arbitrary name you specify to identify the database. The default is cloudmanager.

    • Database User Name: A user to be created who must have read/write permissions to the database.

    • Database User Password: The password that the database user (designated above) uses to log in to the database.

  2. At the Cloud Manager Application Server, run the Cloud Manager Application configuration tool:

    /opt/netiq/cloudmanager/configurator/config

    The tool displays the first segment of its configuration script:

    Welcome to the NetIQ Cloud Manager configuration utility.
    
    INSTALLATION OPTIONS MENU
    
    Select products to configure
    
     #   selected  Item
     1)     no     NetIQ Cloud Manager - Server
     2)     no     NetIQ Cloud Manager - Manage Authentication
     3)     no     NetIQ Cloud Manager - Manage Certificates
    
    Select from the following:
      1 - 3)  toggle selection status
           a)  all
           n)  none
           f)  finished making selections
           q)  quit -- exit the program
    Selection [f]:
    
  3. Specify 1 to configure the Cloud Manager Application Server, then enter f to finish the selection and move to the PostgreSQL Database Connection segment of the script.

    POSTGRESQL DATABASE CONNECTION
    
    This segment of the configuration utility lets you provide PostgreSQL
    authentication information to be used by NetIQ Cloud Manager (NCM).
    
    If you want to install Postgres to a local database and Postgres has not been 
    configured, you can choose to configure Postgres automatically.
    
    If you choose to install to an existing Postgres server, you need the
    following information:
    
        -  The Postgres server IP Address and the port where the service is running
        -  A username with permission to create the NCM database and user
    
           or
    
           The database name you want to populate, along with a username with write
           permission to that database.
    
    Press <RETURN> to continue...
    
  4. Follow the prompts to complete the Postgres configuration. Use the information you collected in Step 1 as the script prompts you.

The configuration tool checks the database server and the database instance you specify, using the newly-defined credentials to make sure that the database instance and the database user can be created.

Following the Postgres configuration, continue with Section 4.0, Configuring Cloud Manager to Use Authentication Sources to configure the authentication sources you want to use with Cloud Manager.