On Saturday 03 February 2018 12:07:20 pm Rich Lawrence wrote: > Hello all. > I have a partner helping with my streaming station and I would like him to be > able to access the main database, which is housed at my location, from a > remote machine at his location. > This is mostly going to be used for adding new music, promos, etc. Voice > tracking is something g later down the line, but the priority is the former. > I’m running 2.10.3 on Ubuntu 12, and would like some suggestions on the best > way to accomplish what I am looking to do.
"Access the main database" could be taken a few ways. Literally... I would first offer an EXTREME CAUTION doing this !! The likelihood of completely trashing your database, resulting in the loss of EVERYTHING is not trivial ! Fred and I have discussed this many times. The problem is two people accessing the same thing at the same time. Which is the "valid" data ? The first one to commit, or the last one to commit, neither being aware of the other, thus commiting conflicting data. OK, got that ? You have been warned ! Figuratively, meaning able to work with the system, and not directly access the database. You could add his remote host, assuming he has a public IP on that machine, the same as any other. I'd strongly recommend against, as it involves a good deal of risky exposure at both ends, but you're not exposing your database directly on the open internet. Across a VPN this should work easily. Setting up a VPN on an unfamiliar OS ( Ubuntu ) is beyond me, but once done his remote machine is "local" as far as the system is concerned, albeit slower. Probably, you'd actually be creating the VPN firewall to firewall so that the Rivendell machines don't even need be aware it's not physically local. You could give him remote access to a local workstation via ssh -X Safer, but not without pitfalls, as music and such would have to be first transfered onto that machine, then imported "locally" at your location though he'd be the one actually doing it via remote access. That's probably the way I'd approach it, based on familiarity though the idea of a VPN approach is probably the better way. -- Cowboy http://cowboy.cwf1.com This Fortue Examined By INSPECTOR NO. 2-14 _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
