This file is indexed.

/etc/firebird/2.5/fbtrace.conf is in firebird2.5-server-common 2.5.2.26540.ds4-9ubuntu1.

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
# 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"


# default database section 
#
<database>
	# Do we trace database events or not
	enabled false

	# Operations log file name. For use by system audit trace only
	#log_filename 

	# 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 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

	# Sweep activity
	#log_sweep false


	# Print access path (plan) with sql statement
	print_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
</database>



# default services section
#
# List of names of currently existing Firebirds 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 

	# 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
</services>


# Example of trace customization:
#
# Enable logging for my_database.fdb in any folder
#
<database %[\\/]my_database.fdb>
	enabled true
</database>


# 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
</database>