Comments (3)
Thanks.
It's a memory bug. pgaudit could not handle properly when the same field is specified at more than once. Commit b300c17 should fix it.
from pgaudit.
Thank you for bug fixes!
In the bugfix version, I confirmed that it will be the following behavior.
- Segfault did not occur and the PostgreSQL server started up.
- When describing duplicate filter items in one rule, it is overwritten with the description written behind.
PostgreSQL launch log
$ pg_ctl -w -D ~/pgdata/9.6-pgaudit/ start
waiting for server to start....LOG: detect duplicate field setting "class"in rule section, overwritten by "read"
LOG: detect duplicate field setting "database"in rule section, overwritten by "test"
LOG: detect duplicate field setting "class"in rule section, overwritten by "write"
LOG: detect duplicate field setting "object_name"in rule section, overwritten by "public.foo"
LOG: detect duplicate field setting "database"in rule section, overwritten by "bad"
LOG: detect duplicate field setting "class"in rule section, overwritten by "write"
LOG: detect duplicate field setting "object_name"in rule section, overwritten by "public.bar"
LOG: log_catalog = 1
LOG: log_level_string = (null)
LOG: log_level = 15
LOG: log_parameter = 0
LOG: log_statement_once = 0
LOG: log_for_test = 0
LOG: role =
LOG: logger = serverlog
LOG: facility = (null)
LOG: priority = (null)
LOG: ident = (null)
LOG: option = (null)
LOG: pathlog = (null)
LOG: Rule 0
LOG: STR database = bad
LOG: BMP class = 256
LOG: STR object_name = public.bar
LOG: pgaudit extension initialized
LOG: database system was shut down at 2017-03-09 15:36:17 JST
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
LOG: connection received: host=[local]
LOG: connection authorized: user=nuko database=postgres
from pgaudit.
I confirmed the fix.
Close this Issue.
from pgaudit.
Related Issues (20)
- (refactored branch) Defining multiple output sections does not cause an error. HOT 3
- (refactored branch) Setting file error does not occur even if the order of each section is changed. HOT 7
- (refactored branch) When log_connections or log_disconnections is turned off and reloaded, connection audit logs are no longer output. HOT 4
- (refactore branch) Update Copyright
- (refactored branch) Even if an unnecessary token exists in the setting file, it does not cause an error. HOT 3
- (refactored branche) Even if you specify WARNING as the level of the output section, the log level of the audit log is LOG instead of WARNING. HOT 3
- (refactored branche) Question: Does the parameter name in the setting file allow only lowercase letters? HOT 3
- (refactored branche) When "log_parameter = on" is specified and SQL with multiple parameters is executed, parameters are concatenated. HOT 4
- (refactored branche) Parameters written in uppercase letters are ignored. HOT 3
- (refactored branch) There is a problem with the explanation of Session Audit Logging / Configuration of Readme.md. HOT 4
- (refactored branch) pid is not output to the audit log. HOT 5
- (refactored branch) The audit log that is output when pg_basebackup is executed is "class = SYSTEM" HOT 2
- (refactored branch) The filter by the database name has no effect on the audit log of the connection attempt. HOT 2
- (refactored branch) Even if you specify a command_tag filter, not filtered. HOT 2
- (refactored branch) Even if you specify a object_type filter, not filtered. HOT 3
- (refactored branch) Pattern matching with '%' character is not supported.
- (refactored branch) Behavior when you specify an invalid timestamp literal HOT 4
- (refactored branch) Filters do not work correctly in the Japanese object name
- Rewriting README.md HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pgaudit.