Issues connecting from the Pgadmin4 QueryTool over a VPN connection

See also questions close to this topic

• is it possible to write OpenVPN plugin in python?

  I want to use my own python authentication script which uses RADIUS in OpenVPN server, but I can't figure out how to make it work from the server config file. I have tried this setting in server.conf:

     plugin '/etc/openvpn/pyradplugin/venv/bin/python3.5' '/etc/openvpn/pyradplugin/pyradplugin.py'
  

  It fails with an error:

  PLUGIN_INIT: could not load plugin shared object /etc/openvpn/pyradplugin/venv/bin/python3.5: /etc/openvpn/pyradplugin/venv/bin/python3.5: cannot dynamically load executable: No such file or directory

  All scripts that i've found for ovpn are writen using C or C++. Is there a way to use python directly without any C code required?
• Shell: How to configure a OpenVPN-Gateway on OpenWRT over one network interface

  I have a TP-Link TL-WR1043ND router with OpenWRT 18.06.01 installed. Now I need a shell script to configure a OpenVPN gateway but not with two network interfaces as normal, one for the VPN connection resp. internet connection and one for a connection to the network behind the router. It must be only one hardware network interface, for example only one ethernet cable connected from the network to the WAN-Port, and both, VPN and the connection to the network itself should exist through this one ethernet cable. The goal is to get access to other devices in the network behind the router and to get access over VPN with this connected cable. I already have a shell script but it doesn't work as I need it. Which Routing commands or firewall commands do I need to get it to work?

  Here is my code in rc.local:

  export NGDS_USER=blabla
  export NGDS_PASS=blabla
  export NGDS_IP=192.168.2.5
  export NGDS_NET=192.168.2.0
  export NGDS_MASK=255.255.255.0
  export NGDS_POOL_START=192.168.2.200
  export NGDS_POOL_END=192.168.2.254
  export NGDS_HTTP_PROXY_IP=
  export NGDS_HTTP_PROXY_PORT=
  export NGDS_REMOTE_HOST=mydomain.de
  export NGDS_REMOTE_PORT=443
  export NGDS_TUN_MTU=1460
  export NGDS_MSS_FIX=1450
  export NGDS_ADD_VPN_USER=""
  export NGDS_ADD_ROUTES=""
  export NGDS_OPKG_DEPENDENCIES="ip luci tcpdump nano openvpn-openssl usbutils comgt kmod-usb2 kmod-usb-ohci kmod-usb-uhci kmod-usb-serial kmod-usb-serial-option kmod-usb-serial-wwan kmod-usb-acm usb-modeswitch luci-proto-3g kmod-usb-storage kmod-usb-net-cdc-ether"
  export NGDS_SOFTWARE_VERSION=23
  
  # Create Proxy String
  if [ -z "$NGDS_HTTP_PROXY_IP" ] || [ -z "$NGDS_HTTP_PROXY_PORT" ]
  then
  NGDS_PROXY_STRING=""
  else
  NGDS_PROXY_STRING="http-proxy $NGDS_HTTP_PROXY_IP $NGDS_HTTP_PROXY_PORT"
  export http_proxy="http://$NGDS_HTTP_PROXY_IP:$NGDS_HTTP_PROXY_PORT"
  fi
  
  
  #echo "Sleeping 10 Seconds"
  #sleep 10
  
  mkdir /tmp/openvpncl
  
  
  echo "$NGDS_USER
  $NGDS_PASS" > /tmp/openvpncl/auth-client
  
  
  echo "client
  dev tap0
  proto tcp `echo -e "\n$NGDS_PROXY_STRING"`
  remote $NGDS_REMOTE_HOST $NGDS_REMOTE_PORT
  resolv-retry infinite
  nobind
  persist-key
  persist-tun
  tun-mtu $NGDS_TUN_MTU
  tun-mtu-extra 32
  mssfix $NGDS_MSS_FIX
  keepalive 10 30
  ca /tmp/openvpncl/ca.crt
  auth-user-pass /tmp/openvpncl/auth-client
  writepid /tmp/openvpncl/vpn-client.pid
  pull
  comp-lzo" > /tmp/openvpncl/vpn-client.conf
  
  
  
  echo "UserBLA:PWDBla`echo -e "\n$NGDS_ADD_VPN_USER"`" > /tmp/openvpncl/auth-server
  
  
  
  echo "#!/bin/sh
  
  #set>/tmp/openvpncl/auth-diag-server.txt
  
  if [ \"\`cat /tmp/openvpncl/auth-server | grep \$username:\$password\`\" == \"\$username:\$password\" ]
  then exit 0
  fi
  
  exit 1" > /tmp/openvpncl/auth-script.sh
  
  
  
  
  echo "mode server
  tls-server
  proto tcp-server
  port 8443
  #port-share 192.168.100.2 20443
  multihome
  dev tap1
  ifconfig $NGDS_NET $NGDS_MASK
  ifconfig-pool $NGDS_POOL_START $NGDS_POOL_END $NGDS_MASK
  push \"route-gateway $NGDS_IP\"
  #push \"route 192.168.100.0 255.255.255.0\"
  passtos
  comp-lzo
  keepalive 8 30
  tun-mtu 1500
  tun-mtu-extra 32
  mssfix 1450
  persist-key
  persist-tun
  persist-local-ip
  persist-remote-ip
  duplicate-cn
  verb 1
  dh /tmp/openvpncl/dh1024.pem
  pkcs12 /tmp/openvpncl/pkcs12.p12
  writepid /tmp/openvpncl/vpn-server.pid
  verify-client-cert
  auth-user-pass-verify \"/tmp/openvpncl/auth-script.sh\" via-env
  username-as-common-name
  push \"dhcp-option DNS $NGDS_IP\"
  push \"dhcp-option WINS $NGDS_IP\"
  #push \"dhcp-option DOMAIN neugartds.local\"" > /tmp/openvpncl/vpn-server.conf
  
  echo "#!/bin/sh
  
  if [ ! -f /proc/\`cat /tmp/openvpncl/vpn-client.pid\`/exe ];
  then
  echo Restarting OpenVPN Client
  /tmp/openvpncl/start-client.sh
  fi
  
  if [ ! -f /proc/\`cat /tmp/openvpncl/vpn-server.pid\`/exe ];
  then
  echo Restarting OpenVPN Server
  /tmp/openvpncl/start-server.sh
  fi
  
  `which wget` http://update.getcharged.de/wrt/checkscript.sh -O /tmp/openvpncl/checkscript.sh
  if [ -f /tmp/openvpncl/checkscript.sh ]
  
  then
  /bin/chmod 755 /tmp/openvpncl/checkscript.sh
  /tmp/openvpncl/checkscript.sh
  /bin/rm /tmp/openvpncl/checkscript.sh
  fi"> /tmp/openvpncl/check-vpn.sh
  
  
  echo "#!/bin/sh
  VPNCLIENTPID=\$(cat /tmp/openvpncl/vpn-client.pid)
  kill -9 \$VPNCLIENTPID
  /usr/sbin/openvpn --config /tmp/openvpncl/vpn-client.conf --auth-user-pass /tmp/openvpncl/auth-client --route-up /tmp/openvpncl/route-up.sh --down /tmp/openvpncl/route-down.sh --script-security 3 --daemon" > /tmp/openvpncl/start-client.sh
  
  
  echo "#!/bin/sh
  VPNSERVERPID=\$(cat /tmp/openvpncl/vpn-server.pid)
  kill -9 \$VPNSERVERPID
  /usr/sbin/openvpn --config /tmp/openvpncl/vpn-server.conf --route-up /tmp/openvpncl/route-up.sh --up /tmp/openvpncl/bridge-up.sh --down /tmp/openvpncl/route-down.sh --script-security 3 --daemon" > /tmp/openvpncl/start-server.sh
  
  echo "#!/bin/sh
  /usr/sbin/brctl addif br-lan \$dev"> /tmp/openvpncl/bridge-up.sh
  
  
  
  echo "#!/bin/sh
  iptables -I FORWARD -i br-lan -o tap+ -j ACCEPT
  iptables -I FORWARD -i tap+ -o br-lan -j ACCEPT
  iptables -I INPUT -i tap+ -j ACCEPT
  iptables -I INPUT -p tcp --dport 8443 -j ACCEPT
  iptables -I FORWARD -i eth0.2 -o lo ACCEPT
  
  # Additional Routes
  $NGDS_ADD_ROUTES" >/tmp/openvpncl/route-up.sh
  
  echo "#!/bin/sh
  iptables -I FORWARD -i br-lan -o tap+ -j ACCEPT
  iptables -I FORWARD -i tap+ -o br-lan -j ACCEPT
  iptables -I INPUT -i tap+ -j ACCEPT
  iptables -I INPUT -p tcp --dport 8443 -j ACCEPT
  iptables -I FORWARD -i eth0.2 -o lo ACCEPT
  
  # Additional Routes
  $NGDS_ADD_ROUTES" >/tmp/openvpncl/route-down.sh
  
  
  echo -e "(deleted certificate code here because of length)"> /tmp/openvpncl/neugvpn.tar.bz2
  
  tar xvpf /tmp/openvpncl/neugvpn.tar.bz2 -C /tmp/openvpncl/
  rm /tmp/openvpncl/neugvpn.tar.bz2
  
  
  
  echo "#!/bin/sh
  
  opkg update
  
  for dependency in \$NGDS_OPKG_DEPENDENCIES
  do
          if [ \`opkg status \$dependency | wc -l\` == 0 ]
          then
          opkg install \$dependency
          fi
  done">/tmp/openvpncl/check-tools.sh
  
  
  echo "#!/bin/sh
  
  if ! \$(crontab -l | grep -iq check-vpn.sh); then
  echo \"*/5 * * * * /tmp/openvpncl/check-vpn.sh\">>/etc/crontabs/root
  fi">/tmp/openvpncl/check-crontabs.sh
  
  
  chmod 755 /tmp/openvpncl/*.sh
  
  echo $NGDS_SOFTWARE_VERSION>/tmp/openvpncl/NGDS_Version
  
  
  echo "Finished"
  
  echo "Applying Firewall Rules"
  iptables -I INPUT 1 -p tcp --dport 22 -j ACCEPT
  iptables -I FORWARD -i br-lan -o tap+ -j ACCEPT
  iptables -I FORWARD -i tap+ -o br-lan -j ACCEPT
  iptables -I INPUT -i tap+ -j ACCEPT
  iptables -I INPUT -p tcp --dport 8443 -j ACCEPT
  
  
  
  #echo "Sleeping 30 Seconds"
  #sleep 30
  /tmp/openvpncl/start-client.sh
  /tmp/openvpncl/start-server.sh
  
  #echo "Sleeping 10 Seconds"
  #sleep 10
  /tmp/openvpncl/check-tools.sh
  /tmp/openvpncl/check-vpn.sh
  /tmp/openvpncl/check-crontabs.sh
  
  exit 0
  
• OpenVPN capture packet p2p

  I am trying to capture packet (only try to get the dst and src IP) via OpenVPN by creating an OpenVPN server and starting to sniff between a game connection(P2P). So packets would go like this:

  me -> VPN -> players. 
  

  I tried tcpdump but I only got packet between server (OpenVPN) and me but not from players. Am I doing wrong?

  tcpdump udp
  

  and result:

  03:42:18.980419 IP dyn-1xx-xx9-xx2-xx.nexicom.net.57472 > instance-x.us-east1-b.c.xxxx.internal.443: UDP, length 76
  
• How do I create a column inside a table based on a query in sql?

  I'm sure this is a very simple question.

  I have a table with a column that has a series '1' and '0'.

  I want to create two more columns. On column with only '1' and another with only '0'.

  I was able to get data based on this information with:

  SELECT (Column_name) From table_name AS number_o_ones WHERE Column_name=1;

  I don't know how to turn that into a proper column inside of the table though.

  Thank you for your help. If you have any questions let me know.
• pgAdmin 4 how to upgrade version?

  I have looked and looked on pgAdmin's website for where to ask this simple question, but can't find any sort of forum for support.

  I get this message popping up on my pgAdmin (browser) version:

  You are currently running version 2.0 of PgAdmin4, however the current version is 3.4.  Please click here for more information.
  

  But that click doesn't tell me HOW to upgrade. It just has a link to download, something. There's a download for MacOs, and one for Windows, but not one for Ubuntu, which I have.

  I just want to find a step-by-step instructions for what to do. Obviously I did it at one time, but I can't remember what I did.

  Where can I find up-to-date instructions for how to upgrade?