When the DBA Management Server is launched, you are prompted with a login screen as shown below. Once your username is authenticated the DBA Management Server home page will appear.

Figure 2 DBA Management Server - Login

Note: In case of Internet Explorer, there may be a problem in redirection from https://server:9363/edb-mgmtsvr/login.jsp to http://server:9000/edb-mgmtsvr/source_stats.do

In this situation, the user may be redirected to http://server:9363/edb-mgmtsvr/source_stats.do instead of http://server:9000/edb-mgmtsvr/source_stats.do

In case this happens, update Internet Explorer using the Internet Explorer menu Tools and choose the WindowsUpdate option from the menu, and then restart Internet Explorer. The user will then be correctly redirected to http://server:9000/edb-mgmtsvr/source_stats.do

Only a valid superuser username and password can gain access to the DBA Management Server.

Upon login, the system checks for the availability of a connection configured against the Default Data Source. This information is maintained in the enterprisedb-ds.xml file which can be found in the mgmtsvr/server/default/deploy subdirectory of the Postgres Plus Advanced Server home directory. In case a connection cannot be made due to some reason such as a bad username/password combination or connection timeout, the following error message is shown.

Figure 3 Default Data Source Connection Error

This dialog box can be closed by clicking the X symbol in the upper right corner; however, this dialog box will be displayed upon each user login until the enterprisedb-ds.xml file is updated.

The following is an example of the enterprisedb-ds.xml file.

<?xml version="1.0" encoding="UTF-8"?>

<!-- ==================================================================== -->
<!--  Datasource config for EnterpriseDB                                      -->
<!-- ==================================================================== -->


<datasources>
  <local-tx-datasource>
	<jndi-name>DefaultDS</jndi-name>

	<!-- Connection using EnterpriseDB JDBC Driver -->
      <connection-url>jdbc:edb://127.0.0.1:5445/mgmtsvr</connection-url>
      <driver-class>com.edb.Driver</driver-class>

	<!-- Connection using PostgreSQL JDBC Driver -->
	<!--
	<connection-url>jdbc:postgresql://127.0.0.1:#port/#db</connection-url>
      <driver-class>org.postgresql.Driver</driver-class>
	-->

	<user-name>enterprisedb</user-name>
	<password>password</password>

	<!-- The minimum connections in a pool/sub-pool. Pools are lazily
         constructed on first use -->
      <min-pool-size>1</min-pool-size>

      <!-- The maximum connections in a pool/sub-pool -->
      <max-pool-size>20</max-pool-size>

	<!-- The time before an unused connection is destroyed -->
      <!-- NOTE: This is the check period. It will be destroyed somewhere
           between 1x and 2x this timeout after last use -->
	<idle-timeout-minutes>0</idle-timeout-minutes>


	<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml
         (optional) -->
      <metadata>
         <type-mapping>PostgreSQL 8.0</type-mapping>
      </metadata>

  </local-tx-datasource>

</datasources>