29.2 Changing the Ports Used by the Embedded Sybase SQL Anywhere Database

Sybase SQL Anywhere uses port 2638 by default. You can change the port on which the database runs.

  1. In the zenworks_database.conf file, specify the new port number on which the server listens to.

    The zenworks_database.conf file is located in %ZENWORKS_HOME%\conf on Windows and in /etc/opt/novell/zenworks on Linux.

  2. In the zdm.xml file on all the Primary Servers, specify the new port number in the following entry:

    <entry key="Port">2638</entry>
    

    By default, the entry lists the default port number, 2638.

    The zdm.xml file is located in %ZENWORKS_HOME%\conf\datamodel on Windows and in /etc/opt/novell/zenworks/datamodel on Linux.

  3. (Conditional) If the ZENworks Reporting Server is installed on the Primary Server, add the new port number to the ODBC data information:

    • On a Windows server: Do the following:

      1. From the desktop Start menu, click Settings, click Control Panel, then double-click ODBC Data Source.

        The ODBC Data Source Administrator window is displayed.

      2. Click the System DSN tab.

      3. Double-click ZENworks Datastore.

        The ODBC Configuration window is displayed.

      4. Click the Networks tab.

      5. In the Select the Network Protocols and Options panel, change the value of the TCP/IP port number (by default, it is 2638) to the port number specified in zenworks_database.conf (the new number you specified in Step 1).

    • On a Linux server: In the /opt/novell/zenworks/share/boe/bobje/odbc.ini file, change the value of TCP/IP to the port number specified in zenworks_database.conf (the new number you specified in Step 1).

  4. Restart the database service, ZENServer, and ZENLoader services on all Primary servers:

    • On Windows: Do the following:

      1. From the Windows desktop Start menu, click Settings > Control Panel.

      2. Double-click Administrative Tools > Services.

      3. Restart the following services: Novell ZENworks Embedded Datastore, Novell ZENworks Loader Service, and Novell ZENworks Server.

    • On Linux: At the console prompt, enter the following commands in the order given:

      • /etc/init.d/novell-zenmntr stop

      • /etc/init.d/novell-zenserver stop

      • /etc/init.d/novell-zenloader stop

      • /etc/init.d/sybase-asa restart

      • /etc/init.d/novell-zenserver start

      • /etc/init.d/novell-zenloader start

      • /etc/init.d/novell-zenmntr start

Even though the TCP and UDP ports are changed from 2638, the database server also listens on UDP port 2638. For more information, see the Sybase database documentation.