Server Menu

From InterBase
Jump to: navigation, search

Go Up to IBConsole - Main Menu

The server menu has the following options:

Add...

Before access to a database is possible, you must provide the information necessary to communicate with the InterBase server. This process is called "adding" the server. To add a server, highlight the topmost item in the server/database tree of the Main Window - "InterBase Servers" - and select Server>Add on the menu bar. This will open the Add Server dialog box.

Serveraddwizard.png

Privilege Requirements
A server can be added by anyone. However, a valid User Name and Password, which exist in the server's security database, are required to log in to the server.

Server Information
If InterBase Server is running locally, the Local Server option will be available. The Remote Server option is always available.

To connect to a locally running InterBase server, click the Local Server radio button and supply a port alias. For a server prior to IB7.5 the port alias is always "gds_db". Starting with IB7.5 the instance name of the server must be supplied in the port alias edit box. Local server connections do not require any additional information, so the Server Name and Network Protocol options will be disabled when Local Server is selected.

If the InterBase server is accessed over a network, select Remote Server (default). When registering a remote server, provide the Server Name (the network name of the server) and select the Network Protocol used by the server (TCP/IP, NetBEUI, SPX/IPX) from the pulldown menu. The Server Name can be the network name (i.e. dbserv, ibserver) or network address when using TCP/IP (i.e. 200.112.255.0).

A server only needs to be added once. Attempts to add the same server more than once will result in an error. Once a server is added it will appear in the server/database tree.

Remove

Removing a server removes it and all databases within from the server/database tree of the Main Window. To remove a server, highlight it in the tree and select Server>Remove on the menu bar. A confirmation dialog box will appear, asking you if you are sure you want to remove the server. Click OK to remove the server and all databases registered to it. Any active database connections will be disconnected, and you will be logged out of the server if you were logged in.

IB Server Manager

Ibservermanager.png

Refresh Server Status

Updates the connection status of the Databases.

Login...

Logging in to a server allows you to use the database utilities on that server. You need to first add the server that you want to log in to. Login to a server by highlighting it in the server tree of the Main Window and selecting Server>Login from the menu bar.

Privilege Requirements
A User Name and Password that exist in the security database of the respective server are required to log in.

Logging In

  • Enter your InterBase server User Name as provided by your InterBase administrator. The User Name is required to access the server.
  • Enter your InterBase server Password. The correct password is required to access the server.
  • Finally, click Login to attempt to log in to the server using the supplied information.

Logout

It is recommended that users log out of a server when leaving their terminal unattended to prevent others from making unauthorized changes. To log out of a server, highlight it in the server tree of the Main Window and select Server>Logout on the menu bar. Logging out of a server will disconnect any databases currently connected.

Diagnose Connection...

This tool lets you troubleshoot your communications setup by testing for network and/or server problems. To use this tool select Server>Diagnose Connection... on the menu bar of the Main Window. This will display the Communication Diagnostics dialog box.

Comdiagnostics.png

The following tests are available:

User Privileges
All users can run a communications diagnostic, however a valid User Name and Password combination that matches an entry in the security database of the selected server is required to do a Database Connection Test.

User Security...

Use this dialog for creating, removing and modifying users on a local or remote server. To open the user security dialog box, log in to the server, highlight it in the connection tree of the Main Window and select Server>User Security from the menu bar.

Privilege Requirements
Users require INSERT, UPDATE and/or DELETE privileges in the Users table of the security database in order to be able to add, modify or remove users, respectively. Initially, only the SYSDBA has these privileges.

Creating New Users

  1. Press New to prepare the form for accepting a new user.
  2. Enter a User Name for the new user. User names are restricted to 31 standard ASCII characters, but must not contain spaces.
  3. Enter a password for the new user in the Password input box. This will be the new user's initial password.
  4. Retype the password in the Confirm Password input box to ensure that the correct password was entered.
  5. Enter Optional Information, if desired, which includes the user's First Name, Middle Name, and Last Name.
  6. Press the Apply button to create the new user in the security database.
  7. Repeat steps 1. to 6. for each new user to be created.
  8. Press Close when finished with user security.

When the Apply button is pressed, the data entered is validated and the operator is notified of any errors. If there are any errors, an error message will appear with details of the error, and you will have a chance to make changes before trying again. The list of users in the User Name drop down list is refreshed in order to reflect the latest transaction.

Modifying and Removing Users

  1. From the User Name drop-down list, select the User Name to be modified or removed. The remaining input boxes are filled in with the information stored for that user.
  2. If modifying the user, make the changes to the password and/or optional information and press Apply. If it is necessary to change a User Name, you will have to delete the old User Name and create a new user with the new User Name. You must have the UPDATE privilege on the Users table in the security database, or the transaction will fail.
  3. If removing the user, press Delete. You must have the DELETE privilege on the Users table in the security database, or you will get an error.

When the Apply button is pressed, the changes are validated and the operator is notified of any errors. If there are any errors, a message will appear with details of the error and you will have a chance to make changes. When a user is deleted, the list of users is refreshed to reflect the latest transactions.

Notes:

  • The User Name and Password are restricted to ASCII characters.
  • The User Name can be up to 32 characters and IS NOT case sensitive.
  • The Password can be up to 31 characters and IS case sensitive.
  • First, Middle and Last names can be up to 32 characters.

View Logfile...

The server log stores records of server events, such as users connecting and disconnecting. To view the current server log, highlight the desired server and select Server>View Logfile from the main menu.

OTW Configuration

Server>OTW Configuration opens the OTW Wizard. This option allows you to create a Over-the-Wire (OTW) encryption of the client-server connection.

For more information about this InterBase feature, please see Setting up OTW Encryption and Sample OTW Configurations.

Properties...

Selecting Server>Properties on the menu of the Main Window opens a dialog box displaying several server attributes and statistics for the server currently selected in the connections tree. The dialog box is divided into two tabs, each displaying different types of information. The properties on the Alias tab can be edited if the server is not local. If the server is local, the items on the Alias tab are all diabled. The statistics displayed on the General tab are informative only, and are not editable here. The General tab is only visible when logged in to the respective server. A description of each property or statistic is given in the list below.

Name Description
Alias Name Alias of the selected server.
Host Name The network name of the InterBase server host.
Network Protocol The current network protocol being used to connect to the network host. Disabled when logged in to the server.
Port Alias
Description

Next

Retrieved from "https://docwiki.embarcadero.com/InterBase/XE7/e/index.php?title=Server_Menu&oldid=23104"