Re: [RDD] Cart groups syncing between standalone Riv machines

2019-08-19 Thread Rob Landry
Yup. That's what I do. Rob -- Я там, где ребята толковые, Я там, где плакаты "Вперёд", Где песни рабочие новые Страна трудовая поёт. On Mon, 19 Aug 2019, Fred Gleason wrote: On Mon, 2019-08-19 at 08:36 -0400, Rob Landry wrote: What I need to do is make a field-by-field comparison of the lo

Re: [RDD] Cart groups syncing between standalone Riv machines

2019-08-19 Thread Fred Gleason
On Mon, 2019-08-19 at 08:36 -0400, Rob Landry wrote: > What I need to do is make a field-by-field comparison of the log in > the local database with the one in the remote database, and be able > to tell that any differences are due to someone updating the local > database. I looked at the WebAPI bu

Re: [RDD] Cart groups syncing between standalone Riv machines

2019-08-19 Thread Gabriele Fergola
Rob, probably is not a solution u can put in place for many reasons but if you have a good connection between the 2 site and private (never do it on public IP or network) u can think to use a MySQL master-master replica so every change u made on one side is automatically replicated on the other. If

Re: [RDD] Cart groups syncing between standalone Riv machines

2019-08-19 Thread Rob Landry
On Sun, 18 Aug 2019, Fred Gleason wrote: That will likely need significant rework as the DB schema for handling log rows is completely different in v3.x _vis a vis_ v2.x. Long term, your best bet will be to use the WebAPI and eschew direct database access entirely. The WebAPI is publicly documen

Re: [RDD] Cart groups syncing between standalone Riv machines

2019-08-18 Thread Fred Gleason
On Aug 16, 2019, at 15:13, Rob Landry <41001...@interpring.com> wrote: > I also have a script that can synchronize the LOGS and [day of week]_LOG > tables between a master Rivendell system and a remote one (typically > maintained as a backup at a transmitter site). All of these scripts were >

Re: [RDD] Cart groups syncing between standalone Riv machines

2019-08-16 Thread Rob Landry
I've been doing something like that for World Classical Network since 2007. At one point there were as many as 14 stations (currently just 4) running the same music but different local content. Each station has a Rivendell box with a copy of the music library; the voice tracks are rsync'd thr

Re: [RDD] Cart groups syncing between standalone Riv machines

2019-08-16 Thread Steve Rubin
13, 2019 at 10:56 PM To: User discussion about the Rivendell Radio Automation System Subject: [RDD] Cart groups syncing between standalone Riv machines   I'm about to pitch Rivendell to a client who is facing an automation dilemma as his current systems are running Win 7 that is falling o

[RDD] Cart groups syncing between standalone Riv machines

2019-08-13 Thread BNSF 6421
I'm about to pitch Rivendell to a client who is facing an automation dilemma as his current systems are running Win 7 that is falling out of support in a few months. He is currently running Storq using the network Voice tracks and spots which they are migrating the music, network spots and voice t