Thursday, June 28, 2018

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

Thursday, June 7, 2018

Encrypt data postgres

CREATE EXTENSION pgcrypto;
 
SELECT ENCODE(DIGEST('sometext','sha256'),'hex');
 

Tuesday, June 5, 2018

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

Monday, June 4, 2018

Change force ssl roundcude

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

Monday, April 30, 2018

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

Tuesday, March 27, 2018

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