From: | Dylan Luong <Dylan(dot)Luong(at)unisa(dot)edu(dot)au> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | pgAudit_Analyze - parse error in pgaudit_analyze.log |
Date: | 2016-12-15 03:06:30 |
Message-ID: | 76719bdd1ebc412a8a2c0178b4d47aa2@ITUPW-EXMBOX2B.UniNet.unisa.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
I have configured pgAudit extension on my DEV PostgreSQL instance.
I am trying to configure the pgAudit_Analyze to read the audit logs and loads them into a database table.
Following the steps in https://github.com/pgaudit/pgaudit_analyze I have perl script pgaudit_analyze running as a daemon process. I can see csv files in my log directory, however, in the pgaudit_analyze.log I am seeing the following errors consistently.
reading postgresql-14-12-16-13-56.csv
reading postgresql-14-12-16-14-00.csv
reading postgresql-14-12-16-14-30.csv
reading postgresql-14-12-16-15-00.csv
reading postgresql-14-12-16-15-30.csv
reading postgresql-14-12-16-16-00.csv
reading postgresql-14-12-16-16-30.csv
Can't call method "parse" on an undefined value at ./pgaudit_analyze line 509, <$hFile> line 282.
at ./pgaudit_analyze line 44
main::__ANON__('Can\'t call method "parse" on an undefined value at ./pgaudit...') called at ./pgaudit_analyze line 509
main::auditWrite('5850e4ff.6355', 'postgres', 4, 'AUDIT: SESSION,1,1,MISC,SET,,,"\x{a}SET DateStyle=ISO;\x{a}SET client...') called at ./pgaudit_analyze line 474
main::logWrite('5850e4ff.6355', 'postgres', '2016-12-14 16:51:51.265 ACDT', 4, 'set', 'log', 00000, '5/20971', 0, ...) called at ./pgaudit_analyze line 696
eval {...} called at ./pgaudit_analyze line 643
reading postgresql-14-12-16-13-56.csv
reading postgresql-14-12-16-14-00.csv
reading postgresql-14-12-16-14-30.csv
reading postgresql-14-12-16-15-00.csv
reading postgresql-14-12-16-15-30.csv
reading postgresql-14-12-16-16-00.csv
reading postgresql-14-12-16-16-30.csv
Can't call method "parse" on an undefined value at ./pgaudit_analyze line 509, <$hFile> line 282.
at ./pgaudit_analyze line 44
main::__ANON__('Can\'t call method "parse" on an undefined value at ./pgaudit...') called at ./pgaudit_analyze line 509
main::auditWrite('5850e4ff.6355', 'postgres', 4, 'AUDIT: SESSION,1,1,MISC,SET,,,"\x{a}SET DateStyle=ISO;\x{a}SET client...') called at ./pgaudit_analyze line 474
main::logWrite('5850e4ff.6355', 'postgres', '2016-12-14 16:51:51.265 ACDT', 4, 'set', 'log', 00000, '5/20971', 0, ...) called at ./pgaudit_analyze line 696
eval {...} called at ./pgaudit_analyze line 643
Please help.
My DEV server is Red Hat 6. PostgreSQL9.5
Regards
Dylan
From | Date | Subject | |
---|---|---|---|
Next Message | David Steele | 2016-12-15 03:43:12 | Re: pgAudit_Analyze - parse error in pgaudit_analyze.log |
Previous Message | Adrian Klaver | 2016-12-15 02:08:09 | Re: Plpgsql - Custom fields Postgres 9.5 |