This question has been flagged

Has anyone come across a working guide for installing Aeroo reports in Odoo version 8.0 on Ubuntu 14.04 from these repositories?:

https://github.com/aeroo/aeroo_reports
https://github.com/aeroo/aeroo_docs
https://github.com/aeroo/aeroolib

Avatar
Discard
Author Best Answer

I have managed to get Aeroo Reports working in Odoo 8.0 using the following method on a clean Ubuntu 14.04 installation:

Ubuntu 14.04 Aeroo Reports installation script:

To install Aeroo Reports and all related dependencies please do the following at a terminal in Ubuntu 14.04:

#0      cd /tmp
#1      sudo wget https://raw.githubusercontent.com/OdooCommunityWidgets/install-scripts/8.0/aeroo_reports/aeroo_install.sh
#2      sudo sh aeroo_install.sh

#3      Follow steps #31-37 in the "Ubuntu 14.04 Aeroo Reports installation method:" section below for installation instructions inside                   Odoo.

This script has a yes/no option for installing Odoo 8.0, and the Aeroo reports Odoo modules. If you have a pre-existing Odoo installation you can choose no when you get to the prompt for installing Odoo 8, and choose yes when you get to the option for installing the Aeroo Reports (aeroo_reports) modules for Odoo 8.

For installing the Aeroo Reports (aeroo_reports) modules this script assumes you already have the following directory:

/opt/odoo/custom

and

/opt/odoo/custom/addons

and it also assumes that your /etc/odoo-server.conf file includes the following directory in your addons_path line, for example:

addons_path = /opt/odoo/odoo-server/addons,/opt/odoo/custom/addons

Ubuntu 14.04 Aeroo Reports installation method:

Install Git:

#0      sudo apt-get install git

Install AerooLib:

#1      sudo apt-get install python-setuptools
#2      sudo apt-get install python-genshi python-cairo python-lxml
#3      sudo apt-get install libreoffice-script-provider-python
#4      sudo mkdir /opt/aeroo
#5      cd /opt/aeroo
#6      sudo git clone https://github.com/aeroo/aeroolib.git
#7      cd /opt/aeroo/aeroolib
#8      sudo python setup.py install

Create Init Script for OpenOffice (Headless Mode) - (see: https://www.odoo.com/forum/help-1/question/how-to-install-aeroo-reports-2780 for original post from Ahmet):

#9        sudo pico -w /etc/init.d/office
#10      Copy and paste this:

#!/bin/sh

/usr/bin/soffice --nologo --nofirststartwizard --headless --norestore --invisible "--accept=socket,host=localhost,port=8100,tcpNoDelay=1;urp;" &

#11        sudo chmod +x /etc/init.d/office
#12        sudo update-rc.d office defaults
#13        sudo /etc/init.d/office
#14        telnet localhost 8100
#15        You should see something like the following message (this means it has established a connection successfully):

Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
e--'com.sun.star.bridge.XProtocolPropertiesUrpProtocolProperties.UrpProtocolPropertiesTidE--L

Install AerooDOCS (see: https://github.com/aeroo/aeroo_docs/wiki/Installation-example-for-Ubuntu-14.04-LTS for original post):

#16      sudo apt-get install python3-pip
#17     sudo pip3 install jsonrpc2 daemonize
#18     cd /opt/aeroo
#19     sudo git clone https://github.com/aeroo/aeroo_docs.git
#20     sudo python3 /opt/aeroo/aeroo_docs/aeroo-docs start -c /etc/aeroo-docs.conf
#21     sudo ln -s /opt/aeroo/aeroo_docs/aeroo-docs /etc/init.d/aeroo-docs
#22     sudo update-rc.d aeroo-docs defaults
#23     sudo service aeroo-docs start
                 [ ! ]  If you encounter and error "Unable to lock on the pidfile while trying #16 just restart your server (sudo shutdown -r now)                         and try #16 again after reboot.

Install Odoo from Source:

#24      cd /tmp
#25     sudo wget https://raw.githubusercontent.com/lukebranch/odoo-install-scripts/master/odoo-saas4/ubuntu-14-04/odoo_install.sh
#26     sudo sh odoo_install.sh
#27     restart the server (sudo shutdown -r now)

Install Aeroo Reports:

#28    sudo apt-get install python-cups
#29    cd /opt/odoo/custom
#30    sudo git clone -b master https://github.com/aeroo/aeroo_reports.git

After following the (above) steps in this guide you should have Aeroo Reports installed correctly on your server for Ubuntu 14.04 and Odoo 8.0. You'll just need to create a database and install the required Aeroo reports modules you need for that database.

[ ! ]    Do not have aeroo_report_sample in your addons directory or you will get an error message when updating module list:
         Warning! Unmet python dependencies! No module named cups

Install report_aeroo module in Odoo database:

#31    Go to Settings >> Users >> Administrator in the backend of Odoo
#32    Tick the box next to 'Technical Features' and Save, then refresh your browser window.
#33    Go to Settings >> Update Modules List > Update
#34    Go to Settings >> Local Modules > Search for: Aeroo
#35    Install report_aeroo
#36    You'll be confronted with an installation wizard, click: Continue >> Choose Simple Authentication from the Authentication dropdown list, and add username and password: anonymous
[ ! ]     You can change the username and password in: /etc/aeroo-docs.conf if required.
#37    Click Apply and Test. You should see the following message if it was successful:

Success! Connection to the DOCS service was successfully established and PDF convertion is working.

You now have a fully operational Aeroo Reports installation in Ubuntu 14.04. If for any reason this is not working for you please post back in the comments and explain the error message you are seeing.

Avatar
Discard

Nice work Luke! Will post a blog with credits to you! We will do some tests and help fixing this!

This is core aeroo code lib issue...need just a self reference!

Author

@SerpentCS,

Thanks! Aeroo reports seems to be a really great platform for building reports. Very easy to work with. I'll post some tutorials linked to this one on how to build custom quotation, invoice, PO, etc. templates as soon as I can find some time.

Author

@Serpent,

FYI - I've just updated the steps to include the connection to OpenOffice in headless mode.

Author

@Serpent,

Do you have any insight on this issue?:

https://www.odoo.com/forum/help-1/question/8-0-aeroo-reports-report-aeroo-direct-print-error-nameerror-global-name-context-is-not-defined-83234

I'll be putting together a tutorial on building a custom quotation/invoice template, as well as setting up the Direct Print settings shortly, but i've run into a roadblock with this in the report_aeroo_direct_print module.

Have you run into any similar issues in your own instance?

Hi Luke, am getting the error "Unable to lock on the pidfile" on step #20. How to resolve that? I tried restarting but dint work for me.

Author

@Akhil,

I am working on an install script for Odoo 8.0 and Ubuntu 14.04 using the guide above. You can find the (work in progress) here:

https://github.com/OdooCommunityWidgets/install-scripts/blob/8.0/aeroo_reports/aeroo_install.sh

I'll post back here once it's finished.

Author

@Akhil,

Try running this script on a clean Ubuntu 14.04 machine:

https://raw.githubusercontent.com/OdooCommunityWidgets/install-scripts/8.0/aeroo_reports/aeroo_install.sh

To run the script do the following in a terminal:

#1) sudo wget https://raw.githubusercontent.com/OdooCommunityWidgets/install-scripts/8.0/aeroo_reports/aeroo_install.sh
#2) sudo sh aeroo_install.sh

Please let me know if it works for you. It should install Aeroo reports along with Odoo. Once the script has finished running (it will probably take around 45 mins) just restart your server and you should have a working Odoo install with Aeroo modules available to you.

Best Answer

How can I install the official Aeroo Reports (module) for Odoo version 8 on windows 7 ?


I dont have enough Karma(beginner in odoo) to reply again in this post..

Kindly help me through "tsyeshwanth@gmail.com" 


Avatar
Discard
Author

@Yeshwanth,

What method of installation did you use for Odoo 8.0 on Windows? This will be necessary in order for people to offer you some advice.

Dear Luke,

I am really sorry to interrupt you through mail. I dont have enough Karma's to answer or reply to a question..

You can help me through this mail ID.  "tsyeshwanth@gmail.com"

I have directly downloaded the software from the Odoo website and installed, i did not use github installation method or other method.

If my installation is wrong, guide me.

Thank you.

On Tue, Mar 24, 2015 at 12:47 PM, Luke Branch <luke-weairsoft-com@mail.odoo.com> wrote:

@Yeshwanth,

What method of installation did you use for Odoo 8.0 on Windows? This will be necessary in order for people to offer you some advice.

--
Luke Branch
Sent by Odoo S.A. using Odoo access your messages

Author

@Yeshwanth,

Unfortunately I do not have experience with Odoo running on Windows. There may be others in the community that can help you with this though.

Otherwise I recommend looking into installing Ubuntu 14.04 on VirtualBox in your windows computer and then following the instructions above.

Best Answer

@Luke Branch

IS there a way to install aeroolib and aeroodocs, when Odoo is not installed in /var/lib/odoo. For example odoo is installed in /opt/odoo =?

Because I get an error when I'm installing aeroolib



chown: cannot access ‘/var/lib/odoo’: No such file or directory

I think thats because I installed Odoo in an other directory.

Avatar
Discard

Connection done , changed the port like in the aeroo-docs.conf file to "8989" All fine

Best Answer

As Akhil P Sivan, I have the same issue after step 20 "Unable to lock on the pidfile", even after reboot, it keeps saying the same error.

Please help! Thank you

Avatar
Discard
Author

@Fabrice,

I am working on an install script for Odoo 8.0 and Ubuntu 14.04 using the guide above. You can find the script (work in progress) here:

https://github.com/OdooCommunityWidgets/install-scripts/blob/8.0/aeroo_reports/aeroo_install.sh

I'll post back here once it's finished.

Oh thanks a lot! Any idea what is wrong with the Ünable to lock on the pidfile"? I followed this tutorial twice, but still have this error at step 20

Oh thanks a lot! Any idea what is wrong with the Ünable to lock on the pidfile"? I followed this tutorial twice, but still have this error at step 20

Author

@Fabrice,

I'm working through the steps in this tutorial step-by-step to build the script. Once I come across this error again, i'll comment back.

OK thanks for your help and work!

Author

@Fabrice,

No problem, this script should be almost ready now. Please try the script on an clean install of Ubuntu 14.04 and let me know if you run into any errors. If you already have a working instance of Odoo on the system then you need to comment out lines 50-54.

I tried your script but it stops as it cannot connect to kaz.dl.sourceforge.net when installing Wkhtmltopdf 0.12.1

it keeps saying failed : connection timed out

Author

@Fabrice,

I'm working on a fix now. This is due to the download link having been changed for wkhtmltopdf in my Odoo install script.

I'll comment back here once it's fixed.

Author

@Fabrice,

Please start again with a fresh Ubuntu 14.04 instance. I've updated the script.

The problem was due to the fact the installation script link was pointing to the master branch (https://raw.githubusercontent.com/lukebranch/odoo-install-scripts/master/odoo-saas4/ubuntu-14-04/odoo_install.sh) instead of the 8.0 branch (https://raw.githubusercontent.com/lukebranch/odoo-install-scripts/8.0/odoo-saas4/ubuntu-14-04/odoo_install.sh).

Please let me know how you get on, i've just tested it on my own clean Ubuntu 14.04 instance and it works fine.

Installing right now, I'll let you know

Thanks for your precious help!

I will try it and I will let you know.

 

 

From: Luke Branch [mailto:luke-weairsoft-com@mail.odoo.com]
Sent: lundi 25 mai 2015 16:07
To: Fabrice Candau
Subject:

 

@Fabrice,

Please start again with a fresh Ubuntu 14.04 instance. I've updated the script.

The problem was due to the fact the installation script link was pointing to the master branch (https://raw.githubusercontent.com/lukebranch/odoo-install-scripts/master/odoo-saas4/ubuntu-14-04/odoo_install.sh) instead of the 8.0 branch (https://raw.githubusercontent.com/lukebranch/odoo-install-scripts/8.0/odoo-saas4/ubuntu-14-04/odoo_install.sh).

Please let me know how you get on, i've just tested it on my own clean Ubuntu 14.04 instance and it works fine.

--
Luke Branch
Sent by Odoo S.A. using Odoo access your messages

Author

@Fabrice,

If you run into an issue with AerooDOCS when you install the aeroo_reports module in Odoo saying that it can't connect to AerooDOCS then try running the following at a terminal:

1) sudo apt-get install python-setuptools python-genshi python-cairo python-lxml libreoffice-script-provider-python libreoffice-base python-cups python3-pip -yf
2) sudo pip3 install jsonrpc2 daemonize

For some reason the script is not processing these lines correctly, however doing them manually after the script has run should do the trick if you do run into this issue.

Ok thank you so much!
I have launched the installation script but had to leave my office. Will tell you tomorrow if everything went well.
Thanks again for your help, it seems it is difficult sometimes to get help from odoo community.

Fabrice



-------- Original Message --------
From: Luke Branch <luke-weairsoft-com@mail.odoo.com>
Sent: Monday, May 25, 2015 09:59 PM
To: Fabrice Candau <fabrice_candau@hotmail.com>
Subject: Re: RE:

@Fabrice,

If you run into an issue with AerooDOCS when you install the aeroo_reports module in Odoo saying that it can't connect to AerooDOCS then try running the following at a terminal:

1) sudo apt-get install python-setuptools python-genshi python-cairo python-lxml libreoffice-script-provider-python libreoffice-base python-cups python3-pip -yf
2) sudo pip3 install jsonrpc2 daemonize

For some reason the script is not processing these lines correctly, however doing them manually after the script has run should do the trick if you do run into this issue.

--
Luke Branch
Sent by Odoo S.A. using Odoo access your messages
Author

@Fabrice,

If your previous attempt above doesn't work you may want to try one more time with the newest version of the script (as of the time of writing of this message), as i've made some changes and tested the script a few times in my own dev instances.

The script will take quite awhile, and has a total of two prompts during installation; one for installing Odoo and one for installing aeroo_reports odoo modules from github (aeroo/aeroo_reports).

Please message back here or create an issue on github if you run into any issues.

Thanks for your email

I'll let you know if it goes well with your previous script or the new one.
Thanks  again!

Fabrice



-------- Original Message --------
From: Luke Branch <luke-weairsoft-com@mail.odoo.com>
Sent: Tuesday, May 26, 2015 01:37 AM
To: Fabrice Candau <fabrice_candau@hotmail.com>
Subject: Re: RE:

@Fabrice,

If your previous attempt above doesn't work you may want to try one more time with the newest version of the script (as of the time of writing of this message), as i've made some changes and tested the script a few times in my own dev instances.

The script will take quite awhile, and has a total of two prompts during installation; one for installing Odoo and one for installing aeroo_reports odoo modules from github (aeroo/aeroo_reports).

Please message back here or create an issue on github if you run into any issues.

--
Luke Branch
Sent by Odoo S.A. using Odoo access your messages
Author

@Fabrice,

No problem.

I installed odoo and aeroo from your script but I don't understand why Odoo shows me in settings/Apps Aeroo not installed. Shoud I try to install it again from Odoo settings?

Ok I tried but it crashes and gave me many errors

Author

@Fabrice,

Could we continue this discussion on a github issue thread here:

https://github.com/OdooCommunityWidgets/install-scripts/issues

I just need you to create an issue on github (you'll need to sign up for a github account if you don't have one).

If you could detail some of the errors you've run into this will help in troubleshooting. For the installation script, it doesn't install Aeroo reports in the actual Odoo database, it just places it in the /custom/addons folder so that you just need to do 'Update Modules List' and search for Aeroo in the modules list, just like you would with installing any other community module.

Did you get errors from the script itself, or from the Aeroo Reports installation wizard inside Odoo?

I've run this on 5 clean ubuntu 14.04 instances, and although there are some errors during the script that I need to resolve, the result is a working Odoo instance with a working AerooDOCS, and AerooLib installation.

If there are any bugs in the script though i'd like to iron them out, so any insight into errors you've run into would be appreciated.