One thing that hasn't been addressed (I don't think) is why there is a second system (remote at that) being added to the mix. In terms of a VPN, yes - that's just a tunnel to your infrastructure created as needed to a system can connect securely over otherwise non-secure networks. Once a VPN is established, then it's just like the remote system is inside the datacenter. Nothing special there, except that since it is part of the spec it indicates to me that someone is looking to backup/access/modify the database from multiple locations?
I see two items that need to be resolved - Getting the database out of Lotus Approach and into mysql. Seems like there is some good information out there - http://forums.devshed.com/mysql-help-4/import-lotus-approach-mysql-169506.html - has a couple of gotchas people have run into before. But it seems do-able without too much hassle. - Providing remote access to and sync of the database. Do you really need a VPN connection to sync the database? What about a mysql instance hosted somewhere a la AWS? Or, I agree with Howard, it's also worth exploring a CRM in this scenario - there are companies that provide this service, or you can host them in house with a web interface that can be accessed remotely. The downside to continuing to host everything yourself is that you may be spending more time and resources hosting the database (and providing access to the instance in a secure fashion) when compared to letting someone/somewhere else do the hard work. It sounds like there are a couple of goals in play, and while the goal of moving off Approach is well-defined, the remote access goal needs more clarification for a good answer. Please write back with additional info and we'll dig in further! On Sun, Sep 13, 2015 at 4:47 PM, Howard White <[email protected]> wrote: > Michael, > > I don't mean to be rude but I would think that the mailing label function > you describe would be available as a turnkey package. That application has > been solved many years and times over. Or let me spin this another way - > do you need to expand functionality to use a tool like a Customer Resource > Management (CRM) package? There are several open source CRM tools > (SugarCRM for instance) that might do multiple jobs for your organization. > > At first blush, your request sounds like re-inventing the wheel. > > Howard > > On 09/13/2015 04:04 AM, Michael L wrote: > >> The database app runs a mailing list for DVD's. And I will say that our >> current (soon to be former?) security strategy is to leave the single >> machine completely off the internet. I guess that strategy will have to >> be abandoned now to connect to a VPN? I understand the 'V' in VPN to >> mean virtually private as opposed to actually private or virustually >> private if you have a virus on one of the machines. Am I correct on that? >> M >> >> -- >> -- >> You received this message because you are subscribed to the Google >> Groups "NLUG" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/nlug-talk?hl=en >> >> --- >> You received this message because you are subscribed to the Google >> Groups "NLUG" group. >> To unsubscribe from this group and stop receiving emails from it, send >> an email to [email protected] >> <mailto:[email protected]>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > -- > You received this message because you are subscribed to the Google Groups > "NLUG" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/nlug-talk?hl=en > > --- You received this message because you are subscribed to the Google > Groups "NLUG" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- http://www.wesleyduffeebraun.com <http://www.ashevillephotobooth.com> -- -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en --- You received this message because you are subscribed to the Google Groups "NLUG" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
