openoffice integration
Hello All,
Have just had a bit of a tinker with using the openoffice forms/letters in openvpms. Up to now I have only used the jasperreports that ship with openvpms. Using 2.3.0.2
I seem to be failing at the first hurdle with openoffice though, getting the following error in the logs:
17 Oct 2022 14:11:58,172 ERROR AbstractOOConnectionPool,https-openssl-nio-8443-exec-4:198 - cwearne - Failed to allocate connection 21669: org.openvpms.report.openoffice.OpenOfficeConnectionException: Failed to connect to OpenOffice: failed to connect after 10 attempts 21670: at org.openvpms.report.openoffice.OOBootstrapService.start(OOBootstrapService.java:193) ~[openvpms-reports-2.3.0.2-SNAPSHOT.jar:2.3.0.2-SNAPSHOT]
OpenOffice is installed with its desktop-integration.
I'm hazarding a guess that my issue relates to the tomcat container running under user tomcat which is an unprivileged user with no home directory (for security reasons).
If anyone can point me in the right direction to resolve this without compromising server security I'd be much obliged!
Kind regards
Chris
Re: openoffice integration
Is OO running headless on the server?
Simon Slater
Registered Linux User #463789 @ http://linuxcounter.net
Re: openoffice integration
If the OpenOffice service is not running the tomcat container will launch it. It will be launched running as the same user thats running tomcat obviously. It does require a home directory
we have /usr/share/tomcat7 but anywhere will do - it doesnt really compromise security to allocate a home directory. Looking at our home directory there are a number of things cached there by tomcat.
Our server is headless - ie no GUI...Office runs headless.
You should confirm that Open is able to launch the process - basically I sudo in as the tomcat user and launch office by running soffice
Re: openoffice integration
Many thanks for the replies.
The reason for the tinkering was creating client and patient labels. I discovered to my amazement that I could not find an easy way for printing a patient label such to stick on a dog lead or a lab sample. I may be overlooking something as it seems like such a basic requirement. Same goes for a client address label to stick on a vaccination card.
I'll create a home directory for the tomcat user and see if that does the job. I hear you on the speed of openoffice Ben. I was just after an easy way of doing the job but I can see that the jasperReports is a more robust solution.
Chris
Re: openoffice integration
Just rejig the JRXML label files to create those custom labels we did it for laboratory sample labels - added a second label printer with a different size label just for that job.
Re: openoffice integration
Hi Ben,
I've got a patient label doing what I want now using jasper. Can I ask how you would trigger the printing process? At the moment I only know how to select the patient, create a new document 'Patient Label' and then print from there. Say a receptionist wants to quickly print a label to attach to a dog lead, what would be the most efficient way of doing this?
Kind regards
Chris
Re: openoffice integration
Out of interest - there isnt much that Jrxml files cant do. the Openoffice integration is slow. I would try and avoid it as much as possible for regular reports/forms and letters.
Re: openoffice integration
+1 for Bens comments. It can be a painful learning curve, but jreports is the way to go.
Matt