Issues connecting from the Pgadmin4 QueryTool over a VPN connection

See also questions close to this topic

• Changing Dynamic IP Address Netowork via OpenVPN cli

  I am setting up my OpenVPN via terraform, I am trying to figure out is how to set the Dynamic IP network address via the ./sacli

  I'm doing same thing for setting the hostname

  ./sacli --key "host.name" --value "myhost" ConfigPut

  But I cannot find any documentation for changing the dynamic ip address network.. currently its set to its default "172.27.224.0", I would like to be able to set this during installation so that i know the address scheme ahead of time rather than manually setting it in the UI

  Any idea how to change that or a place that gives the entire list of keys from the sacli?
• OpenWRT: Signature file download failed. wget returned 8

  I have a GL-iNet GL-AR300M. I was having some problems with OpenVPN using two different VPN services on firmware 2.x, so I decided to update to firmware 3.x to see if that would resolve the issue. Firmware 3.x is based on OpenWRT.

  Having installed this new firmware, I have discovered to my surprise that OpenVPN support is not included by default and I am supposed to install it. That's fine, but trying to install it - and even trying to update opkg results in a string of error messages like:

  Downloading http://download.gl-inet.com/releases/kmod-3.0/ar71xx/nand/Packages.gz
  Updated list of available packages in /var/opkg-lists/glinet_core
  Downloading http://download.gl-inet.com/releases/kmod-3.0/ar71xx/nand/Packages.sig
  Signature file download failed. Remove wrong Signature file.
  

  Browing to the repository in my browser confirms that the .sig files are missing. So...

  1. Why are they missing?

  2. Is there an alternative download location that I can use that actually contains these missing files?

  3. If not, is it possible to not need those files?

  In addition, I then get this:

  Collected errors:
  * opkg_download: Failed to download http://download.gl-inet.com/releases/packages-3.x/ar71xx/generic/base/Packages.gz, wget returned 8.
  * opkg_download: Failed to download http://download.gl-inet.com/releases/packages-3.x/ar71xx/generic/gli_pub/Packages.gz, wget returned 8.
  * opkg_download: Failed to download http://download.gl-inet.com/releases/packages-3.x/ar71xx/generic/packages/Packages.gz, wget returned 8.
  * opkg_download: Failed to download http://download.gl-inet.com/releases/packages-3.x/ar71xx/generic/luci/Packages.gz, wget returned 8.
  * opkg_download: Failed to download http://download.gl-inet.com/releases/packages-3.x/ar71xx/generic/routing/Packages.gz, wget returned 8.
  * opkg_download: Failed to download http://download.gl-inet.com/releases/packages-3.x/ar71xx/generic/telephony/Packages.gz, wget returned 8.
  * opkg_download: Failed to download http://download.gl-inet.com/releases/packages-3.x/ar71xx/generic/glinet/Packages.gz, wget returned 8.
  

  I noticed that the firmware that GL-iNet provides is based on OpenWRT 18.06.0-rc1. The latest version of the firmware however is 18.06.2. Since sysupdate also fails with similar error messages, I thought perhaps I could simply flash the device myself with the latest version of OpenWRT. However, I see that there are several possible options at https://downloads.openwrt.org/releases/18.06.2/targets/ar71xx/nand/ and GL-iNet's firmware file name (gl-ar300m-3.0-1011_clean) offers no indication of which one I might need. I do know that it's somewhere within ar71xx though because of the opkg errors. So...

  1. Does anyone know which firmware I need to download from OpenWRT directly in order to flash onto a GL-iNet GL-AR300M?

  2. If not, does anyone know how I might be able to deduce this information myself? Is there some config file or something on the image that would reveal it? I don't want to potentially brick my system by uploading an incorrect image.

  Thanks in advance!
• Can OpenVPN (for Linux) connect to a VPN through a jumpbox?

  I use MacOS at work, where I connect to a VPN (using Tunnelblick). We use a "jumpbox" to proxy requests to the VPN server itself. I have an ovpn file, username and password for the VPN, plus a username and pem file to get into the jump server.

  In Tunnelblick, there's an option for assigning a proxy server and username/cert file. I don't see such an option using OpenVPN on Linux (Fedora 29) using the default network manager (kcm_networkmanagement ), though. Is there a way to use a jump server in Fedora's OpenVPN client? If not, is there another OpenVPN client that might work?

  I've tried Frohu client, but I don't see any jump server / proxy options there. I've also tried using OpenVPN from the command line, but openvpn --config <my config file> never asks for a proxy option, and the man page help doesn't seem to support jump servers, as far as I can tell.
• What is right sql query format to update a table in POSTGRESQL Database using pgAdmin?

  I am using Postgres 11 and pgAdmin 3.2. I keep getting errors in several standard SQL queries. Most of the time error is column does not exist despite of having columns. I am trying to update my table with where clause. I am following standard SQL query format for postgres. But it's not working.

  Here is my query:

  Update test 
  set NAME = 'Jem' 
  where Name = 'M';
  

  and error I get is

  ERROR: column "name" does not exist
  LINE 2: set NAME = 'Jem' where name='M'
• How to save pgAdmin layout

  Each time I re-open pgAdmin I have to open the path to my database tables. Is there a way to have the path saved so it automatically re-opens to the desired layout?
• Unable to find server dropdown in pgadmin4

  I am unable to find plus symbol or dropdown at server in pgadmin4.

  Attached the image of error message. Please help.