On Wed, Jul 26, 2017 at 3:18 PM, PAWAN SHARMA <er.pawanshr0963@xxxxxxxxx> wrote:
On Wed, Jul 26, 2017 at 2:42 PM, Michael Paquier <michael.paquier@xxxxxxxxx> wrote:On Wed, Jul 26, 2017 at 10:59 AM, PAWAN SHARMA
<er.pawanshr0963@xxxxxxxxx> wrote:
>
> Hi All,
>
> I am facing below error while parsing log file.
>
> [postgres@abc pgaudit]$ pgbadger -f stderr postgres-2017-07-25_121445.csv
> Can't locate Text/CSV_XS.pm in @INC (@INC contains: /usr/local/lib64/perl5
> /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl
> /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at
> /bin/pgbadger line 2620.
>
> Please suggest..!!
This means that you need to install the perl module Text::CVS_XS:
http://search.cpan.org/~hmbrand/Text-CSV_XS-1.31/CSV_XS.pm
This is defined in the requirements of pgbadger's README when parsing csv files:
https://github.com/dalibo/pgbadger/blob/master/README
--
Michael
Hi Michal,Thanks for the response.I have tried to install Text::CSV_XS, but still facing same error.cpan[1]> install Text::CSV_XSReading '/root/.cpan/Metadata'Database was generated on Wed, 26 Jul 2017 09:17:02 GMTRunning install for module 'Text::CSV_XS'Running make for H/HM/HMBRAND/Text-CSV_XS-1.31.tgz Fetching with HTTP::Tiny:Fetching with HTTP::Tiny:Checksum for /root/.cpan/sources/authors/id/H/HM/HMBRAND/Text-CSV_XS-1. 31.tgz ok Scanning cache /root/.cpan/build for sizes............................................................ ................DONE CPAN.pm: Building H/HM/HMBRAND/Text-CSV_XS-1.31.tgz Checking if your kit is complete...Looks goodGenerating a Unix-style MakefileWriting Makefile for Text::CSV_XSWriting MYMETA.yml and MYMETA.jsoncp CSV_XS.pm blib/lib/Text/CSV_XS.pmRunning Mkbootstrap for CSV_XS ()chmod 644 "CSV_XS.bs""/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- CSV_XS.bs blib/arch/auto/Text/CSV_XS/CSV_XS.bs 644 "/usr/bin/perl" "/usr/share/perl5/vendor_perl/ExtUtils/xsubpp" -typemap '/usr/share/perl5/ExtUtils/ typemap' CSV_XS.xs > CSV_XS.xsc mv CSV_XS.xsc CSV_XS.cgcc -c -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -pipe -Wall -Wp ,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -DVERSION=\"1.31\" -DXS_VERSION=\"1.31 \" -fPIC "-I/usr/lib64/perl5/CORE" CSV_XS.crm -f blib/arch/auto/Text/CSV_XS/CSV_XS.so gcc -shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -Wl,- z,relro CSV_XS.o -o blib/arch/auto/Text/CSV_XS/CSV_XS.so \ \chmod 755 blib/arch/auto/Text/CSV_XS/CSV_XS.so Manifying 1 pod documentHMBRAND/Text-CSV_XS-1.31.tgz/bin/make -- OK'YAML' not installed, will not store persistent stateRunning make test"/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- CSV_XS.bs blib/arch/auto/Text/CSV_XS/CSV_XS.bs 644 PERL_DL_NONLAZY=1 "/usr/bin/perl" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(0, 'blib/lib', 'blib/arch')" t/*.tt/00_pod.t ........ skipped: Test::Pod 1.00 required for testing PODt/01_pod.t ........ skipped: Test::Pod::Coverage required for testing POD Coveraget/10_base.t ....... okt/12_acc.t ........ okt/15_flags.t ...... okt/20_file.t ....... okt/21_lexicalio.t .. okt/22_scalario.t ... okt/30_types.t ...... okt/40_misc.t ....... okt/41_null.t ....... okt/45_eol.t ........ okt/46_eol_si.t ..... okt/50_utf8.t ....... okt/51_utf8.t ....... okt/55_combi.t ...... okt/60_samples.t .... okt/65_allow.t ...... okt/70_rt.t ......... okt/75_hashref.t .... okt/76_magic.t ...... okt/77_getall.t ..... okt/78_fragment.t ... okt/79_callbacks.t .. okt/80_diag.t ....... okt/81_subclass.t ... okt/85_util.t ....... okt/90_csv.t ........ okt/91_csv_cb.t ..... okAll tests successful.Files=29, Tests=50834, 45 wallclock secs ( 4.18 usr 0.16 sys + 43.91 cusr 0.69 csys = 48.94 CPU)Result: PASSHMBRAND/Text-CSV_XS-1.31.tgz/bin/make test -- OKRunning make install"/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- CSV_XS.bs blib/arch/auto/Text/CSV_XS/CSV_XS.bs 644 Manifying 1 pod documentFiles found in blib/arch: installing files in blib/lib into architecture dependent library treeInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/Text/ CSV_XS/CSV_XS.so Installing /root/perl5/lib/perl5/x86_64-linux-thread-multi/Text/CSV_ XS.pm Installing /root/perl5/man/man3/Text::CSV_XS.3pm Appending installation info to /root/perl5/lib/perl5/x86_64-linux-thread-multi/perllocal. pod HMBRAND/Text-CSV_XS-1.31.tgz/bin/make install -- OKcpan[2]> quitTerminal does not support GetHistory.Lockfile removed.[root@abc:/home/psharm89]##-> rpm -qa | grep perl-CPANperl-CPAN-1.9800-286.el7.noarch [postgres@abc pgaudit]$ pgbadger -f stderr postgres-2017-07-26_000000.csv -o abc.htmlCan't locate Text/CSV_XS.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/ perl5 /usr/share/perl5 .) at /bin/pgbadger line 2620.
Hi Michal,
For root user its working fine
[root@abc :/opt/PostgreSQL/9.5/data/pgaudit]#
#-> pgbadger -f stderr postgres-2017-07-26_000000.csv -o abc.html
[======================> ] Parsed 1873673 bytes of 1991998 (94.06%), queries: 0, events: 845
LOG: Ok, generating html report...
but for the Postgres user, its showing the below error.
[postgres@abcpgaudit]$ pgbadger -f stderr postgres-2017-07-26_000000.csv -o xyz.html
Can't locate Text/CSV_XS.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /opt/PostgreSQL/9.5/bin/pgbadger line 2652.
[postgres@abc~]$ rpm -qa | grep perl-CPAN
perl-CPAN-1.9800-286.el7.noarch
[postgres@itsusraorclic05 ~]$ logout
[root@abc:/opt/PostgreSQL/9.5/data/pgaudit]#
#-> rpm -qa | grep perl-CPAN
perl-CPAN-1.9800-286.el7.noarch
Please suggest..!!!!!!!
