Re: [RDD] rivendell_filter

2018-08-13 Thread Robert Jeffares
Thanks Jonathan, I looked at those, and could not figure out how to not 
convert files from wav to FLAC.


But if I have to roll my own all the code I need is in there.

I am exploring a selective dump CART CUTS and associated tables in 
REPLACE mode.


This database is about 10 years old and has a few klingons!

R


On 14/08/18 16:25, Jonathan Cohen wrote:

Not related to Rivendell_filter and I'm not sure it would cope with 6 
tracks, but I wrote some crude PHP scripts that export and import carts in bulk 
between 2.19.2 systems, keeping all the segue and other data and also allowing 
export and import between systems with different sample rates. They did take 
about 12 hours to do around 5000 tracks though and are far from polished.

http://radiotools.uk/download/rivendell-export-import-101.zip

Jonathan

-Original Message-
From: rivendell-dev-boun...@lists.rivendellaudio.org 
[mailto:rivendell-dev-boun...@lists.rivendellaudio.org] On Behalf Of Robert 
Jeffares
Sent: 14 August 2018 01:43
To: rivendell-dev@lists.rivendellaudio.org
Subject: [RDD] rivendell_filter

I have discovered that replicating systems from a master which has been used 
for a number of different stations carries a lot of additional mysql data which 
is not all deleted when clocks or dropboxes are deleted in the QT3 interface.
There are some tables that look like they are no longer used in the current 
schema but remain to bloat the system which is now running very slow.
eg DROPBOX_PATHS had data in it from 2011 which possibly should have been 
deleted when I deleted them in the GUI.


Looking through the mailing list rivendell_filter will enable me to copy the 
60,000 audio tracks onto a new pristine system bringing just CART CUTS and 
associated schedule codes, perms etc.


Lots of links that go nowhere and a line on the wiki saying the file should be 
in docs which it's not.

Anyone got a copy of rivendell_filter somewhere please?

regards
Robert Jeffares

___
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] rivendell_filter

2018-08-13 Thread Jonathan Cohen
Not related to Rivendell_filter and I'm not sure it would cope with 6 
tracks, but I wrote some crude PHP scripts that export and import carts in bulk 
between 2.19.2 systems, keeping all the segue and other data and also allowing 
export and import between systems with different sample rates. They did take 
about 12 hours to do around 5000 tracks though and are far from polished.

http://radiotools.uk/download/rivendell-export-import-101.zip

Jonathan

-Original Message-
From: rivendell-dev-boun...@lists.rivendellaudio.org 
[mailto:rivendell-dev-boun...@lists.rivendellaudio.org] On Behalf Of Robert 
Jeffares
Sent: 14 August 2018 01:43
To: rivendell-dev@lists.rivendellaudio.org
Subject: [RDD] rivendell_filter

I have discovered that replicating systems from a master which has been used 
for a number of different stations carries a lot of additional mysql data which 
is not all deleted when clocks or dropboxes are deleted in the QT3 interface.
There are some tables that look like they are no longer used in the current 
schema but remain to bloat the system which is now running very slow.
eg DROPBOX_PATHS had data in it from 2011 which possibly should have been 
deleted when I deleted them in the GUI.


Looking through the mailing list rivendell_filter will enable me to copy the 
60,000 audio tracks onto a new pristine system bringing just CART CUTS and 
associated schedule codes, perms etc.


Lots of links that go nowhere and a line on the wiki saying the file should be 
in docs which it's not.

Anyone got a copy of rivendell_filter somewhere please?

regards
Robert Jeffares

___
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] rdairplay dies, out of memory

2018-08-13 Thread Rob Landry


Usually the biggest memory user is caed with between 8% and 16%.

I have 1 GM of memory and 2 GB of swap in this machine.


Rob

--
Я там, где ребята толковые,
Я там, где плакаты "Вперёд",
Где песни рабочие новые
Страна трудовая поёт.

On Mon, 13 Aug 2018, riv...@braingia.org wrote:


Hello,

You might try this next time to see what is taking up memory:

top -o %MEM

Also, is there swap available on the machine?

Steve

On Mon, Aug 13, 2018 at 04:27:38PM -0400, Rob Landry wrote:


A station emailed me just now to report that rdairplay died in the middle of
a piece of music.

/var/log/messages shows that the OS ran out of memory and killed rdairplay.

This is RD 2.16 running under CentOS 6 on older hardware with 1 GB RAM. The
machine doesn't do anything but run Rivendell with no manual intervention.
It's been running for at least a year with no problems.

What would cause the OS to run out of memory, I wonder? The machine has an
AudioScience ASI5111 card that was almost certainly bought in 2007; I've
seen these cards go bad after this many years, but differently than this;
they've stopped producing audio and/or ceased to be recognized by Rivendell.
This card still works; the client restarted rdairplay and it's running fine
now.

Any thoughts from the list?


Rob

--
? ???, ??? ?? ,
? ???, ??? ??? "??",
??? ? ??? ?
??  .



___
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] rdairplay dies, out of memory

2018-08-13 Thread Rob Landry

On Mon, 13 Aug 2018, David Henderson wrote:


Just wondering if the machine gets rebooted regularly or if it is left
running indefinitely. I usually try and reboot once a week.


I rarely reboot Rivendell systems. I had one at WCRI that ran for more 
than four years without a reboot; it was only the need to replace the 
batteries in the UPS that made a reboot necessary.



Rob

--
Я там, где ребята толковые,
Я там, где плакаты "Вперёд",
Где песни рабочие новые
Страна трудовая поёт.___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev


Re: [RDD] rdairplay dies, out of memory

2018-08-13 Thread Jonathan Cohen
Once a week! I doubt if we reboot more than once a year on average and even 
then only for other reasons such as power cuts etc.  J

 
Running out of memory does not sound normal, no matter how long the machine has 
been up, unless it’s something else running on the same machine?

 
Jonathan

 
From: rivendell-dev-boun...@lists.rivendellaudio.org 
[mailto:rivendell-dev-boun...@lists.rivendellaudio.org] On Behalf Of David 
Henderson
Sent: 13 August 2018 21:41
To: rivendell-dev@lists.rivendellaudio.org
Subject: Re: [RDD] rdairplay dies, out of memory

 
Just wondering if the machine gets rebooted regularly or if it is left running 
indefinitely. I usually try and reboot once a week.

Sent from my Huawei Mobile 



 Original Message 
Subject: [RDD] rdairplay dies, out of memory
From: Rob Landry <41001...@interpring.com  >
To: rivendell-dev@lists.rivendellaudio.org 
 
CC: 




A station emailed me just now to report that rdairplay died in the middle 
of a piece of music.

/var/log/messages shows that the OS ran out of memory and killed 
rdairplay.

This is RD 2.16 running under CentOS 6 on older hardware with 1 GB RAM. 
The machine doesn't do anything but run Rivendell with no manual 
intervention. It's been running for at least a year with no problems.

What would cause the OS to run out of memory, I wonder? The machine has an 
AudioScience ASI5111 card that was almost certainly bought in 2007; I've 
seen these cards go bad after this many years, but differently than this; 
they've stopped producing audio and/or ceased to be recognized by 
Rivendell. This card still works; the client restarted rdairplay and it's 
running fine now.

Any thoughts from the list?


Rob

-- 
Я там, где ребята толковые,
Я там, где плакаты "Вперёд",
Где песни рабочие новые
Страна трудовая поёт.

___
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] rdairplay dies, out of memory

2018-08-13 Thread rivdev
Hello,

You might try this next time to see what is taking up memory:

top -o %MEM

Also, is there swap available on the machine? 

Steve

On Mon, Aug 13, 2018 at 04:27:38PM -0400, Rob Landry wrote:
> 
> A station emailed me just now to report that rdairplay died in the middle of
> a piece of music.
> 
> /var/log/messages shows that the OS ran out of memory and killed rdairplay.
> 
> This is RD 2.16 running under CentOS 6 on older hardware with 1 GB RAM. The
> machine doesn't do anything but run Rivendell with no manual intervention.
> It's been running for at least a year with no problems.
> 
> What would cause the OS to run out of memory, I wonder? The machine has an
> AudioScience ASI5111 card that was almost certainly bought in 2007; I've
> seen these cards go bad after this many years, but differently than this;
> they've stopped producing audio and/or ceased to be recognized by Rivendell.
> This card still works; the client restarted rdairplay and it's running fine
> now.
> 
> Any thoughts from the list?
> 
> 
> Rob
> 
> -- 
> ? ???, ??? ?? ,
> ? ???, ??? ??? "??",
> ??? ? ??? ?
> ??  .

> ___
> 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] rdairplay dies, out of memory

2018-08-13 Thread David Henderson
Just wondering if the machine gets rebooted regularly or if it is left running 
indefinitely. I usually try and reboot once a week.

Sent from my Huawei Mobile


 Original Message 
Subject: [RDD] rdairplay dies, out of memory
From: Rob Landry <41001...@interpring.com>
To: rivendell-dev@lists.rivendellaudio.org
CC:



A station emailed me just now to report that rdairplay died in the middle
of a piece of music.

/var/log/messages shows that the OS ran out of memory and killed
rdairplay.

This is RD 2.16 running under CentOS 6 on older hardware with 1 GB RAM.
The machine doesn't do anything but run Rivendell with no manual
intervention. It's been running for at least a year with no problems.

What would cause the OS to run out of memory, I wonder? The machine has an
AudioScience ASI5111 card that was almost certainly bought in 2007; I've
seen these cards go bad after this many years, but differently than this;
they've stopped producing audio and/or ceased to be recognized by
Rivendell. This card still works; the client restarted rdairplay and it's
running fine now.

Any thoughts from the list?


Rob

--
Я там, где ребята толковые,
Я там, где плакаты "Вперёд",
Где песни рабочие новые
Страна трудовая поёт.

___
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] rdairplay dies, out of memory

2018-08-13 Thread Rob Landry


A station emailed me just now to report that rdairplay died in the middle 
of a piece of music.


/var/log/messages shows that the OS ran out of memory and killed 
rdairplay.


This is RD 2.16 running under CentOS 6 on older hardware with 1 GB RAM. 
The machine doesn't do anything but run Rivendell with no manual 
intervention. It's been running for at least a year with no problems.


What would cause the OS to run out of memory, I wonder? The machine has an 
AudioScience ASI5111 card that was almost certainly bought in 2007; I've 
seen these cards go bad after this many years, but differently than this; 
they've stopped producing audio and/or ceased to be recognized by 
Rivendell. This card still works; the client restarted rdairplay and it's 
running fine now.


Any thoughts from the list?


Rob

--
Я там, где ребята толковые,
Я там, где плакаты "Вперёд",
Где песни рабочие новые
Страна трудовая поёт.___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev


Re: [RDD] 3 hours off

2018-08-13 Thread Cowboy
On Mon, 13 Aug 2018 15:58:27 +
Mark Murdock  wrote:

> Any ideas?

 You're displaying Eastern time instead of Pacific time.
 Check your time zone settings.

-- 
Cowboy

The aim of a joke is not to degrade the human being but to remind him that
he is already degraded.
-- George Orwell
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev


Re: [RDD] 3 hours off

2018-08-13 Thread John Anderson
https://www.cyberciti.biz/faq/centos-linux-6-7-changing-timezone-command-line/

or there are time settings under rivendell, follow the clock and set the
correct time zone...

On Mon, 2018-08-13 at 15:58 +, Mark Murdock wrote:
> Rivendell is displaying a time 3 hours ahead of the computer system
> clock, and I can’t find a way to fix this. Rebooting does not help.
> Any ideas?
> 
>  
> 
> Mark Murdock
> 
> Production Director
> 
> KAMB 
> 
> 90 E. 16th St.
> 
> Merced, CA 95340
> 
> (209) 723-1015
> 
> www.celebrationradio.com
> 
> m...@celebrationradio.com
> 
>  
> 
> 
> ___
> 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] 3 hours off

2018-08-13 Thread rivdev
Hi Mark,

That seems odd.  What's the output from the "date" command?  Open a 
terminal window and type:

date

Also, is it possible that the firmware/bios time is different?

Steve


On Mon, Aug 13, 2018 at 03:58:27PM +, Mark Murdock wrote:
> Rivendell is displaying a time 3 hours ahead of the computer system clock, 
> and I can't find a way to fix this. Rebooting does not help. Any ideas?
> 
> Mark Murdock
> Production Director
> KAMB
> 90 E. 16th St.
> Merced, CA 95340
> (209) 723-1015
> www.celebrationradio.com
> m...@celebrationradio.com
> 

> ___
> 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] 3 hours off

2018-08-13 Thread Mark Murdock
Rivendell is displaying a time 3 hours ahead of the computer system clock, and 
I can't find a way to fix this. Rebooting does not help. Any ideas?

Mark Murdock
Production Director
KAMB
90 E. 16th St.
Merced, CA 95340
(209) 723-1015
www.celebrationradio.com
m...@celebrationradio.com

___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev