Re: [RDD] Database Access Question(s)

[Geoff Barkman]

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  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  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

Re: [RDD] Database Access Question(s)

[Alan Smith]

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 > 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

Re: [RDD] Database Access Question(s)

[Geoff Barkman]

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  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

Re: [RDD] Database Access Question(s)

[Mike Carroll]

I've never run into the backup problem, but here's a couple of things you
might try to figure out why: check /var/log/messages for anything
"interesting" around the time of one of the failures; run RDAdmin from a
command line then do a backup so any messages it issues appear at the
terminal.  There's also the MySQL log at /var/log/mysqld.log, but it's
unlikely you'll see anything there.

Mike C

On Fri, Nov 25, 2016 at 6:20 AM Alan Smith  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

[RDD] Database Access Question(s)

[Alan Smith]

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