Ubuntu 20 GLIBC 2.31 to 2.35

Error: version `GLIBC_2.34' not found 

 

You should be able to use any of the listed mirrors by adding a line to your /etc/apt/sources.list like this:

deb http://security.ubuntu.com/ubuntu jammy-security main 

 

sudo apt update
sudo apt install libc6 

References:

[1] https://packages.ubuntu.com/jammy/amd64/libc6/download

[2] https://stackoverflow.com/questions/71940179/error-lib-x86-64-linux-gnu-libc-so-6-version-glibc-2-34-not-found 

 

Ubuntu Desktop Info

 

systemctl status display-manager.service
echo $XDG_CURRENT_DESKTOP
XFCE
echo $DESKTOP_SESSION
xfce
 

Ubuntu 20 and Nautilus thumbnails problem

Linux Lite 5.8 with Ubuntu 20 does not show all thumbnails after settings

sudo apt-get install ubuntu-restricted-extras

 

Text to Voice online tools and codes

 Text to Voice

[1] Free 2k https://luvvoice.com/es 

[2] Short text to voice https://clowerweb.github.io/kitten-tts-web-demo/

 

Upgrade old Android to 10 in Sony Xperia

 https://dev.androidfilehost.com/?w=files&flid=295879&sort_by=name&sort_dir=ASC

 https://twrp.me/sony/sonyxperia10.html

 

https://get.pixelexperience.org/devices

 

https://twrp.me/Devices/

 

Popular adb commands

• adb shell - launches a shell on the device
• adb push <local> <remote> - pushes the file <local> to <remote>
• adb pull <remote> [<local>] - pulls the file <remote> to <local>. If <local> isn’t specified, it will pull to the current folder.
• adb logcat - allows you to view the device log in real-time. You can use adb logcat -b radio to view radio logs, and adb logcat -C to view logs in colour
• adb install <file> - installs the given .apk file to your devic

 

https://xdaforums.com/t/guide-full-phone-backup-without-unlock-or-root.1420351/

 

Sunat padron

 

 

awk -F\| '{print>$1}' file1

awk -F\| '{print $1","$2","$5","$6" "$7" "$10","$8" "$9}' padron_reducido_ruc.txt > padron_reducido_rucname.c
sv

 

iconv -f ISO-8859-1 -t UTF-8 in.txt > out.txt

 

Odoo Compress/UnCompress

 

 [1]  https://github.com/nodeca/pako 

PoS Cache system

 

[1] Odoo Cache system in PoS https://www.cybrosys.com/blog/how-to-store-values-in-pos-cache-in-odoo-17

 

Líneas telefónicas Perú

 

[1] Verifica https://checatuslineas.osiptel.gob.pe/ 

Arduino Accesories

 [1] https://sawers.com.pe/modulo-lector-micro-sd-para-arduino-? 

[2] https://www.electromania.pe/productos/raspberry/placas/page/3 

Audio tools AI

 [1] Audio enhancer https://audioenhancer.ai/

 

Algorithms

 

[1] Introduction to Algorithms 3rd Edition Cormen https://fun4yo.xyz/book/introduction-to-algorithms-3rd-edition/ 

[2]  

 

Malware scan

[1] 250Mb https://virusscan.jotti.org/en-US/scan-file

[2] https://metadefender.com/

[3] 50Mb https://nordvpn.com/file-checker/

[4] https://internxt.com/virus-scanner 

[5] 100Mb https://www.joesandbox.com/

 

gedit mutiple windows problem

gsettings set org.gnome.gedit.preferences.ui show-tabs-mode 'always'
 

gsettings get org.gnome.gedit.preferences.ui show-tabs-mode

 

gsettings list-recursively org.gnome.gedit.preferences.ui         
org.gnome.gedit.preferences.ui bottom-panel-visible false
org.gnome.gedit.preferences.ui max-recents uint32 5
org.gnome.gedit.preferences.ui statusbar-visible true
org.gnome.gedit.preferences.ui show-tabs-mode 'always'
org.gnome.gedit.preferences.ui side-panel-visible false
org.gnome.gedit.preferences.ui toolbar-visible true

 

Common online tools

OCR

[1]  https://ocr.space/ 

 

Vectorize PNG to SVG

No Login 

[1] https://www.freeconvert.com/png-to-svg 

[2] https://svg-converter.com/potrace 

Loging required

[2] https://www.recraft.ai

[3] https://iconscout.com/ai/vectorizer

 

 

 

 

 

 

 

 

 

Python3 version alternatives and virtual environments

Solving multiple python installation:

sudo update-alternatives --install /usr/bin/python3 python3 /usr/bin/python3.5 1

sudo update-alternatives --install /usr/bin/python3 python3 /usr/bin/python3.6 2

sudo update-alternatives --install /usr/bin/python3 python3 /usr/local/bin/python3.10 3
 

sudo update-alternatives --config python3

Solving:

Error: Command '['/home/DRIVE/Temp/aa/bin/python3.9', '-Im', 'ensurepip', '--upg
rade', '--default-pip']' returned non-zero exit status 1.
 

apt-get install python3.6-dev python3.6-venv

python3.6 -m venv myVenv 

Upgrade pip

pip3 install --upgrade pip

 

Ubuntu 18 - Print Screen Key

Menu settings/keyboard

gnome-screenshot #default print screen

xfce4-screenshooter  #dialog to choose complete/area screen to capture

 

Vitamina D - Cancer

[1] https://ensedeciencia.com/2023/10/14/la-potente-vitamina-que-protege-frente-al-cancer-de-prostata-y-otros-tipos-de-cancer/

Odoo 17 - Custom adds

 

 

[1] Diario/Seq https://apps.odoo.com/apps/modules/17.0/sequence_for_journal

 

Ubuntu list services

 

sudo systemctl list-units

pgadmin4 issues on ubuntu 18

Ubuntu 18.04.5 LTS (Bionic Beaver)
 

pgadmin4-desktop pgadmin4-server pgadmin4-web

 

ImportError: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.28' not found (required by /usr/pgadmin4/venv/lib/python3.8/site-packages/cryptography/hazmat/bindings/_rust.abi3.so)

 

 fincahuanaco  ~  ldd --version
ldd (Ubuntu GLIBC 2.27-3ubuntu1.4) 2.27
Copyright (C) 2018 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
Written by Roland McGrath and Ulrich Drepper.

fincahuanaco  ~  sudo /usr/pgadmin4/bin/setup-web.sh

ImportError: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.28' not found (required by  
/usr/pgadmin4/venv/lib/python3.8/site-packages/cryptography/hazmat/bindings/_rust.abi3.so)
Error setting up server mode. Please examine the output above.

Docker Alternative

 fincahuanaco  ~  docker pull dpage/pgadmin4

 

sudo docker run -p 5050:5050 -e 'PGADMIN_DEFAULT_EMAIL=email@gmail.com' -e 'PGADMIN_DEFAULT_PASSWORD=password' -e 'PGADMIN_LISTEN_PORT=5050' -d dpage/pgadmin4

 

sudo docker ps

CONTAINER ID   IMAGE            COMMAND            CREATED          STATUS          PORTS     NAMES
2b0f1c329504   dpage/pgadmin4   "/entrypoint.sh"   25 minutes ago   Up 25 minutes             awesome_darwin

sudo docker stop 2b0f1c329504



sudo docker inspect 2b0f1c329504 | grep IPAddress  #discovery ip

 

#force use local network

sudo docker run -p 5050:5050 --network host -e 'PGADMIN_DEFAULT_EMAIL=email@gmail.com' -e 'PGADMIN_DEFAULT_PASSWORD=password' -e 'PGADMIN_LISTEN_PORT=5050' -d dpage/pgadmin4

 

Resume docker containers

$ sudo docker start  $(sudo docker ps -q -l)

 

Docker References:

 

[1] https://hub.docker.com/r/dpage/pgadmin4/

[2] Deploy https://www.pgadmin.org/docs/pgadmin4/latest/container_deployment.html

[3] https://stackoverflow.com/questions/53610385/docker-postgres-and-pgadmin-4-connection-refused

[4] Resume docker container https://stackoverflow.com/questions/21928691/how-to-continue-a-docker-container-which-has-exited

 

 

 

IPTV

 

Resources:

[1] https://iptv-org.github.io/

 

Photo Animation

 

Resources:

[1] AI Animation https://vivago.ai/video-generation

[2] Remove BG https://www.remove.bg/upload

 

Run python request over proxy

Code

import requests

proxies = {
   'http': 'http://72.10.160.172:9739',
}

url = 'https://httpbin.io/ip'
response = requests.get(url, proxies=proxies)
print(response.json())
 

 

 

References:

[1] https://www.zenrows.com/blog/python-requests-proxy#perform-requests

[2] https://free-proxy-list.net/

[3] https://stackoverflow.com/questions/57579359/use-python-sshtunnel-for-port-forwarding-rest-request

 

Ubuntu Forware port 80

 

#!/bin/bash
iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 80 -j REDIRECT --to-port 8069
iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 443 -j REDIRECT --to-port 8070
iptables-save

 

Permanent in system by:

$sudo vi /etc/rc.local

References:

https://www.odoo.com/forum/help-1/change-to-port-80-instead-of-8069-23031

 

PostgreSQL json fields

select name->'es_PE',* from product_template where name->>'es_PE' like '%MEGACI%'

 

References:

[1] https://popsql.com/learn-sql/postgresql/how-to-query-a-json-column-in-postgresql

Ubuntu VGA Resolutions

 

References:

[1] https://pendrivelinux.com/vga-boot-modes-to-set-screen-resolution/

 

Ubuntu add user easily

 

 

$sudo adduser pharmaquipa

$sudo usermod -aG sudo pharmaquipa #add to sudo group

References

[1] https://www.digitalocean.com/community/tutorials/how-to-create-a-new-sudo-enabled-user-on-ubuntu

[2] https://phoenixnap.com/kb/how-to-create-sudo-user-on-ubuntu

Facturador Sunat SFS (Linux)

 

 

/usr/lib/jvm/java-8-openjdk-amd64/bin/java -jar ./facturadorApp-2.1.jar server prod.yaml

References:

[1] SFS(Sistema Facturador SUNAT) https://orientacion.sunat.gob.pe/6790-07-descarga-del-facturador

[2] Make temp certificate for test https://llama.pe/facturador-sunat-see-sfs-certificado-digital
 

Audacious Skins

 Winamp skins for Linux

https://lunduke.substack.com/p/miss-winamp-try-audacious-the-winamp

Notes run odoo 16 venv

Using previous virtual environment (~python 3.10)

pip install --upgrade pip
 

pip install lxml==5.1.0

pip3 install Werkzeug==2.0.2

pip install pyOpenSSL

pip3 install docutils
 

pip3 install num2words
 

 Trying on python3.8 by empy virtual environment

python3.8 -m pip install virtualenv

python3.8 -m virtualenv test  

source test/bin/activate     
 

sudo apt install python3.8-dev 

 

pip install -r requirements.txt
 

python3 odoo-bin --http-port=1616 -d enter02

 

Update pgadmin

pgadmin4 on web by python

$sudo mkdir /var/lib/pgadmin
$sudo mkdir /var/log/pgadmin
$sudo chown $USER /var/lib/pgadmin
$sudo chown $USER /var/log/pgadmin
$python3 -m venv pgadmin4
$source pgadmin4/bin/activate
(pgadmin4) $ pip install pgadmin4
(pgadmin4) $ pgadmin4

Change port, by default is 5050 but if you want to change(on the venv):

$PGADMIN_INT_PORT=6060 pgadmin4/bin/pgadmin4
 

Change the credentials(on the venv):

$pgadmin4/bin/pgadmin4-cli add-user email@gmail.com password


 

Remove credentials:

$ls /var/lib/pgadmin/storage
 

Enable remote access to pgadmin4

$vi pgadmin4/lib/python3.10/site-packages/pgadmin4/config.py
 

[1] https://www.digitalocean.com/community/tutorials/how-to-install-configure-pgadmin4-server-mode

 

References:

[1] https://www.pgadmin.org/download/pgadmin-4-python

[2] https://gcore.com/learning/how-to-install-pgadmin4-on-ubuntu/

AI Dog identifiers

 Online

[1] https://www.nyckel.com/pretrained-classifiers/dog-breed-identifier/

PostgreSQL command tools

 

Database size

select pg_size_pretty( pg_database_size('dbname') );


Tables order by size

select
  table_name,
  pg_size_pretty(pg_total_relation_size(quote_ident(table_name))),
  pg_total_relation_size(quote_ident(table_name))
from information_schema.tables
where table_schema = 'public'
order by 3 desc;

References:

https://stackoverflow.com/questions/21738408/postgresql-list-and-order-tables-by-size

 

Video edition issues

 Merge Video and Audio

ffmpeg -i video.mp4 -i audio.mp3 -c:v copy -c:a aac output.mp4

Android by VMWare on Linux

VMWare paremeters

• bios.forceSetupOnce = "TRUE"
  
• bios.bootDelay = "xxxx"

Resources

[1] Android images http://www.osboxes.org/android-x86/

References
[1] https://kb.vmware.com/s/article/1004129
[2] http://siliseed.com/2013/08/instalar-android-en-una-maquina-virtual-windows.html
[3] https://android.stackexchange.com/questions/141700/how-to-fix-android-x86-install-on-vmware
[4] https://android.stackexchange.com/questions/144535/android-x86-marshmallow-not-booting-on-virtualbox-and-vmware-workstation