2.7

Table Of Contents
ACE Management Server Administrator’s Manual
30 VMware, Inc.
Create a System DSN Entry for a Linux Database
OnLinuxsystems,youuseatexteditorortheODBCConfiggraphical(X11)utilitytocreateasystemDSNentry.
TheODBCConfigutilitymimicstheWindowsODBCDataSourcesControlPanelplugin.
Beforeyoubegin,determinethecorrectODBCdriver:
OnRedHatEnterpriseServer,thedriverislocatedat/usr/lib/libodbcpsql.so.
OnSUSELinuxEnterpriseServer9,thedriverislocatedat/user/lib/unixODBC/libodbcpsql.so.2.
TheDSNconfigurationfortheunixODBCpackageisstoredinthe/etcdirectory(/etc/unixODBCfor
SUSELinuxEnterpriseServer).
IfyouareusingtheACEManagementServerappliance,see“SetUpaConnectionBetweentheServer
Applianceand
anExternalDatabase”onpage 31.
Youusetheodbc.inifileforcreatingDSNsandtheodbcinst.inifilefordriverandgeneralODBCsystem
configuration.
To create a System DSN entry for a Linux database
1Asroot,usetheODBCConfigutilitytocreateaSystemDSNentry.
YoualsomustconfiguretheserveraddressandthedatabasenameintheDSNsettings.
For
informationaboutusingunixODBC,seetheunixODBCProjectWebpage.
TheODBCConfigutilitymakeschangestotheodbc.iniandodbcinst.inifiles.
2MakeanoteofthedatabaseDSN,username,andpassword.
YoucannowusethebrowserbasedACEManagementServerSetupapplicationtoconnecttothisdatabase.
Increase the Number of Database Connections Allowed
Foroptimalserverperformance,ACEManagementServerstartsmultipleparallelthreads(onWindows)or
processes(onLinux)listeningfortheincomingconnectionsfromtheclients.Everyclientconnectiontypically
runsadatabasetransaction,soitneedstoopenadatabaseconnection.
ACEManagementServerusuallyrequiresasmanydatabaseconnectionsas
itdoesparallelthreadsor
processesforclientconnections.Iftheserverrunsoutofdatabaseconnections,theclientsmightstartreceiving
connectionerrors.
Table 41includesalistofthelocationsfortheApacheconfigurationfileandthetypicaldefaultnumberof
connections:
Table 4-1. Apache Configuration File Locations and Default Client Connections
ThedefaultinstallationofthePostgreSQL
databaseonRedHatEnterpriseLinuxallows100 remote
connections,whichislessthanthenumberofparallelthreadsthattheApacheserverstartsbydefaultonthe
sameplatform.Changethisnumberifyouexpectahighvolumeofclientrequeststoyourserver(morethan
100activeclients).
Platform Location Client Connections
Windows C:\Program Files\VMware\VMware ACE
Management Server\Apache2\
conf\httpd.conf
250 (WinNTMPMsection)
RedHatEnterpriseLinux /etc/httpd/conf/httpd.conf 256 (preforkMPMsection)
SUSELinux /etc/apache2/server-tuning.conf 150 (preforkMPMsection)
ACEManagementServer
appliance
/etc/httpd/apache2.conf 20 (preforkMPMsection)