I wanted to add that I was finally able to get this working, so I thought I would share. Clearly the UTM is locked down and doesn't allow access to the database from external sources. Instead of playing with IP Tables and possibly making the firewall weaker, I did the following:
-Logged into Webadmin, Enabled SSH, set password for LoginUser account
-Created a PuTTY session to UTM internal address from internal network, setting up a port forward tunnel. I mapped local port 5432 to 127.0.0.1:5432 (in this case, 127.0.0.1 refers to the UTM, i.e. the other end of the tunnel)
-Installed pgAdmin 4.1 and entered 127.0.0.2 (backup localhost address for Windows PCs.. may work with .1, but I've had issues using .1 w/RDP port tunneling in the past, so it's habit) as the IP to use, and boom went right in.
Hope this helps someone else. Now I just need to figure out where to change the setting for SMTP Logging. I can't deal with 30 days.. I run a small mail server with not a lot of traffic. I'll start with 90, but may go as high as 180.
This was done on a Windows 7 x64 PC from the local network to the UTM.
Could you please show me how to setup a port forward tunnel. I've created it but still can't connect to postgresql.
First, I connect to the UTM via putty, then run this command:
# ssh - L 3000:127.0.0.1:5432 "UTM_IP"
In pgAdmin on my Laptop, I entered the following:
Did I do something wrong? Please help.
Thank you very much