Wednesday, June 26, 2024

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

Friday, June 21, 2024

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


Thursday, June 20, 2024

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/

Friday, June 14, 2024

VPS 2024

 

 

References:

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

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

Thursday, June 13, 2024

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
 

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

 


Tuesday, June 11, 2024

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

  

Monday, June 10, 2024

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/

PostgreSQL command tools

  Database size select pg_size_pretty( pg_database_size('dbname') ); Tables order by size select   table_name,   pg_size_pretty(pg_...