Defining Autodiscover Ports

2. Default Ports for each instance

By default autodiscover scans the following ports:

MS SQL Server: 1433
Oracle: 1521
Sybase: 5000
MySQL: 3306
PostgreSQL: 5432

These default ports are defined for each of the default groups (Development, Test, and Production) present under the file group_defaults.xml found in “C:\ProgramData\dbWatchControlCenter\config\server”.

Adding ports to auto-discover port

When you want to expand the default ports during SCAN, you can add them by creating a file name “autodiscover_ports.txt”. It follows an xml like style where it defines database name and ports. Inside that file, you will see the structure:

<port-def>
      <dbms>
           <name>oracle</name>
           <ports>
               ...
           </ports>
      </dbms>
      <dbms>
           <name>sqlserver</name>
           <ports>
               ...
           </ports>
      </dbms>
      ...
 </port-def>

A < port-def > tag encloses all the entire file. This tag is important so dbWatch can recognize that you are manually defining the ports for auto-discover. Inside the <port-def> tag, you will see < dbms > tags enclosing both < name > and < ports > tags. Inside each <dbms> you will define a set of ports/port ranges for each supported DBMS type in the following way:

<dbms>
  <name>oracle</name>
    <ports>
      <port>1520-1527</port>
      <port>5633</port>
      <port>5635</port>
    </ports>
 </dbms>

As you see, a <dbms> tag contains:
|Tag || Description|
| < name > ||Tag for database instance name. (Legal values: “oracle”, “sqlserver”, “sybase”, “mysql”, “postgres”)|
| < Por t> || Tag for port range (f.ex 1520-1527) or single port (f.ex 1521). Maximum allowed value for port is 65535.|