Server Administration Tool

by admin, December 13, 2010

Introduction

The DBIASM server administration tool is where you manage users and Channergy databases that are connected to client computers through the DBIASM database engine. This tool can also be used to monitor who is connected to the databases as well as the status of the database engine as well.

Quick Jump To

Starting the Server Administration Tool

Once the database tools have been downloaded and installed, the Server Administration Tool can be started from the Channergy 201x menu from the start button.

 

Logging In to the Server

When the  Administration Tool has started, connect to the server via File -> Login

Login To Server Admin

The login dialog box will pop up. The default administrator login and password are admin/DBAdmin.

Login Prompt

Click the Server tab. Change the following:

  • Connection Timeout: 3600
  • Dead Session Cleanup: 30
  • Dead Session Expiration: 120

 

Linking a Channergy Database to the Client-Server Engine

In order to take advantage of the client-server engine, the engine needs to know where the Channergy database(s) are located. You do this from the Databases tab.

Select Databases Tab

In the Database Information portion of the dialog box, name the database the same as you did in the clientserver.ini file next to the RemoteDatabase field. If the RemoteDatabase is missing from the clientserver.ini file then the name of the database must be Channergy.

Add Database Directory

Use the Select… button next to the directory field to open a file browser dialog box to navigate to the folder that contains the channergy database. Note: This is not the folder that contains the clientserver.ini file.

Click the Save button to add the database to the database engine.

This can be repeated for as many Channergy databases that are on the system (provided that they have a valid clientserver.ini file).

Adding Users

In order for client computers to access the Channergy databases through the client-server engine users have to be created and then linked to the channergy databases. To add users to the system you start by selecting the Users tab. By default the Admin user has been created. To add additional users click the Add button.

Add Users

Key in a User Name and Password in the appropriate fields in the User Information box. Note, only users with the Administrator check box checked will be able to log into this Database Administration Tool. Depending on the size of your company, there should only be a select few who have administrator privileges to access this utility. Use this option wisely!

Use this screen to add other users to the system. Keep in mind that it is not necessary to have every Channergy user have a User Name on the client server. The Operators & Security settings in Channergy offer much more control over who has access to features than does the client-server engine.

Linking Users to Databases

Up to this point you have all your users added to the client-server engine. However, they will not be able to connect to the database(s) until they become Database Users. This is how you associate your users with your Channergy companies.

This is done through the Database Users tab.

Assign Users

First, select the Channergy database from the drop-down list on the left side of the menu box. Once this has been done a list of users who have access to this database will appear in the list box below.

To select a user that you want linked to this database select them from the drop-down list on the right side of the menu box. Once you have selected a user, in most cases you will check all of the Rights boxes below the User Name drop-down.

Click Save to complete the action.

Procedures

The procedures tab allows scripts to be run on a periodic basis.  To set up a procedure, click on the Procedures tab.

In the name field key in the name of the Channergy script preceded by Channergy followed by a colon.  So if the script that  you want to automate is called MyScript.mws, then the name would be Channergy:MyScript.mws.  The script will need to be installed in the Channergy data directory, not in the ChannergyCS folder.

Note: The script will need to have all of the prompts removed before it can be run from the CS Engine.  To find out how to do that check out our Creating and Running Scripts help page

The following screen shows how the script name will look.

Click on the  button.

Procedure Users

In order to be able to run procedures in the client server engine you will need to assign a user to the procedure.  In normal circumstances this involves simply assigning the Admin user to the procedure.  To set  up a Procedure User, click on the Procedure Users tab.

Click on the procedure that  you want to run  from the Procedure drop-down list and then click on the Add button.  By default the Admin user will be selected in the User Name screen

Click on the  button to save the changes.

Events

The Events tab is where you set the frequency that a procedure (script) will run.  Click on the Events tab, you will get a screen similar to the one below.

To create a new scheduled event, click on the  button.  In the Event Information screen enter in the following information in the fields

  • Name-Enter the name of the procedure that you want to run.  You will need to use the same naming convention that was used when the procedure was set up.  So if the script is called MyScript.mws, then the name would be Channergy:MyScript.mws
  • Description-Enter an optional description of the procedure.
  • Run Type-Select the frequency that  you want the procedure to run. The options are Once, Hourly, Daily,Weekly and Monthly.  In most cases you would select hourly.
  • Starting/Ending- Select the date range that you want the procedure to run.
  • From/until- Select the time that you want the procedure to run.  Depending on how long the procedure takes to run, you will need to allocate a large enough time window for the procedure to complete.
  • Every- This is where you set the time span that the procedure.  In most cases you would set this to one hour.

When you have finished setting up the Event, click on the  button.

 

Other Useful Information

If you want to know what version of the client-server engine is running it is located on the title bar of the Server Administration Tool.

Server Version

The Status tab also has a wealth of information on who is connected to the server. It also allows you to disconnect users or even start or stop the Client-Server engine.

The Log tab will display a detailed list of all the events that have occurred since the server was started. This is very useful if users are experiencing problems accessing the databases.

Server Log

No Comments


Please login to comment