OpenOffice connection trouble

OpenOffice connection trouble

Postby mr.nightmare » Wed Mar 31, 2010 12:59 pm

Hello,

I installed the report_openoffice on ubu 9.10 / openerp 5.0.3 and got as far as the first report creation
When i click on the action button to create the pdf, i get this error :


Environment Information :
System : Linux-2.6.31-20-generic-i686-with-Ubuntu-9.10-karmic
OS Name : posix
Distributor ID: Ubuntu
Description: Ubuntu 9.10
Release: 9.10
Codename: karmic
Operating System Release : 2.6.31-20-generic
Operating System Version : #58-Ubuntu SMP Fri Mar 12 05:23:09 UTC 2010
Operating System Architecture : 32bit
Operating System Locale : fr_BE.UTF8
Python Version : 2.6.4
OpenERP-Client Version : 5.0.3
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
File "/usr/lib/openerp-server/service/web_services.py", line 687, in go
(result, format) = obj.create(cr, uid, ids, datas, context)
File "/usr/lib/openerp-server/addons/report_openoffice.zip/report_openoffice/report_openoffice.py", line 310, in create
return fnct(cr, uid, ids, data, report_xml, context)
File "/usr/lib/openerp-server/report/report_sxw.py", line 421, in create_source_pdf
return self.create_single_pdf(cr, uid, ids, data, report_xml, context)
File "/usr/lib/openerp-server/addons/report_openoffice.zip/report_openoffice/report_openoffice.py", line 215, in create_single_pdf
return self.create_relatorio_report(cr, uid, ids, data, report_xml, context=context, output='pdf')
File "/usr/lib/openerp-server/addons/report_openoffice.zip/report_openoffice/report_openoffice.py", line 198, in create_relatorio_report
DC = DocumentConverter(host, port)
File "/usr/lib/openerp-server/addons/report_openoffice.zip/report_openoffice/DocumentConverter.py", line 76, in __init__
raise DocumentConversionException, "Failed to connect to OpenOffice.org on port %s. %s" % (port, exception)
DocumentConversionException: Failed to connect to OpenOffice.org on port 8100. Connector : couldn't connect to socket (Success)


I've read in this forum that an OOo session has to already be open somewhere for the module to work but i get the same error after testing...

Could it be Pyuno not working correctly ? (if i recall well pyuno is used for interactions with OOo)

I already tested this and got no error:

Python 2.6.4 (r264:75706, Dec 7 2009, 18:45:15)
[GCC 4.4.1] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import uno
>>> import pyuno

any leads are welcome :mrgreen:
mr.nightmare
 
Posts: 6
Joined: Tue Mar 30, 2010 5:12 pm

Re: OpenOffice connection trouble

Postby sraps » Wed Mar 31, 2010 5:32 pm

Hello,
please read carefully the installation tutorial, especially part named "Testing OpenOffice headless mode."

http://kndati.lv/index.php/en/openerp/o ... stallation

Kaspars
sraps
 
Posts: 403
Joined: Mon May 04, 2009 10:04 pm

Re: OpenOffice connection trouble

Postby mr.nightmare » Thu Apr 01, 2010 11:04 am

Thanks for ur reply,

Indeed, i had obviously jumped that part :oops:

But when using openoffice in headless mode (the test with telnet localhost 8100 works fine) I still get an error when i click on the button to get the pdf :

Traceback (most recent call last):
File "/usr/lib/openerp-server/service/web_services.py", line 687, in go
(result, format) = obj.create(cr, uid, ids, datas, context)
File "/usr/lib/openerp-server/addons/report_openoffice.zip/report_openoffice/report_openoffice.py", line 310, in create
return fnct(cr, uid, ids, data, report_xml, context)
File "/usr/lib/openerp-server/report/report_sxw.py", line 421, in create_source_pdf
return self.create_single_pdf(cr, uid, ids, data, report_xml, context)
File "/usr/lib/openerp-server/addons/report_openoffice.zip/report_openoffice/report_openoffice.py", line 215, in create_single_pdf
return self.create_relatorio_report(cr, uid, ids, data, report_xml, context=context, output='pdf')
File "/usr/lib/openerp-server/addons/report_openoffice.zip/report_openoffice/report_openoffice.py", line 199, in create_relatorio_report
data = DC.convertByStream(data)
File "/usr/lib/openerp-server/addons/report_openoffice.zip/report_openoffice/DocumentConverter.py", line 84, in convertByStream
InputStream = inputStream
com.sun.star.lang.IllegalArgumentException: URL seems to be an unsupported one.

after reading thoroughly the installation tutorial I have no lead on what could i do to solve this...
mr.nightmare
 
Posts: 6
Joined: Tue Mar 30, 2010 5:12 pm

Re: OpenOffice connection trouble

Postby sraps » Thu Apr 01, 2010 2:38 pm

Hi,
what does the connection configuration wizard tells you?

Configure connection parameters to OpenOffice.org service

Administration ->Low Level Objects -> OpenOffice Connection
1.Open wizard;
2.Fill in your custom values;
3.Save;
On success you should receive message:"Connection to the OpenOffice.org instance was successfully established and PDF convertion is working."

If it fails with error : “Connection to OpenOffice.org instance was not established or convertion to PDF unsuccessful!”
It was unable to connect to OpenOffice.org or OpenOffice.org was unable to perform PDF conversion.


Kaspars
sraps
 
Posts: 403
Joined: Mon May 04, 2009 10:04 pm

Re: OpenOffice connection trouble

Postby sraps » Thu Apr 01, 2010 3:00 pm

Check if you have sufficient permissions for user to operate with temporary folder on system...

To check this you can try to launch the OOo process by root.

Kaspars
sraps
 
Posts: 403
Joined: Mon May 04, 2009 10:04 pm

Re: OpenOffice connection trouble

Postby mr.nightmare » Thu Apr 01, 2010 5:48 pm

Kaspars :arrow:
Thanks for taking the time to help me,

the connection configuration wizard tells me
"Connection to OpenOffice.org instance was not established or convertion to PDF unsuccessful!”

even when launching the OOo process
./soffice -nologo -nofirststartwizard -headless -norestore -invisible "-accept=socket,host=localhost,port=8100,tcpNoDelay=1;urp;" &
with root

I managed yesterday to obtain an osd report file via the GTK, so i think it is the "convertion to pdf" part that provides an error.

what could i do else to test if this is a permissions trouble ? ( i'm testing on a VM so i can go chmod 777 all i want)
mr.nightmare
 
Posts: 6
Joined: Tue Mar 30, 2010 5:12 pm


Return to Aeroo Reports & OpenOffice.org Reporting Engine

cron
Copyright © 2001 Alistek Ltd., ALL RIGHTS RESERVED