Deployment and reports: Libreoffice not found

deployment
reporting-addon

(Riccardo P.) #1

Hi to all,

I have problems with Yarg/Libreoffice.
I created a new vm for production (debian 9), installed tomcat8, libreoffice 5.2.7.2, db, ecc.
Everything works fine except reports. The error is “Couldn’t find openoffice instance”.
I checked the application.properties inside the app-core-xxx-SNAPSHOT.jar and I have

reporting.displayDeviceUnavailable = true
reporting.openoffice.path = /usr/lib/libreoffice/program  --- also added a final / with no success

the output of the ls -l command on /usr/lib/libreoffice/program is

kosmos@prod:~$ ls -l /usr/lib/libreoffice/program/
total 205800
-rw-r--r--  1 root root     1963 May  4  2017 JREProperties.class
drwxr-xr-x  2 root root     4096 Nov  3 13:04 __pycache__
-rw-r--r--  1 root root      185 May  4  2017 bootstraprc
drwxr-xr-x  2 root root     4096 Nov  3 12:59 classes
-rw-r--r--  1 root root   812578 Apr 25  2017 flat_logo.svg
-rw-r--r--  1 root root     2247 May  4  2017 fundamentalrc
-rw-r--r--  1 root root      334 Apr 25  2017 gdbtrace
-rw-r--r--  1 root root    16241 Apr 25  2017 intro.png
-rwxr-xr-x  1 root root     2023 May  4  2017 java-set-classpath
-rwxr-xr-x  1 root root    10672 May  4  2017 javaldx
-rw-r--r--  1 root root     1676 Apr 25  2017 javavendors.xml
-rw-r--r--  1 root root      247 May  4  2017 jvmfwk3rc
-rw-r--r--  1 root root   216320 May  4  2017 libOGLTranslo.so
-rw-r--r--  1 root root   429480 May  4  2017 libPresentationMinimizerlo.so
-rw-r--r--  1 root root  1046312 May  4  2017 libPresenterScreenlo.so
-rw-r--r--  1 root root   196600 May  4  2017 libabplo.so
-rw-r--r--  1 root root  1348040 May  4  2017 libacclo.so
-rw-r--r--  1 root root    14720 May  4  2017 libaffine_uno_uno.so
-rw-r--r--  1 root root   310448 May  4  2017 libanalysislo.so
-rw-r--r--  1 root root   150320 May  4  2017 libanimcorelo.so
-rw-r--r--  1 root root    77512 May  4  2017 libavmediagst.so
-rw-r--r--  1 root root    65000 May  4  2017 libavmediaogl.so
-rw-r--r--  1 root root  1419712 May  4  2017 libbasctllo.so
-rw-r--r--  1 root root   134776 May  4  2017 libbasprovlo.so
-rw-r--r--  1 root root   418904 May  4  2017 libbiblo.so
-rw-r--r--  1 root root   163352 May  4  2017 libbinaryurplo.so
-rw-r--r--  1 root root   455528 May  4  2017 libbootstraplo.so
-rw-r--r--  1 root root   306088 May  4  2017 libcached1.so
-rw-r--r--  1 root root   636744 May  4  2017 libcairocanvaslo.so
-rw-r--r--  1 root root   303576 May  4  2017 libcalclo.so
-rw-r--r--  1 root root    60152 May  4  2017 libcanvasfactorylo.so
-rw-r--r--  1 root root  2711160 May  4  2017 libchartcontrollerlo.so
-rw-r--r--  1 root root  3477400 May  4  2017 libchartcorelo.so
-rw-r--r--  1 root root   253648 May  4  2017 libchartopengllo.so
-rw-r--r--  1 root root    18544 May  4  2017 libclewlo.so
-rw-r--r--  1 root root    64448 May  4  2017 libcmdmaillo.so
-rw-r--r--  1 root root  1365944 May  4  2017 libcollator_data.so
-rw-r--r--  1 root root   216016 May  4  2017 libctllo.so
-rw-r--r--  1 root root  4137824 May  4  2017 libcuilo.so
-rw-r--r--  1 root root    72576 May  4  2017 libdatelo.so
-rw-r--r--  1 root root  2630552 May  4  2017 libdbalo.so
-rw-r--r--  1 root root   464480 May  4  2017 libdbaselo.so
-rw-r--r--  1 root root   381592 May  4  2017 libdbaxmllo.so
-rw-r--r--  1 root root   237400 May  4  2017 libdbmmlo.so
-rw-r--r--  1 root root   282192 May  4  2017 libdbplo.so
-rw-r--r--  1 root root   150872 May  4  2017 libdbpool2.so
-rw-r--r--  1 root root  4418616 May  4  2017 libdbulo.so
-rw-r--r--  1 root root   468328 May  4  2017 libdeploymentgui.so
-rw-r--r--  1 root root  1054648 May  4  2017 libdict_ja.so
-rw-r--r--  1 root root  2267064 May  4  2017 libdict_zh.so
-rw-r--r--  1 root root   167488 May  4  2017 libdlgprovlo.so
-rw-r--r--  1 root root   384648 May  4  2017 libembobj.so
-rw-r--r--  1 root root   240936 May  4  2017 libemboleobj.so
-rw-r--r--  1 root root    93088 May  4  2017 libevtattlo.so
-rw-r--r--  1 root root   192360 May  4  2017 libexpwraplo.so
-rw-r--r--  1 root root   616232 May  4  2017 libfilelo.so
-rw-r--r--  1 root root   242248 May  4  2017 libflashlo.so
-rw-r--r--  1 root root   307736 May  4  2017 libflatlo.so
-rw-r--r--  1 root root   163040 May  4  2017 libforlo.so
-rw-r--r--  1 root root   200360 May  4  2017 libforuilo.so
-rw-r--r--  1 root root   456376 May  4  2017 libfps_officelo.so
-rw-r--r--  1 root root  2862344 May  4  2017 libfrmlo.so
-rw-r--r--  1 root root   365544 May  4  2017 libfwllo.so
-rw-r--r--  1 root root   183720 May  4  2017 libfwmlo.so
-rw-r--r--  1 root root    60416 May  4  2017 libgcc3_uno.so
-rw-r--r--  1 root root   328632 May  4  2017 libgielo.so
-rw-r--r--  1 root root    85272 May  4  2017 libgraphicfilterlo.so
-rw-r--r--  1 root root    43848 May  4  2017 libguesslanglo.so
-rw-r--r--  1 root root   354568 May  4  2017 libhsqldb.so
-rw-r--r--  1 root root   487152 May  4  2017 libhwplo.so
-rw-r--r--  1 root root    64824 May  4  2017 libhyphenlo.so
-rw-r--r--  1 root root    76696 May  4  2017 libi18nsearchlo.so
-rw-r--r--  1 root root   121760 May  4  2017 libicglo.so
-rw-r--r--  1 root root   534872 May  4  2017 libindex_data.so
-rw-r--r--  1 root root   167128 May  4  2017 libintrospectionlo.so
-rw-r--r--  1 root root    43840 May  4  2017 libinvocadaptlo.so
-rw-r--r--  1 root root   105240 May  4  2017 libinvocationlo.so
-rw-r--r--  1 root root   258920 May  4  2017 libiolo.so
-rw-r--r--  1 root root   117696 May  4  2017 libjava_uno.so
-rw-r--r--  1 root root    43744 May  4  2017 libjavaloaderlo.so
-rw-r--r--  1 root root   134656 May  4  2017 libjavavmlo.so
-rw-r--r--  1 root root   500312 May  4  2017 libjdbclo.so
-rw-r--r--  1 root root    10344 May  4  2017 libjpipe.so
-rw-r--r--  1 root root    10392 May  4  2017 libjuh.so
-rw-r--r--  1 root root    60160 May  4  2017 libjuhx.so
-rw-r--r--  1 root root    27128 May  4  2017 libjvmaccesslo.so
-rw-r--r--  1 root root   151808 May  4  2017 libjvmfwklo.so
-rw-r--r--  1 root root    60408 May  4  2017 libldapbe2lo.so
-rw-r--r--  1 root root    73032 May  4  2017 liblnthlo.so
-rw-r--r--  1 root root   317928 May  4  2017 liblocaledata_en.so
-rw-r--r--  1 root root   278152 May  4  2017 liblocaledata_es.so
-rw-r--r--  1 root root  2386312 May  4  2017 liblocaledata_euro.so
-rw-r--r--  1 root root  3423240 May  4  2017 liblocaledata_others.so
-rw-r--r--  1 root root    14680 May  4  2017 liblog_uno_uno.so
-rw-r--r--  1 root root   130696 May  4  2017 libloglo.so
-rw-r--r--  1 root root  1015440 May  4  2017 liblwpftlo.so
-rw-r--r--  1 root root 69854048 May  4  2017 libmergedlo.so
-rw-r--r--  1 root root    60648 May  4  2017 libmigrationoo2lo.so
-rw-r--r--  1 root root    56360 May  4  2017 libmigrationoo3lo.so
-rw-r--r--  1 root root   435784 May  4  2017 libmorklo.so
-rw-r--r--  1 root root    48056 May  4  2017 libmozbootstraplo.so
-rw-r--r--  1 root root   480472 May  4  2017 libmsformslo.so
-rw-r--r--  1 root root  2117088 May  4  2017 libmswordlo.so
-rw-r--r--  1 root root    35592 May  4  2017 libmtfrendererlo.so
-rw-r--r--  1 root root   221272 May  4  2017 libmysqllo.so
-rw-r--r--  1 root root    23152 May  4  2017 libnamingservicelo.so
-rw-r--r--  1 root root   603112 May  4  2017 libodbclo.so
-rw-r--r--  1 root root    35520 May  4  2017 libodfflatxmllo.so
-rw-r--r--  1 root root    43920 May  4  2017 liboffacclo.so
-rw-r--r--  1 root root   352632 May  4  2017 liboglcanvaslo.so
-rw-r--r--  1 root root  4388312 May  4  2017 libooxlo.so
-rw-r--r--  1 root root   109752 May  4  2017 libpasswordcontainerlo.so
-rw-r--r--  1 root root  1491896 May  4  2017 libpcrlo.so
-rw-r--r--  1 root root   279080 May  4  2017 libpdffilterlo.so
-rw-r--r--  1 root root   467656 May  4  2017 libpdfimportlo.so
-rw-r--r--  1 root root    72648 May  4  2017 libplacewarelo.so
-rw-r--r--  1 root root   874936 May  4  2017 libpostgresql-sdbc-impllo.so
-rw-r--r--  1 root root    47856 May  4  2017 libpostgresql-sdbclo.so
-rw-r--r--  1 root root    93056 May  4  2017 libpricinglo.so
-rw-r--r--  1 root root    47976 May  4  2017 libprotocolhandlerlo.so
-rw-r--r--  1 root root    31480 May  4  2017 libproxyfaclo.so
-rw-r--r--  1 root root    23328 May  4  2017 libpythonloaderlo.so
-rw-r--r--  1 root root   257744 May  4  2017 libpyuno.so
-rw-r--r--  1 root root    47864 May  4  2017 librecentfile.so
-rw-r--r--  1 root root   167040 May  4  2017 libreflectionlo.so
-rw-r--r--  1 root root   101448 May  4  2017 libreglo.so
-rw-r--r--  1 root root    89368 May  4  2017 libreslo.so
-rw-r--r--  1 root root  1437112 May  4  2017 librptlo.so
-rw-r--r--  1 root root  1273656 May  4  2017 librptuilo.so
-rw-r--r--  1 root root   411320 May  4  2017 librptxmllo.so
-rw-r--r--  1 root root  1693824 May  4  2017 libsal_textenclo.so
-rw-r--r--  1 root root    35672 May  4  2017 libscdlo.so
-rw-r--r--  1 root root  4595016 May  4  2017 libscfiltlo.so
-rw-r--r--  1 root root 15688800 May  4  2017 libsclo.so
-rw-r--r--  1 root root   151544 May  4  2017 libscnlo.so
-rw-r--r--  1 root root   200184 May  4  2017 libscriptframe.so
-rw-r--r--  1 root root   924704 May  4  2017 libscuilo.so
-rw-r--r--  1 root root    89008 May  4  2017 libsdbc2.so
-rw-r--r--  1 root root   117992 May  4  2017 libsdbtlo.so
-rw-r--r--  1 root root    31640 May  4  2017 libsddlo.so
-rw-r--r--  1 root root   568256 May  4  2017 libsdfiltlo.so
-rw-r--r--  1 root root  6973432 May  4  2017 libsdlo.so
-rw-r--r--  1 root root   688104 May  4  2017 libsduilo.so
-rw-r--r--  1 root root    64320 May  4  2017 libsimplecanvaslo.so
-rw-r--r--  1 root root  1795272 May  4  2017 libslideshowlo.so
-rw-r--r--  1 root root    27440 May  4  2017 libsmdlo.so
-rw-r--r--  1 root root  1268680 May  4  2017 libsmlo.so
-rw-r--r--  1 root root    76912 May  4  2017 libsolverlo.so
-rw-r--r--  1 root root    64792 May  4  2017 libspelllo.so
-rw-r--r--  1 root root   142720 May  4  2017 libsrtrs1.so
-rw-r--r--  1 root root   114152 May  4  2017 libstocserviceslo.so
-rw-r--r--  1 root root    47992 May  4  2017 libstoragefdlo.so
-rw-r--r--  1 root root   109104 May  4  2017 libstorelo.so
-rw-r--r--  1 root root   167168 May  4  2017 libstringresourcelo.so
-rw-r--r--  1 root root   886608 May  4  2017 libsvgfilterlo.so
-rw-r--r--  1 root root   299064 May  4  2017 libsvgiolo.so
-rw-r--r--  1 root root    27408 May  4  2017 libswdlo.so
-rw-r--r--  1 root root 15501456 May  4  2017 libswlo.so
-rw-r--r--  1 root root  2736208 May  4  2017 libswuilo.so
-rw-r--r--  1 root root    35584 May  4  2017 libsysshlo.so
-rw-r--r--  1 root root   118648 May  4  2017 libt602filterlo.so
-rw-r--r--  1 root root   231352 May  4  2017 libtextconv_dict.so
-rw-r--r--  1 root root   126264 May  4  2017 libtextconversiondlgslo.so
-rw-r--r--  1 root root    35776 May  4  2017 libtextfdlo.so
-rw-r--r--  1 root root   425992 May  4  2017 libucpchelp1.so
-rw-r--r--  1 root root   278208 May  4  2017 libucpcmis1lo.so
-rw-r--r--  1 root root   377296 May  4  2017 libucpdav1.so
-rw-r--r--  1 root root    97408 May  4  2017 libucpextlo.so
-rw-r--r--  1 root root   237176 May  4  2017 libucpftp1.so
-rw-r--r--  1 root root   294272 May  4  2017 libucphier1.so
-rw-r--r--  1 root root    35584 May  4  2017 libucpimagelo.so
-rw-r--r--  1 root root   204152 May  4  2017 libucppkg1.so
-rw-r--r--  1 root root   327760 May  4  2017 libucptdoc1lo.so
-rw-r--r--  1 root root   232536 May  4  2017 libuno_cppu.so.3
-rw-r--r--  1 root root   944040 May  4  2017 libuno_cppuhelpergcc3.so.3
-rw-r--r--  1 root root    22960 May  4  2017 libuno_purpenvhelpergcc3.so.3
-rw-r--r--  1 root root   332240 May  4  2017 libuno_sal.so.3
-rw-r--r--  1 root root    27232 May  4  2017 libuno_salhelpergcc3.so.3
-rw-r--r--  1 root root   400448 May  4  2017 libunoidllo.so
-rw-r--r--  1 root root   105816 May  4  2017 libunopkgapp.so
-rw-r--r--  1 root root   196560 May  4  2017 libunordflo.so
-rw-r--r--  1 root root    10496 May  4  2017 libunsafe_uno_uno.so
-rw-r--r--  1 root root    85000 May  4  2017 libupdatefeedlo.so
-rw-r--r--  1 root root    31400 May  4  2017 libuuresolverlo.so
-rw-r--r--  1 root root   118168 May  4  2017 libvbaeventslo.so
-rw-r--r--  1 root root   914968 May  4  2017 libvbahelperlo.so
-rw-r--r--  1 root root  2349656 May  4  2017 libvbaobjlo.so
-rw-r--r--  1 root root  1996088 May  4  2017 libvbaswobjlo.so
-rw-r--r--  1 root root   665576 May  4  2017 libvclcanvaslo.so
-rw-r--r--  1 root root   623592 May  4  2017 libvclplug_genlo.so
-rw-r--r--  1 root root   637568 May  4  2017 libvclplug_gtklo.so
-rw-r--r--  1 root root    56432 May  4  2017 libwpftcalclo.so
-rw-r--r--  1 root root    76904 May  4  2017 libwpftdrawlo.so
-rw-r--r--  1 root root    68712 May  4  2017 libwpftimpresslo.so
-rw-r--r--  1 root root    89592 May  4  2017 libwpftwriterlo.so
-rw-r--r--  1 root root  2292408 May  4  2017 libwriterfilterlo.so
-rw-r--r--  1 root root    85008 May  4  2017 libwriterperfectlo.so
-rw-r--r--  1 root root    60304 May  4  2017 libxmlfalo.so
-rw-r--r--  1 root root    47888 May  4  2017 libxmlfdlo.so
-rw-r--r--  1 root root    47608 May  4  2017 libxmlreaderlo.so
-rw-r--r--  1 root root   480136 May  4  2017 libxmlsecurity.so
-rw-r--r--  1 root root   317128 May  4  2017 libxoflo.so
-rw-r--r--  1 root root   147176 May  4  2017 libxsec_fw.so
-rw-r--r--  1 root root   739648 May  4  2017 libxsec_xmlsec.so
-rw-r--r--  1 root root   307352 May  4  2017 libxsltdlglo.so
-rw-r--r--  1 root root   126584 May  4  2017 libxsltfilterlo.so
-rw-r--r--  1 root root     1059 May  4  2017 lounorc
-rw-r--r--  1 root root    17894 Apr 25  2017 mailmerge.py
-rw-r--r--  1 root root     8473 Apr 25  2017 msgbox.py
-rw-r--r--  1 root root     3166 Apr 25  2017 officehelper.py
-rwxr-xr-x  1 root root    40216 May  4  2017 oosplash
drwxr-xr-x  2 root root     4096 Nov  3 12:58 opencl
drwxr-xr-x  2 root root     4096 Nov  3 13:00 opengl
-rw-r--r--  1 root root       24 May  4  2017 pagein-calc
-rw-r--r--  1 root root      262 May  4  2017 pagein-common
-rw-r--r--  1 root root       24 May  4  2017 pagein-draw
-rw-r--r--  1 root root       24 May  4  2017 pagein-impress
-rw-r--r--  1 root root       24 May  4  2017 pagein-writer
-rw-r--r--  1 root root       29 Apr 25  2017 postgresql-sdbc.ini
-rw-r--r--  1 root root     6866 Apr 25  2017 pythonloader.py
-rw-r--r--  1 root root      181 May  4  2017 pythonloader.unorc
-rw-r--r--  1 root root    39968 Apr 25  2017 pythonscript.py
-rw-r--r--  1 root root     6240 May  4  2017 pyuno.so
-rw-r--r--  1 root root       50 May  4  2017 redirectrc
-rwxr-xr-x  1 root root    19032 May  4  2017 regmerge
-rwxr-xr-x  1 root root    10696 May  4  2017 regview
drwxr-xr-x  2 root root     4096 Nov  3 12:58 resource
-rwxr-xr-x  1 root root       62 Apr 25  2017 sbase
-rwxr-xr-x  1 root root       62 Apr 25  2017 scalc
-rwxr-xr-x  1 root root       62 Apr 25  2017 sdraw
-rwxr-xr-x  1 root root    14014 May  4  2017 senddoc
drwxr-xr-x  2 root root     4096 Nov  3 12:59 services
-rw-r--r--  1 root root     8690 May  4  2017 services.rdb
-rw-r--r--  1 root root       34 May  4  2017 setuprc
drwxr-xr-x  2 root root     4096 Nov  3 12:58 shell
-rwxr-xr-x  1 root root       65 Apr 25  2017 simpress
-rwxr-xr-x  1 root root       62 Apr 25  2017 smath
-rwxr-xr-x  1 root root     5875 May  4  2017 soffice
-rwxr-xr-x  1 root root     6328 May  4  2017 soffice.bin
-rw-r--r--  1 root root      789 May  4  2017 sofficerc
-rwxr-xr-x  1 root root       64 Apr 25  2017 swriter
drwxr-xr-x  2 root root     4096 Nov  3 12:58 types
-rw-r--r--  1 root root    57362 May  4  2017 types.rdb
-rwxr-xr-x  1 root root     1508 Apr 25  2017 uno
-rwxr-xr-x  1 root root    72712 May  4  2017 uno.bin
-rwxr-xr-x  1 root root     1335 Apr 25  2017 unoinfo
-rwxr-xr-x  1 root root     2996 May  4  2017 unopkg
-rwxr-xr-x  1 root root     6328 May  4  2017 unopkg.bin
-rw-r--r--  1 root root      239 May  4  2017 unorc
-rwxr-xr-x  1 root root     6360 May  4  2017 uri-encode
-rw-r--r--  1 root root      960 May  4  2017 versionrc
drwxr-xr-x 10 root root     4096 Nov  3 12:58 wizards
-rwxr-xr-x  1 root root     6336 May  4  2017 xid-fullscreen-on-all-monitors
-rwxr-xr-x  1 root root    47928 May  4  2017 xpdfimport

Also checked the command line

strace -e trace=signal /usr/lib/libreoffice/program/soffice.bin --headless --accept="socket,host=localhost,port=8100;urp" --nologo --nolockcheck

I don’t know if the output is right or wrong because the documentation doensn’t show the correct output.

kosmos@prod:~$ strace -e trace=signal /usr/lib/libreoffice/program/soffice.bin --headless --accept="socket,host=localhost,port=8100;urp" --nologo --nolockcheck
rt_sigaction(SIGRTMIN, {sa_handler=0x7f29b0075bd0, sa_mask=[], sa_flags=SA_RESTORER|SA_SIGINFO, sa_restorer=0x7f29b00810c0}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {sa_handler=0x7f29b0075c60, sa_mask=[], sa_flags=SA_RESTORER|SA_RESTART|SA_SIGINFO, sa_restorer=0x7f29b00810c0}, NULL, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
--- SIGCHLD {si_signo=SIGCHLD, si_code=CLD_EXITED, si_pid=5212, si_uid=1000, si_status=1, si_utime=0, si_stime=0} ---
rt_sigaction(SIGHUP, {sa_handler=SIG_IGN, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGINT, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGQUIT, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGTRAP, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGABRT, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGFPE, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGBUS, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGSEGV, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGSYS, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGPIPE, {sa_handler=SIG_IGN, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGALRM, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGTERM, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGPWR, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGWINCH, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGURG, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGIO, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGVTALRM, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGXCPU, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGXFSZ, {sa_handler=0x7f29b28fb4b0, sa_mask=~[RTMIN RT_1], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f29b2556030}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigaction(SIGXFSZ, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGXCPU, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGVTALRM, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGIO, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGURG, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGWINCH, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGPWR, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGTERM, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGALRM, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGPIPE, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGSYS, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGSEGV, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGBUS, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGFPE, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGABRT, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGTRAP, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGQUIT, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGINT, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
rt_sigaction(SIGHUP, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=SA_RESTORER, sa_restorer=0x7f29b2556030}, NULL, 8) = 0
+++ exited with 0 +++
kosmos@imi-prod:~$ 

The application log says

Caused by: com.haulmont.reports.exception.FailedToConnectToOpenOfficeException: Unable to create Open office components. Report name [Preventivo]
    at com.haulmont.reports.ReportingBean.createReportDocument(ReportingBean.java:277)
    at com.haulmont.reports.ReportingBean.createReport(ReportingBean.java:175)
    at com.haulmont.reports.ReportServiceBean.createReport(ReportServiceBean.java:35)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)

What else can I check to get reports work?

Thank you
Riccardo


(Andrey Subbotin) #3

Hi Riccardo,

I tried to reproduce the problem on Ubuntu and Debian 9. Conversation from Excel to PDF using Open Office works correctly without errors.
I created sample project on Debian 9 using CUBA Studio with Reporting module and ran it.

Could you provide sample application? Do use WAR build or docker for deployment?

Thanks.


(Riccardo P.) #4

Hi Andrey,

At the moment I can’t provide a sample application, if you want I can send you (in private) the full application I’m developing, since there are no top secret issues and/or If you want I can share with you the entire vm since I have 20Mbit upload speed dsl and the file is not so big (~2.4 Gb)

I didn’t use excel as report source, but an odt file generated with “libreoffice writer”. I created a report with the correct fields and uploaded it as “default template”. I selected pdf as output type (you already catched this)

I deployed the project using the war build, compiling the war with the ./gradlew buildwar command.

The war-contex.xml file is this

<!-- Database connection -->
<Resource
  name="jdbc/CubaDS"
  type="javax.sql.DataSource"
  maxTotal="20"
  maxIdle="2"
  maxWaitMillis="5000"
  driverClassName="org.postgresql.Driver"
  url="jdbc:postgresql://localhost/kgest"
  username="postgres"
  password="kosmos2017.."/>

<!-- Switch off session serialization -->
<Manager pathname=""/>

and the single-war-web.xml is this

<?xml version="1.0" encoding="UTF-8"?>

<!-- Web Client parameters -->

<context-param>
    <description>List of app properties files for Web Client</description>
    <param-name>appPropertiesConfigWeb</param-name>
    <param-value>
        
        classpath:eu/kosmostech/kgest/web-app.properties
        /WEB-INF/local.app.properties
    </param-value>
</context-param>

<context-param>
    <description>Web resources version for correct caching in browser</description>
    <param-name>webResourcesTs</param-name>
    <param-value>${webResourcesTs}</param-value>
</context-param>


<!-- Middleware parameters -->

<context-param>
    <description>List of app properties files for Middleware</description>
    <param-name>appPropertiesConfigCore</param-name>
    <param-value>
        
        classpath:eu/kosmostech/kgest/app.properties
        /WEB-INF/local.app.properties
    </param-value>
</context-param>
<!--Application components-->
<context-param>
    <param-name>appComponents</param-name>
    <param-value>com.haulmont.cuba com.haulmont.reports</param-value>
</context-param>

<!-- Servlet context listeners that load the application blocks -->

<listener>
    <listener-class>com.vaadin.server.communication.JSR356WebsocketInitializer</listener-class>
</listener>
<listener>
    <listener-class>com.haulmont.cuba.core.sys.singleapp.SingleAppCoreServletListener</listener-class>
</listener>
<listener>
    <listener-class>com.haulmont.cuba.web.sys.singleapp.SingleAppWebServletListener</listener-class>
</listener>

Thank you very much
Riccardo


(Riccardo P.) #5

Hi Andrey
any news? I really can’t get reports work

Thanks
Riccardo


(Andrey Subbotin) #6

Hi Riccardo,

Also, I tried to reproduce the problem for WAR building and ODT template. It works fine.

Could you try to execute following sample reports:
XLSX to PDF.zip (5.9 KB)
ODT to DOC.zip (11.5 KB)

Please check LibreOffice path from application:
Open Administration -> JMX console, find app-core.cuba:type=ConfigStorage bean and execute getAppProperty method with parameter reporting.openoffice.path. What is the output of method execution?

Thanks,
Andrey Subbotin


(Riccardo P.) #7

Hi Andrey,

The invocation returns:

Operation invoked successfully with result:
reporting.openoffice.path=/usr/lib/libreoffice/program

I successfully imported both reports but they can’t run. The error is always the same “Couldn’t find openoffice instance”

I noticed that the output for the property reporting.openoffice.ports was null.
I set the value in the app.properties (then redeployed and checked):

Operation invoked successfully with result:
reporting.openoffice.ports=8100|8101|8102|8103

No luck unfortunately, reports are still not working

Thank you
Riccardo


(Andrey Subbotin) #8

Riccardo,

How did you install Tomcat? Did you install it from Debian repository?
For my tests, I used Tomcat from deploy directory in a sample project. I copied Tomcat to Linux VM.

Thank you,
Andrey


(Andrey Subbotin) #9

Riccardo,

I have reproduced the problem with Tomcat from Debian repository. The problem is related to permissions for LibreOffice.
Try to perform following steps in the terminal:

su
cd /var/lib/tomcat8
mkdir .cache
chown tomcat8:tomcat8 /var/lib/tomcat8/.cache

Copy folder content /root/.config/libreoffice to `/var/lib/tomcat8/.config/libreoffice’ and execute coomant in the terminal:

chown -R tomcat8:tomcat8 /var/lib/tomcat8/.config

Restart Tomcat service and try to print report.

Thank you,
Andrey


(Riccardo P.) #10

VERY VERY VERY WELL!

IT WORKS!

Maybe will you take into consideration adding this solution to the doc (on the Reporting/appendix A)?

Thank you very much!

Riccardo


(Andrey Subbotin) #11

Hi Riccardo,

We plan to test this case on Ubuntu with pre-installed Tomcat and update documentation.

Thanks,
Andrey Subbotin


(Ivan Rabkesov) #12

Done:slightly_smiling_face:

:speech_balloon: UPD: Sorry, the problem with pre-installed Tomcat on Ubuntu still persists, this part is missed in documentation. We are working on a solution.


(Michael Why) #13

I am having the same problem on MacOS using LibreOffice on my dev machine.

I followed these instructions to verify the reporting.openoffice.path exists in my app properties.

Open Administration -> JMX console, find app-core.cuba:type=ConfigStorage bean and execute getAppProperty method with parameter reporting.openoffice.path. What is the output of method execution?

The following shows LibreOffice has been installed.

$ ls /Applications/LibreOffice.App Contents

If possible, can you please provide the same instructions to fix MacOS LibreOffice for PDF output from an XLSX template.

Mike.


(Ramkumarvairavel612) #16

Hi Andrey,
I am also trying to creating report generation while using Cuba Platform.I would getting a only report structure Report for entity Contact (1).docx (5.6 KB)
only where i have to give a report template.And how to create a complete reporting. Please give some suggestion to me Andrey.
Thank you.


(Andrey Subbotin) #17

Do you use YARG directly or Reporting module?


(Ivan Rabkesov) #18

For Ubuntu, in case of the following error in logfile during report generating

no suitable windowing system found, exiting

check if these packages installed in the system:

sudo apt-get install libxt6
sudo apt-get install libxrender1

This should fix the problem.