Odoo - distributed business apps

ww4

@loudlemur I wasn't aware of it until today, it seems they are a very close fork of Odoo... too close for Odoo's comfort in some cases! Here is the #3 on Google search for "flectra": https://www.odoo.com/page/flectra-vs-odoo-flectrahq-enterprise

At any rate, if Cloudron supports either one it should be possible to support both, as they are so similar.

nj

I have packaged Odoo successfully.
Please check out http://github.com/njsubedi/cloudron-odoo

I had to patch the default Database connection function to prevent Odoo from connecting to the database named “postgres” from different places.

Otherwise, everything is working as expected. Simply clone the repo, and then from inside the repo, run

cloudoron build
cloudron install -l <subdomain.yourcloudron.tld>

Please post any error logs or problems here so I can continue to improve it.

Update: somehow LDAP login is failing; need to look into it.

girish

@nj Oh, this is awesome! Would be great to see someone try this and give some feedback on how well this works.

What do you think is the "status" of the package otherwise?

luckow

@nj Quick feedback after I invested 60 minutes in Odoo as a Cloudron app:
Instead of an error message, a big
The installation runs smoothly and without any problems. Yes, you are right: LDAP does not work.
Also the typical problems with uploading images or modules, do not exist in your package. Top.

mdreira

@nj WOW!! The entire community will be eternally grateful to you for starting this great challenge.

luckow

@nj The only negative point as far as I can see so far: Your Odoo version is too new
The OCA module shop for version 15 is almost empty.
https://odoo-community.org/shop?version=19

girish

@luckow Interesting, why is that? Because people have not ported over to odoo 15?

marcusquinn

@luckow This is a very good point!

@nj With Odoo, because of the nature of what it is, it makes sense to have separate apps for each whole-number version, because whole-number version updates are quite a big deal in ERP stacks with lots of 3rd-party add-ons to test each time.

Certainly appreciating your time on this, but to make it more likely to be adopted and also attract more Cloudron users with it being a hosting setup option, if you had time, it would make sense to have an App Package for each of the latest 3 whole-number versions, perhaps even more.

People really do get stuck on ERP whole number versions sometimes , when they don't have the available resources to upgrade, they often just don't take the risk if it's not hurting them.

luckow

@girish yes. Normal for community contributions
The "official" odoo (so called) apps are v15 ready. But there is a module wonderland through community contributions.
This is "official" odoo -> https://www.odoo.com/ with its enterprise and paid plan.
This is odoo community -> https://odoo-community.org with its association and software contribution.

nj

@luckow I've pushed a fix for LDAP Login. I had to map cn to displayName, and use a proper LDAP filter. I was able to immediately log in after installing Odoo.

However, there are two issues:

1. You have to log in with email and password. When I tried to have it login with both username and email, Odoo was creating two different users - one with the email and another one with the username.

2. Odoo throws a Server Error on the first login for a user from LDAP. From the second time, the error is not raised for the same user. Simply reload the page to "resend" the email/password, or log in again.
I spent some time debugging, but couldn't fix it. Looks like a bug in the record cache system of Odoo. If anyone is interested, I have opened an issue.

nj

@girish I'd say it is ready to be released as an unstable app. I tried restarting, reinstalling, updating, etc, and everything is working fine. I'm still unsure whether to keep the IMAP settings or remove it, because recvmail is mostly deprecated.

As other members said, there will be missing out on a lot of community addons but sooner or later they will be updated to support the latest Odoo version.

girish

@nj said in Odoo - distributed business apps:

@girish I'd say it is ready to be released as an unstable app. I tried restarting, reinstalling, updating, etc, and everything is working fine. I'm still unsure whether to keep the IMAP settings or remove it, because recvmail is mostly deprecated.

recvmail got un-deprecated and is back in the last release. But I wouldn't worry about that part yet since it's not critical to get the app published. I already have your outline app on my TODO list, so I will get to this after that. Thanks!

LoudLemur

@nj If this is made available as a beta app in Cloudron, I will test it and give feedback.

Thank you incredibly for helping make this very powerful Free Software available to a much wider number of users. I think that including Odoo Community Edition on Cloudron will showcase the functionality that Cloudron can deliver. Well done!

If you have managed to make Odoo 15 work, I think both Flectra and LibreERP could be deployed in the same way. LibreERP is based on a much earlier version of Odoo, v11, I think.

This is great news.

LoudLemur

@girish Odoo hosts events all round the world:
https://www.odoo.com/event

The flagship event, where the next version of Odoo is introduced, is called Odoo Experience, and is usually around November.

If we have Odoo running well on Cloudron before then, I think Cloudron could greatly boost the number of users by making a presentation at Odoo Experience. Last year, it was an online event, usually it is in-person and in Belgium.

luckow

@nj just a quick note about your latest improvements: ldap still does not work for me

nj

@luckow did you try logging in for the second time? As I have mentioned, first-time login still fails. Also if you could raise an issue on Github with the contents of “/run/logs/odoo.log” as soon as you log in, I can look into it.

luckow

@nj Everything back to zero. Those who can read have an advantage. .... ! As you wrote: You have to use the mail address (instead of the username). And you have to reload the whole form.
Now it works as described (for me)

rmdes

@nj Amazing work !!!

luckow

@luckow look at https://odoo-community.org/shop?version=19 9 days later! The Odoo-community was busy

LoudLemur

@luckow How much additional memory is Odoo using?

luckow

@LoudLemur this is package default:
Memory Limit : 2.5 GB

No idea if this is right or wrong. In my (few) test, the app is responsible.

samir

Hey,

I'm cross-posting a message sent in the sponsoring odoo topic.
For those interested in Odoo V10 CE, I've just updated my last script here :
https://git.cloudron.io/altsyst/odoo10-ce-app

I'm not maintaining it anymore, but it's working well for two years now (working with the ldap cloudron server).

Enjoy

scooke

@samir Is the install process the same as the other recently shared Odoo?

LoudLemur

@samir Thank you very much for this. I know you are no longer maintaining this, but is it possible before you leave the project, if it does not take too much time, to incorporate the new script suggested here:

https://git.cloudron.io/altsyst/odoo-ce-app/-/issues/1

mdreira

@girish Would it be possible to pick up the slack and add Odoo or Flectra in the near future to Cloudron? This would be amazing.

samir

@scooke the install process is the cloudron custom app process, described in the doc

samir

@LoudLemur The current script is based on the Yenthe666 script, I will publish an odoo12-ce-app very soon. It's pretty easy to adapt the script for odoo13 if you want it, though I've heard (to confirm) that the odoo based on even version are usually more stable than the odd one... I tend to pass the odd version, waiting for the even one.

In my opinion, it makes sense to have separate repo for each odoo version. It's not obvious to update a odoo version, since it requires a special script to update the database (and other stuff...)

samir

I've just published the cloudron custom app odoo 12 CE here :
https://git.cloudron.io/altsyst/odoo12-ce-app/

samir

For using the cloudron ldap :

Create first the user in odoo with an empty password
open the ldap parameters in odoo (as admin, config>settings)
enter into an odoo terminal and get the cloudron ldap parameters
fill in the ldap cloudron parameters (ldap server address, binddn, port, password)
For LDAP base : ou=users,dc=cloudron
restart odoo app (or cloudron, I don't remember)

doodlemania2

@samir Attempting from your script, stuck in a loop:
Traceback (most recent call last):
Apr 08 12:52:02 File "/app/code/odoo-server/odoo-bin", line 5, in <module>
Apr 08 12:52:02 import odoo
Apr 08 12:52:02 File "/app/code/odoo-server/odoo/init.py", line 125, in <module>
Apr 08 12:52:02 from . import modules
Apr 08 12:52:02 File "/app/code/odoo-server/odoo/modules/init.py", line 8, in <module>
Apr 08 12:52:02 from . import db, graph, loading, migration, module, registry
Apr 08 12:52:02 File "/app/code/odoo-server/odoo/modules/loading.py", line 17, in <module>
Apr 08 12:52:02 import odoo.modules.migration
Apr 08 12:52:02 File "/app/code/odoo-server/odoo/modules/migration.py", line 12, in <module>
Apr 08 12:52:02 from odoo.modules.module import get_resource_path
Apr 08 12:52:02 File "/app/code/odoo-server/odoo/modules/module.py", line 25, in <module>
Apr 08 12:52:02 from odoo import SUPERUSER_ID, api
Apr 08 12:52:02 File "/app/code/odoo-server/odoo/api.py", line 1198, in <module>
Apr 08 12:52:02 from odoo.modules.registry import Registry
Apr 08 12:52:02 File "/app/code/odoo-server/odoo/modules/registry.py", line 18, in <module>
Apr 08 12:52:02 from odoo.sql_db import TestCursor
Apr 08 12:52:02 File "/app/code/odoo-server/odoo/sql_db.py", line 49, in <module>
Apr 08 12:52:02 import tools
Apr 08 12:52:02 ImportError: No module named 'tools'
Apr 08 12:52:10 => Ensure directories
Apr 08 12:52:10 => Patch config file
Apr 08 12:52:11 => Ensure data ownership

samir

@doodlemania2 which script? Odoo 10 or odoo 12? Could you fill an issue on git directly to keep track of the issue? Thanks!

doodlemania2

@samir that was from 12, will do so!

LoudLemur

@girish Is this ready to be included as an experimental status Cloudron application yet?

doodlemania2

@LoudLemur I don't think so - at least not yet. Unable to get it to install cleanly on my CR server, but I think it's close.

LoudLemur

@nj

What is the latest on installing Odoo? Is it ready as a Cloudron Beta application yet?

luckow

@LoudLemur nope.
but it's been working as a custom app on one of my instances for a few weeks. to get an idea of how odoo works and what you need to learn to implement an erp system in your company, it's top. as a reliable critical app for your company (without knowledge about content migration), you should wait until odoo is an official cloudron app.

LoudLemur

@luckow When that day happens, I shall be grinning from ear to ear! I shall probably be jumping up and down in joy too!

msbt

@nj thanks for your packaging efforts! I just tried to run odoo and it wouldn't start, it was always looping the First run. Initializing DB... bit. I've jumped in the terminal and ran the cmds manually and eventually figured out, that the /app/data needed chowning to the cloudron-user before it worked - which it now does! So all we need to do is add /app/data/ to https://github.com/njsubedi/cloudron-odoo/blob/main/start.sh#L17

makemrproper

@msbt Odoo Community edition hosted on Cloudron would be a massive value add to the Cloudron portfolio. I totally recommend using Cloudron in a business to structure and improve processes. Unless your company has the budget to run Salesforce, or Service Now to do the same.

LoudLemur

@makemrproper There is a large and active development community for Odoo. I think it would be quite excited to hear about a Beta of Odoo on Cloudron and they could contribute quite a lot. Hopefully, the other great applications available on Cloudron would catch their notice too, and people would join us.

Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.

Odoo - distributed business apps