Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger
> On Wed, Jul 27, 2017, PAWAN SHARMA wrote: > > On Wed, Jul 26, 2017, wrote: > > > > You have an environment problem in that the 2 different users have a > > different > > PATH and you're getting 2 different perl executables, or at least that's > > what > > it looks like to me. Please note that where you installed the module to is > > not > > listed in the @INC of the other command. > > ... > > You can run with a custom perl, we do; but that also means you must make > > sure > > that all apps use it by setting PATH and PERLLIB appropriately, usually by > > changing a system file and making sure all environments source it. If you > > do that, > > then PgBadger will work just fine -and- use the same perl as all of your > > other programs. > > > Hi Kevin, > > Thanks for Response. > > Can you please help me, how can I run this using custom, Perl. This is really beyond the scope of this list, but I'll give it 1 try to helpful. Note: I can only answer for Linux type systems, and what you need to do is probably distro specific. The basics are to leave what was installed with the system there so the OS installed tools will continue to work when they reference /usr/bin/perl. Install your custom perl. Change a system file to reference it, which normally means adding the new dir to PATH and PERLLIB; this might be /etc/bashrc or /etc/profile.d/perl.sh (yours as it won't be from the distro) or perhaps something else. Make sure all processes get these new values (the shotgun approach is to reboot the server). Make sure any of your applications reference the new perl specifically (full path) or only say "perl" to get it from PATH. Those are the concepts; if you need more help beyond that, you should ask a good system administrator who knows your server. HTH, Kevin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger
On Wed, Jul 26, 2017 at 11:36 PM, wrote: > On Wed, Jul 26, 2017 at 3:18 PM, PAWAN SHARMA > wrote: > > > > On Wed, Jul 26, 2017 at 2:42 PM, Michael Paquier < > michael.paqu...@gmail.com> wrote: > > On Wed, Jul 26, 2017 at 10:59 AM, PAWAN SHARMA > > 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. > > > ... > > Running 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 document > > Files found in blib/arch: installing files in blib/lib into architecture > dependent library tree > > Installing /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 -- OK > ... > > [postgres@abc pgaudit]$ pgbadger -f stderr > postgres-2017-07-26_00.csv -o abc.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 > /bin/pgbadger line 2620. > > You have an environment problem in that the 2 different users have a > different > PATH and you're getting 2 different perl executables, or at least that's > what > it looks like to me. Please note that where you installed the module to is > not > listed in the @INC of the other command. > > I saw in another post that you have it fixed, but all you've done (from > what I > can see) is that you've only put a band-aide on the problem not fixed the > root issue > because you've installed the module into 2 different places. The root > problem should > still exist. > > You can run with a custom perl, we do; but that also means you must make > sure > that all apps use it by setting PATH and PERLLIB appropriately, usually by > changing a system file and making sure all environments source it. If you > do that, > then PgBadger will work just fine -and- use the same perl as all of your > other programs. > > HTH, > Kevin > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > Hi Kevin, Thanks for Response. Can you please help me, how can I run this using custom, Perl.
Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger
On Wed, Jul 26, 2017 at 3:18 PM, PAWAN SHARMA wrote: > > On Wed, Jul 26, 2017 at 2:42 PM, Michael Paquier > wrote: > On Wed, Jul 26, 2017 at 10:59 AM, PAWAN SHARMA > 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. > ... > Running 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 document > Files found in blib/arch: installing files in blib/lib into architecture > dependent library tree > Installing > /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 -- OK ... > [postgres@abc pgaudit]$ pgbadger -f stderr postgres-2017-07-26_00.csv -o > abc.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 > /bin/pgbadger line 2620. You have an environment problem in that the 2 different users have a different PATH and you're getting 2 different perl executables, or at least that's what it looks like to me. Please note that where you installed the module to is not listed in the @INC of the other command. I saw in another post that you have it fixed, but all you've done (from what I can see) is that you've only put a band-aide on the problem not fixed the root issue because you've installed the module into 2 different places. The root problem should still exist. You can run with a custom perl, we do; but that also means you must make sure that all apps use it by setting PATH and PERLLIB appropriately, usually by changing a system file and making sure all environments source it. If you do that, then PgBadger will work just fine -and- use the same perl as all of your other programs. HTH, Kevin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger
On Wed, Jul 26, 2017 at 5:38 PM, Michael Paquier wrote: > On Wed, Jul 26, 2017 at 2:01 PM, PAWAN SHARMA > wrote: > > For root user its working fine > > > > [root@abc :/opt/PostgreSQL/9.5/data/pgaudit]# > > #-> pgbadger -f stderr postgres-2017-07-26_00.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. > > There is no way to be sure what's wrong as this depends on the > environment you are using and the packaging system that you have, but > at short glance, I think that you should first try to update PERL5LIB > so as it points to the location where the module has been installed. > Good luck! It does not sound complicated to me to address anyway. > -- > Michael > Hi Michal, Thanks for your support. finally, it's done. I have installed Text::CSV_XS using PostgreSQL user. [postgres@abcpgaudit]$ perl -MCPAN -e shell cpan> install Text::CSV_XS CPAN: Storable loaded ok Going to read /root/.cpan/Metadata Warning: Found only 0 objects in /root/.cpan/Metadata CPAN: LWP::UserAgent loaded ok Fetching with LWP: ftp://ftp.perl.org/pub/CPAN/authors/01mailrc.txt.gz Going to read /root/.cpan/sources/authors/01mailrc.txt.gz CPAN: Compress::Zlib loaded ok Fetching with LWP: ftp://ftp.perl.org/pub/CPAN/modules/02packages.details.txt.gz Going to read /root/.cpan/sources/modules/02packages.details.txt.gz Database was generated on Thu, 28 Nov 2013 08:17:03 GMT There's a new CPAN.pm version (v2.00) available! [Current version is v1.7602] You might want to try install Bundle::CPAN reload cpan without quitting the current session. It should be a seamless upgrade while we are running... Fetching with LWP: ftp://ftp.perl.org/pub/CPAN/modules/03modlist.data.gz Going to read /root/.cpan/sources/modules/03modlist.data.gz Going to write /root/.cpan/Metadata Running install for module Text::CSV_XS Running make for H/HM/HMBRAND/Text-CSV_XS-1.02.tgz Fetching with LWP: ftp://ftp.perl.org/pub/CPAN/authors/id/H/HM/HMBRAND/Text-CSV_XS-1.02.tgz CPAN: Digest::MD5 loaded ok Fetching with LWP: ftp://ftp.perl.org/pub/CPAN/authors/id/H/HM/HMBRAND/CHECKSUMS Checksum for /root/.cpan/sources/authors/id/H/HM/HMBRAND/Text-CSV_XS-1.02.tgz ok Scanning cache /root/.cpan/build for sizes Text-CSV_XS-1.02/ Text-CSV_XS-1.02/examples/ Text-CSV_XS-1.02/examples/parser-xs.pl Text-CSV_XS-1.02/examples/speed.pl Text-CSV_XS-1.02/examples/csv2xls Text-CSV_XS-1.02/examples/csvdiff Text-CSV_XS-1.02/examples/csv-check Text-CSV_XS-1.02/ChangeLog Text-CSV_XS-1.02/META.yml Text-CSV_XS-1.02/MANIFEST Text-CSV_XS-1.02/ppport.h Text-CSV_XS-1.02/Makefile.PL Text-CSV_XS-1.02/CSV_XS.xs Text-CSV_XS-1.02/files/ Text-CSV_XS-1.02/files/macosx.csv Text-CSV_XS-1.02/files/utf8.csv Text-CSV_XS-1.02/README Text-CSV_XS-1.02/META.json Text-CSV_XS-1.02/t/ Text-CSV_XS-1.02/t/46_eol_si.t Text-CSV_XS-1.02/t/20_file.t Text-CSV_XS-1.02/t/76_magic.t Text-CSV_XS-1.02/t/81_subclass.t Text-CSV_XS-1.02/t/util.pl Text-CSV_XS-1.02/t/40_misc.t Text-CSV_XS-1.02/t/70_rt.t Text-CSV_XS-1.02/t/22_scalario.t Text-CSV_XS-1.02/t/21_lexicalio.t Text-CSV_XS-1.02/t/77_getall.t Text-CSV_XS-1.02/t/12_acc.t Text-CSV_XS-1.02/t/00_pod.t Text-CSV_XS-1.02/t/60_samples.t Text-CSV_XS-1.02/t/01_pod.t Text-CSV_XS-1.02/t/75_hashref.t Text-CSV_XS-1.02/t/65_allow.t Text-CSV_XS-1.02/t/50_utf8.t Text-CSV_XS-1.02/t/41_null.t Text-CSV_XS-1.02/t/30_types.t Text-CSV_XS-1.02/t/51_utf8.t Text-CSV_XS-1.02/t/10_base.t Text-CSV_XS-1.02/t/55_combi.t Text-CSV_XS-1.02/t/80_diag.t Text-CSV_XS-1.02/t/45_eol.t Text-CSV_XS-1.02/t/15_flags.t Text-CSV_XS-1.02/CSV_XS.pm CPAN.pm: Going to build H/HM/HMBRAND/Text-CSV_XS-1.02.tgz Checking if your kit is complete... Looks good Writing Makefile for Text::CSV_XS cp CSV_XS.pm blib/lib/Text/CSV_XS.pm /usr/bin/perl /usr/lib/perl5/5.8.8/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.8.8/ExtUtils/typemap CSV_XS.xs > CSV_XS.xsc && mv CSV_XS.xsc CSV_XS.c gcc -c -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -DVERSION=\"1.02\" -DXS_VERSION=\"1.02\" -fPIC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE" CSV_XS.c CSV_XS.xs: In function 'cx_Print': CSV_XS.xs:627: warning: unused variable 'l' CSV_XS.xs: In function 'cx_c_xsParse': CSV_XS.xs:1450: warning: unused variable 'sp' CSV_XS.c: In function 'XS_Text__CSV_XS_error_input': CSV_XS.xs:1665: warning: unused variable 'hv' CSV_XS.c: At top level: CSV_XS.xs:1546: warning: 'cx_av_free' defined but not used Running Mkbootstrap for Text::CSV_XS () chmod 644 CSV_XS.bs rm -f blib/arch/auto/Text/CSV_XS/CSV_XS.so gcc -shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-
Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger
On Wed, Jul 26, 2017 at 2:01 PM, PAWAN SHARMA wrote: > For root user its working fine > > [root@abc :/opt/PostgreSQL/9.5/data/pgaudit]# > #-> pgbadger -f stderr postgres-2017-07-26_00.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. There is no way to be sure what's wrong as this depends on the environment you are using and the packaging system that you have, but at short glance, I think that you should first try to update PERL5LIB so as it points to the location where the module has been installed. Good luck! It does not sound complicated to me to address anyway. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger
On Wed, Jul 26, 2017 at 3:18 PM, PAWAN SHARMA wrote: > > On Wed, Jul 26, 2017 at 2:42 PM, Michael Paquier < > michael.paqu...@gmail.com> wrote: > >> On Wed, Jul 26, 2017 at 10:59 AM, PAWAN SHARMA >> 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_XS > Reading '/root/.cpan/Metadata' > Database was generated on Wed, 26 Jul 2017 09:17:02 GMT > Running install for module 'Text::CSV_XS' > Running make for H/HM/HMBRAND/Text-CSV_XS-1.31.tgz > Fetching with HTTP::Tiny: > http://mirror.liquidtelecom.com/CPAN/authors/id/H/HM/ > HMBRAND/Text-CSV_XS-1.31.tgz > Fetching with HTTP::Tiny: > http://mirror.liquidtelecom.com/CPAN/authors/id/H/HM/HMBRAND/CHECKSUMS > 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 good > Generating a Unix-style Makefile > Writing Makefile for Text::CSV_XS > Writing MYMETA.yml and MYMETA.json > cp CSV_XS.pm blib/lib/Text/CSV_XS.pm > Running 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.c > gcc -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.c > rm -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 document > HMBRAND/Text-CSV_XS-1.31.tgz > /bin/make -- OK > 'YAML' not installed, will not store persistent state > Running 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/*.t > t/00_pod.t skipped: Test::Pod 1.00 required for testing POD > t/01_pod.t skipped: Test::Pod::Coverage required for testing POD > Coverage > t/10_base.t ... ok > t/12_acc.t ok > t/15_flags.t .. ok > t/20_file.t ... ok > t/21_lexicalio.t .. ok > t/22_scalario.t ... ok > t/30_types.t .. ok > t/40_misc.t ... ok > t/41_null.t ... ok > t/45_eol.t ok > t/46_eol_si.t . ok > t/50_utf8.t ... ok > t/51_utf8.t ... ok > t/55_combi.t .. ok > t/60_samples.t ok > t/65_allow.t .. ok > t/70_rt.t . ok > t/75_hashref.t ok > t/76_magic.t .. ok > t/77_getall.t . ok > t/78_fragment.t ... ok > t/79_callbacks.t .. ok > t/80_diag.t ... ok > t/81_subclass.t ... ok > t/85_util.t ... ok > t/90_csv.t ok > t/91_csv_cb.t . ok > All 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: PASS > HMBRAND/Text-CSV_XS-1.31.tgz > /bin/make test -- OK > Running 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 document > Files found in blib/arch: installing files in blib/lib into architecture > dependent library tree > Installing /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:
Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger
On Wed, Jul 26, 2017 at 2:42 PM, Michael Paquier wrote: > On Wed, Jul 26, 2017 at 10:59 AM, PAWAN SHARMA > 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_XS Reading '/root/.cpan/Metadata' Database was generated on Wed, 26 Jul 2017 09:17:02 GMT Running install for module 'Text::CSV_XS' Running make for H/HM/HMBRAND/Text-CSV_XS-1.31.tgz Fetching with HTTP::Tiny: http://mirror.liquidtelecom.com/CPAN/authors/id/H/HM/HMBRAND/Text-CSV_XS-1.31.tgz Fetching with HTTP::Tiny: http://mirror.liquidtelecom.com/CPAN/authors/id/H/HM/HMBRAND/CHECKSUMS 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 good Generating a Unix-style Makefile Writing Makefile for Text::CSV_XS Writing MYMETA.yml and MYMETA.json cp CSV_XS.pm blib/lib/Text/CSV_XS.pm Running 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.c gcc -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.c rm -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 document HMBRAND/Text-CSV_XS-1.31.tgz /bin/make -- OK 'YAML' not installed, will not store persistent state Running 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/*.t t/00_pod.t skipped: Test::Pod 1.00 required for testing POD t/01_pod.t skipped: Test::Pod::Coverage required for testing POD Coverage t/10_base.t ... ok t/12_acc.t ok t/15_flags.t .. ok t/20_file.t ... ok t/21_lexicalio.t .. ok t/22_scalario.t ... ok t/30_types.t .. ok t/40_misc.t ... ok t/41_null.t ... ok t/45_eol.t ok t/46_eol_si.t . ok t/50_utf8.t ... ok t/51_utf8.t ... ok t/55_combi.t .. ok t/60_samples.t ok t/65_allow.t .. ok t/70_rt.t . ok t/75_hashref.t ok t/76_magic.t .. ok t/77_getall.t . ok t/78_fragment.t ... ok t/79_callbacks.t .. ok t/80_diag.t ... ok t/81_subclass.t ... ok t/85_util.t ... ok t/90_csv.t ok t/91_csv_cb.t . ok All 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: PASS HMBRAND/Text-CSV_XS-1.31.tgz /bin/make test -- OK Running 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 document Files found in blib/arch: installing files in blib/lib into architecture dependent library tree Installing /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 -- OK cpan[2]> quit Terminal does not support GetHistory. Lockfile removed. [root@abc:/home/psharm89]# #-> rpm -qa | grep perl-CPAN perl-CPAN-1.9800-286.el7.noarch [postgre
Re: [GENERAL] Fwd: getting error while parsing log file using pgbadger
On Wed, Jul 26, 2017 at 10:59 AM, PAWAN SHARMA 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Fwd: getting error while parsing log file using pgbadger
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..!! -Pawan