Configuration Databases

From GWAVA4

Jump to: navigation, search

GWAVA 4 stores all of its configuration information in distributed databases, currently stored in the SQLITE3 format.

The major advantages of this system are

  • It allows distribution across the GWAVA system, no matter how many servers. This permits deployment and maintenance of configuration world-wide.
  • By storing the information in a SQL database it is easier to access and retrieve the information in a uniform fashion. Also, administrators that wish to extract statistical information for reports can do so.
[edit]

Core Database

The core configuration database, maintained by GWAVAMAN (see GWAVA 4 Components), is gwavaman.db, located in <productRoot>/config directory.

The core configuration database consists of three tables

  • the main configuration table, containing all configuration information for all objects in the network.
  • the HOSTS table, which lists all the servers participating in the network (used for replication)
  • the replication table, which is used during replication. (Pending replications are stored here temporarily)
[edit]

QMS Database

The GWAVA Quarantine Management System (QMS) data store is located by default under <productRoot>/services/qms/data

and is stored in multiple databases:

  • qms_data.db contains the core message and event information
  • qms_user.db contains the user, group and rights information
  • qms_digest.db contains digest configuration information

The actual MIME files are NOT stored in the QMS database, but under the STORAGE subdirectory below the QMS data directory.

[edit]

Editing the Configuration Databases

We strongly recommend that the administrator NEVER directly edit the database records. Instead, use the Web interface provided by GWAVAMAN. Even using the Database Editor in the Advanced System Tools is quite dangerous and may lead to

  • permanent loss of data
  • non functioning system
  • multiple servers out of sync or refusing to communicate with each other
  • breaches of security

Technical Support has been trained in the use of database editing tools. Nonetheless, it is strongly recommended that you make a safe backup - Backing up Configuration Databases before submiting an incident to Technical Support.

Retrieved from "http://gwavasupport.securesites.net/wiki/index.php/Configuration_Databases"
Personal tools