2.0

Table Of Contents
VMware, Inc. 73
Chapter 4 Installing and Configuring the ACE 2 Management Server
Theexternaldatabasedoesnothavetobeinstalledonthesameserveras theACE2
ManagementServer.
2Configureadatabase.Makesureyouhaveadedicateddatabase(seetheNote
below)andauseraccountthathasfullaccesstothisdatabase,includingrightsto
createtables.Ensurethatyoudidnʹtgivethisdatabaseuserpermissionsthatit
doesnʹtneed;forexample,forreadingorwriting
tootherdatabasesmanagedby
yourRDBMS.
3IfyouplantohavetheACE2ManagementServerconnecttothedatabaseoverthe
network(TCPsocketconnection),ensurethatTCPconnectivityisenabledinthe
databaseconfigurationoptions.AlsoensurethattheTCPconnectionisnotblocked
byfirewallsettingson
eitherthedatabaseserverortheACE2ManagementServ er
system.Additionally,ifyouareusingaPostgreSQLexternaldatabase,youmust
configureperuserpermissiontoconnecttothedatabaseoverthenetwork.
Configurethatpermissioninthefilepg_hba.conf,whichislocatedintheroot
folderofyour
database.
4ToensuresmoothconfigurationoftheACE2ManagementServer,youcouldalso
verifytheserversconnectivitytotheconfigureddatabasewiththeconfigureduser
credentialsbyrunningacommandlineorgraphicalSQLtoolontheACE2
ManagementServermachine.Examplesofsuchtoolsaresqlcmd.exeforSQL
Server,sqlplus.exeforOracle,andpsqlforPostgres.Refertotherespective
databaseusermanualfordatabaseconfigurationandverificationinstructions.
5 CreateaSystemDSNentryontheACE2ManagementServermachine.Theonly
requiredinformationinDSNconfigurationistheDSNname,serverIPaddressor
hostname,and
thedatabasename.Inotherwords,youdonʹthavetoprovidea
usernameandpasswordintheDSNconfiguration.Anyvaluesenteredherewill
N
OTETheACE2ManagementServerwillcreatethedatabaseschema
automatically,providedproperaccessrightsaregranted.
NOTEAlltablesinthedatabasehaveanamestartingwithaPolicyDb_prefixand
indiceswithPdbIns_orPdbLf_prefixes,sopotentiallyyoucouldprovidethe
ACE2ManagementServerwithaDSNtoadatabasethatitwouldsharewithsome
otherapplication,ifthedatabasecountisat
apremium.