Using VMware Vcenter Import with the Vcenter Appliance

Version 4

    Verified Product Versions

    LANDESK Management Suite 9.5

    Problem:

     

    As an alternative to installing vCenter Server on a Windows machine, you can download the VMware vCenter Server Appliance. The vCenter Server Appliance is a preconfigured Linux-based virtual machine optimized for running vCenter Server and associated services. The current VMware Vcenter Import rules give the choice between SQL or Oracle import. However, the appliance comes pre-configured with a PostgreSQL database which is currently not supported by DTS.

     

     

    Workaround:

     

    To still be able to import VMware Vcenter data into the LANDesk Inventory Database follow these steps:

     

    Step 1- SSH into your VCSA and in the following configuration file /storage/db/vpostgres/pg_hba.conf you will need to add the network in which you will be connecting from, for example:

    host    all             all             172.30.0.0/24           trust

     

    Step 2 - SSH into your VCSA and in the following configuration file /storage/db/vpostgres/postgresql.conf you will need to add the IP Address(s) that you want vPostgres to listen for remote connection. If you use "*", it will allow all addresses, for example:

    listen_addresses = '*'

     

    Step 3 - For the changes to go into effect, you will need to restart the vPostgres DB by SSH-ing into your VCSA and running the following command:

    service vmware-vpostgres restart

     

    Step 4 - Download the latest ODBC driver for PostgreSQL (32-bit!) and install this on the LANDesk Core Server.

     

     

     

    Step 5 - Create a DSN by opening the 32-bit Data Sources (ODBC). To do so:

                   - Run c:\windows\sysWOW64\odbcad32.exe

                   - Select Add at User DSN

                   - Select the Unicode PostgreSQL Driver

                   - Enter the following values

                        Data Source: PostgreSQL35W

                        Database: VCDB (default)

                        Server: (Server name of your appliance)

                        UserName: vc (default)

                        SSL Mode: disable

                        Port: 5432

                        Password: xxxxx

                        Description: optional

                   - Click Test to see if your connection-settings are good; If not, re-check Step 1 to 5.

     

    Step 6 - Enter the LANDesk Console and open Data Analytics Data Translation Services

                        - Go to Import Data and make a copy of all 'Import VMWare ....' Rules

                        - Rename the copies to 'ODBC Import VMware ...'

                        - Open all 'ODBC Import VMware ...' rules and go through the configuration screens

                                  - On all 'Data Source' screens, change the information to ODBC and select the DSN created before.

                                    Use the same username/password as in the DSN. DON"T CHANGE ANYTHING ELSE IN THE CONFIGURATIONS, and save them.

                        - Create a New Rule Group called ODBC VMware Import

                        - Drag and drop the 'ODBC VMware Import ...' rules into the new group

                        - Go to the VMware Vcenter Group and drag and drop all non-VMWare Import rules from the sub-groups into your new group

                        - Change the run order of the ODBC VMware Import group (right click on the group) to:

                             ODBC Import VMWare Vcenter Host Info

                             Normalize Manufacturers

                             Processor.speed from Processor Type

                             Pad Computer.Network.TCPIP Address

                             Calculate Computre.Processor.Features.Cores per Package

                             ODBC Import VMWare Vcenter Host Images

                             VMWAre Vcenter Set Computer.Bios.Vmware UUID

                             ODBC Import VMWare Vcenter VM Host Name

                             ODBC Import VMware Vcenter VM Info

                        - Run immediately or schedule the group to run periodically