Configuration

The PhraseExpress SQL Client Manager is your central hub to manage users, clients and licenses.

While running, the SQL Client Manager allows clients to find the SQL database on the network (via UDP broadcast polling). The SQL Client Manager also optionally sends email status notifications.

Monitor tab

The Monitor tab shows status information and all clients with a license key association.

Use the SHIFT- and CTRL-keys to highlight multiple users in the list.

Right-click the title bar of the user list to add/remove columns.

Click a column title to sort the users in the list. Click again to invert the sorting order.

Right-click on one of the column headers in the monitor to show or hide additional columns.

Monitor columns

Right-click the title bar of the user list to add/remove columns.

Click a column title to sort the users in the list. Click again to invert the sorting order.

ColumnDescription

Check boxes in column "W" (for "write access") define whether a client is generally allowed to edit phrases. If unchecked, options to add/remove/edit phrases are disabled in that client to prevent operating errors.

This global write permission setting overrides any folder-based access permissions configured in the clients.

To change settings for all clients in one go, (un)check the check box in the title row and transfer this setting with the Set button. The check boxes in the title bar also define the default settings for new clients connecting for the first time. If you uncheck the "W" check box in the title bar, any client connecting for the first time will have no write access to the phrase file by default.

Do not revoke write access while a user is editing a phrase as the change would be lost.

Clients are updating this setting in intervals, which can be configured in the client's configuration file (tag <Network><SQLPingInterval>). If zero, or if the client has a locally registered license, this setting is retrieved on client launch only.

The check boxes in the column "C" (for "configuration") define whether a client can access program settings. If unchecked, access to program settings is disabled to prevent configuration errors.

To change settings for all clients in one go, (un)check the check box in the title row and transfer this setting with the Set button. The check boxes in the title bar also define the default settings for new clients connecting for the first time. If you uncheck the "C" check box in the title bar, any client connecting for the first time will have no write access to the phrase file by default.

Clients are updating this setting in intervals, which can be configured in the client's configuration file (tag <Network><SQLPingInterval>). If zero, or if the client has a locally registered license, this setting is retrieved on client launch only.

Licensed: The client has successfully received a license from the SQL license database.

Demo: The client has no license and is running in demo or freeware mode.

Local License: The client is registered locally and does not require a license from the central license pool (if any).

The SQL Client Manager accumulates the time and money savings of all PhraseExpress clients.

The money savings accumulate the plain figures and don't reflect different currencies.

Release unused licenses

  1. Exit PhraseExpress for the users, you wish to remove from the list of users.
  2. Select the users you wish to remove from the list.
  3. Click the button "Remove".

The license returns to the pool of available licenses and can be occupied by the next client connecting to the server.

A removed user will take a license if his client is launched again. To prevent that, remove PhraseExpress on his computer or disable autostart.

Master user

Master users have following extra rights:

  • The Master can access all phrases regardless of any access restrictions.
  • The Master can redefine the owner of any phrase (via the client access restrictions dialog).
To elevate any user to a master user:
  1. In the SQL Client Manager, switch to the "Monitor" tab.
  2. Right-click the user you wish to become the master and select the corresponding context menu option.

The selected user becomes the master users and appears with green text.

Central Master Configuration

The master user's PhraseExpress client program settings can be applied to other clients:

  1. Right-click the Master and select the corresponding context menu option. If the Master user provides the central configuration appear, he appears in bold green text.
  2. Withdraw configuration rights to all users, who shall use the program settings of the master user by unchecking the the "C" column for those users.

The selected users will use the master client program settings with the next start of their PhraseExpress clients. As they do not have configuration permission, they cannot alter the master user program settings.

Database Tab

Tab "database" provides overview about the SQL database. You can create a configuration file that contains connection information for the clients.

To create a new database or to load an existing one:
  1. Switch to the tab "Database" in the SQL Client Manager
  2. Press button "Configure" and enter the Sysdba password (default Firebird SQL Server password is "masterkey").
  3. Define an administrator account that is used to authorize access to the SQL Client Manager.
  4. Optionally change the fiel path to the SQL database. The database must be located on the server computer running the SQL server.
  5. Press OK to create the phrase and license database.

If you never changed the phrase file location on the clients (e.g. after initial installation) and if the clients can access the SQL Client Manager via UDP, the SQL Client Manager will transmit the SQL database location and PhraseExpress for Windows clients will load the SQL database automatically.

Backup

PhraseExpress does not create SQL database backups. Please use 3rd party tools to create such backups. Information about Firebird SQL database backups can be found in the Firebird SQL FAQ

Frequently backup your phrase and license database to different storage media to eliminate the slightest risk to lose your data in case of hard disk failure.

Hard disks can break - And they do when you don't expect it!

Table of Contents


    Table of Contents