OpenBase Manager Overview
The OpenBase Manager application provides graphical tools for managing database servers across your local area network. It also includes tools for viewing database tables, editing database schemas, managing database security and starting database servers.
Overview of OpenBase Manager
OpenBase Manager allows you to view the different hosts and servers on your local network with OpenBase installed. There are three categories provided for viewing databases and servers. By clicking on the category you can see the databases available within that specific category. These categories are Local, Network, and Remote. OpenBase Manager also allows you to create groups of databases.
The OpenBase Manager window serves as a database control panel allowing users to perform a variety of functions including starting and stopping databases remotely from across the network. Databases with a green dot beside their name have been started and are ready to be used.
Figure 1: OpenBase Manager Window
The Action Button
The Action button drop down menu list allows you to perform the same functions as you could by clicking on the icons to the right of the database name. In addition, you can perform Backup functions, Synchronization functions, and create New Databases.
When no database is selected, this button only shows the New Database option.
The Forms Menu
The Forms Menu provides easy access to existing database interface forms created with OpenBase Form, as well as a quick way to create new forms. By selecting a database and selecting “New Form” on this menu you can generate a new database interface to access your data.
The Color Button
The Color button allows you to select a color scheme for the database names. This can aid you in quickly identifying the database you are looking for in a longer list. The colors show as aqua bubbles. The colors are changed globally for the database so all users will see the changes made to the color scheme.
The Detail Button
The Detail button expands and collapses database information that is displayed in the window. When the database information is expanded it shows additional information such as database size and the text description. When collapsed, only the database name and action buttons are displayed.
Left Side of OpenBase Manager Window
Local shows all databases located on the local machine. If none are displayed, it may be that you do not have the server processes installed on the local machine.
Network uses Rendezvous to discover all network accessible database hosts on your local area network.
Remote allows you to specify other hosts outside your network that you want to monitor. The (+) allows you to add the domain names or the ipaddresses you want to monitor to the list.
Remote Networks are groups of databases which share different Infoserver. It could be a website or another group of servers which you want to remotely administrate. Remote Networks are listed under the Remote Networks title on the main OpenBase Manager window.
To add a Remote Network you need an ipaddress or fully qualified domain name and a user friendly title for the network. Click the plus (+) icon next to Remote on the OpenBase Manager window and enter either the hostname or IP address of the remote host. For best results the ipaddress should be the address of the remote network’s infoserver. However, the ipaddress could be any of the servers that share the infoserver as long as the infoserver computer is remotely accessible. Only one ipaddress per network should be included in order to see all of the accessible database hosts on that network. To configure Remote Networks
To configure the Remote Host, click the configure icon to the right of the database name and enter the login information for that host.
Below the line are groups of databases. To add a group click the plus sign in the lower left hand corner. To edit a group click the little pencil icon beside each group name. To add databases to a group, you can drag and drop databases from Local, Network, Remote categories into the groups. To remove a database from a group, click the (X) icon at the far right of the action buttons.
Once you click on the category, the database names will be displayed. The icon to the left of the database names shows whether the databases are starting, running, stopping or stopped. The different icon meanings are explained as follows:
(Yellow) The database is in the process of starting. During this time database files are checked
and rebuilt if necessary.
(Green) The database is running on the specified host and is ready to be accessed by client
(Yellow-Red) The database is in the process of cleaning up before stopping.
(Red) The database has been stopped.
(Clear) The database has not been started.
Database Management Tools Icons
The buttons to the right of the database name provide easy access to a number of common functions. They are described as follows:
Start - Starts the selected database
Stop - Stops the selected database
Browse Data - Opens the database to browse data
Configure - Allows the user to configure database preferences related to Localization, unique
keys, mirroring, backup, automatic procedures, and expert settings.
User Manager - Allows the administrator to add new users and groups and to set the access
levels for each
Form Wizard - Allows users to create a new OpenBase Forms interface for accessing database
Database Schema Design - Allows the administrator to change the schema for the selected
SQL Terminal - Opens an SQL Terminal window
GUI SQL Terminal - Opens an SQL Terminal window in a GUI interface
Database Monitor - Opens a monitor window for the selected database.
Active Database Connections - Displays the number of active database connections
Cleanup Database - Cleans up the selected database
Message Log - Opens the message log for viewing
To start a database:
1. Click on the database name that you want to start in the OpenBase Manager window.
2. Click the Start Database button or select Start Database from the Action menu or Action
icon on the OpenBase Manager window. This may bring up a password window asking for
the password of the host where you are starting the database. If this happens, type in the
password and press the return key. The password can be set by selecting File > Server >
Configure Local Host from the OpenBase Manager window.
A yellow dot icon will appear beside databases you start, indicating that the database is in the process of starting. The start-up procedure may take several seconds, during which time the server checks the data and loads some of the indexes into memory. When the database becomes available for user programs, a green dot will appear beside the database.
To stop a database:
1. Select the database you want to stop.
2. Click the Stop toolbar item or select the Stop menu item on the Database menu. This may
bring up a password window asking for the password of the host where you are starting the
database. If so, type in the password and press the return key.
The icon beside the database will turn to a yellow dot, indicating that it is shutting down. When the database actually stops, a red dot will be displayed.
Creating New Databases
To create a new database:
1. Click the Action icon on the OpenBase Manager window or the Action menu item and then
select the Create New Database option. A panel will appear allowing you to specify a new
database name and the host computer you would like your database to run on. The
database name must not contain any spaces.
2. Select the host from the popup menu.
3. Once the name has been entered and the host selected, the next window provides seven
tabbed panels where you can configure the database settings. These tabs are General,
Localization, Keys, Mirroring, Backup, Automatic, and Expert.
4. Click on the tabs and enter the database settings. See Configuring the Database for detailed
information on each tab.
When all the parameters have been set, close the window. You will be prompted to either Cancel, Close without Save, or Save Changes. Click Save Changes to save all the parameters entered.
Before you can use your new database you need to start it. To start the database, select the database and click the start icon. When you do this a new server process will be started on the destination computer.
To duplicate a database, select the database in the OpenBase Manager. Click the Action icon or click Action in the menu bar and select Duplicate Database. Only stopped databases can be duplicated. Use the Configuration General tab to edit the name of the new database.