Open topic with navigation
WTSupported in traditional Synergy on Windows
WNSupported in Synergy .NET on Windows
USupported on UNIX
VSupported on OpenVMS
Vtxnetd and vtxnet2 are service programs that implement SQL OpenNet. Vtxnet2 is available only on Windows. Note the following operating system-specific information:
If the SQL OpenNet service fails to start, an error will be written to the tcm_pid.log file if you are using vtxnetd/vtxnet2 logging. There will be no other indication that the service failed to start, except that SQL OpenNet connections will fail.
vtxnetd [option] [...]
vtxnet2 [option] [...]
Use the operating system to validate the username and password in connect strings. On Windows, you can use -a with the L option (that is, -aL; L must be capitalized) to log authorization errors to the Windows Event Viewer.
-e crt key [p]
Use SSL data packet encryption. Crt is the name and location of the SSL certificate file, key is the name and location of the key file, and p (optional) specifies supported protocols (TLS levels).
Use the specified file to check inbound service requests. (Windows, UNIX only)
Display a list of options.
Encrypt usernames and passwords in connect strings; n specifies the key for the encryption algorithm.
Output a connection log.
Output a connection log that does not include vtxping events.
Listen for requests on port nnnn.
Specify thread stack size for vtxnetd in kilobytes. (Windows only)
Specify that the port allows IPv6 connections. Default is IPv4. If the OS supports IPv4 and IPv6 connections on the same port, specifying -v6 means both IPv4 and IPv6 are supported. If the OS does not support IPv4 and IPv6 on the same port, specifying -v6 results in only IPv6 support. (Currently, only Solaris and HP-UX do not offer this support.) (Windows, UNIX only)
Terminate existing connections when vtxnetd is shut down. There is a delay of up to n seconds after the shut down is requested for underlying operations to complete. The default is 10 seconds. (Windows only)
By default, no system-level remote user authentication occurs. This behavior can be overridden with the -a option. When -a is used, the username and password for the host must be passed in the connect string from the client machine (in addition to any database username and password). The host username and password could be an account on the server machine or (on Windows) on a domain controller.
The service manager validates the username and password using operating system security validation. Assuming the username and password are valid, the service manager creates a new process or thread for the connection using the persona of the username that was passed to it. Note the following operating system restrictions for using the -a option:
On Windows, by including “L” with the -a option (that is, -aL), you can log authorization errors in the Windows application event log, which can be viewed with the Windows Event Viewer. If the authentication fails, this log will contain information that may be helpful in troubleshooting.
Encrypting data packets (-e)
By default, no data packet encryption (SSL encryption) occurs for SQL OpenNet. To enable SSL encryption for SQL OpenNet, use the -e option:
-e crt key [p]
This option invokes SSL encryption functionality supplied by a third-party library, OpenSSL. Crt specifies the name and location of the SSL certificate file, and key specifies the name and location of the key file. These can include a full path or logical. The optional p argument enables you to specify supported TLS levels (TLS 1.0, 1.1, 1.2). By default, all three are supported, but current security best practices require TLS 1.2. To specify more than one TLS level, separate values with commas. For example,
vtxnetd -e c:\ssl\crt.txt c:\ssl\key.txt 1.1,1.2
See Using data packet encryption for SQL OpenNet for information on installing and setting up SSL for SQL OpenNet. For information on default SSL client settings for SQL OpenNet, see Setting SQL OpenNet client options in net.ini. For information on setting connection-specific client settings for SSL encryption, see %SSC_CMD (for SQL Connection) and Setting up access with DSNs (for xfODBC).
The -f option is supported on Windows and UNIX only.
Using the -f option tells the service manager to check inbound service requests and reject invalid requests. The -f option specifies a text file, in which you list the connect strings that this instance of the service manager can connect to. For example, if the file of valid connection strings contains only this:
then only a connection request from a client specifying exactly
will be allowed.
By default, the -k option is included on the command line in the start-up file. This option encrypts both the database username and password and the host username and password being sent across the wire.
The key n can be any number between 1 and 2,147,483,647. It must be set to the same value on both the server and the client. On the client, set it in the net.ini file in the connect\synodbc\lib directory. See Setting connect string defaults and encryption in net.ini. If these numbers do not match, you’ll get the error “Invalid connect syntax (uid/pwd/datasource).”
Change this setting on the server and clients. The default setting is common knowledge and is not secure.
Use the log option to produce a log file that contains error information and connection requests, including vtxping events, such as occur when sqld polls vtxnetd/vtxnet2. Use the log2 option to produce a log file that contains error information and connection requests, without the vtxping events. Using log2 produces a smaller logfile. By default, the log file is located in the directory that the service manager was started in and is named tcm_pid.log, where pid is the current process ID.
Be sure to manage log files. Turn off logging when it is no longer needed, and clean up unneeded log files.
Use the -p option to specify the port that SQL OpenNet will use on the server. On OpenVMS, the port number must be specified using -p (in the NET.COM file), unless you want SQL OpenNet to use port 1958 (the default).. On Windows and UNIX, however, you can specify a default port in the services file, but this it is not recommended. A port number setting in the services file is used only when -p is not used. (See Specifying the port number and Configuring SQL OpenNet for SQL Connection.)
Make sure that the port you specify for SQL OpenNet is not used by anything else on your system. And make sure that the port number that clients use for SQL OpenNet matches the port number used by vtxnetd/vtxnet2 on the server. For SQL Connection, see Connecting from a client for Windows; SQL Connection: configuring client or stand-alone access for UNIX; or SQL Connection: configuring and testing client or stand-alone access for OpenVMS. For xfODBC, see Setting up access with DSNs.
By default, vtxnetd uses 512K of memory on Windows. You can change this with the -s option, which determines how much memory vtxnetd will use by limiting the thread stack size allocated to it. Reducing the amount of memory used may enable vtxnetd to support more concurrent users.
For example, to reduce the amount of memory used by vtxnetd to 256K, you would use the following:
Database drivers have minimum requirements for thread stack size. If you set the thread stack size to a value that is less than the minimum required by your database driver, vtxnetd will likely fail or generate random errors.
By default, the -w option is included on the command line in the opennet.srv file. When -w is specified, shutting down SQL OpenNet will disable new connections and terminate existing ones, resulting in a “Network connection lost” (10054) error on the client. There is a delay of up to n seconds before existing connections are terminated, allowing underlying operations to complete. The default is 10 seconds, but you can change this value by editing the -w option on the vtxnetd command line in opennet.srv. If you set it to 0 (zero), all connections will be terminated immediately.
If -w is not specified, new connections are disabled, but existing connections are not terminated, and vtxnetd does not completely shut down until all child processes have terminated. Only the third-party applications that are connected to the Synergy data can stop existing processes in this case.
See Stopping and removing SQL OpenNet for details on the various ways to stop the service.
The -w option was introduced in version 10.3 and is included on the vtxnetd command line in the opennet.srv and opennet_base.srv files for 10.3 and higher. The opennet.srv file is not overwritten on an upgrade, however, so if you are upgrading from a previous version and want client connections to be terminated when vtxnetd is shut down, you will need to edit opennet.srv to add -wn to the command line. For example,
vtxnetd.exe -k67834 -p1958 -s512 -w10 log2
Running multiple SQL OpenNet servers
You can run multiple SQL OpenNet servers by specifying multiple start-up lines, with a different port number for each server. For example:
nohup vtxnetd -p1960 &
$ VTXNETD -p1960