Scale Firefox and Chrome on HIDPI

Firefox:
about:config
layout.css.devPixelsPerPx --> change value from 1.5 to 3

Chrome
Open a terminal 

sudo gedit /usr/share/applications/google-chrome.desktop

Find this line:

Exec=/usr/bin/google-chrome-stable %U

Change n into 1.5 to 3:

Exec=/usr/bin/google-chrome-stable --force-device-scale-factor=n %U

Save/close, relaunch Chrome.

Change owner all database objects to new role

for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" DBNAME` ; do  psql -c "alter table \"$tbl\" owner to NEWUSER" DBNAME ; done

for tbl in `psql -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" DBNAME` ; do  psql -c "alter table \"$tbl\" owner to NEWUSER" DBNAME ; done

for tbl in `psql -qAt -c "select table_name from information_schema.views where table_schema = 'public';" DBNAME` ; do  psql -c "alter table \"$tbl\" owner to NEWUSER" DBNAME ; done

Kill session on Linux

detect sessions
who

list process id off specified session (ex pts/3 )
ps -dN|grep pts/3

kill processid
kill -9 processid

--
kill all sessions of specified user
skill -KILL -u name_of_user

VirtualBox common command

VBoxManage hostonlyif create
VBoxManage hostonlyif ipconfig vboxnet0 --ip 192.168.56.1
vboxmanage export vmname -o vmname.ova
vboxmanage import vmname.ova

VBoxManage list vms

vboxmanage clonevm "currentmachine" --name NewMachineName --register

VBoxManage startvm "Machine_Name" --type headless

VBoxManage controlvm "Machine_Name" poweroff | reset | savestate

VBoxManage unregistervm "Machine_Name" --delete

Config CPUs:
VBoxManage modifyvm "vm name" --cpuhotplug off
VBoxManage modifyvm "vm name" --cpus 4

Config Memory:
VBoxManage modifyvm "vm name" --memory 16000

sudo VBoxManage extpack install --replace Oracle_VM_VirtualBox_Extension_Pack.vbox-extpack


vboxmanage dhcpserver modify --netname HostInterfaceNetworking-vboxnet0 --disable
vboxmanage list dhcpservers

Change font size eclipse global

Edit file

eclipse\plugins\org.eclipse.ui.themes_1.2.1.v20170809-1435\css\e4_basestyle.css

Add content

* {
font-size: 12px;
}

Change git location on eclipse config

View fileon

/home/user/eclipse/workspaces/workspace1/.metadata/.plugins/org.eclipse.core.runtime/.settings/org.eclipse.egit.core.prefs

Encrypt data postgres

CREATE EXTENSION pgcrypto;

 

SELECT ENCODE(DIGEST('sometext','sha256'),'hex');

 

locale debian

export LANGUAGE=en_US.UTF-8
export LANG=en_US.UTF-8
export LC_ALL=en_US.UTF-8
locale-gen en_US.UTF-8
dpkg-reconfigure locales

Change force ssl roundcude

Change parameter force_https in path /opt/www/roundcubemail/config/config.inc.php

Setup OpenVPN

Server
1. Install openvpn
apt-get install openvpn

2. Install easy-rsa
apt-get install easy-rsa

3. Config easy-rsa

4. Config openvpn

Client
1. Install openvpn

2. Config openvpn

Install pgadmin4 on Ubuntu

apt-get install virtualenv python-pip libpq-dev python-dev

wget whl file

mkdir pgadmin4

cd pgadmin4

virtualenv .

source bin/activate

pip install whlfile

echo "SERVER_MODE = False" >> lib/python2.7/site-packages/pgadmin4/config_local.py

sudo -s

mkdir /var/lib/pgadmin

mkdir /var/log/pgadmin

chmod gbsofts:gbsofts /var/lib/pgadmin

chmod gbsofts:gbsofts /var/log/pgadmin

exit


Create desktop icon
nano pgadmin4.desktop
#!/usr/bin/env xdg-open

[Desktop Entry]
Version=1.0
Type=Application
Terminal=false
Icon[en_US]=gnome-panel-launcher
Name[en_US]=PgAdmin4
Exec=bash /home/gbsofts/pgadmin4/pgadmin4.sh
Name=PgAdmin4
Icon=/home/gbsofts/pgadmin4/logo-128.png

chmod 755 pgadmin4.desktop

Create script
nano pgadmin4.sh
cd $HOME/pgadmin4
source bin/activate
python ./lib/python2.7/site-packages/pgadmin4/pgAdmin4.py  &
sleep 5; chromium-browser --app=http://localhost:5050

Enable socket admin Haproxy

The stats socket is not enabled by default. In order to enable it, it is
necessary to add one line in the global section of the haproxy configuration.
A second line is recommended to set a larger timeout, always appreciated when
issuing commands by hand :

    global
        stats socket /var/run/haproxy.sock mode 600 level admin
        stats timeout 2m

It is also possible to add multiple instances of the stats socket by repeating
the line, and make them listen to a TCP port instead of a UNIX socket. This is
never done by default because this is dangerous, but can be handy in some
situations :

    global
        stats socket /var/run/haproxy.sock mode 600 level admin
        stats socket ipv4@192.168.0.1:9999 level admin
        stats timeout 2m