Odoo 17 migrations issues

Tips

wkhtmltopdf in ubuntu 18 - Qt problem

The latest package taken from the download page (0.12.6.1-2 at the moment), works on Ubuntu 22.04, it has the QT patch inside

Tools

[1] https://github.com/pierrelocus/odoo-attrs-replace

Alpaca Information

 [1] https://www.youtube.com/watch?v=l_ie4_Yyxjg

[2] Alpaca Breeding/Feeding https://www.youtube.com/watch?v=0sO9rizj7I4

     Types Suri, Tuy-Wacaya

[3] Alpaca Breeding (Chigmo, SilluSillu) https://www.youtube.com/watch?v=ksN5x9y5HNw

Ubuntu 20 VMWare Player

 

sudo apt update

sudo apt install build-essential linux-headers-generic

Next, download and install from the following resources

VMware-Player-Full-17.5.0-22583795.x86_64.bundle

Download from drive

[1] https://drive.google.com/file/d/1X0MifVmJ_gr5UgShUKGrt8V49YA2wI6O/view?usp=drive_web

[2] Linux Lite 5.2 based on Ubuntu 20 https://osdn.net/dl/linuxlite/linux-lite-5.2-64bit.iso

References:

[1] original link https://salvatorenoschese.it/vmware-17-5-2-download-url/

[2] Linux Lite mirror https://osdn.net/projects/linuxlite/storage/

ML Datasets

 

Computer Vision

[1] Community https://huggingface.co/datasets

 

VPS 2024

 

 

References:

[1] https://github.com/cloudcommunity/Cloud-Free-Tier-Comparison

[2] Uptime Kuma https://github.com/louislam/uptime-kuma

ERP and CRM

 

102  sudo apt install python3-setuptools
103  sudo apt-get install python3-venv
105  sudo apt-get install python3-virtualenv
106  sudo apt-get install python3.10-venv

112  python3 -m venv odoovenv

118  sudo apt update && sudo apt upgrade -y
119  sudo apt install software-properties-common -y
120  sudo add-apt-repository ppa:deadsnakes/ppa
121  sudo apt update
122  sudo apt install python3.10
123  python3
125  sudo unlink python3
126  python3
131  sudo unlink /usr/bin/python3
132  sudo ln -s /usr/bin/python3.10 /usr/bin/python3

134  cd Software/
135  ls
136  source odoovenv/
137  source odoovenv/bin/activate
138  cd odoo-17.0/
139  ls
141  pip install --upgrade pip
142  pip install -r requirements.txt

150  sudo apt install postgresql
154  sudo apt install python3-dev
155  sudo apt install python3.10-dev
156  sudo apt-get install libsasl2-dev python-dev-is-python3 libldap2-dev libssl-dev
157  sudo apt-get install libldap2-dev
158  sudo apt install python3-ldap
159  sudo apt-get install libpq-dev

Note:

Modules/LDAPObject.c:16:10: fatal error: sasl/sasl.h: No such file or directory

when python3.10 installed from source, and python3.10-dev isn't available

apt-get install python-dev libsasl2-dev
 

Note in Ardaldinho server by python3.10.15

ModuleNotFoundError: No module named 'OpenSSL'

$ pip install pyOpenSSL

ModuleNotFoundError: No module named '_cffi_backend'

$ sudo apt remove python3-cffi
$ pip install cffi  #inner venv

ModuleNotFoundError: No module named 'cryptography.hazmat.backends.openssl.x509'
 

$ pip install pyopenssl==21.0.0 #inner venv

AttributeError: module 'lib' has no attribute 'X509_V_FLAG_NOTIFY_POLICY'. Did you mean: 'X509_V_FLAG_EXPLICIT_POLICY'?

 
$ pip install cryptography==3.4.8 #inner venv

 

Resources:

[1] https://github.com/odoo/odoo

[2] fe_sendauth https://stackoverflow.com/questions/17996957/fe-sendauth-no-password-supplied

[3] https://store.webkul.com/odoo-pos-pharmacy-management.html

[4] https://apps.odoo.com/apps/modules/14.0/bi_pos_pharmacy_management

 

Postgres 10/12 into Linux 18

 

sudo systemctl status postgresql.service

sudo systemctl start postgresql.service

sudo systemctl restart postgresql.service

sudo -i -u postgres psql

SELECT version();

pg_config --version

psql --version

CREATE ROLE mysuperuser2 WITH SUPERUSER CREATEDB CREATEROLE LOGIN ENCRYPTED PASSWORD 'mysuperpass2'  

$ sudo vi /etc/postgresql/12/main/pg_hba.conf
 

local   all             postgres                                trust #peer
# TYPE  DATABASE        USER            ADDRESS                 METHOD
# "local" is for Unix domain socket connections only
local   all             all                                     md5 #peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            md5
host    replication     all             ::1/128                 md5

Enable remote access

$ sudo vi /etc/postgresql/12/main/pg_hba.conf

host    all             all             127.0.0.1/32            md5 

host    all             all             192.168.0.1/24            md5 

$ sudo vi /etc/postgresql/12/main/postgresql.conf

listen_address='*' # host1, host2, ..., localhost  
  

Set default Python3

 

 

fincahuanaco@RolumaraT01:~$ sudo unlink /usr/bin/python3              
fincahuanaco@RolumaraT01:~$ sudo ln -s /usr/bin/python3.10 /usr/bin/python3

 fincahuanaco@RolumaraT01:~$ python3
Python 3.10.14 (main, Apr  6 2024, 18:45:05) [GCC 9.4.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> quit()

Python3.10 on Ubuntu18

Manual Installation

sudo apt install software-properties-common
sudo apt install build-essential zlib1g-dev libncurses5-dev libgdbm-dev libnss3-dev libssl-dev libreadline-dev libffi-dev libsqlite3-dev wget libbz2-dev

wget https://www.python.org/ftp/python/3.10.0/Python-3.10.0.tgz

tar -zxvf Python-3.10.0.tgz  
ls
cd Python-3.10.0/
ls

 
./configure --enable-optimizations
make -j $(nproc)
sudo make altinstall
python3.10

 

References:

[1] https://computingforgeeks.com/how-to-install-python-on-ubuntu-linux-system/