Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

[8.0] How can I install the official Aeroo Reports (Alistek) for Odoo version 8? [SOLVED + Installation Script]

By
Luke Branch
on 2/11/15, 4:36 AM 12,691 views

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

7

Luke Branch

--Luke Branch--
1531
| 6 7 8
Mui Wo, Lantau, Hong Kong
--Luke Branch--

...

Luke Branch
On 3/21/15, 3:28 AM

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.

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

Serpent Consulting Services Pvt. Ltd.
on 3/23/15, 12:50 PM

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

Serpent Consulting Services Pvt. Ltd.
on 3/23/15, 12:53 PM

@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.

Luke Branch
on 3/23/15, 10:04 PM

@Serpent,

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

Luke Branch
on 4/1/15, 3:16 AM

@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?

Luke Branch
on 4/1/15, 6:44 AM

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.

Akhil P Sivan
on 4/8/15, 7:43 AM

@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.

Luke Branch
on 5/19/15, 1:03 PM

@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.

Luke Branch
on 5/22/15, 1:43 PM
Luke Branch
on 5/25/15, 4:18 AM
1
yeshwanth
On 3/24/15, 3:04 AM

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" 


@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
on 3/24/15, 3:17 AM
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

yeshwanth
on 3/24/15, 3:23 AM

@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.

Luke Branch
on 3/25/15, 3:57 AM
0
wizardz
On 3/31/15, 5:04 AM

@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.

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

wizardz
on 3/31/15, 8:56 AM
0
Fabrice Candau
On 5/19/15, 2:25 AM

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

@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.

Luke Branch
on 5/19/15, 1:04 PM

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

Fabrice Candau
on 5/20/15, 2:06 AM

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

Fabrice Candau
on 5/20/15, 2:06 AM

@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.

Luke Branch
on 5/20/15, 1:11 PM

OK thanks for your help and work!

Fabrice Candau
on 5/21/15, 8:35 PM

@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.

Luke Branch
on 5/24/15, 11:07 PM

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

Fabrice Candau
on 5/24/15, 11:56 PM

it keeps saying failed : connection timed out

Fabrice Candau
on 5/25/15, 3:19 AM

@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.

Luke Branch
on 5/25/15, 3:56 AM

@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
on 5/25/15, 4:06 AM

Installing right now, I'll let you know

Fabrice Candau
on 5/25/15, 8:08 AM

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

Fabrice Candau
on 5/25/15, 8:10 AM

@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
on 5/25/15, 9:59 AM

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
Fabrice Candau
on 5/25/15, 10:05 AM

@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
on 5/25/15, 1:37 PM

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
Fabrice Candau
on 5/25/15, 2:24 PM

@Fabrice,

No problem.

Luke Branch
on 5/25/15, 11:23 PM

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?

Fabrice Candau
on 5/26/15, 9:33 PM

Ok I tried but it crashes and gave me many errors

Fabrice Candau
on 5/26/15, 9:38 PM

@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.

Luke Branch
on 5/26/15, 10:30 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

11 follower(s)

Stats

Asked: 2/11/15, 4:36 AM
Seen: 12691 times
Last updated: 11/20/16, 4:59 PM