How You Install Net

To install Ingres Net as part of a new or existing installation, follow this process:

Note: On VMS, make sure any user account that is using Net has the NETMBX privilege.

1. Make sure you have met the installation prerequisites for the network protocol you are using, and that the physical network is installed and working. For more information, see Network Installation and Testing and the appendix specific to your network protocol.
2. Be ready with the necessary information to set up the Net installation parameters.

   Windows:

   For server installations:

   • Installation Password, if you are defining one at this time

     For client installations:

   • Installation Code
   • Region and Time Zone

     If access is authorized to a remote server using an Installation Password:

   • Installation Password defined on server installation
   • Name of the host machine on which the server installation resides
   • Server installation's listen address

     UNIX:

   • Host Name: The name of the host machine on which the remote installation resides
   • Listen Address: The listen address for the remote installation's Communications server. The default is the server installation code
   • Installation Password: The Installation Password defined on the remote installation

     VMS:

   • Installation Code
   • Time Zone
3. Shut down your installation if you are adding Ingres Net to an existing installation.
4. Perform the appropriate installation procedure documented in the Installation Guide.
5. Start your installation.
6. Authorize users to use Ingres by using the create user statement (or Visual DBA if available). For details, see the Database Administrator Guide.
7. Define connection data for the remote installations you plan to access. For detailed procedures, see the chapter "Establishing Communications."
8. Define remote user authorizations for the remote installations you plan to access, if you did not do so during the installation procedure. For detailed procedures, see the chapter "Establishing Communications."
9. Define an Installation Password for the local installation to enable remote users to access this installation

   Note: This step is not necessary if you defined a password during the installation procedure.

   For detailed procedures, see the chapter "Establishing Communications."

10. UNIX: On UNIX systems, make sure the ingvalidpw program is installed. For details, see Create Password Validation Program (UNIX).

Note: If you are upgrading an existing Ingres Net installation, your existing netutil (or netu) definitions remain in effect.

Create Password Validation Program (UNIX)

On UNIX, the Ingres DBMS Server uses the ingvalidpw program to validate shadow passwords. This executable is created at installation time or loaded from the distribution media.

The mkvalidpw script tries to recompile the ingvalidpw program if your machine has a C compiler available; otherwise it copies the supplied ingvalidpw program to the $II_SYSTEM/ingres/bin directory. The mkvalidpw script also sets the II_SHADOW_PWD variable in the Ingres symbol.tbl to enable shadow password validation.

To create the ingvalidpw program

1. Log in as root.
2. Set the II_SYSTEM and PATH variables to the same values as those for the user account that owns the installation.
3. Run the mkvalidpw script, located in the directory $II_SYSTEM/ingres/bin, as follows:

   mkvalidpw

   The ingvalidpw executable is created.

4. Shut down and restart the Name Server.

   The ingvalidpw program is ready for operation.