The adventure on odoo / LibreERP, notes i share

Discuss
1

join me on the adventure of running this so you can learn with me :slight_smile:

note i will post stuff mostly using debug mode /web?debug=1 also i like bullet points nad i will try to separate stuff using --- so on your screen you will see 1pixel line

imagen

  1. selecting “Choose an administrator user for this app” dont really do much because this used it will not be validated when you log in u will get to a white page with your logo here and a lick to database that is disabled

imagen

  1. the real admin is an internal account named admin and the password u provided during install is stored on .local/yunohost/admin/#/apps/libreerp/operations "admin_passwd = "
  1. my guess is that the combination of 1 and 2 happens when your default admin account is something other that admin, i always changed the admin account, i need to test to see if having ynh admin fixes this

imagen

  1. any other ynh user login into libreerp gets
# Bad Request

Record does not exist or has been deleted.
(Record: res.users(28,), User: 28)

u need to get in the settings->users, then remove the filter to see something like
imagen

internal user will allow you to set more permissions, i bet portal and public users depends on other modules and on stuff like permissions
imagen

:thinking: :thinking: settings/config/hierarchy hell?

  1. users created via libreerp UI will be confirmed and on libreerp only and have portal user type, imo disabling Free sign up is a good idea

here the tooltip
imagen

2 Likes
2

i wonder if is easy to update directly from git

here the files used to install

/var/www/libreerp/libreerp# ls -1a
.
..
addons
CONTRIBUTING.md
COPYRIGHT
debian
doc
.github
.gitignore
LICENSE
MANIFEST.in
odoo
odoo-bin
README.md
requirements.txt
SECURITY.md
setup
setup.cfg
setup.py
.tx

so in this folder i can

git clone --depth 1 --branch 16 https://www.github.com/odoo/odoo to get latest files

after that when need to upgrade just

git fetch origin 16.0
git reset --hard origin/16.0
systemctl restart libreerp

same goes GitHub - OCA/OCB at 16.0

i am missing something?

3

here some hints for Spanish payroll, depending on what version u got installed this can change also have a second install to test things to change the config to have a second database for testing

Nombre Codigo Category Calculo
Basic Salary BASIC Basic Código Python result = contract.wage
Gross GROSS Gross Código Python result = result = categories.BASIC + categories.ALW
Net Salary NET Net Código Python result = categories.BASIC+categories.INDEM - categories.DED
Salario base 1 Basic Código Python result = (contract.wage/30) * worked_days.DIAS.number_of_days
Plus convenio CONVENIO Basic Código Python result=inputs.CONVENIO.amount * worked_days.DIAS.number_of_days
Paga proporcional verano navidad PAGA Basic Código Python result=inputs.PAGA.amount
Dieta DIETA Dietas Código Python result=inputs.DIETA.amount
Cotizacion cont. comu 995 Deduction Porcentaje (%)/categories.BASIC/1./4.7
Cotizacion Formacion 996 Deduction Porcentaje (%)/categories.BASIC/1.0/0.1
Cotizacion Desempleo fijo 997 Deduction Porcentaje (%)/categories.BASIC/1.0/1.6
Tributacion IRPF 11 IRPF11 Deduction Porcentaje (%)/BIRPF/1.0/11.0
Tributacion IRPF 2% IRPF2 Deduction Porcentaje (%)/BIRPF/1.0/2.0
Remuneración total REMTOTAL Gross Porcentaje (%)/categories.BASIC/1.0/100.0
Base Seguridad Social BASESS Seguridad Social Código Python mas abajo
Contingencias comunes 101 Company Contribution Porcentaje (%)/BASESS/1.0/23.6
AT y EP 102 Company Contribution Porcentaje (%)/BASESS/1.0/6.7
Desempleo fijo 103 Company Contribution Porcentaje (%)/BASESS/1.0/5.5
Formación Profesional 104 Company Contribution Porcentaje (%)/BASESS/1.0/0.6
Fondo Garantía Salarial 105 Company Contribution Porcentaje (%)/BASESS/1.0/0.2
Coste para empresa COSTT Coste total empresa Porcentaje (%)/categories.TCOST/1.0/100.0\
Cotizacion Desempleo Temporal 997 Deduction Porcentaje (%)/categories.BASIC/1.0/1.6
Desempleo temporal 103 Company Contribution Porcentaje (%)/BASESS/1.0/6.7
Parte proporcional vacaciones FPPV Basic Código Python result=inputs.FPPV.amount
Indemnización FI Indemnizacion Código Python result=inputs.FI.amount
Base I.R.P.F. BIRPF I.R.P.F. Porcentaje (%)/categories.BASIC+categories.INDEM/1.0/100.0 
result = 0
   for line in payslip.worked_days_line_ids:
     result += line.number_of_days
   if result >= 28:
    result = 30
  result = ( REMTOTAL /worked_days.DIAS.number_of_days) * result
4

in the default ynh config the user libreerp cant create databases so is impossible to import a new bd, you can to start psql and give him the role

ALTER USER libreerp CREATEDB;

in /etc/libreerp/main.conf

db_name locks the db u get to see
list_db show u the list of db u can pick


db_name = 

list_db = True

for version 16 suspect because it got replaced with websocket
longpolling_port = 8072

you may wan to add

limit_time_cpu = 600
limit_time_real = 1200

u need this if u plan to use base_location_geonames_import

add version to custom addons

addons_path = /var/www/libreerp/libreerp/addons,/var/www/libreerp/custom-addons/16.0

depending how good the host is u can add more workers

workers = 2
limit_memory_hard = 2684354560
limit_memory_soft = 2147483648