About Static Logging

Configure static logging by specifying database options when creating or editing/updating your database. To change this type of logging, you must shut down the database and restart it.

You can choose to log to syslog, to a remote syslog to centralize logging, or the default is to log to stdout, which is captured in the agent log. See Agent Log Description for information about where the agent log is stored on your platform.

Turn logging on by setting any of the following database options. You must specify at least one of the log options listed in Database Options. There are log options for specifying the level and category of logging.

Database Option to Turn Logging On Logs To

verbose log-options

Agent log file.

syslog log-options

System log file.

remote-syslog log-options

System log file on the host specified by the remote-syslog-server database option. Specify the remote-syslog-server option to send logging information to the syslog on the remote host. The remote-syslog-server option has the following format:

remote-syslog-server hostname

You can use the Automation Console to specify static logging as in the following example, which creates a new database. In the figure below, the verbose key (database option) is set to the log options msgs (logging category that captures messages sent among NuoDB processes) and info (logging level that captures the least amount of information). Logging information goes to the agent log. See also Description of Logging Categories.

Alternatively, you can use NuoDB Manager to turn logging on. The following example turns on logging when it updates a databases:

nuodb [domain] > update database
Database Name: test
Template Name: Multi Host
Database Options: verbose msgs,debug
Template Variables: REGION us-east-1