2.6

Table Of Contents
ACE Management Server Administrator’s Manual
32 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 33.
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.
FollowingisalistofthelocationsfortheApacheconfigurationfileandthetypicaldefaultnumberof
connections:
ThedefaultinstallationofthePostgreSQLdatabaseon
RedHatEnterpriseLinuxallows100 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)
RedHatEnterprise
Linux
/etc/httpd/conf/httpd.conf 256 (preforkMPMsection)
SUSELinux /etc/apache2/server-tuning.conf 150 (preforkMPMsection)
ACEManagement
Serverappliance
/etc/httpd/apache2.conf 20 (preforkMPMsection)