[Hidden-tech] Virtual/aliased IP

[Tim Boudreau]

You could, say, rent a virtual machine from a cloud provider like Digital
Ocean for $5/mo or so, and set up an ssh tunnel from there to the
database.  To use the database, you connect the other end of the ssh tunnel
to a local port on your machine, and then have your database tools connect
to that.  The database sees all the connections as coming from the virtual
machine's stable IP address.

Or, if you have the option with whoever is hosting it, just turn off the
configuration option that locks the database down to specific IP addresses,
and use something like client certificates to lock it down instead:
https://icicimov.github.io/blog/database/MySQL-SSL-and-client-certificates-authentication/

-Tim


On Sat, Oct 21, 2017 at 2:26 PM, Tom Murray <tmurray at cs.umass.edu> wrote:

> *Background*: I'm connecting to a mySQL server (hosted by someone else
> through Dreamhost) and doing some maintenance/reports on the database. I
> was originally using phpmyadmin in a browser and recently switched to an
> ODBC connection so I could use some FileMaker magic for complicated tasks.
> I then discovered that the authentication required the database admin to
> register my IP, so that things work from home but not from other locations
> (unless I send in the other IPs). This must be a common issue for some
> folks with an easy solution, but I have not had to deal with it before.
>
> *The question*: what is the best (and/or least expensive) approach to
> setting up a virtual or aliased IP address, so that I can access this
> server from anywhere and have it look like I am accessing from a constant
> IP? (I'm on a Mac)
>
> many thanks, Tom
>
>
> ===---===---===---===---===---===---===---===---===---===---===
> ---===---===---===---===---===---===---===
>
> Tom Murray, EdD
>
> Chief Visionary and Instigator @ Open Way Solutions —
> www.openwaysolutions.com
>
> Senior Research Fellow in Cognitive Tools, Educational Technology &
> E-Dialogue  @ UMass Amherst — www.tommurray.us
>
> 36 Fruit Street, Northampton MA 01060; phone: is413-then-695-and-2800.
>
>
> _______________________________________________
> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
> Hidden-discuss at lists.hidden-tech.net
>
> You are receiving this because you are on the Hidden-Tech Discussion list.
> If you would like to change your list preferences, Go to the Members
> page on the Hidden Tech Web site.
> http://www.hidden-tech.net/members
>



-- 
http://timboudreau.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20171021/1f9793a9/attachment-0001.html