Hi Alan (Thought I'd sent this email a few days back... but I discovered it in my drafts)
Yes you can have multiple computers accessing the rivendell database at the same time BUT there are a few restrictions. If you were editing logs on your machine and someone else edited the same log on another machine... last person to click save would overide the changes of another. this could happen if you were voice tracking and another were just adding programs as well. log generation should only be done on one machine at a time. rdairplay is ok to run on multiple machines... if you add new hotkeys on the user panels... it will appear on the other machine within a few seconds. rd library is ok as long as you don't do stuff on the same cart etc. I don't think there is a conclusive list of do's and don't's... sometimes its trial an error finding out things on a test machine. On Tue, Nov 29, 2016 at 11:51 AM, Alan Smith <alansm...@flinn.com> wrote: > Geoff, > > Thanks for the links to your script. Also, the rddbcheck did the > trick. Fixed it right up, and I can now do backups from within RDAdmin > again. > > The database wasn't very large to begin with, but is several years old. > > Questions still remain though: > > Is is safe to have multiple simultaneous db accesses happening at once? > Is it even allowed? Again, this is for clock generation/modifications at > the same time as traffic log generation/editing from remote Windows > workstations. > > Thanks! > > -Alan > > On 11/25/2016 1:01 PM, Geoff Barkman wrote: > > Hi Alan > How old is the Database? I ran into problems when my system had been > running 2 or 3 years. I have a cronjob set up to automaticly back up the > database every week at the same time and append the current date / time to > the filename so a sequential backup is kept. > I think I fixed it by running rddbcheck from a commandline. It fixed up > the database and let me make database back ups in the normal way using > rdadmin. > Running rddbcheck shrunk the db backup sql file from 45 mb down to about > 10 mb. > > Here is my script and a link to my blog that hosts it. > > http://geofffromdunedin.blogspot.co.nz/2010/12/automatically-backup- > rivendell-database.html > > NOTE If sharing created files with windows users Colons eg : cannot be in > filenames > #I suggest doing the date variable creation like this. > currentdate=`date +%F-%H.%M.%S` > Instead of like this currentdate=`date +%F-%X` > > > Note > I found that sometimes the Rivendell macros crash rdairplay so I now run > from a command line the following script..... > > > #!/bin/bash > > currentdate=`date +%F-%X` > > echo $currentdate > > mysqldump -u rduser -pletmein --lock-tables=false Rivendell > > /home/geoff/rivendell-backup/RD-$currentdate.sql > > > > You can set up this macro to run daily weekly or whenever. > > > I hope this helps you automate the process. > Many thanks > Geoff Barkman > > > > On Sat, Nov 26, 2016 at 3:19 AM, Alan Smith <alansm...@flinn.com> wrote: > >> Been a while since I've posted to the group. >> >> I currently still only have a single RD system running out on the other >> side of the country, so I don't get a chance to "fiddle" with it much. >> >> I decided I had better do a database backup since its been a long while, >> and using rdadmin when I tried was greeted with "Unable to create >> backup!". On some google searching, seems this is a common long-running >> issue. I did find a command that allowed me to back it up via the command >> line. >> >> The reason for my post is I am wanted to install RD for a single AM >> station that I do some side work for. My plan is going to make heavy use >> of running RDLogEdit/RDLogManager from a couple Windows machines. So my >> questions: >> >> 1) Does this "bug" that crops up that won't allow DB backups from within >> RD also affect the ability to remotely access the DB from RD modules >> running on Win platforms? >> >> 2) Can you have simultaneous access to the DB from multiple Win >> platforms? I imagine the PD will want to create clocks and such while >> Traffic will be working on logs. >> >> Thanks! >> >> -Alan >> >> PS This is on the latest appliance via the Parvel website. Also, >> database backup in rdadmin used to work fine. It just "broke" one day, and >> since its been a while I'm not sure when or why. >> >> _______________________________________________ >> Rivendell-dev mailing list >> Rivendell-dev@lists.rivendellaudio.org >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >> > > > > _______________________________________________ > Rivendell-dev mailing list > Rivendell-dev@lists.rivendellaudio.org > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > >
_______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
