Configure DBServer

Overview

Procedures

Reference

Overview

Configure DBServer to define aspects of the operation of the server including:

• The names and the locations (defined by URL or IP address) of the databases you want to access.
• The number of database connections to maintain.
• Which users can access DBServer to work with template and SQL statements stored on the server.
• The groups to which users belong and the specific ranges of SQL statements associated with those groups.

HHPN recommends using Unify eWave ServletExec version 3.0 for servlet management. If you are using this product, also adjust the configuration to ensure that FormProcessor and the servlet manager on the DBServer installation work correctly as described in Procedures. For information about configuring other servlet management products, see the corresponding product documentation.

Configure DBServer settings immediately after installation or whenever you need to change database or server settings or users. For information about updating configuration settings, see Manage DBServer.

Procedures

Define server and database properties

Adjust the ServletExec configuration

Define groups

Define group access rights

Define users

Configure server log data display

Configure template-statistics display

Configure SQL statement statistics displays

Configure the backup server

Define Server and Database Properties

1. In the DBServer window, from the Configure menu, click Edit Server.
2. In the Server Configuration dialog box, click Add Connection.
   
   

   

3. In the Database Connection dialog box, complete the options for the new database connection as appropriate.
   
   

   

4. Complete the remaining options in the Server Configuration dialog box and click Submit.

Adjust the ServletExec Configuration

1. With ServletExec installed, click Start, point to Programs menu, and point to New Atlanta.
2. Under New Atlanta, point to ServletExec 3.0 API, point to Admin, and click Register. The Edit Servlet dialog box appears as follows.
   
   

   

3. Complete the dialog box as follows.
• In the Servlet Name box, type FormProcessor.
• In the Servlet Class box, type FormProcessor.
• Under Initialization Parameters, in the Name box, type serverdirectory.
• In the Value box, type the DBServer path (for example, "C:\Program Files\DBServer").
4. Click Submit to save changes or Reset to clear changes.
5. In the left pane of the dialog box, under Virtual Machine, click classpath.
   The following dialog box appears.
   
   

   

6. In the Java Virtual Machine (VM) Classpath dialog box, type each line of the class path for DBServer in the boxes provided. If your DBServer installation resides on the C drive, the path might appear as follows:




C:\Program Files\New Atlanta\ServletExec ISAPI\classes

C:\Program Files\XLiRAD_Server\classes

C:\Program Files\XLiRAD_Server\classes\XLiRAD.jar

C:\Program Files\XLiRAD_Server\classes\email.zip

C:\Program Files\XLiRAD_Server\classes\jaxp.jar

C:\Program Files\XLiRAD_Server\classes\jsdk.jar

C:\Program Files\XLiRAD_Server\classes\motif.jar

C:\Program Files\XLiRAD_Server\classes\parser.jar

C:\Program Files\XLiRAD_Server\classes\sfc.jar

C:\Program Files\XLiRAD_Server\classes\swingall.jar

C:\Program Files\XLiRAD_Server\classes\windows.jar

C:\Program Files\XLiRAD_Server\jre

7. In the left pane of the dialog box, under Configure, click Aliases. The following dialog box appears.
   
   

   

8. In the Servlet name box, type the alias you want to use for FormProcessor. Using an alias is optional.

Make sure the alias you define matches the one used in your DBServer configuration.

Define Groups

1. From the Configuration menu, click Edit Groups.
2. In the Group Editor dialog box, add the name of the groups your users will belong to.
   Notice that the new group appears in the Existing Groups dialog box after you click the Add Group button.
3. Click Exit.

Define Group Access Rights

1. From the Configuration menu, click Edit SQL Ranges.
2. In the SQL Range Selection dialog box, specify the starting and ending numbers for a range of command IDs to associate with a selected group.
3. Click Submit.

Define Users

1. From the Configuration menu, click Edit Users.
2. Complete the User Editor dialog box and the Edit User dialog box options.
3. Click Submit.
   Notice that the new user's name appears in the Current Users list box.

Configure Log Display

• From the Configuration menu, click the Display Output check box.
  Clicking this check box causes the DBServer window to display server events such as database-connection testing, client requests to the server, and so on.

Configure Template Statistics Log Display

1. From the Configuration menu, click Template Statistics.
2. In the Template Statistics dialog box, complete the options as appropriate and click Exit.

 Configure SQL Statistics Log Display

1. From the Configuration menu, click SQL Statistics.
2. In the SQL Statistics dialog box, complete the options as appropriate and click Exit.

 Configure the Backup Server

1. From the Configuration menu, click Configure Backup Server.
2. Complete the Backup Server dialog box options and click Submit. 
   For information about how the backup service works and how to use it, see Manage DBServer.

Reference

DBserver supports the following databases:

• Microsoft SQL Server 7.0 or later
• Microsoft Access 97 or later
• Oracle version 7.0 or later
• Sybase
• IBM UDB
• MySQL

The database can reside on any computer that can communicate with the computer running DBServer.

The evaluation copy of DBServer supports two database connections. The starting license configuration supports five database connections; if you need additional connections, you can purchase a license for additional connections (available in five-connection increments).

Users log on to DBServer by means of a user name and password defined by the administrator. The administrator assigns users to groups to control the SQL statements that users can access. This capability helps Internet Service Providers (ISPs) host a DBServer installation for businesses who store their own set of SQL statements on the server. By assigning each business its own group, the DBServer administrator enables multiple businesses to use the same DBServer installation while preventing one business from accessing the SQL statements of another business that reside on the same server. Assignment of groups also benefits Web design firms where design teams work on multiple projects. If team members belong to a group associated with the project, they only need access to the SQL statements associated with that project. For best results, create SQL statements for a particular group in sequential order. For information about creating SQL statements using XLiRAD, see Work with SQL Statements. 

When you start DBServer and select the auto-start option, DBServer begins establishing database connections and monitoring for server requests as soon as you launch DBServer. If you don't select auto-start, only the DBServer Executive runs after start-up; you can manually start the database connections process or the monitoring process as needed. If you want your computer to start DBServer automatically after system start-up, place DBServer in your Startup group (on a Windows-based computer) or include it in the run-command (rc) scripts of a UNIX-based computer.

Configuration Menu Command Help

Server Configuration Dialog Box Help

Database Connection Dialog Box Help

Backup Server Dialog Box Help

Group Editor Dialog Box Help

SQL Range Selection Dialog Box Help

User Editor Dialog Box Help

Edit User Dialog Box Help

Template Statistics Dialog Box Help

SQL Statistics Dialog Box Help

Server Configuration Dialog Box Help

The Server Configuration dialog box displays the database, computer, or port settings for the current DBServer configuration.

Option	Description
Database Connections	These columns list the database settings you configure in the Database Connection dialog box.
Add Connection	Click this button to display the Database Connection dialog box where you can define a new database connection.
Edit Connection	With a database name selected, click this button to display the Database Connection dialog box where you can change information for an existing data source.
Remove Connection	With a database name selected, click this button to remove a listed connection.
DBServer Port	Displays the number of the port that DBServer monitors for requests. To add or change a configuration, type a new number.This is typically a value of 5000 or higher.
Servlet Alias	Displays the name of the currently defined servlet. To add or change a configuration, type the name of the alias or friendly name for the servlet.
Auto Start	Click this check box if you want DBServer to start making database connections and monitoring for requests as soon as you start DBServer. DBServer clears this check box by default.
Cancel	Click this button to discard changes and close the dialog box.
Submit	Click this button to save changes and close the dialog box.

Database Connection Dialog Box Help

Use the Database Connection dialog box to add or modify database and server properties.

Backup Server Dialog Box Help

Use the Backup Serverdialog box to define the database host name, port number, and other settings that support use of a backup server.

Group Editor Dialog Box Help

Use the Group Editor dialog box to add, delete, or change the names of groups and to view the users associated with a group.

SQL Range Selection Dialog Box Help

Use the SQL Range Selection dialog box to specify the range of SQL statements that users can access according to their group membership.

User Editor Dialog Box Help

Use the User Editor dialog box to view a list of users and to present a dialog box for adding, deleting, or changing the data for users who may access the server while authoring templates or working with SQL statements.

Edit User Dialog Box Help

Use the Edit User dialog box to add a new user name and password to a group or to change the name or password of an existing user.

Template Statistics Dialog Box Help

Use the Template Statistics dialog box to configure display of templates requested by name and the number of requests for those templates over a user-defined interval.

SQL Statistics Dialog Box Help

Use the SQL Statistics dialog box to configure display of SQL commands requested by command ID and the number of requests for those commands over a user-defined interval.