/etc/firebird/3.0/fbtrace.conf is in firebird3.0-server 3.0.2.32703.ds4-11ubuntu2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 | # Trace configuration. Following rules are used :
# - configuration is processed from top to bottom
# - there is two kind of sections allowed : "database" and "services"
# - parameters at default section are used for all databases or services
# - only one default section for each kind is allowed
# - after processing of default database section, search is continued
# - if database name matches pattern, options are immediately applied and
# search does not continue
#
# Pattern is either database name without path or "SIMILAR TO"-based regular
# expression which is matched against fully qualified database path name.
#
# For log file name Sed syntax for substitutions is supported.
# I.e. \0 - whole matched string, \1 ... \9 - parenthesis subexpressions.
# \\ is backslash.
#
# String values should be enclosed into (any kind of) quotes if contains
# spaces embedded, for example:
# log_filename 'C:\\Documents and Settings\\Firebird\\My Documents\\trace.log'
# include_filter "Database Stats"
database
{
# Do we trace database events or not
#enabled = false
# Operations log file name. For use by system audit trace only
#log_filename = name
# Maximum size of log file (megabytes). Used by system audit trace for
# log's rotation : when current log file reached this limit it is renamed
# using current date and time and new log file is created. Value of zero
# means that the log file size is unlimited and rotation will never happen.
#max_log_size = 0
# SQL query filters.
#
# Only SQL statements falling under given regular expression are reported
# in the log.
#include_filter
# SQL statements falling under given regular expression are NOT reported
# in the log.
#exclude_filter
# Put attach/detach log records
#log_connections = false
# Trace only given connection id. If zero - trace all connections
#connection_id = 0
# Put transaction start/end records
#log_transactions = false
# Put sql statement prepare records
#log_statement_prepare = false
# Put sql statement free records
#log_statement_free = false
# Put sql statement execution start records
#log_statement_start = false
# Put sql statement execution finish\fetch to eof records
#log_statement_finish = false
# Put record when stored procedure is start execution
#log_procedure_start = false
# Put record when stored procedure is finish execution
#log_procedure_finish = false
# Put record when stored function is start execution
#log_function_start = false
# Put record when stored function is finish execution
#log_function_finish = false
# Put trigger execute records
#log_trigger_start = false
# Put trigger execute records
#log_trigger_finish = false
# Put context variable change records (RDB$SET_CONTEXT)
#log_context = false
# Put errors happened
#log_errors = false
# Put warnings
#log_warnings = false
# Filters for errors and warnings GDS codes.
# Comma separated list of GDS codes values and\or names.
# For example: deadlock, req_sync, 335544321
# Include filter. If empty, trace all errors\warnings events.
# Else trace event if any code from list is found in status-vector.
#include_gds_codes
# Exclude filter. If empty, trace all errors\warnings events.
# Else trace event if no code from list is found in status-vector.
#exclude_gds_codes
# Put trace session init and finish messages
#log_initfini = true
# Sweep activity
#log_sweep = false
# Print access path (plan) with sql statement
#print_plan = false
# Use legacy (false) or explained (true) plan format
#explain_plan = false
# Print detailed performance info when applicable
#print_perf = false
# Put blr requests compile/execute records
#log_blr_requests = false
# Print blr requests or not
#print_blr = false
# Put dyn requests execute records
#log_dyn_requests = false
# Print dyn requests or not
#print_dyn = false
# Put xxx_finish record only if its timing exceeds this number of milliseconds
#time_threshold = 100
# Maximum length of SQL string logged
# Beware when adjusting max_xxx parameters! Maximum length of log record
# for one event should never exceed 64K.
#max_sql_length = 300
# Maximum length of blr request logged
#max_blr_length = 500
# Maximum length of dyn request logged
#max_dyn_length = 500
# Maximum length of individual string argument we log
#max_arg_length = 80
# Maximum number of query arguments to put in log
#max_arg_count = 30
}
# default services section
#
# List of names of currently existing Firebird services (to use with service
# filters below) :
# Backup Database
# Restore Database
# Repair Database
# Add User
# Delete User
# Modify User
# Display User
# Database Properties
# Database Stats
# Get Log File
# Incremental Backup Database
# Incremental Restore Database
# Start Trace Session
# Stop Trace Session
# Suspend Trace Session
# Resume Trace Session
# List Trace Sessions
# Set Domain Admins Mapping to RDB$ADMIN
# Drop Domain Admins Mapping to RDB$ADMIN
#
services
{
# Do we trace services events or not
#enabled = false
# Operations log file name. For use by system audit trace only
#log_filename = name
# Maximum size of log file (megabytes). Used by system audit trace for
# log's rotation
#max_log_size = 0
# Services filters.
#
# Only services whose names fall under given regular expression are
# reported in the log.
#include_filter
# Services whose names fall under given regular expression are NOT
# reported in the log.
#exclude_filter
# Put service attach, detach and start records
#log_services = false
# Put service query records
#log_service_query = false
# Put errors happened
#log_errors = false
# Put warnings
#log_warnings = false
# Filters for errors and warnings GDS codes.
# Comma separated list of GDS codes values and\or names.
# For example: deadlock, req_sync, 335544321
# Include filter. If empty, trace all errors\warnings events.
# Else trace event if any code from list is found in status-vector.
#include_gds_codes
# Exclude filter. If empty, trace all errors\warnings events.
# Else trace event if no code from list is found in status-vector.
#exclude_gds_codes
# Put trace session init and finish messages
#log_initfini = true
}
# Example of trace customization:
#
# Enable logging for my_database.fdb in any folder
#
database = %[\\/]my_database.fdb
{
enabled = true
}
# Enable logging for test.fdb, azk2.fdb and rulez.fdb in any directory
# into log file name matching database name - test.log, azk2.log and
# rulez.log appropriately
#
database = %[\\/](test|azk2|rulez).fdb
{
enabled = true
log_filename = \1.log
}
|