I tried it now and could not reproduce it. Fresh 7.4, installed odoo and Software Center works.
It’s possible to setup SMTP and IMAP mail server in odoo. It seems also possible to add a custom template to postfix to use the local mail server directly.
Thanks for testing! Although the issue with psutil happened only once, I’d like to keep it in the howto, maybe it helps others.
I have had a read of the Flectra site it looks promising and agree that the Odoo financial model is not so good, I am an open-source purest and only have been using the free moduals with in Odoo. would the NS people and Flectra people consider creating this as an installable app with Neth Server? a one click install solution would be excellent.
Or is this something for the to hard box? considering Flectra is only at Alpha.
An alpha version in Software Center, which is needed for one-click, is too risky I think…
But instead of a one-click-install I may provide a one-line-install like “yum install http://someserver/somepackage.rpm”.
Did you test it already?
You may take this howto as a template for installing. I did not have a look at flectra now but it’s on my todo list.
Its something i would like to look at if i can find the time, I am a Sole Trader (Self Employed) in Australia and are flat out working most days, we all gota pay our bills somehow
I think i will stick with Odoo for now as its already being worked here. Hoping to have time over Christmas to get it running.
Hi Clinton, welcome here. Please let us know how your tests go
I tried to install it under Debian 9 and it has been working. Would be nice to have an unexpensive ERP-System under NethServer…
Do we have ERP-Experts here ?
Did you try to install it on NethServer? Isn’t it similar to installing odoo?
No, had no time until now…
Pleas have a look (debian9):
adduser --system --quiet --shell=/bin/bash --home=/opt/flectra --gecos ‘flectra’ --group flectra
apt-get upgrade -y
apt-get install postgresql build-essential python3-pillow python3-lxml python-ldap3 python3-dev python3-pip python3-setuptools git libldap2-dev libsasl2-dev libxml2-dev libxslt1-dev libjpeg-dev zlib1g-dev curl -y
curl -sL https://deb.nodesource.com/setup_6.x | bash -
apt-get install nodejs wkhtmltopdf -y
git clone --depth=1 --branch=master https://github.com/flectrahq/flectra.git /opt/flectra/flectra
chown flectra:flectra /opt/flectra/ -R
chown flectra:flectra /var/log/flectra/ -R
pip3 install -r requirements.txt
npm install -g less less-plugin-clean-css -y
ln -s /usr/bin/nodejs /usr/bin/node
apt-get remove wkhtmltopdf -y
cd /tmp && https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.4/wkhtmltox-0.12.4_linux-generic-amd64.tar.xz
tar xf wkhtmltox-0.12.4_linux-generic-amd64.tar.xz
cp -R /tmp/wkhtmltox/ /
wget -N http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz && gunzip GeoLiteCity.dat.gz && mkdir /usr/share/GeoIP/ && mv GeoLiteCity.dat /usr/share/GeoIP/
su - postgres -c “createuser -s flectra"
su - flectra -c “/opt/flectra/flectra/flectra-bin --addons-path=/opt/flectra/flectra/addons -s --stop-after-init"
mv /opt/flectra/.flectrarc /etc/flectra/flectra.conf
sed -i “s,^(logfile = ).,\1”/var/log/flectra/flectra-server.log”,” /etc/flectra/flectra.conf
sed -i “s,^(logrotate = ).,\1"True”," /etc/flectra/flectra.conf
sed -i “s,^(proxy_mode = ).*,\1"True”," /etc/flectra/flectra.conf
cp /opt/flectra/flectra/debian/init /etc/init.d/flectra
chmod +x /etc/init.d/flectra
ln -s /opt/flectra/flectra/flectra-bin /usr/bin/flectra
update-rc.d -f flectra start 20 2 3 4 5 .
service flectra start
Running into some issues with this on a Neth 7.4 test VM. It started with creating the database:
postgres=# CREATE DATABASE odoo ENCODING 'UTF8' OWNER odoo; ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) HINT: Use the same encoding as in the template database, or use template0 as template.
So I ran the create command without specifying UTF8. The remainder of the installation appeared to proceed without issues, but I’m getting an Internal Server Error when I browse to http://host:8069. In /var/log/odoo/odoo-server.log, I’m seeing this:
2017-12-15 22:57:59,098 4330 INFO odoo werkzeug: 192.168.1.199 - - [15/Dec/2017 22:57:59] “GET / HTTP/1.1” 500 -
2017-12-15 22:57:59,105 4330 ERROR odoo werkzeug: Error on request:
Traceback (most recent call last):
File “/usr/lib/python2.7/site-packages/werkzeug/serving.py”, line 177, in run_wsgi
File “/usr/lib/python2.7/site-packages/werkzeug/serving.py”, line 165, in execute
application_iter = app(environ, start_response)
File “/usr/lib/python2.7/site-packages/odoo/service/server.py”, line 246, in app
return self.app(e, s)
File “/usr/lib/python2.7/site-packages/odoo/service/wsgi_server.py”, line 186, in application
return application_unproxied(environ, start_response)
File “/usr/lib/python2.7/site-packages/odoo/service/wsgi_server.py”, line 172, in application_unproxied
result = handler(environ, start_response)
File “/usr/lib/python2.7/site-packages/odoo/http.py”, line 1308, in call
return self.dispatch(environ, start_response)
File “/usr/lib/python2.7/site-packages/odoo/http.py”, line 1282, in call
return self.app(environ, start_wrapped)
File “/usr/lib/python2.7/site-packages/werkzeug/wsgi.py”, line 579, in call
return self.app(environ, start_response)
File “/usr/lib/python2.7/site-packages/odoo/http.py”, line 1464, in dispatch
File “/usr/lib/python2.7/site-packages/odoo/init.py”, line 52, in registry
File “/usr/lib/python2.7/site-packages/odoo/modules/registry.py”, line 59, in new
File “/usr/lib/python2.7/site-packages/odoo/modules/registry.py”, line 83, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File “/usr/lib/python2.7/site-packages/odoo/modules/loading.py”, line 280, in load_modules
loaded_modules, processed_modules = load_module_graph(cr, graph, status, perform_checks=update_module, report=report)
File “/usr/lib/python2.7/site-packages/odoo/modules/loading.py”, line 156, in load_module_graph
_load_data(cr, module_name, idref, mode, kind=‘data’)
File “/usr/lib/python2.7/site-packages/odoo/modules/loading.py”, line 95, in load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File “/usr/lib/python2.7/site-packages/odoo/tools/convert.py”, line 839, in convert_file
convert_csv_import(cr, module, pathname, fp.read(), idref, mode, noupdate)
File “/usr/lib/python2.7/site-packages/odoo/tools/convert.py”, line 895, in convert_csv_import
raise Exception((‘Module loading %s failed: file %s could not be processed:\n %s’) % (module, fname, warning_msg))
Exception: Module loading base failed: file base/res/res.lang.csv could not be processed:
Unknown error during import: <class ‘odoo.exceptions.ValidationError’>: Error while validating constraint
Thank you, you are right. Maybe a postgres update changed the behaviour. The solution is to make the db UTF8 using template0:
DROP DATABASE odoo; CREATE DATABASE odoo ENCODING 'UTF8' OWNER odoo TEMPLATE template0;
I’ll update the howto asap…thanks again!
That seems to have resolved it. A suggestion to simplify the instructions: When you’re installing the dependencies, only install nethserver-postgresql. Then, when it’s time to install odoo, rather than downloading with wget and manually adding the key, simply do
yum install http://nightly.odoocdn.com/10.0/nightly/rpm/odoo_10.0.latest.noarch.rpm. That will pick up all the dependencies, add the key if needed, and install everything.
Thanks again, this way we can make one line out of four and required packages are handled by odoo package:
yum -y install nethserver-postgresql http://nightly.odoocdn.com/10.0/nightly/rpm/odoo_10.0.latest.noarch.rpm
Have used the following with no errors being displayed
Were do i go from here with initial setup for https? from reading the Odoo instruction there using nginx is this possible with NS or will it break something?
It’s possible but nginx and apache use the same ports by default so you have to change the nginx port 80 to something else or apache won’t start anymore. I didn’t try nginx with odoo yet.
Here is an example of installing nginx:
I am thinking that i’m starting to get ahead of my self with that question, I apologize. Will try again
Odoo is multi threaded for multiple Users / Odoo Apps. As the NS community and the Dev team have put so much effort into such a stable Server OS i would like to avoid adding extra complexity by using untested non NS software and plugins etc…
Q: What is the best way in NS to have Odoo with multi threading on HTTPs using only what comes with NS (Apache, nethserver-httpd-proxypass, nethserver-lightsquid, nethserver-squid)
Sorry, I didn’t test it for now, maybe you could use the NethServer Reverse Proxy module (apache proxypass) instead of nginx. Squid is a not a reverse proxy, you won’t need it in this case.
I added HTTPS config in my first post but it does only work with installing nginx and move apache to other ports which may make other apps unusable.
Odoo can integrate AD users, the new nethserver-sssd update makes it really easy without the need of a seperate AD user! It’s included in the howto (first post)