On Sat, Jun 30, 2012 at 11:25 PM, V G wrote: > Hi all, > > Thank you to everyone for reading and replying to the Database Encryption > thread. This is what I've decided to do: > > The doctor has a spare old computer sitting on his desk doing nothing, so > I'm going to turn it into a server: > - I'm going to assume all ports are blocked on the hospital's network, so > I'm going to buy him a cheap Ethernet router and hook up his desktop > computer as well as the server to it so that ports won't be blocked withi= n > the subnet. > - The hard drive will be fully encrypted. > - It will run Linux, probably Ubuntu server edition. > - It will run Apache, PHP, and PostgreSQL servers. The database will be > stored as clear text as well as all data it contains. > - I will install some kind of software to automatically update its dynami= c > IP to a hostname (like no-ip.com). > - (1.) It needs to have some some kind of SSH server or VNC type thing so > I can, at the very least, SSH into it for administration and maintenance > from home. > - (2.) Or, A VPN server would be very useful so I can connect to the > network from home and test out my website and database access as well as > login to the server. > > Note: I also don't want to run any servers on my home computer or open up > any ports. > > > 1. I don't know too much about the inner workings of local area networks > and how the ports and port blocking works as well as how it affects serve= rs > listening on those ports. Going to study that stuff now. Assuming that th= e > hospital IT department "blocked off/firewalled" everything, how can I run > an SSH server so that I can login from home for administration? I think I > would need to install some kind of HTTP tunnel server thing, but again, i= f > port 80 is blocked, how would that work exactly? > > Anyway, even if port 80 is blocked, I have my webhost which I can use as = a > HTTP tunnel server/proxy for this sort of thing ( > http://http-tunnel.sourceforge.net/) where all requests will be > client-HTTP requests to the webhost-server which will be guaranteed to wo= rk. > > 2. Again, I don't really know how a VNC server would work behind a > firewall. > > > > So I'm thinking something like this (view png image): > http://i.minus.com/iriCxRbtJMA4J.png (also attached as *.png) > > > What do you guys think? Is there a better way to do this? I bet the way I > drew up will be pretty slow and frustrating. > Update: scratch the automatic update of IP. The external IP of a computer on the subnet will be the IP of the router anyway. Question: how can two computer under one router run a HTTP server on port 80 simultaneously? How would they be accessed (since their external IP is the IP of the router)? --=20 http://www.piclist.com PIC/SX FAQ & list archive View/change your membership options at http://mailman.mit.edu/mailman/listinfo/piclist .