PreviousGetting Started with Pervasive PSQL v9 SP2 (9.5) (Server Edition) (v9 SP2 (9.5) revision 1) Next

Changing the Default Communication Ports

Chapter contents

Pervasive PSQL communicates through three ports. Your firewall(s) and routers need to allow access to the following ports for remote access with the server database engine:

Typically, you do not need to modify the ports unless you have a conflict with them.


Note
The Windows operating system uses port 139 for authentication to the operating system. An alternative to allowing access to port 139 through a firewall is to enable security on the Pervasive PSQL database. Once security is enabled, users, such as "Master," are authenticated to the database through the database's own security features. See To turn on security using Pervasive PSQL Explorer and To create a new user using Pervasive PSQL Explorer , both in Advanced Operations Guide.

Port assignments 1583 is configurable for the server through the Pervasive PSQL utilities. See TCP/IP Port in Advanced Operations Guide. This port is manually configurable for clients as explained in this section.

Port assignment 3351 is manually configurable for the server and the clients as explained in this section.

Ensure that the port configurations match on both the server and all clients. You must stop then start the database engine for the port assignments to take effect.

Services File

The services file is a text file used by the operating system for network communications. In the services files, you can manually assign the ports used by Pervasive PSQL Server and its clients. The following table summarizes this.

Platform
Location of Services File
Example Addition To Services File1
Windows 32-bit
\WINDOWS\SYSTEM32\DRIVERS\ETC
or
\WINNT\SYSTEM32\DRIVERS\ETC
To specify that you want to use port 1580 for the relational interface, add the line:
psql      1580/tcp
To specify that you want to use port 3355 for the transactional interface, add the line:
btrieve      3355/tcp
Windows 98/ME
\WINDOWS
NetWare
SYS:\ETC
Linux
/etc
1Entries are case-sensitive in the Linux services files and in the Windows services file for 32-bit platforms. Entries in the NetWare services file are not case-sensitive.


Note
After changing port assignments in the services file, you must stop then start the Pervasive PSQL database engine for the changes to take effect. See Starting and Stopping the Database Engine in Pervasive PSQL User's Guide.

Chapter contents
Book contents

Prev topic: Using SPX to Connect to a Windows 32-bit Server
Next topic: NetBIOS and the Pervasive PSQL Server Engine