ossc-db / pgaudit

PostgreSQL Audit Extension
Other
2 stars 4 forks source link

(refactored branche) Parameters written in uppercase letters are ignored. #37

Closed harada-toshi closed 7 years ago

harada-toshi commented 7 years ago

Over view

lowe case parameter

Config file

[output]
        logger = 'serverlog'
        level   = 'LOG'

[option]
        role = 'auditor'
        log_catalog = off

[rule]
        format = '%t,%d,%u,%p,%v,%statement_id,%sub_statement_id,%class,%command_tag,%object_type,%object_name,%command_text'
        class = 'READ,WRITE,DDL,ROLE,FUNCTION,MISC'

PostgreSQL Launch log.

Upper case parameter

Config file

[output]
        logger = 'serverlog'
        level   = 'LOG'

[option]
        role = 'auditor'
        LOG_CATALOG = off

[rule]
        format = '%t,%d,%u,%p,%v,%statement_id,%sub_statement_id,%class,%command_tag,%object_type,%object_name,%command_text'
        class = 'READ,WRITE,DDL,ROLE,FUNCTION,MISC'

PostgreSQL Launch log.

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 = auditor
LOG:  logger = serverlog
LOG:  facility = (null)
LOG:  priority = (null)
LOG:  ident = (null)
LOG:  option = (null)
LOG:  pathlog = (null)
LOG:  Rule 0
LOG:      BMP class = 500
LOG:  pgaudit extension initialized
MasahikoSawada commented 7 years ago

Thanks!

Commit c0e8f8555caba404e1492144dfff45963c65294d should fix it. Please confirm it.

harada-toshi commented 7 years ago

Thanks. This problem was confirmed that it has solved.

MasahikoSawada commented 7 years ago

Thanks!